private void btn_save_supllier_Click(object sender, EventArgs e)
{
try
{
Supplyer newSuppyer = new Supplyer();
foreach (var item in supproductlocalList)
{
newSuppyer.Name = item.Name;
newSuppyer.Phone = item.Phone;
newSuppyer.Address = item.Address;
storeContext.Supplyers.Add(newSuppyer);
storeContext.SaveChanges();
}
}
catch (Exception)
{
MessageBox.Show("هناك عميل موجود بالفعل ");
}
}
private void button2_Click(object sender, EventArgs e)
{
Supplyer sup = context.Supplyers.FirstOrDefault(s => s.Name == SupplyerCombo.Text);
SupplyerBill suppleyBill = new SupplyerBill()
{
supplyer_ID = sup.ID,
PaidPrice = 0,
DeptPrice = 0
};
context.SupplyerBills.Add(suppleyBill);
context.SaveChanges();
SupplyerBill supBill = context.SupplyerBills.OrderByDescending(s => s.ID).FirstOrDefault();
SupplyerBillDetail supplyerBDetails;
foreach (var item in supperList)
{
supplyerBDetails = new SupplyerBillDetail();
supplyerBDetails.Amount = item.Amount;
supplyerBDetails.Date = item.Date;
supplyerBDetails.Paid = 0;
supplyerBDetails.Debt = 0;
supplyerBDetails.AmountPrice = item.AmountPrice;
supplyerBDetails.productOpj_ID = item.productOpj_ID;
supplyerBDetails.AdeyMortagaType = item.AdeyMortagaType;
supplyerBDetails.SupplyerBillobj_ID = supBill.supplyer_ID;
context.SupplyerBillDetails.Add(supplyerBDetails);
Product UpdateProduct = context.Products.FirstOrDefault(p => p.ID == supplyerBDetails.productOpj_ID);
if (supplyerBDetails.AdeyMortagaType == "عادى")
{
UpdateProduct.AmountInStock = UpdateProduct.AmountInStock + supplyerBDetails.Amount;
}
if (supplyerBDetails.AdeyMortagaType == "مرتجع")
{
UpdateProduct.AmountInStock = UpdateProduct.AmountInStock - supplyerBDetails.Amount;
}
context.SaveChanges();
}
}