public void EncryptTaxIDs(CCHEncrypt ce) { ce.Add("TaxID", ""); List <dynamic> newD = new List <dynamic>(); foreach (dynamic doc in this.results) { ce["TaxID"] = doc.TaxID; newD.Add(new { doc.ServiceName, TaxId = ce.ToString(), doc.NPI, doc.PracticeName, doc.ProviderName, doc.RangeMin, doc.RangeMax, doc.Latitude, doc.Longitude, doc.LocationAddress1, doc.LocationAddress2, doc.LocationCity, doc.LocationState, doc.LocationZip, doc.LocationTelephone, doc.FairPrice, doc.HGRecognized, doc.HGProviderID, doc.OtherKeyItem1, doc.OtherKeyItem1_Text, doc.OtherKeyItem1_LearnMoreTitle, doc.OtherKeyItem1_LearnMoreText }); } this.results = newD; }
public void GetData(string ConnectionString, CCHEncrypt ce) { base.GetData(ConnectionString); ce.Add("TaxID", ""); if (this.Tables.Count >= 1 && this.Tables[0].Rows.Count > 0 && FromRow <= this.Tables[0].Rows.Count) { //If we got data back, there are rows in that data, and they've specified a result range that exists in the data set //The range works as an index and a count, need to transform a starting row index and an ending row index into that format int maxRowCount = this.Tables[0].Rows.Count, //The most rows we could possibly get rowCount = ToRow - FromRow; //Set rowCount to the difference in order to turn an index into a count if (rowCount <= 0) { rowCount = 25; //If we didn't receive a specific endpoint, set it to 25 as the default } if (rowCount > (maxRowCount - FromRow)) { rowCount = maxRowCount - FromRow; //Cap the rowCount at the most we have available factoring in the starting point endOfResults = true; } _totalDocs = (this.Tables[0] != null ? this.Tables[0].Rows.Count : 0); // lam, 20130730, MOB-33 doctors = (from docRow in this.Tables[0].AsEnumerable() select new DoctorResult { ServiceName = docRow.GetData("ServiceName"), TaxId = docRow.EncryptTaxID(ce), NPI = docRow.GetData("NPI"), PracticeName = docRow.GetData("PracticeName"), OrganizationLocationID = docRow.GetData <int>("OrganizationLocationID"), ProviderName = docRow.GetData("ProviderName"), RangeMin = docRow.GetData <int>("RangeMin"), RangeMax = docRow.GetData <int>("RangeMax"), Latitude = docRow.GetData <double>("Latitude"), Longitude = docRow.GetData <double>("Longitude"), LocationAddress1 = docRow.GetData("LocationAddress1"), YourCostMin = docRow.GetData <int>("YourCostMin"), YourCostMax = docRow.GetData <int>("YourCostMax"), LocationCity = docRow.GetData("LocationCity"), LocationState = docRow.GetData("LocationState"), LocationZip = docRow.GetData("LocationZip"), LocationPhone = docRow.GetData("LocationTelephone"), RowNumber = docRow.GetData <int>("RowNumber"), Distance = docRow.GetData("Distance"), NumericDistance = docRow.GetData <decimal>("NumericDistance"), FairPrice = docRow.GetData <bool>("FairPrice"), HGRecognized = docRow.GetData <int>("HGRecognized"), LatLong = docRow.GetData("LatLong"), HGOverallRating = docRow.GetData <double>("HGOverallRating"), HGPatientCount = docRow.GetData <int>("HGPatientCount"), RowOrderKey = docRow.GetData <int>("RowOrderKey"), AntiTransparency = docRow.GetData <bool>("AntiTransparency") }).ToList <DoctorResult>().GetRange(FromRow, rowCount); } if (this.Tables.Count >= 2 && this.Tables[1].Rows.Count > 0) { description = (from desc in this.Tables[1].AsEnumerable() select new DescriptionResult { Description = desc.GetData("Description") }).ToList <DescriptionResult>(); } if (this.Tables.Count >= 3 && this.Tables[2].Rows.Count > 0) { specialties = (from specs in this.Tables[2].AsEnumerable() select new SpecialtyResult { FindADoc = specs.GetData <int>("FindADoc"), Specialty = specs.GetData("Specialty"), Description = specs.GetData("Description"), Title = specs.GetData("Title"), DoctorTitleText = specs.GetData("DoctorTitleText"), LearnMore = specs.GetData("LearnMore") }).ToList <SpecialtyResult>(); } if (this.Tables.Count >= 4 && this.Tables[3].Rows.Count > 0) { thinData = (from td in this.Tables[3].AsEnumerable() select new ThinDataResult { ThinData = td.GetData <bool>("ThinData") }).ToList <ThinDataResult>(); } if (this.Tables.Count >= 5 && this.Tables[4].Rows.Count > 0) { if (FromRow == 0) { preferredDocs = (from prefDocRow in this.Tables[4].AsEnumerable() where prefDocRow.GetData("ServiceName") != null select new DoctorResult { ServiceName = prefDocRow.GetData("ServiceName"), TaxId = prefDocRow.EncryptTaxID(ce), NPI = prefDocRow.GetData("NPI"), PracticeName = prefDocRow.GetData("PracticeName"), OrganizationLocationID = prefDocRow.GetData <int>("OrganizationLocationID"), ProviderName = prefDocRow.GetData("ProviderName"), RangeMin = prefDocRow.GetData <int>("RangeMin"), RangeMax = prefDocRow.GetData <int>("RangeMax"), Latitude = prefDocRow.GetData <double>("Latitude"), Longitude = prefDocRow.GetData <double>("Longitude"), LocationAddress1 = prefDocRow.GetData("LocationAddress1"), YourCostMin = prefDocRow.GetData <int>("YourCostMin"), YourCostMax = prefDocRow.GetData <int>("YourCostMax"), LocationCity = prefDocRow.GetData("LocationCity"), LocationState = prefDocRow.GetData("LocationState"), LocationZip = prefDocRow.GetData("LocationZip"), LocationPhone = prefDocRow.GetData("LocationTelephone"), RowNumber = prefDocRow.GetData <int>("RowNumber"), Distance = prefDocRow.GetData("Distance"), NumericDistance = prefDocRow.GetData <decimal>("NumericDistance"), FairPrice = prefDocRow.GetData <bool>("FairPrice"), HGRecognized = prefDocRow.GetData <int>("HGRecognized"), LatLong = prefDocRow.GetData("LatLong"), HGOverallRating = prefDocRow.GetData <double>("HGOverallRating"), HGPatientCount = prefDocRow.GetData <int>("HGPatientCount"), RowOrderKey = prefDocRow.GetData <int>("RowOrderKey"), AntiTransparency = prefDocRow.GetData <bool>("AntiTransparency") }).ToList <DoctorResult>(); _totalDocs += (preferredDocs != null && preferredDocs.Count > 0 ? preferredDocs.Count : 0); } } }
public void GetData(string ConnectionString, CCHEncrypt ce) { base.GetData(ConnectionString); ce.Add("TaxID", ""); if (this.Tables.Count >= 1 && this.Tables[0].Rows.Count > 0) { _totalDocs = (this.Tables[0] != null ? this.Tables[0].Rows.Count : 0); // lam, 20130730, MOB-33 doctors = (from docRow in this.Tables[0].AsEnumerable() select new DoctorResult { ServiceName = docRow.GetData("ServiceName"), TaxId = docRow.EncryptTaxID(ce), NPI = docRow.GetData("NPI"), PracticeName = docRow.GetData("PracticeName"), OrganizationLocationID = docRow.GetData("OrganizationLocationID"), ProviderName = docRow.GetData("ProviderName"), RangeMin = docRow.GetData <int>("RangeMin"), RangeMax = docRow.GetData <int>("RangeMax"), Latitude = docRow.GetData <double>("Latitude"), Longitude = docRow.GetData <double>("Longitude"), LocationAddress1 = docRow.GetData("LocationAddress1"), YourCostMin = docRow.GetData <int>("YourCostMin"), YourCostMax = docRow.GetData <int>("YourCostMax"), LocationCity = docRow.GetData("LocationCity"), LocationState = docRow.GetData("LocationState"), LocationZip = docRow.GetData("LocationZip"), LocationPhone = docRow.GetData("LocationTelephone"), RowNumber = docRow.GetData <int>("RowNumber"), Distance = docRow.GetData("Distance"), NumericDistance = docRow.GetData <decimal>("NumericDistance"), FairPrice = docRow.GetData <bool>("FairPrice"), HGRecognized = docRow.GetData <int>("HGRecognized"), LatLong = docRow.GetData("LatLong"), HGOverallRating = docRow.GetData <double>("HGOverallRating"), HGPatientCount = docRow.GetData <int>("HGPatientCount"), RowOrderKey = docRow.GetData <int>("RowOrderKey"), AntiTransparency = docRow.GetData <bool>("AntiTransparency") }).ToList <DoctorResult>(); } if (this.Tables.Count >= 2 && this.Tables[1].Rows.Count > 0) { description = (from desc in this.Tables[1].AsEnumerable() select new DescriptionResult { Description = desc.GetData("Description") }).ToList <DescriptionResult>(); } if (this.Tables.Count >= 3 && this.Tables[2].Rows.Count > 0) { specialties = (from specs in this.Tables[2].AsEnumerable() select new SpecialtyResult { FindADoc = specs.GetData <int>("FindADoc"), Specialty = specs.GetData("Specialty"), Description = specs.GetData("Description"), Title = specs.GetData("Title"), DoctorTitleText = specs.GetData("DoctorTitleText"), LearnMore = specs.GetData("LearnMore") }).ToList <SpecialtyResult>(); } if (this.Tables.Count >= 4 && this.Tables[3].Rows.Count > 0) { thinData = (from td in this.Tables[3].AsEnumerable() select new ThinDataResult { ThinData = td.GetData <bool>("ThinData") }).ToList <ThinDataResult>(); alternateProviderResult = (from specs in this.Tables[3].AsEnumerable() select new AlternateProviderResult { AlternateProviderData = specs.GetData <bool>("AltFlg") }).First <AlternateProviderResult>(); } if (this.Tables.Count >= 5 && this.Tables[4].Rows.Count > 0) { if (fromRow == 0) { preferredDocs = (from prefDocRow in this.Tables[4].AsEnumerable() where prefDocRow.GetData("ServiceName") != null select new DoctorResult { ServiceName = prefDocRow.GetData("ServiceName"), TaxId = prefDocRow.EncryptTaxID(ce), NPI = prefDocRow.GetData("NPI"), PracticeName = prefDocRow.GetData("PracticeName"), OrganizationLocationID = prefDocRow.GetData("OrganizationLocationID"), ProviderName = prefDocRow.GetData("ProviderName"), RangeMin = prefDocRow.GetData <int>("RangeMin"), RangeMax = prefDocRow.GetData <int>("RangeMax"), Latitude = prefDocRow.GetData <double>("Latitude"), Longitude = prefDocRow.GetData <double>("Longitude"), LocationAddress1 = prefDocRow.GetData("LocationAddress1"), YourCostMin = prefDocRow.GetData <int>("YourCostMin"), YourCostMax = prefDocRow.GetData <int>("YourCostMax"), LocationCity = prefDocRow.GetData("LocationCity"), LocationState = prefDocRow.GetData("LocationState"), LocationZip = prefDocRow.GetData("LocationZip"), LocationPhone = prefDocRow.GetData("LocationTelephone"), RowNumber = prefDocRow.GetData <int>("RowNumber"), Distance = prefDocRow.GetData("Distance"), NumericDistance = prefDocRow.GetData <decimal>("NumericDistance"), FairPrice = prefDocRow.GetData <bool>("FairPrice"), HGRecognized = prefDocRow.GetData <int>("HGRecognized"), LatLong = prefDocRow.GetData("LatLong"), HGOverallRating = prefDocRow.GetData <double>("HGOverallRating"), HGPatientCount = prefDocRow.GetData <int>("HGPatientCount"), RowOrderKey = prefDocRow.GetData <int>("RowOrderKey"), AntiTransparency = prefDocRow.GetData <bool>("AntiTransparency") }).ToList <DoctorResult>(); _totalDocs += (preferredDocs != null && preferredDocs.Count > 0 ? preferredDocs.Count : 0); } } }
public void GetData(string ConnectionString, CCHEncrypt ce) { base.GetData(ConnectionString); ce.Add("TaxID", ""); //Regular results if (this.Tables.Count >= 1 && this.Tables[0].Rows.Count > 0) { Int32 rangeStart = 0, rangeCount = this.Tables[0].Rows.Count; if (ToRow - FromRow <= rangeCount) { if (FromRow > 0) { rangeStart = FromRow; } if (ToRow > 0 && ToRow < rangeCount) { rangeCount = ToRow - FromRow + 1; } } resultData = (from result in this.Tables[0].AsEnumerable() select new FacilityResult { ServiceName = result.GetData("ServiceName"), TaxId = result.EncryptTaxID(ce), NPI = result.GetData("NPI"), PracticeName = result.GetData("PracticeName"), OrganizationLocationID = result.GetData <int>("OrganizationLocationID"), ProviderName = result.GetData("ProviderName"), RangeMin = result.GetData <int>("RangeMin"), RangeMax = result.GetData <int>("RangeMax"), Latitude = result.GetData <double>("Latitude"), Longitude = result.GetData <double>("Longitude"), LocationAddress1 = result.GetData("LocationAddress1"), YourCostMin = result.GetData <int>("YourCostMin"), YourCostMax = result.GetData <int>("YourCostMax"), LocationCity = result.GetData("LocationCity"), LocationState = result.GetData("LocationState"), LocationZip = result.GetData("LocationZip"), LocationPhone = result.GetData("LocationTelephone"), RowNumber = result.GetData <int>("RowNumber"), Distance = result.GetData("Distance"), NumericDistance = result.GetData <decimal>("NumericDistance"), FairPrice = result.GetData <bool>("FairPrice"), HGRecognized = result.GetData <int>("HGRecognized"), LatLong = result.GetData("LatLong"), HGOverallRating = result.GetData <double>("HGOverallRating"), HGPatientCount = result.GetData <int>("HGPatientCount"), RowOrderKey = result.GetData <int>("RowOrderKey"), HGRecognizedDocCount = result.GetData <int>("HGRecognizedDocCount"), HGDocCount = result.GetData <int>("HGDocCount"), HGOfficeID = result.GetData("HGOfficeID"), AntiTransparency = result.GetData <bool>("AntiTransparency") }).ToList <FacilityResult>(); //.GetRange(rangeStart, rangeCount); } // Description Info if (this.Tables.Count >= 2 && this.Tables[1].Rows.Count > 0) { learnMoreData = (from desc in this.Tables[1].AsEnumerable() select new DescriptionResult { Description = desc.GetData("Description") }).ToList <DescriptionResult>(); } // Thin Data Info if (this.Tables.Count >= 3 && this.Tables[2].Rows.Count > 0) { thinDataData = (from specs in this.Tables[2].AsEnumerable() select new ThinDataResult { ThinData = specs.GetData <bool>("ThinData") }).ToList <ThinDataResult>(); } // Preferred Providers if (this.Tables.Count >= 5 && this.Tables[4].Rows.Count > 0) { if (FromRow == 0) { preferredData = (from result in this.Tables[4].AsEnumerable() select new FacilityResult { ServiceName = result.GetData("ServiceName"), TaxId = result.EncryptTaxID(ce), NPI = result.GetData("NPI"), PracticeName = result.GetData("PracticeName"), OrganizationLocationID = result.GetData <int>("OrganizationLocationID"), ProviderName = result.GetData("ProviderName"), RangeMin = result.GetData <int>("RangeMin"), RangeMax = result.GetData <int>("RangeMax"), Latitude = result.GetData <double>("Latitude"), Longitude = result.GetData <double>("Longitude"), LocationAddress1 = result.GetData("LocationAddress1"), YourCostMin = result.GetData <int>("YourCostMin"), YourCostMax = result.GetData <int>("YourCostMax"), LocationCity = result.GetData("LocationCity"), LocationState = result.GetData("LocationState"), LocationZip = result.GetData("LocationZip"), LocationPhone = result.GetData("LocationTelephone"), RowNumber = result.GetData <int>("RowNumber"), Distance = result.GetData("Distance"), NumericDistance = result.GetData <decimal>("NumericDistance"), FairPrice = result.GetData <bool>("FairPrice"), HGRecognized = result.GetData <int>("HGRecognized"), LatLong = result.GetData("LatLong"), HGOverallRating = result.GetData <double>("HGOverallRating"), HGPatientCount = result.GetData <int>("HGPatientCount"), RowOrderKey = result.GetData <int>("RowOrderKey"), HGRecognizedDocCount = result.GetData <int>("HGRecognizedDocCount"), HGDocCount = result.GetData <int>("HGDocCount"), HGOfficeID = result.GetData("HGOfficeID"), AntiTransparency = result.GetData <bool>("AntiTransparency") }).ToList <FacilityResult>(); } } }
public void GetData(string ConnectionString, CCHEncrypt ce) { base.GetData(ConnectionString); ce.Add("TaxID", ""); if (this.Tables.Count >= 1 && this.Tables[0].Rows.Count > 0) { resultData = (from result in this.Tables[0].AsEnumerable() select new FacilityResult { ServiceName = result.GetData("ServiceName"), TaxId = result.EncryptTaxID(ce), NPI = result.GetData("NPI"), PracticeName = result.GetData("PracticeName"), OrganizationLocationID = result.GetData <int>("OrganizationLocationID"), ProviderName = result.GetData("ProviderName"), AllowedAmount = result.GetData <int>("AllowedAmount"), Latitude = result.GetData <double>("Latitude"), Longitude = result.GetData <double>("Longitude"), LocationAddress1 = result.GetData("LocationAddress1"), YourCost = result.GetData <int>("YourCost"), LocationCity = result.GetData("LocationCity"), LocationState = result.GetData("LocationState"), LocationZip = result.GetData("LocationZip"), LocationTelephone = result.GetData("LocationTelephone"), RowNumber = result.GetData <int>("RowNumber"), Distance = result.GetData("Distance"), NumericDistance = result.GetData <decimal>("NumericDistance"), FairPrice = result.GetData <bool>("FairPrice"), HGRecognized = result.GetData <int>("HGRecognized"), LatLong = result.GetData("LatLong"), HGOverallRating = result.GetData <double>("HGOverallRating"), HGPatientCount = result.GetData <int>("HGPatientCount"), FindAService = result.GetData <int>("FindAService"), RowOrderKey = result.GetData <int>("RowOrderKey"), OrganizationID = result.GetData <int>("OrganizationID"), HGRecognizedDocCount = result.GetData <int>("HGRecognizedDocCount"), HGDocCount = result.GetData <int>("HGDocCount"), AntiTransparency = result.GetData <bool>("AntiTransparency") }).ToList <FacilityResult>(); } if (this.Tables.Count >= 2 && this.Tables[1].Rows.Count > 0) { learnMoreData = (from desc in this.Tables[1].AsEnumerable() select new LearnMoreResult { Description = desc.GetData("Description") }).ToList <LearnMoreResult>(); } if (this.Tables.Count >= 3 && this.Tables[2].Rows.Count > 0) { learnMoreSpecialtyData = (from desc in this.Tables[2].AsEnumerable() select new LearnMoreSpecialtyResult { FindADoc = desc.GetData <int>("FindADoc"), Specialty = desc.GetData("Specialty"), Description = desc.GetData("Description"), Title = desc.GetData("Title"), DoctorTitleText = desc.GetData("DoctorTitleText"), LearnMore = desc.GetData("LearnMore") }).ToList <LearnMoreSpecialtyResult>(); } if (this.Tables.Count >= 4 && this.Tables[3].Rows.Count > 0) { savingsData = (from savings in this.Tables[3].AsEnumerable() select new SavingsResult { ServiceDate = savings.GetData <DateTime>("ServiceDate"), ProcedureCode = savings.GetData("ProcedureCode"), AllowedAmount = savings.GetData <double>("AllowedAmount"), YouCouldHaveSaved = savings.GetData <double>("YouCouldHaveSaved"), OrganizationID = savings.GetData <int>("OrganizationID"), OrganizationLocationID = savings.GetData <int>("OrganizationLocationID"), SpecialtyID = savings.GetData <int>("SpecialtyID") }).ToList <SavingsResult>(); } }