public void InsertPromo(AddPromoModel addPromoModel) { using (IDbConnection connection = OpenConnection()) { System.TimeSpan midnight = new System.TimeSpan(0, 23, 59, 59); addPromoModel.ExpireDate = addPromoModel.ExpireDate.Add(midnight); const string query = "INSERT INTO PromotionalCode (PromoCode, PromoCodeType, Amount, ExpireDate, MultiUse, Description, CreatedBy) VALUES (@PromoCode, @PromoCodeType, @Amount, @ExpireDate, @MultiUse, @Description, @CreatedBy)"; var parameters = new { PromoCode = addPromoModel.PromoCode, Amount = addPromoModel.PromoAmount, PromoCodeType = addPromoModel.PromoTypes, ExpireDate = addPromoModel.ExpireDate, MultiUse = addPromoModel.MultipleUse, Description = addPromoModel.Description, CreatedBy = addPromoModel.CreatedBy }; try { connection.Execute(query, parameters); } catch { throw; } return; } }
public void CreatePromo(AddPromoModel addPromoModel) { try { adminRepository.InsertPromo(addPromoModel); } catch { throw; } }
public ActionResult AddPromoCode() { if (Session["isAdmin"] == null) { return(RedirectToAction("LogIn", "Account")); } AddPromoModel model = new AddPromoModel(); model.PromoCode = GenPromoCode(); model.ExpireDate = DateTime.Today.AddDays(1); return(View(model)); }
public ActionResult AddPromoCode(AddPromoModel model) { if (ModelState.IsValid) { if (Session["isAdmin"] == null) { return(RedirectToAction("LogIn", "Account")); } if (model.Command == "ADD") { string PostedPromoCode = model.PromoCode; ModelState.Clear(); try { model.CreatedBy = (int)Session["MemberID"]; adminService.CreatePromo(model); model.Message = "Promo Code " + PostedPromoCode + " has been saved. Enter a new Promo or cancel."; Random random = new Random(); model.PromoCode = GenPromoCode(); model.ExpireDate = DateTime.Today.AddDays(1); return(View(model)); } catch { model.Message = "Error Adding Promo"; return(View(model)); } } else if (model.Command == "CANCEL") { return(RedirectToAction("Index")); } } return(View(model)); }