public IHttpActionResult Get(int id)
{
DTO_PRO_BaoCaoTienDoNghienCuu tbl_PRO_BaoCaoTienDoNghienCuu = BS_PRO_BaoCaoTienDoNghienCuu.get_PRO_BaoCaoTienDoNghienCuu(db, id);
if (tbl_PRO_BaoCaoTienDoNghienCuu == null)
{
return(NotFound());
}
return(Ok(tbl_PRO_BaoCaoTienDoNghienCuu));
}
public IHttpActionResult Delete(int id)
{
bool check = BS_PRO_BaoCaoTienDoNghienCuu.check_PRO_BaoCaoTienDoNghienCuu_Exists(db, id);
if (!check)
{
return(NotFound());
}
bool result = BS_PRO_BaoCaoTienDoNghienCuu.delete_PRO_BaoCaoTienDoNghienCuu(db, id, Username);
if (result)
{
return(StatusCode(HttpStatusCode.NoContent));
}
return(Conflict());
}
public HttpResponseMessage Get_BaoCaoTienDoNghienCuu()
{
string fileurl = "";
var package = GetTemplateWorkbook("DS-BaoCaoTienDoNghienCuu.xlsx", "DS-BaoCaoTienDoNghienCuu-" + 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_BaoCaoTienDoNghienCuu.get_PRO_BaoCaoTienDoNghienCuuTheoDeTaiChiTiet(db, QueryStrings);
int rowid = 3;
foreach (var item in data)
{
int col = 2;
ws.Cells[rowid, col].Value = item.Sort; col++;
ws.Cells[rowid, col].Value = item.TenDeTai; col++;
ws.Cells[rowid, col].Value = item.ChuNhiemDeTai; col++;
ws.Cells[rowid, col].Value = item.NCVChinh; col++;
ws.Cells[rowid, col].Value = item.SoNCT; col++;
ws.Cells[rowid, col].Value = item.NgayDuyetNghienCuu; col++;
ws.Cells[rowid, col].Value = item.ThoiGianTienHanh; col++;
ws.Cells[rowid, col].Value = item.CompletePercent; col++;
ws.Cells[rowid, col].Value = item.SoLanDaBaoCao; col++;
ws.Cells[rowid, col].Value = item.CoMau; col++;
ws.Cells[rowid, col].Value = item.SoCaThuThapHopLe; col++;
ws.Cells[rowid, col].Value = item.TienDoThuNhanMau; col++;
ws.Cells[rowid, col].Value = item.KhoKhan; col++;
ws.Cells[rowid, col].Value = item.TinhTrangNghienCuuHienTai; col++;
ws.Cells[rowid, col].Value = item.TinhTrangNghienCuu; col++;
ws.Cells[rowid, col].Value = item.CreatedDate.ToString("dd/MM/yyy HH:mm:ss"); col++;
ws.Cells[rowid, col].Value = item.CreatedBy; col++;
rowid++;
}
package.Save();
}
return(downloadFile(fileurl));
}
public IHttpActionResult Post(DTO_PRO_BaoCaoTienDoNghienCuu tbl_PRO_BaoCaoTienDoNghienCuu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DTO_PRO_BaoCaoTienDoNghienCuu result = BS_PRO_BaoCaoTienDoNghienCuu.post_PRO_BaoCaoTienDoNghienCuuCustom(db, tbl_PRO_BaoCaoTienDoNghienCuu, Username);
if (!string.IsNullOrEmpty(result.Error))
{
return(BadRequest(result.Error));
}
if (result != null)
{
return(CreatedAtRoute("get_PRO_BaoCaoTienDoNghienCuu", new { id = result.ID }, result));
}
return(Conflict());
}
public IHttpActionResult Put(int id, DTO_PRO_BaoCaoTienDoNghienCuu tbl_PRO_BaoCaoTienDoNghienCuu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_PRO_BaoCaoTienDoNghienCuu.ID)
{
return(BadRequest());
}
string result = BS_PRO_BaoCaoTienDoNghienCuu.put_PRO_BaoCaoTienDoNghienCuuCustom(db, id, tbl_PRO_BaoCaoTienDoNghienCuu, Username);
if (string.IsNullOrEmpty(result))
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(BadRequest(result));
}
}
public IQueryable <DTO_PRO_BaoCaoTienDoNghienCuu> GetAll()
{
return(BS_PRO_BaoCaoTienDoNghienCuu.get_PRO_BaoCaoTienDoNghienCuu(db, QueryStrings));
}
public List <DTO_PRO_BaoCaoTienDoNghienCuu_DeTai> GetTheoDeTai()
{
return(BS_PRO_BaoCaoTienDoNghienCuu.get_PRO_BaoCaoTienDoNghienCuuTheoDeTai(db, QueryStrings));
}
public IQueryable <DTO_PRO_BaoCaoTienDoNghienCuu> GetByDeTai(int deTaiId)
{
return(BS_PRO_BaoCaoTienDoNghienCuu.get_PRO_BaoCaoTienDoNghienCuuByDeTai(db, deTaiId, QueryStrings));
}