Etiket: c#

Algoritmalar ve Programlama – 1 (Güz-2017) Hafta – 11

7 Aralık 2017 tarihinde gönderilmiş caglar tarafından

#include <iostream>

using namespace std;
int main()
{
    int elemansayisi;
    cout<<"Eleman Sayısını Giriniz:";
    cin>>elemansayisi;
    int sayilar[elemansayisi];
    for(int i=0;i<elemansayisi;i++)
    {
        cout<<(i+1)<<". Eleman:";
        cin>>sayilar[i];
    }
    int toplam=0;
    for(int i=0;i<elemansayisi;i++){
     cout<<(i+1)<<". Eleman:"<<sayilar[i]<<endl;
     toplam+=sayilar[i];
    }

    cout<<"Toplam:"<<toplam;
    return 0;
}

#include <iostream>

using namespace std;

int main()

{

int elemansayisi;

cout<<"Eleman Sayısını Giriniz:";

cin>>elemansayisi;

int sayilar[elemansayisi];

for(int i=0;i<elemansayisi;i++)

{

cout<<(i+1)<<". Eleman:";

cin>>sayilar[i];

}

int toplam=0;

for(int i=0;i<elemansayisi;i++){

cout<<(i+1)<<". Eleman:"<<sayilar[i]<<endl;

toplam+=sayilar[i];

}

cout<<"Toplam:"<<toplam;

return 0;

}

Okumaya devam et

Algoritmalar ve Programlama – 1 (Güz-2017) Hafta – 5

30 Ekim 201730 Ekim 2017 tarihinde gönderilmiş caglar tarafından

#include <iostream>

using namespace std;

int main()
{

    double tuketim;
    cout<<"Miktari girin:";
    cin>>tuketim;

    double kw_tl= 0.21569612*tuketim;
    double dagitim_tl=0.11613051*tuketim;
    double toplam = (kw_tl+dagitim_tl)*1.18;

    cout<<"TL: "<<toplam<<endl;

    return 0;
}

#include <iostream>

using namespace std;

int main()

{

double tuketim;

cout<<"Miktari girin:";

cin>>tuketim;

double kw_tl= 0.21569612*tuketim;

double dagitim_tl=0.11613051*tuketim;

double toplam = (kw_tl+dagitim_tl)*1.18;

cout<<"TL: "<<toplam<<endl;

return 0;

}

Okumaya devam et

Algoritmalar ve Programlama – 1 (Güz-2017) Hafta – 6

30 Ekim 20179 Kasım 2017 tarihinde gönderilmiş caglar tarafından

#include <iostream>
using namespace std;

int main()
{
    int dogru=0, yanlis=0;
    string secim;

    cout<<"1) 2 MB = ? KB"<<endl;
    cout<<"a) 10 b) 200 c) 2048 d) 4096"<<endl;
    cin>>secim;
    if(secim=="c")
        dogru=dogru+1;
    else
        yanlis=yanlis+1;

    cout<<"2) Asagidakilerden hangisi giris birimidir?"<<endl;
    cout<<"a) Monitor b) Klavye c) Kasa d) Yazici"<<endl;
    cin>>secim;
    if(secim=="b")
        dogru++;
    else
        yanlis++;

    cout<<"3) Asagidakilerden hangisi bir lojik kapı degildir?"<<endl;
    cout<<"a) AND b) OR c) XOR d) COR"<<endl;
    cin>>secim;
    if(secim=="d")
        dogru++;
    else
        yanlis++;

    cout<<"4) Asagidakilerden hangisi derlenen bir dildir?"<<endl;
    cout<<"a) C++ b) PHP c) PERL d) ASP"<<endl;
    cin>>secim;
    if(secim=="a")
        dogru++;
    else
        yanlis++;

    cout<<"5) C++ dilinde hangisi ekrana metin yazdirir?"<<endl;
    cout<<"a) cin b) int c) cout  d) if "<<endl;
    cin>>secim;
    if(secim=="c")
        dogru++;
    else
        yanlis++;

    cout<< "Toplam Dogru: "<<dogru<<" Toplam Yanlis: "<<yanlis<<endl;

    return 0;
}

#include <iostream>

using namespace std;

int main()

{

int dogru=0, yanlis=0;

string secim;

cout<<"1) 2 MB = ? KB"<<endl;

cout<<"a) 10 b) 200 c) 2048 d) 4096"<<endl;

cin>>secim;

if(secim=="c")

dogru=dogru+1;

else

yanlis=yanlis+1;

cout<<"2) Asagidakilerden hangisi giris birimidir?"<<endl;

cout<<"a) Monitor b) Klavye c) Kasa d) Yazici"<<endl;

cin>>secim;

if(secim=="b")

dogru++;

else

yanlis++;

cout<<"3) Asagidakilerden hangisi bir lojik kapı degildir?"<<endl;

cout<<"a) AND b) OR c) XOR d) COR"<<endl;

cin>>secim;

if(secim=="d")

dogru++;

else

yanlis++;

cout<<"4) Asagidakilerden hangisi derlenen bir dildir?"<<endl;

cout<<"a) C++ b) PHP c) PERL d) ASP"<<endl;

cin>>secim;

if(secim=="a")

dogru++;

else

yanlis++;

cout<<"5) C++ dilinde hangisi ekrana metin yazdirir?"<<endl;

cout<<"a) cin b) int c) cout d) if "<<endl;

cin>>secim;

if(secim=="c")

dogru++;

else

yanlis++;

cout<< "Toplam Dogru: "<<dogru<<" Toplam Yanlis: "<<yanlis<<endl;

return 0;

}

Okumaya devam et

İşletim Sistemleri (Bahar-2016) Hafta-14/2

17 Mayıs 201717 Mayıs 2017 tarihinde gönderilmiş caglar tarafından

Uygulamada önce proc1.cpp çalıştırılmalıdır. Root seviyesinde çalıştırmayı unutmayınız!

#include<iostream>
#include<unistd.h>
#include<sys/sem.h>
#include<sys/ipc.h>
#include<stdlib.h>
#include<cstdio>


using namespace std;

int main()
{
	union semun{
		int val;
		//struct semid_ds *buf;
		//unsigned short int *array;
		//struct seminfo *inf;
	};
	
	int sem_id, cikis;
	struct sembuf islemler[1];
	union semun ozellik;
	
	ozellik.val=0; // p durumu baslangic degeri
	
	sem_id = semget(101,1,IPC_CREAT | IPC_EXCL);
	cout<<"Sem ID:"<<sem_id<<endl;
	
	if(sem_id==-1)
	{
		cout<<"semget error"<<endl;
		perror("semget");
		exit(0);
	}
	
	semctl(sem_id,1,SETVAL,ozellik);
	
	islemler[0].sem_num=0;
	islemler[0].sem_op=-1; // p islemine girildikten sonraki degiskenin degerinin degistirilmesi
	islemler[0].sem_flg=SEM_UNDO;
	
	cout<<"P durumu!"<<endl;
	cikis = semop(sem_id,islemler,1);
	if(cikis>-1){
		cout<<"v izin gonderdi KB deyiz"<<endl;
		// semafor u yok etmek icin kod yazilacak
		semctl(sem_id,1,IPC_RMID,ozellik);
	}
	else
	{
		cout<<"hata olustu!"<<endl;
		perror("semop");
	}

}

#include<iostream>

#include<unistd.h>

#include<sys/sem.h>

#include<sys/ipc.h>

#include<stdlib.h>

#include<cstdio>

using namespace std;

int main()

