public void GetNextResults() { if (IsMultiLab) { using (GetFacilitiesForMultiLab gffml = new GetFacilitiesForMultiLab()) { //Set the parameters using (DataView dv = new DataView(ThisSession.ChosenLabs)) gffml.ServiceList = dv.ToTable("ChosenLabs", true, new String[] { "ServiceID" }); gffml.Distance = "20"; gffml.Latitude = this.lat; gffml.Longitude = this.lng; gffml.OrderByField = sort; gffml.OrderDirection = dir; //Populate the object with data from the database Int32 calcFrom = Int32.Parse(this.resCount) + resultBuffer.Rows.Count + 1; gffml.GetData(calcFrom, (calcFrom + 20)); //If we got anything back and had no errors... if (!gffml.HasErrors && gffml.RowsBack > 0) { //If we've reached the end of the result, set it even on the first pass lastResult = gffml.ReachedEnd; //Save the specific results for sorting and geocoding for when we leave the Using tblResults = gffml.RawResults; //DO NOT CLEAR THE RESULT BUFFER HERE AS WE'LL NEED IT'S CONTENTS IN THIS SITUATION } } } else { using (GetFacilitiesForService gffs = new GetFacilitiesForService()) { //Set the Parameters gffs.ServiceID = ThisSession.ServiceID.ToString(); gffs.Latitude = this.lat; gffs.Longitude = this.lng; gffs.SpecialtyID = ThisSession.SpecialtyID.ToString(); gffs.Distance = "20"; gffs.OrderByField = sort; gffs.OrderDirection = dir; //gffs.MemberMedicalID = ThisSession.SubscriberMedicalID; gffs.CCHID = ThisSession.CCHID; gffs.UserID = Membership.GetUser().ProviderUserKey.ToString(); //Populate the object with data from the database Int32 calcFrom = Int32.Parse(this.resCount) + resultBuffer.Rows.Count + 1; gffs.GetData(calcFrom, (calcFrom + 20)); //If we got anything back and had no errors... if (!gffs.HasErrors && gffs.RowsBack > 0) { //If we've reached the end of the result, set it even on the first pass lastResult = gffs.ReachedEnd; //Save the specific results for sorting and geocoding for when we leave the Using tblResults = gffs.RawResults; //DO NOT CLEAR THE RESULT BUFFER HERE AS WE'LL NEED IT'S CONTENTS IN THIS SITUATION } } } }
public void GetFirstResults() { if (IsMultiLab) { using (GetFacilitiesForMultiLab gffml = new GetFacilitiesForMultiLab()) { //Set the parameters using (DataView dv = new DataView(ThisSession.ChosenLabs)) gffml.ServiceList = dv.ToTable("ChosenLabs", true, new String[] { "ServiceID" }); gffml.Distance = "20"; gffml.Latitude = this.lat; gffml.Longitude = this.lng; gffml.OrderByField = "Distance"; gffml.OrderDirection = "ASC"; //Populate the object with data from the database gffml.GetData(); //If we got anything back and had no errors... if (!gffml.HasErrors && gffml.RowsBack > 0) { //If we've reached the end of the result set it even on the first pass lastResult = gffml.ReachedEnd; //Save the specific results for sorting and geocoding for when we leave the Using tblResults = gffml.RawResults; //Set the LearnMore table for use later learnMoreTable = gffml.LearnMoreResults; } } } else { if (!IsThin) { using (GetFacilitiesForService gffs = new GetFacilitiesForService()) { //Set the parameters gffs.ServiceID = ThisSession.ServiceID.ToString(); gffs.Latitude = this.lat; gffs.Longitude = this.lng; gffs.SpecialtyID = ThisSession.SpecialtyID.ToString(); gffs.Distance = "20"; gffs.OrderByField = "Distance"; gffs.OrderDirection = "ASC"; //gffs.MemberMedicalID = ThisSession.SubscriberMedicalID; gffs.CCHID = ThisSession.CCHID; gffs.UserID = Membership.GetUser().ProviderUserKey.ToString(); //Populate the object with data from the database gffs.GetData(); //Is this thin data or no? if (!gffs.DataIsThin) { //If we got anything back and had no errors... if (!gffs.HasErrors && gffs.RowsBack > 0) { //If we've reached the end of the result set it even on the first pass lastResult = gffs.ReachedEnd; //Save the specific results for sorting and geocoding for when we leave the Using tblResults = gffs.RawResults; //Set the LearnMore table for use later learnMoreTable = gffs.LearnMoreResults; } } else { IsThin = true; } } } if (IsThin) { using (GetThinDataResults gtdr = new GetThinDataResults()) { //Set the parameters gtdr.ZipCode = ThisSession.PatientZipCode; gtdr.ServiceID = ThisSession.ServiceID.ToString(); gtdr.Latitude = this.lat; gtdr.Longitude = this.lng; gtdr.SpecialtyId = ThisSession.SpecialtyID.ToString(); //Populate the object with data from the database gtdr.GetData(); if (gtdr.HasErrors && gtdr.RowsBack > 0) { lastResult = gtdr.ReachedEnd; tblResults = gtdr.RawResults; } } } } //Prepare the result buffer to begin with a clean slate if (tblResults != null && tblResults.Rows.Count > 0) if (resultBuffer == null) resultBuffer = tblResults.Clone(); else resultBuffer.Clear(); }
public void ChangeSortResults() { if (IsMultiLab) { using (GetFacilitiesForMultiLab gffml = new GetFacilitiesForMultiLab()) { //Set the parameters using (DataView dv = new DataView(ThisSession.ChosenLabs)) gffml.ServiceList = dv.ToTable("ChosenLabs", true, new String[] { "ServiceID" }); gffml.Distance = "20"; gffml.Latitude = this.lat; gffml.Longitude = this.lng; gffml.OrderByField = sort; gffml.OrderDirection = dir; //Populate the object with data from the databdase gffml.GetData(); //If we got anything back and had no errors... if (!gffml.HasErrors && gffml.RowsBack > 0) { //If we've reached the end of the result set it even on the first pass lastResult = gffml.ReachedEnd; //Save the specific results for sorting and geocoding for when we leave the Using tblResults = gffml.RawResults; } } } else { using (GetFacilitiesForService gffs = new GetFacilitiesForService()) { //Set the Parameters gffs.ServiceID = ThisSession.ServiceID.ToString(); gffs.Latitude = this.lat; gffs.Longitude = this.lng; gffs.SpecialtyID = ThisSession.SpecialtyID.ToString(); gffs.Distance = "20"; gffs.OrderByField = sort; gffs.OrderDirection = dir; //gffs.MemberMedicalID = ThisSession.SubscriberMedicalID; gffs.CCHID = ThisSession.CCHID; gffs.UserID = Membership.GetUser().ProviderUserKey.ToString(); //Populate the object with data from the database gffs.GetData(); //If we got anything back and had no errors... if (!gffs.HasErrors && gffs.RowsBack > 0) { //If we've reached the end of the result set it even on the first pass lastResult = gffs.ReachedEnd; //Save the specific results for sorting and geocoding for when we leave the Using tblResults = gffs.RawResults; } } } //Prepare the result buffer to begin with a clean slate if (resultBuffer == null) resultBuffer = tblResults.Clone(); else resultBuffer.Clear(); }
public void ChangeSortResults() { if (IsMultiLab) { using (GetFacilitiesForMultiLab gffml = new GetFacilitiesForMultiLab()) { //Set the parameters using (DataView dv = new DataView(ThisSession.ChosenLabs)) gffml.ServiceList = dv.ToTable("ChosenLabs", true, new String[] { "ServiceID" }); gffml.Distance = "20"; gffml.Latitude = this.lat; gffml.Longitude = this.lng; gffml.OrderByField = sort; gffml.OrderDirection = dir; //Populate the object with data from the databdase gffml.GetData(); //If we got anything back and had no errors... if (!gffml.HasErrors && gffml.RowsBack > 0) { //If we've reached the end of the result set it even on the first pass lastResult = gffml.ReachedEnd; //Save the specific results for sorting and geocoding for when we leave the Using tblResults = gffml.RawResults; } } } else { using (GetFacilitiesForService gffs = new GetFacilitiesForService()) { //Set the Parameters gffs.ServiceID = ThisSession.ServiceID.ToString(); gffs.Latitude = this.lat; gffs.Longitude = this.lng; gffs.SpecialtyID = ThisSession.SpecialtyID.ToString(); gffs.Distance = "20"; gffs.OrderByField = sort; gffs.OrderDirection = dir; //gffs.MemberMedicalID = ThisSession.SubscriberMedicalID; gffs.CCHID = ThisSession.CCHID; gffs.UserID = Membership.GetUser().ProviderUserKey.ToString(); //Populate the object with data from the database gffs.GetData(); //If we got anything back and had no errors... if (!gffs.HasErrors && gffs.RowsBack > 0) { //If we've reached the end of the result set it even on the first pass lastResult = gffs.ReachedEnd; //Save the specific results for sorting and geocoding for when we leave the Using tblResults = gffs.RawResults; } } } //Prepare the result buffer to begin with a clean slate if (resultBuffer == null) { resultBuffer = tblResults.Clone(); } else { resultBuffer.Clear(); } }
public void GetFirstResults() { if (IsMultiLab) { using (GetFacilitiesForMultiLab gffml = new GetFacilitiesForMultiLab()) { //Set the parameters using (DataView dv = new DataView(ThisSession.ChosenLabs)) gffml.ServiceList = dv.ToTable("ChosenLabs", true, new String[] { "ServiceID" }); gffml.Distance = "20"; gffml.Latitude = this.lat; gffml.Longitude = this.lng; gffml.OrderByField = "Distance"; gffml.OrderDirection = "ASC"; //Populate the object with data from the database gffml.GetData(); //If we got anything back and had no errors... if (!gffml.HasErrors && gffml.RowsBack > 0) { //If we've reached the end of the result set it even on the first pass lastResult = gffml.ReachedEnd; //Save the specific results for sorting and geocoding for when we leave the Using tblResults = gffml.RawResults; //Set the LearnMore table for use later learnMoreTable = gffml.LearnMoreResults; } } } else { if (!IsThin) { using (GetFacilitiesForService gffs = new GetFacilitiesForService()) { //Set the parameters gffs.ServiceID = ThisSession.ServiceID.ToString(); gffs.Latitude = this.lat; gffs.Longitude = this.lng; gffs.SpecialtyID = ThisSession.SpecialtyID.ToString(); gffs.Distance = "20"; gffs.OrderByField = "Distance"; gffs.OrderDirection = "ASC"; //gffs.MemberMedicalID = ThisSession.SubscriberMedicalID; gffs.CCHID = ThisSession.CCHID; gffs.UserID = Membership.GetUser().ProviderUserKey.ToString(); //Populate the object with data from the database gffs.GetData(); //Is this thin data or no? if (!gffs.DataIsThin) { //If we got anything back and had no errors... if (!gffs.HasErrors && gffs.RowsBack > 0) { //If we've reached the end of the result set it even on the first pass lastResult = gffs.ReachedEnd; //Save the specific results for sorting and geocoding for when we leave the Using tblResults = gffs.RawResults; //Set the LearnMore table for use later learnMoreTable = gffs.LearnMoreResults; } } else { IsThin = true; } } } if (IsThin) { using (GetThinDataResults gtdr = new GetThinDataResults()) { //Set the parameters gtdr.ZipCode = ThisSession.PatientZipCode; gtdr.ServiceID = ThisSession.ServiceID.ToString(); gtdr.Latitude = this.lat; gtdr.Longitude = this.lng; gtdr.SpecialtyId = ThisSession.SpecialtyID.ToString(); //Populate the object with data from the database gtdr.GetData(); if (gtdr.HasErrors && gtdr.RowsBack > 0) { lastResult = gtdr.ReachedEnd; tblResults = gtdr.RawResults; } } } } //Prepare the result buffer to begin with a clean slate if (tblResults != null && tblResults.Rows.Count > 0) { if (resultBuffer == null) { resultBuffer = tblResults.Clone(); } else { resultBuffer.Clear(); } } }