//Sua chi tiet pn
public bool SuaCTNP(int pMaPN, int pMaSp, double pDonGia, int pNum)
{
try
{
detail_receipt_import check = _Coffee.detail_receipt_imports.Where(t => t.ID_RECEIPT_IMPORT.Equals(pMaPN) && t.ID_ITEM.Equals(pMaSp)).FirstOrDefault();
if (check != null)
{
int numchang = pNum - check.NUMBER;
check.ID_ITEM = pMaSp;
check.NUMBER = pNum;
check.PRICE_PURCHASE = pDonGia;
dll.UpdateNumber(pMaSp, numchang);
_Coffee.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
//them moi chi tiet phieu nhap
public bool ThemMoiCTPN(int pMaPN, int pMaSp, double pDonGia, int pNum)
{
try
{
detail_receipt_import check = _Coffee.detail_receipt_imports.Where(t => t.ID_RECEIPT_IMPORT.Equals(pMaPN) && t.ID_ITEM.Equals(pMaSp)).FirstOrDefault();
if (check != null)
{
return(false);
}
else
{
detail_receipt_import add = new detail_receipt_import();
add.ID_RECEIPT_IMPORT = pMaPN;
add.ID_ITEM = pMaSp;
add.PRICE_PURCHASE = pDonGia;
add.NUMBER = pNum;
_Coffee.detail_receipt_imports.InsertOnSubmit(add);
_Coffee.SubmitChanges();
return(true);
}
}
catch
{
return(false);
}
}
//Cap nhat ctpn
public bool CapNhatCTPN(int pMaPN, int pMaSp, int pNum)
{
try
{
detail_receipt_import check = _Coffee.detail_receipt_imports.Where(t => t.ID_RECEIPT_IMPORT.Equals(pMaPN) && t.ID_ITEM.Equals(pMaSp)).FirstOrDefault();
check.NUMBER = pNum;
_Coffee.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
//Xoa chi tiet pn
public bool XoaCTNP(int pMaPN, int pMaSp)
{
try
{
detail_receipt_import check = _Coffee.detail_receipt_imports.Where(t => t.ID_RECEIPT_IMPORT.Equals(pMaPN) && t.ID_ITEM.Equals(pMaSp)).FirstOrDefault();
if (check != null)
{
_Coffee.detail_receipt_imports.DeleteOnSubmit(check);
_Coffee.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}