public IHttpActionResult Get(int id) { DTO_PRO_HoiNghiHoiThao_DangKyDeTai tbl_PRO_HoiNghiHoiThao_DangKyDeTai = BS_PRO_HoiNghiHoiThao_DangKyDeTai.get_PRO_HoiNghiHoiThao_DangKyDeTai(db, id); if (tbl_PRO_HoiNghiHoiThao_DangKyDeTai == null) { return(NotFound()); } return(Ok(tbl_PRO_HoiNghiHoiThao_DangKyDeTai)); }
public IHttpActionResult UploadFullText(DTO_PRO_HoiNghiHoiThao_DangKyDeTai item) { BS_PRO_HoiNghiHoiThao_DangKyDeTai.uploadFullText_PRO_HoiNghiHoiThaoDangKyDeTai(db, item.ID, item.BaiFulltext, Username); var res = BS_PRO_HoiNghiHoiThao_DangKyDeTai.get_PRO_HoiNghiHoiThao_DangKyDeTai(db, item.ID); if (res == null) { return(NotFound()); } return(Ok(res)); }
public IHttpActionResult UpdateStatus(int id, string actionCode) { var result = BS_PRO_HoiNghiHoiThao_DangKyDeTai.updateStatus_PRO_HoiNghiHoiThaoDangKyDeTai(db, id, actionCode, Username); if (!string.IsNullOrEmpty(result)) { return(BadRequest(result)); } DTO_PRO_HoiNghiHoiThao_DangKyDeTai tbl_PRO_HoiNghiHoiThao = BS_PRO_HoiNghiHoiThao_DangKyDeTai.get_PRO_HoiNghiHoiThao_DangKyDeTai(db, id); if (tbl_PRO_HoiNghiHoiThao == null) { return(NotFound()); } return(Ok(tbl_PRO_HoiNghiHoiThao)); }
public IHttpActionResult Delete(int id) { bool check = BS_PRO_HoiNghiHoiThao_DangKyDeTai.check_PRO_HoiNghiHoiThao_DangKyDeTai_Exists(db, id); if (!check) { return(NotFound()); } bool result = BS_PRO_HoiNghiHoiThao_DangKyDeTai.delete_PRO_HoiNghiHoiThao_DangKyDeTai(db, id, Username); if (result) { return(StatusCode(HttpStatusCode.NoContent)); } return(Conflict()); }
public IHttpActionResult Post(DTO_PRO_HoiNghiHoiThao_DangKyDeTai tbl_PRO_HoiNghiHoiThao_DangKyDeTai) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } DTO_PRO_HoiNghiHoiThao_DangKyDeTai result = BS_PRO_HoiNghiHoiThao_DangKyDeTai.post_PRO_HoiNghiHoiThao_DangKyDeTaiCustom(db, tbl_PRO_HoiNghiHoiThao_DangKyDeTai, Username); if (result != null) { if (!string.IsNullOrEmpty(result.Error)) { return(BadRequest(result.Error)); } return(CreatedAtRoute("get_PRO_HoiNghiHoiThao_DangKyDeTai", new { id = result.ID }, result)); } return(Conflict()); }
public HttpResponseMessage Get_HoiNghiHoiThao() { string fileurl = ""; var package = GetTemplateWorkbook("DS-BaoCaoHoiNghiHoiThao.xlsx", "DS-BaoCaoHoiNghiHoiThao.xlsx-" + DateTime.Now.ToString("HHmmss") + ".xlsx", out fileurl); ExcelWorkbook workBook = package.Workbook; if (workBook != null) { var ws = workBook.Worksheets.FirstOrDefault(); //Worksheets["DS"]; var data = BS_PRO_HoiNghiHoiThao_DangKyDeTai.getExcel_PRO_HoiNghiHoiThao_DangKyDeTaiTheoHoiNghi(db, 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.TenHoiNghi; col++; ws.Cells[rowid, col].Value = item.DiaDiem; col++; ws.Cells[rowid, col].Value = item.ThoiGian.ToString("dd/MM/yyy HH:mm:ss"); col++; ws.Cells[rowid, col].Value = item.ThoiGianHetHan.Value.ToString("dd/MM/yyy HH:mm:ss"); col++; ws.Cells[rowid, col].Value = item.TongSoNguoiDangKy; col++; ws.Cells[rowid, col].Value = item.TongSoDeTaiDangKy; col++; ws.Cells[rowid, col].Value = item.TenNCV; col++; ws.Cells[rowid, col].Value = item.TenDeTai; col++; ws.Cells[rowid, col].Value = item.HinhThucDangKy; col++; ws.Cells[rowid, col].Value = item.TrangThai; col++; ws.Cells[rowid, col].Value = !string.IsNullOrEmpty(item.TenNCV) ? item.CreatedDate.ToString("dd/MM/yyy HH:mm:ss") : ""; col++; rowid++; sort++; } package.Save(); } return(downloadFile(fileurl)); }
public IHttpActionResult Put(int id, DTO_PRO_HoiNghiHoiThao_DangKyDeTai tbl_PRO_HoiNghiHoiThao_DangKyDeTai) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_PRO_HoiNghiHoiThao_DangKyDeTai.ID) { return(BadRequest()); } string result = BS_PRO_HoiNghiHoiThao_DangKyDeTai.put_PRO_HoiNghiHoiThao_DangKyDeTaiCustom(db, id, tbl_PRO_HoiNghiHoiThao_DangKyDeTai, Username); if (string.IsNullOrEmpty(result)) { return(StatusCode(HttpStatusCode.NoContent)); } else { return(BadRequest(result)); } }
public IQueryable <DTO_PRO_HoiNghiHoiThao_DangKyDeTai> Get() { return(BS_PRO_HoiNghiHoiThao_DangKyDeTai.get_PRO_HoiNghiHoiThao_DangKyDeTai(db, QueryStrings)); }
public IQueryable <DTO_PRO_HoiNghiHoiThao_DangKyDeTai> GetDeTaiByDangKy(int idDangKy) { return(BS_PRO_HoiNghiHoiThao_DangKyDeTai.get_PRO_HoiNghiHoiThao_DangKyDeTaiTheoDangKy(db, QueryStrings, idDangKy)); }