/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override BaseWebsitePageComponent LoadFromReader(System.Data.IDataReader dr) { var item = new BaseWebsitePageComponent() { Name = dr.Guard <string>("Name").UnQuote(), WebsitePageName = dr.Guard <string>("WebsitePageName").UnQuote(), CodePath = dr.Guard <string>("CodePath").UnQuote(), ComponentType = dr.Guard <string>("ComponentType").UnQuote().GetEnum <WebsitePageComponentTypeEnum>(), Audiences = dr.Guard <string>("Audiences").UnQuote().Split(',').ToList().ConvertAll(s => s.GetEnum <Entities.Domain.Reports.Audience>()) }; // NOTE: Must save and flush data here or categories are not being saved! using (var session = DataProvider.SessionFactory.OpenSession()) { try { session.SaveOrUpdate(item); session.Flush(); } catch (Exception exc) { base.Logger.Log(exc.GetBaseException().Message, Microsoft.Practices.Prism.Logging.Category.Exception, Microsoft.Practices.Prism.Logging.Priority.High); } } return(null); // item; }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override ZipCodeToHRRAndHSA LoadFromReader(System.Data.IDataReader dr) { var state = States.FirstOrDefault(x => x.Abbreviation == dr.Guard <string>(3).Trim()); /* * var zipCodeToHRRandHSA = new ZipCodeToHRRAndHSA * { * Zip = dr.Guard<string>(0).PadLeft(5, '0'), * HSANumber = dr.Guard<int>(1), * HRRNumber = dr.Guard<int>(2), * State = state.Abbreviation, * StateFIPS = state.FIPSState * }; */ var zipCodeToHrrAndHsa = new ZipCodeToHRRAndHSA { Zip = dr.Guard <string>(0).PadLeft(5, '0'), HSANumber = dr.Guard <int>(2), HRRNumber = dr.Guard <int>(1), State = state.Abbreviation, StateFIPS = state.FIPSState }; return(zipCodeToHrrAndHsa); }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override BaseWebsitePageZone LoadFromReader(System.Data.IDataReader dr) { var item = new BaseWebsitePageZone() { Name = dr.Guard <string>("Name").UnQuote(), WebsitePageName = dr.Guard <string>("WebsitePageName").UnQuote(), CodePath = dr.Guard <string>("CodePath").UnQuote(), ZoneType = dr.Guard <string>("ZoneType").UnQuote().GetEnum <WebsitePageZoneTypeEnum>(), Audience = dr.Guard <string>("Audience").UnQuote().GetEnum <Entities.Domain.Reports.Audience>(), }; // NOTE: Must save and flush data here or categories are not being saved! using (var session = DataProvider.SessionFactory.OpenSession()) { try { session.SaveOrUpdate(item); session.Flush(); } catch (Exception exc) { base.Logger.Write(exc, "Error loading website data from data reader"); } } return(null); // item; }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override ProviderSpeciality LoadFromReader(System.Data.IDataReader dr) { return(new ProviderSpeciality { Name = Inflector.ProperCase(dr.Guard <string>("Name"), @"\/"), ProviderTaxonomy = dr.Guard <string>("provider_taxonomy") }); }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override ICD10toDXCCSCrosswalk LoadFromReader(System.Data.IDataReader dr) { return(new ICD10toDXCCSCrosswalk { ICDID = dr.Guard <string>("ICDID").Replace("'", string.Empty), DXCCSID = dr.Guard <int>("DXCCSID") }); }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override ICD9toPRCCSCrosswalk LoadFromReader(System.Data.IDataReader dr) { return(new ICD9toPRCCSCrosswalk() { ICD9ID = dr.Guard <string>("ICD9").Replace("'", string.Empty), PRCCSID = dr.Guard <int>("CCSID") }); }
public PRCCS LoadFromReader(System.Data.IDataReader rdr) { return(new PRCCS() { Description = rdr.Guard <string>("Description"), PRCCSID = rdr.Guard <int>("PRCCS"), FirstYear = rdr.Guard <int>("FirstYear"), LastYear = rdr.Guard <int>("LastYear"), }); }
public MDC LoadFromReader(System.Data.IDataReader rdr) { return(new MDC() { Description = rdr.Guard <string>("Description"), MDCID = rdr.Guard <int>("MDC"), FirstYear = rdr.Guard <int>("FirstYear"), LastYear = rdr.Guard <int>("LastYear"), }); }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override MDC LoadFromReader(System.Data.IDataReader dr) { return(new MDC() { MDCID = dr.Guard <int>("MDC"), Description = dr.Guard <string>("Description"), FirstYear = dr.Guard <int>("FirstYear"), LastYear = dr.Guard <int>("LastYear") }); }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override DXCCS LoadFromReader(System.Data.IDataReader dr) { return(new DXCCS() { DXCCSID = dr.Guard <int>("DXCCS"), Description = dr.Guard <string>("Description"), FirstYear = dr.Guard <int>("FirstYear"), LastYear = dr.Guard <int>("LastYear") }); }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override CGCAHPSMeasureLookup LoadFromReader(System.Data.IDataReader dr) { var item = new CGCAHPSMeasureLookup { MeasureId = dr.Guard <string>("MeasureId"), MeasureType = dr.Guard <string>("MeasureType"), CAHPSQuestionType = dr.Guard <string>("CAHPSQuestionType"), }; return(item); }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override County LoadFromReader(System.Data.IDataReader dr) { return(new County { Name = dr.Guard <string>("NAME"), CountyFIPS = dr.Guard <string>("GEOID").PadLeft(5, '0'), CountySSA = dr.ColumnExists("SSA") ? !string.IsNullOrEmpty(dr.Guard <string>("SSA")) ? dr.Guard <string>("SSA").PadLeft(3, '0') : null : null, State = dr.Guard <string>("USPS") }); }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override NHProviderToLatLong LoadFromReader(System.Data.IDataReader dr) { var provider = dr.Guard <object>("ProviderId"); var item = new NHProviderToLatLong { ProviderId = provider.ToString().Replace("'", null), Latitude = dr.Guard <double>("Latitude"), Longitude = dr.Guard <double>("Longitude") }; return(item); }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override CostToCharge LoadFromReader(System.Data.IDataReader dr) { var providerId = dr.Guard <string>(0).Replace("'", string.Empty); var year = dr.Guard <string>(1); var ratio = System.Math.Round(dr.Guard <double>(2), 5); return(new CostToCharge { ProviderID = providerId, Year = year, Ratio = ratio }); }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override State LoadFromReader(System.Data.IDataReader dr) { return(new State { Abbreviation = dr.Guard <string>("StateAbbreviation"), FIPSState = dr.Guard <string>("FIPSState"), Name = dr.Guard <string>("StateName"), Centroid = new Point(dr.Guard <double>("x0"), dr.Guard <double>("y0")), BoundingRegion = new Rect( new Point(dr.Guard <double>("MinX"), dr.Guard <double>("MinY")), new Point(dr.Guard <double>("MaxX"), dr.Guard <double>("MaxY"))) }); }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override HospitalCategory LoadFromReader(System.Data.IDataReader dr) { var name = dr.Guard <string>("Description"); if (HospitalCategories.Contains(name)) { return(null); } var hrr = new HospitalCategory(Registry) // TODO: Do we need to pass in the registry? { CategoryID = dr.Guard <int>("CategoryID"), Name = dr.Guard <string>("Description"), IsSourcedFromBaseData = true, Version = Registry.DataVersion }; return(hrr); }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override HealthReferralRegion LoadFromReader(System.Data.IDataReader dr) { var state = States.FirstOrDefault(x => x == dr.Guard <string>(2).Trim()); //HRRState var code = string.Format("HRR{0}{1}", dr.Guard <int>(0), dr.Guard <string>(2)); // "HRRNumber" | "HRRState" if (HRRs.Contains(code) || state.IsNullOrEmpty()) { return(null); } var hrr = new HealthReferralRegion(Registry) // TODO: Do we need to pass in the registry? { Code = code, Version = Registry.DataVersion, // TODO: Is this version really needed here?!? ImportRegionId = dr.Guard <int>(0), State = state, City = dr.Guard <string>(1), //"HRRCity" IsSourcedFromBaseData = true }; return(hrr); }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override HospitalServiceArea LoadFromReader(System.Data.IDataReader dr) { var state = States.FirstOrDefault(x => x == dr.Guard <string>(2).Trim()); //HSAState var code = string.Format("HSA{0}{1}", dr.Guard <int>(0), dr.Guard <string>(2)); //"HSANumber" || HSAState if (HSAs.Contains(code) || state.IsNullOrEmpty()) { return(null); } var hsa = new HospitalServiceArea(Registry) { Code = code, Version = Registry.DataVersion, // TODO: Is this version really needed here?!? ImportRegionId = dr.Guard <int>(0), State = state, City = dr.Guard <string>(1), //HSACity IsSourcedFromBaseData = true }; return(hsa); }
/// <summary> /// Loads from reader. /// </summary> /// <param name="dr">The dr.</param> /// <returns></returns> public override BaseWebsitePage LoadFromReader(System.Data.IDataReader dr) { var item = new BaseWebsitePage { Name = dr.Guard <string>("Name").UnQuote(), TemplateRelativePath = dr.Guard <string>("TemplateRelativePath").UnQuote(), PublishRelativePath = dr.Guard <string>("PublishRelativePath").UnQuote(), PageType = dr.Guard <string>("PageType").UnQuote().GetEnum <WebsitePageTypeEnum>(), ReportName = dr.Guard <string>("ReportName").UnQuote(), Audience = dr.Guard <string>("Audience").UnQuote().GetEnum <Audience>(), Url = dr.Guard <string>("Url").UnQuote(), IsEditable = dr.Guard <bool>("IsEditable"), }; return(item); }