public async Task <HttpResponseMessage> GetByIdAsync(SysGroupRoleModel _params)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
var data = await Task.Run(() => _sysGroupRoleService.GetById(_params));
if (data != null)
{
Result.Data = data;
Result.Status = true;
Result.Message = "Call API Success";
Result.StatusCode = HttpStatusCode.OK;
}
else
{
Result.Data = null;
Result.Status = false;
Result.Message = "Không tìm thấy dữ liệu";
Result.StatusCode = HttpStatusCode.InternalServerError;
}
Res.Content = new StringContent(JsonConvert.SerializeObject(Result));
return(Res);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <HttpResponseMessage> DeleteAsync(SysGroupRoleModel _param)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
if (_param != null)
{
await Task.Run(() => _sysGroupRoleService.Delete(_param));
Result.Status = true;
Result.Message = "Xóa thành công";
Result.StatusCode = HttpStatusCode.OK;
}
else
{
Result.Status = false;
Result.Message = "Xóa thất bại";
Result.StatusCode = HttpStatusCode.BadRequest;
}
Res.Content = new StringContent(JsonConvert.SerializeObject(Result));
return(Res);
}
catch (Exception ex)
{
Result.Status = false;
Result.Message = "Có lỗi xảy ra trong quá trình xóa " + ex.Message;
Result.StatusCode = HttpStatusCode.BadRequest;
throw new Exception(ex.Message);
}
}
/*===Update===*/
public void Update(SysGroupRoleModel _params)
{
try
{
_uow.SysGroupRoleRepo.ExcQuery("exec sp_SysGroupRoles_Update " +
"@GroupRolesId," +
"@GroupRolesCode," +
"@GroupRolesName," +
"@Is_Active," +
"@Display_Order," +
"@CreateDate," +
"@CreateBy," +
"@UpdateDate," +
"@UpdateBy",
new SqlParameter("GroupRolesId", SqlDbType.Int)
{
Value = _params.GroupRolesId
},
new SqlParameter("GroupRolesCode", SqlDbType.VarChar, (50))
{
Value = _params.GroupRolesCode ?? DBNull.Value.ToString()
},
new SqlParameter("GroupRolesName", SqlDbType.NVarChar, (50))
{
Value = _params.GroupRolesName
},
new SqlParameter("Is_Active", SqlDbType.Bit)
{
Value = _params.Is_Active == null ? true : _params.Is_Active
},
new SqlParameter("Display_Order", SqlDbType.Int)
{
Value = _params.Display_Order ?? 1
},
new SqlParameter("CreateDate", SqlDbType.Date)
{
Value = _params.CreateDate == null ? DateTime.Now : _params.CreateDate
},
new SqlParameter("CreateBy", SqlDbType.Int)
{
Value = _params.CreateBy == null ? 1 : _params.CreateBy
},
new SqlParameter("UpdateDate", SqlDbType.Date)
{
Value = _params.UpdateDate == null ? DateTime.Now : _params.UpdateDate
},
new SqlParameter("UpdateBy", SqlDbType.Int)
{
Value = _params.UpdateBy == null ? 1 : _params.UpdateBy
}
);
}
catch (Exception ex)
{
throw new Exception("Có lỗi xãy ra trong quá trình cập nhập " + ex.Message);
}
}
/*==GetAllById ==*/
public SysGroupRoleModel GetById(SysGroupRoleModel _params)
{
var data = _uow.SysGroupRoleRepo.SQLQuery <SysGroupRoleModel>("sp_SysGroupRoles_GetById "
+ "@GroupRolesId",
new SqlParameter("GroupRolesId", SqlDbType.Int)
{
Value = _params.GroupRolesId
}).FirstOrDefault();
return(data);
}
/*===Delete===*/
public void Delete(SysGroupRoleModel _params)
{
try
{
_uow.SysGroupRoleRepo.ExcQuery("exec sp_SysGroupRoles_Delete " +
"@GroupRolesId",
new SqlParameter("GroupRolesId", SqlDbType.Int)
{
Value = _params.GroupRolesId
}
);
}
catch (Exception ex)
{
throw new Exception("Có lỗi xãy ra trong quá trình xóa " + ex.Message);
}
}
public async Task <HttpResponseMessage> CreateAsync(SysGroupRoleModel _param)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
if (_param != null)
{
if (string.IsNullOrEmpty(_param.GroupRolesName))
{
Result.Status = false;
Result.Message = "Tên không được trống" + _param.GroupRolesName;
Result.StatusCode = HttpStatusCode.BadRequest;
}
else
{
await Task.Run(() => _sysGroupRoleService.Insert(_param));
Result.Status = true;
Result.Message = "Thêm mới thành công";
Result.StatusCode = HttpStatusCode.OK;
}
}
else
{
Result.Status = false;
Result.Message = "Thêm mới thất bại";
Result.StatusCode = HttpStatusCode.BadRequest;
}
Res.Content = new StringContent(JsonConvert.SerializeObject(Result));
return(Res);
}
catch (Exception ex)
{
Result.Status = false;
Result.Message = "Có lỗi xảy ra trong quá trình thêm mới " + ex.Message;
Result.StatusCode = HttpStatusCode.BadRequest;
throw new Exception(ex.Message);
}
}
