public bool editHeadImport(string idHI, DateTime date, float Total, string IDAcc, int[] idpro, int[] quantity, double[] price, DateTime[] dateti, string[] status)
{
db = new CMART1Entities1();
HeadImport head = db.HeadImports.Single(st => st.IDHeadImport.Equals(idHI));
List <HeadImport_List> headlist = head.HeadImport_List.ToList();
try
{
head.IDAcc = IDAcc;
head.TotalAmount = Total;
db.SaveChanges();
foreach (HeadImport_List he in headlist)
{
db.HeadImport_List.Remove(he);
db.SaveChanges();
}
for (int i = 0; i < idpro.Length; i++)
{
HeadImport_List headli = new HeadImport_List();
headli.IDHeadImport = idHI;
headli.IDProduct = idpro[i];
headli.Quantity = quantity[i];
headli.Status = status[i];
headli.Price = price[i];
headli.Expiration = dateti[i];
db.HeadImport_List.Add(headli);
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool checkexistIDreandIDPro(string idHi, string idPro)
{
db = new CMART1Entities1();
bool flag = false;
try
{
int idPr = int.Parse(idPro);
HeadImport re = db.HeadImports.Single(st => st.IDHeadImport.Equals(idHi));
List <HeadImport_List> relist = re.HeadImport_List.ToList();
foreach (HeadImport_List pro in relist)
{
if (idPr == pro.IDProduct)
{
flag = true;
break;
}
}
return(flag);
}
catch (Exception)
{
return(false);
}
}
public bool addHeadImport(string idHI, string idRe, DateTime date, float Total, string IDAcc, int[] idpro, int[] quantity, double[] price, DateTime[] dateti, string[] status)
{
int t = int.Parse(idHI.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 = "HI" + 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";
}
HeadImport head = new HeadImport();
try
{
head.IDrequestImport = idRe;
head.IDHeadImport = idnew;
head.IDAcc = IDAcc;
head.HeadDate = date;
head.TotalAmount = Total;
db.HeadImports.Add(head);
db.SaveChanges();
addHeadList(idnew, idpro, quantity, price, dateti, status);
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool deleteHeadImport(string id)
{
db = new CMART1Entities1();
try
{
HeadImport headimport = db.HeadImports.Single(st => st.IDHeadImport.Equals(id));
List <HeadImport_List> headlist = headimport.HeadImport_List.ToList();
foreach (HeadImport_List a in headlist)
{
db.HeadImport_List.Remove(a);
}
db.HeadImports.Remove(headimport);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (list.SelectedRows.Count == 1)
{
i = 1;
btnEdit.Enabled = false;
btnCancel.Text = "Cancel";
tabAdd.Text = "Edit";
this.id = (string)list.SelectedRows[0].Cells[0].Value;
CMART1Entities1 db = new CMART1Entities1();
HeadImport head = db.HeadImports.Single(s => s.IDHeadImport.Equals(id));
dateTime.Value = head.HeadDate.Value;
txtIDRequest.Text = head.IDrequestImport;
lblTotalAmount.Text = head.TotalAmount.ToString();
List <HeadImport_List> head_list = head.HeadImport_List.ToList();
foreach (HeadImport_List bi in head_list)
{
Product pro = db.Products.Single(st => st.IDProduct.Equals(bi.IDProduct));
list2.Rows.Add(head.IDrequestImport, bi.IDProduct, pro.Name, bi.Quantity, bi.Price, bi.Expiration, bi.Status);
}
tabPage.SelectedIndex = 1;
calDetail();
}
}
