public static int Update(EKullanici eKullanici) { SqlCommand sqlCommand = null; int degistirilen = 0; try { sqlCommand = new SqlCommand("Kitap_Update", Baglan.Con); sqlCommand.CommandType = CommandType.StoredProcedure; if (sqlCommand.Connection.State != ConnectionState.Open) { sqlCommand.Connection.Open(); } sqlCommand.Parameters.AddWithValue("adS", eKullanici.adS); sqlCommand.Parameters.AddWithValue("email", eKullanici.email); sqlCommand.Parameters.AddWithValue("telefon", eKullanici.telefon); degistirilen = sqlCommand.ExecuteNonQuery(); MessageBox.Show("Güncelleme başarılı"); } catch (Exception e) { MessageBox.Show(e.ToString()); degistirilen = -1; } finally { sqlCommand.Connection.Close(); } return(degistirilen); }
public static int Insert(EKullanici eKullanici) { SqlCommand sqlCommand = null; int girilen = 0; try { sqlCommand = new SqlCommand("Kullanici_Ekle", Baglan.Con); sqlCommand.CommandType = CommandType.StoredProcedure; if (sqlCommand.Connection.State != ConnectionState.Open) { sqlCommand.Connection.Open(); } sqlCommand.Parameters.AddWithValue("adS", eKullanici.adS); sqlCommand.Parameters.AddWithValue("email", eKullanici.email); sqlCommand.Parameters.AddWithValue("telefon", eKullanici.telefon); sqlCommand.Parameters.AddWithValue("password", eKullanici.password); girilen = sqlCommand.ExecuteNonQuery(); MessageBox.Show("Ekleme başarılı"); } catch (Exception e) { MessageBox.Show(e.ToString()); } finally { sqlCommand.Connection.Close(); } return(girilen); }
public static int Update(EKullanici eKullanici) { if (eKullanici.adS != null && eKullanici.email.Trim().Length > 0 && eKullanici.kullaniciId > 0) { return(FKullanici.Update(eKullanici)); } return(-1); }
public static int Insert(EKullanici eKullanici) { if (eKullanici.email != null && eKullanici.email.Trim().Length > 0 && eKullanici.password != null && eKullanici.password.Trim().Length > 0) { return(FKullanici.Insert(eKullanici)); } return(-1); }
private void button1_Click(object sender, EventArgs e) { EKullanici yeniKullanici = new EKullanici(); yeniKullanici.adS = adSoyadText.Text; yeniKullanici.email = emailText.Text; yeniKullanici.password = sifreText.Text; yeniKullanici.telefon = telefonText.Text; BKullanici.Insert(yeniKullanici); }
public static List <EKullanici> FirmaGorevlileri() { List <EKullanici> fGorevlileri = null; SqlCommand sqlCommand = null; try { sqlCommand = new SqlCommand("Firma_Yetkilileri_Getir", Baglan.Con); sqlCommand.CommandType = CommandType.StoredProcedure; if (sqlCommand.Connection.State != ConnectionState.Open) { sqlCommand.Connection.Open(); } SqlDataReader rdr = sqlCommand.ExecuteReader(); if (rdr.HasRows) { fGorevlileri = new List <EKullanici>(); while (rdr.Read()) { EKullanici kul = new EKullanici(); kul.kullaniciId = Convert.ToInt32(rdr["kullaniciId"]); kul.adS = rdr["adS"].ToString(); kul.email = rdr["email"].ToString(); kul.telefon = rdr["telefon"].ToString(); fGorevlileri.Add(kul); } } rdr.Close(); } catch (Exception e) { MessageBox.Show(e.ToString()); fGorevlileri = null; } finally { sqlCommand.Connection.Close(); } return(fGorevlileri); }
public static EKullanici BirKullanici(int Id) { EKullanici kullanici = null; SqlCommand sqlCommand = null; try { sqlCommand = new SqlCommand("Kullanici_Getir", Baglan.Con); sqlCommand.CommandType = CommandType.StoredProcedure; if (sqlCommand.Connection.State != ConnectionState.Open) { sqlCommand.Connection.Open(); } sqlCommand.Parameters.AddWithValue("ID", Id); SqlDataReader rdr = sqlCommand.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { kullanici = new EKullanici(); kullanici.adS = rdr["adS"].ToString(); kullanici.email = rdr["email"].ToString(); kullanici.telefon = rdr["telefon"].ToString(); } } rdr.Close(); } catch (Exception e) { MessageBox.Show(e.ToString()); kullanici = null; } finally { sqlCommand.Connection.Close(); } return(kullanici); }