///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Supply> TableToList(DataTable table)
{
List <Supply> retVal = new List <Supply>();
Supply supply;
foreach (DataRow row in table.Rows)
{
supply = new Supply();
supply.SupplyNum = PIn.Long(row["SupplyNum"].ToString());
supply.SupplierNum = PIn.Long(row["SupplierNum"].ToString());
supply.CatalogNumber = PIn.String(row["CatalogNumber"].ToString());
supply.Descript = PIn.String(row["Descript"].ToString());
supply.Category = PIn.Long(row["Category"].ToString());
supply.ItemOrder = PIn.Int(row["ItemOrder"].ToString());
supply.LevelDesired = PIn.Float(row["LevelDesired"].ToString());
supply.IsHidden = PIn.Bool(row["IsHidden"].ToString());
supply.Price = PIn.Double(row["Price"].ToString());
supply.BarCodeOrID = PIn.String(row["BarCodeOrID"].ToString());
supply.DispDefaultQuant = PIn.Float(row["DispDefaultQuant"].ToString());
supply.DispUnitsCount = PIn.Int(row["DispUnitsCount"].ToString());
supply.DispUnitDesc = PIn.String(row["DispUnitDesc"].ToString());
supply.LevelOnHand = PIn.Float(row["LevelOnHand"].ToString());
retVal.Add(supply);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <VaccinePat> TableToList(DataTable table)
{
List <VaccinePat> retVal = new List <VaccinePat>();
VaccinePat vaccinePat;
foreach (DataRow row in table.Rows)
{
vaccinePat = new VaccinePat();
vaccinePat.VaccinePatNum = PIn.Long(row["VaccinePatNum"].ToString());
vaccinePat.VaccineDefNum = PIn.Long(row["VaccineDefNum"].ToString());
vaccinePat.DateTimeStart = PIn.DateT(row["DateTimeStart"].ToString());
vaccinePat.DateTimeEnd = PIn.DateT(row["DateTimeEnd"].ToString());
vaccinePat.AdministeredAmt = PIn.Float(row["AdministeredAmt"].ToString());
vaccinePat.DrugUnitNum = PIn.Long(row["DrugUnitNum"].ToString());
vaccinePat.LotNumber = PIn.String(row["LotNumber"].ToString());
vaccinePat.PatNum = PIn.Long(row["PatNum"].ToString());
vaccinePat.Note = PIn.String(row["Note"].ToString());
vaccinePat.FilledCity = PIn.String(row["FilledCity"].ToString());
vaccinePat.FilledST = PIn.String(row["FilledST"].ToString());
vaccinePat.CompletionStatus = (OpenDentBusiness.VaccineCompletionStatus)PIn.Int(row["CompletionStatus"].ToString());
vaccinePat.AdministrationNoteCode = (OpenDentBusiness.VaccineAdministrationNote)PIn.Int(row["AdministrationNoteCode"].ToString());
vaccinePat.UserNum = PIn.Long(row["UserNum"].ToString());
vaccinePat.ProvNumOrdering = PIn.Long(row["ProvNumOrdering"].ToString());
vaccinePat.ProvNumAdminister = PIn.Long(row["ProvNumAdminister"].ToString());
vaccinePat.DateExpire = PIn.Date(row["DateExpire"].ToString());
vaccinePat.RefusalReason = (OpenDentBusiness.VaccineRefusalReason)PIn.Int(row["RefusalReason"].ToString());
vaccinePat.ActionCode = (OpenDentBusiness.VaccineAction)PIn.Int(row["ActionCode"].ToString());
vaccinePat.AdministrationRoute = (OpenDentBusiness.VaccineAdministrationRoute)PIn.Int(row["AdministrationRoute"].ToString());
vaccinePat.AdministrationSite = (OpenDentBusiness.VaccineAdministrationSite)PIn.Int(row["AdministrationSite"].ToString());
retVal.Add(vaccinePat);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <SmsBilling> TableToList(DataTable table)
{
List <SmsBilling> retVal = new List <SmsBilling>();
SmsBilling smsBilling;
foreach (DataRow row in table.Rows)
{
smsBilling = new SmsBilling();
smsBilling.SmsBillingNum = PIn.Long(row["SmsBillingNum"].ToString());
smsBilling.RegistrationKeyNum = PIn.Long(row["RegistrationKeyNum"].ToString());
smsBilling.CustPatNum = PIn.Long(row["CustPatNum"].ToString());
smsBilling.DateUsage = PIn.Date(row["DateUsage"].ToString());
smsBilling.MsgChargeTotalUSD = PIn.Float(row["MsgChargeTotalUSD"].ToString());
smsBilling.AccessChargeTotalUSD = PIn.Float(row["AccessChargeTotalUSD"].ToString());
smsBilling.ClinicsTotalCount = PIn.Int(row["ClinicsTotalCount"].ToString());
smsBilling.ClinicsActiveCount = PIn.Int(row["ClinicsActiveCount"].ToString());
smsBilling.ClinicsUsedCount = PIn.Int(row["ClinicsUsedCount"].ToString());
smsBilling.PhonesTotalCount = PIn.Int(row["PhonesTotalCount"].ToString());
smsBilling.PhonesActiveCount = PIn.Int(row["PhonesActiveCount"].ToString());
smsBilling.PhonesUsedCount = PIn.Int(row["PhonesUsedCount"].ToString());
smsBilling.MsgSentOkCount = PIn.Int(row["MsgSentOkCount"].ToString());
smsBilling.MsgRcvOkCount = PIn.Int(row["MsgRcvOkCount"].ToString());
smsBilling.MsgSentFailCount = PIn.Int(row["MsgSentFailCount"].ToString());
smsBilling.MsgRcvFailCount = PIn.Int(row["MsgRcvFailCount"].ToString());
smsBilling.ConfirmationClinics = PIn.Int(row["ConfirmationClinics"].ToString());
smsBilling.ConfirmationsTotal = PIn.Int(row["ConfirmationsTotal"].ToString());
smsBilling.ConfirmationsEmail = PIn.Int(row["ConfirmationsEmail"].ToString());
smsBilling.ConfirmationsSms = PIn.Int(row["ConfirmationsSms"].ToString());
smsBilling.ConfirmationChargeTotalUSD = PIn.Float(row["ConfirmationChargeTotalUSD"].ToString());
smsBilling.BillingDescSms = PIn.String(row["BillingDescSms"].ToString());
smsBilling.BillingDescConfirmation = PIn.String(row["BillingDescConfirmation"].ToString());
retVal.Add(smsBilling);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Vitalsign> TableToList(DataTable table)
{
List <Vitalsign> retVal = new List <Vitalsign>();
Vitalsign vitalsign;
for (int i = 0; i < table.Rows.Count; i++)
{
vitalsign = new Vitalsign();
vitalsign.VitalsignNum = PIn.Long(table.Rows[i]["VitalsignNum"].ToString());
vitalsign.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
vitalsign.Height = PIn.Float(table.Rows[i]["Height"].ToString());
vitalsign.Weight = PIn.Float(table.Rows[i]["Weight"].ToString());
vitalsign.BpSystolic = PIn.Int(table.Rows[i]["BpSystolic"].ToString());
vitalsign.BpDiastolic = PIn.Int(table.Rows[i]["BpDiastolic"].ToString());
vitalsign.DateTaken = PIn.Date(table.Rows[i]["DateTaken"].ToString());
vitalsign.HasFollowupPlan = PIn.Bool(table.Rows[i]["HasFollowupPlan"].ToString());
vitalsign.IsIneligible = PIn.Bool(table.Rows[i]["IsIneligible"].ToString());
vitalsign.Documentation = PIn.String(table.Rows[i]["Documentation"].ToString());
vitalsign.ChildGotNutrition = PIn.Bool(table.Rows[i]["ChildGotNutrition"].ToString());
vitalsign.ChildGotPhysCouns = PIn.Bool(table.Rows[i]["ChildGotPhysCouns"].ToString());
vitalsign.WeightCode = PIn.String(table.Rows[i]["WeightCode"].ToString());
vitalsign.HeightExamCode = PIn.String(table.Rows[i]["HeightExamCode"].ToString());
vitalsign.WeightExamCode = PIn.String(table.Rows[i]["WeightExamCode"].ToString());
vitalsign.BMIExamCode = PIn.String(table.Rows[i]["BMIExamCode"].ToString());
vitalsign.EhrNotPerformedNum = PIn.Long(table.Rows[i]["EhrNotPerformedNum"].ToString());
vitalsign.PregDiseaseNum = PIn.Long(table.Rows[i]["PregDiseaseNum"].ToString());
vitalsign.BMIPercentile = PIn.Int(table.Rows[i]["BMIPercentile"].ToString());
retVal.Add(vitalsign);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <SheetDef> TableToList(DataTable table)
{
List <SheetDef> retVal = new List <SheetDef>();
SheetDef sheetDef;
foreach (DataRow row in table.Rows)
{
sheetDef = new SheetDef();
sheetDef.SheetDefNum = PIn.Long(row["SheetDefNum"].ToString());
sheetDef.Description = PIn.String(row["Description"].ToString());
sheetDef.SheetType = (OpenDentBusiness.SheetTypeEnum)PIn.Int(row["SheetType"].ToString());
sheetDef.FontSize = PIn.Float(row["FontSize"].ToString());
sheetDef.FontName = PIn.String(row["FontName"].ToString());
sheetDef.Width = PIn.Int(row["Width"].ToString());
sheetDef.Height = PIn.Int(row["Height"].ToString());
sheetDef.IsLandscape = PIn.Bool(row["IsLandscape"].ToString());
sheetDef.PageCount = PIn.Int(row["PageCount"].ToString());
sheetDef.IsMultiPage = PIn.Bool(row["IsMultiPage"].ToString());
sheetDef.BypassGlobalLock = (OpenDentBusiness.BypassLockStatus)PIn.Int(row["BypassGlobalLock"].ToString());
sheetDef.HasMobileLayout = PIn.Bool(row["HasMobileLayout"].ToString());
sheetDef.DateTCreated = PIn.DateT(row["DateTCreated"].ToString());
retVal.Add(sheetDef);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Sheet> TableToList(DataTable table)
{
List <Sheet> retVal = new List <Sheet>();
Sheet sheet;
foreach (DataRow row in table.Rows)
{
sheet = new Sheet();
sheet.SheetNum = PIn.Long(row["SheetNum"].ToString());
sheet.SheetType = (OpenDentBusiness.SheetTypeEnum)PIn.Int(row["SheetType"].ToString());
sheet.PatNum = PIn.Long(row["PatNum"].ToString());
sheet.DateTimeSheet = PIn.DateT(row["DateTimeSheet"].ToString());
sheet.FontSize = PIn.Float(row["FontSize"].ToString());
sheet.FontName = PIn.String(row["FontName"].ToString());
sheet.Width = PIn.Int(row["Width"].ToString());
sheet.Height = PIn.Int(row["Height"].ToString());
sheet.IsLandscape = PIn.Bool(row["IsLandscape"].ToString());
sheet.InternalNote = PIn.String(row["InternalNote"].ToString());
sheet.Description = PIn.String(row["Description"].ToString());
sheet.ShowInTerminal = PIn.Byte(row["ShowInTerminal"].ToString());
sheet.IsWebForm = PIn.Bool(row["IsWebForm"].ToString());
sheet.IsMultiPage = PIn.Bool(row["IsMultiPage"].ToString());
sheet.IsDeleted = PIn.Bool(row["IsDeleted"].ToString());
sheet.SheetDefNum = PIn.Long(row["SheetDefNum"].ToString());
sheet.DocNum = PIn.Long(row["DocNum"].ToString());
sheet.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
retVal.Add(sheet);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <WebForms_Sheet> TableToList(DataTable table)
{
List <WebForms_Sheet> retVal = new List <WebForms_Sheet>();
WebForms_Sheet webForms_Sheet;
for (int i = 0; i < table.Rows.Count; i++)
{
webForms_Sheet = new WebForms_Sheet();
webForms_Sheet.SheetID = PIn.Long(table.Rows[i]["SheetID"].ToString());
webForms_Sheet.DentalOfficeID = PIn.Long(table.Rows[i]["DentalOfficeID"].ToString());
webForms_Sheet.Description = PIn.String(table.Rows[i]["Description"].ToString());
webForms_Sheet.SheetType = (OpenDentBusiness.SheetFieldType)PIn.Int(table.Rows[i]["SheetType"].ToString());
webForms_Sheet.DateTimeSheet = PIn.DateT(table.Rows[i]["DateTimeSheet"].ToString());
webForms_Sheet.FontSize = PIn.Float(table.Rows[i]["FontSize"].ToString());
webForms_Sheet.FontName = PIn.String(table.Rows[i]["FontName"].ToString());
webForms_Sheet.Width = PIn.Int(table.Rows[i]["Width"].ToString());
webForms_Sheet.Height = PIn.Int(table.Rows[i]["Height"].ToString());
webForms_Sheet.IsLandscape = PIn.Bool(table.Rows[i]["IsLandscape"].ToString());
webForms_Sheet.ClinicNum = PIn.Long(table.Rows[i]["ClinicNum"].ToString());
webForms_Sheet.HasMobileLayout = PIn.Bool(table.Rows[i]["HasMobileLayout"].ToString());
webForms_Sheet.SheetDefNum = PIn.Long(table.Rows[i]["SheetDefNum"].ToString());
retVal.Add(webForms_Sheet);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <WebForms_SheetField> TableToList(DataTable table)
{
List <WebForms_SheetField> retVal = new List <WebForms_SheetField>();
WebForms_SheetField webForms_SheetField;
for (int i = 0; i < table.Rows.Count; i++)
{
webForms_SheetField = new WebForms_SheetField();
webForms_SheetField.SheetFieldID = PIn.Long(table.Rows[i]["SheetFieldID"].ToString());
webForms_SheetField.SheetID = PIn.Long(table.Rows[i]["SheetID"].ToString());
webForms_SheetField.FieldType = (OpenDentBusiness.SheetFieldType)PIn.Int(table.Rows[i]["FieldType"].ToString());
webForms_SheetField.FieldName = PIn.String(table.Rows[i]["FieldName"].ToString());
webForms_SheetField.FieldValue = PIn.String(table.Rows[i]["FieldValue"].ToString());
webForms_SheetField.FontSize = PIn.Float(table.Rows[i]["FontSize"].ToString());
webForms_SheetField.FontName = PIn.String(table.Rows[i]["FontName"].ToString());
webForms_SheetField.FontIsBold = PIn.Bool(table.Rows[i]["FontIsBold"].ToString());
webForms_SheetField.XPos = PIn.Int(table.Rows[i]["XPos"].ToString());
webForms_SheetField.YPos = PIn.Int(table.Rows[i]["YPos"].ToString());
webForms_SheetField.Width = PIn.Int(table.Rows[i]["Width"].ToString());
webForms_SheetField.Height = PIn.Int(table.Rows[i]["Height"].ToString());
webForms_SheetField.GrowthBehavior = (OpenDentBusiness.GrowthBehaviorEnum)PIn.Int(table.Rows[i]["GrowthBehavior"].ToString());
webForms_SheetField.RadioButtonValue = PIn.String(table.Rows[i]["RadioButtonValue"].ToString());
webForms_SheetField.RadioButtonGroup = PIn.String(table.Rows[i]["RadioButtonGroup"].ToString());
webForms_SheetField.IsRequired = PIn.Bool(table.Rows[i]["IsRequired"].ToString());
webForms_SheetField.TabOrder = PIn.Int(table.Rows[i]["TabOrder"].ToString());
webForms_SheetField.ReportableName = PIn.String(table.Rows[i]["ReportableName"].ToString());
webForms_SheetField.TextAlign = (System.Windows.Forms.HorizontalAlignment)PIn.Int(table.Rows[i]["TextAlign"].ToString());
webForms_SheetField.ItemColor = Color.FromArgb(PIn.Int(table.Rows[i]["ItemColor"].ToString()));
webForms_SheetField.TabOrderMobile = PIn.Int(table.Rows[i]["TabOrderMobile"].ToString());
webForms_SheetField.UiLabelMobile = PIn.String(table.Rows[i]["UiLabelMobile"].ToString());
webForms_SheetField.UiLabelMobileRadioButton = PIn.String(table.Rows[i]["UiLabelMobileRadioButton"].ToString());
retVal.Add(webForms_SheetField);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <SmsToMobile> TableToList(DataTable table)
{
List <SmsToMobile> retVal = new List <SmsToMobile>();
SmsToMobile smsToMobile;
foreach (DataRow row in table.Rows)
{
smsToMobile = new SmsToMobile();
smsToMobile.SmsToMobileNum = PIn.Long(row["SmsToMobileNum"].ToString());
smsToMobile.PatNum = PIn.Long(row["PatNum"].ToString());
smsToMobile.GuidMessage = PIn.String(row["GuidMessage"].ToString());
smsToMobile.GuidBatch = PIn.String(row["GuidBatch"].ToString());
smsToMobile.SmsPhoneNumber = PIn.String(row["SmsPhoneNumber"].ToString());
smsToMobile.MobilePhoneNumber = PIn.String(row["MobilePhoneNumber"].ToString());
smsToMobile.IsTimeSensitive = PIn.Bool(row["IsTimeSensitive"].ToString());
smsToMobile.MsgType = (OpenDentBusiness.SmsMessageSource)PIn.Int(row["MsgType"].ToString());
smsToMobile.MsgText = PIn.String(row["MsgText"].ToString());
smsToMobile.SmsStatus = (OpenDentBusiness.SmsDeliveryStatus)PIn.Int(row["SmsStatus"].ToString());
smsToMobile.MsgParts = PIn.Int(row["MsgParts"].ToString());
smsToMobile.MsgChargeUSD = PIn.Float(row["MsgChargeUSD"].ToString());
smsToMobile.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
smsToMobile.CustErrorText = PIn.String(row["CustErrorText"].ToString());
smsToMobile.DateTimeSent = PIn.DateT(row["DateTimeSent"].ToString());
smsToMobile.DateTimeTerminated = PIn.DateT(row["DateTimeTerminated"].ToString());
smsToMobile.IsHidden = PIn.Bool(row["IsHidden"].ToString());
retVal.Add(smsToMobile);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <SheetFieldDef> TableToList(DataTable table)
{
List <SheetFieldDef> retVal = new List <SheetFieldDef>();
SheetFieldDef sheetFieldDef;
foreach (DataRow row in table.Rows)
{
sheetFieldDef = new SheetFieldDef();
sheetFieldDef.SheetFieldDefNum = PIn.Long(row["SheetFieldDefNum"].ToString());
sheetFieldDef.SheetDefNum = PIn.Long(row["SheetDefNum"].ToString());
sheetFieldDef.FieldType = (OpenDentBusiness.SheetFieldType)PIn.Int(row["FieldType"].ToString());
sheetFieldDef.FieldName = PIn.String(row["FieldName"].ToString());
sheetFieldDef.FieldValue = PIn.String(row["FieldValue"].ToString());
sheetFieldDef.FontSize = PIn.Float(row["FontSize"].ToString());
sheetFieldDef.FontName = PIn.String(row["FontName"].ToString());
sheetFieldDef.FontIsBold = PIn.Bool(row["FontIsBold"].ToString());
sheetFieldDef.XPos = PIn.Int(row["XPos"].ToString());
sheetFieldDef.YPos = PIn.Int(row["YPos"].ToString());
sheetFieldDef.Width = PIn.Int(row["Width"].ToString());
sheetFieldDef.Height = PIn.Int(row["Height"].ToString());
sheetFieldDef.GrowthBehavior = (OpenDentBusiness.GrowthBehaviorEnum)PIn.Int(row["GrowthBehavior"].ToString());
sheetFieldDef.RadioButtonValue = PIn.String(row["RadioButtonValue"].ToString());
sheetFieldDef.RadioButtonGroup = PIn.String(row["RadioButtonGroup"].ToString());
sheetFieldDef.IsRequired = PIn.Bool(row["IsRequired"].ToString());
sheetFieldDef.TabOrder = PIn.Int(row["TabOrder"].ToString());
sheetFieldDef.ReportableName = PIn.String(row["ReportableName"].ToString());
sheetFieldDef.TextAlign = (System.Windows.Forms.HorizontalAlignment)PIn.Int(row["TextAlign"].ToString());
sheetFieldDef.IsPaymentOption = PIn.Bool(row["IsPaymentOption"].ToString());
sheetFieldDef.IsLocked = PIn.Bool(row["IsLocked"].ToString());
sheetFieldDef.ItemColor = Color.FromArgb(PIn.Int(row["ItemColor"].ToString()));
retVal.Add(sheetFieldDef);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <SheetField> TableToList(DataTable table)
{
List <SheetField> retVal = new List <SheetField>();
SheetField sheetField;
for (int i = 0; i < table.Rows.Count; i++)
{
sheetField = new SheetField();
sheetField.SheetFieldNum = PIn.Long(table.Rows[i]["SheetFieldNum"].ToString());
sheetField.SheetNum = PIn.Long(table.Rows[i]["SheetNum"].ToString());
sheetField.FieldType = (SheetFieldType)PIn.Int(table.Rows[i]["FieldType"].ToString());
sheetField.FieldName = PIn.String(table.Rows[i]["FieldName"].ToString());
sheetField.FieldValue = PIn.String(table.Rows[i]["FieldValue"].ToString());
sheetField.FontSize = PIn.Float(table.Rows[i]["FontSize"].ToString());
sheetField.FontName = PIn.String(table.Rows[i]["FontName"].ToString());
sheetField.FontIsBold = PIn.Bool(table.Rows[i]["FontIsBold"].ToString());
sheetField.XPos = PIn.Int(table.Rows[i]["XPos"].ToString());
sheetField.YPos = PIn.Int(table.Rows[i]["YPos"].ToString());
sheetField.Width = PIn.Int(table.Rows[i]["Width"].ToString());
sheetField.Height = PIn.Int(table.Rows[i]["Height"].ToString());
sheetField.GrowthBehavior = (GrowthBehaviorEnum)PIn.Int(table.Rows[i]["GrowthBehavior"].ToString());
sheetField.RadioButtonValue = PIn.String(table.Rows[i]["RadioButtonValue"].ToString());
sheetField.RadioButtonGroup = PIn.String(table.Rows[i]["RadioButtonGroup"].ToString());
sheetField.IsRequired = PIn.Bool(table.Rows[i]["IsRequired"].ToString());
sheetField.TabOrder = PIn.Int(table.Rows[i]["TabOrder"].ToString());
retVal.Add(sheetField);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <Sheet> TableToList(DataTable table)
{
List <Sheet> retVal = new List <Sheet>();
Sheet sheet;
for (int i = 0; i < table.Rows.Count; i++)
{
sheet = new Sheet();
sheet.SheetNum = PIn.Long(table.Rows[i]["SheetNum"].ToString());
sheet.SheetType = (SheetTypeEnum)PIn.Int(table.Rows[i]["SheetType"].ToString());
sheet.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
sheet.DateTimeSheet = PIn.DateT(table.Rows[i]["DateTimeSheet"].ToString());
sheet.FontSize = PIn.Float(table.Rows[i]["FontSize"].ToString());
sheet.FontName = PIn.String(table.Rows[i]["FontName"].ToString());
sheet.Width = PIn.Int(table.Rows[i]["Width"].ToString());
sheet.Height = PIn.Int(table.Rows[i]["Height"].ToString());
sheet.IsLandscape = PIn.Bool(table.Rows[i]["IsLandscape"].ToString());
sheet.InternalNote = PIn.String(table.Rows[i]["InternalNote"].ToString());
sheet.Description = PIn.String(table.Rows[i]["Description"].ToString());
sheet.ShowInTerminal = PIn.Byte(table.Rows[i]["ShowInTerminal"].ToString());
sheet.IsWebForm = PIn.Bool(table.Rows[i]["IsWebForm"].ToString());
retVal.Add(sheet);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <Procedure> TableToList(DataTable table)
{
List <Procedure> retVal = new List <Procedure>();
Procedure procedure;
for (int i = 0; i < table.Rows.Count; i++)
{
procedure = new Procedure();
procedure.ProcNum = PIn.Long(table.Rows[i]["ProcNum"].ToString());
procedure.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
procedure.AptNum = PIn.Long(table.Rows[i]["AptNum"].ToString());
procedure.OldCode = PIn.String(table.Rows[i]["OldCode"].ToString());
procedure.ProcDate = PIn.Date(table.Rows[i]["ProcDate"].ToString());
procedure.ProcFee = PIn.Double(table.Rows[i]["ProcFee"].ToString());
procedure.Surf = PIn.String(table.Rows[i]["Surf"].ToString());
procedure.ToothNum = PIn.String(table.Rows[i]["ToothNum"].ToString());
procedure.ToothRange = PIn.String(table.Rows[i]["ToothRange"].ToString());
procedure.Priority = PIn.Long(table.Rows[i]["Priority"].ToString());
procedure.ProcStatus = (ProcStat)PIn.Int(table.Rows[i]["ProcStatus"].ToString());
procedure.ProvNum = PIn.Long(table.Rows[i]["ProvNum"].ToString());
procedure.Dx = PIn.Long(table.Rows[i]["Dx"].ToString());
procedure.PlannedAptNum = PIn.Long(table.Rows[i]["PlannedAptNum"].ToString());
procedure.PlaceService = (PlaceOfService)PIn.Int(table.Rows[i]["PlaceService"].ToString());
procedure.Prosthesis = PIn.String(table.Rows[i]["Prosthesis"].ToString());
procedure.DateOriginalProsth = PIn.Date(table.Rows[i]["DateOriginalProsth"].ToString());
procedure.ClaimNote = PIn.String(table.Rows[i]["ClaimNote"].ToString());
procedure.DateEntryC = PIn.Date(table.Rows[i]["DateEntryC"].ToString());
procedure.ClinicNum = PIn.Long(table.Rows[i]["ClinicNum"].ToString());
procedure.MedicalCode = PIn.String(table.Rows[i]["MedicalCode"].ToString());
procedure.DiagnosticCode = PIn.String(table.Rows[i]["DiagnosticCode"].ToString());
procedure.IsPrincDiag = PIn.Bool(table.Rows[i]["IsPrincDiag"].ToString());
procedure.ProcNumLab = PIn.Long(table.Rows[i]["ProcNumLab"].ToString());
procedure.BillingTypeOne = PIn.Long(table.Rows[i]["BillingTypeOne"].ToString());
procedure.BillingTypeTwo = PIn.Long(table.Rows[i]["BillingTypeTwo"].ToString());
procedure.CodeNum = PIn.Long(table.Rows[i]["CodeNum"].ToString());
procedure.CodeMod1 = PIn.String(table.Rows[i]["CodeMod1"].ToString());
procedure.CodeMod2 = PIn.String(table.Rows[i]["CodeMod2"].ToString());
procedure.CodeMod3 = PIn.String(table.Rows[i]["CodeMod3"].ToString());
procedure.CodeMod4 = PIn.String(table.Rows[i]["CodeMod4"].ToString());
procedure.RevCode = PIn.String(table.Rows[i]["RevCode"].ToString());
procedure.UnitQty = PIn.Int(table.Rows[i]["UnitQty"].ToString());
procedure.BaseUnits = PIn.Int(table.Rows[i]["BaseUnits"].ToString());
procedure.StartTime = PIn.Int(table.Rows[i]["StartTime"].ToString());
procedure.StopTime = PIn.Int(table.Rows[i]["StopTime"].ToString());
procedure.DateTP = PIn.Date(table.Rows[i]["DateTP"].ToString());
procedure.SiteNum = PIn.Long(table.Rows[i]["SiteNum"].ToString());
procedure.HideGraphics = PIn.Bool(table.Rows[i]["HideGraphics"].ToString());
procedure.CanadianTypeCodes = PIn.String(table.Rows[i]["CanadianTypeCodes"].ToString());
procedure.ProcTime = PIn.Time(table.Rows[i]["ProcTime"].ToString());
procedure.ProcTimeEnd = PIn.Time(table.Rows[i]["ProcTimeEnd"].ToString());
procedure.DateTStamp = PIn.DateT(table.Rows[i]["DateTStamp"].ToString());
procedure.Prognosis = PIn.Long(table.Rows[i]["Prognosis"].ToString());
procedure.DrugUnit = (EnumProcDrugUnit)PIn.Int(table.Rows[i]["DrugUnit"].ToString());
procedure.DrugQty = PIn.Float(table.Rows[i]["DrugQty"].ToString());
retVal.Add(procedure);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <GradingScaleItem> TableToList(DataTable table)
{
List <GradingScaleItem> retVal = new List <GradingScaleItem>();
GradingScaleItem gradingScaleItem;
foreach (DataRow row in table.Rows)
{
gradingScaleItem = new GradingScaleItem();
gradingScaleItem.GradingScaleItemNum = PIn.Long(row["GradingScaleItemNum"].ToString());
gradingScaleItem.GradingScaleNum = PIn.Long(row["GradingScaleNum"].ToString());
gradingScaleItem.GradeShowing = PIn.String(row["GradeShowing"].ToString());
gradingScaleItem.GradeNumber = PIn.Float(row["GradeNumber"].ToString());
gradingScaleItem.Description = PIn.String(row["Description"].ToString());
retVal.Add(gradingScaleItem);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <DispSupply> TableToList(DataTable table)
{
List <DispSupply> retVal = new List <DispSupply>();
DispSupply dispSupply;
foreach (DataRow row in table.Rows)
{
dispSupply = new DispSupply();
dispSupply.DispSupplyNum = PIn.Long(row["DispSupplyNum"].ToString());
dispSupply.SupplyNum = PIn.Long(row["SupplyNum"].ToString());
dispSupply.ProvNum = PIn.Long(row["ProvNum"].ToString());
dispSupply.DateDispensed = PIn.Date(row["DateDispensed"].ToString());
dispSupply.DispQuantity = PIn.Float(row["DispQuantity"].ToString());
dispSupply.Note = PIn.String(row["Note"].ToString());
retVal.Add(dispSupply);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <InstallmentPlan> TableToList(DataTable table)
{
List <InstallmentPlan> retVal = new List <InstallmentPlan>();
InstallmentPlan installmentPlan;
foreach (DataRow row in table.Rows)
{
installmentPlan = new InstallmentPlan();
installmentPlan.InstallmentPlanNum = PIn.Long(row["InstallmentPlanNum"].ToString());
installmentPlan.PatNum = PIn.Long(row["PatNum"].ToString());
installmentPlan.DateAgreement = PIn.Date(row["DateAgreement"].ToString());
installmentPlan.DateFirstPayment = PIn.Date(row["DateFirstPayment"].ToString());
installmentPlan.MonthlyPayment = PIn.Double(row["MonthlyPayment"].ToString());
installmentPlan.APR = PIn.Float(row["APR"].ToString());
installmentPlan.Note = PIn.String(row["Note"].ToString());
retVal.Add(installmentPlan);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <ToothInitial> TableToList(DataTable table)
{
List <ToothInitial> retVal = new List <ToothInitial>();
ToothInitial toothInitial;
foreach (DataRow row in table.Rows)
{
toothInitial = new ToothInitial();
toothInitial.ToothInitialNum = PIn.Long(row["ToothInitialNum"].ToString());
toothInitial.PatNum = PIn.Long(row["PatNum"].ToString());
toothInitial.ToothNum = PIn.String(row["ToothNum"].ToString());
toothInitial.InitialType = (OpenDentBusiness.ToothInitialType)PIn.Int(row["InitialType"].ToString());
toothInitial.Movement = PIn.Float(row["Movement"].ToString());
toothInitial.DrawingSegment = PIn.String(row["DrawingSegment"].ToString());
toothInitial.ColorDraw = Color.FromArgb(PIn.Int(row["ColorDraw"].ToString()));
retVal.Add(toothInitial);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <ToothInitial> TableToList(DataTable table)
{
List <ToothInitial> retVal = new List <ToothInitial>();
ToothInitial toothInitial;
for (int i = 0; i < table.Rows.Count; i++)
{
toothInitial = new ToothInitial();
toothInitial.ToothInitialNum = PIn.Long(table.Rows[i]["ToothInitialNum"].ToString());
toothInitial.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
toothInitial.ToothNum = PIn.String(table.Rows[i]["ToothNum"].ToString());
toothInitial.InitialType = (ToothInitialType)PIn.Int(table.Rows[i]["InitialType"].ToString());
toothInitial.Movement = PIn.Float(table.Rows[i]["Movement"].ToString());
toothInitial.DrawingSegment = PIn.String(table.Rows[i]["DrawingSegment"].ToString());
toothInitial.ColorDraw = Color.FromArgb(PIn.Int(table.Rows[i]["ColorDraw"].ToString()));
retVal.Add(toothInitial);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <EvaluationCriterionDef> TableToList(DataTable table)
{
List <EvaluationCriterionDef> retVal = new List <EvaluationCriterionDef>();
EvaluationCriterionDef evaluationCriterionDef;
foreach (DataRow row in table.Rows)
{
evaluationCriterionDef = new EvaluationCriterionDef();
evaluationCriterionDef.EvaluationCriterionDefNum = PIn.Long(row["EvaluationCriterionDefNum"].ToString());
evaluationCriterionDef.EvaluationDefNum = PIn.Long(row["EvaluationDefNum"].ToString());
evaluationCriterionDef.CriterionDescript = PIn.String(row["CriterionDescript"].ToString());
evaluationCriterionDef.IsCategoryName = PIn.Bool(row["IsCategoryName"].ToString());
evaluationCriterionDef.GradingScaleNum = PIn.Long(row["GradingScaleNum"].ToString());
evaluationCriterionDef.ItemOrder = PIn.Int(row["ItemOrder"].ToString());
evaluationCriterionDef.MaxPointsPoss = PIn.Float(row["MaxPointsPoss"].ToString());
retVal.Add(evaluationCriterionDef);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <EhrProvKey> TableToList(DataTable table)
{
List <EhrProvKey> retVal = new List <EhrProvKey>();
EhrProvKey ehrProvKey;
for (int i = 0; i < table.Rows.Count; i++)
{
ehrProvKey = new EhrProvKey();
ehrProvKey.EhrProvKeyNum = PIn.Long(table.Rows[i]["EhrProvKeyNum"].ToString());
ehrProvKey.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
ehrProvKey.LName = PIn.String(table.Rows[i]["LName"].ToString());
ehrProvKey.FName = PIn.String(table.Rows[i]["FName"].ToString());
ehrProvKey.ProvKey = PIn.String(table.Rows[i]["ProvKey"].ToString());
ehrProvKey.FullTimeEquiv = PIn.Float(table.Rows[i]["FullTimeEquiv"].ToString());
ehrProvKey.Notes = PIn.String(table.Rows[i]["Notes"].ToString());
ehrProvKey.HasReportAccess = PIn.Bool(table.Rows[i]["HasReportAccess"].ToString());
retVal.Add(ehrProvKey);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <EhrProvKey> TableToList(DataTable table)
{
List <EhrProvKey> retVal = new List <EhrProvKey>();
EhrProvKey ehrProvKey;
foreach (DataRow row in table.Rows)
{
ehrProvKey = new EhrProvKey();
ehrProvKey.EhrProvKeyNum = PIn.Long(row["EhrProvKeyNum"].ToString());
ehrProvKey.PatNum = PIn.Long(row["PatNum"].ToString());
ehrProvKey.LName = PIn.String(row["LName"].ToString());
ehrProvKey.FName = PIn.String(row["FName"].ToString());
ehrProvKey.ProvKey = PIn.String(row["ProvKey"].ToString());
ehrProvKey.FullTimeEquiv = PIn.Float(row["FullTimeEquiv"].ToString());
ehrProvKey.Notes = PIn.String(row["Notes"].ToString());
ehrProvKey.YearValue = PIn.Int(row["YearValue"].ToString());
retVal.Add(ehrProvKey);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <SheetDef> TableToList(DataTable table)
{
List <SheetDef> retVal = new List <SheetDef>();
SheetDef sheetDef;
for (int i = 0; i < table.Rows.Count; i++)
{
sheetDef = new SheetDef();
sheetDef.SheetDefNum = PIn.Long(table.Rows[i]["SheetDefNum"].ToString());
sheetDef.Description = PIn.String(table.Rows[i]["Description"].ToString());
sheetDef.SheetType = (SheetTypeEnum)PIn.Int(table.Rows[i]["SheetType"].ToString());
sheetDef.FontSize = PIn.Float(table.Rows[i]["FontSize"].ToString());
sheetDef.FontName = PIn.String(table.Rows[i]["FontName"].ToString());
sheetDef.Width = PIn.Int(table.Rows[i]["Width"].ToString());
sheetDef.Height = PIn.Int(table.Rows[i]["Height"].ToString());
sheetDef.IsLandscape = PIn.Bool(table.Rows[i]["IsLandscape"].ToString());
retVal.Add(sheetDef);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Supply> TableToList(DataTable table)
{
List <Supply> retVal = new List <Supply>();
Supply supply;
for (int i = 0; i < table.Rows.Count; i++)
{
supply = new Supply();
supply.SupplyNum = PIn.Long(table.Rows[i]["SupplyNum"].ToString());
supply.SupplierNum = PIn.Long(table.Rows[i]["SupplierNum"].ToString());
supply.CatalogNumber = PIn.String(table.Rows[i]["CatalogNumber"].ToString());
supply.Descript = PIn.String(table.Rows[i]["Descript"].ToString());
supply.Category = PIn.Long(table.Rows[i]["Category"].ToString());
supply.ItemOrder = PIn.Int(table.Rows[i]["ItemOrder"].ToString());
supply.LevelDesired = PIn.Float(table.Rows[i]["LevelDesired"].ToString());
supply.IsHidden = PIn.Bool(table.Rows[i]["IsHidden"].ToString());
supply.Price = PIn.Double(table.Rows[i]["Price"].ToString());
retVal.Add(supply);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <ClaimForm> TableToList(DataTable table)
{
List <ClaimForm> retVal = new List <ClaimForm>();
ClaimForm claimForm;
for (int i = 0; i < table.Rows.Count; i++)
{
claimForm = new ClaimForm();
claimForm.ClaimFormNum = PIn.Long(table.Rows[i]["ClaimFormNum"].ToString());
claimForm.Description = PIn.String(table.Rows[i]["Description"].ToString());
claimForm.IsHidden = PIn.Bool(table.Rows[i]["IsHidden"].ToString());
claimForm.FontName = PIn.String(table.Rows[i]["FontName"].ToString());
claimForm.FontSize = PIn.Float(table.Rows[i]["FontSize"].ToString());
claimForm.UniqueID = PIn.String(table.Rows[i]["UniqueID"].ToString());
claimForm.PrintImages = PIn.Bool(table.Rows[i]["PrintImages"].ToString());
claimForm.OffsetX = PIn.Int(table.Rows[i]["OffsetX"].ToString());
claimForm.OffsetY = PIn.Int(table.Rows[i]["OffsetY"].ToString());
retVal.Add(claimForm);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <ClaimFormItem> TableToList(DataTable table)
{
List <ClaimFormItem> retVal = new List <ClaimFormItem>();
ClaimFormItem claimFormItem;
for (int i = 0; i < table.Rows.Count; i++)
{
claimFormItem = new ClaimFormItem();
claimFormItem.ClaimFormItemNum = PIn.Long(table.Rows[i]["ClaimFormItemNum"].ToString());
claimFormItem.ClaimFormNum = PIn.Long(table.Rows[i]["ClaimFormNum"].ToString());
claimFormItem.ImageFileName = PIn.String(table.Rows[i]["ImageFileName"].ToString());
claimFormItem.FieldName = PIn.String(table.Rows[i]["FieldName"].ToString());
claimFormItem.FormatString = PIn.String(table.Rows[i]["FormatString"].ToString());
claimFormItem.XPos = PIn.Float(table.Rows[i]["XPos"].ToString());
claimFormItem.YPos = PIn.Float(table.Rows[i]["YPos"].ToString());
claimFormItem.Width = PIn.Float(table.Rows[i]["Width"].ToString());
claimFormItem.Height = PIn.Float(table.Rows[i]["Height"].ToString());
retVal.Add(claimFormItem);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Evaluation> TableToList(DataTable table)
{
List <Evaluation> retVal = new List <Evaluation>();
Evaluation evaluation;
foreach (DataRow row in table.Rows)
{
evaluation = new Evaluation();
evaluation.EvaluationNum = PIn.Long(row["EvaluationNum"].ToString());
evaluation.InstructNum = PIn.Long(row["InstructNum"].ToString());
evaluation.StudentNum = PIn.Long(row["StudentNum"].ToString());
evaluation.SchoolCourseNum = PIn.Long(row["SchoolCourseNum"].ToString());
evaluation.EvalTitle = PIn.String(row["EvalTitle"].ToString());
evaluation.DateEval = PIn.Date(row["DateEval"].ToString());
evaluation.GradingScaleNum = PIn.Long(row["GradingScaleNum"].ToString());
evaluation.OverallGradeShowing = PIn.String(row["OverallGradeShowing"].ToString());
evaluation.OverallGradeNumber = PIn.Float(row["OverallGradeNumber"].ToString());
evaluation.Notes = PIn.String(row["Notes"].ToString());
retVal.Add(evaluation);
}
return(retVal);
}
///<Summary>asOfDate is typically 12/31/... </Summary>
public static float NetIncomeThisYear(object asOfDateObj)
{
DateTime asOfDate;
if (asOfDateObj.GetType() == typeof(string))
{
asOfDate = PIn.Date(asOfDateObj.ToString());
}
else if (asOfDateObj.GetType() == typeof(DateTime))
{
asOfDate = (DateTime)asOfDateObj;
}
else
{
return(0);
}
DateTime firstOfYear = new DateTime(asOfDate.Year, 1, 1);
string command = "SELECT SUM(CreditAmt), SUM(DebitAmt), AcctType "
+ "FROM journalentry,account "
+ "WHERE journalentry.AccountNum=account.AccountNum "
+ "AND DateDisplayed >= " + POut.Date(firstOfYear)
+ " AND DateDisplayed <= " + POut.Date(asOfDate)
+ " GROUP BY AcctType";
DataConnection dcon = new DataConnection();
DataTable table = dcon.GetTable(command);
float retVal = 0;
for (int i = 0; i < table.Rows.Count; i++)
{
if (table.Rows[i][2].ToString() == "3" || //income
table.Rows[i][2].ToString() == "4") //expense
{
retVal += PIn.Float(table.Rows[i][0].ToString()); //add credit
retVal -= PIn.Float(table.Rows[i][1].ToString()); //subtract debit
//if it's an expense, we are subtracting (income-expense), but the signs cancel.
}
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <VaccinePat> TableToList(DataTable table)
{
List <VaccinePat> retVal = new List <VaccinePat>();
VaccinePat vaccinePat;
for (int i = 0; i < table.Rows.Count; i++)
{
vaccinePat = new VaccinePat();
vaccinePat.VaccinePatNum = PIn.Long(table.Rows[i]["VaccinePatNum"].ToString());
vaccinePat.VaccineDefNum = PIn.Long(table.Rows[i]["VaccineDefNum"].ToString());
vaccinePat.DateTimeStart = PIn.DateT(table.Rows[i]["DateTimeStart"].ToString());
vaccinePat.DateTimeEnd = PIn.DateT(table.Rows[i]["DateTimeEnd"].ToString());
vaccinePat.AdministeredAmt = PIn.Float(table.Rows[i]["AdministeredAmt"].ToString());
vaccinePat.DrugUnitNum = PIn.Long(table.Rows[i]["DrugUnitNum"].ToString());
vaccinePat.LotNumber = PIn.String(table.Rows[i]["LotNumber"].ToString());
vaccinePat.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
vaccinePat.NotGiven = PIn.Bool(table.Rows[i]["NotGiven"].ToString());
vaccinePat.Note = PIn.String(table.Rows[i]["Note"].ToString());
retVal.Add(vaccinePat);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <EvaluationCriterion> TableToList(DataTable table)
{
List <EvaluationCriterion> retVal = new List <EvaluationCriterion>();
EvaluationCriterion evaluationCriterion;
foreach (DataRow row in table.Rows)
{
evaluationCriterion = new EvaluationCriterion();
evaluationCriterion.EvaluationCriterionNum = PIn.Long(row["EvaluationCriterionNum"].ToString());
evaluationCriterion.EvaluationNum = PIn.Long(row["EvaluationNum"].ToString());
evaluationCriterion.CriterionDescript = PIn.String(row["CriterionDescript"].ToString());
evaluationCriterion.IsCategoryName = PIn.Bool(row["IsCategoryName"].ToString());
evaluationCriterion.GradingScaleNum = PIn.Long(row["GradingScaleNum"].ToString());
evaluationCriterion.GradeShowing = PIn.String(row["GradeShowing"].ToString());
evaluationCriterion.GradeNumber = PIn.Float(row["GradeNumber"].ToString());
evaluationCriterion.Notes = PIn.String(row["Notes"].ToString());
evaluationCriterion.ItemOrder = PIn.Int(row["ItemOrder"].ToString());
evaluationCriterion.MaxPointsPoss = PIn.Float(row["MaxPointsPoss"].ToString());
retVal.Add(evaluationCriterion);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <ClaimForm> TableToList(DataTable table)
{
List <ClaimForm> retVal = new List <ClaimForm>();
ClaimForm claimForm;
foreach (DataRow row in table.Rows)
{
claimForm = new ClaimForm();
claimForm.ClaimFormNum = PIn.Long(row["ClaimFormNum"].ToString());
claimForm.Description = PIn.String(row["Description"].ToString());
claimForm.IsHidden = PIn.Bool(row["IsHidden"].ToString());
claimForm.FontName = PIn.String(row["FontName"].ToString());
claimForm.FontSize = PIn.Float(row["FontSize"].ToString());
claimForm.UniqueID = PIn.String(row["UniqueID"].ToString());
claimForm.PrintImages = PIn.Bool(row["PrintImages"].ToString());
claimForm.OffsetX = PIn.Int(row["OffsetX"].ToString());
claimForm.OffsetY = PIn.Int(row["OffsetY"].ToString());
claimForm.Width = PIn.Int(row["Width"].ToString());
claimForm.Height = PIn.Int(row["Height"].ToString());
retVal.Add(claimForm);
}
return(retVal);
}