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