public OralConsultationOrganizationItem UpdateOrganization(OralConsultationOrganizationItem item) { try { TmpOralConsultationOrganization entity = new TmpOralConsultationOrganization { ID = item.ID, OralConsultationOrganizationID = item.OralConsultationOrganizationID, OralConsultationID = item.OralConsultationID, OrganizationID = item.OrganizationID, GUID = item.GUID }; db.TmpOralConsultationOrganizations.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); Organization organization = db.Organizations.Find(item.OrganizationID); item.OrganizationName = organization.OrganizationName; return(item); } catch (Exception ex) { exception = ex; return(null); } }
public OralConsultationOrganizationItem DeleteOrganization(OralConsultationOrganizationItem item) { try { TmpOralConsultationOrganization entity = new TmpOralConsultationOrganization { ID = item.ID, OralConsultationOrganizationID = item.OralConsultationOrganizationID, OralConsultationID = item.OralConsultationID, OrganizationID = item.OrganizationID, GUID = item.GUID }; db.TmpOralConsultationOrganizations.Attach(entity); db.TmpOralConsultationOrganizations.Remove(entity); db.SaveChanges(); return(item); } catch (Exception ex) { exception = ex; return(null); } }
public OralConsultationOrganizationItem InsertOrganization(OralConsultationOrganizationItem item) { try { TmpOralConsultationOrganization entity = new TmpOralConsultationOrganization { OralConsultationOrganizationID = 0, OralConsultationID = item.OralConsultationID, OrganizationID = item.OrganizationID, GUID = item.GUID }; db.TmpOralConsultationOrganizations.Add(entity); db.SaveChanges(); item.ID = entity.ID; item.OralConsultationOrganizationID = entity.OralConsultationOrganizationID; Organization organization = db.Organizations.Find(item.OrganizationID); item.OrganizationName = organization.OrganizationName; return(item); } catch (Exception ex) { exception = ex; return(null); } }
public OralConsultationItem GetOralConsultationItemByID(int oralConsultationID) { var oralConsultation = db.OralConsultations.Find(oralConsultationID); var issue = db.Issues.Find(oralConsultation.IssueID); OralConsultationItem item = new OralConsultationItem { OralConsultationID = oralConsultation.OralConsultationID, IssueID = issue.IssueID, IssueName = issue.IssueName, IssueDate = issue.IssueDate, IssueDescription = issue.IssueDescription, OralConsultationDate = oralConsultation.OralConsultationDate, InvocationTypeID = oralConsultation.InvocationTypeID, TargetGroupID = oralConsultation.TargetGroupID, ProblemDescription = oralConsultation.ProblemDescription, ConsultationDescription = oralConsultation.ConsultationDescription, GUID = Guid.NewGuid(), InitializationType = InitializationTypes.Update, UserID = String.Empty, ChangeDate = null }; foreach (var consultant in db.OralConsultationConsultants.Where(p => p.OralConsultationID == oralConsultationID)) { TmpOralConsultationConsultant itm = new TmpOralConsultationConsultant(); itm.OralConsultationConsultantID = consultant.OralConsultationConsultantID; itm.OralConsultationID = consultant.OralConsultationID; itm.ConsultantID = consultant.ConsultantID; itm.GUID = item.GUID; db.TmpOralConsultationConsultants.Add(itm); } foreach (var organization in db.OralConsultationOrganizations.Where(p => p.OralConsultationID == oralConsultationID)) { TmpOralConsultationOrganization itm = new TmpOralConsultationOrganization(); itm.OralConsultationOrganizationID = organization.OralConsultationOrganizationID; itm.OralConsultationID = organization.OralConsultationID; itm.OrganizationID = organization.OrganizationID; itm.GUID = item.GUID; db.TmpOralConsultationOrganizations.Add(itm); } foreach (var right in db.OralConsultationRights.Where(p => p.OralConsultationID == oralConsultationID)) { TmpOralConsultationRight itm = new TmpOralConsultationRight(); itm.OralConsultationRightID = right.OralConsultationRightID; itm.OralConsultationID = right.OralConsultationID; itm.HumanRightID = right.HumanRightID; itm.GUID = item.GUID; db.TmpOralConsultationRights.Add(itm); } foreach (var permission in db.OralConsultationPermissions.Where(p => p.OralConsultationID == oralConsultationID)) { TmpOralConsultationPermission itm = new TmpOralConsultationPermission(); itm.OralConsultationPermissionID = permission.OralConsultationPermissionID; itm.OralConsultationID = permission.OralConsultationID; itm.UserID = permission.UserID; itm.IsChange = permission.IsChange; itm.IsRead = permission.IsRead; itm.GUID = item.GUID; db.TmpOralConsultationPermissions.Add(itm); } db.SaveChanges(); return(item); }