private void BtImpEditPro_Click(object sender, EventArgs e) { var IdBill = Convert.ToInt16(DgvImp.CurrentRow.Cells["ID"].Value.ToString()); List <DetailImport> List = new List <DetailImport>(); for (int i = 0; i < DgvImpPro.RowCount; i++) { DetailImport Pro = new DetailImport(); var str = DgvImpPro.Rows[i].Cells["ID"].Value.ToString(); Pro.IDProduct = Convert.ToInt16(str); Pro.IDBill = IdBill; var Quan = DgvImpPro.Rows[i].Cells["Quantity"].Value.ToString(); Pro.Quantity = Convert.ToInt16(Quan); //var Detail = db.DetailImports.Where(p => p.IDBill == IdBill && p.IDProduct == IDProduct).SingleOrDefault(); List.Add(Pro); } var IDPro = Convert.ToInt16(DgvImpPro.CurrentRow.Cells["ID"].Value.ToString()); var result = db.Products.Find(IDPro); var ProImp = List.Where(p => p.IDBill == IdBill && p.IDProduct == IDPro).SingleOrDefault(); List.Remove(ProImp); DetailImport ImpPro = new DetailImport(); ImpPro.IDBill = IdBill; ImpPro.IDProduct = IDPro; string quan = TxtImpProQuan.Text; ImpPro.Quantity = Convert.ToInt16(quan); List.Add(ImpPro); LoadPro(List); }
private void BtImpDeletePro_Click(object sender, EventArgs e) { List <DetailImport> List = new List <DetailImport>(); var IdBill = DgvImp.CurrentRow.Cells["ID"].Value.ToString(); int Bill = Convert.ToInt16(IdBill); for (int i = 0; i < DgvImpPro.RowCount; i++) { DetailImport ImpPro = new DetailImport(); var str = DgvImpPro.Rows[i].Cells["ID"].Value.ToString(); ImpPro.IDProduct = Convert.ToInt16(str); ImpPro.IDBill = Bill; var quan = DgvImpPro.Rows[i].Cells["Quantity"].Value.ToString(); ImpPro.Quantity = Convert.ToInt16(quan); List.Add(ImpPro); } var IdPro = DgvImpPro.CurrentRow.Cells["ID"].Value.ToString(); int Pro = Convert.ToInt16(IdPro); var ProImp = List.Where(p => p.IDProduct == Pro).SingleOrDefault(); List.Remove(ProImp); LoadPro(List); TxtImpProCode.Clear(); TxtImpProName.Clear(); TxtImpProUnit.Clear(); TxtImpProQuan.Clear(); }
private void BtImpAddPro_Click(object sender, EventArgs e) { List <DetailImport> ListPro = new List <DetailImport>(); DetailImport ProImp = new DetailImport(); var Id = Convert.ToInt32(DgvImp.CurrentRow.Cells["ID"].Value.ToString()); for (int i = 0; i < DgvImpPro.RowCount; i++) { var str = DgvImpPro.Rows[i].Cells["ID"].Value.ToString(); var IDProduct = Convert.ToInt16(str); var Detail = db.DetailImports.Where(p => p.IDBill == Id && p.IDProduct == IDProduct).SingleOrDefault(); ListPro.Add(Detail); } var result = db.Products.Where(p => p.Code == TxtImpProCode.Text).SingleOrDefault(); if (result == null) { MessageBox.Show("There isn't this item in the storehouse, Click to add product"); return; } else { TxtImpProName.Text = result.Name; TxtImpProUnit.Text = result.Unit; CbImpProSup.SelectedValue = result.IdCom; ProImp.IDBill = Id; ProImp.IDProduct = result.ID; ProImp.Quantity = Convert.ToInt16(TxtImpProQuan.Text); ListPro.Add(ProImp); LoadPro(ListPro); } }
private void BtImpEdit_Click(object sender, EventArgs e) { var IdBill = DgvImp.CurrentRow.Cells["ID"].Value.ToString(); int ID = Convert.ToInt16(IdBill); var Bill = db.BillImports.Find(ID); Bill.IDCompany = Convert.ToInt16(CbImpSupplier.SelectedValue.ToString()); Bill.NameCustom = TxtImpDeliver.Text; var IDsto = Convert.ToInt16(TxtImpStoID.Text); Bill.IDStoreKeeper = IDsto; Bill.DateImport = DateImp.Value; if (MessageBox.Show("Do you want to save changes?", "", MessageBoxButtons.OKCancel) == DialogResult.OK) { var result = db.DetailImports.Where(p => p.IDBill == ID).ToList(); for (int i = 0; i < result.Count; i++) { db.DetailImports.Remove(result[i]); db.SaveChanges(); } for (int i = 0; i < DgvImpPro.RowCount; i++) { DetailImport Detail = new DetailImport(); Detail.IDBill = Bill.ID; Detail.IDProduct = Convert.ToInt16(DgvImpPro.Rows[i].Cells["ID"].Value.ToString()); var res = db.DetailImports.Where(p => p.IDBill == Detail.IDBill && p.IDProduct == Detail.IDProduct).SingleOrDefault(); if (res != null) { res.Quantity = res.Quantity + Convert.ToInt16(DgvImpPro.Rows[i].Cells["Quantity"].Value.ToString()); db.SaveChanges(); } else { Detail.Quantity = Convert.ToInt16(DgvImpPro.Rows[i].Cells["Quantity"].Value.ToString()); db.DetailImports.Add(Detail); db.SaveChanges(); } } db.SaveChanges(); LoadDgv(); LoadDetail(); LoadDgvPro(); LoadDetailPro(); } else { return; } }
private void BtImpCreate_Click(object sender, EventArgs e) { if (TxtImpStorekeeper.Text == "" || TxtImpDeliver.Text == "") { MessageBox.Show("Fill in all information"); return; } BillImport Bill = new BillImport(); Bill.IDCompany = Convert.ToInt16(CbImpSupplier.SelectedValue.ToString()); Bill.IDStoreKeeper = Medium.IdSto; Bill.NameCustom = TxtImpDeliver.Text; Bill.DateImport = DateImp.Value; db.BillImports.Add(Bill); db.SaveChanges(); for (int i = 0; i < DgvImpPro.RowCount; i++) { DetailImport Detail = new DetailImport(); Detail.IDBill = Bill.ID; Detail.IDProduct = Convert.ToInt16(DgvImpPro.Rows[i].Cells["ID"].Value.ToString()); var res = db.DetailImports.Where(p => p.IDBill == Detail.IDBill && p.IDProduct == Detail.IDProduct).SingleOrDefault(); if (res != null) { res.Quantity = res.Quantity + Convert.ToInt16(DgvImpPro.Rows[i].Cells["Quantity"].Value.ToString()); db.SaveChanges(); } else { Detail.Quantity = Convert.ToInt16(DgvImpPro.Rows[i].Cells["Quantity"].Value.ToString()); db.DetailImports.Add(Detail); db.SaveChanges(); } } MessageBox.Show("Add Item successfully"); LoadDgv(); LoadDetail(); LoadDgvPro(); LoadDetailPro(); }