{

union semun{

int val;

//struct semid_ds *buf;

//unsigned short int *array;

//struct seminfo *inf;

};

int sem_id, cikis;

struct sembuf islemler[1];

union semun ozellik;

ozellik.val=0; // p durumu baslangic degeri

sem_id = semget(101,1,IPC_CREAT | IPC_EXCL);

cout<<"Sem ID:"<<sem_id<<endl;

if(sem_id==-1)

{

cout<<"semget error"<<endl;

perror("semget");

exit(0);

}

semctl(sem_id,1,SETVAL,ozellik);

islemler[0].sem_num=0;

islemler[0].sem_op=-1; // p islemine girildikten sonraki degiskenin degerinin degistirilmesi

islemler[0].sem_flg=SEM_UNDO;

cout<<"P durumu!"<<endl;

cikis = semop(sem_id,islemler,1);

if(cikis>-1){

cout<<"v izin gonderdi KB deyiz"<<endl;

// semafor u yok etmek icin kod yazilacak

semctl(sem_id,1,IPC_RMID,ozellik);

}

else

{

cout<<"hata olustu!"<<endl;

perror("semop");

}

proc1.cpp P() işlemi yaparken (bekleme durumu) aşağıdaki kod root seviyesinde çalıştırıldığında

Okumaya devam et

İşletim Sistemleri (Bahar-2016) Hafta-14/1

17 Mayıs 2017 tarihinde gönderilmiş caglar tarafından

#include<iostream>
#include<unistd.h>

using namespace std;

int main()
{
	pid_t pid;
	int fd[2];
	char bilgi[12];
	
	pipe(fd);
	
	pid =fork();
	
	if(pid==0)
	{
		// cocuk
		cout<<"cocuk aktif ve bilgi gonderiyor"<<endl;
		write(fd[1],"merhaba anne",12);
		close(fd[1]);
	}
	else
	{
		// anne
		cout<<"anne bilgiyi bekliyor"<<endl;
		read(fd[0],bilgi,12);
		close(fd[0]);
		cout<<"Anne bilgiyi aldi:"<<bilgi<<endl;	
	}
	

}

#include<iostream>

#include<unistd.h>

using namespace std;

int main()

{

pid_t pid;

int fd[2];

char bilgi[12];

pipe(fd);

pid =fork();

if(pid==0)

{

// cocuk

cout<<"cocuk aktif ve bilgi gonderiyor"<<endl;

write(fd[1],"merhaba anne",12);

close(fd[1]);

}

else

{

// anne

cout<<"anne bilgiyi bekliyor"<<endl;

read(fd[0],bilgi,12);

close(fd[0]);

cout<<"Anne bilgiyi aldi:"<<bilgi<<endl;

}

Okumaya devam et

İşletim Sistemleri (Bahar-2016) Hafta-13

17 Mayıs 2017 tarihinde gönderilmiş caglar tarafından

#include<iostream>
#include<pthread.h>
#include<unistd.h>

using namespace std;

void* asal(void* arg)
{
	int* sayi = (int*) arg;
	int say = *sayi;

	int sayac=0;
	
	for(int i=2;i<=(say/2);i++)
	{
		if(say%i==0)
		{
			sayac++;
			break;
		}
	
	}	
	
	if(sayac==0)
		cout<<say<<" sayisi asaldir"<<endl;
	sleep(1);	
}

void* fib(void* arg)
{

int* sayi = (int*) arg;
int say = *sayi;

int sayi1=0;
int sayi2=1;
int sayi3=0;

	while(sayi3<say)
	{
		sayi3=sayi1+sayi2;
		sayi1=sayi2;
		sayi2=sayi3;
		
		if(sayi3==say)
		{
			cout<<say<<" fib. sayisidir!"<<endl;
		}
	}
	sleep(1);
}




int main()
{
	int sayilar[]={5, 20, 11, 71, 91, 101, 13};
	
	int boyut=sizeof(sayilar)/sizeof(int);
	
	pthread_t calisan1[boyut],calisan2[boyut];
	
	cout<<"basladi"<<endl;
	
	int k =10;
	
	for(int i =0;i<boyut;i++)
	{	
		pthread_create(&calisan1[i],NULL,asal, &sayilar[i]); // olustu ve basladi
		pthread_create(&calisan2[i],NULL,fib, &sayilar[i]); // olustu ve basladi
	}
	
	for(int i=0;i<boyut;i++)
	{
		pthread_join(calisan1[i],NULL); // ilgili thread bitisini bekle
		pthread_join(calisan2[i],NULL); // ilgili thread bitisini bekle
	}
	cout<<"bitti"<<endl;
	sleep(3);	
}

#include<iostream>

#include<pthread.h>

#include<unistd.h>

using namespace std;

void* asal(void* arg)

{

int* sayi = (int*) arg;

int say = *sayi;

int sayac=0;

for(int i=2;i<=(say/2);i++)

{

if(say%i==0)

{

sayac++;

break;

}

if(sayac==0)

cout<<say<<" sayisi asaldir"<<endl;

sleep(1);

}

void* fib(void* arg)

{

int* sayi = (int*) arg;

int say = *sayi;

int sayi1=0;

int sayi2=1;

int sayi3=0;

while(sayi3<say)

{

sayi3=sayi1+sayi2;

sayi1=sayi2;

sayi2=sayi3;

if(sayi3==say)

{

cout<<say<<" fib. sayisidir!"<<endl;

}

sleep(1);

}

int main()

{

int sayilar[]={5, 20, 11, 71, 91, 101, 13};

int boyut=sizeof(sayilar)/sizeof(int);

pthread_t calisan1[boyut],calisan2[boyut];

cout<<"basladi"<<endl;

int k =10;

for(int i =0;i<boyut;i++)

{

pthread_create(&calisan1[i],NULL,asal, &sayilar[i]); // olustu ve basladi

pthread_create(&calisan2[i],NULL,fib, &sayilar[i]); // olustu ve basladi

}

for(int i=0;i<boyut;i++)

{

pthread_join(calisan1[i],NULL); // ilgili thread bitisini bekle

pthread_join(calisan2[i],NULL); // ilgili thread bitisini bekle

}

cout<<"bitti"<<endl;

sleep(3);

}

Okumaya devam et

İşletim Sistemleri (Bahar-2016) Hafta-10/1

1 Mayıs 20171 Mayıs 2017 tarihinde gönderilmiş caglar tarafından

Sinyallerin yakalanması

#include<iostream>
#include<unistd.h>
#include<signal.h>

using namespace std;

int i=0;

void islem(int sinyal)
{
	i++;
	if(sinyal==SIGINT)
		cout<<i<<" :: CTRL+C sinyali"<<endl;
	if(sinyal==SIGTERM)
		cout<<i<<" :: TERM sinyali"<<endl;	
}


int main()
{
	cout<<"PROC:"<<getpid()<<endl;
	
	while(true)
	{
		signal(SIGINT,&islem);
		signal(SIGTERM,&islem);
	}

}

#include<iostream>

#include<unistd.h>

#include<signal.h>

using namespace std;

int i=0;

void islem(int sinyal)

{

i++;

if(sinyal==SIGINT)

cout<<i<<" :: CTRL+C sinyali"<<endl;

if(sinyal==SIGTERM)

cout<<i<<" :: TERM sinyali"<<endl;

}

int main()

{

cout<<"PROC:"<<getpid()<<endl;

while(true)

{

signal(SIGINT,&islem);

signal(SIGTERM,&islem);

}

Okumaya devam et

İşletim Sistemleri (Bahar-2016) Hafta-5/2

22 Mart 201722 Mart 2017 tarihinde gönderilmiş caglar tarafından

Thread ile asal sayılar:

#include<iostream>
#include<unistd.h>
#include<pthread.h>

using namespace std;

void * islem1(void *arg)
{
	cout<<"THREAD BASLADI!!::1"<<endl;

	for(int sayi=100;sayi<2000;sayi++)
	{
		int sayac=0;

		for(int i=2;i<(sayi/2);i++)
		{
			if(sayi%i==0)
			{
				sayac++;
				break;	
			}
		}
		
		if(sayac==0)
			cout<<"::1::"<<sayi<<" asaldir"<<endl;
	}

	pthread_exit(0);
}


void * islem2(void *arg)
{
	cout<<"THREAD BASLADI!!::2"<<endl;

	for(int sayi=3000;sayi<9000;sayi++)
	{
		int sayac=0;

		for(int i=2;i<(sayi/2);i++)
		{
			if(sayi%i==0)
			{
				sayac++;
				break;	
			}
		}
		
		if(sayac==0)
			cout<<"::2::"<<sayi<<" asaldir"<<endl;
	}

	pthread_exit(0);
}

int main()
{
	pthread_t iplik1,iplik2;
		
	cout<<"PROC ID:"<<getpid()<<endl;
	
	pthread_create(&iplik1,NULL,islem1,NULL);
	pthread_create(&iplik2,NULL,islem2,NULL);
	cout<<"THREAD BEKLE"<<endl;
	pthread_join(iplik1,NULL);
	pthread_join(iplik2,NULL);
	cout<<"ANA PROC SONLANDI"<<endl;
}

#include<iostream>

#include<unistd.h>

#include<pthread.h>

using namespace std;

void * islem1(void *arg)

{

cout<<"THREAD BASLADI!!::1"<<endl;

for(int sayi=100;sayi<2000;sayi++)

{

int sayac=0;

for(int i=2;i<(sayi/2);i++)

{

if(sayi%i==0)

{

sayac++;

break;

}

if(sayac==0)

cout<<"::1::"<<sayi<<" asaldir"<<endl;

}

pthread_exit(0);

}

void * islem2(void *arg)

{

cout<<"THREAD BASLADI!!::2"<<endl;

for(int sayi=3000;sayi<9000;sayi++)

{

int sayac=0;

for(int i=2;i<(sayi/2);i++)

{

if(sayi%i==0)

{

sayac++;

break;

}

if(sayac==0)

cout<<"::2::"<<sayi<<" asaldir"<<endl;

}

pthread_exit(0);

}

int main()

{

pthread_t iplik1,iplik2;

cout<<"PROC ID:"<<getpid()<<endl;

pthread_create(&iplik1,NULL,islem1,NULL);

pthread_create(&iplik2,NULL,islem2,NULL);

cout<<"THREAD BEKLE"<<endl;

pthread_join(iplik1,NULL);

pthread_join(iplik2,NULL);

cout<<"ANA PROC SONLANDI"<<endl;

}

Okumaya devam et

İşletim Sistemleri (Bahar-2016) Hafta-2

6 Mart 2017 tarihinde gönderilmiş caglar tarafından

#include <iostream>
#include <unistd.h>

using namespace std;
int main()
{
	int x;
	cout<<"pid:"<<getpid()<<endl;
	cout<<"Sayi Giriniz:";
	cin>>x;
	cout<<"Sayi:"<<x<<endl;
	return 0;	
}

#include <iostream>

#include <unistd.h>

using namespace std;

int main()

{

int x;

cout<<"pid:"<<getpid()<<endl;

cout<<"Sayi Giriniz:";

cin>>x;

cout<<"Sayi:"<<x<<endl;

return 0;

}

#include<iostream>
#include<unistd.h>

using namespace std;

int main()
{
	int x=0;
	cout<<"BASLA:"<<getpid()<<endl;
	fork();
	fork();
	fork();
	cout<<"PROC:"<<getpid()<<" SAYAC: "<<(++x)<<endl;
	
	return 0;
}

#include<iostream>

#include<unistd.h>

using namespace std;

int main()

{

int x=0;

cout<<"BASLA:"<<getpid()<<endl;

fork();

cout<<"PROC:"<<getpid()<<" SAYAC: "<<(++x)<<endl;

return 0;

}

Okumaya devam et

Görsel Programlama (Güz-2016) Hafta-3-2

15 Ekim 2016 tarihinde gönderilmiş caglar tarafından

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace ornek1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void bgoster_Click(object sender, EventArgs e)
        {
            /*string secilenler = "";
            if (csec1.Checked)
            {
                secilenler = csec1.Text;
            }

            if (csec2.Checked)
            {
                if (secilenler.Length > 0) secilenler += ";";
                secilenler += csec2.Text;
            }

            if (csec3.Checked)
            {
                if (secilenler.Length > 0) secilenler += ";";
                secilenler += csec3.Text;
            }

            if (secilenler.Length == 0)
                secilenler = "Seçili Bilgi Yok!";

            MessageBox.Show(secilenler);*/


            CheckBox[] chb = { csec1, csec2, csec3 };

            string secilenler="";
            for(int i=0;i<chb.Length;i++)
                if (chb[i].Checked){
                    if(secilenler.Length>0)
                        secilenler += ";";
                    secilenler += chb[i].Text;
                    }

            if (secilenler.Length == 0)
                secilenler = "Seçili Bilgi Yok!";

            MessageBox.Show(secilenler);



        }
    }
}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace ornek1

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void bgoster_Click(object sender, EventArgs e)

{

/*string secilenler = "";

if (csec1.Checked)

{

secilenler = csec1.Text;

}

if (csec2.Checked)

{

if (secilenler.Length > 0) secilenler += ";";

secilenler += csec2.Text;

}

if (csec3.Checked)

{

if (secilenler.Length > 0) secilenler += ";";

secilenler += csec3.Text;

}

if (secilenler.Length == 0)

secilenler = "Seçili Bilgi Yok!";

MessageBox.Show(secilenler);*/

CheckBox[] chb = { csec1, csec2, csec3 };

string secilenler="";

for(int i=0;i<chb.Length;i++)

if (chb[i].Checked){

if(secilenler.Length>0)

secilenler += ";";

secilenler += chb[i].Text;

}

if (secilenler.Length == 0)

secilenler = "Seçili Bilgi Yok!";

MessageBox.Show(secilenler);

}

GP (Güz-2016) Hafta-3/2

Okumaya devam et

Görsel Programlama (Güz-2016) Hafta-3-1

15 Ekim 201615 Ekim 2016 tarihinde gönderilmiş caglar tarafından

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace ornek1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void btopla_Click(object sender, EventArgs e)
        {
            string sayi1 = tsayi1.Text;
            string sayi2 = tsayi2.Text;

            //MessageBox.Show(sayi1 + sayi2);

            /*int s1 = Convert.ToInt32(sayi1);
            int s2 = Convert.ToInt32(sayi2);*/

            int s1, s2;

            bool k1 = Int32.TryParse(sayi1, out s1);
            bool k2 = Int32.TryParse(sayi2, out s2);

            if(k1 && k2)
                MessageBox.Show("Toplama Sonucu:" + (s1 + s2));
            else
                MessageBox.Show("Girilen bilgiler formata uygun değil!");
          
        }

        private void bcikar_Click(object sender, EventArgs e)
        {
            string sayi1 = tsayi1.Text;
            string sayi2 = tsayi2.Text;

            int s1, s2;

            bool k1 = Int32.TryParse(sayi1, out s1);
            bool k2 = Int32.TryParse(sayi2, out s2);

            if (k1 && k2)
                MessageBox.Show("Toplama Sonucu:" + (s1 - s2));
            else
                MessageBox.Show("Girilen bilgiler formata uygun değil!");
        }

        private void bkapat_Click(object sender, EventArgs e)
        {
            this.Close();
        }

    }
}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace ornek1

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void btopla_Click(object sender, EventArgs e)

{

string sayi1 = tsayi1.Text;

string sayi2 = tsayi2.Text;

//MessageBox.Show(sayi1 + sayi2);

/*int s1 = Convert.ToInt32(sayi1);

int s2 = Convert.ToInt32(sayi2);*/

int s1, s2;

bool k1 = Int32.TryParse(sayi1, out s1);

bool k2 = Int32.TryParse(sayi2, out s2);

if(k1 && k2)

MessageBox.Show("Toplama Sonucu:" + (s1 + s2));

else

MessageBox.Show("Girilen bilgiler formata uygun değil!");

}

private void bcikar_Click(object sender, EventArgs e)

{

string sayi1 = tsayi1.Text;

string sayi2 = tsayi2.Text;

int s1, s2;

bool k1 = Int32.TryParse(sayi1, out s1);

bool k2 = Int32.TryParse(sayi2, out s2);

if (k1 && k2)

MessageBox.Show("Toplama Sonucu:" + (s1 - s2));

else

MessageBox.Show("Girilen bilgiler formata uygun değil!");

}

private void bkapat_Click(object sender, EventArgs e)

{

this.Close();

}

GP (Güz-2016) Hafta-3/1

Okumaya devam et

NYP-2 2016 7. Hafta Uygulamaları

9 Mayıs 2016 tarihinde gönderilmiş caglar tarafından

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace tarifeler
{
    public partial class Form1 : Form
    {
        MySqlDataAdapter da_paket, da_musteri;
        DataTable dt_paket, dt_musteri;
        public Form1()
        {
            InitializeComponent();

            MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();
            bag.Server = "localhost";
            bag.UserID = "root";
            bag.Password = "123456";
            bag.Database = "hafta7_16_2";

            MySqlConnection conn = new MySqlConnection(bag.ToString());

            // paket tablosu
            MySqlCommand cmd_paket_sel = 
                new MySqlCommand("select id,adi,dk,sms,mb from paket", conn);
            MySqlCommand cmd_paket_ins =
                new MySqlCommand("insert into paket(adi,dk,sms,mb) values(@adi,@dk,@sms,@mb)", conn);
            cmd_paket_ins.Parameters.Add("@adi", MySqlDbType.VarChar, 45, "adi");
            cmd_paket_ins.Parameters.Add("@dk", MySqlDbType.Double, 11, "dk");
            cmd_paket_ins.Parameters.Add("@sms", MySqlDbType.Double, 11, "sms");
            cmd_paket_ins.Parameters.Add("@mb", MySqlDbType.Double, 11, "mb");

            MySqlCommand cmd_paket_upd = 
                new MySqlCommand("update paket set dk=@dk, sms=@sms, mb=@mb where id=@id", conn);
            cmd_paket_upd.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");
            cmd_paket_upd.Parameters.Add("@dk", MySqlDbType.Double, 11, "dk");
            cmd_paket_upd.Parameters.Add("@sms", MySqlDbType.Double, 11, "sms");
            cmd_paket_upd.Parameters.Add("@mb", MySqlDbType.Double, 11, "mb");


            da_paket = new MySqlDataAdapter();
            da_paket.SelectCommand = cmd_paket_sel;
            da_paket.InsertCommand = cmd_paket_ins;
            da_paket.UpdateCommand = cmd_paket_upd;

            // musteri tablosu
            MySqlCommand cmd_musteri_sel = 
                new MySqlCommand("select id,musteriadi,paketid,k_dk,k_sms,k_mb from musteri", conn);
            MySqlCommand cmd_musteri_ins =
                new MySqlCommand("insert into musteri(musteriadi,paketid,k_dk,k_sms,k_mb) values(@musteriadi,@paketid,@k_dk,@k_sms,@k_mb)", conn);
            cmd_musteri_ins.Parameters.Add("@musteriadi", MySqlDbType.VarChar, 45, "musteriadi");
            cmd_musteri_ins.Parameters.Add("@paketid", MySqlDbType.Int32, 11, "paketid");
            cmd_musteri_ins.Parameters.Add("@k_dk", MySqlDbType.Int32, 11, "k_dk");
            cmd_musteri_ins.Parameters.Add("@k_sms", MySqlDbType.Int32, 11, "k_sms");
            cmd_musteri_ins.Parameters.Add("@k_mb", MySqlDbType.Int32, 11, "k_mb");

            MySqlCommand cmd_musteri_del = 
                new MySqlCommand("delete from musteri where id=@id", conn);
            cmd_musteri_del.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");

            da_musteri = new MySqlDataAdapter();
            da_musteri.SelectCommand = cmd_musteri_sel;
            da_musteri.InsertCommand = cmd_musteri_ins;
            da_musteri.DeleteCommand = cmd_musteri_del;

            paketgetir();
            musterigetir();
        }


        private void paketgetir()
        {
            ctarife.Items.Clear();
            try
            {
                dt_paket = new DataTable();
                da_paket.Fill(dt_paket);
                int satirsay = dt_paket.Rows.Count;
                for (int i = 0; i < satirsay; i++)
                    ctarife.Items.Add(dt_paket.Rows[i]["adi"]);
            }
            catch
            { 
            }

            ctarife.Text = "Seçiniz";
        }

        private void musterigetir()
        {
            lmusteri.Items.Clear();
            ltarife.Items.Clear();
            ldk.Items.Clear();
            lsms.Items.Clear();
            lmb.Items.Clear();
            ltutar.Items.Clear();

            try
            {
                dt_musteri = new DataTable();
                da_musteri.Fill(dt_musteri);
                int satirsay = dt_musteri.Rows.Count;

                for (int i = 0; i < satirsay; i++)
                {

                    int paketid = (int)dt_musteri.Rows[i]["paketid"];

                    DataRow dr = tarifeyigetir(paketid);

                    if (dr != null)
                    {
                        double tutar = 
                            (int)dt_musteri.Rows[i]["k_dk"] * (double)dr["dk"] + 
                            (int)dt_musteri.Rows[i]["k_sms"] * (double)dr["sms"] + 
                            (int)dt_musteri.Rows[i]["k_mb"] * (double)dr["mb"];

                        lmusteri.Items.Add(dt_musteri.Rows[i]["musteriadi"]);
                        ltarife.Items.Add(dr["adi"]);
                        ldk.Items.Add(dt_musteri.Rows[i]["k_dk"]);
                        lsms.Items.Add(dt_musteri.Rows[i]["k_sms"]);
                        lmb.Items.Add(dt_musteri.Rows[i]["k_mb"]);
                        ltutar.Items.Add(tutar);
                    
                    
                    }
                
                }

            }
            catch
            { 
            
            }
        }


        private DataRow tarifeyigetir(int id)
        {
            try
            {
                DataRow[] drs=dt_paket.Select("id=" + id);
                if (drs.Length > 0)
                    return drs[0];
            }
            catch
            { 
            }

            return null;
        
        }

        private void bekle_Click(object sender, EventArgs e)
        {
            int dk, sms, mb;
            bool k1 = Int32.TryParse(tdk.Text, out dk);
            bool k2 = Int32.TryParse(tsms.Text, out sms);
            bool k3 = Int32.TryParse(tmb.Text, out mb);
            int secilen = ctarife.SelectedIndex;

            if(secilen>-1 && k1 && k2 && k3 && tmusteri.Text.Length>0)
            {
                try
                {
                    DataRow dr = dt_musteri.NewRow();
                    dr["musteriadi"] = tmusteri.Text;
                    dr["paketid"] =(int)dt_paket.Rows[secilen]["id"];
                    dr["k_dk"] = dk;
                    dr["k_sms"] = sms;
                    dr["k_mb"] = mb;
                    dt_musteri.Rows.Add(dr);
                    da_musteri.Update(dt_musteri);
                    
                    tmusteri.Clear();
                    ctarife.Text = "Seçiniz";
                    tdk.Clear();
                    tsms.Clear();
                    tmb.Clear();
                }
                catch
                { }

                musterigetir();
            }
        }

        private void bsil_Click(object sender, EventArgs e)
        {
            int secilen = lmusteri.SelectedIndex;
            if (secilen > -1)
            {
                try
                {
                    dt_musteri.Rows[secilen].Delete();
                    da_musteri.Update(dt_musteri);
                }
                catch
                { }
                musterigetir();
            }


        }

        private void btarife_Click(object sender, EventArgs e)
        {
            ftarifeler frm = new ftarifeler(da_paket);
            frm.ShowDialog();
            paketgetir();
        }
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace tarifeler

{

public partial class Form1 : Form

{

MySqlDataAdapter da_paket, da_musteri;

DataTable dt_paket, dt_musteri;

public Form1()

{

InitializeComponent();

MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();

bag.Server = "localhost";

bag.UserID = "root";

bag.Password = "123456";

bag.Database = "hafta7_16_2";

MySqlConnection conn = new MySqlConnection(bag.ToString());

// paket tablosu

MySqlCommand cmd_paket_sel =

new MySqlCommand("select id,adi,dk,sms,mb from paket", conn);

MySqlCommand cmd_paket_ins =

new MySqlCommand("insert into paket(adi,dk,sms,mb) values(@adi,@dk,@sms,@mb)", conn);

cmd_paket_ins.Parameters.Add("@adi", MySqlDbType.VarChar, 45, "adi");

cmd_paket_ins.Parameters.Add("@dk", MySqlDbType.Double, 11, "dk");

cmd_paket_ins.Parameters.Add("@sms", MySqlDbType.Double, 11, "sms");

cmd_paket_ins.Parameters.Add("@mb", MySqlDbType.Double, 11, "mb");

MySqlCommand cmd_paket_upd =

new MySqlCommand("update paket set dk=@dk, sms=@sms, mb=@mb where id=@id", conn);

cmd_paket_upd.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");

cmd_paket_upd.Parameters.Add("@dk", MySqlDbType.Double, 11, "dk");

cmd_paket_upd.Parameters.Add("@sms", MySqlDbType.Double, 11, "sms");

cmd_paket_upd.Parameters.Add("@mb", MySqlDbType.Double, 11, "mb");

da_paket = new MySqlDataAdapter();

da_paket.SelectCommand = cmd_paket_sel;

da_paket.InsertCommand = cmd_paket_ins;

da_paket.UpdateCommand = cmd_paket_upd;

// musteri tablosu

MySqlCommand cmd_musteri_sel =

new MySqlCommand("select id,musteriadi,paketid,k_dk,k_sms,k_mb from musteri", conn);

MySqlCommand cmd_musteri_ins =

new MySqlCommand("insert into musteri(musteriadi,paketid,k_dk,k_sms,k_mb) values(@musteriadi,@paketid,@k_dk,@k_sms,@k_mb)", conn);

cmd_musteri_ins.Parameters.Add("@musteriadi", MySqlDbType.VarChar, 45, "musteriadi");

cmd_musteri_ins.Parameters.Add("@paketid", MySqlDbType.Int32, 11, "paketid");

cmd_musteri_ins.Parameters.Add("@k_dk", MySqlDbType.Int32, 11, "k_dk");

cmd_musteri_ins.Parameters.Add("@k_sms", MySqlDbType.Int32, 11, "k_sms");

cmd_musteri_ins.Parameters.Add("@k_mb", MySqlDbType.Int32, 11, "k_mb");

MySqlCommand cmd_musteri_del =

new MySqlCommand("delete from musteri where id=@id", conn);

cmd_musteri_del.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");

da_musteri = new MySqlDataAdapter();

da_musteri.SelectCommand = cmd_musteri_sel;

da_musteri.InsertCommand = cmd_musteri_ins;

da_musteri.DeleteCommand = cmd_musteri_del;

paketgetir();

musterigetir();

}

private void paketgetir()

{

ctarife.Items.Clear();

try

{

dt_paket = new DataTable();

da_paket.Fill(dt_paket);

int satirsay = dt_paket.Rows.Count;

for (int i = 0; i < satirsay; i++)

ctarife.Items.Add(dt_paket.Rows[i]["adi"]);

}

catch

{

}

ctarife.Text = "Seçiniz";

}

private void musterigetir()

{

lmusteri.Items.Clear();

ltarife.Items.Clear();

ldk.Items.Clear();

lsms.Items.Clear();

lmb.Items.Clear();

ltutar.Items.Clear();

try

{

dt_musteri = new DataTable();

da_musteri.Fill(dt_musteri);

int satirsay = dt_musteri.Rows.Count;

for (int i = 0; i < satirsay; i++)

{

int paketid = (int)dt_musteri.Rows[i]["paketid"];

DataRow dr = tarifeyigetir(paketid);

if (dr != null)

{

double tutar =

(int)dt_musteri.Rows[i]["k_dk"] * (double)dr["dk"] +

(int)dt_musteri.Rows[i]["k_sms"] * (double)dr["sms"] +

(int)dt_musteri.Rows[i]["k_mb"] * (double)dr["mb"];

lmusteri.Items.Add(dt_musteri.Rows[i]["musteriadi"]);

ltarife.Items.Add(dr["adi"]);

ldk.Items.Add(dt_musteri.Rows[i]["k_dk"]);

lsms.Items.Add(dt_musteri.Rows[i]["k_sms"]);

lmb.Items.Add(dt_musteri.Rows[i]["k_mb"]);

ltutar.Items.Add(tutar);

}

catch

{

}

private DataRow tarifeyigetir(int id)

{

try

{

DataRow[] drs=dt_paket.Select("id=" + id);

if (drs.Length > 0)

return drs[0];

}

catch

{

}

return null;

}

private void bekle_Click(object sender, EventArgs e)

{

int dk, sms, mb;

bool k1 = Int32.TryParse(tdk.Text, out dk);

bool k2 = Int32.TryParse(tsms.Text, out sms);

bool k3 = Int32.TryParse(tmb.Text, out mb);

int secilen = ctarife.SelectedIndex;

if(secilen>-1 && k1 && k2 && k3 && tmusteri.Text.Length>0)

{

try

{

DataRow dr = dt_musteri.NewRow();

dr["musteriadi"] = tmusteri.Text;

dr["paketid"] =(int)dt_paket.Rows[secilen]["id"];

dr["k_dk"] = dk;

dr["k_sms"] = sms;

dr["k_mb"] = mb;

dt_musteri.Rows.Add(dr);

da_musteri.Update(dt_musteri);

tmusteri.Clear();

ctarife.Text = "Seçiniz";

tdk.Clear();

tsms.Clear();

tmb.Clear();

}

catch

{ }

musterigetir();

}

private void bsil_Click(object sender, EventArgs e)

{

int secilen = lmusteri.SelectedIndex;

if (secilen > -1)

{

try

{

dt_musteri.Rows[secilen].Delete();

da_musteri.Update(dt_musteri);

}

catch

{ }

musterigetir();

}

private void btarife_Click(object sender, EventArgs e)

{

ftarifeler frm = new ftarifeler(da_paket);

frm.ShowDialog();

paketgetir();

}

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace tarifeler
{
    public partial class ftarifeler: Form
    {
        MySqlDataAdapter da;
        DataTable dt;
        public ftarifeler(MySqlDataAdapter _da)
        {
            InitializeComponent();
            da = _da;
            verigetir();
        }

        private void verigetir()
        {
            lad.Items.Clear();
            ldk.Items.Clear();
            lsms.Items.Clear();
            lmb.Items.Clear();
            try
            {
                dt = new DataTable();
                da.Fill(dt);
                int satirsay = dt.Rows.Count;
                for (int i = 0; i < satirsay; i++)
                {
                    lad.Items.Add(dt.Rows[i]["adi"]);
                    ldk.Items.Add(dt.Rows[i]["dk"]);
                    lsms.Items.Add(dt.Rows[i]["sms"]);
                    lmb.Items.Add(dt.Rows[i]["mb"]);
                }
            }
            catch
            { }
        }

        private void bekle_Click(object sender, EventArgs e)
        {
            double fdk, fsms, fmb;
            bool k1 = Double.TryParse(tdk.Text, out fdk);
            bool k2 = Double.TryParse(tsms.Text, out fsms);
            bool k3 = Double.TryParse(tmb.Text, out fmb);

            if (tad.Text.Length > 0 && k1 && k2 && k3)
            {
                try
                {
                    DataRow dr = dt.NewRow();
                    dr["adi"] = tad.Text;
                    dr["dk"] = fdk;
                    dr["sms"] = fsms;
                    dr["mb"] = fmb;

                    dt.Rows.Add(dr);
                    da.Update(dt);

                    tad.Clear();
                    tdk.Clear();
                    tsms.Clear();
                    tmb.Clear();
                }
                catch { 
                }

                verigetir();

            }
        }

        private void bduzenle_Click(object sender, EventArgs e)
        {
            double fdk, fsms, fmb;
            bool k1 = Double.TryParse(tdk.Text, out fdk);
            bool k2 = Double.TryParse(tsms.Text, out fsms);
            bool k3 = Double.TryParse(tmb.Text, out fmb);
            int secilen = lad.SelectedIndex;

            if ( secilen>-1 && k1 && k2 && k3)
            {
                try
                {
                    DataRow dr = dt.Rows[secilen];
                    dr["dk"] = fdk;
                    dr["sms"] = fsms;
                    dr["mb"] = fmb;
                    da.Update(dt);

                    tad.Clear();
                    tdk.Clear();
                    tsms.Clear();
                    tmb.Clear();
                
                }
                catch
                { }

                verigetir();
            }

        }

        private void bkapat_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace tarifeler

{

public partial class ftarifeler: Form

{

MySqlDataAdapter da;

DataTable dt;

public ftarifeler(MySqlDataAdapter _da)

{

InitializeComponent();

da = _da;

verigetir();

}

private void verigetir()

{

lad.Items.Clear();

ldk.Items.Clear();

lsms.Items.Clear();

lmb.Items.Clear();

try

{

dt = new DataTable();

da.Fill(dt);

int satirsay = dt.Rows.Count;

for (int i = 0; i < satirsay; i++)

{

lad.Items.Add(dt.Rows[i]["adi"]);

ldk.Items.Add(dt.Rows[i]["dk"]);

lsms.Items.Add(dt.Rows[i]["sms"]);

lmb.Items.Add(dt.Rows[i]["mb"]);

}

catch

{ }

}

private void bekle_Click(object sender, EventArgs e)

{

double fdk, fsms, fmb;

bool k1 = Double.TryParse(tdk.Text, out fdk);

bool k2 = Double.TryParse(tsms.Text, out fsms);

bool k3 = Double.TryParse(tmb.Text, out fmb);

if (tad.Text.Length > 0 && k1 && k2 && k3)

{

try

{

DataRow dr = dt.NewRow();

dr["adi"] = tad.Text;

dr["dk"] = fdk;

dr["sms"] = fsms;

dr["mb"] = fmb;

dt.Rows.Add(dr);

da.Update(dt);

tad.Clear();

tdk.Clear();

tsms.Clear();

tmb.Clear();

}

catch {

}

verigetir();

}

private void bduzenle_Click(object sender, EventArgs e)

{

double fdk, fsms, fmb;

bool k1 = Double.TryParse(tdk.Text, out fdk);

bool k2 = Double.TryParse(tsms.Text, out fsms);

bool k3 = Double.TryParse(tmb.Text, out fmb);

int secilen = lad.SelectedIndex;

if ( secilen>-1 && k1 && k2 && k3)

{

try

{

DataRow dr = dt.Rows[secilen];

dr["dk"] = fdk;

dr["sms"] = fsms;

dr["mb"] = fmb;

da.Update(dt);

tad.Clear();

tdk.Clear();

tsms.Clear();

tmb.Clear();

}

catch

{ }

verigetir();

}

private void bkapat_Click(object sender, EventArgs e)

{

this.Close();

}

NYP-2 2016 Hafta-7

Okumaya devam et

NYP-2 2016 6. Hafta Uygulamaları

17 Mart 2016 tarihinde gönderilmiş caglar tarafından

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;


namespace alisverissepeti
{
    public partial class Form1 : Form
    {
        DataTable dt1, dt2;
        MySqlDataAdapter da1, da2;

        public Form1()
        {
            InitializeComponent();
            rbalis.Checked = true;

            MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();
            bag.Server = "localhost";
            bag.UserID = "root";
            bag.Password = "123456";
            bag.Database = "hafta6_16_2";

            MySqlConnection conn = new MySqlConnection(bag.ToString());

            // urun tablosu sorgulari
            MySqlCommand cmd_urun_sel = 
                new MySqlCommand("select id, urunadi, alisfiyati, satisfiyati from urun", conn);
            da1 = new MySqlDataAdapter();
            da1.SelectCommand = cmd_urun_sel;

            // sepet tablosu sorgulari
            MySqlCommand cmd_sepet_sel = 
                new MySqlCommand("select id,urunid,miktar,tip from sepet", conn);
            MySqlCommand cmd_sepet_ins = 
                new MySqlCommand("insert into sepet(urunid,miktar,tip) values(@urunid,@miktar,@tip)", conn);
            cmd_sepet_ins.Parameters.Add("@urunid", MySqlDbType.Int32, 11, "urunid");
            cmd_sepet_ins.Parameters.Add("@miktar", MySqlDbType.Int32, 11, "miktar");
            cmd_sepet_ins.Parameters.Add("@tip", MySqlDbType.Int32, 11, "tip");
            MySqlCommand cmd_sepet_del = 
                new MySqlCommand("delete from sepet where id=@id", conn);
            cmd_sepet_del.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");

            da2 = new MySqlDataAdapter();
            da2.SelectCommand = cmd_sepet_sel;
            da2.InsertCommand = cmd_sepet_ins;
            da2.DeleteCommand = cmd_sepet_del;
            urungetir();
            sepetgetir();
        }

        private void urungetir()
        {
            curun.Items.Clear();
            try
            {
                dt1 = new DataTable();
                da1.Fill(dt1);
                int satirsay = dt1.Rows.Count;
                for (int i = 0; i < satirsay; i++)
                    curun.Items.Add(dt1.Rows[i]["urunadi"]);

                curun.Text = "Seçiniz";
            }
            catch
            {
                curun.Text = "Hata";
            }
        }

        private void sepetgetir()
        { 
            double tutar=0;
            lurun.Items.Clear();
            lmiktar.Items.Clear();
            lislem.Items.Clear();
            ltutar.Items.Clear();
            try
            {
                dt2 = new DataTable();
                da2.Fill(dt2);

                int satirsay = dt2.Rows.Count;
                for (int i = 0; i < satirsay; i++)
                {
                    int urunid= (int)dt2.Rows[i]["urunid"];
                    int miktar = (int)dt2.Rows[i]["miktar"];
                    int tip = (int)dt2.Rows[i]["tip"];
                    double uruntutar = 0;
                    DataRow dr = urunbul(urunid);
                    if (dr != null)
                    {
                        lurun.Items.Add(dr["urunadi"]);
                        lmiktar.Items.Add(miktar);
                        if (tip == 0)
                        {
                            lislem.Items.Add("Alış");
                            uruntutar = miktar * (double)dr["alisfiyati"];
                            tutar -= uruntutar;
                        }
                        else
                        {
                            lislem.Items.Add("Satış");
                            uruntutar = miktar * (double)dr["satisfiyati"];
                            tutar += uruntutar;
                        }
                        ltutar.Items.Add(uruntutar);
                    }
                }

                curun.Text = "Seçiniz";
            }
            catch
            {
                curun.Text = "Hata";
            }
            latutar.Text = tutar + " TL";
        }

        private DataRow urunbul(int id)
        {
            int satirsay = dt1.Rows.Count;
            for(int i=0;i<satirsay;i++)
            {
                if ((int)dt1.Rows[i]["id"] == id)
                    return dt1.Rows[i];
            }
            return null;

            
        }

         private DataRow urunbul1(int id)
        {
            try
            {
                DataRow[] dr = dt1.Select("id=" + id); // datatable icerisinde yer alan bir kolon ile ilgili filtre
                if (dr.Length > 0)
                    return dr[0];
            }
            catch
            { 
            
            }

            return null;
        }

        private void bekle_Click(object sender, EventArgs e)
        {
            int miktar;
            int secilen = curun.SelectedIndex;
            bool kontrol = Int32.TryParse(tmiktar.Text, out miktar);

            if (secilen > -1 && kontrol)
            {
                try
                {
                    DataRow dr = dt2.NewRow();
                    dr["urunid"] = dt1.Rows[secilen]["id"];// ekleme siralari ayni oldugu icin 
                    dr["miktar"] = miktar;
                    if (rbalis.Checked)
                        dr["tip"] = 0;
                    else
                        dr["tip"] = 1;

                    dt2.Rows.Add(dr);
                    da2.Update(dt2);
                    curun.Text = "Seçiniz";
                    rbalis.Checked = true;
                    tmiktar.Clear();
                }
                catch
                { }
                sepetgetir(); // liste guncelle
            }
        }

        private void bsil_Click(object sender, EventArgs e)
        {
            int secilen = lurun.SelectedIndex;
            if (secilen > -1)
            {
                try
                {
                    dt2.Rows[secilen].Delete();
                    da2.Update(dt2);
                }
                catch
                { }
                sepetgetir(); // listeyi guncelle
            }
        }
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace alisverissepeti

{

public partial class Form1 : Form

{

DataTable dt1, dt2;

MySqlDataAdapter da1, da2;

public Form1()

{

InitializeComponent();

rbalis.Checked = true;

MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();

bag.Server = "localhost";

bag.UserID = "root";

bag.Password = "123456";

bag.Database = "hafta6_16_2";

MySqlConnection conn = new MySqlConnection(bag.ToString());

// urun tablosu sorgulari

MySqlCommand cmd_urun_sel =

new MySqlCommand("select id, urunadi, alisfiyati, satisfiyati from urun", conn);

da1 = new MySqlDataAdapter();

da1.SelectCommand = cmd_urun_sel;

// sepet tablosu sorgulari

MySqlCommand cmd_sepet_sel =

new MySqlCommand("select id,urunid,miktar,tip from sepet", conn);

MySqlCommand cmd_sepet_ins =

new MySqlCommand("insert into sepet(urunid,miktar,tip) values(@urunid,@miktar,@tip)", conn);

cmd_sepet_ins.Parameters.Add("@urunid", MySqlDbType.Int32, 11, "urunid");

cmd_sepet_ins.Parameters.Add("@miktar", MySqlDbType.Int32, 11, "miktar");

cmd_sepet_ins.Parameters.Add("@tip", MySqlDbType.Int32, 11, "tip");

MySqlCommand cmd_sepet_del =

new MySqlCommand("delete from sepet where id=@id", conn);

cmd_sepet_del.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");

da2 = new MySqlDataAdapter();

da2.SelectCommand = cmd_sepet_sel;

da2.InsertCommand = cmd_sepet_ins;

da2.DeleteCommand = cmd_sepet_del;

urungetir();

sepetgetir();

}

private void urungetir()

{

curun.Items.Clear();

try

{

dt1 = new DataTable();

da1.Fill(dt1);

int satirsay = dt1.Rows.Count;

for (int i = 0; i < satirsay; i++)

curun.Items.Add(dt1.Rows[i]["urunadi"]);

curun.Text = "Seçiniz";

}

catch

{

curun.Text = "Hata";

}

private void sepetgetir()

{

double tutar=0;

lurun.Items.Clear();

lmiktar.Items.Clear();

lislem.Items.Clear();

ltutar.Items.Clear();

try

{

dt2 = new DataTable();

da2.Fill(dt2);

int satirsay = dt2.Rows.Count;

for (int i = 0; i < satirsay; i++)

{

int urunid= (int)dt2.Rows[i]["urunid"];

int miktar = (int)dt2.Rows[i]["miktar"];

int tip = (int)dt2.Rows[i]["tip"];

double uruntutar = 0;

DataRow dr = urunbul(urunid);

if (dr != null)

{

lurun.Items.Add(dr["urunadi"]);

lmiktar.Items.Add(miktar);

if (tip == 0)

{

lislem.Items.Add("Alış");

uruntutar = miktar * (double)dr["alisfiyati"];

tutar -= uruntutar;

}

else

{

lislem.Items.Add("Satış");

uruntutar = miktar * (double)dr["satisfiyati"];

tutar += uruntutar;

}

ltutar.Items.Add(uruntutar);

}

curun.Text = "Seçiniz";

}

catch

{

curun.Text = "Hata";

}

latutar.Text = tutar + " TL";

}

private DataRow urunbul(int id)

{

int satirsay = dt1.Rows.Count;

for(int i=0;i<satirsay;i++)

{

if ((int)dt1.Rows[i]["id"] == id)

return dt1.Rows[i];

}

return null;

}

private DataRow urunbul1(int id)

{

try

{

DataRow[] dr = dt1.Select("id=" + id); // datatable icerisinde yer alan bir kolon ile ilgili filtre

if (dr.Length > 0)

return dr[0];

}

catch

{

}

return null;

}

private void bekle_Click(object sender, EventArgs e)

{

int miktar;

int secilen = curun.SelectedIndex;

bool kontrol = Int32.TryParse(tmiktar.Text, out miktar);

if (secilen > -1 && kontrol)

{

try

{

DataRow dr = dt2.NewRow();

dr["urunid"] = dt1.Rows[secilen]["id"];// ekleme siralari ayni oldugu icin

dr["miktar"] = miktar;

if (rbalis.Checked)

dr["tip"] = 0;

else

dr["tip"] = 1;

dt2.Rows.Add(dr);

da2.Update(dt2);

curun.Text = "Seçiniz";

rbalis.Checked = true;

tmiktar.Clear();

}

catch

{ }

sepetgetir(); // liste guncelle

}

private void bsil_Click(object sender, EventArgs e)

{

int secilen = lurun.SelectedIndex;

if (secilen > -1)

{

try

{

dt2.Rows[secilen].Delete();

da2.Update(dt2);

}

catch

{ }

sepetgetir(); // listeyi guncelle

}

CREATE SCHEMA `hafta6_16_2` DEFAULT CHARACTER SET utf8 COLLATE utf8_turkish_ci ;

CREATE TABLE `hafta6_16_2`.`urun` (
  `id` INT NOT NULL AUTO_INCREMENT COMMENT '',
  `urunadi` VARCHAR(45) NULL COMMENT '',
  `alisfiyati` DOUBLE NULL COMMENT '',
  `satisfiyati` DOUBLE NULL COMMENT '',
  PRIMARY KEY (`id`)  COMMENT '');

  CREATE TABLE `hafta6_16_2`.`sepet` (
  `id` INT NOT NULL AUTO_INCREMENT COMMENT '',
  `urunid` INT NULL COMMENT '',
  `miktar` INT NULL COMMENT '',
  `tip` INT NULL COMMENT '',
  PRIMARY KEY (`id`)  COMMENT '');

INSERT INTO `hafta6_16_2`.`urun` (`urunadi`, `alisfiyati`, `satisfiyati`) VALUES ('Masa', '25', '45');
INSERT INTO `hafta6_16_2`.`urun` (`urunadi`, `alisfiyati`, `satisfiyati`) VALUES ('Sandalye', '15', '20');
INSERT INTO `hafta6_16_2`.`urun` (`urunadi`, `alisfiyati`, `satisfiyati`) VALUES ('Sehpa', '5', '15');
INSERT INTO `hafta6_16_2`.`urun` (`urunadi`, `alisfiyati`, `satisfiyati`) VALUES ('TV', '1200', '1350');
INSERT INTO `hafta6_16_2`.`urun` (`urunadi`, `alisfiyati`, `satisfiyati`) VALUES ('Halı', '450', '600');

CREATE SCHEMA `hafta6_16_2` DEFAULT CHARACTER SET utf8 COLLATE utf8_turkish_ci ;

CREATE TABLE `hafta6_16_2`.`urun` (

`id` INT NOT NULL AUTO_INCREMENT COMMENT '',

`urunadi` VARCHAR(45) NULL COMMENT '',

`alisfiyati` DOUBLE NULL COMMENT '',

`satisfiyati` DOUBLE NULL COMMENT '',

PRIMARY KEY (`id`) COMMENT '');

CREATE TABLE `hafta6_16_2`.`sepet` (

`id` INT NOT NULL AUTO_INCREMENT COMMENT '',

`urunid` INT NULL COMMENT '',

`miktar` INT NULL COMMENT '',

`tip` INT NULL COMMENT '',

PRIMARY KEY (`id`) COMMENT '');

INSERT INTO `hafta6_16_2`.`urun` (`urunadi`, `alisfiyati`, `satisfiyati`) VALUES ('Masa', '25', '45');

INSERT INTO `hafta6_16_2`.`urun` (`urunadi`, `alisfiyati`, `satisfiyati`) VALUES ('Sandalye', '15', '20');

INSERT INTO `hafta6_16_2`.`urun` (`urunadi`, `alisfiyati`, `satisfiyati`) VALUES ('Sehpa', '5', '15');

INSERT INTO `hafta6_16_2`.`urun` (`urunadi`, `alisfiyati`, `satisfiyati`) VALUES ('TV', '1200', '1350');

INSERT INTO `hafta6_16_2`.`urun` (`urunadi`, `alisfiyati`, `satisfiyati`) VALUES ('Halı', '450', '600');

NYP-2 2016 6. Hafta Uygulamaları

Okumaya devam et

NYP-2 2016 5. Hafta Uygulamaları

9 Mart 2016 tarihinde gönderilmiş caglar tarafından

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace depo
{
    public partial class Form1 : Form
    {
        MySqlDataAdapter da;
        DataTable dt;

        public Form1()
        {
            InitializeComponent();

            MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();
            bag.Server = "localhost";
            bag.UserID = "root";
            bag.Password = "123456";
            bag.Database = "hafta5_16_1";

            MySqlConnection conn = new MySqlConnection(bag.ToString());
            MySqlCommand cmd_sel = new MySqlCommand("select id,isim,miktar from depo;", conn);
            MySqlCommand cmd_ins = new MySqlCommand("insert into depo(isim,miktar) values (@isim,@miktar);",conn);
            cmd_ins.Parameters.Add("@isim", MySqlDbType.VarChar, 45, "isim");
            cmd_ins.Parameters.Add("@miktar", MySqlDbType.Int32, 11, "miktar");

            MySqlCommand cmd_del = new MySqlCommand("delete from depo where id=@id", conn);
            cmd_del.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");

            MySqlCommand cmd_upd = new MySqlCommand("update depo set isim=@isim, miktar=@miktar where id=@id",conn);
            cmd_upd.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");
            cmd_upd.Parameters.Add("@isim", MySqlDbType.VarChar, 45, "isim");
            cmd_upd.Parameters.Add("@miktar", MySqlDbType.Int32, 11, "miktar");

            da = new MySqlDataAdapter();
            da.SelectCommand = cmd_sel;
            da.InsertCommand = cmd_ins;
            da.DeleteCommand = cmd_del;
            da.UpdateCommand = cmd_upd;

            verigetir();
        }

        private void bekle_Click(object sender, EventArgs e)
        {
            int miktar;
            bool kontrol = Int32.TryParse(tmiktar.Text, out miktar);

            if (kontrol && turun.Text.Length > 0)
            {

                try
                {
                    DataRow dr = dt.NewRow(); // mevcut tablodan yeni bir satir turettik
                    dr["isim"] = turun.Text;
                    dr["miktar"] = miktar;
                    dt.Rows.Add(dr); // olusturulan yeni satir tabloya eklendi
                    da.Update(dt);
                    turun.Clear();
                    tmiktar.Clear();

                }
                catch
                { 
                }

                verigetir();
            }



        }


        private void verigetir()
        {
            try
            {
                dt = new DataTable();
                da.Fill(dt);
                lurun.Items.Clear();
                lmiktar.Items.Clear();

                int satirsay = dt.Rows.Count;
                for (int i = 0; i < satirsay; i++)
                {
                    lurun.Items.Add(dt.Rows[i]["isim"]);
                    lmiktar.Items.Add(dt.Rows[i]["miktar"]);
                }
            }
            catch { 
            
            }
        
        
        }

        private void bsil_Click(object sender, EventArgs e)
        {

            int index = lurun.SelectedIndex;
            if (index > -1)
            {
                try
                {
                    dt.Rows[index].Delete();
                    da.Update(dt);
                }
                catch
                { 
                 
                }
                verigetir();
            }



        }

        private void bguncelleme_Click(object sender, EventArgs e)
        {
            int index = lurun.SelectedIndex;
             int miktar;
            bool kontrol = Int32.TryParse(tmiktar.Text, out miktar);

            if (kontrol && index>-1 && turun.Text.Length > 0)
            {

                try
                {
                    DataRow dr = dt.Rows[index]; // mevcut satiri getirdik
                    dr["isim"] = turun.Text;
                    dr["miktar"] = miktar;
                    da.Update(dt);
                    turun.Clear();
                    tmiktar.Clear();
                    verigetir();
                }
                catch
                { 
                    //
                }
            }


        }

    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace depo

{

public partial class Form1 : Form

{

MySqlDataAdapter da;

DataTable dt;

public Form1()

{

InitializeComponent();

MySqlConnectionStringBuilder bag = new MySqlConnectionStringBuilder();

bag.Server = "localhost";

bag.UserID = "root";

bag.Password = "123456";

bag.Database = "hafta5_16_1";

MySqlConnection conn = new MySqlConnection(bag.ToString());

MySqlCommand cmd_sel = new MySqlCommand("select id,isim,miktar from depo;", conn);

MySqlCommand cmd_ins = new MySqlCommand("insert into depo(isim,miktar) values (@isim,@miktar);",conn);

cmd_ins.Parameters.Add("@isim", MySqlDbType.VarChar, 45, "isim");

cmd_ins.Parameters.Add("@miktar", MySqlDbType.Int32, 11, "miktar");

MySqlCommand cmd_del = new MySqlCommand("delete from depo where id=@id", conn);

cmd_del.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");

MySqlCommand cmd_upd = new MySqlCommand("update depo set isim=@isim, miktar=@miktar where id=@id",conn);

cmd_upd.Parameters.Add("@id", MySqlDbType.Int32, 11, "id");

cmd_upd.Parameters.Add("@isim", MySqlDbType.VarChar, 45, "isim");

cmd_upd.Parameters.Add("@miktar", MySqlDbType.Int32, 11, "miktar");

da = new MySqlDataAdapter();

da.SelectCommand = cmd_sel;

da.InsertCommand = cmd_ins;

da.DeleteCommand = cmd_del;

da.UpdateCommand = cmd_upd;

verigetir();

}

private void bekle_Click(object sender, EventArgs e)

{

int miktar;

bool kontrol = Int32.TryParse(tmiktar.Text, out miktar);

if (kontrol && turun.Text.Length > 0)

{

try

{

DataRow dr = dt.NewRow(); // mevcut tablodan yeni bir satir turettik

dr["isim"] = turun.Text;

dr["miktar"] = miktar;

dt.Rows.Add(dr); // olusturulan yeni satir tabloya eklendi

da.Update(dt);

turun.Clear();

tmiktar.Clear();

}

catch

{

}

verigetir();

}

private void verigetir()

{

try

{

dt = new DataTable();

da.Fill(dt);

lurun.Items.Clear();

lmiktar.Items.Clear();

int satirsay = dt.Rows.Count;

for (int i = 0; i < satirsay; i++)

{

lurun.Items.Add(dt.Rows[i]["isim"]);

lmiktar.Items.Add(dt.Rows[i]["miktar"]);

}

catch {

}

private void bsil_Click(object sender, EventArgs e)

{

int index = lurun.SelectedIndex;

if (index > -1)

{

try

{

dt.Rows[index].Delete();

da.Update(dt);

}

catch

{

}

verigetir();

}

private void bguncelleme_Click(object sender, EventArgs e)

{

int index = lurun.SelectedIndex;

int miktar;

bool kontrol = Int32.TryParse(tmiktar.Text, out miktar);

if (kontrol && index>-1 && turun.Text.Length > 0)

{

try

{

DataRow dr = dt.Rows[index]; // mevcut satiri getirdik

dr["isim"] = turun.Text;

dr["miktar"] = miktar;

da.Update(dt);

turun.Clear();

tmiktar.Clear();

verigetir();

}

catch

{

}

CREATE SCHEMA `hafta5_16_1` DEFAULT CHARACTER SET utf8 COLLATE utf8_turkish_ci ;
CREATE TABLE `hafta5_16_1`.`depo` (
  `id` INT NOT NULL AUTO_INCREMENT COMMENT '',
  `isim` VARCHAR(45) NULL COMMENT '',
  `miktar` INT NULL COMMENT '',
  PRIMARY KEY (`id`)  COMMENT '');

CREATE SCHEMA `hafta5_16_1` DEFAULT CHARACTER SET utf8 COLLATE utf8_turkish_ci ;

CREATE TABLE `hafta5_16_1`.`depo` (

`id` INT NOT NULL AUTO_INCREMENT COMMENT '',

`isim` VARCHAR(45) NULL COMMENT '',

`miktar` INT NULL COMMENT '',

PRIMARY KEY (`id`) COMMENT '');

NYP-2 2016 5. Hafta Uygulamaları

Okumaya devam et

NYP-1 2016 Hafta-13

28 Aralık 2015 tarihinde gönderilmiş caglar tarafından

NYP-1 2016 13. Hafta Uygulamaları

Okumaya devam et

NYP-1 2016 Hafta-12

28 Aralık 201528 Aralık 2015 tarihinde gönderilmiş caglar tarafından

NYP-1 2016 12. Hafta Uygulamaları

Okumaya devam et

NYP-1 2016 Hafta-9

23 Kasım 2015 tarihinde gönderilmiş caglar tarafından

Not: Sil butonu önceki örneklere benzer olduğu için yeniden yazılmamıştır. Daha önceki ListBox örneklerini inceleyebilirsiniz. NYP-1 2016 9. Hafta Uygulamaları

Okumaya devam et

NYP-1 2016 Hafta-8

23 Kasım 2015 tarihinde gönderilmiş caglar tarafından

NYP-1 2016 8. Hafta Uygulamaları

Okumaya devam et

NYP-1 2016 Hafta-7

10 Kasım 201510 Kasım 2015 tarihinde gönderilmiş caglar tarafından

NYP-1 2016 7. Hafta Uygulamaları

Okumaya devam et

NYP-1 2016 Hafta-6

3 Kasım 2015 tarihinde gönderilmiş caglar tarafından

NYP-1 2016 6. Hafta Uygulamaları

Okumaya devam et

Etiket: c#

Algoritmalar ve Programlama – 1 (Güz-2017) Hafta – 11

Algoritmalar ve Programlama – 1 (Güz-2017) Hafta – 5

Algoritmalar ve Programlama – 1 (Güz-2017) Hafta – 6

İşletim Sistemleri (Bahar-2016) Hafta-14/2

İşletim Sistemleri (Bahar-2016) Hafta-14/1

İşletim Sistemleri (Bahar-2016) Hafta-13

İşletim Sistemleri (Bahar-2016) Hafta-10/1

İşletim Sistemleri (Bahar-2016) Hafta-5/2

İşletim Sistemleri (Bahar-2016) Hafta-2

Görsel Programlama (Güz-2016) Hafta-3-2

Görsel Programlama (Güz-2016) Hafta-3-1

NYP-2 2016 7. Hafta Uygulamaları

NYP-2 2016 6. Hafta Uygulamaları

NYP-2 2016 5. Hafta Uygulamaları

NYP-1 2016 Hafta-13

NYP-1 2016 Hafta-12

NYP-1 2016 Hafta-9

NYP-1 2016 Hafta-8

NYP-1 2016 Hafta-7

NYP-1 2016 Hafta-6

Son Yorumlar

Son Yazılar

Kategoriler

Arşivler