///<summary>Deletes the current CovSpans for the given eBenefitCategory, then creates new code ranges from the ranges specified in arrayCodeRanges. The values in arrayCodeRanges can be a single code such as "D0120" or a code range such as "D9000-D9999".</summary> private static void RecreateSpansForCategory(EbenefitCategory eBenefitCategory, params string[] arrayCodeRanges) { long covCatNum = GetForEbenCat(eBenefitCategory).CovCatNum; CovSpans.DeleteForCat(covCatNum); for (int i = 0; i < arrayCodeRanges.Length; i++) { string codeRange = arrayCodeRanges[i]; CovSpan span = new CovSpan(); span.CovCatNum = covCatNum; if (codeRange.Contains("-")) //Code range { span.FromCode = codeRange.Substring(0, codeRange.IndexOf("-")); span.ToCode = codeRange.Substring(span.FromCode.Length + 1); } else //Single code { span.FromCode = codeRange; span.ToCode = codeRange; } CovSpans.Insert(span); } }
public static void SetSpansToDefaultUsa() { //This can only be run if the validation checks have been run first. //No need to check RemotingRole; no call to db. long covCatNum; CovSpan span; covCatNum = GetForEbenCat(EbenefitCategory.General).CovCatNum; CovSpans.DeleteForCat(covCatNum); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D0000"; span.ToCode = "D7999"; CovSpans.Insert(span); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D9000"; span.ToCode = "D9999"; CovSpans.Insert(span); covCatNum = GetForEbenCat(EbenefitCategory.Diagnostic).CovCatNum; CovSpans.DeleteForCat(covCatNum); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D0000"; span.ToCode = "D0999"; CovSpans.Insert(span); covCatNum = GetForEbenCat(EbenefitCategory.DiagnosticXRay).CovCatNum; CovSpans.DeleteForCat(covCatNum); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D0200"; span.ToCode = "D0399"; CovSpans.Insert(span); covCatNum = GetForEbenCat(EbenefitCategory.RoutinePreventive).CovCatNum; CovSpans.DeleteForCat(covCatNum); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D1000"; span.ToCode = "D1999"; CovSpans.Insert(span); covCatNum = GetForEbenCat(EbenefitCategory.Restorative).CovCatNum; CovSpans.DeleteForCat(covCatNum); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D2000"; span.ToCode = "D2699"; CovSpans.Insert(span); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D2800"; span.ToCode = "D2999"; CovSpans.Insert(span); covCatNum = GetForEbenCat(EbenefitCategory.Endodontics).CovCatNum; CovSpans.DeleteForCat(covCatNum); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D3000"; span.ToCode = "D3999"; CovSpans.Insert(span); covCatNum = GetForEbenCat(EbenefitCategory.Periodontics).CovCatNum; CovSpans.DeleteForCat(covCatNum); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D4000"; span.ToCode = "D4999"; CovSpans.Insert(span); covCatNum = GetForEbenCat(EbenefitCategory.OralSurgery).CovCatNum; CovSpans.DeleteForCat(covCatNum); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D7000"; span.ToCode = "D7999"; CovSpans.Insert(span); covCatNum = GetForEbenCat(EbenefitCategory.Crowns).CovCatNum; CovSpans.DeleteForCat(covCatNum); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D2700"; span.ToCode = "D2799"; CovSpans.Insert(span); covCatNum = GetForEbenCat(EbenefitCategory.Prosthodontics).CovCatNum; CovSpans.DeleteForCat(covCatNum); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D5000"; span.ToCode = "D5899"; CovSpans.Insert(span); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D6200"; span.ToCode = "D6899"; CovSpans.Insert(span); covCatNum = GetForEbenCat(EbenefitCategory.MaxillofacialProsth).CovCatNum; CovSpans.DeleteForCat(covCatNum); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D5900"; span.ToCode = "D5999"; CovSpans.Insert(span); covCatNum = GetForEbenCat(EbenefitCategory.Accident).CovCatNum; CovSpans.DeleteForCat(covCatNum); covCatNum = GetForEbenCat(EbenefitCategory.Orthodontics).CovCatNum; CovSpans.DeleteForCat(covCatNum); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D8000"; span.ToCode = "D8999"; CovSpans.Insert(span); covCatNum = GetForEbenCat(EbenefitCategory.Adjunctive).CovCatNum; CovSpans.DeleteForCat(covCatNum); span = new CovSpan(); span.CovCatNum = covCatNum; span.FromCode = "D9000"; span.ToCode = "D9999"; CovSpans.Insert(span); }