public static DTO_PRO_BaoCaoNghiemThuDeTai toDTO(tbl_PRO_BaoCaoNghiemThuDeTai dbResult)
{
if (dbResult != null)
{
return(new DTO_PRO_BaoCaoNghiemThuDeTai()
{
ID = dbResult.ID,
IDDeTai = dbResult.IDDeTai,
TenDeTai = dbResult.TenDeTai,
ChuNhiemDeTai = dbResult.ChuNhiemDeTai,
JSON_DanhSachThamGia = dbResult.JSON_DanhSachThamGia,
JSON_TomTat = dbResult.JSON_TomTat,
JSON_Abstract = dbResult.JSON_Abstract,
JSON_LoiCamOn = dbResult.JSON_LoiCamOn,
JSON_MucLuc = dbResult.JSON_MucLuc,
JSON_CacChuVietTat = dbResult.JSON_CacChuVietTat,
JSON_DanhMucCacBang = dbResult.JSON_DanhMucCacBang,
JSON_MucTieu = dbResult.JSON_MucTieu,
JSON_Chuong1 = dbResult.JSON_Chuong1,
JSON_Chuong2 = dbResult.JSON_Chuong2,
JSON_VatLieuPhuongPhap = dbResult.JSON_VatLieuPhuongPhap,
JSON_Chuong3 = dbResult.JSON_Chuong3,
JSON_Chuong4 = dbResult.JSON_Chuong4,
JSON_Chuong5 = dbResult.JSON_Chuong5,
JSON_KetLuan = dbResult.JSON_KetLuan,
JSON_TaiLieuThamKhao = dbResult.JSON_TaiLieuThamKhao,
HTML = dbResult.HTML,
IsDisabled = dbResult.IsDisabled,
IsDeleted = dbResult.IsDeleted,
CreatedDate = dbResult.CreatedDate,
CreatedBy = dbResult.CreatedBy,
ModifiedDate = dbResult.ModifiedDate,
ModifiedBy = dbResult.ModifiedBy,
BaiFulltext = dbResult.BaiFulltext,
FormConfig = dbResult.FormConfig,
ThoiGian_Thang = dbResult.ThoiGian_Thang,
ThoiGian_Nam = dbResult.ThoiGian_Nam,
FileBaoCaoTongHop = dbResult.FileBaoCaoTongHop,
});
}
else
{
return(null);
}
}
public static bool uploadFileBaoCaoTongHop_PRO_BaoCaoNghiemThuDeTai(AppEntities db, int ID, string path, string Username)
{
bool result = false;
var dbitem = db.tbl_PRO_BaoCaoNghiemThuDeTai.FirstOrDefault(c => c.IDDeTai == ID);
if (dbitem == null)
{
dbitem = new tbl_PRO_BaoCaoNghiemThuDeTai();
dbitem.CreatedDate = DateTime.Now;
dbitem.CreatedBy = Username;
dbitem.IDDeTai = ID;
db.tbl_PRO_BaoCaoNghiemThuDeTai.Add(dbitem);
var detai = db.tbl_PRO_DeTai.FirstOrDefault(c => c.ID == ID);
if (detai != null)
{
dbitem.TenDeTai = detai.TenTiengViet;
dbitem.ChuNhiemDeTai = detai.tbl_CUS_HRM_STAFF_NhanSu1 != null ? detai.tbl_CUS_HRM_STAFF_NhanSu1.Name : "";
}
}
else
{
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
}
dbitem.FileBaoCaoTongHop = path;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_BaoCaoNghiemThuDeTai", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("uploadFileBaoCaoTongHop_PRO_BaoCaoNghiemThuDeTai", e);
result = false;
}
return(result);
}
public static DTO_PRO_BaoCaoNghiemThuDeTai post_PRO_BaoCaoNghiemThuDeTai(AppEntities db, DTO_PRO_BaoCaoNghiemThuDeTai item, string Username)
{
tbl_PRO_BaoCaoNghiemThuDeTai dbitem = new tbl_PRO_BaoCaoNghiemThuDeTai();
if (item != 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.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.tbl_PRO_BaoCaoNghiemThuDeTai.Add(dbitem);
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;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("post_PRO_BaoCaoNghiemThuDeTai", e);
item = null;
}
}
return(item);
}
public static bool uploadFullText_PRO_BaoCaoNghiemThuDeTai(AppEntities db, int ID, string path, string Username)
{
bool result = false;
var dbitem = db.tbl_PRO_BaoCaoNghiemThuDeTai.FirstOrDefault(c => c.IDDeTai == ID);
if (dbitem == null)
{
dbitem = new tbl_PRO_BaoCaoNghiemThuDeTai();
dbitem.CreatedDate = DateTime.Now;
dbitem.CreatedBy = Username;
dbitem.IDDeTai = ID;
db.tbl_PRO_BaoCaoNghiemThuDeTai.Add(dbitem);
var detai = db.tbl_PRO_DeTai.FirstOrDefault(c => c.ID == ID);
if (detai != null)
{
dbitem.TenDeTai = detai.TenTiengViet;
dbitem.ChuNhiemDeTai = detai.tbl_CUS_HRM_STAFF_NhanSu1 != null ? detai.tbl_CUS_HRM_STAFF_NhanSu1.Name : "";
}
}
else
{
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
}
if (!string.IsNullOrEmpty(dbitem.BaiFulltext))
{
var oldFile = db.tbl_CUS_DOC_File.FirstOrDefault(c => c.Path == dbitem.BaiFulltext);
if (oldFile != null)
{
oldFile.IsDeleted = true;
var fileInFolder = db.tbl_CUS_DOC_FileInFolder.FirstOrDefault(c => c.IDFile == oldFile.ID && c.IsDeleted == false);
if (fileInFolder != null)
{
fileInFolder.IsDeleted = true;
}
}
}
dbitem.BaiFulltext = path;
var file = db.tbl_CUS_DOC_File.FirstOrDefault(c => c.Path == path);
if (file != null)
{
file.IDDeTai = ID;
file.IsApproved = true;
file.IsDeleted = false;
var detai = db.tbl_PRO_DeTai.FirstOrDefault(c => c.ID == ID);
if (detai.IDLinhVuc > 0)
{
var folder = db.tbl_CUS_DOC_Folder.FirstOrDefault(c => c.IDLinhVuc == detai.IDLinhVuc);
if (folder != null)
{
var fileInFolder = db.tbl_CUS_DOC_FileInFolder.FirstOrDefault(c => c.IDFile == file.ID && c.IDFolder == folder.ID && c.IsDeleted == false);
if (fileInFolder == null)
{
fileInFolder = new tbl_CUS_DOC_FileInFolder();
fileInFolder.CreatedBy = Username;
fileInFolder.CreatedDate = DateTime.Now;
fileInFolder.ModifiedBy = Username;
fileInFolder.ModifiedDate = DateTime.Now;
fileInFolder.IDFile = file.ID;
fileInFolder.IDFolder = folder.ID;
fileInFolder.IDPartner = 1;
db.tbl_CUS_DOC_FileInFolder.Add(fileInFolder);
}
}
}
}
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_BaoCaoNghiemThuDeTai", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("uploadFullText_PRO_BaoCaoNghiemThuDeTai", e);
result = false;
}
return(result);
}
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);
}
}
