public async Task <ActionResult> KendoSave([DataSourceRequest] DataSourceRequest request, RoleReadModel model)
{
string message = string.Empty;
int result = 0;
try
{
//AgroAppEntities context = new AgroAppEntities();
var RoleIdParam = new SqlParameter
{
ParameterName = "RoleId",
DbType = DbType.Int32,
Value = (object)model.RoleId ?? DBNull.Value
};
var RoleNameParam = new SqlParameter
{
ParameterName = "RoleName",
DbType = DbType.String,
Value = (object)model.RoleName ?? DBNull.Value
};
var IsActiveParam = new SqlParameter
{
ParameterName = "IsActive",
DbType = DbType.Boolean,
Value = (object)model.IsActive ?? DBNull.Value
};
result = context.Database.SqlQuery <int>("SP_RoleInsertAndUpdate @RoleId,@RoleName,@IsActive"
, RoleIdParam, RoleNameParam, IsActiveParam).FirstOrDefault();
if (result == 1)
{
message = "Role Inserted SucessFully !!! ";
}
else if (result == 2)
{
message = "Role Updated SucessFully !!! ";
}
else if (result == 3)
{
message = "Role Already Exist !!! ";
}
}
catch (Exception ex)
{
message = CommonHelper.GetErrorMessage(ex);
}
//return Json(new[] { model }.ToDataSourceResult(request));
return((result == 3)
? Json(new { Message = message, IsError = Convert.ToString((int)Enums.NotifyType.Error) }, JsonRequestBehavior.AllowGet)
: Json(new { Message = message, IsError = Convert.ToString((int)Enums.NotifyType.Success) }, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> KendoDestroy([DataSourceRequest] DataSourceRequest request, RoleReadModel model)
{
string deleteMessage = string.Empty;
int result = 0;
try
{
//AgroAppEntities context = new AgroAppEntities();
var RoleIdParam = new SqlParameter
{
ParameterName = "RoleId",
DbType = DbType.Int32,
Value = model.RoleId
};
result = context.Database.SqlQuery <int>("SP_RoleMaster_DeleteRole @RoleId", RoleIdParam).FirstOrDefault();
}
catch (Exception ex)
{
deleteMessage = CommonHelper.GetErrorMessage(ex);
}
return(Json(new[] { model }.ToDataSourceResult(request)));
}
