public static DTO_CUS_DOC_FileInFolder post_CUS_DOC_FileInFolder(AppEntities db, int PartnerID, DTO_CUS_DOC_FileInFolder item, string Username)
{
tbl_CUS_DOC_FileInFolder dbitem = new tbl_CUS_DOC_FileInFolder();
if (item != null)
{
dbitem.IDFolder = item.IDFolder;
dbitem.IDFile = item.IDFile;
dbitem.Sort = item.Sort;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
dbitem.IDPartner = PartnerID;
try
{
db.tbl_CUS_DOC_FileInFolder.Add(dbitem);
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, dbitem.IDPartner, "DTO_CUS_DOC_FileInFolder", dbitem.ModifiedDate, Username);
item.ID = dbitem.ID;
item.CreatedBy = dbitem.CreatedBy;
item.CreatedDate = dbitem.CreatedDate;
item.ModifiedBy = dbitem.ModifiedBy;
item.ModifiedDate = dbitem.ModifiedDate;
item.IDPartner = dbitem.IDPartner;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("post_CUS_DOC_FileInFolder", e);
item = null;
}
}
return(item);
}
public static DTO_CUS_DOC_FileInFolder toDTO(tbl_CUS_DOC_FileInFolder dbResult)
{
if (dbResult != null)
{
return(new DTO_CUS_DOC_FileInFolder()
{
IDPartner = dbResult.IDPartner,
IDFolder = dbResult.IDFolder,
IDFile = dbResult.IDFile,
ID = dbResult.ID,
Sort = dbResult.Sort,
IsDisabled = dbResult.IsDisabled,
IsDeleted = dbResult.IsDeleted,
CreatedBy = dbResult.CreatedBy,
ModifiedBy = dbResult.ModifiedBy,
CreatedDate = dbResult.CreatedDate,
ModifiedDate = dbResult.ModifiedDate,
});
}
else
{
return(null);
}
}
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);
}
