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