private void btnKaydet_Click(object sender, EventArgs e)
{
if (musteriIDsi == -1 || dtSatis.Rows.Count == 0) // hiçbir ürün yoksa sondaki
{
MessageBox.Show("Gerekli bilgileri doldurunuz!");
return;
}
Entities.SATIS d = new Entities.SATIS();
DataLogic.SATIS satis = new DataLogic.SATIS();
d.MusteriID = musteriIDsi;
d.Tarih = Convert.ToDateTime(dateTimePicker1.Value.ToShortDateString());
tutarBul();
d.ToplamTutar = genelTutar;
d.SorumluID = sorumluID;
if (satis.satisEkle(d, dtSatis) == 111)
{
MessageBox.Show("Başarıyla kaydedildi.");
a.Show();
this.Close();
}
}
public int satisEkle(Entities.SATIS d, DataTable dt)
{
SqlConnection cnn = new SqlConnection();
cnn.ConnectionString = Settings.connectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
SqlTransaction tr = cnn.BeginTransaction();
cmd.Transaction = tr;
cmd.CommandText = @"select ISNULL(MAX(SatisID), 0) from SATIS";
int satisID = Convert.ToInt32(cmd.ExecuteScalar()) + 1;
cmd.CommandText = "insert into SATIS(SatisID, Tarih, MusteriID, ToplamTutar, SorumluID) values " +
"(@SatisID, @Tarih, @MusteriID, @ToplamTutar, @SorumluID)";
cmd.Parameters.Add("@Tarih", SqlDbType.DateTime);
cmd.Parameters.Add("@MusteriID", SqlDbType.Int);
cmd.Parameters.Add("@ToplamTutar", SqlDbType.Decimal);
cmd.Parameters.Add("@SatisID", SqlDbType.Int);
cmd.Parameters.Add("@SorumluID", SqlDbType.Int);
cmd.Parameters["@Tarih"].Value = d.Tarih;
cmd.Parameters["@MusteriID"].Value = d.MusteriID;
cmd.Parameters["@ToplamTutar"].Value = d.ToplamTutar;
cmd.Parameters["@SatisID"].Value = satisID;
cmd.Parameters["@SorumluID"].Value = d.SorumluID;
int a = cmd.ExecuteNonQuery();
if (a != 1)
{
tr.Rollback();
return(-1);
}
cmd.Parameters.Clear();
cmd.CommandText = "insert into SATISDETAY (SatisID, UrunID, Miktar, BirimFiyat, Tutar) values" +
"(@SatisID, @UrunID, @Miktar, @BirimFiyat, @Tutar)";
cmd.Parameters.Add("@SatisID", SqlDbType.Int);
cmd.Parameters.Add("@UrunID", SqlDbType.Int);
cmd.Parameters.Add("@Miktar", SqlDbType.Decimal);
cmd.Parameters.Add("@BirimFiyat", SqlDbType.Decimal);
cmd.Parameters.Add("@Tutar", SqlDbType.Decimal);
for (int i = 0; i < dt.Rows.Count; i++)
{
cmd.Parameters["@SatisID"].Value = satisID;
cmd.Parameters["@UrunID"].Value = dt.Rows[i]["UrunID"];
cmd.Parameters["@Miktar"].Value = dt.Rows[i]["Miktar"];
cmd.Parameters["@BirimFiyat"].Value = dt.Rows[i]["BirimFiyat"];
cmd.Parameters["@Tutar"].Value = dt.Rows[i]["Tutar"];
a = cmd.ExecuteNonQuery();
if (a != 1)
{
tr.Rollback();
return(-1);
}
}
tr.Commit();
if (cnn.State == ConnectionState.Open)
{
cnn.Close();
}
return(111);
}
