public static DTO_SYS_Config toDTO(tbl_SYS_Config dbResult) { if (dbResult != null) { return(new DTO_SYS_Config() { ID = dbResult.ID, Code = dbResult.Code, Name = dbResult.Name, Remark = dbResult.Remark, Sort = dbResult.Sort, IsDisabled = dbResult.IsDisabled, IsDeleted = dbResult.IsDeleted, CreatedBy = dbResult.CreatedBy, ModifiedBy = dbResult.ModifiedBy, CreatedDate = dbResult.CreatedDate, ModifiedDate = dbResult.ModifiedDate, Value = dbResult.Value, }); } else { return(null); } }
public static DTO_SYS_Config post_SYS_ConfigEmail_Template(AppEntities db, DTO_SYS_Config item, string Username) { var dbitem = db.tbl_SYS_Config.FirstOrDefault(c => c.Code == item.Code && !c.IsDeleted); if (dbitem == null) { dbitem = new tbl_SYS_Config(); dbitem.CreatedBy = Username; dbitem.CreatedDate = DateTime.Now; dbitem.ModifiedBy = Username; dbitem.ModifiedDate = DateTime.Now; dbitem.Code = item.Code; db.tbl_SYS_Config.Add(dbitem); } else { dbitem.ModifiedBy = Username; dbitem.ModifiedDate = DateTime.Now; } item.Email.Subject = item.Subject; item.Email.Body = item.Body; item.Email.EmailList = item.EmailList; dbitem.Value = Newtonsoft.Json.JsonConvert.SerializeObject(item.Email); if (dbitem != null) { try { db.SaveChanges(); BS_CUS_Version.update_CUS_Version(db, null, "post_SYS_ConfigEmail_Template", dbitem.ModifiedDate, 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_SYS_ConfigEmail_Template", e); item = null; } } return(item); }
public static DTO_SYS_Config post_SYS_Config_ThoiGianBaoCaoNSKH(AppEntities db, DTO_SYS_Config item, string Username) { string sKey = SYSConfigCode.ThoiGianBaoCaoNSKH.ToString(); var dbitem = db.tbl_SYS_Config.FirstOrDefault(c => c.Code == sKey && !c.IsDeleted); if (dbitem == null) { dbitem = new tbl_SYS_Config(); dbitem.CreatedBy = Username; dbitem.CreatedDate = DateTime.Now; dbitem.ModifiedBy = Username; dbitem.ModifiedDate = DateTime.Now; dbitem.Code = sKey; db.tbl_SYS_Config.Add(dbitem); } else { dbitem.ModifiedBy = Username; dbitem.ModifiedDate = DateTime.Now; } dbitem.Value = Newtonsoft.Json.JsonConvert.SerializeObject(item.ThoiGianBaoCaoNSKH); if (dbitem != null) { try { db.SaveChanges(); BS_CUS_Version.update_CUS_Version(db, null, "post_SYS_Config_ThoiGianBaoCaoNSKH", dbitem.ModifiedDate, 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_SYS_Config_ThoiGianBaoCaoNSKH", e); item = null; } } return(item); }
public static DTO_SYS_Config post_SYS_Config(AppEntities db, DTO_SYS_Config item, string Username) { tbl_SYS_Config dbitem = new tbl_SYS_Config(); if (item != null) { dbitem.Code = item.Code; dbitem.Name = item.Name; dbitem.Remark = item.Remark; dbitem.Sort = item.Sort; dbitem.IsDisabled = item.IsDisabled; dbitem.IsDeleted = item.IsDeleted; dbitem.Value = item.Value; dbitem.CreatedBy = Username; dbitem.CreatedDate = DateTime.Now; dbitem.ModifiedBy = Username; dbitem.ModifiedDate = DateTime.Now; try { db.tbl_SYS_Config.Add(dbitem); db.SaveChanges(); BS_CUS_Version.update_CUS_Version(db, null, "DTO_SYS_Config", dbitem.ModifiedDate, 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_SYS_Config", e); item = null; } } return(item); }