public void UsedCode(string iduser) { if (Session["Code"] != null) { var useCode = Session["Code"].ToString(); var codeInvoice = _dbBCDH.CuponCodes.AsNoTracking().Where(x => x.Code == useCode).SingleOrDefault(); CuponCode temp = codeInvoice; temp.NumberUse = temp.NumberUse - 1; var dateCreate = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss"); CuponCodeHistory tempcode = new CuponCodeHistory { CuponCodeUsed = useCode, ID_User = iduser, DateUsed = Convert.ToDateTime(dateCreate) }; _dbBCDH.Entry(tempcode).State = System.Data.Entity.EntityState.Added; _dbBCDH.Entry(temp).State = System.Data.Entity.EntityState.Modified; _dbBCDH.SaveChanges(); } }
private CuponCode CreateCupon(string userid) { var tempUser = _dbBCDH.Invoices.Where(x => x.ID_Account == userid && x.Payment_Methods != "PayForAccount").FirstOrDefault(); if (tempUser != null) { return(null); } else { var dateCreate = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss"); var code = new RandomCode().RandomNumber(8); CuponCode tempCode = new CuponCode { Code = code, ContentCode = "KMFristTimeBuy", CreateDate = Convert.ToDateTime(dateCreate), NumberUse = 1, PercentSale = 10, ValueSale = 0, EndDate = Convert.ToDateTime(dateCreate).AddDays(7) }; _dbBCDH.Entry(tempCode).State = System.Data.Entity.EntityState.Added; _dbBCDH.SaveChanges(); return(tempCode); } }