/// <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);
}
