private void update()
{
var db = new shampazEntities();
var factor = db.BuyFactors.Where(x => x.Id == EditedFactor.Id).FirstOrDefault();
factor.Date = (DateTime)pdpDate.GeorgianDate + dtpTime.Value.TimeOfDay;
factor.PersonId = SelectedPerson.Id;
factor.TotalPrice = Convert.ToDecimal(txtTotalPrice.Text);
factor.Description = txtDescription.Text;
try
{
factor.PaymentPrice = Convert.ToDecimal(txtPayment.Text);
}
catch
{
factor.PaymentPrice = 0;
}
//MessageBox.Show(factor.Id.ToString());
db.BuyFactorItems.RemoveRange(factor.BuyFactorItems);
//foreach( var item in factor.SellFactorItems )
//{
// db.SellFactorItems.Remove(item);
// db.SaveChanges();
//}
foreach (DataGridViewRow r in dgvItems.Rows)
{
factor.BuyFactorItems.Add(
new BuyFactorItem
{
Name = r.Cells["clnProductName"].Value.ToString(),
Quantity = Convert.ToDouble(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);
EditedFactor = factor;
}
private void save()
{
var db = new shampazEntities();
decimal paymentPrice;
try
{
paymentPrice = Convert.ToDecimal(txtPayment.Text);
} catch
{
paymentPrice = 0;
}
var factor = new BuyFactor
{
Date = (DateTime)pdpDate.GeorgianDate + dtpTime.Value.TimeOfDay,
PersonId = SelectedPerson.Id,
TotalPrice = Convert.ToDecimal(txtTotalPrice.Text),
Description = txtDescription.Text,
PaymentPrice = paymentPrice,
};
db.BuyFactors.Add(factor);
foreach (DataGridViewRow r in dgvItems.Rows)
{
var ProductId = Convert.ToInt32(r.Cells["clnProductId"].Value);
factor.BuyFactorItems.Add(
new BuyFactorItem
{
Name = r.Cells["clnProductName"].Value.ToString(),
Quantity = Convert.ToDouble(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);
EditedFactor = factor;
}
