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