public static DTO_PRO_BaoCaoTienDoNghienCuu toDTO(tbl_PRO_BaoCaoTienDoNghienCuu dbResult)
{
if (dbResult != null)
{
return(new DTO_PRO_BaoCaoTienDoNghienCuu()
{
ID = dbResult.ID,
IDDeTai = dbResult.IDDeTai,
SoCaThuThapHopLe = dbResult.SoCaThuThapHopLe,
TienDoThuNhanMau = dbResult.TienDoThuNhanMau,
KhoKhan = dbResult.KhoKhan,
CreatedDate = dbResult.CreatedDate,
CreatedBy = dbResult.CreatedBy,
ModifiedDate = dbResult.ModifiedDate,
ModifiedBy = dbResult.ModifiedBy,
IsDisabled = dbResult.IsDisabled,
IsDeleted = dbResult.IsDeleted,
TenDeTai = dbResult.TenDeTai,
ChuNhiemDeTai = dbResult.ChuNhiemDeTai,
NCVChinh = dbResult.NCVChinh,
NgayDuyetNghienCuu = dbResult.NgayDuyetNghienCuu,
SoNCT = dbResult.SoNCT,
ThoiGianTienHanh = dbResult.ThoiGianTienHanh,
CoMau = dbResult.CoMau,
IDTinhTrangNghienCuu = dbResult.IDTinhTrangNghienCuu,
FormConfig = dbResult.FormConfig,
});
}
else
{
return(null);
}
}
public static DTO_PRO_BaoCaoTienDoNghienCuu post_PRO_BaoCaoTienDoNghienCuu(AppEntities db, DTO_PRO_BaoCaoTienDoNghienCuu item, string Username)
{
tbl_PRO_BaoCaoTienDoNghienCuu dbitem = new tbl_PRO_BaoCaoTienDoNghienCuu();
if (item != null)
{
dbitem.IDDeTai = item.IDDeTai;
dbitem.SoCaThuThapHopLe = item.SoCaThuThapHopLe;
dbitem.TienDoThuNhanMau = item.TienDoThuNhanMau;
dbitem.KhoKhan = item.KhoKhan;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.TenDeTai = item.TenDeTai;
dbitem.ChuNhiemDeTai = item.ChuNhiemDeTai;
dbitem.NCVChinh = item.NCVChinh;
dbitem.NgayDuyetNghienCuu = item.NgayDuyetNghienCuu;
dbitem.SoNCT = item.SoNCT;
dbitem.ThoiGianTienHanh = item.ThoiGianTienHanh;
dbitem.CoMau = item.CoMau;
dbitem.IDTinhTrangNghienCuu = item.IDTinhTrangNghienCuu;
dbitem.FormConfig = item.FormConfig;
dbitem.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.tbl_PRO_BaoCaoTienDoNghienCuu.Add(dbitem);
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_BaoCaoTienDoNghienCuu", 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_BaoCaoTienDoNghienCuu", e);
item = null;
}
}
return(item);
}
public static DTO_PRO_BaoCaoTienDoNghienCuu post_PRO_BaoCaoTienDoNghienCuuCustom(AppEntities db, DTO_PRO_BaoCaoTienDoNghienCuu item, string Username)
{
tbl_PRO_BaoCaoTienDoNghienCuu dbitem = new tbl_PRO_BaoCaoTienDoNghienCuu();
if (item != null)
{
dbitem.IDDeTai = item.IDDeTai;
dbitem.SoCaThuThapHopLe = item.SoCaThuThapHopLe;
dbitem.TienDoThuNhanMau = item.TienDoThuNhanMau;
dbitem.KhoKhan = item.KhoKhan;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.IDTinhTrangNghienCuu = item.IDTinhTrangNghienCuu ?? -(int)SYSVarType.PhanLoaiDeTai;
dbitem.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
string sKey = SYSConfigCode.ThoiGianBaoCaoTDNC.ToString();
var config = db.tbl_SYS_Config.FirstOrDefault(c => c.Code == sKey && !c.IsDeleted);
if (config != null)
{
try
{
var setting = Newtonsoft.Json.JsonConvert.DeserializeObject <DTO_SYS_Config_ThoiGianBaoCaoTDNC>(config.Value);
if (setting != null)
{
int GiaiDoan1_NgayBatDau = setting.GiaiDoan1_NgayBatDau;
int GiaiDoan1_NgayKetThuc = setting.GiaiDoan1_NgayKetThuc;
int GiaiDoan2_NgayBatDau = setting.GiaiDoan2_NgayBatDau;
int GiaiDoan2_NgayKetThuc = setting.GiaiDoan2_NgayKetThuc;
bool isSuccess = false;
if (GiaiDoan1_NgayBatDau > 0 && GiaiDoan1_NgayKetThuc > 0)
{
if (dbitem.CreatedDate.Day >= GiaiDoan1_NgayBatDau && dbitem.CreatedDate.Day <= GiaiDoan1_NgayKetThuc)
{
isSuccess = true;
}
}
if (!isSuccess && GiaiDoan2_NgayBatDau > 0 && GiaiDoan2_NgayKetThuc > 0)
{
if (dbitem.CreatedDate.Day >= GiaiDoan2_NgayBatDau && dbitem.CreatedDate.Day <= GiaiDoan2_NgayKetThuc)
{
isSuccess = true;
}
}
if (!isSuccess)
{
item.Error = "Đã hết thời hạn được báo cáo, thời hạn báo cáo cho phép từ ngày " + GiaiDoan1_NgayBatDau.ToString("00") + " đến " + GiaiDoan1_NgayKetThuc.ToString("00") + " và từ ngày " + GiaiDoan2_NgayBatDau.ToString("00") + " đến " + GiaiDoan2_NgayKetThuc.ToString("00") + " hằng tháng";
return(item);
}
}
}
catch { }
}
var detai = db.tbl_PRO_DeTai.FirstOrDefault(c => c.ID == item.IDDeTai);
if (detai != null)
{
detai.IDTinhTrangNghienCuu = dbitem.IDTinhTrangNghienCuu;
dbitem.TenDeTai = detai.TenTiengViet;
dbitem.ChuNhiemDeTai = detai.tbl_CUS_HRM_STAFF_NhanSu1 != null ? detai.tbl_CUS_HRM_STAFF_NhanSu1.Name : "";
dbitem.SoNCT = detai.SoNCT;
dbitem.NCVChinh = detai.tbl_CUS_HRM_STAFF_NhanSu.Name;
if (detai.IDTrangThai_HDDD == -(int)SYSVarType.TrangThai_HDDD_DaDuyet)
{
var trangthaiHDDD = db.tbl_PRO_TrangThai_Log.Where(c => c.IDDeTai == item.IDDeTai && c.IDTrangThaiMoi == -(int)SYSVarType.TrangThai_HDDD_DaDuyet).OrderByDescending(c => c.CreatedDate).FirstOrDefault();
if (trangthaiHDDD != null)
{
dbitem.NgayDuyetNghienCuu = trangthaiHDDD.CreatedDate.ToString("dd/MM/yyyy HH:mm");
}
}
else
{
item.Error = "Đề tài chưa duyệt HĐĐĐ, không thể tạo báo cáo";
return(item);
}
var donxindanhgiaDD = db.tbl_PRO_DonXinDanhGiaDaoDuc.FirstOrDefault(c => c.IDDeTai == item.IDDeTai && c.IsDeleted == false);
if (donxindanhgiaDD != null)
{
dbitem.ThoiGianTienHanh = donxindanhgiaDD.ThoiGianNghienCuu;
}
//var thuyetminhdetai = db.tbl_PRO_ThuyetMinhDeTai.FirstOrDefault(c => c.IDDeTai == item.IDDeTai && c.IsDeleted == false);
//if (thuyetminhdetai != null)
//{
// dbitem.CoMau = thuyetminhdetai.B3222_CoMau;
//}
}
try
{
db.tbl_PRO_BaoCaoTienDoNghienCuu.Add(dbitem);
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_BaoCaoTienDoNghienCuu", 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_BaoCaoTienDoNghienCuuCustom", e);
item = null;
}
}
return(item);
}
