public ActionResult RewardSetup(RewardSetupModel rewardSetupModel) { if (!ModelState.IsValid) { string errorString = this.ValidationRewardSetup(rewardSetupModel); if (!string.IsNullOrEmpty(errorString)) { ViewBag.Validate = errorString; return(View(rewardSetupModel)); } } if (rewardSetupModel.Id > 0) { var result = _iRewardSetupService.UpdateRewardSetup(rewardSetupModel); if (result == -1) { ModelState.AddModelError("OfferName", "Offer name already exists"); return(View(rewardSetupModel)); } ViewBag.Result = _locService.GetLocalizedHtmlString("EditSuccss"); } else { var result = _iRewardSetupService.InsertRewardSetup(rewardSetupModel); if (result == -1) { ModelState.AddModelError("OfferName", "Offer name already exists"); return(View(rewardSetupModel)); } ViewBag.Result = _locService.GetLocalizedHtmlString("SaveSuccess"); } return(RedirectToAction("Index", "RewardSetup")); }
private string ValidationRewardSetup(RewardSetupModel rewardSetupModel) { string ErrorString = string.Empty; if (string.IsNullOrEmpty(rewardSetupModel.OfferName)) { ErrorString = _locService.GetLocalizedHtmlString("ValidOfferName"); return(ErrorString); } return(ErrorString); }
public ActionResult RewardSetup(int?id) { RewardSetupModel rewardSetupModel = new RewardSetupModel(); if (UserRolePermissionForPage.Add == true || UserRolePermissionForPage.Edit == true) { if (id > 0) { rewardSetupModel = _iRewardSetupService.GetRewardSetupById(Convert.ToInt32(id)); } return(View(rewardSetupModel)); } else { return(RedirectToAction("NotFound", "Error")); } }
public int UpdateRewardSetup(RewardSetupModel rewardSetupModel) { int result = 0; using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { CommonRepository commonRepository = new CommonRepository(_ConnectionString); result = commonRepository.GetValidateUnique("RewardSetup", "OfferName", rewardSetupModel.OfferName, rewardSetupModel.Id.ToString()); if (result > 0) { return(-1); } con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var query = "UPDATE RewardSetup SET OfferName =@OfferName," + "TransactionAmount = @TransactionAmount, " + "RewardPoint = @RewardPoint, " + "Notes = @Notes, " + "IsActive = @IsActive, " + "UserIdUpdated = " + LoginInfo.Userid + ",DateUpdated = GetUtcDate() " + "WHERE Id = @Id;"; result = con.Execute(query, rewardSetupModel, sqltrans, 0, System.Data.CommandType.Text); if (result > 0) { sqltrans.Commit(); string output = commonRepository.SyncTableStatus("RewardSetup"); } else { sqltrans.Rollback(); } } return(result); }
public int InsertRewardSetup(RewardSetupModel rewardSetupModel) { int result = 0; using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { CommonRepository commonRepository = new CommonRepository(_ConnectionString); result = commonRepository.GetValidateUnique("RewardSetup", "OfferName", rewardSetupModel.OfferName, rewardSetupModel.Id.ToString()); if (result > 0) { return(-1); } int MaxId = commonRepository.GetMaxId("RewardSetup"); con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var query = "INSERT INTO RewardSetup (Id,OfferName,TransactionAmount,RewardPoint," + "Notes, " + "IsActive,UserIdInserted,DateInserted,IsDeleted)" + "VALUES (" + MaxId + ",@OfferName,@TransactionAmount,@RewardPoint," + "@Notes," + "@IsActive," + LoginInfo.Userid + ",GetUtcDate(),0); SELECT CAST(SCOPE_IDENTITY() as INT);"; result = con.Execute(query, rewardSetupModel, sqltrans, 0, System.Data.CommandType.Text); if (result > 0) { sqltrans.Commit(); string output = commonRepository.SyncTableStatus("RewardSetup"); } else { sqltrans.Rollback(); } return(result); } }
public int UpdateRewardSetup(RewardSetupModel rewardSetupModel) { return(_iRewardSetupRepository.UpdateRewardSetup(rewardSetupModel)); }
public int InsertRewardSetup(RewardSetupModel rewardSetupModel) { return(_iRewardSetupRepository.InsertRewardSetup(rewardSetupModel)); }