private void save()
{
var db = new shampazEntities();
var factor = new SellFactor
{
Date = (DateTime)pdpDate.GeorgianDate + dtpTime.Value.TimeOfDay,
PersonId = SelectedPerson.Id,
TotalPrice = Convert.ToDecimal(txtTotalPrice.Text),
Description = txtDescription.Text,
};
db.SellFactors.Add(factor);
foreach (DataGridViewRow r in dgvItems.Rows)
{
factor.SellFactorItems.Add(
new SellFactorItem
{
Name = r.Cells["clnProductName"].Value.ToString(),
Numbers = Convert.ToInt32(r.Cells["clnNumber"].Value),
Price = Convert.ToDecimal(r.Cells["clnProductPrice"].Value),
ProductId = Convert.ToInt32(r.Cells["clnProductId"].Value),
TotalPrice = Convert.ToDecimal(r.Cells["clnTotalPrice"].Value),
}
);
}
db.SaveChanges();
DesktopAlert.Show("فاکتور ذخیره شد", eDesktopAlertColor.Green, eAlertPosition.BottomRight);
EditedSellFactor = factor;
}
private void update()
{
var db = new shampazEntities();
var factor = db.SellFactors.Where(x => x.Id == EditedSellFactor.Id).FirstOrDefault();
factor.Date = (DateTime)pdpDate.GeorgianDate + dtpTime.Value.TimeOfDay;
factor.PersonId = SelectedPerson.Id;
factor.TotalPrice = Convert.ToDecimal(txtTotalPrice.Text);
factor.Description = txtDescription.Text;
//MessageBox.Show(factor.Id.ToString());
db.SellFactorItems.RemoveRange(factor.SellFactorItems);
//foreach( var item in factor.SellFactorItems )
//{
// db.SellFactorItems.Remove(item);
// db.SaveChanges();
//}
foreach (DataGridViewRow r in dgvItems.Rows)
{
factor.SellFactorItems.Add(
new SellFactorItem
{
Name = r.Cells["clnProductName"].Value.ToString(),
Numbers = Convert.ToInt32(r.Cells["clnNumber"].Value),
Price = Convert.ToDecimal(r.Cells["clnProductPrice"].Value),
ProductId = Convert.ToInt32(r.Cells["clnProductId"].Value),
TotalPrice = Convert.ToDecimal(r.Cells["clnTotalPrice"].Value)
}
);
}
db.SaveChanges();
DesktopAlert.Show("فاکتور بروزرسانی شد", eDesktopAlertColor.Green, eAlertPosition.BottomRight);
EditedSellFactor = factor;
}
private void deleteFactor(SellFactor factor)
{
var db = new shampazEntities();
db.SaveChanges();
}
