private void tbtnSale_Click(object sender, EventArgs e)
{
for (int i = 0; i < advBandedGridView1.RowCount; i++)
{
double total = Convert.ToDouble(advBandedGridView1.GetRowCellValue(i, "Total"));
if (total > 0)
{
int quantity = Convert.ToInt32(advBandedGridView1.GetRowCellValue(i, "Quantity"));
int id = Convert.ToInt32(advBandedGridView1.GetRowCellValue(i, "Id"));
DBLayer.Users.Details det = ((DBLayer.Users.Details)AppDomain.CurrentDomain.GetData("User"));
DBLayer.Sales.Details sDet = new FitnessProject.DBLayer.Sales.Details();
sDet.Date = this.Date1;
sDet.ProductId = id;
sDet.UserId = det.Id;
sDet.Quantity = quantity;
DBLayer.Sales.Insert(sDet);
}
}
MessageBox.Show("Изменения сохранены");
}
private void btnOk_Click(object sender, EventArgs e)
{
DBLayer.Sales.Details det = new FitnessProject.DBLayer.Sales.Details();
det.Date = DateTime.Now.Date;
det.ProductId = this.Product.Id;
det.Quantity = Convert.ToInt32(tbQuantity.Text);
det.Time = DateTime.Now.ToShortTimeString();
DBLayer.Users.Details detU = (DBLayer.Users.Details)AppDomain.CurrentDomain.GetData("User");
det.UserId = detU.Id;
DBLayer.Sales.Insert(det);
this.Close();
}
