public override List <ImportExport.Result> XmlImport(System.Xml.XmlNode objectNode) { List <ImportExport.Result> response = base.XmlImport(objectNode); System.Xml.XmlNode definitionsNode; String exceptionMessage = String.Empty; try { definitionsNode = objectNode.SelectSingleNode("Definitions"); foreach (System.Xml.XmlNode currentDefinitionNode in definitionsNode.ChildNodes) { MedicalServices.Definitions.ServiceSetDefinition definition = new Mercury.Server.Core.MedicalServices.Definitions.ServiceSetDefinition(application); response.AddRange(definition.XmlImport(currentDefinitionNode)); definition.ServiceId = this.Id; definitions.Add(definition); } if (!Save()) { throw new ApplicationException("Unable to import Service Set."); } } catch (Exception importException) { response.Add(new ImportExport.Result(ObjectType, Name, importException)); } return(response); }
public override Boolean Load(Int64 forId) { Boolean success = false; StringBuilder sqlStatement = new StringBuilder(); System.Data.DataTable definitionTable; success = base.Load(forId); if (success) { sqlStatement.Append("SELECT ServiceSetDefinition.*, Service.ServiceName"); sqlStatement.Append(" FROM ServiceSetDefinition "); sqlStatement.Append(" JOIN Service ON ServiceSetDefinition.DefinitionServiceId = Service.ServiceId"); sqlStatement.Append(" WHERE ServiceSetDefinition.ServiceId = " + forId); sqlStatement.Append(" ORDER BY Service.ServiceName"); definitionTable = base.application.EnvironmentDatabase.SelectDataTable(sqlStatement.ToString()); foreach (System.Data.DataRow currentRow in definitionTable.Rows) { MedicalServices.Definitions.ServiceSetDefinition setDefinition = new Mercury.Server.Core.MedicalServices.Definitions.ServiceSetDefinition(application); setDefinition.ServiceId = Id; setDefinition.MapDataFields(currentRow); definitions.Add(setDefinition); } } return(success); }