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);
}
