public ActionResult AddCategory(DeviceCategoryModel model)
{
using (var con = new SqlConnection(_connectionString))
{
var result = con.Query <int>("Add_Modify_Delete_Category",
new
{
CatId = "",
model.CatName,
model.IsRepair,
model.IsActive,
model.SortOrder,
model.Comments,
User = CurrentUser.UserId,
Action = "add",
companyId = CurrentUser.CompanyId
}, commandType: CommandType.StoredProcedure).FirstOrDefault();
var response = new ResponseModel();
if (result == 1)
{
response.IsSuccess = true;
response.Response = "Successfully Added";
TempData["response"] = response;
}
else
{
response.IsSuccess = true;
response.Response = "Category Already Exist";
TempData["response"] = response;
}
}
return(RedirectToAction("DeviceCategory"));
}
public ActionResult EditDeviceCategory(DeviceCategoryModel model)
{
try
{
using (var con = new SqlConnection(_connectionString))
{
var result = con.Query <int>("Add_Modify_Delete_Category",
new
{
model.CatId,
model.CatName,
model.IsRepair,
model.IsActive,
model.SortOrder,
model.Comments,
User = CurrentUser.UserId,
Action = "edit",
companyId = CurrentUser.CompanyId
}, commandType: CommandType.StoredProcedure).FirstOrDefault();
var response = new ResponseModel();
if (result == 2)
{
response.IsSuccess = true;
response.Response = "Category Successfully Updated";
TempData["response"] = response;
}
}
}
catch (Exception e)
{
throw e;
}
return(RedirectToAction("DeviceCategory"));
}
