public async Task <HttpResponseMessage> GetByIdAsync(SysFunctionGroupModel _params)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
var data = await Task.Run(() => _sysFunctionGroupService.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(SysFunctionGroupModel _param)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
if (_param != null)
{
await Task.Run(() => _sysFunctionGroupService.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(SysFunctionGroupModel _params)
{
try
{
_uow.SysFunctionGroupRepo.ExcQuery("exec sp_SysFunctionGroup_Insert " +
"@SysFunctionGroupCode," +
"@SysFunctionGroupName," +
"@Descriptions," +
"@Display_Order," +
"@Is_Active," +
"@CreateDate," +
"@CreateBy," +
"@UpdateDate," +
"@UpdateBy",
new SqlParameter("SysFunctionGroupCode", SqlDbType.VarChar, (50))
{
Value = _params.SysFunctionGroupCode ?? DBNull.Value.ToString()
},
new SqlParameter("SysFunctionGroupName", SqlDbType.NVarChar, (255))
{
Value = _params.SysFunctionGroupName
},
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 SysFunctionGroupModel GetById(SysFunctionGroupModel _params)
{
var data = _uow.SysFunctionGroupRepo.SQLQuery <SysFunctionGroupModel>("sp_SysFunctionGroup_GetById "
+ "@SysFunctionGroupId",
new SqlParameter("SysFunctionGroupId", SqlDbType.Int)
{
Value = _params.SysFunctionGroupId
}).FirstOrDefault();
return(data);
}
/*==Delete==*/
public void Delete(SysFunctionGroupModel _params)
{
try
{
_uow.SysFunctionGroupRepo.ExcQuery("exec sp_SysFunctionGroup_Delete " +
"@SysFunctionGroupId",
new SqlParameter("SysFunctionGroupId", SqlDbType.Int)
{
Value = _params.SysFunctionGroupId
});
}
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(SysFunctionGroupModel _param)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
if (_param != null)
{
if (string.IsNullOrEmpty(_param.SysFunctionGroupName))
{
Result.Status = false;
Result.Message = "Tên nhóm chức năng không được trống" + _param.SysFunctionGroupId;
Result.StatusCode = HttpStatusCode.BadRequest;
}
else
{
await Task.Run(() => _sysFunctionGroupService.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);
}
}
