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