///<summary></summary>
public CovSpan Copy() {
CovSpan c=new CovSpan();
c.CovSpanNum=CovSpanNum;
c.CovCatNum=CovCatNum;
c.FromCode=FromCode;
c.ToCode=ToCode;
return c;
}
///<summary></summary>
public static long Insert(CovSpan span) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
span.CovSpanNum=Meth.GetLong(MethodBase.GetCurrentMethod(),span);
return span.CovSpanNum;
}
Validate(span);
return Crud.CovSpanCrud.Insert(span);
}
///<summary></summary>
public static long GetCat(string myCode)
{
//No need to check RemotingRole; no call to db.
CovSpan covSpan = GetLastOrDefault(x => String.Compare(myCode, x.FromCode) >= 0 &&
String.Compare(myCode, x.ToCode) <= 0);
return(covSpan == null ? 0 : covSpan.CovCatNum);
}
///<summary></summary>
public static void Delete(CovSpan span) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
Meth.GetVoid(MethodBase.GetCurrentMethod(),span);
return;
}
string command="DELETE FROM covspan"
+" WHERE CovSpanNum = '"+POut.Long(span.CovSpanNum)+"'";
Db.NonQ(command);
}
///<summary></summary>
private static void Validate(CovSpan span){
//No need to check RemotingRole; no call to db.
if(span.FromCode=="" || span.ToCode=="") {
throw new ApplicationException(Lans.g("FormInsSpanEdit","Codes not allowed to be blank."));
}
if(String.Compare(span.ToCode,span.FromCode)<0){
throw new ApplicationException(Lans.g("FormInsSpanEdit","From Code must be less than To Code. Remember that the comparison is alphabetical, not numeric. For instance, 100 would come before 2, but after 02."));
}
}
///<summary></summary>
public static void Update(CovSpan span) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
Meth.GetVoid(MethodBase.GetCurrentMethod(),span);
return;
}
Validate(span);
Crud.CovSpanCrud.Update(span);
return;
}
///<summary></summary>
public CovSpan Copy()
{
CovSpan c = new CovSpan();
c.CovSpanNum = CovSpanNum;
c.CovCatNum = CovCatNum;
c.FromCode = FromCode;
c.ToCode = ToCode;
return(c);
}
///<summary></summary>
public static long Insert(CovSpan span)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
span.CovSpanNum = Meth.GetLong(MethodBase.GetCurrentMethod(), span);
return(span.CovSpanNum);
}
Validate(span);
return(Crud.CovSpanCrud.Insert(span));
}
///<summary>If the supplied code falls within any of the supplied spans, then returns true.</summary>
public static bool IsCodeInSpans(string strProcCode,CovSpan[] covSpanArray)
{
//No need to check RemotingRole; no call to db.
for(int i=0;i<covSpanArray.Length;i++) {
if(String.Compare(strProcCode,covSpanArray[i].FromCode)>=0
&& String.Compare(strProcCode,covSpanArray[i].ToCode)<=0) {
return true;
}
}
return false;
}
///<summary></summary>
public static void Update(CovSpan span)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), span);
return;
}
Validate(span);
Crud.CovSpanCrud.Update(span);
return;
}
///<summary></summary>
private static void Validate(CovSpan span)
{
//No need to check RemotingRole; no call to db.
if (span.FromCode == "" || span.ToCode == "")
{
throw new ApplicationException(Lans.g("FormInsSpanEdit", "Codes not allowed to be blank."));
}
if (String.Compare(span.ToCode, span.FromCode) < 0)
{
throw new ApplicationException(Lans.g("FormInsSpanEdit", "From Code must be less than To Code. Remember that the comparison is alphabetical, not numeric. For instance, 100 would come before 2, but after 02."));
}
}
///<summary></summary>
public static void Delete(CovSpan span)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), span);
return;
}
string command = "DELETE FROM covspan"
+ " WHERE CovSpanNum = '" + POut.Long(span.CovSpanNum) + "'";
Db.NonQ(command);
}
///<summary></summary>
public static CovSpan[] GetForCat(long catNum)
{
//No need to check RemotingRole; no call to db.
ArrayList AL=new ArrayList();
for(int i=0;i<CovSpanC.List.Length;i++){
if(CovSpanC.List[i].CovCatNum==catNum){
AL.Add(CovSpanC.List[i].Copy());
}
}
CovSpan[] retVal=new CovSpan[AL.Count];
AL.CopyTo(retVal);
return retVal;
}
///<summary></summary>
public static CovSpan[] GetForCat(long catNum)
{
//No need to check RemotingRole; no call to db.
ArrayList AL = new ArrayList();
for (int i = 0; i < CovSpanC.List.Length; i++)
{
if (CovSpanC.List[i].CovCatNum == catNum)
{
AL.Add(CovSpanC.List[i].Copy());
}
}
CovSpan[] retVal = new CovSpan[AL.Count];
AL.CopyTo(retVal);
return(retVal);
}
///<summary></summary>
public static CovSpan[] GetList() {
bool isListNull=false;
lock(_lockObj) {
if(_list==null) {
isListNull=true;
}
}
if(isListNull) {
CovSpans.RefreshCache();
}
CovSpan[] arrayCovSpans;
lock(_lockObj) {
arrayCovSpans=new CovSpan[_list.Length];
for(int i=0;i<_list.Length;i++) {
arrayCovSpans[i]=_list[i].Copy();
}
}
return arrayCovSpans;
}
private void butAddSpan_Click(object sender, System.EventArgs e)
{
if(gridMain.SelectedIndices.Length<1){
MsgBox.Show(this,"Please select a category first.");
return;
}
if(gridMain.Rows[gridMain.SelectedIndices[0]].Tag.GetType()!=typeof(CovCat)){
MsgBox.Show(this,"Please select a category first.");
return;
}
CovSpan covspan=new CovSpan();
covspan.CovCatNum=((CovCat)gridMain.Rows[gridMain.SelectedIndices[0]].Tag).CovCatNum;
FormInsSpanEdit FormE=new FormInsSpanEdit(covspan);
FormE.IsNew=true;
FormE.ShowDialog();
if(FormE.DialogResult!=DialogResult.OK){
return;
}
changed=true;
FillSpans();
}
///<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);
}
///<summary></summary>
public FormInsSpanEdit(CovSpan covSpanCur){
InitializeComponent();// Required for Windows Form Designer support
CovSpanCur=covSpanCur.Copy();
Lan.F(this);
}
public static void SetSpansToDefault() {
//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);
}
///<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);
}
}
