private void button2_Click(object sender, EventArgs e)
{
try
{
comboBox1.Enabled = false;
RepresentitiveBillDetail newRepresentiveBd = new RepresentitiveBillDetail();
Representitive NameRep = (Representitive)comboBox1.SelectedItem;
Representitive rep = context.Representitives.FirstOrDefault(r => r.Name == NameRep.Name);
RepresentitiveBill newRepresentitveBill = new RepresentitiveBill()
{
Representitive_NationalID = rep.NationalID
};
context.RepresentitiveBills.Add(newRepresentitveBill);
context.SaveChanges();
RepresentitiveBill RepresentitveBillJustAdded = context.RepresentitiveBills.OrderByDescending(r => r.ID).FirstOrDefault();
foreach (var item in supproductlocalList)
{
newRepresentiveBd.GivenAmount = item.GivenAmount;
newRepresentiveBd.Date = item.Date;
newRepresentiveBd.ProductObj_ID = item.ProductObj_ID;
newRepresentiveBd.GivenAmountPrice = item.GivenAmountPrice;
newRepresentiveBd.RepresentitiveBillObj_ID = RepresentitveBillJustAdded.ID;
context.RepresentitiveBillDetails.Add(newRepresentiveBd);
context.SaveChanges();
Product pro = context.Products.FirstOrDefault(p => p.ID == item.ProductObj_ID);
if (pro.AmountInStock > item.GivenAmount)
{
pro.AmountInStock = pro.AmountInStock - item.GivenAmount;
context.SaveChanges();
}
else
{
MessageBox.Show("الكمية المطلوبة أكبر من الكمية الموجوده فى المخزن");
}
}
supproductlocalList.Clear();
}
catch
{
}
}
private void button2_Click(object sender, EventArgs e)
{
//compoOfClients.Enabled = false;
//RepresentitiveBillDetail newRepresentiveBd = new RepresentitiveBillDetail();
//ClientBill CLientBillJustAdded = context.ClientBills.OrderByDescending(r => r.ID).FirstOrDefault();
//ClientBillDetail clientBDetails = new ClientBillDetail();
//double totalPrice = 0;
//string trypeClientBill = null;
//foreach (var item in supperList)
//{
// clientBDetails.Amount = item.Amount;
// clientBDetails.Date = item.Date;
// clientBDetails.Type = item.Type;
// trypeClientBill = item.Type;
// clientBDetails.AmountPrice = item.AmountPrice;
// clientBDetails.Paid = 0;
// clientBDetails.Debt = 0;
// clientBDetails.ClientBillObj_ID = CLientBillJustAdded.ID;
// clientBDetails.ProductOpj_ID = item.ProductOpj_ID;
// clientBDetails.AdeyMortagaType = item.AdeyMortagaType;
// context.ClientBillDetails.Add(clientBDetails);
// totalPrice = totalPrice + clientBDetails.AmountPrice;
// ClientBillDetail ClientBillJustAdded = context.ClientBillDetails.OrderByDescending(cB => cB.ID).FirstOrDefault();
// x = (Representitive)rpresentiveCombo.SelectedItem;
// var prdN = productComboFromRepresentive.Text.ToString();
// var prd = context.Products.Where(n => n.Name == prdN).FirstOrDefault();
// //amount of representitveBillDetails
// var y = context.RepresentitiveBillDetails
// .Where(p => p.RepresentitiveBill.Representitive_NationalID == x.NationalID && p.ProductObj_ID == prd.ID).FirstOrDefault();
// clientBDetails.RepresentitiveBillDetailsObj_ID = y.ID;
// ClientBillDetail cUpdated = context.ClientBillDetails.OrderByDescending(c => c.ID).FirstOrDefault();
// // cUpdated.RepresentitiveBillDetail.GivenAmount = cUpdated.RepresentitiveBillDetail.GivenAmount - item.Amount;
// //context.SaveChanges();
// RepresentitiveBillDetail rebDeta = context.RepresentitiveBillDetails.FirstOrDefault(r => r.ID == cUpdated.RepresentitiveBillDetailsObj_ID);
// if (rebDeta.GivenAmount > 0 && MortagaAdeyCombo.SelectedItem.ToString() == "عادى")
// {
// rebDeta.GivenAmount = rebDeta.GivenAmount + item.Amount;
// }
// else
// {
// prd.AmountInStock = prd.AmountInStock + item.Amount;
// }
// context.SaveChanges();
//}
//Client ClientObj = (Client)compoOfClients.SelectedItem;
////Representitive rep = context.Clients.FirstOrDefault(r => r.Name == NameRep.Name);
//double paid = int.Parse(PaidNumericUpdown.Value.ToString());
//double deptPrice = totalPrice - paid;
//ClientBill NewClientBill = new ClientBill()
//{
// ClientObj_NationalID = ClientObj.NationalID,
// TotalPrice = totalPrice,
// type = trypeClientBill,
// PaidPrice = paid,
// DeptPrice = deptPrice
//};
////lapelTotalPrice.Text = totalPrice.ToString();
////lapelTotalPrice.Visible = true;
//if (flag == true)
//{
// context.ClientBills.Add(NewClientBill);
// context.SaveChanges();
// flag = false;
//}
compoOfClients.Enabled = false;
RepresentitiveBillDetail newRepresentiveBd = new RepresentitiveBillDetail();
Client ClientSelected = context.Clients.FirstOrDefault(c => c.Name == compoOfClients.Text);
ClientBill clientBilld = new ClientBill()
{
ClientObj_NationalID = ClientSelected.NationalID,
type = TypeBillCombo.Text,
};
context.ClientBills.Add(clientBilld);
context.SaveChanges();
ClientBill CLientBillJustAdded = context.ClientBills.OrderByDescending(r => r.ID).FirstOrDefault();
ClientBillDetail clientBDetails = new ClientBillDetail();
double totalPrice = 0;
string trypeClientBill = null;
foreach (var item in supperList)
{
clientBDetails.Amount = item.Amount;
clientBDetails.Date = item.Date;
clientBDetails.Type = item.Type;
trypeClientBill = item.Type;
clientBDetails.AmountPrice = item.AmountPrice;
clientBDetails.Paid = 0;
clientBDetails.Debt = 0;
clientBDetails.ClientBillObj_ID = CLientBillJustAdded.ID;
clientBDetails.ProductOpj_ID = item.ProductOpj_ID;
clientBDetails.AdeyMortagaType = item.AdeyMortagaType;
context.ClientBillDetails.Add(clientBDetails);
totalPrice = totalPrice + clientBDetails.AmountPrice;
ClientBillDetail ClientBillJustAdded = context.ClientBillDetails.OrderByDescending(cB => cB.ID).FirstOrDefault();
x = (Representitive)rpresentiveCombo.SelectedItem;
var prdN = productComboFromRepresentive.Text.ToString();
var prd = context.Products.Where(n => n.Name == prdN).FirstOrDefault();
//amount of representitveBillDetails
var y = context.RepresentitiveBillDetails
.Where(p => p.RepresentitiveBill.Representitive_NationalID == x.NationalID && p.ProductObj_ID == prd.ID).FirstOrDefault();
clientBDetails.RepresentitiveBillDetailsObj_ID = y.ID;
ClientBillDetail cUpdated = context.ClientBillDetails.OrderByDescending(c => c.ID).FirstOrDefault();
// cUpdated.RepresentitiveBillDetail.GivenAmount = cUpdated.RepresentitiveBillDetail.GivenAmount - item.Amount;
//context.SaveChanges();
RepresentitiveBillDetail rebDeta = context.RepresentitiveBillDetails.FirstOrDefault(r => r.ID == cUpdated.RepresentitiveBillDetailsObj_ID);
if (rebDeta.GivenAmount > 0 && MortagaAdeyCombo.SelectedItem.ToString() == "عادى")
{
rebDeta.GivenAmount = rebDeta.GivenAmount - item.Amount;
}
else
{
prd.AmountInStock = prd.AmountInStock + item.Amount;
}
context.SaveChanges();
}
Client ClientObj = (Client)compoOfClients.SelectedItem;
//Representitive rep = context.Clients.FirstOrDefault(r => r.Name == NameRep.Name);
double paid = int.Parse(PaidNumericUpdown.Value.ToString());
double deptPrice = totalPrice - paid;
ClientBill NewClientBill = new ClientBill()
{
ClientObj_NationalID = ClientObj.NationalID,
TotalPrice = totalPrice,
type = trypeClientBill,
PaidPrice = paid,
DeptPrice = deptPrice
};
//lapelTotalPrice.Text = totalPrice.ToString();
//lapelTotalPrice.Visible = true;
if (flag == true)
{
context.ClientBills.Add(NewClientBill);
context.SaveChanges();
flag = false;
}
}
