private void BtnEdit_Click(object sender, EventArgs e) { WareHouseSupplier Sup = new WareHouseSupplier(); WareHouseItem wareHouseItem = new WareHouseItem(); var ItemInfo = db.Items.Where(S => S.Name == comboBox1.Text).FirstOrDefault(); var supplierInfo = db.Suppliers.Where(S => S.Name == comboBox2.Text).FirstOrDefault(); var WareHouseInfo = db.WareHouses.Where(S => S.Name == comboBox3.Text).FirstOrDefault(); Sup = db.WareHouseSuppliers.SingleOrDefault(s => s.id == Id); Sup.IdItem = ItemInfo.ID; Sup.IdSupplier = supplierInfo.Id; Sup.IdWareHouse = WareHouseInfo.Id; wareHouseItem.IdWareHouse = WareHouseInfo.Id; wareHouseItem.Quantity = int.Parse(TBQuantity.Text); wareHouseItem.IdItem = ItemInfo.ID; Sup.Quantity = int.Parse(TBQuantity.Text); Sup.LicenseNum = int.Parse(TBPermitNUM.Text); Sup.LicenseDate = LicenseDate.Value; db.SaveChanges(); MessageBox.Show("Done"); this.Close(); _formPermission.ListOfSupplyPermission.DataSource = db.WareHouseSuppliers.Select(P => new { P.id, P.IdItem, P.IdSupplier, P.IdWareHouse, P.LicenseDate, P.LicenseNum, P.Quantity }).ToList(); }
private void BtnAdd_Click(object sender, EventArgs e) { WareHouseSupplier Sperm = new WareHouseSupplier(); //|| CBCust.SelectedItem == null || CBItems.SelectedItem == null || CBStore.SelectedItem == null || CBSupplier.SelectedItem == null WareHouseItem store = new WareHouseItem(); var itemInfo = ENT.Items.Where(r => r.Name == (string)comboBox1.SelectedItem).SingleOrDefault(); var supplierInfo = ENT.Suppliers.Where(r => r.Name == (string)comboBox2.SelectedItem).SingleOrDefault(); var storeInfo = ENT.WareHouses.Where(r => r.Name == (string)comboBox3.SelectedItem).SingleOrDefault(); try { if (string.IsNullOrWhiteSpace(TBQuantity.Text) || string.IsNullOrWhiteSpace(TBPermitNUM.Text)) { MessageBox.Show("Please Complete empty Field"); } else if (Convert.ToInt32(TBQuantity.Text) > itemInfo.Quantity) { MessageBox.Show("this Quantity Greater than item Quantity"); } else { Sperm.IdItem = itemInfo.ID; Sperm.IdSupplier = supplierInfo.Id; Sperm.IdWareHouse = storeInfo.Id; store.IdItem = itemInfo.ID; store.IdWareHouse = storeInfo.Id; Sperm.LicenseDate = LicenseDate.Value; //permission date store.Quantity = Convert.ToInt32(TBQuantity.Text); Sperm.Quantity = Convert.ToInt32(TBQuantity.Text); var quantity = itemInfo.Quantity - Convert.ToInt32(TBQuantity.Text); itemInfo.Quantity = quantity; Sperm.LicenseNum = Convert.ToInt32(TBPermitNUM.Text); ENT.WareHouseSuppliers.Add(Sperm); ENT.WareHouseItems.Add(store); ENT.SaveChanges(); MessageBox.Show("Done"); comboBox1.Items.Clear(); comboBox2.Items.Clear(); comboBox3.Items.Clear(); TBQuantity.Text = string.Empty; TBPermitNUM.Text = string.Empty; ListOfSupplyPermission.DataSource = ENT.WareHouseSuppliers.Select(P => new { P.id, P.IdItem, P.IdSupplier, P.IdWareHouse, P.LicenseDate, P.LicenseNum, P.Quantity }).ToList(); } } catch (Exception) { MessageBox.Show("Please Invalid Inputs"); } }
private void EditSupPermission_Load(object sender, EventArgs e) { WareHouseSupplier item = new WareHouseSupplier(); item = db.WareHouseSuppliers.SingleOrDefault(s => s.id == Id); comboBox1.Text = item.Item.Name; comboBox2.Text = item.Supplier.Name.ToString(); comboBox3.Text = item.WareHouse.Name; TBQuantity.Text = item.Quantity.ToString(); TBPermitNUM.Text = item.LicenseNum.ToString(); LicenseDate.Value = item.LicenseDate.Value; }
private void button1_Click(object sender, EventArgs e) { var itemInfo = db.Items.Where(r => r.Name == (string)CBItems.SelectedItem).SingleOrDefault(); var supplierInfo = db.Suppliers.Where(r => r.Name == (string)CBSupplier.SelectedItem).SingleOrDefault(); var storeInfoFrom = db.WareHouses.Where(r => r.Name == (string)CBFrom.SelectedItem).SingleOrDefault(); var storeInfoTo = db.WareHouses.Where(r => r.Name == (string)CBTo.SelectedItem).SingleOrDefault(); WareHouseItem Item = new WareHouseItem(); WareHouseSupplier Supplier = new WareHouseSupplier(); Item items = new Item(); var wareHouseItems = db.WareHouseItems.Where(r => r.IdWareHouse == storeInfoFrom.Id).SingleOrDefault(); var wareHouseSupplier = db.WareHouseSuppliers.Where(r => r.IdWareHouse == storeInfoFrom.Id).SingleOrDefault(); // items transfare wareHouseSupplier.IdItem = itemInfo.ID; wareHouseItems.IdItem = itemInfo.ID; // Quantity Transfar wareHouseItems.Quantity = Convert.ToInt32(TBQuntity.Text); wareHouseSupplier.Quantity = Convert.ToInt32(TBQuntity.Text); // supplier Transfare wareHouseSupplier.IdSupplier = supplierInfo.Id; // date wareHouseSupplier.LicenseDate = date.Value; // EXP items.EXP = Convert.ToInt32(TBEXP.Text); // store transfare wareHouseSupplier.IdWareHouse = storeInfoTo.Id; wareHouseItems.IdWareHouse = storeInfoTo.Id; db.SaveChanges(); MessageBox.Show("Done"); }