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)); }