///<summary>Refresh all operatories</summary>
public static void Refresh()
{
string command = "SELECT * FROM operatory "
+ "ORDER BY ItemOrder";
DataTable table = General.GetTable(command);
List = new Operatory[table.Rows.Count];
ArrayList AL = new ArrayList();
for (int i = 0; i < table.Rows.Count; i++)
{
List[i] = new Operatory();
List[i].OperatoryNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].OpName = PIn.PString(table.Rows[i][1].ToString());
List[i].Abbrev = PIn.PString(table.Rows[i][2].ToString());
List[i].ItemOrder = PIn.PInt(table.Rows[i][3].ToString());
List[i].IsHidden = PIn.PBool(table.Rows[i][4].ToString());
List[i].ProvDentist = PIn.PInt(table.Rows[i][5].ToString());
List[i].ProvHygienist = PIn.PInt(table.Rows[i][6].ToString());
List[i].IsHygiene = PIn.PBool(table.Rows[i][7].ToString());
List[i].ClinicNum = PIn.PInt(table.Rows[i][8].ToString());
if (!List[i].IsHidden)
{
AL.Add(List[i]);
}
}
ListShort = new Operatory[AL.Count];
AL.CopyTo(ListShort);
}
///<summary>Gets directly from the database. Returns true if the last time clock entry for this employee was a clockin.</summary>
public static bool IsClockedIn(int employeeNum)
{
string command = "SELECT ClockIn FROM clockevent WHERE EmployeeNum=" + POut.PInt(employeeNum)
+ " ORDER BY TimeDisplayed DESC ";
if (FormChooseDatabase.DBtype == DatabaseType.Oracle)
{
command = "SELECT * FROM (" + command + ") WHERE ROWNUM<=1";
}
else //Assume MySQL
{
command += " LIMIT 1";
}
DataTable table = General.GetTable(command);
if (table.Rows.Count == 0) //if this employee has never clocked in or out.
{
return(false);
}
if (PIn.PBool(table.Rows[0][0].ToString())) //if the last clockevent was a clockin
{
return(true);
}
return(false);
}
public static Employee[] ListShort; //does not include hidden employees
///<summary></summary>
public static void Refresh()
{
string command = "SELECT * FROM employee ORDER BY IsHidden,FName,LName";
DataTable table = General.GetTable(command);
ListLong = new Employee[table.Rows.Count];
ArrayList tempList = new ArrayList();
//Employee temp;
for (int i = 0; i < table.Rows.Count; i++)
{
ListLong[i] = new Employee();
ListLong[i].EmployeeNum = PIn.PInt(table.Rows[i][0].ToString());
ListLong[i].LName = PIn.PString(table.Rows[i][1].ToString());
ListLong[i].FName = PIn.PString(table.Rows[i][2].ToString());
ListLong[i].MiddleI = PIn.PString(table.Rows[i][3].ToString());
ListLong[i].IsHidden = PIn.PBool(table.Rows[i][4].ToString());
ListLong[i].ClockStatus = PIn.PString(table.Rows[i][5].ToString());
if (!ListLong[i].IsHidden)
{
tempList.Add(ListLong[i]);
}
}
ListShort = new Employee[tempList.Count];
for (int i = 0; i < tempList.Count; i++)
{
ListShort[i] = (Employee)tempList[i];
}
}
///<summary></summary>
public static void Refresh()
{
string command =
"SELECT * from account "
+ " ORDER BY AcctType,Description";
DataTable table = General.GetTable(command);
listLong = new Account[table.Rows.Count];
ArrayList AL = new ArrayList();
for (int i = 0; i < listLong.Length; i++)
{
listLong[i] = new Account();
listLong[i].AccountNum = PIn.PInt(table.Rows[i][0].ToString());
listLong[i].Description = PIn.PString(table.Rows[i][1].ToString());
listLong[i].AcctType = (AccountType)PIn.PInt(table.Rows[i][2].ToString());
listLong[i].BankNumber = PIn.PString(table.Rows[i][3].ToString());
listLong[i].Inactive = PIn.PBool(table.Rows[i][4].ToString());
listLong[i].AccountColor = Color.FromArgb(PIn.PInt(table.Rows[i][5].ToString()));
if (!listLong[i].Inactive)
{
AL.Add(listLong[i].Copy());
}
}
listShort = new Account[AL.Count];
AL.CopyTo(listShort);
}
///<summary>Carriers are not refreshed as local data, but are refreshed as needed. A full refresh is frequently triggered if a carrierNum cannot be found in the HList. Important retrieval is done directly from the db.</summary>
public static void Refresh()
{
HList = new Hashtable();
string command = "SELECT * FROM carrier ORDER BY CarrierName";
DataTable table = General.GetTable(command);
List = new Carrier[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
List[i] = new Carrier();
List[i].CarrierNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].CarrierName = PIn.PString(table.Rows[i][1].ToString());
List[i].Address = PIn.PString(table.Rows[i][2].ToString());
List[i].Address2 = PIn.PString(table.Rows[i][3].ToString());
List[i].City = PIn.PString(table.Rows[i][4].ToString());
List[i].State = PIn.PString(table.Rows[i][5].ToString());
List[i].Zip = PIn.PString(table.Rows[i][6].ToString());
List[i].Phone = PIn.PString(table.Rows[i][7].ToString());
List[i].ElectID = PIn.PString(table.Rows[i][8].ToString());
List[i].NoSendElect = PIn.PBool(table.Rows[i][9].ToString());
List[i].IsCDA = PIn.PBool(table.Rows[i][10].ToString());
List[i].IsPMP = PIn.PBool(table.Rows[i][11].ToString());
List[i].CDAnetVersion = PIn.PString(table.Rows[i][12].ToString());
List[i].CanadianNetworkNum = PIn.PInt(table.Rows[i][13].ToString());
HList.Add(List[i].CarrierNum, List[i]);
}
}
///<summary>Refreshes all referrals for all patients. Need to rework at some point so less memory is consumed. Also refreshes dynamically, so no need to invalidate local data.</summary>
public static void Refresh()
{
string command =
"SELECT * from referral "
+ "ORDER BY lname";
DataTable table = General.GetTable(command);
List = new Referral[table.Rows.Count];
HList = new Hashtable();
for (int i = 0; i < table.Rows.Count; i++)
{
List[i] = new Referral();
List[i].ReferralNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].LName = PIn.PString(table.Rows[i][1].ToString());
List[i].FName = PIn.PString(table.Rows[i][2].ToString());
List[i].MName = PIn.PString(table.Rows[i][3].ToString());
List[i].SSN = PIn.PString(table.Rows[i][4].ToString());
List[i].UsingTIN = PIn.PBool(table.Rows[i][5].ToString());
List[i].Specialty = (DentalSpecialty)PIn.PInt(table.Rows[i][6].ToString());
List[i].ST = PIn.PString(table.Rows[i][7].ToString());
List[i].Telephone = PIn.PString(table.Rows[i][8].ToString());
List[i].Address = PIn.PString(table.Rows[i][9].ToString());
List[i].Address2 = PIn.PString(table.Rows[i][10].ToString());
List[i].City = PIn.PString(table.Rows[i][11].ToString());
List[i].Zip = PIn.PString(table.Rows[i][12].ToString());
List[i].Note = PIn.PString(table.Rows[i][13].ToString());
List[i].Phone2 = PIn.PString(table.Rows[i][14].ToString());
List[i].IsHidden = PIn.PBool(table.Rows[i][15].ToString());
List[i].NotPerson = PIn.PBool(table.Rows[i][16].ToString());
List[i].Title = PIn.PString(table.Rows[i][17].ToString());
List[i].EMail = PIn.PString(table.Rows[i][18].ToString());
List[i].PatNum = PIn.PInt(table.Rows[i][19].ToString());
HList.Add(List[i].ReferralNum, List[i]);
}
}
///<summary>Fills ListShort and ListLong with all claimforms from the db. Also attaches corresponding claimformitems to each.</summary>
public static void Refresh()
{
string command =
"SELECT * FROM claimform";
DataTable table = General.GetTable(command);
ListLong = new ClaimForm[table.Rows.Count];
ArrayList tempAL = new ArrayList();
for (int i = 0; i < table.Rows.Count; i++)
{
ListLong[i] = new ClaimForm();
ListLong[i].ClaimFormNum = PIn.PInt(table.Rows[i][0].ToString());
ListLong[i].Description = PIn.PString(table.Rows[i][1].ToString());
ListLong[i].IsHidden = PIn.PBool(table.Rows[i][2].ToString());
ListLong[i].FontName = PIn.PString(table.Rows[i][3].ToString());
ListLong[i].FontSize = PIn.PFloat(table.Rows[i][4].ToString());
ListLong[i].UniqueID = PIn.PString(table.Rows[i][5].ToString());
ListLong[i].PrintImages = PIn.PBool(table.Rows[i][6].ToString());
ListLong[i].OffsetX = PIn.PInt(table.Rows[i][7].ToString());
ListLong[i].OffsetY = PIn.PInt(table.Rows[i][8].ToString());
ListLong[i].Items = ClaimFormItems.GetListForForm(ListLong[i].ClaimFormNum);
if (!ListLong[i].IsHidden)
{
tempAL.Add(ListLong[i]);
}
}
ListShort = new ClaimForm[tempAL.Count];
for (int i = 0; i < ListShort.Length; i++)
{
ListShort[i] = (ClaimForm)tempAL[i];
}
}
///<summary>Called from claimsend window.</summary>
public static ClaimSendQueueItem[] GetQueueList()
{
string command =
"SELECT claim.ClaimNum,carrier.NoSendElect"
+ ",CONCAT(CONCAT(CONCAT(concat(patient.LName,', '),patient.FName),' '),patient.MiddleI)"
+ ",claim.ClaimStatus,carrier.CarrierName,patient.PatNum,carrier.ElectID,insplan.IsMedical "
+ "FROM claim "
+ "Left join insplan on claim.PlanNum = insplan.PlanNum "
+ "Left join carrier on insplan.CarrierNum = carrier.CarrierNum "
+ "Left join patient on patient.PatNum = claim.PatNum "
+ "WHERE claim.ClaimStatus = 'W' OR claim.ClaimStatus = 'P' "
+ "ORDER BY insplan.IsMedical"; //this puts the medical claims at the end, helping with the looping in X12.
//MessageBox.Show(string command);
DataTable table = General.GetTable(command);
ClaimSendQueueItem[] listQueue = new ClaimSendQueueItem[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
listQueue[i] = new ClaimSendQueueItem();
listQueue[i].ClaimNum = PIn.PInt(table.Rows[i][0].ToString());
listQueue[i].NoSendElect = PIn.PBool(table.Rows[i][1].ToString());
listQueue[i].PatName = PIn.PString(table.Rows[i][2].ToString());
listQueue[i].ClaimStatus = PIn.PString(table.Rows[i][3].ToString());
listQueue[i].Carrier = PIn.PString(table.Rows[i][4].ToString());
listQueue[i].PatNum = PIn.PInt(table.Rows[i][5].ToString());
listQueue[i].ClearinghouseNum = Clearinghouses.GetNumForPayor(PIn.PString(table.Rows[i][6].ToString()));
listQueue[i].IsMedical = PIn.PBool(table.Rows[i][7].ToString());
}
return(listQueue);
}
///<summary></summary>
public static void Refresh()
{
string command = "SELECT * from autocode";
DataTable table = General.GetTable(command);
HList = new Hashtable();
List = new AutoCode[table.Rows.Count];
ArrayList ALshort = new ArrayList(); //int of indexes of short list
for (int i = 0; i < List.Length; i++)
{
List[i] = new AutoCode();
List[i].AutoCodeNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].Description = PIn.PString(table.Rows[i][1].ToString());
List[i].IsHidden = PIn.PBool(table.Rows[i][2].ToString());
List[i].LessIntrusive = PIn.PBool(table.Rows[i][3].ToString());
HList.Add(List[i].AutoCodeNum, List[i]);
if (!List[i].IsHidden)
{
ALshort.Add(i);
}
}
ListShort = new AutoCode[ALshort.Count];
for (int i = 0; i < ALshort.Count; i++)
{
ListShort[i] = List[(int)ALshort[i]];
}
}
/*
* ///<summary></summary>
* public static Document[] GetAllWithPat(int patNum) {
* string command="SELECT * FROM document WHERE WithPat="+POut.PInt(patNum);
* return RefreshAndFill(command);
* }*/
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.WithPat = 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.PInt(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());
return(doc);
}
///<summary></summary>
public static void Refresh()
{
//MessageBox.Show("refreshing");
HList = new Hashtable();
Program tempProgram = new Program();
string command =
"SELECT * from program ORDER BY ProgDesc";
DataTable table = General.GetTable(command);
List = new Program[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
tempProgram = new Program();
tempProgram.ProgramNum = PIn.PInt(table.Rows[i][0].ToString());
tempProgram.ProgName = PIn.PString(table.Rows[i][1].ToString());
tempProgram.ProgDesc = PIn.PString(table.Rows[i][2].ToString());
tempProgram.Enabled = PIn.PBool(table.Rows[i][3].ToString());
tempProgram.Path = PIn.PString(table.Rows[i][4].ToString());
tempProgram.CommandLine = PIn.PString(table.Rows[i][5].ToString());
tempProgram.Note = PIn.PString(table.Rows[i][6].ToString());
List[i] = tempProgram;
if (!HList.ContainsKey(tempProgram.ProgName))
{
HList.Add(tempProgram.ProgName, tempProgram);
}
}
//MessageBox.Show(HList.Count.ToString());
}
///<summary>Gets all recalls for the supplied patients, usually a family or single pat. Result might have a length of zero.</summary>
public static Recall[] GetList(int[] patNums)
{
string wherePats = "";
for (int i = 0; i < patNums.Length; i++)
{
if (i != 0)
{
wherePats += " OR ";
}
wherePats += "PatNum=" + patNums[i].ToString();
}
string command =
"SELECT * from recall "
+ "WHERE " + wherePats;
DataTable table = General.GetTable(command);
Recall[] List = new Recall[table.Rows.Count];
for (int i = 0; i < List.Length; i++)
{
List[i] = new Recall();
List[i].RecallNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].PatNum = PIn.PInt(table.Rows[i][1].ToString());
List[i].DateDueCalc = PIn.PDate(table.Rows[i][2].ToString());
List[i].DateDue = PIn.PDate(table.Rows[i][3].ToString());
List[i].DatePrevious = PIn.PDate(table.Rows[i][4].ToString());
List[i].RecallInterval = new Interval(PIn.PInt(table.Rows[i][5].ToString()));
List[i].RecallStatus = PIn.PInt(table.Rows[i][6].ToString());
List[i].Note = PIn.PString(table.Rows[i][7].ToString());
List[i].IsDisabled = PIn.PBool(table.Rows[i][8].ToString());
}
return(List);
}
///<summary>Fills the specified array of Appointments using the supplied SQL command.</summary>
private static Appointment[] FillList(string command)
{
DataTable table = General.GetTable(command);
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 = (LabCase)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>Refreshed automatically to always be kept current with all phrases, regardless of whether there are any entries in LanguageForeign table.</summary>
public static void Refresh()
{
HList = new Hashtable();
if (CultureInfo.CurrentCulture.Name == "en-US")
{
return;
}
string command = "SELECT * from language";
DataTable table = General.GetTable(command);
List = new Language[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
List[i] = new Language();
//List[i].EnglishCommentsOld= PIn.PString(table.Rows[i][0].ToString());
List[i].ClassType = PIn.PString(table.Rows[i][1].ToString());
List[i].English = PIn.PString(table.Rows[i][2].ToString());
List[i].IsObsolete = PIn.PBool(table.Rows[i][3].ToString());
if (!HList.ContainsKey(List[i].ClassType + List[i].English))
{
HList.Add(List[i].ClassType + List[i].English, List[i]);
}
}
//MessageBox.Show(List.Length.ToString());
}
///<summary>Surround with try/catch.</summary>
public static void Update(Carrier Cur)
{
string command;
DataTable table;
if (CultureInfo.CurrentCulture.Name.Substring(3) == "CA") //en-CA or fr-CA
{
if (Cur.IsCDA)
{
if (Cur.ElectID == "")
{
throw new ApplicationException(Lan.g("Carriers", "EDI Code required."));
}
if (!Regex.IsMatch(Cur.ElectID, "^[0-9]{6}$"))
{
throw new ApplicationException(Lan.g("Carriers", "EDI Code must be exactly 6 numbers."));
}
command = "SELECT CarrierNum FROM carrier WHERE "
+ "ElectID = '" + POut.PString(Cur.ElectID) + "' "
+ "AND IsCDA=1 "
+ "AND CarrierNum != " + POut.PInt(Cur.CarrierNum);
table = General.GetTable(command);
if (table.Rows.Count > 0) //if there already exists a Canadian carrier with that ElectID
{
throw new ApplicationException(Lan.g("Carriers", "EDI Code already in use."));
}
}
//so the edited carrier looks good, but now we need to make sure that the original was allowed to be changed.
command = "SELECT ElectID,IsCDA FROM carrier WHERE CarrierNum = '" + POut.PInt(Cur.CarrierNum) + "'";
table = General.GetTable(command);
if (PIn.PBool(table.Rows[0][1].ToString()) && //if original carrier IsCDA
PIn.PString(table.Rows[0][0].ToString()) != Cur.ElectID) //and the ElectID was changed
{
command = "SELECT COUNT(*) FROM etrans WHERE CarrierNum= " + POut.PInt(Cur.CarrierNum)
+ " OR CarrierNum2=" + POut.PInt(Cur.CarrierNum);
if (General.GetCount(command) != "0")
{
throw new ApplicationException(Lan.g("Carriers", "Not allowed to change EDI Code because it's in use in the claim history."));
}
}
}
command = "UPDATE carrier SET "
+ "CarrierName= '" + POut.PString(Cur.CarrierName) + "' "
+ ",Address= '" + POut.PString(Cur.Address) + "' "
+ ",Address2= '" + POut.PString(Cur.Address2) + "' "
+ ",City= '" + POut.PString(Cur.City) + "' "
+ ",State= '" + POut.PString(Cur.State) + "' "
+ ",Zip= '" + POut.PString(Cur.Zip) + "' "
+ ",Phone= '" + POut.PString(Cur.Phone) + "' "
+ ",ElectID= '" + POut.PString(Cur.ElectID) + "' "
+ ",NoSendElect= '" + POut.PBool(Cur.NoSendElect) + "' "
+ ",IsCDA= '" + POut.PBool(Cur.IsCDA) + "' "
+ ",IsPMP= '" + POut.PBool(Cur.IsPMP) + "' "
+ ",CDAnetVersion= '" + POut.PString(Cur.CDAnetVersion) + "' "
+ ",CanadianNetworkNum= '" + POut.PInt(Cur.CanadianNetworkNum) + "' "
+ "WHERE CarrierNum = '" + POut.PInt(Cur.CarrierNum) + "'";
//MessageBox.Show(string command);
General.NonQ(command);
}
///<summary>Used to get a list of carriers to display in the FormCarriers window. Only used for Canadian right now.</summary>
public static DataTable Refresh(bool isCanadian)
{
DataTable tableRaw;
DataTable tableReturn;
string command;
if (isCanadian)
{
command = "SELECT CarrierNum, CarrierName, ElectID, IsPMP, canadiannetwork.Abbrev, CDAnetVersion FROM carrier "
+ "LEFT JOIN canadiannetwork ON canadiannetwork.CanadianNetworkNum=carrier.CanadianNetworkNum "
+ "WHERE IsCDA=1 ORDER BY CarrierName";
tableRaw = General.GetTable(command);
tableReturn = new DataTable();
tableReturn.Columns.Add("CarrierNum");
tableReturn.Columns.Add("CarrierName");
tableReturn.Columns.Add("ElectID");
tableReturn.Columns.Add("PMP");
tableReturn.Columns.Add("Network");
tableReturn.Columns.Add("Version");
tableReturn.Columns.Add("Trans02");
tableReturn.Columns.Add("Trans03");
tableReturn.Columns.Add("Trans04");
tableReturn.Columns.Add("Trans05");
tableReturn.Columns.Add("Trans06");
tableReturn.Columns.Add("Trans07");
tableReturn.Columns.Add("Trans08");
DataRow row;
for (int i = 0; i < tableRaw.Rows.Count; i++)
{
row = tableReturn.NewRow();
row["CarrierNum"] = tableRaw.Rows[i]["CarrierNum"].ToString();
row["CarrierName"] = tableRaw.Rows[i]["CarrierName"].ToString();
row["ElectID"] = tableRaw.Rows[i]["ElectID"].ToString();
if (PIn.PBool(tableRaw.Rows[i]["IsPMP"].ToString()))
{
row["PMP"] = "X";
}
else
{
row["PMP"] = "";
}
row["Network"] = tableRaw.Rows[i]["Abbrev"].ToString();
row["Version"] = tableRaw.Rows[i]["CDAnetVersion"].ToString();
row["Trans02"] = "X";
row["Trans03"] = "X";
row["Trans04"] = "X";
row["Trans05"] = "X";
row["Trans06"] = "X";
row["Trans07"] = "X";
row["Trans08"] = "X";
tableReturn.Rows.Add(row);
}
return(tableReturn);
}
return(null);
}
///<summary>Fills List with all AppointmentRules.</summary>
public static void Refresh() {
string command="SELECT * FROM appointmentrule";
DataTable table=General.GetTable(command);
List=new AppointmentRule[table.Rows.Count];
for(int i=0;i<table.Rows.Count;i++) {
List[i]=new AppointmentRule();
List[i].AppointmentRuleNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].RuleDesc = PIn.PString(table.Rows[i][1].ToString());
List[i].ADACodeStart = PIn.PString(table.Rows[i][2].ToString());
List[i].ADACodeEnd = PIn.PString(table.Rows[i][3].ToString());
List[i].IsEnabled = PIn.PBool(table.Rows[i][4].ToString());
}
}
///<summary></summary>
public static void Refresh()
{
HList = new Hashtable();
ProcedureCode tempCode = new ProcedureCode();
string command = "SELECT * FROM procedurecode ORDER BY ProcCat,ProcCode";
DataTable table = General.GetTable(command);
tableStat = table.Copy();
RecallAL = new ArrayList();
List = new ProcedureCode[tableStat.Rows.Count];
for (int i = 0; i < tableStat.Rows.Count; i++)
{
tempCode = new ProcedureCode();
tempCode.CodeNum = PIn.PInt(tableStat.Rows[i][0].ToString());
tempCode.ProcCode = PIn.PString(tableStat.Rows[i][1].ToString());
tempCode.Descript = PIn.PString(tableStat.Rows[i][2].ToString());
tempCode.AbbrDesc = PIn.PString(tableStat.Rows[i][3].ToString());
tempCode.ProcTime = PIn.PString(tableStat.Rows[i][4].ToString());
tempCode.ProcCat = PIn.PInt(tableStat.Rows[i][5].ToString());
tempCode.TreatArea = (TreatmentArea)PIn.PInt(tableStat.Rows[i][6].ToString());
//tempCode.RemoveTooth =PIn.PBool (tableStat.Rows[i][7].ToString());
tempCode.SetRecall = PIn.PBool(tableStat.Rows[i][8].ToString());
tempCode.NoBillIns = PIn.PBool(tableStat.Rows[i][9].ToString());
tempCode.IsProsth = PIn.PBool(tableStat.Rows[i][10].ToString());
tempCode.DefaultNote = PIn.PString(tableStat.Rows[i][11].ToString());
tempCode.IsHygiene = PIn.PBool(tableStat.Rows[i][12].ToString());
tempCode.GTypeNum = PIn.PInt(tableStat.Rows[i][13].ToString());
tempCode.AlternateCode1 = PIn.PString(tableStat.Rows[i][14].ToString());
tempCode.MedicalCode = PIn.PString(tableStat.Rows[i][15].ToString());
tempCode.IsTaxed = PIn.PBool(tableStat.Rows[i][16].ToString());
tempCode.PaintType = (ToothPaintingType)PIn.PInt(tableStat.Rows[i][17].ToString());
tempCode.GraphicColor = Color.FromArgb(PIn.PInt(tableStat.Rows[i][18].ToString()));
tempCode.LaymanTerm = PIn.PString(tableStat.Rows[i][19].ToString());
tempCode.IsCanadianLab = PIn.PBool(tableStat.Rows[i][20].ToString());
tempCode.PreExisting = PIn.PBool(tableStat.Rows[i][21].ToString());
tempCode.BaseUnits = PIn.PInt(tableStat.Rows[i][22].ToString());
tempCode.SubstitutionCode = PIn.PString(tableStat.Rows[i][23].ToString());
//tempCode.SubstOnlyIf =(SubstitutionCondition)PIn.PInt(tableStat.Rows[i][24].ToString());
try {
HList.Add(tempCode.ProcCode, tempCode.Copy());
}
catch {
}
List[i] = tempCode.Copy();
if (tempCode.SetRecall)
{
RecallAL.Add(tempCode);
}
}
}
///<summary>Returns the computer preferences for the computer which this instance of Open Dental is running on.</summary>
public static ComputerPref GetForLocalComputer()
{
string computerName = Dns.GetHostName(); //local computer name
string command = "SELECT * FROM computerpref WHERE ComputerName='" + POut.PString(computerName) + "'";
DataTable table;
ComputerPref computerPref = new ComputerPref();
//OpenGL tooth chart not supported on Unix systems.
if (Environment.OSVersion.Platform == PlatformID.Unix)
{
computerPref.GraphicsSimple = true;
}
//Default sensor values to start
computerPref.SensorType = "D";
computerPref.SensorPort = 0;
computerPref.SensorExposure = 1;
computerPref.SensorBinned = false;
try{
table = General.GetTableEx(command);
}catch {
//In case of database error, just use default graphics settings so that it is possible for the program to start.
return(computerPref);
}
if (table.Rows.Count == 0) //Computer prefs do not exist yet.
{
computerPref.ComputerName = computerName;
Insert(computerPref); //Create default prefs for the specified computer. Also sets primary key in our computerPref object.
return(computerPref);
}
if (table.Rows.Count > 1)
{
//Should never happen (would only happen if the primary key showed up more than once).
Logger.openlog.LogMB("Corrupt computerpref table in database. The computer name '"
+ POut.PString(computerName) + "' is a primary key in multiple records. Please run the "
+ "database maintenance tool, then call us for help if you still get this message.",
Logger.Severity.WARNING);
}
computerPref.ComputerPrefNum = PIn.PInt(table.Rows[0][0].ToString());
computerPref.ComputerName = PIn.PString(table.Rows[0][1].ToString());
computerPref.GraphicsUseHardware = PIn.PBool(table.Rows[0][2].ToString());
computerPref.GraphicsSimple = PIn.PBool(table.Rows[0][3].ToString());
computerPref.SensorType = PIn.PString(table.Rows[0][4].ToString());
computerPref.SensorBinned = PIn.PBool(table.Rows[0][5].ToString());
computerPref.SensorPort = PIn.PInt(table.Rows[0][6].ToString());
computerPref.SensorExposure = PIn.PInt(table.Rows[0][7].ToString());
computerPref.GraphicsDoubleBuffering = PIn.PBool(table.Rows[0][8].ToString());
computerPref.PreferredPixelFormatNum = PIn.PInt(table.Rows[0][9].ToString());
return(computerPref);
}
private static Printer[] RefreshAndFill(string command)
{
DataTable table = General.GetTable(command);
Printer[] pList = new Printer[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
pList[i] = new Printer();
pList[i].PrinterNum = PIn.PInt(table.Rows[i][0].ToString());
pList[i].ComputerNum = PIn.PInt(table.Rows[i][1].ToString());
pList[i].PrintSit = (PrintSituation)PIn.PInt(table.Rows[i][2].ToString());
pList[i].PrinterName = PIn.PString(table.Rows[i][3].ToString());
pList[i].DisplayPrompt = PIn.PBool(table.Rows[i][4].ToString());
}
return(pList);
}
private static Reconcile[] RefreshAndFill(string command)
{
DataTable table = General.GetTable(command);
Reconcile[] List = new Reconcile[table.Rows.Count];
for (int i = 0; i < List.Length; i++)
{
List[i] = new Reconcile();
List[i].ReconcileNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].AccountNum = PIn.PInt(table.Rows[i][1].ToString());
List[i].StartingBal = PIn.PDouble(table.Rows[i][2].ToString());
List[i].EndingBal = PIn.PDouble(table.Rows[i][3].ToString());
List[i].DateReconcile = PIn.PDate(table.Rows[i][4].ToString());
List[i].IsLocked = PIn.PBool(table.Rows[i][5].ToString());
}
return(List);
}
///<summary>Only used in translation tool to get list for one category</summary>
public static Language[] GetListForCat(string classType)
{
string command = "SELECT * FROM language "
+ "WHERE ClassType = BINARY '" + POut.PString(classType) + "' ORDER BY English";
DataTable table = General.GetTable(command);
Language[] ListForCat = new Language[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
ListForCat[i] = new Language();
//ListForCat[i].EnglishComments= PIn.PString(table.Rows[i][0].ToString());
ListForCat[i].ClassType = PIn.PString(table.Rows[i][1].ToString());
ListForCat[i].English = PIn.PString(table.Rows[i][2].ToString());
ListForCat[i].IsObsolete = PIn.PBool(table.Rows[i][3].ToString());
}
return(ListForCat);
}
///<summary>Since users not allowed to edit, this only gets run on startup.</summary>
public static void Refresh()
{
string command = "SELECT * from electid "
+ "ORDER BY CarrierName";
DataTable table = General.GetTable(command);
List = new ElectID[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
List[i] = new ElectID();
List[i].ElectIDNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].PayorID = PIn.PString(table.Rows[i][1].ToString());
List[i].CarrierName = PIn.PString(table.Rows[i][2].ToString());
List[i].IsMedicaid = PIn.PBool(table.Rows[i][3].ToString());
List[i].ProviderTypes = PIn.PString(table.Rows[i][4].ToString());
List[i].Comments = PIn.PString(table.Rows[i][5].ToString());
}
}
///<summary></summary>
public static ClaimProc[] Refresh(int patNum)
{
string command =
"SELECT * from claimproc "
+ "WHERE PatNum = '" + patNum.ToString() + "' ORDER BY LineNumber";
DataTable table = General.GetTable(command);
ClaimProc[] List = new ClaimProc[table.Rows.Count];
for (int i = 0; i < List.Length; i++)
{
List[i] = new ClaimProc();
List[i].ClaimProcNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].ProcNum = PIn.PInt(table.Rows[i][1].ToString());
List[i].ClaimNum = PIn.PInt(table.Rows[i][2].ToString());
List[i].PatNum = PIn.PInt(table.Rows[i][3].ToString());
List[i].ProvNum = PIn.PInt(table.Rows[i][4].ToString());
List[i].FeeBilled = PIn.PDouble(table.Rows[i][5].ToString());
List[i].InsPayEst = PIn.PDouble(table.Rows[i][6].ToString());
List[i].DedApplied = PIn.PDouble(table.Rows[i][7].ToString());
List[i].Status = (ClaimProcStatus)PIn.PInt(table.Rows[i][8].ToString());
List[i].InsPayAmt = PIn.PDouble(table.Rows[i][9].ToString());
List[i].Remarks = PIn.PString(table.Rows[i][10].ToString());
List[i].ClaimPaymentNum = PIn.PInt(table.Rows[i][11].ToString());
List[i].PlanNum = PIn.PInt(table.Rows[i][12].ToString());
List[i].DateCP = PIn.PDate(table.Rows[i][13].ToString());
List[i].WriteOff = PIn.PDouble(table.Rows[i][14].ToString());
List[i].CodeSent = PIn.PString(table.Rows[i][15].ToString());
List[i].AllowedAmt = PIn.PDouble(table.Rows[i][16].ToString());
List[i].Percentage = PIn.PInt(table.Rows[i][17].ToString());
List[i].PercentOverride = PIn.PInt(table.Rows[i][18].ToString());
List[i].CopayAmt = PIn.PDouble(table.Rows[i][19].ToString());
List[i].OverrideInsEst = PIn.PDouble(table.Rows[i][20].ToString());
List[i].NoBillIns = PIn.PBool(table.Rows[i][21].ToString());
List[i].DedBeforePerc = PIn.PBool(table.Rows[i][22].ToString());
List[i].OverAnnualMax = PIn.PDouble(table.Rows[i][23].ToString());
List[i].PaidOtherIns = PIn.PDouble(table.Rows[i][24].ToString());
List[i].BaseEst = PIn.PDouble(table.Rows[i][25].ToString());
List[i].CopayOverride = PIn.PDouble(table.Rows[i][26].ToString());
List[i].ProcDate = PIn.PDate(table.Rows[i][27].ToString());
List[i].DateEntry = PIn.PDate(table.Rows[i][28].ToString());
List[i].LineNumber = PIn.PInt(table.Rows[i][29].ToString());
}
return(List);
}
///<summary></summary>
public static void Refresh()
{
string command =
"SELECT * FROM clearinghouse";
DataTable table = General.GetTable(command);
list = new Clearinghouse[table.Rows.Count];
HList = new Hashtable();
string[] payors;
for (int i = 0; i < table.Rows.Count; i++)
{
list[i] = new Clearinghouse();
list[i].ClearinghouseNum = PIn.PInt(table.Rows[i][0].ToString());
list[i].Description = PIn.PString(table.Rows[i][1].ToString());
list[i].ExportPath = PIn.PString(table.Rows[i][2].ToString());
list[i].IsDefault = PIn.PBool(table.Rows[i][3].ToString());
list[i].Payors = PIn.PString(table.Rows[i][4].ToString());
list[i].Eformat = (ElectronicClaimFormat)PIn.PInt(table.Rows[i][5].ToString());
list[i].ISA05 = PIn.PString(table.Rows[i][6].ToString());
list[i].SenderTIN = PIn.PString(table.Rows[i][7].ToString());
list[i].ISA07 = PIn.PString(table.Rows[i][8].ToString());
list[i].ISA08 = PIn.PString(table.Rows[i][9].ToString());
list[i].ISA15 = PIn.PString(table.Rows[i][10].ToString());
list[i].Password = PIn.PString(table.Rows[i][11].ToString());
list[i].ResponsePath = PIn.PString(table.Rows[i][12].ToString());
list[i].CommBridge = (EclaimsCommBridge)PIn.PInt(table.Rows[i][13].ToString());
list[i].ClientProgram = PIn.PString(table.Rows[i][14].ToString());
//15: LastBatchNumber
list[i].ModemPort = PIn.PInt(table.Rows[i][16].ToString());
list[i].LoginID = PIn.PString(table.Rows[i][17].ToString());
list[i].SenderName = PIn.PString(table.Rows[i][18].ToString());
list[i].SenderTelephone = PIn.PString(table.Rows[i][19].ToString());
list[i].GS03 = PIn.PString(table.Rows[i][20].ToString());
payors = list[i].Payors.Split(',');
for (int j = 0; j < payors.Length; j++)
{
if (!HList.ContainsKey(payors[j]))
{
HList.Add(payors[j], list[i].ClearinghouseNum);
}
}
}
}
private static Commlog[] RefreshAndFill(string command)
{
DataTable table = General.GetTable(command);
Commlog[] List = new Commlog[table.Rows.Count];
for (int i = 0; i < List.Length; i++)
{
List[i] = new Commlog();
List[i].CommlogNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].PatNum = PIn.PInt(table.Rows[i][1].ToString());
List[i].CommDateTime = PIn.PDate(table.Rows[i][2].ToString());
List[i].CommType = PIn.PInt(table.Rows[i][3].ToString());
List[i].Note = PIn.PString(table.Rows[i][4].ToString());
List[i].Mode_ = (CommItemMode)PIn.PInt(table.Rows[i][5].ToString());
List[i].SentOrReceived = (CommSentOrReceived)PIn.PInt(table.Rows[i][6].ToString());
List[i].IsStatementSent = PIn.PBool(table.Rows[i][7].ToString());
}
return(List);
}
/*
* ///<summary></summary>
* public static Document[] GetAllWithPat(int patNum) {
* string command="SELECT * FROM document WHERE WithPat="+POut.PInt(patNum);
* return RefreshAndFill(command);
* }*/
private static Document[] RefreshAndFill(string command)
{
DataSet ds = null;
try {
if (RemotingClient.OpenDentBusinessIsLocal)
{
ds = GeneralB.GetTable(command);
}
else
{
DtoGeneralGetTable dto = new DtoGeneralGetTable();
dto.Command = command;
ds = RemotingClient.ProcessQuery(dto);
}
}
catch (Exception e) {
MessageBox.Show(e.Message);
}
DataTable table = ds.Tables[0];
Document[] List = new Document[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
List[i] = new Document();
List[i].DocNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].Description = PIn.PString(table.Rows[i][1].ToString());
List[i].DateCreated = PIn.PDate(table.Rows[i][2].ToString());
List[i].DocCategory = PIn.PInt(table.Rows[i][3].ToString());
List[i].WithPat = PIn.PInt(table.Rows[i][4].ToString());
List[i].FileName = PIn.PString(table.Rows[i][5].ToString());
List[i].ImgType = (ImageType)PIn.PInt(table.Rows[i][6].ToString());
List[i].IsFlipped = PIn.PBool(table.Rows[i][7].ToString());
List[i].DegreesRotated = PIn.PInt(table.Rows[i][8].ToString());
List[i].ToothNumbers = PIn.PString(table.Rows[i][9].ToString());
List[i].Note = PIn.PString(table.Rows[i][10].ToString());
List[i].SigIsTopaz = PIn.PBool(table.Rows[i][11].ToString());
List[i].Signature = PIn.PString(table.Rows[i][12].ToString());
}
return(List);
}
//<summary>This should be eliminated when time. It's just used in FormProviderSelect to keep track of which provider is highlighted.</summary>
//public static int Selected;
///<summary>Refreshes List with all providers.</summary>
public static void Refresh()
{
ArrayList AL = new ArrayList();
string command = "SELECT * FROM provider ORDER BY ItemOrder";
DataTable table = General.GetTable(command);
ListLong = new Provider[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
ListLong[i] = new Provider();
ListLong[i].ProvNum = PIn.PInt(table.Rows[i][0].ToString());
ListLong[i].Abbr = PIn.PString(table.Rows[i][1].ToString());
ListLong[i].ItemOrder = PIn.PInt(table.Rows[i][2].ToString());
ListLong[i].LName = PIn.PString(table.Rows[i][3].ToString());
ListLong[i].FName = PIn.PString(table.Rows[i][4].ToString());
ListLong[i].MI = PIn.PString(table.Rows[i][5].ToString());
ListLong[i].Suffix = PIn.PString(table.Rows[i][6].ToString());
ListLong[i].FeeSched = PIn.PInt(table.Rows[i][7].ToString());
ListLong[i].Specialty = (DentalSpecialty)PIn.PInt(table.Rows[i][8].ToString());
ListLong[i].SSN = PIn.PString(table.Rows[i][9].ToString());
ListLong[i].StateLicense = PIn.PString(table.Rows[i][10].ToString());
ListLong[i].DEANum = PIn.PString(table.Rows[i][11].ToString());
ListLong[i].IsSecondary = PIn.PBool(table.Rows[i][12].ToString());
ListLong[i].ProvColor = Color.FromArgb(PIn.PInt(table.Rows[i][13].ToString()));
ListLong[i].IsHidden = PIn.PBool(table.Rows[i][14].ToString());
ListLong[i].UsingTIN = PIn.PBool(table.Rows[i][15].ToString());
//ListLong[i].BlueCrossID = PIn.PString(table.Rows[i][16].ToString());
ListLong[i].SigOnFile = PIn.PBool(table.Rows[i][17].ToString());
ListLong[i].MedicaidID = PIn.PString(table.Rows[i][18].ToString());
ListLong[i].OutlineColor = Color.FromArgb(PIn.PInt(table.Rows[i][19].ToString()));
ListLong[i].SchoolClassNum = PIn.PInt(table.Rows[i][20].ToString());
ListLong[i].NationalProvID = PIn.PString(table.Rows[i][21].ToString());
ListLong[i].CanadianOfficeNum = PIn.PString(table.Rows[i][22].ToString());
if (!ListLong[i].IsHidden)
{
AL.Add(ListLong[i]);
}
}
List = new Provider[AL.Count];
AL.CopyTo(List);
}
///<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 = General.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>For one patient</summary>
public static RefAttach[] Refresh(int patNum)
{
string command =
"SELECT * FROM refattach"
+ " WHERE patnum = " + patNum.ToString()
+ " ORDER BY itemorder";
DataTable table = General.GetTable(command);
RefAttach[] List = new RefAttach[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
List[i] = new RefAttach();
List[i].RefAttachNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].ReferralNum = PIn.PInt(table.Rows[i][1].ToString());
List[i].PatNum = PIn.PInt(table.Rows[i][2].ToString());
List[i].ItemOrder = PIn.PInt(table.Rows[i][3].ToString());
List[i].RefDate = PIn.PDate(table.Rows[i][4].ToString());
List[i].IsFrom = PIn.PBool(table.Rows[i][5].ToString());
}
return(List);
}
