public static List <EAdres> MusteriAdresListele(int p) { SqlCommand cmd = new SqlCommand("sp_MusteriAdresListele", baglanti.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mID", p); baglanti.conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); List <EAdres> aListe = new List <EAdres>(); while (dr.Read()) { EAdres a = new EAdres(); a.ID = Convert.ToInt32(dr["ID"].ToString()); a.CustomerID = Convert.ToInt32(dr["CustomerID"].ToString()); a.AddressName = dr["AddressName"].ToString(); a.Firstname = dr["Firstname"].ToString(); a.Lastname = dr["Lastname"].ToString(); a.City = dr["City"].ToString(); a.Town = dr["Town"].ToString(); a.PostalCode = Convert.ToInt32(dr["PostalCode"].ToString()); a.Address = dr["Address"].ToString(); aListe.Add(a); } dr.Close(); baglanti.conn.Close(); return(aListe); }
public static EAdres AdresBul(int aID) { SqlCommand cmd = new SqlCommand("sp_AdresBul", baglanti.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@aID", aID); baglanti.conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); EAdres a = new EAdres(); while (dr.Read()) { a.ID = Convert.ToInt32(dr["ID"].ToString()); a.CustomerID = Convert.ToInt32(dr["CustomerID"].ToString()); a.AddressName = dr["AddressName"].ToString(); a.Firstname = dr["Firstname"].ToString(); a.Lastname = dr["Lastname"].ToString(); a.City = dr["City"].ToString(); a.Town = dr["Town"].ToString(); a.PostalCode = Convert.ToInt32(dr["PostalCode"].ToString()); a.Address = dr["Address"].ToString(); } dr.Close(); baglanti.conn.Close(); return(a); }
private void lviAdresler_MouseDoubleClick(object sender, MouseEventArgs e) { aID = Convert.ToInt32(lviAdresler.SelectedItems[0].SubItems[0].Text); EAdres a = BLLAdres.AdresBul(aID); lblAdresAdi.Text = a.AddressName; }
private void btnSil_Click(object sender, EventArgs e) { EAdres a = BLLAdres.AdresBul(aID); string cevap = BLLAdres.Sil(a); MessageBox.Show(cevap); Doldur(); }
public static void Sil(EAdres a) { SqlCommand cmd = new SqlCommand("sp_AdresSil", baglanti.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@aID", a.ID); baglanti.conn.Open(); cmd.ExecuteNonQuery(); baglanti.conn.Close(); }
private void frmAdresDetay_Load(object sender, EventArgs e) { EAdres a = BLLAdres.AdresBul(BLLSiparis.SiparisBul(Form1.sID).AddressID); lblAd.Text = a.Firstname; lblSoyad.Text = a.Lastname; lblil.Text = a.City; lblilce.Text = a.Town; lblPostaKodu.Text = a.PostalCode.ToString(); lblAdres.Text = a.Address; }
private void frmAdresDuzenle_Load(object sender, EventArgs e) { a = BLLAdres.AdresBul(frmAdresListele.aID); lblKullanici.Text = BLLMusteri.MusteriBul(a.CustomerID).Username; txtAdresAdi.Text = a.AddressName; txtAliciAdi.Text = a.Firstname; txtAliciSoyadi.Text = a.Lastname; txtil.Text = a.City; txtilce.Text = a.Town; txtPostaKodu.Text = a.PostalCode.ToString(); txtAdres.Text = a.Address; }
public static string Duzenle(EAdres a) { if (a.ID <= 0 || a.AddressName == "" || a.Firstname == "" || a.Lastname == "" || a.City == "" || a.Town == "" || a.PostalCode <= 0 || a.Address == "") { return("Hatalı işlem..."); } else { DALAdres.Duzenle(a); return("Düzenlendi..."); } }
public static string Sil(EAdres a) { if (a.ID > 0) { DALAdres.Sil(a); return("Silindi"); } else { return("Hatalı işlem..."); } }
public static string Ekle(EAdres a) { if (a.CustomerID > 0 && a.AddressName != "" && a.Firstname != "" && a.Lastname != "" && a.City != "" && a.Town != "" && a.PostalCode > 0 && a.Address != "") { if (DALAdres.Ekle(a) > 0) { return("Eklendi..."); } else { return("Aynı adres isminden var, farklı bir isim giriniz..."); } } return("Hatalı işlem..."); }
public static void Duzenle(EAdres a) { SqlCommand cmd = new SqlCommand("sp_AdresDuzenle", baglanti.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", a.ID); cmd.Parameters.AddWithValue("@adresAdi", a.AddressName); cmd.Parameters.AddWithValue("@aliciAdi", a.Firstname); cmd.Parameters.AddWithValue("@aliciSoyadi", a.Lastname); cmd.Parameters.AddWithValue("@il", a.City); cmd.Parameters.AddWithValue("@ilce", a.Town); cmd.Parameters.AddWithValue("@postaKodu", a.PostalCode); cmd.Parameters.AddWithValue("@adres", a.Address); baglanti.conn.Open(); cmd.ExecuteNonQuery(); baglanti.conn.Close(); }
public static int Ekle(EAdres a) { SqlCommand cmd = new SqlCommand("sp_AdresEkle", baglanti.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mID", a.CustomerID); cmd.Parameters.AddWithValue("@adresAdi", a.AddressName); cmd.Parameters.AddWithValue("@mAdi", a.Firstname); cmd.Parameters.AddWithValue("@mSoyadi", a.Lastname); cmd.Parameters.AddWithValue("@il", a.City); cmd.Parameters.AddWithValue("@ilce", a.Town); cmd.Parameters.AddWithValue("@postaKodu", a.PostalCode); cmd.Parameters.AddWithValue("@adres", a.Address); baglanti.conn.Open(); int sayi = cmd.ExecuteNonQuery(); baglanti.conn.Close(); return(sayi); }
private void btnKaydet_Click(object sender, EventArgs e) { EAdres a = new EAdres(); a.CustomerID = m.ID; a.AddressName = txtAdresAdi.Text; a.Firstname = txtAliciAdi.Text; a.Lastname = txtAliciSoyadi.Text; a.City = txtil.Text; a.Town = txtilce.Text; a.PostalCode = Convert.ToInt32(txtPostaKodu.Text); a.Address = txtAdres.Text; string cevap = BLLAdres.Ekle(a); MessageBox.Show(cevap); frmAdresListele f = Application.OpenForms["frmAdresListele"] as frmAdresListele; f.Doldur(); }