///<summary>Used by the refresh method above.</summary>
private static Def[] GetForCategory(int catIndex, bool includeHidden, DataTable table)
{
List <Def> list = new List <Def>();
Def def;
for (int i = 0; i < table.Rows.Count; i++)
{
if (PIn.PInt(table.Rows[i][1].ToString()) != catIndex)
{
continue;
}
if (PIn.PBool(table.Rows[i][6].ToString()) && //if is hidden
!includeHidden) //and we don't want to include hidden
{
continue;
}
def = new Def();
def.DefNum = PIn.PInt(table.Rows[i][0].ToString());
def.Category = (DefCat)PIn.PInt(table.Rows[i][1].ToString());
def.ItemOrder = PIn.PInt(table.Rows[i][2].ToString());
def.ItemName = PIn.PString(table.Rows[i][3].ToString());
def.ItemValue = PIn.PString(table.Rows[i][4].ToString());
def.ItemColor = Color.FromArgb(PIn.PInt(table.Rows[i][5].ToString()));
def.IsHidden = PIn.PBool(table.Rows[i][6].ToString());
list.Add(def);
}
return(list.ToArray());
}
///<summary></summary>
public static Document Fill(DataRow document)
{
if (document == null)
{
return(null);
}
Document doc = new Document();
doc.DocNum = PIn.PInt(document[0].ToString());
doc.Description = PIn.PString(document[1].ToString());
doc.DateCreated = PIn.PDate(document[2].ToString());
doc.DocCategory = PIn.PInt(document[3].ToString());
doc.PatNum = PIn.PInt(document[4].ToString());
doc.FileName = PIn.PString(document[5].ToString());
doc.ImgType = (ImageType)PIn.PInt(document[6].ToString());
doc.IsFlipped = PIn.PBool(document[7].ToString());
doc.DegreesRotated = PIn.PShort(document[8].ToString());
doc.ToothNumbers = PIn.PString(document[9].ToString());
doc.Note = PIn.PString(document[10].ToString());
doc.SigIsTopaz = PIn.PBool(document[11].ToString());
doc.Signature = PIn.PString(document[12].ToString());
doc.CropX = PIn.PInt(document[13].ToString());
doc.CropY = PIn.PInt(document[14].ToString());
doc.CropW = PIn.PInt(document[15].ToString());
doc.CropH = PIn.PInt(document[16].ToString());
doc.WindowingMin = PIn.PInt(document[17].ToString());
doc.WindowingMax = PIn.PInt(document[18].ToString());
doc.MountItemNum = PIn.PInt(document[19].ToString());
return(doc);
}
public static Appointment[] TableToObjects(DataTable table)
{
Appointment[] list = new Appointment[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
list[i] = new Appointment();
list[i].AptNum = PIn.PInt(table.Rows[i][0].ToString());
list[i].PatNum = PIn.PInt(table.Rows[i][1].ToString());
list[i].AptStatus = (ApptStatus)PIn.PInt(table.Rows[i][2].ToString());
list[i].Pattern = PIn.PString(table.Rows[i][3].ToString());
list[i].Confirmed = PIn.PInt(table.Rows[i][4].ToString());
list[i].AddTime = PIn.PInt(table.Rows[i][5].ToString());
list[i].Op = PIn.PInt(table.Rows[i][6].ToString());
list[i].Note = PIn.PString(table.Rows[i][7].ToString());
list[i].ProvNum = PIn.PInt(table.Rows[i][8].ToString());
list[i].ProvHyg = PIn.PInt(table.Rows[i][9].ToString());
list[i].AptDateTime = PIn.PDateT(table.Rows[i][10].ToString());
list[i].NextAptNum = PIn.PInt(table.Rows[i][11].ToString());
list[i].UnschedStatus = PIn.PInt(table.Rows[i][12].ToString());
//list[i].Lab =PIn.PInt(table.Rows[i][13].ToString());
list[i].IsNewPatient = PIn.PBool(table.Rows[i][14].ToString());
list[i].ProcDescript = PIn.PString(table.Rows[i][15].ToString());
list[i].Assistant = PIn.PInt(table.Rows[i][16].ToString());
list[i].InstructorNum = PIn.PInt(table.Rows[i][17].ToString());
list[i].SchoolClassNum = PIn.PInt(table.Rows[i][18].ToString());
list[i].SchoolCourseNum = PIn.PInt(table.Rows[i][19].ToString());
list[i].GradePoint = PIn.PFloat(table.Rows[i][20].ToString());
list[i].ClinicNum = PIn.PInt(table.Rows[i][21].ToString());
list[i].IsHygiene = PIn.PBool(table.Rows[i][22].ToString());
}
return(list);
}
///<summary></summary>
public static void FillLists(DataSet ds)
{
DataTable table = ds.Tables[0];
Listt = new CovCat[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
Listt[i] = new CovCat();
Listt[i].CovCatNum = PIn.PInt(table.Rows[i][0].ToString());
Listt[i].Description = PIn.PString(table.Rows[i][1].ToString());
Listt[i].DefaultPercent = PIn.PInt(table.Rows[i][2].ToString());
Listt[i].CovOrder = PIn.PInt(table.Rows[i][3].ToString());
Listt[i].IsHidden = PIn.PBool(table.Rows[i][4].ToString());
Listt[i].EbenefitCat = (EbenefitCategory)PIn.PInt(table.Rows[i][5].ToString());
}
table = ds.Tables[1];
ListShort = new CovCat[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
ListShort[i] = new CovCat();
ListShort[i].CovCatNum = PIn.PInt(table.Rows[i][0].ToString());
ListShort[i].Description = PIn.PString(table.Rows[i][1].ToString());
ListShort[i].DefaultPercent = PIn.PInt(table.Rows[i][2].ToString());
ListShort[i].CovOrder = PIn.PInt(table.Rows[i][3].ToString());
ListShort[i].IsHidden = PIn.PBool(table.Rows[i][4].ToString());
ListShort[i].EbenefitCat = (EbenefitCategory)PIn.PInt(table.Rows[i][5].ToString());
}
}
///<summary>Gets a pref of type bool.</summary>
public static bool GetBool(string prefName)
{
if (!HList.ContainsKey(prefName))
{
throw new Exception(prefName + " is an invalid pref name.");
}
return(PIn.PBool(((Pref)HList[prefName]).ValueString));
}
///<summary>Gets a list of all MountDefs when program first opens. Also refreshes MountItemDefs and attaches all items to the appropriate mounts.</summary>
public static void Refresh()
{
MountItemDefs.Refresh();
string command = "SELECT * FROM mountdef ORDER BY ItemOrder";
DataTable table = General2.GetTable(command);
Listt = new List <MountDef>();
MountDef mount;
for (int i = 0; i < table.Rows.Count; i++)
{
mount = new MountDef();
mount.MountDefNum = PIn.PInt(table.Rows[i][0].ToString());
mount.Description = PIn.PString(table.Rows[i][1].ToString());
mount.ItemOrder = PIn.PInt(table.Rows[i][2].ToString());
mount.IsRadiograph = PIn.PBool(table.Rows[i][3].ToString());
mount.Width = PIn.PInt(table.Rows[i][4].ToString());
mount.Height = PIn.PInt(table.Rows[i][5].ToString());
Listt.Add(mount);
}
}
///<summary></summary>
public static Userod GetUser(int userNum)
{
Userod user = null;
for (int i = 0; i < RawData.Rows.Count; i++)
{
if (RawData.Rows[i]["UserNum"].ToString() != userNum.ToString())
{
continue;
}
user = new Userod();
user.UserNum = PIn.PInt(RawData.Rows[i][0].ToString());
user.UserName = PIn.PString(RawData.Rows[i][1].ToString());
user.Password = PIn.PString(RawData.Rows[i][2].ToString());
user.UserGroupNum = PIn.PInt(RawData.Rows[i][3].ToString());
user.EmployeeNum = PIn.PInt(RawData.Rows[i][4].ToString());
user.ClinicNum = PIn.PInt(RawData.Rows[i][5].ToString());
user.ProvNum = PIn.PInt(RawData.Rows[i][6].ToString());
user.IsHidden = PIn.PBool(RawData.Rows[i][7].ToString());
}
return(user);
}
///<summary>If aptnum is specified, then the dates are ignored. If getting data for one planned appt, then pass isPlanned=true. This changes which procedures are retrieved.</summary>
private static DataTable GetPeriodApptsTable(string strDateStart, string strDateEnd, string strAptNum, string strIsPlanned)
{
DateTime dateStart = PIn.PDate(strDateStart);
DateTime dateEnd = PIn.PDate(strDateEnd);
int aptNum = PIn.PInt(strAptNum);
bool isPlanned = PIn.PBool(strIsPlanned);
DataConnection dcon = new DataConnection();
DataTable table = new DataTable("Appointments");
DataRow row;
//columns that start with lowercase are altered for display rather than being raw data.
table.Columns.Add("age");
table.Columns.Add("addrNote");
table.Columns.Add("apptModNote");
table.Columns.Add("aptDate");
table.Columns.Add("aptDay");
table.Columns.Add("aptLength");
table.Columns.Add("aptTime");
table.Columns.Add("AptDateTime");
table.Columns.Add("AptNum");
table.Columns.Add("AptStatus");
table.Columns.Add("Assistant");
table.Columns.Add("billingType");
table.Columns.Add("chartNumber");
table.Columns.Add("chartNumAndName");
table.Columns.Add("confirmed");
table.Columns.Add("Confirmed");
table.Columns.Add("contactMethods");
table.Columns.Add("creditIns");
table.Columns.Add("famFinUrgNote");
table.Columns.Add("hmPhone");
table.Columns.Add("ImageFolder");
table.Columns.Add("insurance");
table.Columns.Add("IsHygiene");
table.Columns.Add("lab");
table.Columns.Add("MedUrgNote");
table.Columns.Add("Note");
table.Columns.Add("Op");
table.Columns.Add("patientName");
table.Columns.Add("PatNum");
table.Columns.Add("patNum");
table.Columns.Add("GuarNum");
table.Columns.Add("patNumAndName");
table.Columns.Add("Pattern");
table.Columns.Add("preMedFlag");
table.Columns.Add("procs");
table.Columns.Add("production");
table.Columns.Add("productionVal");
table.Columns.Add("provider");
table.Columns.Add("ProvHyg");
table.Columns.Add("ProvNum");
table.Columns.Add("wkPhone");
table.Columns.Add("wirelessPhone");
string command = "SELECT p1.Abbr ProvAbbr,p2.Abbr HygAbbr,patient.AddrNote,"
+ "patient.ApptModNote,AptDateTime,appointment.AptNum,AptStatus,Assistant,"
+ "patient.BillingType,patient.BirthDate,patient.Guarantor,"
+ "patient.ChartNumber,Confirmed,patient.CreditType,DateTimeChecked,DateTimeRecd,DateTimeSent,"
+ "guar.FamFinUrgNote,patient.FName,patient.HmPhone,patient.ImageFolder,IsHygiene,IsNewPatient,"
+ "LabCaseNum,patient.LName,patient.MedUrgNote,patient.MiddleI,Note,Op,appointment.PatNum,"
+ "Pattern,patplan.PlanNum,patient.PreferConfirmMethod,patient.PreferContactMethod,patient.Preferred,"
+ "patient.PreferRecallMethod,patient.Premed,"
+ "(SELECT SUM(ProcFee) FROM procedurelog ";
if (isPlanned)
{
command += "WHERE procedurelog.PlannedAptNum=appointment.AptNum) Production, ";
}
else
{
command += "WHERE procedurelog.AptNum=appointment.AptNum) Production, ";
}
command += "ProvHyg,appointment.ProvNum,patient.WirelessPhone,patient.WkPhone "
+ "FROM appointment LEFT JOIN patient ON patient.PatNum=appointment.PatNum "
+ "LEFT JOIN provider p1 ON p1.ProvNum=appointment.ProvNum "
+ "LEFT JOIN provider p2 ON p2.ProvNum=appointment.ProvHyg ";
if (isPlanned)
{
command += "LEFT JOIN labcase ON labcase.PlannedAptNum=appointment.AptNum ";
}
else
{
command += "LEFT JOIN labcase ON labcase.AptNum=appointment.AptNum ";
}
command += "LEFT JOIN patient guar ON guar.PatNum=patient.Guarantor "
+ "LEFT JOIN patplan ON patplan.PatNum=patient.PatNum ";
if (aptNum == 0)
{
command += "WHERE AptDateTime >= " + POut.PDate(dateStart) + " "
+ "AND AptDateTime < " + POut.PDate(dateEnd.AddDays(1)) + " "
+ "AND (AptStatus=1 OR AptStatus=2 OR AptStatus=4 OR AptStatus=5 OR AptStatus=7 OR AptStatus=8) ";
}
else
{
command += "WHERE appointment.AptNum=" + POut.PInt(aptNum);
}
command += " GROUP BY appointment.AptNum";
DataTable raw = dcon.GetTable(command);
command = "SELECT AbbrDesc,procedurelog.AptNum,procedurelog.CodeNum,PlannedAptNum,Surf,ToothNum,TreatArea "
+ "FROM procedurelog,appointment,procedurecode ";
if (isPlanned)
{
command += "WHERE procedurelog.PlannedAptNum=appointment.AptNum ";
}
else
{
command += "WHERE procedurelog.AptNum=appointment.AptNum ";
}
command += "AND procedurelog.CodeNum=procedurecode.CodeNum ";
if (aptNum == 0)
{
command += "AND AptDateTime >= " + POut.PDate(dateStart) + " "
+ "AND AptDateTime < " + POut.PDate(dateEnd.AddDays(1)) + " ";
}
else
{
command += "AND appointment.AptNum=" + POut.PInt(aptNum);
}
DataTable rawProc = dcon.GetTable(command);
//procs for flag, InsNotSent
command = "SELECT patient.PatNum, patient.Guarantor "
+ "FROM patient,procedurecode,procedurelog,claimproc "
+ "WHERE claimproc.procnum=procedurelog.procnum "
+ "AND patient.PatNum=procedurelog.PatNum "
+ "AND procedurelog.CodeNum=procedurecode.CodeNum "
+ "AND claimproc.NoBillIns=0 "
+ "AND procedurelog.ProcFee>0 "
+ "AND claimproc.Status=6 " //estimate
+ "AND procedurelog.procstatus=2 "
+ "AND procedurelog.ProcDate >= " + POut.PDate(DateTime.Now.AddYears(-1)) + " "
+ "AND procedurelog.ProcDate <= " + POut.PDate(DateTime.Now) + " "
+ "GROUP BY patient.Guarantor";
DataTable rawInsProc = dcon.GetTable(command);
DateTime aptDate;
TimeSpan span;
int hours;
int minutes;
DateTime labDate;
DateTime birthdate;
for (int i = 0; i < raw.Rows.Count; i++)
{
row = table.NewRow();
if (raw.Rows[i]["AddrNote"].ToString() != "")
{
row["addrNote"] = Lan.g("Appointments", "AddrNote: ") + raw.Rows[i]["AddrNote"].ToString();
}
aptDate = PIn.PDateT(raw.Rows[i]["AptDateTime"].ToString());
row["AptDateTime"] = aptDate;
birthdate = PIn.PDate(raw.Rows[i]["Birthdate"].ToString());
row["age"] = Lan.g("Appointments", "Age: ");
if (birthdate.Year > 1880)
{
row["age"] += PatientB.DateToAgeString(birthdate);
}
else
{
row["age"] += "?";
}
if (raw.Rows[i]["ApptModNote"].ToString() != "")
{
row["apptModNote"] = Lan.g("Appointments", "ApptModNote: ") + raw.Rows[i]["ApptModNote"].ToString();
}
row["aptDate"] = aptDate.ToShortDateString();
row["aptDay"] = aptDate.ToString("dddd");
span = TimeSpan.FromMinutes(raw.Rows[i]["Pattern"].ToString().Length *5);
hours = span.Hours;
minutes = span.Minutes;
if (hours == 0)
{
row["aptLength"] = minutes.ToString() + Lan.g("Appointments", " Min");
}
else if (hours == 1)
{
row["aptLength"] = hours.ToString() + Lan.g("Appointments", " Hr, ")
+ minutes.ToString() + Lan.g("Appointments", " Min");
}
else
{
row["aptLength"] = hours.ToString() + Lan.g("Appointments", " Hrs, ")
+ minutes.ToString() + Lan.g("Appointments", " Min");
}
row["aptTime"] = aptDate.ToShortTimeString();
row["AptNum"] = raw.Rows[i]["AptNum"].ToString();
row["AptStatus"] = raw.Rows[i]["AptStatus"].ToString();
row["Assistant"] = raw.Rows[i]["Assistant"].ToString();
row["billingType"] = DefB.GetName(DefCat.BillingTypes, PIn.PInt(raw.Rows[i]["BillingType"].ToString()));
if (raw.Rows[i]["ChartNumber"].ToString() != "")
{
row["chartNumber"] = raw.Rows[i]["ChartNumber"].ToString();
}
//row["ChartNumber"]=raw.Rows[i]["ChartNumber"].ToString();
row["chartNumAndName"] = "";
if (raw.Rows[i]["IsNewPatient"].ToString() == "1")
{
row["chartNumAndName"] = "NP-";
}
row["chartNumAndName"] += raw.Rows[i]["ChartNumber"].ToString() + " "
+ PatientB.GetNameLF(raw.Rows[i]["LName"].ToString(), raw.Rows[i]["FName"].ToString(),
raw.Rows[i]["Preferred"].ToString(), raw.Rows[i]["MiddleI"].ToString());
row["confirmed"] = DefB.GetName(DefCat.ApptConfirmed, PIn.PInt(raw.Rows[i]["Confirmed"].ToString()));
row["Confirmed"] = raw.Rows[i]["Confirmed"].ToString();
row["contactMethods"] = "";
if (raw.Rows[i]["PreferConfirmMethod"].ToString() != "0")
{
row["contactMethods"] += Lan.g("Appointments", "Confirm Method: ")
+ ((ContactMethod)PIn.PInt(raw.Rows[i]["PreferConfirmMethod"].ToString())).ToString();
}
if (raw.Rows[i]["PreferContactMethod"].ToString() != "0")
{
if (row["contactMethods"].ToString() != "")
{
row["contactMethods"] += "\r\n";
}
row["contactMethods"] += Lan.g("Appointments", "Contact Method: ")
+ ((ContactMethod)PIn.PInt(raw.Rows[i]["PreferContactMethod"].ToString())).ToString();
}
if (raw.Rows[i]["PreferRecallMethod"].ToString() != "0")
{
if (row["contactMethods"].ToString() != "")
{
row["contactMethods"] += "\r\n";
}
row["contactMethods"] += Lan.g("Appointments", "Recall Method: ")
+ ((ContactMethod)PIn.PInt(raw.Rows[i]["PreferRecallMethod"].ToString())).ToString();
}
row["creditIns"] = raw.Rows[i]["CreditType"].ToString();
//figure out if pt's family has ins claims that need to be created
bool InsToSend = false;
for (int j = 0; j < rawInsProc.Rows.Count; j++)
{
if (raw.Rows[i]["PlanNum"].ToString() != "" && raw.Rows[i]["PlanNum"].ToString() != "0")
{
if (raw.Rows[i]["Guarantor"].ToString() == rawInsProc.Rows[j]["Guarantor"].ToString() ||
raw.Rows[i]["Guarantor"].ToString() == rawInsProc.Rows[j]["PatNum"].ToString())
{
InsToSend = true;
}
}
}
if (InsToSend)
{
row["creditIns"] += "!";
}
else if (raw.Rows[i]["PlanNum"].ToString() != "" && raw.Rows[i]["PlanNum"].ToString() != "0")
{
row["creditIns"] += "I";
}
if (raw.Rows[i]["FamFinUrgNote"].ToString() != "")
{
row["famFinUrgNote"] = Lan.g("Appointments", "FamFinUrgNote: ") + raw.Rows[i]["FamFinUrgNote"].ToString();
}
row["hmPhone"] = Lan.g("Appointments", "Hm: ") + raw.Rows[i]["HmPhone"].ToString();
row["ImageFolder"] = raw.Rows[i]["ImageFolder"].ToString();
if (raw.Rows[i]["PlanNum"].ToString() != "" && raw.Rows[i]["PlanNum"].ToString() != "0")
{
row["insurance"] = Lan.g("Appointments", "Insured");
}
row["IsHygiene"] = raw.Rows[i]["IsHygiene"].ToString();
row["lab"] = "";
if (raw.Rows[i]["LabCaseNum"].ToString() != "")
{
labDate = PIn.PDateT(raw.Rows[i]["DateTimeChecked"].ToString());
if (labDate.Year > 1880)
{
row["lab"] = Lan.g("Appointments", "Lab Quality Checked");
}
else
{
labDate = PIn.PDateT(raw.Rows[i]["DateTimeRecd"].ToString());
if (labDate.Year > 1880)
{
row["lab"] = Lan.g("Appointments", "Lab Received");
}
else
{
labDate = PIn.PDateT(raw.Rows[i]["DateTimeSent"].ToString());
if (labDate.Year > 1880)
{
row["lab"] = Lan.g("Appointments", "Lab Sent"); //sent but not received
}
else
{
row["lab"] = Lan.g("Appointments", "Lab Not Sent");
}
}
}
}
row["MedUrgNote"] = raw.Rows[i]["MedUrgNote"].ToString();
row["Note"] = raw.Rows[i]["Note"].ToString();
row["Op"] = raw.Rows[i]["Op"].ToString();
if (raw.Rows[i]["IsNewPatient"].ToString() == "1")
{
row["patientName"] = "NP-";
}
row["patientName"] += PatientB.GetNameLF(raw.Rows[i]["LName"].ToString(), raw.Rows[i]["FName"].ToString(),
raw.Rows[i]["Preferred"].ToString(), raw.Rows[i]["MiddleI"].ToString());
row["PatNum"] = raw.Rows[i]["PatNum"].ToString();
row["patNum"] = "PatNum: " + raw.Rows[i]["PatNum"].ToString();
row["GuarNum"] = raw.Rows[i]["Guarantor"].ToString();
row["patNumAndName"] = "";
if (raw.Rows[i]["IsNewPatient"].ToString() == "1")
{
row["patNumAndName"] = "NP-";
}
row["patNumAndName"] += raw.Rows[i]["PatNum"].ToString() + " "
+ PatientB.GetNameLF(raw.Rows[i]["LName"].ToString(), raw.Rows[i]["FName"].ToString(),
raw.Rows[i]["Preferred"].ToString(), raw.Rows[i]["MiddleI"].ToString());
row["Pattern"] = raw.Rows[i]["Pattern"].ToString();
if (raw.Rows[i]["Premed"].ToString() == "1")
{
row["preMedFlag"] = Lan.g("Appointments", "Premedicate");
}
row["procs"] = "";
for (int p = 0; p < rawProc.Rows.Count; p++)
{
if (!isPlanned && rawProc.Rows[p]["AptNum"].ToString() != raw.Rows[i]["AptNum"].ToString())
{
continue;
}
if (isPlanned && rawProc.Rows[p]["PlannedAptNum"].ToString() != raw.Rows[i]["AptNum"].ToString())
{
continue;
}
if (row["procs"].ToString() != "")
{
row["procs"] += ", ";
}
switch (rawProc.Rows[p]["TreatArea"].ToString())
{
case "1": //TreatmentArea.Surf:
row["procs"] += "#" + Tooth.ToInternat(rawProc.Rows[p]["ToothNum"].ToString()) + "-"
+ rawProc.Rows[p]["Surf"].ToString() + "-"; //""#12-MOD-"
break;
case "2": //TreatmentArea.Tooth:
row["procs"] += "#" + Tooth.ToInternat(rawProc.Rows[p]["ToothNum"].ToString()) + "-"; //"#12-"
break;
default: //area 3 or 0 (mouth)
break;
case "4": //TreatmentArea.Quad:
row["procs"] += rawProc.Rows[p]["Surf"].ToString() + "-"; //"UL-"
break;
case "5": //TreatmentArea.Sextant:
row["procs"] += "S" + rawProc.Rows[p]["Surf"].ToString() + "-"; //"S2-"
break;
case "6": //TreatmentArea.Arch:
row["procs"] += rawProc.Rows[p]["Surf"].ToString() + "-"; //"U-"
break;
case "7": //TreatmentArea.ToothRange:
//strLine+=table.Rows[j][13].ToString()+" ";//don't show range
break;
}
row["procs"] += rawProc.Rows[p]["AbbrDesc"].ToString();
}
row["production"] = PIn.PDouble(raw.Rows[i]["Production"].ToString()).ToString("c");
row["productionVal"] = raw.Rows[i]["Production"].ToString();
if (raw.Rows[i]["IsHygiene"].ToString() == "1")
{
row["provider"] = raw.Rows[i]["HygAbbr"].ToString();
if (raw.Rows[i]["ProvAbbr"].ToString() != "")
{
row["provider"] += " (" + raw.Rows[i]["ProvAbbr"].ToString() + ")";
}
}
else
{
row["provider"] = raw.Rows[i]["ProvAbbr"].ToString();
if (raw.Rows[i]["HygAbbr"].ToString() != "")
{
row["provider"] += " (" + raw.Rows[i]["HygAbbr"].ToString() + ")";
}
}
row["ProvNum"] = raw.Rows[i]["ProvNum"].ToString();
row["ProvHyg"] = raw.Rows[i]["ProvHyg"].ToString();
row["wirelessPhone"] = Lan.g("Appointments", "Cell: ") + raw.Rows[i]["WirelessPhone"].ToString();
row["wkPhone"] = Lan.g("Appointments", "Wk: ") + raw.Rows[i]["WkPhone"].ToString();
table.Rows.Add(row);
}
return(table);
}
