public IActionResult Index(int Id = 0) { ViewBag.StoresList = new SelectList(_storesRespository.GetStoresByUserId(this.loginUserId), "Id", "StoreName"); ViewBag.SurveyList = new List <SurveyForm_VM>(); ViewBag.MenuItemList = new List <MenuItem_VM>(); var voucherSetup = new VoucherSetup_VM(); if (Id > 0) { voucherSetup = _voucherSetupRepository.Get(Id, this.loginUserId, isAdmin); if (voucherSetup == null) { return(RedirectToAction("List", "VoucherSetup")); } else { ViewBag.MenuItemList = new SelectList(_menuItemRepository.GetMenuItemForVoucherSetUp(this.loginUserId, clientId).Where(c => voucherSetup.StoreIds.Contains(c.StoreId)).ToList(), "Id", "Name"); ViewData["Title"] = "Edit"; return(View(voucherSetup)); } } else { ViewData["Title"] = "Add"; return(View(voucherSetup)); } }
public IActionResult Save(VoucherSetup_VM voucherSetup_VM) { if (voucherSetup_VM != null) { if (voucherSetup_VM.Id > 0) { if (_voucherSetupRepository.Update(voucherSetup_VM, this.loginUserId) > 0) { TempData["Status"] = Helper.success_code; TempData["Message"] = Message.voucherSetupUpdated; } else { TempData["Message"] = Message.voucherSetupUpdatedError; } } else { if (_voucherSetupRepository.Add(voucherSetup_VM, this.loginUserId) > 0) { TempData["Status"] = Helper.success_code; TempData["Message"] = Message.voucherSetupAdded; } else { TempData["Message"] = Message.voucherSetupAddedError; } } } return(RedirectToAction("List", "VoucherSetup")); }
/// <summary> /// Function for add voucher /// </summary> /// <param name="voucherSetup_VM"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Add(VoucherSetup_VM voucherSetup_VM, int loginUserId) { var ret = 1; using (var dbcxtransaction = _context.Database.BeginTransaction()) { try { var voucherSetup = new VoucherSetup(); voucherSetup.Name = voucherSetup_VM.Name; voucherSetup.Description = voucherSetup_VM.Description; voucherSetup.Terms = voucherSetup_VM.Terms; voucherSetup.Limitations = voucherSetup_VM.Limitations; voucherSetup.Type = voucherSetup_VM.Type; voucherSetup.Value = voucherSetup_VM.Value; voucherSetup.IsMultipleTimeUsage = voucherSetup_VM.IsMultipleTimeUsage; voucherSetup.StartDate = voucherSetup_VM.StartDate; voucherSetup.EndDate = voucherSetup_VM.EndDate; voucherSetup.Status = voucherSetup_VM.Status; voucherSetup.CreatedOn = DateTime.Now; voucherSetup.CreatedBy = loginUserId; _context.VoucherSetup.Add(voucherSetup); _context.SaveChanges(); //Add voucher stores var voucherStores = new List <Set_VoucherStore>(); foreach (var storeId in voucherSetup_VM.StoreIds) { var obj = new Set_VoucherStore(); obj.VoucherId = voucherSetup.Id; obj.StoreId = storeId; voucherStores.Add(obj); } _context.Set_VoucherStore.AddRange(voucherStores); _context.SaveChanges(); if (voucherSetup_VM.Type == (int)VoucherSetupType.ItemType) { //Add voucher menu item var voucherItemTypes = new List <VoucherItemType>(); foreach (var menuItemId in voucherSetup_VM.MenuItemIds) { var obj = new VoucherItemType(); obj.VoucherId = voucherSetup.Id; obj.MenuItemId = menuItemId; voucherItemTypes.Add(obj); } _context.VoucherItemType.AddRange(voucherItemTypes); _context.SaveChanges(); } //Add voucher survey var voucherSurveys = new List <Set_VoucherSurvey>(); foreach (var surveyId in voucherSetup_VM.SurveyIds) { var obj = new Set_VoucherSurvey(); obj.VoucherId = voucherSetup.Id; obj.SurveyId = surveyId; voucherSurveys.Add(obj); } _context.Set_VoucherSurvey.AddRange(voucherSurveys); _context.SaveChanges(); dbcxtransaction.Commit(); } catch (Exception ex) { dbcxtransaction.Rollback(); ret = 0; } } return(ret); }
/// <summary> /// Function for update voucher /// </summary> /// <param name="voucherSetup_VM"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Update(VoucherSetup_VM voucherSetup_VM, int loginUserId) { var ret = 1; using (var dbcxtransaction = _context.Database.BeginTransaction()) { try { var voucherSetup = _context.VoucherSetup.Where(x => x.Id == voucherSetup_VM.Id && x.IsDeleted == false && x.CreatedBy == loginUserId).FirstOrDefault(); if (voucherSetup != null) { voucherSetup.Name = voucherSetup_VM.Name; voucherSetup.Description = voucherSetup_VM.Description; voucherSetup.Terms = voucherSetup_VM.Terms; voucherSetup.Limitations = voucherSetup_VM.Limitations; voucherSetup.Type = voucherSetup_VM.Type; voucherSetup.Value = voucherSetup_VM.Value; voucherSetup.IsMultipleTimeUsage = voucherSetup_VM.IsMultipleTimeUsage; voucherSetup.StartDate = voucherSetup_VM.StartDate; voucherSetup.EndDate = voucherSetup_VM.EndDate; voucherSetup.Status = voucherSetup_VM.Status; voucherSetup.ModifiedOn = DateTime.Now; voucherSetup.ModifiedBy = loginUserId; _context.SaveChanges(); //Remove old voucher stores var oldVoucherStores = _context.Set_VoucherStore.Where(x => x.VoucherId == voucherSetup.Id).ToList(); if (oldVoucherStores.Any()) { _context.Set_VoucherStore.RemoveRange(oldVoucherStores); _context.SaveChanges(); } //Remove old voucher menu item var oldVoucherItemTypess = _context.VoucherItemType.Where(x => x.VoucherId == voucherSetup.Id).ToList(); if (oldVoucherItemTypess.Any()) { _context.VoucherItemType.RemoveRange(oldVoucherItemTypess); _context.SaveChanges(); } //Remove old voucher survey var oldVoucherSurvey = _context.Set_VoucherSurvey.Where(x => x.VoucherId == voucherSetup.Id).ToList(); if (oldVoucherSurvey.Any()) { _context.Set_VoucherSurvey.RemoveRange(oldVoucherSurvey); _context.SaveChanges(); } //Add voucher stores var voucherStores = new List <Set_VoucherStore>(); foreach (var storeId in voucherSetup_VM.StoreIds) { var obj = new Set_VoucherStore(); obj.VoucherId = voucherSetup.Id; obj.StoreId = storeId; voucherStores.Add(obj); } _context.Set_VoucherStore.AddRange(voucherStores); _context.SaveChanges(); if (voucherSetup_VM.Type == (int)VoucherSetupType.ItemType) { //Add voucher menu item var voucherItemTypes = new List <VoucherItemType>(); foreach (var menuItemId in voucherSetup_VM.MenuItemIds) { var obj = new VoucherItemType(); obj.VoucherId = voucherSetup.Id; obj.MenuItemId = menuItemId; voucherItemTypes.Add(obj); } _context.VoucherItemType.AddRange(voucherItemTypes); _context.SaveChanges(); } //Add voucher survey var voucherSurveys = new List <Set_VoucherSurvey>(); foreach (var surveyId in voucherSetup_VM.SurveyIds) { var obj = new Set_VoucherSurvey(); obj.VoucherId = voucherSetup.Id; obj.SurveyId = surveyId; voucherSurveys.Add(obj); } _context.Set_VoucherSurvey.AddRange(voucherSurveys); _context.SaveChanges(); dbcxtransaction.Commit(); } else { ret = 0; } } catch (Exception ex) { dbcxtransaction.Rollback(); ret = 0; } } return(ret); }