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;
}
}
