//Them mot phieu nhap
public int InsertEnterCoupon(string pID, string pIdSup, string pIdStaff, string pUser, string pCreateDay, string pReson, string pTotal)
{
try
{
EnterCoupon check = db.EnterCoupons.Where(t => t.ID == Convert.ToInt32(pID)).FirstOrDefault();
if (check != null)
{
return(1);//Trung khoa chinh
}
else
{
EnterCoupon add = new EnterCoupon();
add.ID = int.Parse(pID);
add.IDSUPPLIER = int.Parse(pIdSup);
add.IDSTAFF = int.Parse(pIdStaff);
add.IDUSER = pUser;
add.CREATEDATE = Convert.ToDateTime(pCreateDay);
add.RESONENTER = pReson;
add.TOTAL = float.Parse(pTotal);
add.STATUS = 1;
db.EnterCoupons.InsertOnSubmit(add);
db.SubmitChanges();
return(2);//them thanh cong
}
}
catch
{
return(0);
}
}
//Cap nhat phieu nhap
public int UpdateEnterCoupon(string pID, string pIdSup, string pIdStaff, string pUser, string pCreateDay, string pReson, string pTotal)
{
try
{
EnterCoupon check = db.EnterCoupons.Where(t => t.ID == Convert.ToInt32(pID)).FirstOrDefault();
if (check != null)
{
check.IDSTAFF = int.Parse(pIdStaff);
check.IDSUPPLIER = int.Parse(pIdSup);
check.IDUSER = pUser;
check.CREATEDATE = Convert.ToDateTime(pCreateDay);
check.RESONENTER = pReson;
check.TOTAL = float.Parse(pTotal);
db.SubmitChanges();
return(1);
}
else
{
return(2);
}
}
catch
{
return(0);
}
}
//Xoa phieu nhap
public bool DeleteEnterCoupon(string pIdenter)
{
try
{
EnterCoupon check = db.EnterCoupons.Where(t => t.ID == int.Parse(pIdenter)).FirstOrDefault();
check.STATUS = 0;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
