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