public int kaydetMusteri(Entities.MUSTERI musteri) { SqlConnection cnn = new SqlConnection(); cnn.ConnectionString = Settings.connectionString; SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandText = "INSERT INTO MUSTERI(AdiSoyadi,Telefonu,Adresi) values(@AdiSoyadi,@Telefonu,@Adresi)"; cmd.Parameters.Add("@AdiSoyadi", SqlDbType.VarChar, 50); cmd.Parameters.Add("@Telefonu", SqlDbType.VarChar, 16); cmd.Parameters.Add("@Adresi", SqlDbType.VarChar, 250); cmd.Parameters["@AdiSoyadi"].Value = musteri.AdiSoyadi; cmd.Parameters["@Telefonu"].Value = musteri.Telefonu; cmd.Parameters["@Adresi"].Value = musteri.Adresi; if (cnn.State == ConnectionState.Closed) { cnn.Open(); } int a = cmd.ExecuteNonQuery(); if (cnn.State == ConnectionState.Open) { cnn.Close(); } return(a); }
private void button5_Click(object sender, EventArgs e) { DataLogic.MUSTERI musteri = new DataLogic.MUSTERI(); Entities.MUSTERI d = new Entities.MUSTERI(); d.AdiSoyadi = textBox1.Text; d.Telefonu = textBox2.Text; d.Adresi = textBox3.Text; int a = -1; if (textBoxID.Text != "") //ID nin tutulduğu textBox { d.MusteriID = Convert.ToInt32(textBoxID.Text); a = musteri.guncelleMusteri(d); } else { a = musteri.kaydetMusteri(d); } if (a == 1) { MessageBox.Show("İşleminiz Gerçekleştirildi", "Satış Programı", MessageBoxButtons.OK, MessageBoxIcon.Information); temizle(); musterileriGetir(); } else { MessageBox.Show("İşleminiz Yapılamadı", "Satış Programı", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public int guncelleMusteri(Entities.MUSTERI musteri) { SqlConnection cnn = new SqlConnection(); cnn.ConnectionString = Settings.connectionString; SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandText = "Update MUSTERI set AdiSoyadi=@AdiSoyadi,Telefonu=@Telefonu,Adresi=@Adresi where MusteriID=@ID"; cmd.Parameters.Add("@AdiSoyadi", SqlDbType.VarChar, 50); cmd.Parameters.Add("@Telefonu", SqlDbType.VarChar, 16); cmd.Parameters.Add("@Adresi", SqlDbType.VarChar, 250); cmd.Parameters.Add("@ID", SqlDbType.Int); cmd.Parameters["@AdiSoyadi"].Value = musteri.AdiSoyadi; cmd.Parameters["@Telefonu"].Value = musteri.Telefonu; cmd.Parameters["@Adresi"].Value = musteri.Adresi; cmd.Parameters["@ID"].Value = musteri.MusteriID; if (cnn.State == ConnectionState.Closed) { cnn.Open(); } int a = cmd.ExecuteNonQuery(); if (cnn.State == ConnectionState.Open) { cnn.Close(); } return(a); }