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);
}
