private void rpresentiveCombo_SelectedIndexChanged_1(object sender, EventArgs e)
{
x = (Representitive)rpresentiveCombo.SelectedItem;
string repName = rpresentiveCombo.SelectedItem.ToString();
var y = context.RepresentitiveBillDetails
.Where(p => p.RepresentitiveBill.Representitive_NationalID == x.NationalID);
List <Product> ProductList = new List <Product>();
foreach (var item in y)
{
Product ProdcutOfRep = context.Products.FirstOrDefault(p => p.ID == item.ProductObj_ID);
ProductList.Add(ProdcutOfRep);
}
// productComboFromRepresentive.DataSource= ProductList;//بتوع المندوب
// productComboFromRepresentive.DisplayMember = "Name";
}
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 btn_save_reps_Click(object sender, EventArgs e)
{
try
{
Representitive newRepres = new Representitive();
foreach (var item in supproductlocalList)
{
newRepres.Name = item.Name;
newRepres.NationalID = item.NationalId;
newRepres.Phone = item.Phone;
newRepres.Salary = item.salary;
newRepres.TargetSale = item.TargetSale;
storeContext.Representitives.Add(newRepres);
storeContext.SaveChanges();
}
}
catch (Exception)
{
MessageBox.Show("هناك مندوب موجود بالفعل ");
}
}
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;
}
}
private void button3_Click_2(object sender, EventArgs e)
{
Product ChechProduct = null;
if (TypeBillCombo.Text == "جملة")
{
ChechProduct = ChechProduct = context.Products.FirstOrDefault(p => p.Name == productComboFromRepresentive.Text);
priceType = ChechProduct.WholesalePrice;
}
if (TypeBillCombo.Text == "قطاعى")
{
ChechProduct = ChechProduct = context.Products.FirstOrDefault(p => p.Name == productComboFromRepresentive.Text);
priceType = ChechProduct.RetailPrice;
}
if (MortagaAdeyCombo.Text == "عادى")
{
double price = int.Parse(numericUQouantity.Value.ToString()) * priceType;
totalPrice += price;
lapelTotalPrice.Text = totalPrice.ToString();
lapelTotalPrice.Visible = true;
}
superItem = new supproductlocal();
// string RepresentiveName = null;
if (TypeBillCombo.SelectedIndex == -1)
{
MessageBox.Show("لابد من ادخال نوع الفاتوره اولا"); return;
}
// if (labelRepresentitve.Text == "")
//{
LabelTypeOfBill.Visible = true;
LabelTypeOfBill.Text = TypeBillCombo.Text;
TypeBillCombo.Visible = false;
// }
if (rpresentiveCombo.SelectedIndex == -1)
{
MessageBox.Show("لابد من أدخال أسم المندوب اولا"); return;
}
// if (.Text == "")
// {
//RepresentiveName= rpresentiveCombo.Text;
labelRepresentitve.Visible = true;
labelRepresentitve.Text = rpresentiveCombo.Text;
rpresentiveCombo.Visible = false;
// }
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();
if (y != null)
{
if (MortagaAdeyCombo.Text == "عادى")
{
if (int.Parse(numericUQouantity.Value.ToString()) > int.Parse(y.GivenAmount.ToString()))
{
MessageBox.Show("الكميه غير متاحه عند المندوب"); return;
}
}
}
//------------------add to list View---------------------------
Product productAdd = context.Products.FirstOrDefault(p => p.Name == productComboFromRepresentive.Text);
int GAmount = int.Parse(numericUQouantity.Text);
//check if قطاعى else جملة from combo
double amountPrice = 0;
if (TypeBillCombo.Text == "قطاعى")
{
amountPrice = productAdd.RetailPrice * GAmount;
}
else if (TypeBillCombo.Text == "جملة")
{
amountPrice = productAdd.WholesalePrice * GAmount;
totalPrice = amountPrice;
}
ListViewItem items = new ListViewItem(numericUQouantity.Value.ToString(), 0);
items.SubItems.Add(DateTime.Now.ToString());
items.SubItems.Add(amountPrice.ToString());
items.SubItems.Add(productComboFromRepresentive.Text);
items.SubItems.Add(MortagaAdeyCombo.Text);
listView1.Items.AddRange(new ListViewItem[] { items });
var product = context.Products.FirstOrDefault(p => p.Name == productComboFromRepresentive.Text);
//----------------------mapping---------------
var representitve = context.Representitives.FirstOrDefault(r => r.Name == rpresentiveCombo.Text);
RepresentitiveBill repAdded = context.RepresentitiveBills.FirstOrDefault(r => r.Representitive_NationalID == representitve.NationalID);
superItem.Amount = double.Parse(numericUQouantity.Value.ToString());
superItem.Date = DateTime.Now;
superItem.AmountPrice = amountPrice;
superItem.ProductOpj_ID = product.ID;
superItem.Type = TypeBillCombo.Text;
superItem.AdeyMortagaType = MortagaAdeyCombo.Text;
superItem.RepresentitiveBillObj_ID = repAdded.ID;
supperList.Add(superItem);
}