private void button2_Click(object sender, EventArgs e) { 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); pro.AmountInStock = pro.AmountInStock - item.GivenAmount; context.SaveChanges(); } }
private void button5_Click(object sender, EventArgs e) { 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; }
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"; }