private void AddProductBtn_Click(object sender, EventArgs e) { Product product = new Product(); product.P_Code = PCodeTxt.Text; product.Name = PNameTxt.Text; MeasurmentUnit measurmentUnit = new MeasurmentUnit(); foreach (var item in UnitscheckedListBox1.SelectedItems) { var query = db.MeasurmentUnits.First(u => u.Unit_Name == item.ToString()); measurmentUnit = query; measurmentUnit.Products.Add(product); } db.Products.Add(product); db.SaveChanges(); var query2 = db.Products.Select(i => new { i.P_Code, i.Name }); //foreach (var item in query2.ToList()[1].mus) //{ // MessageBox.Show(item.Unit_Name); //} ProductsGridView.DataSource = query2.ToList(); PNameTxt.Text = ""; PCodeTxt.Text = ""; }
private void AddInventoryBtn_Click(object sender, EventArgs e) { Inventory inventory = new Inventory(); inventory.ID = 0; inventory.Name = NameTxt.Text; inventory.Address = AddressTxt.Text; inventory.Admin = AdminTxt.Text; db.Inventories.Add(inventory); db.SaveChanges(); NameTxt.Text = ""; AddressTxt.Text = ""; AdminTxt.Text = ""; var query = db.Inventories.Select(i => new { i.ID, i.Name, i.Address, i.Admin }); InventoryGridView.DataSource = query.ToList(); }
private void AddAsCustomerBTn_Click(object sender, EventArgs e) { Customer_Suppliers customer = new Customer_Suppliers(); customer.Name = name.Text; customer.Phone = phone.Text; customer.Fax = Fax.Text; customer.Email = Email.Text; customer.Mobile = Mobile.Text; customer.Website = WebSite.Text; customer.IsCustomer = true; db.Customer_Suppliers.Add(customer); db.SaveChanges(); var q = db.Customer_Suppliers.Select(c => new { c.ID, c.Name, c.Phone, c.Fax, c.Mobile, c.Email, c.Website }); CUst_suppGrid.DataSource = q.ToList(); name.Text = ""; phone.Text = ""; Fax.Text = ""; Email.Text = ""; Mobile.Text = ""; WebSite.Text = ""; }
private void SwitchBtn_Click(object sender, EventArgs e) { string Frominventoryname = FromInventoryCBox.SelectedItem.ToString(); int FromInventoryid = db.Inventories.FirstOrDefault(a => a.Name == Frominventoryname).ID; string Targetinventoryname = TocomboBox1.SelectedItem.ToString(); int TargetInventoryid = db.Inventories.FirstOrDefault(a => a.Name == Targetinventoryname).ID; string SEdate = dateTimePicker3.Value.ToString("yyyy-MM-dd"); string Spdate = dateTimePicker2.Value.ToString("yyyy-MM-dd"); string supplier = SuppliercomboBox.SelectedItem.ToString(); int SID = db.Customer_Suppliers.FirstOrDefault(a => a.Name == supplier).ID; //list of int //var ListOfPermissions = db.Permissions.Where(a => a.Inventory_ID == FromInventoryid).Select(a => a.P_Number).ToList(); //List<int?> TotalQntyInInv = new List<int?>(); //foreach (var item in ListOfPermissions) //{ // var query = db.Permission_Products.FirstOrDefault(p => p.P_Number == item && p.P_Code == products[0] && p.Supplier_ID == SID && p.ProductionDate == Spdate && p.ExperationDate == SEdate).Quantity; // TotalQntyInInv.Add(query); //} //int? totalQnty = 0; //foreach (var item in TotalQntyInInv) //{ // totalQnty += item; //} //MessageBox.Show("The Totla Qnty Of This Product In this Invetory is = " + totalQnty); //7an mw3d el na2l //decrease el kmya from //ans add new permisiion to (done) //add in transfere table (done) int qntytomove = (int)numericUpDowns[0].Value; Transfere transfere = new Transfere(); transfere.id = 0; transfere.FromInventory = FromInventoryid; transfere.ToInventory = TargetInventoryid; transfere.P_Code = products[0]; transfere.TransfereDate = DateTime.Now.ToString("yyyy-MM-dd"); transfere.PDate = Spdate; transfere.EDate = SEdate; transfere.Qnty = qntytomove; transfere.supplierid = SID; db.Transferes.Add(transfere); db.SaveChanges(); Permission permission = new Permission(); permission.P_Number = 0; permission.P_Date = DateTime.Now; permission.Inventory_ID = TargetInventoryid; permission.Type = "Supply"; Permission_Products permission_Products = new Permission_Products(); permission_Products.P_Code = products[0]; permission_Products.Quantity = qntytomove; permission_Products.Supplier_ID = SID; permission_Products.ProductionDate = Spdate; permission_Products.ExperationDate = Spdate; permission.Permission_Products.Add(permission_Products); db.Permissions.Add(permission); db.SaveChanges(); bool flag = false; string bcode = ""; var ListOfPermissions1 = db.Permissions.Where(a => a.Inventory_ID == FromInventoryid).Select(a => a.P_Number).ToList(); foreach (var item in ListOfPermissions1) { bcode = products[0]; Permission_Products OldPermissionproducts = db.Permission_Products.FirstOrDefault(p => p.P_Number == item && p.P_Code == bcode && p.Supplier_ID == SID && p.ProductionDate == Spdate && p.ExperationDate == SEdate); if (OldPermissionproducts.Quantity >= qntytomove) { OldPermissionproducts.Quantity = OldPermissionproducts.Quantity - qntytomove; flag = true; break; } else { flag = false; } } if (flag == false) { // MessageBox.Show("The qnty is less than the target"); foreach (var item in ListOfPermissions1) { Permission_Products OldPermissionproducts = db.Permission_Products.FirstOrDefault(p => p.P_Number == item && p.P_Code == products[0] && p.Supplier_ID == SID && p.ProductionDate == Spdate && p.ExperationDate == SEdate); while (OldPermissionproducts.Quantity != 0 && qntytomove != 0) { OldPermissionproducts.Quantity--; qntytomove--; } } } db.SaveChanges(); }
private void AddBtn_Click(object sender, EventArgs e) { string inventoryname = InventoryCBox.SelectedItem.ToString(); string Type = Typecbox.SelectedItem.ToString(); string supplier = SuppliercomboBox.SelectedItem.ToString(); string customer = SuppliercomboBox.SelectedItem.ToString(); DateTime Date = dateTimePicker1.Value; string PDate = dateTimePicker2.Value.ToString("yyyy-MM-dd"); string EDate = dateTimePicker3.Value.ToString("yyyy-MM-dd"); int Inventoryid = db.Inventories.FirstOrDefault(a => a.Name == inventoryname).ID; int SID = db.Customer_Suppliers.FirstOrDefault(a => a.Name == supplier).ID; int CID = db.Customer_Suppliers.FirstOrDefault(a => a.Name == customer).ID; Permission permission = new Permission(); permission.P_Date = Date; permission.Inventory_ID = Inventoryid; permission.Type = Type; permission.P_Number = 0; db.Permissions.Add(permission); db.SaveChanges(); db.Entry(permission).GetDatabaseValues(); int Pid = permission.P_Number; // MessageBox.Show(Pid.ToString()); //Permission_Products permission_Products = new Permission_Products(); //permission_Products.Supplier_ID = SID; //if(Type== "Supply") //{ // permission_Products.ProductionDate = PDate; // permission_Products.ExperationDate = EDate; //} DateTime ConvertPDate = DateTime.ParseExact(PDate, "yyyy-MM-dd", null); DateTime ConvertEDate = DateTime.ParseExact(EDate, "yyyy-MM-dd", null); List <int> Qnty = new List <int>(); foreach (var item in numericUpDowns) { int x = (int)item.Value; Qnty.Add(x); } for (int i = 0; i < products.Count; i++) { Permission_Products permission_Products = new Permission_Products(); permission_Products.P_Number = Pid; permission_Products.P_Code = products[i]; // permission_Products.Supplier_ID = SID; permission_Products.Quantity = Qnty[i]; if (Type == "Supply") { permission_Products.Supplier_ID = SID; permission_Products.ProductionDate = PDate; permission_Products.ExperationDate = EDate; } else { permission_Products.Supplier_ID = CID; permission_Products.ProductionDate = null; permission_Products.ExperationDate = null; } db.Permission_Products.Add(permission_Products); } db.SaveChanges(); var Q4 = db.Permissions.Select(p => new { p.P_Number, p.P_Date, p.Inventory_ID, p.Type }); PermissinGrid.DataSource = Q4.ToList(); }