///<summary>Converts a DataTable to a list of objects.</summary>
public static List <InsVerifyHist> TableToList(DataTable table)
{
List <InsVerifyHist> retVal = new List <InsVerifyHist>();
InsVerifyHist insVerifyHist;
foreach (DataRow row in table.Rows)
{
insVerifyHist = new InsVerifyHist();
insVerifyHist.InsVerifyHistNum = PIn.Long(row["InsVerifyHistNum"].ToString());
insVerifyHist.VerifyUserNum = PIn.Long(row["VerifyUserNum"].ToString());
insVerifyHist.InsVerifyNum = PIn.Long(row["InsVerifyNum"].ToString());
insVerifyHist.DateLastVerified = PIn.Date(row["DateLastVerified"].ToString());
insVerifyHist.UserNum = PIn.Long(row["UserNum"].ToString());
insVerifyHist.VerifyType = (OpenDentBusiness.VerifyTypes)PIn.Int(row["VerifyType"].ToString());
insVerifyHist.FKey = PIn.Long(row["FKey"].ToString());
insVerifyHist.DefNum = PIn.Long(row["DefNum"].ToString());
insVerifyHist.DateLastAssigned = PIn.Date(row["DateLastAssigned"].ToString());
insVerifyHist.Note = PIn.String(row["Note"].ToString());
insVerifyHist.DateTimeEntry = PIn.DateT(row["DateTimeEntry"].ToString());
insVerifyHist.HoursAvailableForVerification = PIn.Double(row["HoursAvailableForVerification"].ToString());
insVerifyHist.SecDateTEdit = PIn.DateT(row["SecDateTEdit"].ToString());
retVal.Add(insVerifyHist);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <TreatPlan> TableToList(DataTable table)
{
List <TreatPlan> retVal = new List <TreatPlan>();
TreatPlan treatPlan;
foreach (DataRow row in table.Rows)
{
treatPlan = new TreatPlan();
treatPlan.TreatPlanNum = PIn.Long(row["TreatPlanNum"].ToString());
treatPlan.PatNum = PIn.Long(row["PatNum"].ToString());
treatPlan.DateTP = PIn.Date(row["DateTP"].ToString());
treatPlan.Heading = PIn.String(row["Heading"].ToString());
treatPlan.Note = PIn.String(row["Note"].ToString());
treatPlan.Signature = PIn.String(row["Signature"].ToString());
treatPlan.SigIsTopaz = PIn.Bool(row["SigIsTopaz"].ToString());
treatPlan.ResponsParty = PIn.Long(row["ResponsParty"].ToString());
treatPlan.DocNum = PIn.Long(row["DocNum"].ToString());
treatPlan.TPStatus = (OpenDentBusiness.TreatPlanStatus)PIn.Int(row["TPStatus"].ToString());
treatPlan.SecUserNumEntry = PIn.Long(row["SecUserNumEntry"].ToString());
treatPlan.SecDateEntry = PIn.Date(row["SecDateEntry"].ToString());
treatPlan.SecDateTEdit = PIn.DateT(row["SecDateTEdit"].ToString());
treatPlan.UserNumPresenter = PIn.Long(row["UserNumPresenter"].ToString());
treatPlan.TPType = (OpenDentBusiness.TreatPlanType)PIn.Int(row["TPType"].ToString());
retVal.Add(treatPlan);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <InsSub> TableToList(DataTable table)
{
List <InsSub> retVal = new List <InsSub>();
InsSub insSub;
foreach (DataRow row in table.Rows)
{
insSub = new InsSub();
insSub.InsSubNum = PIn.Long(row["InsSubNum"].ToString());
insSub.PlanNum = PIn.Long(row["PlanNum"].ToString());
insSub.Subscriber = PIn.Long(row["Subscriber"].ToString());
insSub.DateEffective = PIn.Date(row["DateEffective"].ToString());
insSub.DateTerm = PIn.Date(row["DateTerm"].ToString());
insSub.ReleaseInfo = PIn.Bool(row["ReleaseInfo"].ToString());
insSub.AssignBen = PIn.Bool(row["AssignBen"].ToString());
insSub.SubscriberID = PIn.String(row["SubscriberID"].ToString());
insSub.BenefitNotes = PIn.String(row["BenefitNotes"].ToString());
insSub.SubscNote = PIn.String(row["SubscNote"].ToString());
insSub.SecUserNumEntry = PIn.Long(row["SecUserNumEntry"].ToString());
insSub.SecDateEntry = PIn.Date(row["SecDateEntry"].ToString());
insSub.SecDateTEdit = PIn.DateT(row["SecDateTEdit"].ToString());
retVal.Add(insSub);
}
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 <XChargeTransaction> TableToList(DataTable table)
{
List <XChargeTransaction> retVal = new List <XChargeTransaction>();
XChargeTransaction xChargeTransaction;
foreach (DataRow row in table.Rows)
{
xChargeTransaction = new XChargeTransaction();
xChargeTransaction.XChargeTransactionNum = PIn.Long(row["XChargeTransactionNum"].ToString());
xChargeTransaction.TransType = PIn.String(row["TransType"].ToString());
xChargeTransaction.Amount = PIn.Double(row["Amount"].ToString());
xChargeTransaction.CCEntry = PIn.String(row["CCEntry"].ToString());
xChargeTransaction.PatNum = PIn.Long(row["PatNum"].ToString());
xChargeTransaction.Result = PIn.String(row["Result"].ToString());
xChargeTransaction.ClerkID = PIn.String(row["ClerkID"].ToString());
xChargeTransaction.ResultCode = PIn.String(row["ResultCode"].ToString());
xChargeTransaction.Expiration = PIn.String(row["Expiration"].ToString());
xChargeTransaction.CCType = PIn.String(row["CCType"].ToString());
xChargeTransaction.CreditCardNum = PIn.String(row["CreditCardNum"].ToString());
xChargeTransaction.BatchNum = PIn.String(row["BatchNum"].ToString());
xChargeTransaction.ItemNum = PIn.String(row["ItemNum"].ToString());
xChargeTransaction.ApprCode = PIn.String(row["ApprCode"].ToString());
xChargeTransaction.TransactionDateTime = PIn.DateT(row["TransactionDateTime"].ToString());
retVal.Add(xChargeTransaction);
}
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 <RecurringCharge> TableToList(DataTable table)
{
List <RecurringCharge> retVal = new List <RecurringCharge>();
RecurringCharge recurringCharge;
foreach (DataRow row in table.Rows)
{
recurringCharge = new RecurringCharge();
recurringCharge.RecurringChargeNum = PIn.Long(row["RecurringChargeNum"].ToString());
recurringCharge.PatNum = PIn.Long(row["PatNum"].ToString());
recurringCharge.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
recurringCharge.DateTimeCharge = PIn.DateT(row["DateTimeCharge"].ToString());
recurringCharge.ChargeStatus = (OpenDentBusiness.RecurringChargeStatus)PIn.Int(row["ChargeStatus"].ToString());
recurringCharge.FamBal = PIn.Double(row["FamBal"].ToString());
recurringCharge.PayPlanDue = PIn.Double(row["PayPlanDue"].ToString());
recurringCharge.TotalDue = PIn.Double(row["TotalDue"].ToString());
recurringCharge.RepeatAmt = PIn.Double(row["RepeatAmt"].ToString());
recurringCharge.ChargeAmt = PIn.Double(row["ChargeAmt"].ToString());
recurringCharge.UserNum = PIn.Long(row["UserNum"].ToString());
recurringCharge.PayNum = PIn.Long(row["PayNum"].ToString());
recurringCharge.CreditCardNum = PIn.Long(row["CreditCardNum"].ToString());
recurringCharge.ErrorMsg = PIn.String(row["ErrorMsg"].ToString());
retVal.Add(recurringCharge);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <Etrans> TableToList(DataTable table)
{
List <Etrans> retVal = new List <Etrans>();
Etrans etrans;
for (int i = 0; i < table.Rows.Count; i++)
{
etrans = new Etrans();
etrans.EtransNum = PIn.Long(table.Rows[i]["EtransNum"].ToString());
etrans.DateTimeTrans = PIn.DateT(table.Rows[i]["DateTimeTrans"].ToString());
etrans.ClearingHouseNum = PIn.Long(table.Rows[i]["ClearingHouseNum"].ToString());
etrans.Etype = (EtransType)PIn.Int(table.Rows[i]["Etype"].ToString());
etrans.ClaimNum = PIn.Long(table.Rows[i]["ClaimNum"].ToString());
etrans.OfficeSequenceNumber = PIn.Int(table.Rows[i]["OfficeSequenceNumber"].ToString());
etrans.CarrierTransCounter = PIn.Int(table.Rows[i]["CarrierTransCounter"].ToString());
etrans.CarrierTransCounter2 = PIn.Int(table.Rows[i]["CarrierTransCounter2"].ToString());
etrans.CarrierNum = PIn.Long(table.Rows[i]["CarrierNum"].ToString());
etrans.CarrierNum2 = PIn.Long(table.Rows[i]["CarrierNum2"].ToString());
etrans.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
etrans.BatchNumber = PIn.Int(table.Rows[i]["BatchNumber"].ToString());
etrans.AckCode = PIn.String(table.Rows[i]["AckCode"].ToString());
etrans.TransSetNum = PIn.Int(table.Rows[i]["TransSetNum"].ToString());
etrans.Note = PIn.String(table.Rows[i]["Note"].ToString());
etrans.EtransMessageTextNum = PIn.Long(table.Rows[i]["EtransMessageTextNum"].ToString());
etrans.AckEtransNum = PIn.Long(table.Rows[i]["AckEtransNum"].ToString());
etrans.PlanNum = PIn.Long(table.Rows[i]["PlanNum"].ToString());
etrans.InsSubNum = PIn.Long(table.Rows[i]["InsSubNum"].ToString());
retVal.Add(etrans);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Operatory> TableToList(DataTable table)
{
List <Operatory> retVal = new List <Operatory>();
Operatory operatory;
foreach (DataRow row in table.Rows)
{
operatory = new Operatory();
operatory.OperatoryNum = PIn.Long(row["OperatoryNum"].ToString());
operatory.OpName = PIn.String(row["OpName"].ToString());
operatory.Abbrev = PIn.String(row["Abbrev"].ToString());
operatory.ItemOrder = PIn.Int(row["ItemOrder"].ToString());
operatory.IsHidden = PIn.Bool(row["IsHidden"].ToString());
operatory.ProvDentist = PIn.Long(row["ProvDentist"].ToString());
operatory.ProvHygienist = PIn.Long(row["ProvHygienist"].ToString());
operatory.IsHygiene = PIn.Bool(row["IsHygiene"].ToString());
operatory.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
operatory.SetProspective = PIn.Bool(row["SetProspective"].ToString());
operatory.DateTStamp = PIn.DateT(row["DateTStamp"].ToString());
operatory.IsWebSched = PIn.Bool(row["IsWebSched"].ToString());
operatory.IsNewPatAppt = PIn.Bool(row["IsNewPatAppt"].ToString());
retVal.Add(operatory);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <Appointmentm> TableToList(DataTable table)
{
List <Appointmentm> retVal = new List <Appointmentm>();
Appointmentm appointmentm;
for (int i = 0; i < table.Rows.Count; i++)
{
appointmentm = new Appointmentm();
appointmentm.CustomerNum = PIn.Long(table.Rows[i]["CustomerNum"].ToString());
appointmentm.AptNum = PIn.Long(table.Rows[i]["AptNum"].ToString());
appointmentm.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
appointmentm.AptStatus = (ApptStatus)PIn.Int(table.Rows[i]["AptStatus"].ToString());
appointmentm.Pattern = PIn.String(table.Rows[i]["Pattern"].ToString());
appointmentm.Confirmed = PIn.Long(table.Rows[i]["Confirmed"].ToString());
appointmentm.Op = PIn.Long(table.Rows[i]["Op"].ToString());
appointmentm.Note = PIn.String(table.Rows[i]["Note"].ToString());
appointmentm.ProvNum = PIn.Long(table.Rows[i]["ProvNum"].ToString());
appointmentm.ProvHyg = PIn.Long(table.Rows[i]["ProvHyg"].ToString());
appointmentm.AptDateTime = PIn.DateT(table.Rows[i]["AptDateTime"].ToString());
appointmentm.IsNewPatient = PIn.Bool(table.Rows[i]["IsNewPatient"].ToString());
appointmentm.ProcDescript = PIn.String(table.Rows[i]["ProcDescript"].ToString());
appointmentm.ClinicNum = PIn.Long(table.Rows[i]["ClinicNum"].ToString());
appointmentm.IsHygiene = PIn.Bool(table.Rows[i]["IsHygiene"].ToString());
retVal.Add(appointmentm);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Carrier> TableToList(DataTable table)
{
List <Carrier> retVal = new List <Carrier>();
Carrier carrier;
foreach (DataRow row in table.Rows)
{
carrier = new Carrier();
carrier.CarrierNum = PIn.Long(row["CarrierNum"].ToString());
carrier.CarrierName = PIn.String(row["CarrierName"].ToString());
carrier.Address = PIn.String(row["Address"].ToString());
carrier.Address2 = PIn.String(row["Address2"].ToString());
carrier.City = PIn.String(row["City"].ToString());
carrier.State = PIn.String(row["State"].ToString());
carrier.Zip = PIn.String(row["Zip"].ToString());
carrier.Phone = PIn.String(row["Phone"].ToString());
carrier.ElectID = PIn.String(row["ElectID"].ToString());
carrier.NoSendElect = PIn.Bool(row["NoSendElect"].ToString());
carrier.IsCDA = PIn.Bool(row["IsCDA"].ToString());
carrier.CDAnetVersion = PIn.String(row["CDAnetVersion"].ToString());
carrier.CanadianNetworkNum = PIn.Long(row["CanadianNetworkNum"].ToString());
carrier.IsHidden = PIn.Bool(row["IsHidden"].ToString());
carrier.CanadianEncryptionMethod = PIn.Byte(row["CanadianEncryptionMethod"].ToString());
carrier.CanadianSupportedTypes = (OpenDentBusiness.CanSupTransTypes)PIn.Int(row["CanadianSupportedTypes"].ToString());
carrier.SecUserNumEntry = PIn.Long(row["SecUserNumEntry"].ToString());
carrier.SecDateEntry = PIn.Date(row["SecDateEntry"].ToString());
carrier.SecDateTEdit = PIn.DateT(row["SecDateTEdit"].ToString());
carrier.TIN = PIn.String(row["TIN"].ToString());
carrier.CarrierGroupName = PIn.Long(row["CarrierGroupName"].ToString());
carrier.ApptTextBackColor = Color.FromArgb(PIn.Int(row["ApptTextBackColor"].ToString()));
carrier.IsCoinsuranceInverted = PIn.Bool(row["IsCoinsuranceInverted"].ToString());
retVal.Add(carrier);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <EServiceBilling> TableToList(DataTable table)
{
List <EServiceBilling> retVal = new List <EServiceBilling>();
EServiceBilling eServiceBilling;
foreach (DataRow row in table.Rows)
{
eServiceBilling = new EServiceBilling();
eServiceBilling.EServiceBillingNum = PIn.Long(row["EServiceBillingNum"].ToString());
eServiceBilling.RegistrationKeyNum = PIn.Long(row["RegistrationKeyNum"].ToString());
eServiceBilling.CustPatNum = PIn.Long(row["CustPatNum"].ToString());
eServiceBilling.BillingCycleDay = PIn.Int(row["BillingCycleDay"].ToString());
eServiceBilling.DateTimeEntry = PIn.DateT(row["DateTimeEntry"].ToString());
eServiceBilling.DateTimeProceduresPosted = PIn.DateT(row["DateTimeProceduresPosted"].ToString());
eServiceBilling.DateOfBill = PIn.Date(row["DateOfBill"].ToString());
eServiceBilling.MonthOfBill = PIn.Date(row["MonthOfBill"].ToString());
eServiceBilling.BillCycleStart = PIn.Date(row["BillCycleStart"].ToString());
eServiceBilling.BillCycleEnd = PIn.Date(row["BillCycleEnd"].ToString());
eServiceBilling.UsageCycleStart = PIn.Date(row["UsageCycleStart"].ToString());
eServiceBilling.UsageCycleEnd = PIn.Date(row["UsageCycleEnd"].ToString());
eServiceBilling.ProceduresJson = PIn.String(row["ProceduresJson"].ToString());
eServiceBilling.ChargesJson = PIn.String(row["ChargesJson"].ToString());
eServiceBilling.NexmoInfoJson = PIn.String(row["NexmoInfoJson"].ToString());
eServiceBilling.LogInfo = PIn.String(row["LogInfo"].ToString());
retVal.Add(eServiceBilling);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <RxPat> TableToList(DataTable table)
{
List <RxPat> retVal = new List <RxPat>();
RxPat rxPat;
foreach (DataRow row in table.Rows)
{
rxPat = new RxPat();
rxPat.RxNum = PIn.Long(row["RxNum"].ToString());
rxPat.PatNum = PIn.Long(row["PatNum"].ToString());
rxPat.RxDate = PIn.Date(row["RxDate"].ToString());
rxPat.Drug = PIn.String(row["Drug"].ToString());
rxPat.Sig = PIn.String(row["Sig"].ToString());
rxPat.Disp = PIn.String(row["Disp"].ToString());
rxPat.Refills = PIn.String(row["Refills"].ToString());
rxPat.ProvNum = PIn.Long(row["ProvNum"].ToString());
rxPat.Notes = PIn.String(row["Notes"].ToString());
rxPat.PharmacyNum = PIn.Long(row["PharmacyNum"].ToString());
rxPat.IsControlled = PIn.Bool(row["IsControlled"].ToString());
rxPat.DateTStamp = PIn.DateT(row["DateTStamp"].ToString());
rxPat.SendStatus = (OpenDentBusiness.RxSendStatus)PIn.Int(row["SendStatus"].ToString());
rxPat.RxCui = PIn.Long(row["RxCui"].ToString());
rxPat.DosageCode = PIn.String(row["DosageCode"].ToString());
rxPat.ErxGuid = PIn.String(row["ErxGuid"].ToString());
rxPat.IsErxOld = PIn.Bool(row["IsErxOld"].ToString());
rxPat.ErxPharmacyInfo = PIn.String(row["ErxPharmacyInfo"].ToString());
rxPat.IsProcRequired = PIn.Bool(row["IsProcRequired"].ToString());
rxPat.ProcNum = PIn.Long(row["ProcNum"].ToString());
rxPat.DaysOfSupply = PIn.Int(row["DaysOfSupply"].ToString());
retVal.Add(rxPat);
}
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;
foreach (DataRow row in table.Rows)
{
patientNote = new PatientNote();
patientNote.PatNum = PIn.Long(row["PatNum"].ToString());
patientNote.FamFinancial = PIn.String(row["FamFinancial"].ToString());
patientNote.ApptPhone = PIn.String(row["ApptPhone"].ToString());
patientNote.Medical = PIn.String(row["Medical"].ToString());
patientNote.Service = PIn.String(row["Service"].ToString());
patientNote.MedicalComp = PIn.String(row["MedicalComp"].ToString());
patientNote.Treatment = PIn.String(row["Treatment"].ToString());
patientNote.ICEName = PIn.String(row["ICEName"].ToString());
patientNote.ICEPhone = PIn.String(row["ICEPhone"].ToString());
patientNote.OrthoMonthsTreatOverride = PIn.Int(row["OrthoMonthsTreatOverride"].ToString());
patientNote.DateOrthoPlacementOverride = PIn.Date(row["DateOrthoPlacementOverride"].ToString());
patientNote.SecDateTEntry = PIn.DateT(row["SecDateTEntry"].ToString());
patientNote.SecDateTEdit = PIn.DateT(row["SecDateTEdit"].ToString());
patientNote.Consent = (OpenDentBusiness.PatConsentFlags)PIn.Int(row["Consent"].ToString());
retVal.Add(patientNote);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <JobReview> TableToList(DataTable table)
{
List <JobReview> retVal = new List <JobReview>();
JobReview jobReview;
foreach (DataRow row in table.Rows)
{
jobReview = new JobReview();
jobReview.JobReviewNum = PIn.Long(row["JobReviewNum"].ToString());
jobReview.JobNum = PIn.Long(row["JobNum"].ToString());
jobReview.ReviewerNum = PIn.Long(row["ReviewerNum"].ToString());
jobReview.DateTStamp = PIn.DateT(row["DateTStamp"].ToString());
jobReview.Description = PIn.String(row["Description"].ToString());
string reviewStatus = row["ReviewStatus"].ToString();
if (reviewStatus == "")
{
jobReview.ReviewStatus = (JobReviewStatus)0;
}
else
{
try{
jobReview.ReviewStatus = (JobReviewStatus)Enum.Parse(typeof(JobReviewStatus), reviewStatus);
}
catch {
jobReview.ReviewStatus = (JobReviewStatus)0;
}
}
jobReview.Hours = PIn.String(row["Hours"].ToString());
retVal.Add(jobReview);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <SmsFromMobile> TableToList(DataTable table)
{
List <SmsFromMobile> retVal = new List <SmsFromMobile>();
SmsFromMobile smsFromMobile;
foreach (DataRow row in table.Rows)
{
smsFromMobile = new SmsFromMobile();
smsFromMobile.SmsFromMobileNum = PIn.Long(row["SmsFromMobileNum"].ToString());
smsFromMobile.PatNum = PIn.Long(row["PatNum"].ToString());
smsFromMobile.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
smsFromMobile.CommlogNum = PIn.Long(row["CommlogNum"].ToString());
smsFromMobile.MsgText = PIn.String(row["MsgText"].ToString());
smsFromMobile.DateTimeReceived = PIn.DateT(row["DateTimeReceived"].ToString());
smsFromMobile.SmsPhoneNumber = PIn.String(row["SmsPhoneNumber"].ToString());
smsFromMobile.MobilePhoneNumber = PIn.String(row["MobilePhoneNumber"].ToString());
smsFromMobile.MsgPart = PIn.Int(row["MsgPart"].ToString());
smsFromMobile.MsgTotal = PIn.Int(row["MsgTotal"].ToString());
smsFromMobile.MsgRefID = PIn.String(row["MsgRefID"].ToString());
smsFromMobile.SmsStatus = (OpenDentBusiness.SmsFromStatus)PIn.Int(row["SmsStatus"].ToString());
smsFromMobile.Flags = PIn.String(row["Flags"].ToString());
smsFromMobile.IsHidden = PIn.Bool(row["IsHidden"].ToString());
smsFromMobile.MatchCount = PIn.Int(row["MatchCount"].ToString());
smsFromMobile.GuidMessage = PIn.String(row["GuidMessage"].ToString());
retVal.Add(smsFromMobile);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <ProcTP> TableToList(DataTable table)
{
List <ProcTP> retVal = new List <ProcTP>();
ProcTP procTP;
foreach (DataRow row in table.Rows)
{
procTP = new ProcTP();
procTP.ProcTPNum = PIn.Long(row["ProcTPNum"].ToString());
procTP.TreatPlanNum = PIn.Long(row["TreatPlanNum"].ToString());
procTP.PatNum = PIn.Long(row["PatNum"].ToString());
procTP.ProcNumOrig = PIn.Long(row["ProcNumOrig"].ToString());
procTP.ItemOrder = PIn.Int(row["ItemOrder"].ToString());
procTP.Priority = PIn.Long(row["Priority"].ToString());
procTP.ToothNumTP = PIn.String(row["ToothNumTP"].ToString());
procTP.Surf = PIn.String(row["Surf"].ToString());
procTP.ProcCode = PIn.String(row["ProcCode"].ToString());
procTP.Descript = PIn.String(row["Descript"].ToString());
procTP.FeeAmt = PIn.Double(row["FeeAmt"].ToString());
procTP.PriInsAmt = PIn.Double(row["PriInsAmt"].ToString());
procTP.SecInsAmt = PIn.Double(row["SecInsAmt"].ToString());
procTP.PatAmt = PIn.Double(row["PatAmt"].ToString());
procTP.Discount = PIn.Double(row["Discount"].ToString());
procTP.Prognosis = PIn.String(row["Prognosis"].ToString());
procTP.Dx = PIn.String(row["Dx"].ToString());
procTP.ProcAbbr = PIn.String(row["ProcAbbr"].ToString());
procTP.SecUserNumEntry = PIn.Long(row["SecUserNumEntry"].ToString());
procTP.SecDateEntry = PIn.Date(row["SecDateEntry"].ToString());
procTP.SecDateTEdit = PIn.DateT(row["SecDateTEdit"].ToString());
procTP.FeeAllowed = PIn.Double(row["FeeAllowed"].ToString());
retVal.Add(procTP);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Task> TableToList(DataTable table)
{
List <Task> retVal = new List <Task>();
Task task;
foreach (DataRow row in table.Rows)
{
task = new Task();
task.TaskNum = PIn.Long(row["TaskNum"].ToString());
task.TaskListNum = PIn.Long(row["TaskListNum"].ToString());
task.DateTask = PIn.Date(row["DateTask"].ToString());
task.KeyNum = PIn.Long(row["KeyNum"].ToString());
task.Descript = PIn.String(row["Descript"].ToString());
task.TaskStatus = (OpenDentBusiness.TaskStatusEnum)PIn.Int(row["TaskStatus"].ToString());
task.IsRepeating = PIn.Bool(row["IsRepeating"].ToString());
task.DateType = (OpenDentBusiness.TaskDateType)PIn.Int(row["DateType"].ToString());
task.FromNum = PIn.Long(row["FromNum"].ToString());
task.ObjectType = (OpenDentBusiness.TaskObjectType)PIn.Int(row["ObjectType"].ToString());
task.DateTimeEntry = PIn.DateT(row["DateTimeEntry"].ToString());
task.UserNum = PIn.Long(row["UserNum"].ToString());
task.DateTimeFinished = PIn.DateT(row["DateTimeFinished"].ToString());
task.PriorityDefNum = PIn.Long(row["PriorityDefNum"].ToString());
task.ReminderGroupId = PIn.String(row["ReminderGroupId"].ToString());
task.ReminderType = (OpenDentBusiness.TaskReminderType)PIn.Int(row["ReminderType"].ToString());
task.ReminderFrequency = PIn.Int(row["ReminderFrequency"].ToString());
task.DateTimeOriginal = PIn.DateT(row["DateTimeOriginal"].ToString());
retVal.Add(task);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Payment> TableToList(DataTable table)
{
List <Payment> retVal = new List <Payment>();
Payment payment;
foreach (DataRow row in table.Rows)
{
payment = new Payment();
payment.PayNum = PIn.Long(row["PayNum"].ToString());
payment.PayType = PIn.Long(row["PayType"].ToString());
payment.PayDate = PIn.Date(row["PayDate"].ToString());
payment.PayAmt = PIn.Double(row["PayAmt"].ToString());
payment.CheckNum = PIn.String(row["CheckNum"].ToString());
payment.BankBranch = PIn.String(row["BankBranch"].ToString());
payment.PayNote = PIn.String(row["PayNote"].ToString());
payment.IsSplit = PIn.Bool(row["IsSplit"].ToString());
payment.PatNum = PIn.Long(row["PatNum"].ToString());
payment.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
payment.DateEntry = PIn.Date(row["DateEntry"].ToString());
payment.DepositNum = PIn.Long(row["DepositNum"].ToString());
payment.Receipt = PIn.String(row["Receipt"].ToString());
payment.IsRecurringCC = PIn.Bool(row["IsRecurringCC"].ToString());
payment.SecUserNumEntry = PIn.Long(row["SecUserNumEntry"].ToString());
payment.SecDateTEdit = PIn.DateT(row["SecDateTEdit"].ToString());
payment.PaymentSource = (OpenDentBusiness.CreditCardSource)PIn.Int(row["PaymentSource"].ToString());
payment.ProcessStatus = (OpenDentBusiness.ProcessStat)PIn.Int(row["ProcessStatus"].ToString());
payment.RecurringChargeDate = PIn.Date(row["RecurringChargeDate"].ToString());
retVal.Add(payment);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <LabCase> TableToList(DataTable table)
{
List <LabCase> retVal = new List <LabCase>();
LabCase labCase;
foreach (DataRow row in table.Rows)
{
labCase = new LabCase();
labCase.LabCaseNum = PIn.Long(row["LabCaseNum"].ToString());
labCase.PatNum = PIn.Long(row["PatNum"].ToString());
labCase.LaboratoryNum = PIn.Long(row["LaboratoryNum"].ToString());
labCase.AptNum = PIn.Long(row["AptNum"].ToString());
labCase.PlannedAptNum = PIn.Long(row["PlannedAptNum"].ToString());
labCase.DateTimeDue = PIn.DateT(row["DateTimeDue"].ToString());
labCase.DateTimeCreated = PIn.DateT(row["DateTimeCreated"].ToString());
labCase.DateTimeSent = PIn.DateT(row["DateTimeSent"].ToString());
labCase.DateTimeRecd = PIn.DateT(row["DateTimeRecd"].ToString());
labCase.DateTimeChecked = PIn.DateT(row["DateTimeChecked"].ToString());
labCase.ProvNum = PIn.Long(row["ProvNum"].ToString());
labCase.Instructions = PIn.String(row["Instructions"].ToString());
labCase.LabFee = PIn.Double(row["LabFee"].ToString());
labCase.DateTStamp = PIn.DateT(row["DateTStamp"].ToString());
retVal.Add(labCase);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Signalod> TableToList(DataTable table)
{
List <Signalod> retVal = new List <Signalod>();
Signalod signalod;
foreach (DataRow row in table.Rows)
{
signalod = new Signalod();
signalod.SignalNum = PIn.Long(row["SignalNum"].ToString());
signalod.DateViewing = PIn.Date(row["DateViewing"].ToString());
signalod.SigDateTime = PIn.DateT(row["SigDateTime"].ToString());
signalod.FKey = PIn.Long(row["FKey"].ToString());
string fKeyType = row["FKeyType"].ToString();
if (fKeyType == "")
{
signalod.FKeyType = (KeyType)0;
}
else
{
try{
signalod.FKeyType = (KeyType)Enum.Parse(typeof(KeyType), fKeyType);
}
catch {
signalod.FKeyType = (KeyType)0;
}
}
signalod.IType = (OpenDentBusiness.InvalidType)PIn.Int(row["IType"].ToString());
signalod.RemoteRole = (OpenDentBusiness.RemotingRole)PIn.Int(row["RemoteRole"].ToString());
signalod.MsgValue = PIn.String(row["MsgValue"].ToString());
retVal.Add(signalod);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <ClockEvent> TableToList(DataTable table)
{
List <ClockEvent> retVal = new List <ClockEvent>();
ClockEvent clockEvent;
for (int i = 0; i < table.Rows.Count; i++)
{
clockEvent = new ClockEvent();
clockEvent.ClockEventNum = PIn.Long(table.Rows[i]["ClockEventNum"].ToString());
clockEvent.EmployeeNum = PIn.Long(table.Rows[i]["EmployeeNum"].ToString());
clockEvent.TimeEntered1 = PIn.DateT(table.Rows[i]["TimeEntered1"].ToString());
clockEvent.TimeDisplayed1 = PIn.DateT(table.Rows[i]["TimeDisplayed1"].ToString());
clockEvent.ClockStatus = (TimeClockStatus)PIn.Int(table.Rows[i]["ClockStatus"].ToString());
clockEvent.Note = PIn.String(table.Rows[i]["Note"].ToString());
clockEvent.TimeEntered2 = PIn.DateT(table.Rows[i]["TimeEntered2"].ToString());
clockEvent.TimeDisplayed2 = PIn.DateT(table.Rows[i]["TimeDisplayed2"].ToString());
clockEvent.OTimeHours = PIn.TSpan(table.Rows[i]["OTimeHours"].ToString());
clockEvent.OTimeAuto = PIn.TSpan(table.Rows[i]["OTimeAuto"].ToString());
clockEvent.Adjust = PIn.TSpan(table.Rows[i]["Adjust"].ToString());
clockEvent.AdjustAuto = PIn.TSpan(table.Rows[i]["AdjustAuto"].ToString());
clockEvent.AdjustIsOverridden = PIn.Bool(table.Rows[i]["AdjustIsOverridden"].ToString());
retVal.Add(clockEvent);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <PaySplit> TableToList(DataTable table)
{
List <PaySplit> retVal = new List <PaySplit>();
PaySplit paySplit;
foreach (DataRow row in table.Rows)
{
paySplit = new PaySplit();
paySplit.SplitNum = PIn.Long(row["SplitNum"].ToString());
paySplit.SplitAmt = PIn.Double(row["SplitAmt"].ToString());
paySplit.PatNum = PIn.Long(row["PatNum"].ToString());
paySplit.ProcDate = PIn.Date(row["ProcDate"].ToString());
paySplit.PayNum = PIn.Long(row["PayNum"].ToString());
paySplit.IsDiscount = PIn.Bool(row["IsDiscount"].ToString());
paySplit.DiscountType = PIn.Byte(row["DiscountType"].ToString());
paySplit.ProvNum = PIn.Long(row["ProvNum"].ToString());
paySplit.PayPlanNum = PIn.Long(row["PayPlanNum"].ToString());
paySplit.DatePay = PIn.Date(row["DatePay"].ToString());
paySplit.ProcNum = PIn.Long(row["ProcNum"].ToString());
paySplit.DateEntry = PIn.Date(row["DateEntry"].ToString());
paySplit.UnearnedType = PIn.Long(row["UnearnedType"].ToString());
paySplit.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
paySplit.SecUserNumEntry = PIn.Long(row["SecUserNumEntry"].ToString());
paySplit.SecDateTEdit = PIn.DateT(row["SecDateTEdit"].ToString());
paySplit.FSplitNum = PIn.Long(row["FSplitNum"].ToString());
paySplit.AdjNum = PIn.Long(row["AdjNum"].ToString());
paySplit.PayPlanChargeNum = PIn.Long(row["PayPlanChargeNum"].ToString());
retVal.Add(paySplit);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <ClaimTracking> TableToList(DataTable table)
{
List <ClaimTracking> retVal = new List <ClaimTracking>();
ClaimTracking claimTracking;
foreach (DataRow row in table.Rows)
{
claimTracking = new ClaimTracking();
claimTracking.ClaimTrackingNum = PIn.Long(row["ClaimTrackingNum"].ToString());
claimTracking.ClaimNum = PIn.Long(row["ClaimNum"].ToString());
string trackingType = row["TrackingType"].ToString();
if (trackingType == "")
{
claimTracking.TrackingType = (ClaimTrackingType)0;
}
else
{
try{
claimTracking.TrackingType = (ClaimTrackingType)Enum.Parse(typeof(ClaimTrackingType), trackingType);
}
catch {
claimTracking.TrackingType = (ClaimTrackingType)0;
}
}
claimTracking.UserNum = PIn.Long(row["UserNum"].ToString());
claimTracking.DateTimeEntry = PIn.DateT(row["DateTimeEntry"].ToString());
claimTracking.Note = PIn.String(row["Note"].ToString());
claimTracking.TrackingDefNum = PIn.Long(row["TrackingDefNum"].ToString());
claimTracking.TrackingErrorDefNum = PIn.Long(row["TrackingErrorDefNum"].ToString());
retVal.Add(claimTracking);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <RefAttach> TableToList(DataTable table)
{
List <RefAttach> retVal = new List <RefAttach>();
RefAttach refAttach;
foreach (DataRow row in table.Rows)
{
refAttach = new RefAttach();
refAttach.RefAttachNum = PIn.Long(row["RefAttachNum"].ToString());
refAttach.ReferralNum = PIn.Long(row["ReferralNum"].ToString());
refAttach.PatNum = PIn.Long(row["PatNum"].ToString());
refAttach.ItemOrder = PIn.Int(row["ItemOrder"].ToString());
refAttach.RefDate = PIn.Date(row["RefDate"].ToString());
refAttach.RefType = (OpenDentBusiness.ReferralType)PIn.Int(row["RefType"].ToString());
refAttach.RefToStatus = (OpenDentBusiness.ReferralToStatus)PIn.Int(row["RefToStatus"].ToString());
refAttach.Note = PIn.String(row["Note"].ToString());
refAttach.IsTransitionOfCare = PIn.Bool(row["IsTransitionOfCare"].ToString());
refAttach.ProcNum = PIn.Long(row["ProcNum"].ToString());
refAttach.DateProcComplete = PIn.Date(row["DateProcComplete"].ToString());
refAttach.ProvNum = PIn.Long(row["ProvNum"].ToString());
refAttach.DateTStamp = PIn.DateT(row["DateTStamp"].ToString());
retVal.Add(refAttach);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Userod> TableToList(DataTable table)
{
List <Userod> retVal = new List <Userod>();
Userod userod;
foreach (DataRow row in table.Rows)
{
userod = new Userod();
userod.UserNum = PIn.Long(row["UserNum"].ToString());
userod.UserName = PIn.String(row["UserName"].ToString());
userod.Password = PIn.String(row["Password"].ToString());
userod.UserGroupNum = PIn.Long(row["UserGroupNum"].ToString());
userod.EmployeeNum = PIn.Long(row["EmployeeNum"].ToString());
userod.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
userod.ProvNum = PIn.Long(row["ProvNum"].ToString());
userod.IsHidden = PIn.Bool(row["IsHidden"].ToString());
userod.TaskListInBox = PIn.Long(row["TaskListInBox"].ToString());
userod.AnesthProvType = PIn.Int(row["AnesthProvType"].ToString());
userod.DefaultHidePopups = PIn.Bool(row["DefaultHidePopups"].ToString());
userod.PasswordIsStrong = PIn.Bool(row["PasswordIsStrong"].ToString());
userod.ClinicIsRestricted = PIn.Bool(row["ClinicIsRestricted"].ToString());
userod.InboxHidePopups = PIn.Bool(row["InboxHidePopups"].ToString());
userod.UserNumCEMT = PIn.Long(row["UserNumCEMT"].ToString());
userod.DateTFail = PIn.DateT(row["DateTFail"].ToString());
userod.FailedAttempts = PIn.Byte(row["FailedAttempts"].ToString());
userod.DomainUser = PIn.String(row["DomainUser"].ToString());
userod.IsPasswordResetRequired = PIn.Bool(row["IsPasswordResetRequired"].ToString());
retVal.Add(userod);
}
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>
internal static List <Statement> TableToList(DataTable table)
{
List <Statement> retVal = new List <Statement>();
Statement statement;
for (int i = 0; i < table.Rows.Count; i++)
{
statement = new Statement();
statement.StatementNum = PIn.Long(table.Rows[i]["StatementNum"].ToString());
statement.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
statement.DateSent = PIn.Date(table.Rows[i]["DateSent"].ToString());
statement.DateRangeFrom = PIn.Date(table.Rows[i]["DateRangeFrom"].ToString());
statement.DateRangeTo = PIn.Date(table.Rows[i]["DateRangeTo"].ToString());
statement.Note = PIn.String(table.Rows[i]["Note"].ToString());
statement.NoteBold = PIn.String(table.Rows[i]["NoteBold"].ToString());
statement.Mode_ = (StatementMode)PIn.Int(table.Rows[i]["Mode_"].ToString());
statement.HidePayment = PIn.Bool(table.Rows[i]["HidePayment"].ToString());
statement.SinglePatient = PIn.Bool(table.Rows[i]["SinglePatient"].ToString());
statement.Intermingled = PIn.Bool(table.Rows[i]["Intermingled"].ToString());
statement.IsSent = PIn.Bool(table.Rows[i]["IsSent"].ToString());
statement.DocNum = PIn.Long(table.Rows[i]["DocNum"].ToString());
statement.DateTStamp = PIn.DateT(table.Rows[i]["DateTStamp"].ToString());
statement.IsReceipt = PIn.Bool(table.Rows[i]["IsReceipt"].ToString());
retVal.Add(statement);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Adjustment> TableToList(DataTable table)
{
List <Adjustment> retVal = new List <Adjustment>();
Adjustment adjustment;
foreach (DataRow row in table.Rows)
{
adjustment = new Adjustment();
adjustment.AdjNum = PIn.Long(row["AdjNum"].ToString());
adjustment.AdjDate = PIn.Date(row["AdjDate"].ToString());
adjustment.AdjAmt = PIn.Double(row["AdjAmt"].ToString());
adjustment.PatNum = PIn.Long(row["PatNum"].ToString());
adjustment.AdjType = PIn.Long(row["AdjType"].ToString());
adjustment.ProvNum = PIn.Long(row["ProvNum"].ToString());
adjustment.AdjNote = PIn.String(row["AdjNote"].ToString());
adjustment.ProcDate = PIn.Date(row["ProcDate"].ToString());
adjustment.ProcNum = PIn.Long(row["ProcNum"].ToString());
adjustment.DateEntry = PIn.Date(row["DateEntry"].ToString());
adjustment.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
adjustment.StatementNum = PIn.Long(row["StatementNum"].ToString());
adjustment.SecUserNumEntry = PIn.Long(row["SecUserNumEntry"].ToString());
adjustment.SecDateTEdit = PIn.DateT(row["SecDateTEdit"].ToString());
adjustment.TaxTransID = PIn.Long(row["TaxTransID"].ToString());
retVal.Add(adjustment);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Recall> TableToList(DataTable table)
{
List <Recall> retVal = new List <Recall>();
Recall recall;
foreach (DataRow row in table.Rows)
{
recall = new Recall();
recall.RecallNum = PIn.Long(row["RecallNum"].ToString());
recall.PatNum = PIn.Long(row["PatNum"].ToString());
recall.DateDueCalc = PIn.Date(row["DateDueCalc"].ToString());
recall.DateDue = PIn.Date(row["DateDue"].ToString());
recall.DatePrevious = PIn.Date(row["DatePrevious"].ToString());
recall.RecallInterval = new Interval(PIn.Int(row["RecallInterval"].ToString()));
recall.RecallStatus = PIn.Long(row["RecallStatus"].ToString());
recall.Note = PIn.String(row["Note"].ToString());
recall.IsDisabled = PIn.Bool(row["IsDisabled"].ToString());
recall.DateTStamp = PIn.DateT(row["DateTStamp"].ToString());
recall.RecallTypeNum = PIn.Long(row["RecallTypeNum"].ToString());
recall.DisableUntilBalance = PIn.Double(row["DisableUntilBalance"].ToString());
recall.DisableUntilDate = PIn.Date(row["DisableUntilDate"].ToString());
recall.DateScheduled = PIn.Date(row["DateScheduled"].ToString());
recall.Priority = (OpenDentBusiness.RecallPriority)PIn.Int(row["Priority"].ToString());
retVal.Add(recall);
}
return(retVal);
}
