//Cap nhat chi tiet hoa don public bool UpdateDetailReceipt(string idReceipt, string idStaff, string idItem, string pSaleOff, string pNum, string pPriceOut, string pIntoMoney, string pStatus) { try { DetailReceipt check = db.DetailReceipts.Where(t => t.IDRECEIPT == int.Parse(idReceipt) && t.IDSTAFF == int.Parse(idStaff) && t.IDITEM == int.Parse(idItem)).FirstOrDefault(); if (check != null) { //Cap nhat check.SALEOFF = float.Parse(pSaleOff); check.NUMBER = int.Parse(pNum); check.PRICEOUT = float.Parse(pPriceOut); check.INTOMONEY = float.Parse(pIntoMoney); check.STATUS = int.Parse(pStatus); db.SubmitChanges(); return(true); } else { return(false); } } catch { return(false); } }
//Xoa mot chi tiet hoa don public bool DeleteDetailReceipt(string idReceipt, string idStaff, string idItem) { try { DetailReceipt check = db.DetailReceipts.Where(t => t.IDRECEIPT == int.Parse(idReceipt) && t.IDSTAFF == int.Parse(idStaff) && t.IDITEM == int.Parse(idItem)).FirstOrDefault(); if (check != null) { db.DetailReceipts.DeleteOnSubmit(check); db.SubmitChanges(); return(true); } else { return(false); } } catch { return(false); } }
//Them mot chi tiet hoa don public bool AddDetailReceipt(string idReceipt, string idStaff, string idItem, string pSaleOff, string pNum, string pPriceOut, string pIntoMoney, string pStatus) { try { DetailReceipt add = new DetailReceipt(); add.IDRECEIPT = int.Parse(idReceipt); add.IDSTAFF = int.Parse(idStaff); add.IDITEM = int.Parse(idItem); add.NUMBER = int.Parse(pNum); add.PRICEOUT = float.Parse(pPriceOut); add.INTOMONEY = float.Parse(pIntoMoney); add.SALEOFF = float.Parse(pSaleOff); add.STATUS = int.Parse(pStatus); db.DetailReceipts.InsertOnSubmit(add); db.SubmitChanges(); return(true); } catch { return(false); } }