public static bool put_PRO_BaoCaoNghiemThuDeTai(AppEntities db, int ID, DTO_PRO_BaoCaoNghiemThuDeTai item, string Username)
{
bool result = false;
var dbitem = db.tbl_PRO_BaoCaoNghiemThuDeTai.Find(ID);
if (dbitem != null)
{
dbitem.IDDeTai = item.IDDeTai;
dbitem.TenDeTai = item.TenDeTai;
dbitem.ChuNhiemDeTai = item.ChuNhiemDeTai;
dbitem.JSON_DanhSachThamGia = item.JSON_DanhSachThamGia;
dbitem.JSON_TomTat = item.JSON_TomTat;
dbitem.JSON_Abstract = item.JSON_Abstract;
dbitem.JSON_LoiCamOn = item.JSON_LoiCamOn;
dbitem.JSON_MucLuc = item.JSON_MucLuc;
dbitem.JSON_CacChuVietTat = item.JSON_CacChuVietTat;
dbitem.JSON_DanhMucCacBang = item.JSON_DanhMucCacBang;
dbitem.JSON_MucTieu = item.JSON_MucTieu;
dbitem.JSON_Chuong1 = item.JSON_Chuong1;
dbitem.JSON_Chuong2 = item.JSON_Chuong2;
dbitem.JSON_VatLieuPhuongPhap = item.JSON_VatLieuPhuongPhap;
dbitem.JSON_Chuong3 = item.JSON_Chuong3;
dbitem.JSON_Chuong4 = item.JSON_Chuong4;
dbitem.JSON_Chuong5 = item.JSON_Chuong5;
dbitem.JSON_KetLuan = item.JSON_KetLuan;
dbitem.JSON_TaiLieuThamKhao = item.JSON_TaiLieuThamKhao;
dbitem.HTML = item.HTML;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.BaiFulltext = item.BaiFulltext;
dbitem.FormConfig = item.FormConfig;
dbitem.ThoiGian_Thang = item.ThoiGian_Thang;
dbitem.ThoiGian_Nam = item.ThoiGian_Nam;
dbitem.FileBaoCaoTongHop = item.FileBaoCaoTongHop;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_BaoCaoNghiemThuDeTai", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_PRO_BaoCaoNghiemThuDeTai", e);
result = false;
}
}
return(result);
}
public IHttpActionResult Get(int id)
{
DTO_PRO_BaoCaoNghiemThuDeTai tbl_PRO_BaoCaoNghiemThuDeTai = BS_PRO_BaoCaoNghiemThuDeTai.get_PRO_BaoCaoNghiemThuDeTai(db, id);
if (tbl_PRO_BaoCaoNghiemThuDeTai == null)
{
return(NotFound());
}
return(Ok(tbl_PRO_BaoCaoNghiemThuDeTai));
}
public IHttpActionResult UploadFileBaoCaoTongHop(DTO_PRO_BaoCaoNghiemThuDeTai item)
{
BS_PRO_BaoCaoNghiemThuDeTai.uploadFileBaoCaoTongHop_PRO_BaoCaoNghiemThuDeTai(db, item.ID, item.FileBaoCaoTongHop, Username);
var res = BS_PRO_BaoCaoNghiemThuDeTai.get_PRO_BaoCaoNghiemThuDeTaiCustom(db, item.ID);
if (res == null)
{
return(NotFound());
}
return(Ok(res));
}
public IHttpActionResult UploadFullText(DTO_PRO_BaoCaoNghiemThuDeTai item)
{
BS_PRO_BaoCaoNghiemThuDeTai.uploadFullText_PRO_BaoCaoNghiemThuDeTai(db, item.ID, item.BaiFulltext, Username);
var res = BS_PRO_BaoCaoNghiemThuDeTai.get_PRO_BaoCaoNghiemThuDeTaiCustom(db, item.ID);
if (res == null)
{
return(NotFound());
}
return(Ok(res));
}
public IHttpActionResult Post(DTO_PRO_BaoCaoNghiemThuDeTai tbl_PRO_BaoCaoNghiemThuDeTai)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DTO_PRO_BaoCaoNghiemThuDeTai result = BS_PRO_BaoCaoNghiemThuDeTai.post_PRO_BaoCaoNghiemThuDeTai(db, tbl_PRO_BaoCaoNghiemThuDeTai, Username);
if (result != null)
{
return(CreatedAtRoute("get_PRO_BaoCaoNghiemThuDeTai", new { id = result.ID }, result));
}
return(Conflict());
}
public IHttpActionResult Save(DTO_PRO_BaoCaoNghiemThuDeTai tbl_PRO_BaoCaoNghiemThuDeTai)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DTO_PRO_BaoCaoNghiemThuDeTai result = BS_PRO_BaoCaoNghiemThuDeTai.save_PRO_BaoCaoNghiemThuDeTai(db, tbl_PRO_BaoCaoNghiemThuDeTai, Username);
if (result != null)
{
return(Ok(result));
}
return(BadRequest());
}
public IHttpActionResult GetCustom(int idDeTai, bool?isInput = false)
{
DTO_PRO_BaoCaoNghiemThuDeTai tbl_PRO_BaoCaoNghiemThuDeTai = BS_PRO_BaoCaoNghiemThuDeTai.get_PRO_BaoCaoNghiemThuDeTaiCustom(db, idDeTai);
string html = "";
string htmlPrint = "";
using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/BaoCaoNghiemThuDeTai.html")))
{
htmlPrint = r.ReadToEnd();
}
using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/BaoCaoNghiemThuDeTai_Input.html")))
{
html = r.ReadToEnd();
}
tbl_PRO_BaoCaoNghiemThuDeTai.HTML = html;
tbl_PRO_BaoCaoNghiemThuDeTai.HTMLPrint = htmlPrint;
return(Ok(tbl_PRO_BaoCaoNghiemThuDeTai));
}
public IHttpActionResult Put(int id, DTO_PRO_BaoCaoNghiemThuDeTai tbl_PRO_BaoCaoNghiemThuDeTai)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_PRO_BaoCaoNghiemThuDeTai.ID)
{
return(BadRequest());
}
bool result = BS_PRO_BaoCaoNghiemThuDeTai.put_PRO_BaoCaoNghiemThuDeTai(db, id, tbl_PRO_BaoCaoNghiemThuDeTai, Username);
if (result)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(NotFound());
}
}
public static DTO_PRO_BaoCaoNghiemThuDeTai get_PRO_BaoCaoNghiemThuDeTaiCustom(AppEntities db, int idDeTai)
{
DTO_PRO_BaoCaoNghiemThuDeTai query = null;
query = db.tbl_PRO_BaoCaoNghiemThuDeTai.Where(d => d.IDDeTai == idDeTai && d.IsDeleted == false).Select(s => new DTO_PRO_BaoCaoNghiemThuDeTai
{
ID = s.ID,
IDDeTai = s.IDDeTai,
TenDeTai = s.TenDeTai,
ChuNhiemDeTai = s.ChuNhiemDeTai,
JSON_DanhSachThamGia = s.JSON_DanhSachThamGia,
JSON_TomTat = s.JSON_TomTat,
JSON_Abstract = s.JSON_Abstract,
JSON_LoiCamOn = s.JSON_LoiCamOn,
JSON_MucLuc = s.JSON_MucLuc,
JSON_CacChuVietTat = s.JSON_CacChuVietTat,
JSON_DanhMucCacBang = s.JSON_DanhMucCacBang,
JSON_MucTieu = s.JSON_MucTieu,
JSON_Chuong1 = s.JSON_Chuong1,
JSON_Chuong2 = s.JSON_Chuong2,
JSON_VatLieuPhuongPhap = s.JSON_VatLieuPhuongPhap,
JSON_Chuong3 = s.JSON_Chuong3,
JSON_Chuong4 = s.JSON_Chuong4,
JSON_Chuong5 = s.JSON_Chuong5,
JSON_KetLuan = s.JSON_KetLuan,
JSON_TaiLieuThamKhao = s.JSON_TaiLieuThamKhao,
HTML = s.HTML,
IsDisabled = s.IsDisabled,
IsDeleted = s.IsDeleted,
CreatedDate = s.CreatedDate,
CreatedBy = s.CreatedBy,
ModifiedDate = s.ModifiedDate,
ModifiedBy = s.ModifiedBy,
BaiFulltext = s.BaiFulltext,
FormConfig = s.FormConfig,
ThoiGian_Thang = s.ThoiGian_Thang,
ThoiGian_Nam = s.ThoiGian_Nam,
}).FirstOrDefault();
if (query == null)
{
//New
query = new DTO_PRO_BaoCaoNghiemThuDeTai
{
IDDeTai = idDeTai,
};
var detai = db.tbl_PRO_DeTai.FirstOrDefault(c => c.ID == idDeTai);
if (detai != null)
{
query.TenDeTai = detai.TenTiengViet;
query.ChuNhiemDeTai = detai.tbl_CUS_HRM_STAFF_NhanSu1 != null ? detai.tbl_CUS_HRM_STAFF_NhanSu1.Name : "";
}
}
if (!string.IsNullOrWhiteSpace(query.JSON_DanhSachThamGia))
{
query.ListCanBo = JsonConvert.DeserializeObject <List <DTO_PRO_BaoCaoNghiemThuDeTai_CanBo> >(query.JSON_DanhSachThamGia);
}
else
{
query.ListCanBo = new List <DTO_PRO_BaoCaoNghiemThuDeTai_CanBo>()
{
new DTO_PRO_BaoCaoNghiemThuDeTai_CanBo(), new DTO_PRO_BaoCaoNghiemThuDeTai_CanBo()
};
}
if (!string.IsNullOrWhiteSpace(query.JSON_TomTat))
{
}
if (!string.IsNullOrWhiteSpace(query.JSON_Abstract))
{
}
if (!string.IsNullOrWhiteSpace(query.JSON_LoiCamOn))
{
}
if (!string.IsNullOrWhiteSpace(query.JSON_CacChuVietTat))
{
}
if (!string.IsNullOrWhiteSpace(query.JSON_DanhMucCacBang))
{
}
if (!string.IsNullOrWhiteSpace(query.JSON_MucTieu))
{
}
if (!string.IsNullOrWhiteSpace(query.JSON_Chuong1))
{
}
if (!string.IsNullOrWhiteSpace(query.JSON_Chuong2))
{
}
if (!string.IsNullOrWhiteSpace(query.JSON_VatLieuPhuongPhap))
{
}
if (!string.IsNullOrWhiteSpace(query.JSON_Chuong3))
{
}
if (!string.IsNullOrWhiteSpace(query.JSON_Chuong4))
{
}
if (!string.IsNullOrWhiteSpace(query.JSON_Chuong5))
{
}
if (!string.IsNullOrWhiteSpace(query.JSON_KetLuan))
{
}
if (!string.IsNullOrWhiteSpace(query.JSON_TaiLieuThamKhao))
{
}
return(query);
}
public static DTO_PRO_BaoCaoNghiemThuDeTai save_PRO_BaoCaoNghiemThuDeTai(AppEntities db, DTO_PRO_BaoCaoNghiemThuDeTai item, string Username)
{
var dbitem = db.tbl_PRO_BaoCaoNghiemThuDeTai.FirstOrDefault(c => c.IDDeTai == item.IDDeTai && c.IsDeleted == false);
if (dbitem == null)
{
dbitem = new tbl_PRO_BaoCaoNghiemThuDeTai();
dbitem.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
dbitem.TenDeTai = item.TenDeTai;
dbitem.ChuNhiemDeTai = item.ChuNhiemDeTai;
db.tbl_PRO_BaoCaoNghiemThuDeTai.Add(dbitem);
}
dbitem.IDDeTai = item.IDDeTai;
dbitem.BaiFulltext = item.BaiFulltext;
dbitem.JSON_TomTat = item.JSON_TomTat;
dbitem.JSON_Abstract = item.JSON_Abstract;
dbitem.JSON_LoiCamOn = item.JSON_LoiCamOn;
dbitem.JSON_MucLuc = item.JSON_MucLuc;
dbitem.JSON_CacChuVietTat = item.JSON_CacChuVietTat;
dbitem.JSON_DanhMucCacBang = item.JSON_DanhMucCacBang;
dbitem.JSON_MucTieu = item.JSON_MucTieu;
dbitem.JSON_Chuong1 = item.JSON_Chuong1;
dbitem.JSON_Chuong2 = item.JSON_Chuong2;
dbitem.JSON_VatLieuPhuongPhap = item.JSON_VatLieuPhuongPhap;
dbitem.JSON_Chuong3 = item.JSON_Chuong3;
dbitem.JSON_Chuong4 = item.JSON_Chuong4;
dbitem.JSON_Chuong5 = item.JSON_Chuong5;
dbitem.JSON_KetLuan = item.JSON_KetLuan;
dbitem.JSON_TaiLieuThamKhao = item.JSON_TaiLieuThamKhao;
if (item.ListCanBo != null)
{
dbitem.JSON_DanhSachThamGia = JsonConvert.SerializeObject(item.ListCanBo);
}
else
{
dbitem.JSON_DanhSachThamGia = string.Empty;
}
dbitem.FormConfig = item.FormConfig;
dbitem.ThoiGian_Nam = item.ThoiGian_Nam;
dbitem.ThoiGian_Thang = item.ThoiGian_Thang;
dbitem.HTML = item.HTML;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_BaoCaoNghiemThuDeTai", DateTime.Now, Username);
item.ID = dbitem.ID;
item.CreatedBy = dbitem.CreatedBy;
item.CreatedDate = dbitem.CreatedDate;
item.ModifiedBy = dbitem.ModifiedBy;
item.ModifiedDate = dbitem.ModifiedDate;
return(item);
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("save_PRO_BaoCaoNghiemThuDeTai", e);
return(null);
}
}