private void button5_Click(object sender, EventArgs e)
{
try
{
int numberOfBillRepresentive;
RepresentitiveBill RpresentiveB = context.RepresentitiveBills.OrderByDescending(R => R.ID).FirstOrDefault();
if (RpresentiveB == null)
{
numberOfBillRepresentive = 1;
labelNumberBill.Text = numberOfBillRepresentive.ToString();
}
else
{
numberOfBillRepresentive = int.Parse(RpresentiveB.ID.ToString());
numberOfBillRepresentive++;
labelNumberBill.Text = numberOfBillRepresentive.ToString();
}
listView1.Clear();
comboBox1.Enabled = true;
numericUQouantity.Value = 0;
}
catch
{
}
}
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 sader_Load(object sender, EventArgs e)
{
List <Representitive> rep = context.Representitives.ToList();
comboBox1.DataSource = rep;
comboBox1.DisplayMember = "Name";
//-----------------displayNumber Of bill--------------
//--------number of bill representiv----------
int numberOfBill2;
RepresentitiveBill representivrB = context.RepresentitiveBills.OrderByDescending(r => r.ID).FirstOrDefault();
if (representivrB == null)
{
SqlConnection connection = new SqlConnection(@"Data Source=DESKTOP-9HH57Q0\MSSQLSEVEREX;Initial Catalog=project;Integrated Security=True");
SqlCommand command = new SqlCommand();
connection.Open();
command.Connection = connection;
command.CommandText = "DBCC CHECKIDENT ('RepresentitiveBills',RESEED,0)";
command.ExecuteNonQuery();
connection.Close();
numberOfBill2 = 1;
labelNumberBill.Text = numberOfBill2.ToString();
}
else
{
numberOfBill2 = int.Parse(representivrB.ID.ToString());
numberOfBill2++;
labelNumberBill.Text = numberOfBill2.ToString();
}
List <Product> ProductList = context.Products.ToList();
productComboSypplyer.DataSource = ProductList;
productComboSypplyer.DisplayMember = "Name";
}
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);
}
