public IHttpActionResult Put(int id, DTO_PRO_BaoCaoNangSuatKhoaHoc tbl_PRO_BaoCaoNangSuatKhoaHoc)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_PRO_BaoCaoNangSuatKhoaHoc.ID)
{
return(BadRequest());
}
ApplicationUser user = UserManager.FindById(User.Identity.GetUserId());
if (user.StaffID <= 0)
{
return(BadRequest("Chưa tạo nhân sự cho tài khoản"));
}
string res = BS_PRO_BaoCaoNangSuatKhoaHoc.put_PRO_BaoCaoNangSuatKhoaHocCustom(db, id, tbl_PRO_BaoCaoNangSuatKhoaHoc, Username);
if (string.IsNullOrEmpty(res))
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(BadRequest(res));
}
}
public IHttpActionResult Post(DTO_PRO_BaoCaoNangSuatKhoaHoc tbl_PRO_BaoCaoNangSuatKhoaHoc)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
ApplicationUser user = UserManager.FindById(User.Identity.GetUserId());
if (user.StaffID <= 0)
{
return(BadRequest("Tài khoản chưa tạo nhân sự, không thể tạo mới"));
}
DTO_PRO_BaoCaoNangSuatKhoaHoc result = BS_PRO_BaoCaoNangSuatKhoaHoc.post_PRO_BaoCaoNangSuatKhoaHocCustom(db, user.StaffID, tbl_PRO_BaoCaoNangSuatKhoaHoc, Username);
if (result != null && !string.IsNullOrEmpty(result.Error))
{
return(BadRequest(result.Error));
}
if (result != null)
{
return(CreatedAtRoute("get_PRO_BaoCaoNangSuatKhoaHoc", new { id = result.ID }, result));
}
return(Conflict());
}
public IHttpActionResult Get(int id)
{
DTO_PRO_BaoCaoNangSuatKhoaHoc tbl_PRO_BaoCaoNangSuatKhoaHoc = BS_PRO_BaoCaoNangSuatKhoaHoc.get_PRO_BaoCaoNangSuatKhoaHocByID(db, id);
if (tbl_PRO_BaoCaoNangSuatKhoaHoc == null)
{
return(NotFound());
}
return(Ok(tbl_PRO_BaoCaoNangSuatKhoaHoc));
}
public IHttpActionResult UpdateStatus(int id, string actionCode)
{
var result = BS_PRO_BaoCaoNangSuatKhoaHoc.updateStatus_PRO_BaoCaoNangSuatKhoaHoc(db, id, actionCode, Username);
if (!string.IsNullOrEmpty(result))
{
return(BadRequest(result));
}
DTO_PRO_BaoCaoNangSuatKhoaHoc tbl_PRO_BaoCaoNangSuatKhoaHoc = BS_PRO_BaoCaoNangSuatKhoaHoc.get_PRO_BaoCaoNangSuatKhoaHoc(db, id);
if (tbl_PRO_BaoCaoNangSuatKhoaHoc == null)
{
return(NotFound());
}
return(Ok(tbl_PRO_BaoCaoNangSuatKhoaHoc));
}
public IHttpActionResult Delete(int id)
{
bool check = BS_PRO_BaoCaoNangSuatKhoaHoc.check_PRO_BaoCaoNangSuatKhoaHoc_Exists(db, id);
if (!check)
{
return(NotFound());
}
bool result = BS_PRO_BaoCaoNangSuatKhoaHoc.delete_PRO_BaoCaoNangSuatKhoaHoc(db, id, Username);
if (result)
{
return(StatusCode(HttpStatusCode.NoContent));
}
return(Conflict());
}
public HttpResponseMessage Get_BaoCaoNangSuatKhoaHoc()
{
string fileurl = "";
var package = GetTemplateWorkbook("DS-BaoCaoNangSuatKhoaHoc.xlsx", "DS-BaoCaoNangSuatKhoaHoc-" + DateTime.Now.ToString("HHmmss") + ".xlsx", out fileurl);
ApplicationUser user = UserManager.FindById(User.Identity.GetUserId());
ExcelWorkbook workBook = package.Workbook;
if (workBook != null)
{
var ws = workBook.Worksheets.FirstOrDefault(); //Worksheets["DS"];
var data = BS_PRO_BaoCaoNangSuatKhoaHoc.get_PRO_BaoCaoNangSuatKhoaHocCustom(db, user.StaffID, QueryStrings);
int rowid = 3;
int sort = 1;
foreach (var item in data)
{
int col = 2;
ws.Cells[rowid, col].Value = sort; col++;
ws.Cells[rowid, col].Value = item.TenDeTai; col++;
ws.Cells[rowid, col].Value = item.NgayBaoCao.ToString("dd/MM/yyy"); col++;
ws.Cells[rowid, col].Value = item.TapChiHoiNghi; col++;
ws.Cells[rowid, col].Value = item.TenKinhPhi; col++;
ws.Cells[rowid, col].Value = item.GhiChuKinhPhi; col++;
ws.Cells[rowid, col].Value = item.KinhPhi; col++;
ws.Cells[rowid, col].Value = item.TrangThaiDuyet; col++;
ws.Cells[rowid, col].Value = item.CreatedBy; col++;
ws.Cells[rowid, col].Value = item.CreatedDate.ToString("dd/MM/yyy HH:mm:ss"); col++;
rowid++;
sort++;
}
package.Save();
}
return(downloadFile(fileurl));
}
public IQueryable <DTO_PRO_BaoCaoNangSuatKhoaHoc> Get()
{
ApplicationUser user = UserManager.FindById(User.Identity.GetUserId());
return(BS_PRO_BaoCaoNangSuatKhoaHoc.get_PRO_BaoCaoNangSuatKhoaHocCustom(db, user.StaffID, QueryStrings));
}
