///<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 <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 <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 <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 <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>
internal static List <ComputerPref> TableToList(DataTable table)
{
List <ComputerPref> retVal = new List <ComputerPref>();
ComputerPref computerPref;
for (int i = 0; i < table.Rows.Count; i++)
{
computerPref = new ComputerPref();
computerPref.ComputerPrefNum = PIn.Long(table.Rows[i]["ComputerPrefNum"].ToString());
computerPref.ComputerName = PIn.String(table.Rows[i]["ComputerName"].ToString());
computerPref.GraphicsUseHardware = PIn.Bool(table.Rows[i]["GraphicsUseHardware"].ToString());
computerPref.GraphicsSimple = (DrawingMode)PIn.Int(table.Rows[i]["GraphicsSimple"].ToString());
computerPref.SensorType = PIn.String(table.Rows[i]["SensorType"].ToString());
computerPref.SensorBinned = PIn.Bool(table.Rows[i]["SensorBinned"].ToString());
computerPref.SensorPort = PIn.Int(table.Rows[i]["SensorPort"].ToString());
computerPref.SensorExposure = PIn.Int(table.Rows[i]["SensorExposure"].ToString());
computerPref.GraphicsDoubleBuffering = PIn.Bool(table.Rows[i]["GraphicsDoubleBuffering"].ToString());
computerPref.PreferredPixelFormatNum = PIn.Int(table.Rows[i]["PreferredPixelFormatNum"].ToString());
computerPref.AtoZpath = PIn.String(table.Rows[i]["AtoZpath"].ToString());
computerPref.TaskKeepListHidden = PIn.Bool(table.Rows[i]["TaskKeepListHidden"].ToString());
computerPref.TaskDock = PIn.Int(table.Rows[i]["TaskDock"].ToString());
computerPref.TaskX = PIn.Int(table.Rows[i]["TaskX"].ToString());
computerPref.TaskY = PIn.Int(table.Rows[i]["TaskY"].ToString());
computerPref.DirectXFormat = PIn.String(table.Rows[i]["DirectXFormat"].ToString());
computerPref.RecentApptView = PIn.Byte(table.Rows[i]["RecentApptView"].ToString());
retVal.Add(computerPref);
}
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>
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 <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>
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>
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>
internal static List <Payment> TableToList(DataTable table)
{
List <Payment> retVal = new List <Payment>();
Payment payment;
for (int i = 0; i < table.Rows.Count; i++)
{
payment = new Payment();
payment.PayNum = PIn.Long(table.Rows[i]["PayNum"].ToString());
payment.PayType = PIn.Long(table.Rows[i]["PayType"].ToString());
payment.PayDate = PIn.Date(table.Rows[i]["PayDate"].ToString());
payment.PayAmt = PIn.Double(table.Rows[i]["PayAmt"].ToString());
payment.CheckNum = PIn.String(table.Rows[i]["CheckNum"].ToString());
payment.BankBranch = PIn.String(table.Rows[i]["BankBranch"].ToString());
payment.PayNote = PIn.String(table.Rows[i]["PayNote"].ToString());
payment.IsSplit = PIn.Bool(table.Rows[i]["IsSplit"].ToString());
payment.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
payment.ClinicNum = PIn.Long(table.Rows[i]["ClinicNum"].ToString());
payment.DateEntry = PIn.Date(table.Rows[i]["DateEntry"].ToString());
payment.DepositNum = PIn.Long(table.Rows[i]["DepositNum"].ToString());
payment.Receipt = PIn.String(table.Rows[i]["Receipt"].ToString());
payment.IsRecurringCC = PIn.Bool(table.Rows[i]["IsRecurringCC"].ToString());
retVal.Add(payment);
}
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);
}
///<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 <HL7DefSegment> TableToList(DataTable table)
{
List <HL7DefSegment> retVal = new List <HL7DefSegment>();
HL7DefSegment hL7DefSegment;
for (int i = 0; i < table.Rows.Count; i++)
{
hL7DefSegment = new HL7DefSegment();
hL7DefSegment.HL7DefSegmentNum = PIn.Long(table.Rows[i]["HL7DefSegmentNum"].ToString());
hL7DefSegment.HL7DefMessageNum = PIn.Long(table.Rows[i]["HL7DefMessageNum"].ToString());
hL7DefSegment.ItemOrder = PIn.Int(table.Rows[i]["ItemOrder"].ToString());
hL7DefSegment.CanRepeat = PIn.Bool(table.Rows[i]["CanRepeat"].ToString());
hL7DefSegment.IsOptional = PIn.Bool(table.Rows[i]["IsOptional"].ToString());
string segmentName = table.Rows[i]["SegmentName"].ToString();
if (segmentName == "")
{
hL7DefSegment.SegmentName = (SegmentNameHL7)0;
}
else
{
try{
hL7DefSegment.SegmentName = (SegmentNameHL7)Enum.Parse(typeof(SegmentNameHL7), segmentName);
}
catch {
hL7DefSegment.SegmentName = (SegmentNameHL7)0;
}
}
hL7DefSegment.Note = PIn.String(table.Rows[i]["Note"].ToString());
retVal.Add(hL7DefSegment);
}
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 <ApptView> TableToList(DataTable table)
{
List <ApptView> retVal = new List <ApptView>();
ApptView apptView;
foreach (DataRow row in table.Rows)
{
apptView = new ApptView();
apptView.ApptViewNum = PIn.Long(row["ApptViewNum"].ToString());
apptView.Description = PIn.String(row["Description"].ToString());
apptView.ItemOrder = PIn.Int(row["ItemOrder"].ToString());
apptView.RowsPerIncr = PIn.Byte(row["RowsPerIncr"].ToString());
apptView.OnlyScheduledProvs = PIn.Bool(row["OnlyScheduledProvs"].ToString());
apptView.OnlySchedBeforeTime = PIn.Time(row["OnlySchedBeforeTime"].ToString());
apptView.OnlySchedAfterTime = PIn.Time(row["OnlySchedAfterTime"].ToString());
apptView.StackBehavUR = (OpenDentBusiness.ApptViewStackBehavior)PIn.Int(row["StackBehavUR"].ToString());
apptView.StackBehavLR = (OpenDentBusiness.ApptViewStackBehavior)PIn.Int(row["StackBehavLR"].ToString());
apptView.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
apptView.ApptTimeScrollStart = PIn.Time(row["ApptTimeScrollStart"].ToString());
apptView.IsScrollStartDynamic = PIn.Bool(row["IsScrollStartDynamic"].ToString());
apptView.IsApptBubblesDisabled = PIn.Bool(row["IsApptBubblesDisabled"].ToString());
apptView.WidthOpMinimum = PIn.Int(row["WidthOpMinimum"].ToString());
retVal.Add(apptView);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <RepeatCharge> TableToList(DataTable table)
{
List <RepeatCharge> retVal = new List <RepeatCharge>();
RepeatCharge repeatCharge;
foreach (DataRow row in table.Rows)
{
repeatCharge = new RepeatCharge();
repeatCharge.RepeatChargeNum = PIn.Long(row["RepeatChargeNum"].ToString());
repeatCharge.PatNum = PIn.Long(row["PatNum"].ToString());
repeatCharge.ProcCode = PIn.String(row["ProcCode"].ToString());
repeatCharge.ChargeAmt = PIn.Double(row["ChargeAmt"].ToString());
repeatCharge.DateStart = PIn.Date(row["DateStart"].ToString());
repeatCharge.DateStop = PIn.Date(row["DateStop"].ToString());
repeatCharge.Note = PIn.String(row["Note"].ToString());
repeatCharge.CopyNoteToProc = PIn.Bool(row["CopyNoteToProc"].ToString());
repeatCharge.CreatesClaim = PIn.Bool(row["CreatesClaim"].ToString());
repeatCharge.IsEnabled = PIn.Bool(row["IsEnabled"].ToString());
repeatCharge.UsePrepay = PIn.Bool(row["UsePrepay"].ToString());
repeatCharge.Npi = PIn.String(row["Npi"].ToString());
repeatCharge.ErxAccountId = PIn.String(row["ErxAccountId"].ToString());
repeatCharge.ProviderName = PIn.String(row["ProviderName"].ToString());
retVal.Add(repeatCharge);
}
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 <ApptReminderRule> TableToList(DataTable table)
{
List <ApptReminderRule> retVal = new List <ApptReminderRule>();
ApptReminderRule apptReminderRule;
foreach (DataRow row in table.Rows)
{
apptReminderRule = new ApptReminderRule();
apptReminderRule.ApptReminderRuleNum = PIn.Long(row["ApptReminderRuleNum"].ToString());
apptReminderRule.TypeCur = (OpenDentBusiness.ApptReminderType)PIn.Int(row["TypeCur"].ToString());
apptReminderRule.TSPrior = TimeSpan.FromTicks(PIn.Long(row["TSPrior"].ToString()));
apptReminderRule.SendOrder = PIn.String(row["SendOrder"].ToString());
apptReminderRule.IsSendAll = PIn.Bool(row["IsSendAll"].ToString());
apptReminderRule.TemplateSMS = PIn.String(row["TemplateSMS"].ToString());
apptReminderRule.TemplateEmailSubject = PIn.String(row["TemplateEmailSubject"].ToString());
apptReminderRule.TemplateEmail = PIn.String(row["TemplateEmail"].ToString());
apptReminderRule.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
apptReminderRule.TemplateSMSAggShared = PIn.String(row["TemplateSMSAggShared"].ToString());
apptReminderRule.TemplateSMSAggPerAppt = PIn.String(row["TemplateSMSAggPerAppt"].ToString());
apptReminderRule.TemplateEmailSubjAggShared = PIn.String(row["TemplateEmailSubjAggShared"].ToString());
apptReminderRule.TemplateEmailAggShared = PIn.String(row["TemplateEmailAggShared"].ToString());
apptReminderRule.TemplateEmailAggPerAppt = PIn.String(row["TemplateEmailAggPerAppt"].ToString());
apptReminderRule.DoNotSendWithin = TimeSpan.FromTicks(PIn.Long(row["DoNotSendWithin"].ToString()));
apptReminderRule.IsEnabled = PIn.Bool(row["IsEnabled"].ToString());
apptReminderRule.TemplateAutoReply = PIn.String(row["TemplateAutoReply"].ToString());
apptReminderRule.TemplateAutoReplyAgg = PIn.String(row["TemplateAutoReplyAgg"].ToString());
apptReminderRule.IsAutoReplyEnabled = PIn.Bool(row["IsAutoReplyEnabled"].ToString());
retVal.Add(apptReminderRule);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <Referral> TableToList(DataTable table)
{
List <Referral> retVal = new List <Referral>();
Referral referral;
for (int i = 0; i < table.Rows.Count; i++)
{
referral = new Referral();
referral.ReferralNum = PIn.Long(table.Rows[i]["ReferralNum"].ToString());
referral.LName = PIn.String(table.Rows[i]["LName"].ToString());
referral.FName = PIn.String(table.Rows[i]["FName"].ToString());
referral.MName = PIn.String(table.Rows[i]["MName"].ToString());
referral.SSN = PIn.String(table.Rows[i]["SSN"].ToString());
referral.UsingTIN = PIn.Bool(table.Rows[i]["UsingTIN"].ToString());
referral.Specialty = (DentalSpecialty)PIn.Int(table.Rows[i]["Specialty"].ToString());
referral.ST = PIn.String(table.Rows[i]["ST"].ToString());
referral.Telephone = PIn.String(table.Rows[i]["Telephone"].ToString());
referral.Address = PIn.String(table.Rows[i]["Address"].ToString());
referral.Address2 = PIn.String(table.Rows[i]["Address2"].ToString());
referral.City = PIn.String(table.Rows[i]["City"].ToString());
referral.Zip = PIn.String(table.Rows[i]["Zip"].ToString());
referral.Note = PIn.String(table.Rows[i]["Note"].ToString());
referral.Phone2 = PIn.String(table.Rows[i]["Phone2"].ToString());
referral.IsHidden = PIn.Bool(table.Rows[i]["IsHidden"].ToString());
referral.NotPerson = PIn.Bool(table.Rows[i]["NotPerson"].ToString());
referral.Title = PIn.String(table.Rows[i]["Title"].ToString());
referral.EMail = PIn.String(table.Rows[i]["EMail"].ToString());
referral.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
referral.NationalProvID = PIn.String(table.Rows[i]["NationalProvID"].ToString());
referral.Slip = PIn.Long(table.Rows[i]["Slip"].ToString());
referral.IsDoctor = PIn.Bool(table.Rows[i]["IsDoctor"].ToString());
retVal.Add(referral);
}
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 <Carrier> TableToList(DataTable table)
{
List <Carrier> retVal = new List <Carrier>();
Carrier carrier;
for (int i = 0; i < table.Rows.Count; i++)
{
carrier = new Carrier();
carrier.CarrierNum = PIn.Long(table.Rows[i]["CarrierNum"].ToString());
carrier.CarrierName = PIn.String(table.Rows[i]["CarrierName"].ToString());
carrier.Address = PIn.String(table.Rows[i]["Address"].ToString());
carrier.Address2 = PIn.String(table.Rows[i]["Address2"].ToString());
carrier.City = PIn.String(table.Rows[i]["City"].ToString());
carrier.State = PIn.String(table.Rows[i]["State"].ToString());
carrier.Zip = PIn.String(table.Rows[i]["Zip"].ToString());
carrier.Phone = PIn.String(table.Rows[i]["Phone"].ToString());
carrier.ElectID = PIn.String(table.Rows[i]["ElectID"].ToString());
carrier.NoSendElect = PIn.Bool(table.Rows[i]["NoSendElect"].ToString());
carrier.IsCDA = PIn.Bool(table.Rows[i]["IsCDA"].ToString());
carrier.CDAnetVersion = PIn.String(table.Rows[i]["CDAnetVersion"].ToString());
carrier.CanadianNetworkNum = PIn.Long(table.Rows[i]["CanadianNetworkNum"].ToString());
carrier.IsHidden = PIn.Bool(table.Rows[i]["IsHidden"].ToString());
carrier.CanadianEncryptionMethod = PIn.Byte(table.Rows[i]["CanadianEncryptionMethod"].ToString());
carrier.CanadianSupportedTypes = (CanSupTransTypes)PIn.Int(table.Rows[i]["CanadianSupportedTypes"].ToString());
retVal.Add(carrier);
}
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>
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 <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 <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 <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 <HL7Def> TableToList(DataTable table)
{
List <HL7Def> retVal = new List <HL7Def>();
HL7Def hL7Def;
for (int i = 0; i < table.Rows.Count; i++)
{
hL7Def = new HL7Def();
hL7Def.HL7DefNum = PIn.Long(table.Rows[i]["HL7DefNum"].ToString());
hL7Def.Description = PIn.String(table.Rows[i]["Description"].ToString());
hL7Def.ModeTx = (ModeTxHL7)PIn.Int(table.Rows[i]["ModeTx"].ToString());
hL7Def.IncomingFolder = PIn.String(table.Rows[i]["IncomingFolder"].ToString());
hL7Def.OutgoingFolder = PIn.String(table.Rows[i]["OutgoingFolder"].ToString());
hL7Def.IncomingPort = PIn.String(table.Rows[i]["IncomingPort"].ToString());
hL7Def.OutgoingIpPort = PIn.String(table.Rows[i]["OutgoingIpPort"].ToString());
hL7Def.FieldSeparator = PIn.String(table.Rows[i]["FieldSeparator"].ToString());
hL7Def.ComponentSeparator = PIn.String(table.Rows[i]["ComponentSeparator"].ToString());
hL7Def.SubcomponentSeparator = PIn.String(table.Rows[i]["SubcomponentSeparator"].ToString());
hL7Def.RepetitionSeparator = PIn.String(table.Rows[i]["RepetitionSeparator"].ToString());
hL7Def.EscapeCharacter = PIn.String(table.Rows[i]["EscapeCharacter"].ToString());
hL7Def.IsInternal = PIn.Bool(table.Rows[i]["IsInternal"].ToString());
hL7Def.InternalType = PIn.String(table.Rows[i]["InternalType"].ToString());
hL7Def.InternalTypeVersion = PIn.String(table.Rows[i]["InternalTypeVersion"].ToString());
hL7Def.IsEnabled = PIn.Bool(table.Rows[i]["IsEnabled"].ToString());
hL7Def.Note = PIn.String(table.Rows[i]["Note"].ToString());
hL7Def.HL7Server = PIn.String(table.Rows[i]["HL7Server"].ToString());
hL7Def.HL7ServiceName = PIn.String(table.Rows[i]["HL7ServiceName"].ToString());
hL7Def.ShowDemographics = (HL7ShowDemographics)PIn.Int(table.Rows[i]["ShowDemographics"].ToString());
hL7Def.ShowAppts = PIn.Bool(table.Rows[i]["ShowAppts"].ToString());
hL7Def.ShowAccount = PIn.Bool(table.Rows[i]["ShowAccount"].ToString());
retVal.Add(hL7Def);
}
return(retVal);
}