public ActionResult Addons(AddonsModel addonsModel, string submitButton)
{
if (!ModelState.IsValid)
{
string errorString = this.ValidationAddons(addonsModel);
if (!string.IsNullOrEmpty(errorString))
{
ViewBag.Validate = errorString;
return(View(addonsModel));
}
}
if (addonsModel.Id > 0)
{
var result = _iAddonsService.UpdateAddons(addonsModel);
ViewBag.Result = _locService.GetLocalizedHtmlString("EditSuccss");
}
else
{
var result = _iAddonsService.InsertAddons(addonsModel);
ViewBag.Result = _locService.GetLocalizedHtmlString("SaveSuccess");
}
return(RedirectToAction("Index", "Addons"));
//return View(addonsModel);
}
public int UpdateAddons(AddonsModel addonsModel)
{
int result = 0;
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var query = "UPDATE Addons SET AddonsName =@AddonsName," +
"Price = @Price, " +
"IsActive = @IsActive " +
"WHERE Id = @Id;";
result = con.Execute(query, addonsModel, sqltrans, 0, System.Data.CommandType.Text);
if (result > 0)
{
sqltrans.Commit();
}
else
{
sqltrans.Rollback();
}
}
return(result);
}
public int InsertAddons(AddonsModel addonsModel)
{
int result = 0;
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
CommonRepository commonRepository = new CommonRepository(_ConnectionString);
int MaxId = commonRepository.GetMaxId("Addons");
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var query = "INSERT INTO Addons (Id,AddonsName," +
"Price, " +
"IsActive)" +
"VALUES (" + MaxId + ",@AddonsName," +
"@Price," +
"@IsActive); SELECT CAST(SCOPE_IDENTITY() as INT);";
result = con.Execute(query, addonsModel, sqltrans, 0, System.Data.CommandType.Text);
if (result > 0)
{
sqltrans.Commit();
}
else
{
sqltrans.Rollback();
}
}
return(result);
}
private string ValidationAddons(AddonsModel addonsModel)
{
string ErrorString = string.Empty;
if (string.IsNullOrEmpty(addonsModel.AddonsName))
{
ErrorString = _locService.GetLocalizedHtmlString("ValidAddOnesName");
return(ErrorString);
}
//if (string.IsNullOrEmpty(addonsModel.Price.ToString()) || addonsModel.Price == 0)
//{
// ErrorString = _locService.GetLocalizedHtmlString("ValidPrice");
// return ErrorString;
//}
return(ErrorString);
}
public ActionResult Addons(int?id)
{
AddonsModel addonsModel = new AddonsModel();
if (UserRolePermissionForPage.Add == true || UserRolePermissionForPage.Edit == true)
{
if (id > 0)
{
int addonsId = Convert.ToInt32(id);
addonsModel = _iAddonsService.GetAddonesById(addonsId);
}
return(View(addonsModel));
}
else
{
return(RedirectToAction("NotFound", "Error"));
}
}
public int UpdateAddons(AddonsModel addonsModel)
{
return(_IAddonsReportsitory.UpdateAddons(addonsModel));
}
public int InsertAddons(AddonsModel addonsModel)
{
return(_IAddonsReportsitory.InsertAddons(addonsModel));
}
