public bool editBranchImport(string idBranch, DateTime date, int branch, string IDAcc, int[] idpro, int[] quantity, string[] status) { db = new CMART1Entities1(); BranchImport branchImport = db.BranchImports.Single(st => st.IDBranchImport.Equals(idBranch)); List <BranchImport_List> branchList = branchImport.BranchImport_List.ToList(); try { branchImport.BranchDate = date; branchImport.Branch = branch; branchImport.IDAcc = IDAcc; db.SaveChanges(); foreach (BranchImport_List br in branchList) { db.BranchImport_List.Remove(br); db.SaveChanges(); } addBranchList(idBranch, idpro, quantity, status); return(true); } catch (Exception) { return(false); } }
public bool addBranchImport(string idHI, string idBranch, DateTime date, int branch, string IDAcc, int[] idpro, int[] quantity, string[] status) { int t = int.Parse(idBranch.Substring(8, 3)) + 1; string Month = date.Month.ToString(); string Date = date.Day.ToString(); if (Month.Length < 2) { Month = "0" + Month; } if (Date.Length < 2) { Date = "0" + Date; } string idnew = date.Year.ToString() + Month + Date; idnew = "BI" + idnew.Substring(2, 6); if (idnew == idHI.Substring(0, 8)) { for (int i = t.ToString().Length; i < 3; i++) { idnew = idnew + "0"; } idnew = idnew + t; } else { idnew = idnew + "001"; } BranchImport branchImport = new BranchImport(); try { branchImport.IDBranchImport = idnew; branchImport.IDHeadImport = idHI; branchImport.BranchDate = date; branchImport.Branch = branch; branchImport.IDAcc = IDAcc; db.BranchImports.Add(branchImport); db.SaveChanges(); addBranchList(idnew, idpro, quantity, status); return(true); } catch (Exception) { return(false); } }
public bool deleteBranchImport(string id) { db = new CMART1Entities1(); try { BranchImport branchImport = db.BranchImports.Single(st => st.IDBranchImport.Equals(id)); List <BranchImport_List> branchlist = branchImport.BranchImport_List.ToList(); foreach (BranchImport_List a in branchlist) { db.BranchImport_List.Remove(a); } db.BranchImports.Remove(branchImport); db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
private void button2_Click(object sender, EventArgs e) { if (lstBranch.SelectedRows.Count == 1) { i = 1; btnCancel.Text = "Cancel"; tabAdd.Text = "Edit"; string id = (string)lstBranch.SelectedRows[0].Cells[0].Value; CMART1Entities1 db = new CMART1Entities1(); BranchImport branch = db.BranchImports.Single(s => s.IDBranchImport.Equals(id)); dateTime.Value = branch.BranchDate.Value; txtIDHead.Text = branch.IDHeadImport; List <BranchImport_List> branch_list = branch.BranchImport_List.ToList(); foreach (BranchImport_List bi in branch_list) { Product pro = db.Products.Single(st => st.IDProduct.Equals(bi.IDProduct)); lstBranchPro.Rows.Add(branch.IDHeadImport, bi.IDProduct, pro.Name, bi.Quantity, bi.Status); } tabpage.SelectedIndex = 1; } }