private void arayuz_bilgi_duzenle_Click(object sender, EventArgs e) { EUSERS item = new EUSERS(); item.ID = UserIDNo; item.Username = ARkullaniciadi.Text; item.Name = ARadi.Text; item.Surname = ARsoyadi.Text; item.Email = ARemail.Text; BLLUSERS.update_user(item); EADDRESS item2 = new EADDRESS(); item2.Cadde = ARcadde.Text; item2.Street = ARsokak.Text; item2.City = ARil.Text; item2.Town = ARilce.Text; item2.Num = Convert.ToInt32(ARno.Text); item2.UsersID = UserIDNo; BLLADDRESS.update_address(item2); arayuzayar.SelectedIndex = 0; kullanici_arayuz_bilgi(); }
private void kullanici_arayuz_bilgi() { EUSERS item = BLLUSERS.kullanici_ismi(UserIDNo); Akullaniciadi.Text = item.Username; Aadi.Text = item.Name; Asoyadi.Text = item.Surname; Aemail.Text = item.Email; int temp = item.Mode; if (temp == 0) { Apozisyon.Text = "Normal kullanici"; } else if (temp == 1) { Apozisyon.Text = "Calisan uye"; } else if (temp == 2) { Apozisyon.Text = "Admin"; } ECARD item2 = BLLCARD.show_Card_item(UserIDNo); Abakiye.Text = item2.FakeBalance.ToString(); EADDRESS item3 = BLLADDRESS.show_Address_item(UserIDNo); Acadde.Text = item3.Cadde; Asokak.Text = item3.Street; Ail.Text = item3.City; Ailce.Text = item3.Town; Ano.Text = item3.Num.ToString(); }
private void arayuzBilgiDuzenle_Click(object sender, EventArgs e) { arayuzayar.SelectedIndex = 2; EUSERS item = BLLUSERS.kullanici_ismi(UserIDNo); ARkullaniciadi.Text = item.Username; ARadi.Text = item.Name; ARsoyadi.Text = item.Surname; ARemail.Text = item.Email; int temp = item.Mode; if (temp == 0) { ARpozisyon.Text = "Normal kullanici"; } else if (temp == 1) { ARpozisyon.Text = "Calisan uye"; } else if (temp == 2) { ARpozisyon.Text = "Admin"; } ECARD item2 = BLLCARD.show_Card_item(UserIDNo); ARbakiye.Text = item2.FakeBalance.ToString(); EADDRESS item3 = BLLADDRESS.show_Address_item(UserIDNo); ARcadde.Text = item3.Cadde; ARsokak.Text = item3.Street; ARil.Text = item3.City; ARilce.Text = item3.Town; ARno.Text = item3.Num.ToString(); }
public static int update_user(EUSERS item) { int satir = -1; try { SqlCommand com = new SqlCommand("UPDATE_USER", FCONNECTION.conn); com.CommandType = CommandType.StoredProcedure; if (com.Connection.State != ConnectionState.Open) { com.Connection.Open(); } com.Parameters.AddWithValue("ID", item.ID); com.Parameters.AddWithValue("Username", item.Username); com.Parameters.AddWithValue("Name", item.Name); com.Parameters.AddWithValue("Surname", item.Surname); com.Parameters.AddWithValue("Email", item.Email); satir = com.ExecuteNonQuery(); com.Connection.Close(); } catch { satir = -1; } return(satir); }
public static int User_ID_al(string name) { EUSERS item = new EUSERS(); SqlCommand com2 = new SqlCommand("User_ID_al", FCONNECTION.conn); com2.CommandType = CommandType.StoredProcedure; com2.Parameters.AddWithValue("Username", name); if (com2.Connection.State != ConnectionState.Open) { com2.Connection.Open(); } SqlDataReader rdr = com2.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { item.ID = Convert.ToInt32(rdr["ID"]); } } com2.Connection.Close(); rdr.Close(); return(item.ID); }
private void girisYap_Click(object sender, EventArgs e) { EUSERS item = new EUSERS(); item.Username = email_giris.Text; item.Email = email_giris.Text; item.Pass = sifre_giris.Text; if (BLLUSERS.Login(item, ref UserIDNo) == 1) { MessageBox.Show("Basariyla giris yaptiniz."); } else { MessageBox.Show("Giris hatasi"); } TabloUst.SelectedIndex = 0; }
private void incele1_Click(object sender, EventArgs e) { TABLO.SelectedIndex = 1; //if(sol1sag2==1) EPICTURE resim1 = resim_yolu(temp_UrunID); UrunAlPic.ImageLocation = resim1.PicDirectory; urunID.Text = temp_UrunID.ToString(); UsersID.Text = TempUsersID.Text; tempurunID1.Text = temp_UrunID.ToString(); EPRODUCT deger = BLLPRODUCT.urun_listele(temp_UrunID);//sayfa no urun_ad.Text = deger.Name; urun_fiyat.Text = deger.Price.ToString(); EUSERS deger2 = BLLUSERS.kullanici_ismi(Convert.ToInt32(UsersID.Text)); urun_sahibi.Text = "(" + deger2.Username + ") " + deger2.Name + " " + deger2.Surname; }
private void kayitol_Click(object sender, EventArgs e) { if (string.Compare(sifre.Text, sifre2.Text) == 0) { EUSERS item = new EUSERS(); item.Username = username.Text; item.Pass = sifre.Text; item.Name = name.Text; item.Surname = surname.Text; item.Email = email.Text; item.SecurityAnswer = gizlisoru.Text; if (BLLUSERS.Insert(item) > 0) { int temp_user_ID = BLLUSERS.get_user_ID(item); EADDRESS item2 = new EADDRESS(); item2.Cadde = Cadde.Text; item2.Street = Sokak.Text; item2.City = il.Text; item2.Town = ilce.Text; item2.Num = Convert.ToInt32(no.Text); item2.UsersID = temp_user_ID; BLLADDRESS.insert_Address(item2); MessageBox.Show("Basariyla kayit oldunuz."); } else { MessageBox.Show("Kayit hatasi"); } } else { MessageBox.Show("Sifreler uyusmuyor!"); } TabloUst.SelectedIndex = 1; }
public static int get_user_ID(EUSERS item) { SqlCommand com2 = new SqlCommand("get_UserID", FCONNECTION.conn); com2.CommandType = CommandType.StoredProcedure; com2.Parameters.AddWithValue("Username", item.Username); com2.Parameters.AddWithValue("Email", item.Email); com2.Parameters.AddWithValue("Pass", item.Pass); SqlDataReader rdr = com2.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { item.ID = Convert.ToInt32(rdr["ID"]); } } com2.Connection.Close(); rdr.Close(); return(item.ID); }
public static int Login(EUSERS item, ref int UserIDNo) { int temp; SqlCommand com = new SqlCommand("SEARCH_USER", FCONNECTION.conn); com.CommandType = CommandType.StoredProcedure; if (com.Connection.State != ConnectionState.Open) { com.Connection.Open(); } com.Parameters.AddWithValue("Username", item.Username); com.Parameters.AddWithValue("Email", item.Email); com.Parameters.AddWithValue("Pass", item.Pass); temp = (Int32)com.ExecuteScalar(); SqlCommand com2 = new SqlCommand("get_UserID", FCONNECTION.conn); com2.CommandType = CommandType.StoredProcedure; com2.Parameters.AddWithValue("Username", item.Username); com2.Parameters.AddWithValue("Email", item.Email); com2.Parameters.AddWithValue("Pass", item.Pass); SqlDataReader rdr = com2.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { item.ID = Convert.ToInt32(rdr["ID"]); } } UserIDNo = item.ID; com2.Connection.Close(); rdr.Close(); return(temp); }
private void calisan_atama_Click(object sender, EventArgs e) { arayuzayar.SelectedIndex = 0; EUSERS item = new EUSERS(); item.Username = secilen_kisi.Text; int kullanici_ID = BLLUSERS.User_ID_al(item.Username); if (atanacak_poz_combobox.Text == "Normal") { BLLUSERS.set_user_mode(kullanici_ID, 0); //Employee tablosundan sil } else if (atanacak_poz_combobox.Text == "Calisan") { BLLUSERS.set_user_mode(kullanici_ID, 1); //Employee tablosuna ekle ID } else if (atanacak_poz_combobox.Text == "Yonetici") { BLLUSERS.set_user_mode(kullanici_ID, 2); //Employe tablosundan sil } }
public static EUSERS kullanici_ismi(int a) { EUSERS item = new EUSERS(); try { SqlCommand com = new SqlCommand("user_name_satin", FCONNECTION.conn); com.CommandType = CommandType.StoredProcedure; if (com.Connection.State != ConnectionState.Open) { com.Connection.Open(); } com.Parameters.AddWithValue("ID", a); SqlDataReader rdr = com.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { item.Username = rdr["Username"].ToString(); item.Name = rdr["Name"].ToString(); item.Surname = rdr["Surname"].ToString(); item.Email = rdr["Email"].ToString(); item.Mode = Convert.ToInt32(rdr["Mode"]); } } com.Connection.Close(); rdr.Close(); } catch { } return(item); }
public static int update_user(EUSERS item) { return(FUSERS.update_user(item)); }
public static int get_user_ID(EUSERS item) { return(FUSERS.get_user_ID(item)); }
public static int Login(EUSERS item, ref int UserIDNo) { return(FUSERS.Login(item, ref UserIDNo)); }
public static int Insert(EUSERS item) { return(FUSERS.Insert(item)); }