public bool updateNewProduct(string productCode, string productName, string image, string typeCode, string supplierCode) { //Mean of if: Nothing change => Can't update! if (!checkExistProduct(productName, image, typeCode, supplierCode)) { try { using (var db = new CMART2Entities1()) { var product = db.Products.Single(p => p.ProductCode == productCode); product.ProductName = productName; product.Image = image; product.TypeCode = typeCode; product.SupplierCode = supplierCode; db.Entry(product).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { return(false); } } return(false); }
public bool updatePromotion(string promotionCode, string productCode, float promotionPrice, DateTime startTime, DateTime endTime, string promotionContent, string promotionImage) { if (!checkExistPromotion(promotionPrice, startTime, endTime, promotionContent, promotionImage)) { try { using (var db = new CMART2Entities1()) { var promotion = db.PromotionInformations.Single(s => s.PromotionCode == promotionCode); promotion.ProductCode = productCode; promotion.PricePromotion = promotionPrice; promotion.StartTime = startTime; promotion.EndTime = endTime; promotion.Cont = promotionContent; promotion.Image = promotionImage; db.Entry(promotion).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { return(false); } } return(false); }
public bool updateBill(string ballotNum, DateTime date, double total, double guestMoney, double excessCash, int totalNum, int pos, string accountCode) { if (!checkExistBill(date, total, guestMoney, excessCash, totalNum, pos, accountCode)) { try { using (var db = new CMART2Entities1()) { var bill = db.Bills.Single(s => s.BallotNum == ballotNum); bill.Date = date; bill.Total = total; bill.GuestMoney = guestMoney; bill.ExcessCash = excessCash; bill.TotalNum = totalNum; bill.POS = pos; bill.AccountCode = accountCode; db.Entry(bill).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { return(false); } } return(false); }
/*===UPDATE CONTROLLER===*/ public bool updateBranchImportBallotDetail(string ballotNum, string productCode, int number, string status) { //if (!checkUpdateBranchImportBallot(status)) try { using (var db = new CMART2Entities1()) { var importBallotDetail = db.BranchImportBallotDetails.Single (p => p.BallotNum == ballotNum && p.ProductCode == productCode); importBallotDetail.State = status; db.Entry(importBallotDetail).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { return(false); } //return false; }
public bool updateBillDetail(string ballotNum, string productcode, double unitprice, int number) { try { using (var db = new CMART2Entities1()) { var billdetail = db.BillDetails.Single(s => s.BallotNum == ballotNum); { billdetail.ProductCode = productcode; billdetail.UnitPrice = unitprice; billdetail.Number = number; db.Entry(billdetail).State = EntityState.Modified; db.SaveChanges(); return(true); }; } } catch (Exception) { return(false); } }
public bool updateHeadquarterImportBallotDetail(string ballotNum, string productCode, int number, double inputPrice, DateTime exp, string status) { if (!checkExistHeadquarterImportBallot(exp, status)) { try { using (var db = new CMART2Entities1()) { var importBallotDetail = db.HeadquaterImportBallotDetails.Single (p => p.BallotNum == ballotNum && p.ProductCode == productCode); importBallotDetail.EXP = exp; importBallotDetail.State = status; db.Entry(importBallotDetail).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { return(false); } } return(false); }