///<summary>Converts a DataTable to a list of objects.</summary>
public static List <EhrQuarterlyKey> TableToList(DataTable table)
{
List <EhrQuarterlyKey> retVal = new List <EhrQuarterlyKey>();
EhrQuarterlyKey ehrQuarterlyKey;
foreach (DataRow row in table.Rows)
{
ehrQuarterlyKey = new EhrQuarterlyKey();
ehrQuarterlyKey.EhrQuarterlyKeyNum = PIn.Long(row["EhrQuarterlyKeyNum"].ToString());
ehrQuarterlyKey.YearValue = PIn.Int(row["YearValue"].ToString());
ehrQuarterlyKey.QuarterValue = PIn.Int(row["QuarterValue"].ToString());
ehrQuarterlyKey.PracticeName = PIn.String(row["PracticeName"].ToString());
ehrQuarterlyKey.KeyValue = PIn.String(row["KeyValue"].ToString());
ehrQuarterlyKey.PatNum = PIn.Long(row["PatNum"].ToString());
ehrQuarterlyKey.Notes = PIn.String(row["Notes"].ToString());
retVal.Add(ehrQuarterlyKey);
}
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>
internal static List <Allergym> TableToList(DataTable table)
{
List <Allergym> retVal = new List <Allergym>();
Allergym allergym;
for (int i = 0; i < table.Rows.Count; i++)
{
allergym = new Allergym();
allergym.CustomerNum = PIn.Long(table.Rows[i]["CustomerNum"].ToString());
allergym.AllergyNum = PIn.Long(table.Rows[i]["AllergyNum"].ToString());
allergym.AllergyDefNum = PIn.Long(table.Rows[i]["AllergyDefNum"].ToString());
allergym.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
allergym.Reaction = PIn.String(table.Rows[i]["Reaction"].ToString());
allergym.StatusIsActive = PIn.Bool(table.Rows[i]["StatusIsActive"].ToString());
allergym.DateAdverseReaction = PIn.Date(table.Rows[i]["DateAdverseReaction"].ToString());
retVal.Add(allergym);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <Allergy> TableToList(DataTable table)
{
List <Allergy> retVal = new List <Allergy>();
Allergy allergy;
for (int i = 0; i < table.Rows.Count; i++)
{
allergy = new Allergy();
allergy.AllergyNum = PIn.Long(table.Rows[i]["AllergyNum"].ToString());
allergy.AllergyDefNum = PIn.Long(table.Rows[i]["AllergyDefNum"].ToString());
allergy.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
allergy.Reaction = PIn.String(table.Rows[i]["Reaction"].ToString());
allergy.StatusIsActive = PIn.Bool(table.Rows[i]["StatusIsActive"].ToString());
allergy.DateTStamp = PIn.DateT(table.Rows[i]["DateTStamp"].ToString());
allergy.DateAdverseReaction = PIn.Date(table.Rows[i]["DateAdverseReaction"].ToString());
retVal.Add(allergy);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <ProcButtonQuick> TableToList(DataTable table)
{
List <ProcButtonQuick> retVal = new List <ProcButtonQuick>();
ProcButtonQuick procButtonQuick;
foreach (DataRow row in table.Rows)
{
procButtonQuick = new ProcButtonQuick();
procButtonQuick.ProcButtonQuickNum = PIn.Long(row["ProcButtonQuickNum"].ToString());
procButtonQuick.Description = PIn.String(row["Description"].ToString());
procButtonQuick.CodeValue = PIn.String(row["CodeValue"].ToString());
procButtonQuick.Surf = PIn.String(row["Surf"].ToString());
procButtonQuick.YPos = PIn.Int(row["YPos"].ToString());
procButtonQuick.ItemOrder = PIn.Int(row["ItemOrder"].ToString());
procButtonQuick.IsLabel = PIn.Bool(row["IsLabel"].ToString());
retVal.Add(procButtonQuick);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <HL7Msg> TableToList(DataTable table)
{
List <HL7Msg> retVal = new List <HL7Msg>();
HL7Msg hL7Msg;
for (int i = 0; i < table.Rows.Count; i++)
{
hL7Msg = new HL7Msg();
hL7Msg.HL7MsgNum = PIn.Long(table.Rows[i]["HL7MsgNum"].ToString());
hL7Msg.HL7Status = (HL7MessageStatus)PIn.Int(table.Rows[i]["HL7Status"].ToString());
hL7Msg.MsgText = PIn.String(table.Rows[i]["MsgText"].ToString());
hL7Msg.AptNum = PIn.Long(table.Rows[i]["AptNum"].ToString());
hL7Msg.DateTStamp = PIn.DateT(table.Rows[i]["DateTStamp"].ToString());
hL7Msg.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
hL7Msg.Note = PIn.String(table.Rows[i]["Note"].ToString());
retVal.Add(hL7Msg);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Encounter> TableToList(DataTable table)
{
List <Encounter> retVal = new List <Encounter>();
Encounter encounter;
for (int i = 0; i < table.Rows.Count; i++)
{
encounter = new Encounter();
encounter.EncounterNum = PIn.Long(table.Rows[i]["EncounterNum"].ToString());
encounter.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
encounter.ProvNum = PIn.Long(table.Rows[i]["ProvNum"].ToString());
encounter.CodeValue = PIn.String(table.Rows[i]["CodeValue"].ToString());
encounter.CodeSystem = PIn.String(table.Rows[i]["CodeSystem"].ToString());
encounter.Note = PIn.String(table.Rows[i]["Note"].ToString());
encounter.DateEncounter = PIn.Date(table.Rows[i]["DateEncounter"].ToString());
retVal.Add(encounter);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <DisplayReport> TableToList(DataTable table)
{
List <DisplayReport> retVal = new List <DisplayReport>();
DisplayReport displayReport;
foreach (DataRow row in table.Rows)
{
displayReport = new DisplayReport();
displayReport.DisplayReportNum = PIn.Long(row["DisplayReportNum"].ToString());
displayReport.InternalName = PIn.String(row["InternalName"].ToString());
displayReport.ItemOrder = PIn.Int(row["ItemOrder"].ToString());
displayReport.Description = PIn.String(row["Description"].ToString());
displayReport.Category = (OpenDentBusiness.DisplayReportCategory)PIn.Int(row["Category"].ToString());
displayReport.IsHidden = PIn.Bool(row["IsHidden"].ToString());
displayReport.IsVisibleInSubMenu = PIn.Bool(row["IsVisibleInSubMenu"].ToString());
retVal.Add(displayReport);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <PatientNote> TableToList(DataTable table)
{
List <PatientNote> retVal = new List <PatientNote>();
PatientNote patientNote;
for (int i = 0; i < table.Rows.Count; i++)
{
patientNote = new PatientNote();
patientNote.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
patientNote.FamFinancial = PIn.String(table.Rows[i]["FamFinancial"].ToString());
patientNote.ApptPhone = PIn.String(table.Rows[i]["ApptPhone"].ToString());
patientNote.Medical = PIn.String(table.Rows[i]["Medical"].ToString());
patientNote.Service = PIn.String(table.Rows[i]["Service"].ToString());
patientNote.MedicalComp = PIn.String(table.Rows[i]["MedicalComp"].ToString());
patientNote.Treatment = PIn.String(table.Rows[i]["Treatment"].ToString());
retVal.Add(patientNote);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <MedicalOrder> TableToList(DataTable table)
{
List <MedicalOrder> retVal = new List <MedicalOrder>();
MedicalOrder medicalOrder;
for (int i = 0; i < table.Rows.Count; i++)
{
medicalOrder = new MedicalOrder();
medicalOrder.MedicalOrderNum = PIn.Long(table.Rows[i]["MedicalOrderNum"].ToString());
medicalOrder.MedOrderType = (MedicalOrderType)PIn.Int(table.Rows[i]["MedOrderType"].ToString());
medicalOrder.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
medicalOrder.DateTimeOrder = PIn.DateT(table.Rows[i]["DateTimeOrder"].ToString());
medicalOrder.Description = PIn.String(table.Rows[i]["Description"].ToString());
medicalOrder.IsDiscontinued = PIn.Bool(table.Rows[i]["IsDiscontinued"].ToString());
medicalOrder.ProvNum = PIn.Long(table.Rows[i]["ProvNum"].ToString());
retVal.Add(medicalOrder);
}
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 <Deposit> TableToList(DataTable table)
{
List <Deposit> retVal = new List <Deposit>();
Deposit deposit;
foreach (DataRow row in table.Rows)
{
deposit = new Deposit();
deposit.DepositNum = PIn.Long(row["DepositNum"].ToString());
deposit.DateDeposit = PIn.Date(row["DateDeposit"].ToString());
deposit.BankAccountInfo = PIn.String(row["BankAccountInfo"].ToString());
deposit.Amount = PIn.Double(row["Amount"].ToString());
deposit.Memo = PIn.String(row["Memo"].ToString());
deposit.Batch = PIn.String(row["Batch"].ToString());
deposit.DepositAccountNum = PIn.Long(row["DepositAccountNum"].ToString());
retVal.Add(deposit);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <EhrQuarterlyKey> TableToList(DataTable table)
{
List <EhrQuarterlyKey> retVal = new List <EhrQuarterlyKey>();
EhrQuarterlyKey ehrQuarterlyKey;
for (int i = 0; i < table.Rows.Count; i++)
{
ehrQuarterlyKey = new EhrQuarterlyKey();
ehrQuarterlyKey.EhrQuarterlyKeyNum = PIn.Long(table.Rows[i]["EhrQuarterlyKeyNum"].ToString());
ehrQuarterlyKey.YearValue = PIn.Int(table.Rows[i]["YearValue"].ToString());
ehrQuarterlyKey.QuarterValue = PIn.Int(table.Rows[i]["QuarterValue"].ToString());
ehrQuarterlyKey.PracticeName = PIn.String(table.Rows[i]["PracticeName"].ToString());
ehrQuarterlyKey.KeyValue = PIn.String(table.Rows[i]["KeyValue"].ToString());
ehrQuarterlyKey.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
ehrQuarterlyKey.Notes = PIn.String(table.Rows[i]["Notes"].ToString());
retVal.Add(ehrQuarterlyKey);
}
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>
public static List <Contact> TableToList(DataTable table)
{
List <Contact> retVal = new List <Contact>();
Contact contact;
foreach (DataRow row in table.Rows)
{
contact = new Contact();
contact.ContactNum = PIn.Long(row["ContactNum"].ToString());
contact.LName = PIn.String(row["LName"].ToString());
contact.FName = PIn.String(row["FName"].ToString());
contact.WkPhone = PIn.String(row["WkPhone"].ToString());
contact.Fax = PIn.String(row["Fax"].ToString());
contact.Category = PIn.Long(row["Category"].ToString());
contact.Notes = PIn.String(row["Notes"].ToString());
retVal.Add(contact);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <Contact> TableToList(DataTable table)
{
List <Contact> retVal = new List <Contact>();
Contact contact;
for (int i = 0; i < table.Rows.Count; i++)
{
contact = new Contact();
contact.ContactNum = PIn.Long(table.Rows[i]["ContactNum"].ToString());
contact.LName = PIn.String(table.Rows[i]["LName"].ToString());
contact.FName = PIn.String(table.Rows[i]["FName"].ToString());
contact.WkPhone = PIn.String(table.Rows[i]["WkPhone"].ToString());
contact.Fax = PIn.String(table.Rows[i]["Fax"].ToString());
contact.Category = PIn.Long(table.Rows[i]["Category"].ToString());
contact.Notes = PIn.String(table.Rows[i]["Notes"].ToString());
retVal.Add(contact);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <MedicationPatm> TableToList(DataTable table)
{
List <MedicationPatm> retVal = new List <MedicationPatm>();
MedicationPatm medicationPatm;
for (int i = 0; i < table.Rows.Count; i++)
{
medicationPatm = new MedicationPatm();
medicationPatm.CustomerNum = PIn.Long(table.Rows[i]["CustomerNum"].ToString());
medicationPatm.MedicationPatNum = PIn.Long(table.Rows[i]["MedicationPatNum"].ToString());
medicationPatm.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
medicationPatm.MedicationNum = PIn.Long(table.Rows[i]["MedicationNum"].ToString());
medicationPatm.PatNote = PIn.String(table.Rows[i]["PatNote"].ToString());
medicationPatm.DateStart = PIn.Date(table.Rows[i]["DateStart"].ToString());
medicationPatm.DateStop = PIn.Date(table.Rows[i]["DateStop"].ToString());
retVal.Add(medicationPatm);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <TerminalActive> TableToList(DataTable table)
{
List <TerminalActive> retVal = new List <TerminalActive>();
TerminalActive terminalActive;
foreach (DataRow row in table.Rows)
{
terminalActive = new TerminalActive();
terminalActive.TerminalActiveNum = PIn.Long(row["TerminalActiveNum"].ToString());
terminalActive.ComputerName = PIn.String(row["ComputerName"].ToString());
terminalActive.TerminalStatus = (OpenDentBusiness.TerminalStatusEnum)PIn.Int(row["TerminalStatus"].ToString());
terminalActive.PatNum = PIn.Long(row["PatNum"].ToString());
terminalActive.SessionId = PIn.Int(row["SessionId"].ToString());
terminalActive.ProcessId = PIn.Int(row["ProcessId"].ToString());
terminalActive.SessionName = PIn.String(row["SessionName"].ToString());
retVal.Add(terminalActive);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <EhrAptObs> TableToList(DataTable table)
{
List <EhrAptObs> retVal = new List <EhrAptObs>();
EhrAptObs ehrAptObs;
foreach (DataRow row in table.Rows)
{
ehrAptObs = new EhrAptObs();
ehrAptObs.EhrAptObsNum = PIn.Long(row["EhrAptObsNum"].ToString());
ehrAptObs.AptNum = PIn.Long(row["AptNum"].ToString());
ehrAptObs.IdentifyingCode = (OpenDentBusiness.EhrAptObsIdentifier)PIn.Int(row["IdentifyingCode"].ToString());
ehrAptObs.ValType = (OpenDentBusiness.EhrAptObsType)PIn.Int(row["ValType"].ToString());
ehrAptObs.ValReported = PIn.String(row["ValReported"].ToString());
ehrAptObs.UcumCode = PIn.String(row["UcumCode"].ToString());
ehrAptObs.ValCodeSystem = PIn.String(row["ValCodeSystem"].ToString());
retVal.Add(ehrAptObs);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <AllergyDef> TableToList(DataTable table)
{
List <AllergyDef> retVal = new List <AllergyDef>();
AllergyDef allergyDef;
foreach (DataRow row in table.Rows)
{
allergyDef = new AllergyDef();
allergyDef.AllergyDefNum = PIn.Long(row["AllergyDefNum"].ToString());
allergyDef.Description = PIn.String(row["Description"].ToString());
allergyDef.IsHidden = PIn.Bool(row["IsHidden"].ToString());
allergyDef.DateTStamp = PIn.DateT(row["DateTStamp"].ToString());
allergyDef.SnomedType = (OpenDentBusiness.SnomedAllergy)PIn.Int(row["SnomedType"].ToString());
allergyDef.MedicationNum = PIn.Long(row["MedicationNum"].ToString());
allergyDef.UniiCode = PIn.String(row["UniiCode"].ToString());
retVal.Add(allergyDef);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <EduResource> TableToList(DataTable table)
{
List <EduResource> retVal = new List <EduResource>();
EduResource eduResource;
for (int i = 0; i < table.Rows.Count; i++)
{
eduResource = new EduResource();
eduResource.EduResourceNum = PIn.Long(table.Rows[i]["EduResourceNum"].ToString());
eduResource.DiseaseDefNum = PIn.Long(table.Rows[i]["DiseaseDefNum"].ToString());
eduResource.MedicationNum = PIn.Long(table.Rows[i]["MedicationNum"].ToString());
eduResource.LabResultID = PIn.String(table.Rows[i]["LabResultID"].ToString());
eduResource.LabResultName = PIn.String(table.Rows[i]["LabResultName"].ToString());
eduResource.LabResultCompare = PIn.String(table.Rows[i]["LabResultCompare"].ToString());
eduResource.ResourceUrl = PIn.String(table.Rows[i]["ResourceUrl"].ToString());
retVal.Add(eduResource);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Address> TableToList(DataTable table)
{
List <Address> retVal = new List <Address>();
Address address;
foreach (DataRow row in table.Rows)
{
address = new Address();
address.AddressNum = PIn.Long(row["AddressNum"].ToString());
address.Address1 = PIn.String(row["Address1"].ToString());
address.Address2 = PIn.String(row["Address2"].ToString());
address.City = PIn.String(row["City"].ToString());
address.State = PIn.String(row["State"].ToString());
address.Zip = PIn.String(row["Zip"].ToString());
address.PatNumTaxPhysical = PIn.Long(row["PatNumTaxPhysical"].ToString());
retVal.Add(address);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <DisplayField> TableToList(DataTable table)
{
List <DisplayField> retVal = new List <DisplayField>();
DisplayField displayField;
for (int i = 0; i < table.Rows.Count; i++)
{
displayField = new DisplayField();
displayField.DisplayFieldNum = PIn.Long(table.Rows[i]["DisplayFieldNum"].ToString());
displayField.InternalName = PIn.String(table.Rows[i]["InternalName"].ToString());
displayField.ItemOrder = PIn.Int(table.Rows[i]["ItemOrder"].ToString());
displayField.Description = PIn.String(table.Rows[i]["Description"].ToString());
displayField.ColumnWidth = PIn.Int(table.Rows[i]["ColumnWidth"].ToString());
displayField.Category = (DisplayFieldCategory)PIn.Int(table.Rows[i]["Category"].ToString());
displayField.ChartViewNum = PIn.Long(table.Rows[i]["ChartViewNum"].ToString());
retVal.Add(displayField);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <TimeAdjust> TableToList(DataTable table)
{
List <TimeAdjust> retVal = new List <TimeAdjust>();
TimeAdjust timeAdjust;
for (int i = 0; i < table.Rows.Count; i++)
{
timeAdjust = new TimeAdjust();
timeAdjust.TimeAdjustNum = PIn.Long(table.Rows[i]["TimeAdjustNum"].ToString());
timeAdjust.EmployeeNum = PIn.Long(table.Rows[i]["EmployeeNum"].ToString());
timeAdjust.TimeEntry = PIn.DateT(table.Rows[i]["TimeEntry"].ToString());
timeAdjust.RegHours = PIn.TSpan(table.Rows[i]["RegHours"].ToString());
timeAdjust.OTimeHours = PIn.TSpan(table.Rows[i]["OTimeHours"].ToString());
timeAdjust.Note = PIn.String(table.Rows[i]["Note"].ToString());
timeAdjust.IsAuto = PIn.Bool(table.Rows[i]["IsAuto"].ToString());
retVal.Add(timeAdjust);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <PatPlan> TableToList(DataTable table)
{
List <PatPlan> retVal = new List <PatPlan>();
PatPlan patPlan;
for (int i = 0; i < table.Rows.Count; i++)
{
patPlan = new PatPlan();
patPlan.PatPlanNum = PIn.Long(table.Rows[i]["PatPlanNum"].ToString());
patPlan.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
patPlan.Ordinal = PIn.Byte(table.Rows[i]["Ordinal"].ToString());
patPlan.IsPending = PIn.Bool(table.Rows[i]["IsPending"].ToString());
patPlan.Relationship = (Relat)PIn.Int(table.Rows[i]["Relationship"].ToString());
patPlan.PatID = PIn.String(table.Rows[i]["PatID"].ToString());
patPlan.InsSubNum = PIn.Long(table.Rows[i]["InsSubNum"].ToString());
retVal.Add(patPlan);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <MedicalOrder> TableToList(DataTable table)
{
List <MedicalOrder> retVal = new List <MedicalOrder>();
MedicalOrder medicalOrder;
foreach (DataRow row in table.Rows)
{
medicalOrder = new MedicalOrder();
medicalOrder.MedicalOrderNum = PIn.Long(row["MedicalOrderNum"].ToString());
medicalOrder.MedOrderType = (OpenDentBusiness.MedicalOrderType)PIn.Int(row["MedOrderType"].ToString());
medicalOrder.PatNum = PIn.Long(row["PatNum"].ToString());
medicalOrder.DateTimeOrder = PIn.DateT(row["DateTimeOrder"].ToString());
medicalOrder.Description = PIn.String(row["Description"].ToString());
medicalOrder.IsDiscontinued = PIn.Bool(row["IsDiscontinued"].ToString());
medicalOrder.ProvNum = PIn.Long(row["ProvNum"].ToString());
retVal.Add(medicalOrder);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <RepeatCharge> TableToList(DataTable table)
{
List <RepeatCharge> retVal = new List <RepeatCharge>();
RepeatCharge repeatCharge;
for (int i = 0; i < table.Rows.Count; i++)
{
repeatCharge = new RepeatCharge();
repeatCharge.RepeatChargeNum = PIn.Long(table.Rows[i]["RepeatChargeNum"].ToString());
repeatCharge.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
repeatCharge.ProcCode = PIn.String(table.Rows[i]["ProcCode"].ToString());
repeatCharge.ChargeAmt = PIn.Double(table.Rows[i]["ChargeAmt"].ToString());
repeatCharge.DateStart = PIn.Date(table.Rows[i]["DateStart"].ToString());
repeatCharge.DateStop = PIn.Date(table.Rows[i]["DateStop"].ToString());
repeatCharge.Note = PIn.String(table.Rows[i]["Note"].ToString());
retVal.Add(repeatCharge);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <AppointmentType> TableToList(DataTable table)
{
List <AppointmentType> retVal = new List <AppointmentType>();
AppointmentType appointmentType;
foreach (DataRow row in table.Rows)
{
appointmentType = new AppointmentType();
appointmentType.AppointmentTypeNum = PIn.Long(row["AppointmentTypeNum"].ToString());
appointmentType.AppointmentTypeName = PIn.String(row["AppointmentTypeName"].ToString());
appointmentType.AppointmentTypeColor = Color.FromArgb(PIn.Int(row["AppointmentTypeColor"].ToString()));
appointmentType.ItemOrder = PIn.Int(row["ItemOrder"].ToString());
appointmentType.IsHidden = PIn.Bool(row["IsHidden"].ToString());
appointmentType.Pattern = PIn.String(row["Pattern"].ToString());
appointmentType.CodeStr = PIn.String(row["CodeStr"].ToString());
retVal.Add(appointmentType);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Def> TableToList(DataTable table)
{
List <Def> retVal = new List <Def>();
Def def;
foreach (DataRow row in table.Rows)
{
def = new Def();
def.DefNum = PIn.Long(row["DefNum"].ToString());
def.Category = (OpenDentBusiness.DefCat)PIn.Int(row["Category"].ToString());
def.ItemOrder = PIn.Int(row["ItemOrder"].ToString());
def.ItemName = PIn.String(row["ItemName"].ToString());
def.ItemValue = PIn.String(row["ItemValue"].ToString());
def.ItemColor = Color.FromArgb(PIn.Int(row["ItemColor"].ToString()));
def.IsHidden = PIn.Bool(row["IsHidden"].ToString());
retVal.Add(def);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <SmsPhone> TableToList(DataTable table)
{
List <SmsPhone> retVal = new List <SmsPhone>();
SmsPhone smsPhone;
foreach (DataRow row in table.Rows)
{
smsPhone = new SmsPhone();
smsPhone.SmsPhoneNum = PIn.Long(row["SmsPhoneNum"].ToString());
smsPhone.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
smsPhone.PhoneNumber = PIn.String(row["PhoneNumber"].ToString());
smsPhone.DateTimeActive = PIn.DateT(row["DateTimeActive"].ToString());
smsPhone.DateTimeInactive = PIn.DateT(row["DateTimeInactive"].ToString());
smsPhone.InactiveCode = PIn.String(row["InactiveCode"].ToString());
smsPhone.CountryCode = PIn.String(row["CountryCode"].ToString());
retVal.Add(smsPhone);
}
return(retVal);
}