public async Task <HttpResponseMessage> GetByIdAsync(SysUserInGroupModel _params)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
var data = await Task.Run(() => _sysUserInGroupService.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(SysUserInGroupModel _param)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
if (_param != null)
{
await Task.Run(() => _sysUserInGroupService.Delete(_param));
Result.Status = true;
Result.Message = "Xoá 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 xoá " + ex.Message;
Result.StatusCode = HttpStatusCode.BadRequest;
throw new Exception(ex.Message);
}
}
/*===Insert===*/
public void Insert(SysUserInGroupModel _params)
{
try
{
_uow.SysUserInGroupRepo.ExcQuery("exec sp_SysUserInGroup_Insert " +
"@GroupRolesId," +
"@UserId," +
"@Descriptions," +
"@Display_Order," +
"@Is_Active," +
"@CreateDate," +
"@CreateBy," +
"@UpdateDate," +
"@UpdateBy",
new SqlParameter("GroupRolesId", SqlDbType.Int)
{
Value = _params.GroupRolesId
},
new SqlParameter("UserId", SqlDbType.Int)
{
Value = _params.UserId
},
new SqlParameter("Descriptions", SqlDbType.NVarChar)
{
Value = _params.Descriptions ?? DBNull.Value.ToString()
},
new SqlParameter("Display_Order", SqlDbType.Int)
{
Value = _params.Display_Order ?? 1
},
new SqlParameter("Is_Active", SqlDbType.Bit)
{
Value = _params.Is_Active == null ? true : _params.Is_Active
},
new SqlParameter("CreateDate", SqlDbType.Date)
{
Value = _params.CreateDate == null ? DateTime.Now : _params.CreateDate
},
new SqlParameter("CreateBy", SqlDbType.Int)
{
Value = _params.CreateBy ?? 1
},
new SqlParameter("UpdateDate", SqlDbType.Date)
{
Value = _params.UpdateDate == null ? DateTime.Now : _params.UpdateDate
},
new SqlParameter("UpdateBy", SqlDbType.Int)
{
Value = _params.UpdateBy ?? 1
}
);
}
catch (Exception ex)
{
throw new Exception("Có lỗi xãy ra trong quá trình thêm mới " + ex.Message);
}
}
/*==GetAllById ==*/
public SysUserInGroupModel GetById(SysUserInGroupModel _params)
{
var data = _uow.SysUserInGroupRepo
.SQLQuery <SysUserInGroupModel>("sp_SysUserInGroup_GetById " + "@SysUserInGroupId",
new SqlParameter("SysUserInGroupId", SqlDbType.Int)
{
Value = _params.SysUserInGroupId
}).FirstOrDefault();
return(data);
}
public async Task <HttpResponseMessage> CreateAsync(SysUserInGroupModel _param)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
if (_param != null)
{
if (_param.GroupRolesId < 0 || _param.GroupRolesId == null)
{
Result.Status = false;
Result.Message = "Nhóm quyền không được trống " + _param.SysUserInGroupId;
Result.StatusCode = HttpStatusCode.OK;
}
else if (_param.UserId < 0 || _param.UserId == null)
{
Result.Status = false;
Result.Message = "Tài khoản dùng không được trống " + _param.SysUserInGroupId;
Result.StatusCode = HttpStatusCode.OK;
}
else
{
await Task.Run(() => _sysUserInGroupService.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);
}
}
/*===Delete===*/
public void Delete(SysUserInGroupModel _params)
{
try
{
_uow.SysUserInGroupRepo.ExcQuery("exec sp_SysUserInGroup_Delete " +
"@SysUserInGroupId",
new SqlParameter("SysUserInGroupId", SqlDbType.Int)
{
Value = _params.SysUserInGroupId
}
);
}
catch (Exception ex)
{
throw new Exception("Có lỗi xãy ra trong quá trình xóa" + ex.Message);
}
}
