Beispiel #1
0
        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"));
        }
Beispiel #2
0
        private string ValidationRewardSetup(RewardSetupModel rewardSetupModel)
        {
            string ErrorString = string.Empty;

            if (string.IsNullOrEmpty(rewardSetupModel.OfferName))
            {
                ErrorString = _locService.GetLocalizedHtmlString("ValidOfferName");
                return(ErrorString);
            }
            return(ErrorString);
        }
Beispiel #3
0
        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"));
            }
        }
Beispiel #4
0
        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);
        }
Beispiel #5
0
        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));
 }