public static DTO_CUS_DOC_Folder toDTO(tbl_CUS_DOC_Folder dbResult) { if (dbResult != null) { return(new DTO_CUS_DOC_Folder() { IDPartner = dbResult.IDPartner, IDParent = dbResult.IDParent, 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, IDLinhVuc = dbResult.IDLinhVuc, }); } else { return(null); } }
public static DTO_CUS_DOC_Folder post_CUS_DOC_Folder(AppEntities db, int PartnerID, DTO_CUS_DOC_Folder item, string Username) { tbl_CUS_DOC_Folder dbitem = new tbl_CUS_DOC_Folder(); if (item != null) { dbitem.IDParent = item.IDParent; 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.IDLinhVuc = item.IDLinhVuc; dbitem.CreatedBy = Username; dbitem.CreatedDate = DateTime.Now; dbitem.ModifiedBy = Username; dbitem.ModifiedDate = DateTime.Now; dbitem.IDPartner = PartnerID; try { db.tbl_CUS_DOC_Folder.Add(dbitem); db.SaveChanges(); BS_CUS_Version.update_CUS_Version(db, dbitem.IDPartner, "DTO_CUS_DOC_Folder", 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_Folder", e); item = null; } } return(item); }
public static DTO_CAT_LinhVuc post_CAT_LinhVucCustom(AppEntities db, DTO_CAT_LinhVuc item, string Username) { tbl_CAT_LinhVuc dbitem = new tbl_CAT_LinhVuc(); if (item != null) { dbitem.ParentID = item.ParentID; dbitem.Name = item.Name; dbitem.Note = item.Note; 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; try { db.tbl_CAT_LinhVuc.Add(dbitem); db.SaveChanges(); // Tạo thư mục var folder = db.tbl_CUS_DOC_Folder.FirstOrDefault(c => c.IDLinhVuc == dbitem.ID); if (folder == null) { folder = new tbl_CUS_DOC_Folder { CreatedBy = Username, CreatedDate = DateTime.Now, IDLinhVuc = dbitem.ID, }; db.tbl_CUS_DOC_Folder.Add(folder); } folder.IDPartner = 1; folder.Name = item.Name; folder.Sort = item.Sort; folder.ModifiedBy = Username; folder.ModifiedDate = DateTime.Now; if (item.ParentID > 0) { var folderParent = db.tbl_CUS_DOC_Folder.FirstOrDefault(c => c.IDLinhVuc == item.ParentID); if (folderParent != null) { folder.IDParent = folderParent.ID; } } BS_CUS_Version.update_CUS_Version(db, null, "DTO_CAT_LinhVuc", DateTime.Now, Username); db.SaveChanges(); 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_CAT_LinhVuc", e); item = null; } } return(item); }
public static bool put_CAT_LinhVucCustom(AppEntities db, int ID, DTO_CAT_LinhVuc item, string Username) { bool result = false; var dbitem = db.tbl_CAT_LinhVuc.Find(ID); if (dbitem != null) { bool isChangeParent = dbitem.ParentID != item.ParentID; dbitem.ParentID = item.ParentID; dbitem.Name = item.Name; dbitem.Note = item.Note; dbitem.Sort = item.Sort; dbitem.IsDisabled = item.IsDisabled; dbitem.IsDeleted = item.IsDeleted; dbitem.ModifiedBy = Username; dbitem.ModifiedDate = DateTime.Now; try { db.SaveChanges(); var folder = db.tbl_CUS_DOC_Folder.FirstOrDefault(c => c.IDLinhVuc == ID); if (folder == null) { folder = new tbl_CUS_DOC_Folder { CreatedBy = Username, CreatedDate = DateTime.Now, IDLinhVuc = ID, }; db.tbl_CUS_DOC_Folder.Add(folder); } folder.IDPartner = 1; folder.Name = item.Name; folder.Sort = item.Sort; folder.ModifiedBy = Username; folder.ModifiedDate = DateTime.Now; if (item.ParentID == null) { folder.IDParent = null; } if (isChangeParent && item.ParentID > 0) { var folderParent = db.tbl_CUS_DOC_Folder.FirstOrDefault(c => c.IDLinhVuc == item.ParentID); if (folderParent != null) { folder.IDParent = folderParent.ID; } } db.SaveChanges(); BS_CUS_Version.update_CUS_Version(db, null, "DTO_CAT_LinhVuc", DateTime.Now, Username); result = true; } catch (DbEntityValidationException e) { errorLog.logMessage("put_CAT_LinhVuc", e); result = false; } } return(result); }