public async Task <HttpResponseMessage> GetByIdAsync(SysFunctionInGroupModel _params)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
var data = await Task.Run(() => _sysFunctionInGroupService.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(SysFunctionInGroupModel _param)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
if (_param != null)
{
await Task.Run(() => _sysFunctionInGroupService.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);
}
}
/*===Insert===*/
public void Insert(SysFunctionInGroupModel _params)
{
try
{
_uow.SysFunctionInGroupRepo.ExcQuery("exec sp_SysFunctionInGroup_Insert " +
"@GroupRolesId," +
"@FuctionId," +
"@Descriptions," +
"@Display_Order," +
"@Is_Active," +
"@CreateDate," +
"@CreateBy," +
"@UpdateDate," +
"@UpdateBy",
new SqlParameter("GroupRolesId", SqlDbType.Int)
{
Value = _params.GroupRolesId
},
new SqlParameter("FuctionId", SqlDbType.Int)
{
Value = _params.FuctionId
},
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 == 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 thêm mới " + ex.Message);
}
}
/*==GetAllById ==*/
public SysFunctionInGroupModel GetById(SysFunctionInGroupModel _params)
{
var data = _uow.SysFunctionInGroupRepo.SQLQuery <SysFunctionInGroupModel>("sp_SysFunctionInGroup_GetById "
+ "@SysFunctionInGroupId",
new SqlParameter("SysFunctionInGroupId", SqlDbType.Int)
{
Value = _params.SysFunctionInGroupId
}).FirstOrDefault();
return(data);
}
public async Task <HttpResponseMessage> CreateAsync(SysFunctionInGroupModel _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.GroupRolesId;
Result.StatusCode = HttpStatusCode.BadRequest;
}
else if (_param.FuctionId < 0 || _param.FuctionId == null)
{
Result.Status = false;
Result.Message = "Nhóm chức năng được trống" + _param.FuctionId;
Result.StatusCode = HttpStatusCode.BadRequest;
}
else
{
await Task.Run(() => _sysFunctionInGroupService.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(SysFunctionInGroupModel _params)
{
try
{
_uow.SysFunctionInGroupRepo.ExcQuery("exec sp_SysFunctionInGroup_Delete " +
"@SysFunctionInGroupId",
new SqlParameter("SysFunctionInGroupId", SqlDbType.Int)
{
Value = _params.SysFunctionInGroupId
}
);
}
catch (Exception ex)
{
throw new Exception("Có lỗi xãy ra trong quá trình xóa " + ex.Message);
}
}
