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