///<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());
retVal.Add(patientNote);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <PerioMeasure> TableToList(DataTable table)
{
List <PerioMeasure> retVal = new List <PerioMeasure>();
PerioMeasure perioMeasure;
for (int i = 0; i < table.Rows.Count; i++)
{
perioMeasure = new PerioMeasure();
perioMeasure.PerioMeasureNum = PIn.Long(table.Rows[i]["PerioMeasureNum"].ToString());
perioMeasure.PerioExamNum = PIn.Long(table.Rows[i]["PerioExamNum"].ToString());
perioMeasure.SequenceType = (PerioSequenceType)PIn.Int(table.Rows[i]["SequenceType"].ToString());
perioMeasure.IntTooth = PIn.Int(table.Rows[i]["IntTooth"].ToString());
perioMeasure.ToothValue = PIn.Int(table.Rows[i]["ToothValue"].ToString());
perioMeasure.MBvalue = PIn.Int(table.Rows[i]["MBvalue"].ToString());
perioMeasure.Bvalue = PIn.Int(table.Rows[i]["Bvalue"].ToString());
perioMeasure.DBvalue = PIn.Int(table.Rows[i]["DBvalue"].ToString());
perioMeasure.MLvalue = PIn.Int(table.Rows[i]["MLvalue"].ToString());
perioMeasure.Lvalue = PIn.Int(table.Rows[i]["Lvalue"].ToString());
perioMeasure.DLvalue = PIn.Int(table.Rows[i]["DLvalue"].ToString());
retVal.Add(perioMeasure);
}
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());
retVal.Add(sheetDef);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <Clinic> TableToList(DataTable table)
{
List <Clinic> retVal = new List <Clinic>();
Clinic clinic;
for (int i = 0; i < table.Rows.Count; i++)
{
clinic = new Clinic();
clinic.ClinicNum = PIn.Long(table.Rows[i]["ClinicNum"].ToString());
clinic.Description = PIn.String(table.Rows[i]["Description"].ToString());
clinic.Address = PIn.String(table.Rows[i]["Address"].ToString());
clinic.Address2 = PIn.String(table.Rows[i]["Address2"].ToString());
clinic.City = PIn.String(table.Rows[i]["City"].ToString());
clinic.State = PIn.String(table.Rows[i]["State"].ToString());
clinic.Zip = PIn.String(table.Rows[i]["Zip"].ToString());
clinic.Phone = PIn.String(table.Rows[i]["Phone"].ToString());
clinic.BankNumber = PIn.String(table.Rows[i]["BankNumber"].ToString());
clinic.DefaultPlaceService = (PlaceOfService)PIn.Int(table.Rows[i]["DefaultPlaceService"].ToString());
clinic.InsBillingProv = PIn.Long(table.Rows[i]["InsBillingProv"].ToString());
retVal.Add(clinic);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <ChartView> TableToList(DataTable table)
{
List <ChartView> retVal = new List <ChartView>();
ChartView chartView;
foreach (DataRow row in table.Rows)
{
chartView = new ChartView();
chartView.ChartViewNum = PIn.Long(row["ChartViewNum"].ToString());
chartView.Description = PIn.String(row["Description"].ToString());
chartView.ItemOrder = PIn.Int(row["ItemOrder"].ToString());
chartView.ProcStatuses = (OpenDentBusiness.ChartViewProcStat)PIn.Int(row["ProcStatuses"].ToString());
chartView.ObjectTypes = (OpenDentBusiness.ChartViewObjs)PIn.Int(row["ObjectTypes"].ToString());
chartView.ShowProcNotes = PIn.Bool(row["ShowProcNotes"].ToString());
chartView.IsAudit = PIn.Bool(row["IsAudit"].ToString());
chartView.SelectedTeethOnly = PIn.Bool(row["SelectedTeethOnly"].ToString());
chartView.OrionStatusFlags = (OpenDentBusiness.OrionStatus)PIn.Int(row["OrionStatusFlags"].ToString());
chartView.DatesShowing = (OpenDentBusiness.ChartViewDates)PIn.Int(row["DatesShowing"].ToString());
chartView.IsTpCharting = PIn.Bool(row["IsTpCharting"].ToString());
retVal.Add(chartView);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <PhoneEmpDefault> TableToList(DataTable table)
{
List <PhoneEmpDefault> retVal = new List <PhoneEmpDefault>();
PhoneEmpDefault phoneEmpDefault;
for (int i = 0; i < table.Rows.Count; i++)
{
phoneEmpDefault = new PhoneEmpDefault();
phoneEmpDefault.EmployeeNum = PIn.Long(table.Rows[i]["EmployeeNum"].ToString());
phoneEmpDefault.IsGraphed = PIn.Bool(table.Rows[i]["IsGraphed"].ToString());
phoneEmpDefault.HasColor = PIn.Bool(table.Rows[i]["HasColor"].ToString());
phoneEmpDefault.RingGroups = (AsteriskRingGroups)PIn.Int(table.Rows[i]["RingGroups"].ToString());
phoneEmpDefault.EmpName = PIn.String(table.Rows[i]["EmpName"].ToString());
phoneEmpDefault.PhoneExt = PIn.Int(table.Rows[i]["PhoneExt"].ToString());
phoneEmpDefault.StatusOverride = (PhoneEmpStatusOverride)PIn.Int(table.Rows[i]["StatusOverride"].ToString());
phoneEmpDefault.Notes = PIn.String(table.Rows[i]["Notes"].ToString());
phoneEmpDefault.ComputerName = PIn.String(table.Rows[i]["ComputerName"].ToString());
phoneEmpDefault.IsPrivateScreen = PIn.Bool(table.Rows[i]["IsPrivateScreen"].ToString());
phoneEmpDefault.IsTriageOperator = PIn.Bool(table.Rows[i]["IsTriageOperator"].ToString());
retVal.Add(phoneEmpDefault);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <InsVerify> TableToList(DataTable table)
{
List <InsVerify> retVal = new List <InsVerify>();
InsVerify insVerify;
foreach (DataRow row in table.Rows)
{
insVerify = new InsVerify();
insVerify.InsVerifyNum = PIn.Long(row["InsVerifyNum"].ToString());
insVerify.DateLastVerified = PIn.Date(row["DateLastVerified"].ToString());
insVerify.UserNum = PIn.Long(row["UserNum"].ToString());
insVerify.VerifyType = (OpenDentBusiness.VerifyTypes)PIn.Int(row["VerifyType"].ToString());
insVerify.FKey = PIn.Long(row["FKey"].ToString());
insVerify.DefNum = PIn.Long(row["DefNum"].ToString());
insVerify.DateLastAssigned = PIn.Date(row["DateLastAssigned"].ToString());
insVerify.Note = PIn.String(row["Note"].ToString());
insVerify.DateTimeEntry = PIn.DateT(row["DateTimeEntry"].ToString());
insVerify.HoursAvailableForVerification = PIn.Double(row["HoursAvailableForVerification"].ToString());
insVerify.SecDateTEdit = PIn.DateT(row["SecDateTEdit"].ToString());
retVal.Add(insVerify);
}
return(retVal);
}
/// <summary>A simple get request that saves XVWeb Id's for the object it is getting</summary>
private static List <long> GetRequestIds(string token, UriBuilder url, int nextRecord = 0)
{
UriBuilder newUriBuilder = new UriBuilder(url.ToString());
if (nextRecord > 0)
{
newUriBuilder.Query += (newUriBuilder.Query == "" ? "" : "&") + "NextRecord=" + nextRecord;
}
string serverResp = GetRequestHelper(token, newUriBuilder);
//parse recieved data to get the token
object rsp = JsonConvert.DeserializeObject(serverResp);
JToken parseResp = JToken.Parse(rsp.ToString());
JToken records = parseResp["Records"];
List <long> listIds = records.Select(x => PIn.Long(x["Id"].ToString())).ToList();
int newNextRecord = PIn.Int(parseResp["NextRecord"].ToString());
if (newNextRecord > 0 && newNextRecord <= PIn.Long(parseResp["TotalRecords"].ToString()))
{
//we know there is another page of records
listIds.AddRange(GetRequestIds(token, url, newNextRecord)); //Recursively call ourselves
}
return(listIds);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <PerioMeasure> TableToList(DataTable table)
{
List <PerioMeasure> retVal = new List <PerioMeasure>();
PerioMeasure perioMeasure;
foreach (DataRow row in table.Rows)
{
perioMeasure = new PerioMeasure();
perioMeasure.PerioMeasureNum = PIn.Long(row["PerioMeasureNum"].ToString());
perioMeasure.PerioExamNum = PIn.Long(row["PerioExamNum"].ToString());
perioMeasure.SequenceType = (OpenDentBusiness.PerioSequenceType)PIn.Int(row["SequenceType"].ToString());
perioMeasure.IntTooth = PIn.Int(row["IntTooth"].ToString());
perioMeasure.ToothValue = PIn.Int(row["ToothValue"].ToString());
perioMeasure.MBvalue = PIn.Int(row["MBvalue"].ToString());
perioMeasure.Bvalue = PIn.Int(row["Bvalue"].ToString());
perioMeasure.DBvalue = PIn.Int(row["DBvalue"].ToString());
perioMeasure.MLvalue = PIn.Int(row["MLvalue"].ToString());
perioMeasure.Lvalue = PIn.Int(row["Lvalue"].ToString());
perioMeasure.DLvalue = PIn.Int(row["DLvalue"].ToString());
retVal.Add(perioMeasure);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <EhrAmendment> TableToList(DataTable table)
{
List <EhrAmendment> retVal = new List <EhrAmendment>();
EhrAmendment ehrAmendment;
for (int i = 0; i < table.Rows.Count; i++)
{
ehrAmendment = new EhrAmendment();
ehrAmendment.EhrAmendmentNum = PIn.Long(table.Rows[i]["EhrAmendmentNum"].ToString());
ehrAmendment.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
ehrAmendment.IsAccepted = (YN)PIn.Int(table.Rows[i]["IsAccepted"].ToString());
ehrAmendment.Description = PIn.String(table.Rows[i]["Description"].ToString());
ehrAmendment.Source = (AmendmentSource)PIn.Int(table.Rows[i]["Source"].ToString());
ehrAmendment.SourceName = PIn.String(table.Rows[i]["SourceName"].ToString());
ehrAmendment.FileName = PIn.String(table.Rows[i]["FileName"].ToString());
ehrAmendment.RawBase64 = PIn.String(table.Rows[i]["RawBase64"].ToString());
ehrAmendment.DateTRequest = PIn.DateT(table.Rows[i]["DateTRequest"].ToString());
ehrAmendment.DateTAcceptDeny = PIn.DateT(table.Rows[i]["DateTAcceptDeny"].ToString());
ehrAmendment.DateTAppend = PIn.DateT(table.Rows[i]["DateTAppend"].ToString());
retVal.Add(ehrAmendment);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <ProviderErx> TableToList(DataTable table)
{
List <ProviderErx> retVal = new List <ProviderErx>();
ProviderErx providerErx;
foreach (DataRow row in table.Rows)
{
providerErx = new ProviderErx();
providerErx.ProviderErxNum = PIn.Long(row["ProviderErxNum"].ToString());
providerErx.PatNum = PIn.Long(row["PatNum"].ToString());
providerErx.NationalProviderID = PIn.String(row["NationalProviderID"].ToString());
providerErx.IsEnabled = (OpenDentBusiness.ErxStatus)PIn.Int(row["IsEnabled"].ToString());
providerErx.IsIdentifyProofed = PIn.Bool(row["IsIdentifyProofed"].ToString());
providerErx.IsSentToHq = PIn.Bool(row["IsSentToHq"].ToString());
providerErx.IsEpcs = PIn.Bool(row["IsEpcs"].ToString());
providerErx.ErxType = (OpenDentBusiness.ErxOption)PIn.Int(row["ErxType"].ToString());
providerErx.UserId = PIn.String(row["UserId"].ToString());
providerErx.AccountId = PIn.String(row["AccountId"].ToString());
providerErx.RegistrationKeyNum = PIn.Long(row["RegistrationKeyNum"].ToString());
retVal.Add(providerErx);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <Schedule> TableToList(DataTable table)
{
List <Schedule> retVal = new List <Schedule>();
Schedule schedule;
for (int i = 0; i < table.Rows.Count; i++)
{
schedule = new Schedule();
schedule.ScheduleNum = PIn.Long(table.Rows[i]["ScheduleNum"].ToString());
schedule.SchedDate = PIn.Date(table.Rows[i]["SchedDate"].ToString());
schedule.StartTime = PIn.Time(table.Rows[i]["StartTime"].ToString());
schedule.StopTime = PIn.Time(table.Rows[i]["StopTime"].ToString());
schedule.SchedType = (ScheduleType)PIn.Int(table.Rows[i]["SchedType"].ToString());
schedule.ProvNum = PIn.Long(table.Rows[i]["ProvNum"].ToString());
schedule.BlockoutType = PIn.Long(table.Rows[i]["BlockoutType"].ToString());
schedule.Note = PIn.String(table.Rows[i]["Note"].ToString());
schedule.Status = (SchedStatus)PIn.Int(table.Rows[i]["Status"].ToString());
schedule.EmployeeNum = PIn.Long(table.Rows[i]["EmployeeNum"].ToString());
schedule.DateTStamp = PIn.DateT(table.Rows[i]["DateTStamp"].ToString());
retVal.Add(schedule);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Dunning> TableToList(DataTable table)
{
List <Dunning> retVal = new List <Dunning>();
Dunning dunning;
foreach (DataRow row in table.Rows)
{
dunning = new Dunning();
dunning.DunningNum = PIn.Long(row["DunningNum"].ToString());
dunning.DunMessage = PIn.String(row["DunMessage"].ToString());
dunning.BillingType = PIn.Long(row["BillingType"].ToString());
dunning.AgeAccount = PIn.Byte(row["AgeAccount"].ToString());
dunning.InsIsPending = (OpenDentBusiness.YN)PIn.Int(row["InsIsPending"].ToString());
dunning.MessageBold = PIn.String(row["MessageBold"].ToString());
dunning.EmailSubject = PIn.String(row["EmailSubject"].ToString());
dunning.EmailBody = PIn.String(row["EmailBody"].ToString());
dunning.DaysInAdvance = PIn.Int(row["DaysInAdvance"].ToString());
dunning.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
dunning.IsSuperFamily = PIn.Bool(row["IsSuperFamily"].ToString());
retVal.Add(dunning);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <TaskList> TableToList(DataTable table)
{
List <TaskList> retVal = new List <TaskList>();
TaskList taskList;
foreach (DataRow row in table.Rows)
{
taskList = new TaskList();
taskList.TaskListNum = PIn.Long(row["TaskListNum"].ToString());
taskList.Descript = PIn.String(row["Descript"].ToString());
taskList.Parent = PIn.Long(row["Parent"].ToString());
taskList.DateTL = PIn.Date(row["DateTL"].ToString());
taskList.IsRepeating = PIn.Bool(row["IsRepeating"].ToString());
taskList.DateType = (OpenDentBusiness.TaskDateType)PIn.Int(row["DateType"].ToString());
taskList.FromNum = PIn.Long(row["FromNum"].ToString());
taskList.ObjectType = (OpenDentBusiness.TaskObjectType)PIn.Int(row["ObjectType"].ToString());
taskList.DateTimeEntry = PIn.DateT(row["DateTimeEntry"].ToString());
taskList.GlobalTaskFilterType = (OpenDentBusiness.GlobalTaskFilterType)PIn.Int(row["GlobalTaskFilterType"].ToString());
taskList.TaskListStatus = (OpenDentBusiness.TaskListStatusEnum)PIn.Int(row["TaskListStatus"].ToString());
retVal.Add(taskList);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <ClaimForm> TableToList(DataTable table)
{
List <ClaimForm> retVal = new List <ClaimForm>();
ClaimForm claimForm;
foreach (DataRow row in table.Rows)
{
claimForm = new ClaimForm();
claimForm.ClaimFormNum = PIn.Long(row["ClaimFormNum"].ToString());
claimForm.Description = PIn.String(row["Description"].ToString());
claimForm.IsHidden = PIn.Bool(row["IsHidden"].ToString());
claimForm.FontName = PIn.String(row["FontName"].ToString());
claimForm.FontSize = PIn.Float(row["FontSize"].ToString());
claimForm.UniqueID = PIn.String(row["UniqueID"].ToString());
claimForm.PrintImages = PIn.Bool(row["PrintImages"].ToString());
claimForm.OffsetX = PIn.Int(row["OffsetX"].ToString());
claimForm.OffsetY = PIn.Int(row["OffsetY"].ToString());
claimForm.Width = PIn.Int(row["Width"].ToString());
claimForm.Height = PIn.Int(row["Height"].ToString());
retVal.Add(claimForm);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Automation> TableToList(DataTable table)
{
List <Automation> retVal = new List <Automation>();
Automation automation;
foreach (DataRow row in table.Rows)
{
automation = new Automation();
automation.AutomationNum = PIn.Long(row["AutomationNum"].ToString());
automation.Description = PIn.String(row["Description"].ToString());
automation.Autotrigger = (OpenDentBusiness.AutomationTrigger)PIn.Int(row["Autotrigger"].ToString());
automation.ProcCodes = PIn.String(row["ProcCodes"].ToString());
automation.AutoAction = (OpenDentBusiness.AutomationAction)PIn.Int(row["AutoAction"].ToString());
automation.SheetDefNum = PIn.Long(row["SheetDefNum"].ToString());
automation.CommType = PIn.Long(row["CommType"].ToString());
automation.MessageContent = PIn.String(row["MessageContent"].ToString());
automation.AptStatus = (OpenDentBusiness.ApptStatus)PIn.Int(row["AptStatus"].ToString());
automation.AppointmentTypeNum = PIn.Long(row["AppointmentTypeNum"].ToString());
automation.PatStatus = (OpenDentBusiness.PatientStatus)PIn.Int(row["PatStatus"].ToString());
retVal.Add(automation);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <EhrAmendment> TableToList(DataTable table)
{
List <EhrAmendment> retVal = new List <EhrAmendment>();
EhrAmendment ehrAmendment;
foreach (DataRow row in table.Rows)
{
ehrAmendment = new EhrAmendment();
ehrAmendment.EhrAmendmentNum = PIn.Long(row["EhrAmendmentNum"].ToString());
ehrAmendment.PatNum = PIn.Long(row["PatNum"].ToString());
ehrAmendment.IsAccepted = (OpenDentBusiness.YN)PIn.Int(row["IsAccepted"].ToString());
ehrAmendment.Description = PIn.String(row["Description"].ToString());
ehrAmendment.Source = (OpenDentBusiness.AmendmentSource)PIn.Int(row["Source"].ToString());
ehrAmendment.SourceName = PIn.String(row["SourceName"].ToString());
ehrAmendment.FileName = PIn.String(row["FileName"].ToString());
ehrAmendment.RawBase64 = PIn.String(row["RawBase64"].ToString());
ehrAmendment.DateTRequest = PIn.DateT(row["DateTRequest"].ToString());
ehrAmendment.DateTAcceptDeny = PIn.DateT(row["DateTAcceptDeny"].ToString());
ehrAmendment.DateTAppend = PIn.DateT(row["DateTAppend"].ToString());
retVal.Add(ehrAmendment);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <CentralConnection> TableToList(DataTable table)
{
List <CentralConnection> retVal = new List <CentralConnection>();
CentralConnection centralConnection;
for (int i = 0; i < table.Rows.Count; i++)
{
centralConnection = new CentralConnection();
centralConnection.CentralConnectionNum = PIn.Long(table.Rows[i]["CentralConnectionNum"].ToString());
centralConnection.ServerName = PIn.String(table.Rows[i]["ServerName"].ToString());
centralConnection.DatabaseName = PIn.String(table.Rows[i]["DatabaseName"].ToString());
centralConnection.MySqlUser = PIn.String(table.Rows[i]["MySqlUser"].ToString());
centralConnection.MySqlPassword = PIn.String(table.Rows[i]["MySqlPassword"].ToString());
centralConnection.ServiceURI = PIn.String(table.Rows[i]["ServiceURI"].ToString());
centralConnection.OdUser = PIn.String(table.Rows[i]["OdUser"].ToString());
centralConnection.OdPassword = PIn.String(table.Rows[i]["OdPassword"].ToString());
centralConnection.Note = PIn.String(table.Rows[i]["Note"].ToString());
centralConnection.ItemOrder = PIn.Int(table.Rows[i]["ItemOrder"].ToString());
centralConnection.WebServiceIsEcw = PIn.Bool(table.Rows[i]["WebServiceIsEcw"].ToString());
retVal.Add(centralConnection);
}
return(retVal);
}
private void textJumpToPage_KeyUp(object sender, KeyEventArgs e)
{
int newPage = 0;
switch (e.KeyCode)
{
case Keys.Left:
newPage = (_pageCur - 1); //Safe even if value is not valid page.
break;
case Keys.Right:
newPage = (_pageCur + 1); //Safe even if value is not valid page.;
break;
case Keys.Enter:
newPage = PIn.Int(textJumpToPage.Text, false); //Safe even if value is not valid page.
break;
default:
return;
}
Grid.NavigateToPage(newPage);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <RefAttach> TableToList(DataTable table)
{
List <RefAttach> retVal = new List <RefAttach>();
RefAttach refAttach;
for (int i = 0; i < table.Rows.Count; i++)
{
refAttach = new RefAttach();
refAttach.RefAttachNum = PIn.Long(table.Rows[i]["RefAttachNum"].ToString());
refAttach.ReferralNum = PIn.Long(table.Rows[i]["ReferralNum"].ToString());
refAttach.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
refAttach.ItemOrder = PIn.Int(table.Rows[i]["ItemOrder"].ToString());
refAttach.RefDate = PIn.Date(table.Rows[i]["RefDate"].ToString());
refAttach.IsFrom = PIn.Bool(table.Rows[i]["IsFrom"].ToString());
refAttach.RefToStatus = (ReferralToStatus)PIn.Int(table.Rows[i]["RefToStatus"].ToString());
refAttach.Note = PIn.String(table.Rows[i]["Note"].ToString());
refAttach.IsTransitionOfCare = PIn.Bool(table.Rows[i]["IsTransitionOfCare"].ToString());
refAttach.ProcNum = PIn.Long(table.Rows[i]["ProcNum"].ToString());
refAttach.DateProcComplete = PIn.Date(table.Rows[i]["DateProcComplete"].ToString());
retVal.Add(refAttach);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <WebSchedRecall> TableToList(DataTable table)
{
List <WebSchedRecall> retVal = new List <WebSchedRecall>();
WebSchedRecall webSchedRecall;
foreach (DataRow row in table.Rows)
{
webSchedRecall = new WebSchedRecall();
webSchedRecall.WebSchedRecallNum = PIn.Long(row["WebSchedRecallNum"].ToString());
webSchedRecall.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
webSchedRecall.PatNum = PIn.Long(row["PatNum"].ToString());
webSchedRecall.RecallNum = PIn.Long(row["RecallNum"].ToString());
webSchedRecall.DateTimeEntry = PIn.DateT(row["DateTimeEntry"].ToString());
webSchedRecall.DateDue = PIn.Date(row["DateDue"].ToString());
webSchedRecall.ReminderCount = PIn.Int(row["ReminderCount"].ToString());
webSchedRecall.PreferRecallMethod = (OpenDentBusiness.ContactMethod)PIn.Int(row["PreferRecallMethod"].ToString());
webSchedRecall.DateTimeReminderSent = PIn.DateT(row["DateTimeReminderSent"].ToString());
webSchedRecall.DateTimeSendFailed = PIn.DateT(row["DateTimeSendFailed"].ToString());
webSchedRecall.EmailSendStatus = (OpenDentBusiness.AutoCommStatus)PIn.Int(row["EmailSendStatus"].ToString());
webSchedRecall.SmsSendStatus = (OpenDentBusiness.AutoCommStatus)PIn.Int(row["SmsSendStatus"].ToString());
webSchedRecall.PhonePat = PIn.String(row["PhonePat"].ToString());
webSchedRecall.EmailPat = PIn.String(row["EmailPat"].ToString());
webSchedRecall.MsgTextToMobileTemplate = PIn.String(row["MsgTextToMobileTemplate"].ToString());
webSchedRecall.MsgTextToMobile = PIn.String(row["MsgTextToMobile"].ToString());
webSchedRecall.EmailSubjTemplate = PIn.String(row["EmailSubjTemplate"].ToString());
webSchedRecall.EmailSubj = PIn.String(row["EmailSubj"].ToString());
webSchedRecall.EmailTextTemplate = PIn.String(row["EmailTextTemplate"].ToString());
webSchedRecall.EmailText = PIn.String(row["EmailText"].ToString());
webSchedRecall.GuidMessageToMobile = PIn.String(row["GuidMessageToMobile"].ToString());
webSchedRecall.ShortGUIDSms = PIn.String(row["ShortGUIDSms"].ToString());
webSchedRecall.ShortGUIDEmail = PIn.String(row["ShortGUIDEmail"].ToString());
webSchedRecall.ResponseDescript = PIn.String(row["ResponseDescript"].ToString());
webSchedRecall.Source = (OpenDentBusiness.WebSchedRecallSource)PIn.Int(row["Source"].ToString());
retVal.Add(webSchedRecall);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <SheetField> TableToList(DataTable table)
{
List <SheetField> retVal = new List <SheetField>();
SheetField sheetField;
foreach (DataRow row in table.Rows)
{
sheetField = new SheetField();
sheetField.SheetFieldNum = PIn.Long(row["SheetFieldNum"].ToString());
sheetField.SheetNum = PIn.Long(row["SheetNum"].ToString());
sheetField.FieldType = (OpenDentBusiness.SheetFieldType)PIn.Int(row["FieldType"].ToString());
sheetField.FieldName = PIn.String(row["FieldName"].ToString());
sheetField.FieldValue = PIn.String(row["FieldValue"].ToString());
sheetField.FontSize = PIn.Float(row["FontSize"].ToString());
sheetField.FontName = PIn.String(row["FontName"].ToString());
sheetField.FontIsBold = PIn.Bool(row["FontIsBold"].ToString());
sheetField.XPos = PIn.Int(row["XPos"].ToString());
sheetField.YPos = PIn.Int(row["YPos"].ToString());
sheetField.Width = PIn.Int(row["Width"].ToString());
sheetField.Height = PIn.Int(row["Height"].ToString());
sheetField.GrowthBehavior = (OpenDentBusiness.GrowthBehaviorEnum)PIn.Int(row["GrowthBehavior"].ToString());
sheetField.RadioButtonValue = PIn.String(row["RadioButtonValue"].ToString());
sheetField.RadioButtonGroup = PIn.String(row["RadioButtonGroup"].ToString());
sheetField.IsRequired = PIn.Bool(row["IsRequired"].ToString());
sheetField.TabOrder = PIn.Int(row["TabOrder"].ToString());
sheetField.ReportableName = PIn.String(row["ReportableName"].ToString());
sheetField.TextAlign = (System.Windows.Forms.HorizontalAlignment)PIn.Int(row["TextAlign"].ToString());
sheetField.IsLocked = PIn.Bool(row["IsLocked"].ToString());
sheetField.ItemColor = Color.FromArgb(PIn.Int(row["ItemColor"].ToString()));
sheetField.DateTimeSig = PIn.DateT(row["DateTimeSig"].ToString());
sheetField.TabOrderMobile = PIn.Int(row["TabOrderMobile"].ToString());
sheetField.UiLabelMobile = PIn.String(row["UiLabelMobile"].ToString());
sheetField.UiLabelMobileRadioButton = PIn.String(row["UiLabelMobileRadioButton"].ToString());
retVal.Add(sheetField);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <Clearinghouse> TableToList(DataTable table)
{
List <Clearinghouse> retVal = new List <Clearinghouse>();
Clearinghouse clearinghouse;
for (int i = 0; i < table.Rows.Count; i++)
{
clearinghouse = new Clearinghouse();
clearinghouse.ClearinghouseNum = PIn.Long(table.Rows[i]["ClearinghouseNum"].ToString());
clearinghouse.Description = PIn.String(table.Rows[i]["Description"].ToString());
clearinghouse.ExportPath = PIn.String(table.Rows[i]["ExportPath"].ToString());
clearinghouse.Payors = PIn.String(table.Rows[i]["Payors"].ToString());
clearinghouse.Eformat = (ElectronicClaimFormat)PIn.Int(table.Rows[i]["Eformat"].ToString());
clearinghouse.ISA05 = PIn.String(table.Rows[i]["ISA05"].ToString());
clearinghouse.SenderTIN = PIn.String(table.Rows[i]["SenderTIN"].ToString());
clearinghouse.ISA07 = PIn.String(table.Rows[i]["ISA07"].ToString());
clearinghouse.ISA08 = PIn.String(table.Rows[i]["ISA08"].ToString());
clearinghouse.ISA15 = PIn.String(table.Rows[i]["ISA15"].ToString());
clearinghouse.Password = PIn.String(table.Rows[i]["Password"].ToString());
clearinghouse.ResponsePath = PIn.String(table.Rows[i]["ResponsePath"].ToString());
clearinghouse.CommBridge = (EclaimsCommBridge)PIn.Int(table.Rows[i]["CommBridge"].ToString());
clearinghouse.ClientProgram = PIn.String(table.Rows[i]["ClientProgram"].ToString());
clearinghouse.LastBatchNumber = PIn.Int(table.Rows[i]["LastBatchNumber"].ToString());
clearinghouse.ModemPort = PIn.Byte(table.Rows[i]["ModemPort"].ToString());
clearinghouse.LoginID = PIn.String(table.Rows[i]["LoginID"].ToString());
clearinghouse.SenderName = PIn.String(table.Rows[i]["SenderName"].ToString());
clearinghouse.SenderTelephone = PIn.String(table.Rows[i]["SenderTelephone"].ToString());
clearinghouse.GS03 = PIn.String(table.Rows[i]["GS03"].ToString());
clearinghouse.ISA02 = PIn.String(table.Rows[i]["ISA02"].ToString());
clearinghouse.ISA04 = PIn.String(table.Rows[i]["ISA04"].ToString());
clearinghouse.ISA16 = PIn.String(table.Rows[i]["ISA16"].ToString());
clearinghouse.SeparatorData = PIn.String(table.Rows[i]["SeparatorData"].ToString());
clearinghouse.SeparatorSegment = PIn.String(table.Rows[i]["SeparatorSegment"].ToString());
retVal.Add(clearinghouse);
}
return(retVal);
}
private void butSync_Click(object sender, EventArgs e)
{
if (textDate.errorProvider1.GetError(textDate) != "")
{
MsgBox.Show(this, "Please fix error first.");
return;
}
//Enter info into local DB before pushing out to others so we save it.
int days = PIn.Int(textDays.Text);
DateTime date = PIn.Date(textDate.Text);
Prefs.UpdateString(PrefName.SecurityLockDate, POut.Date(date, false));
Prefs.UpdateInt(PrefName.SecurityLockDays, days);
Prefs.UpdateBool(PrefName.SecurityLockIncludesAdmin, checkAdmin.Checked);
Prefs.UpdateBool(PrefName.CentralManagerSecurityLock, checkEnable.Checked);
FormCentralConnections FormCC = new FormCentralConnections();
FormCC.LabelText.Text = Lans.g("CentralSecurity", "Sync will create or update the Central Management users, passwords, and user groups to all selected databases.");
FormCC.Text = Lans.g("CentralSecurity", "Sync Security");
foreach (CentralConnection conn in ListConns)
{
FormCC.ListConns.Add(conn.Copy());
}
List <CentralConnection> listSelectedConns = new List <CentralConnection>();
if (FormCC.ShowDialog() == DialogResult.OK)
{
listSelectedConns = FormCC.ListConns;
}
else
{
return;
}
MsgBoxCopyPaste MsgBoxCopyPaste = new MsgBoxCopyPaste(CentralSyncHelper.SyncAll(listSelectedConns));
MsgBoxCopyPaste.ShowDialog();
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <PhoneEmpDefault> TableToList(DataTable table)
{
List <PhoneEmpDefault> retVal = new List <PhoneEmpDefault>();
PhoneEmpDefault phoneEmpDefault;
foreach (DataRow row in table.Rows)
{
phoneEmpDefault = new PhoneEmpDefault();
phoneEmpDefault.EmployeeNum = PIn.Long(row["EmployeeNum"].ToString());
phoneEmpDefault.IsGraphed = PIn.Bool(row["IsGraphed"].ToString());
phoneEmpDefault.HasColor = PIn.Bool(row["HasColor"].ToString());
phoneEmpDefault.RingGroups = (OpenDentBusiness.AsteriskQueues)PIn.Int(row["RingGroups"].ToString());
phoneEmpDefault.EmpName = PIn.String(row["EmpName"].ToString());
phoneEmpDefault.PhoneExt = PIn.Int(row["PhoneExt"].ToString());
phoneEmpDefault.StatusOverride = (OpenDentBusiness.PhoneEmpStatusOverride)PIn.Int(row["StatusOverride"].ToString());
phoneEmpDefault.Notes = PIn.String(row["Notes"].ToString());
phoneEmpDefault.IsPrivateScreen = PIn.Bool(row["IsPrivateScreen"].ToString());
phoneEmpDefault.IsTriageOperator = PIn.Bool(row["IsTriageOperator"].ToString());
phoneEmpDefault.EscalationOrder = PIn.Int(row["EscalationOrder"].ToString());
phoneEmpDefault.SiteNum = PIn.Long(row["SiteNum"].ToString());
retVal.Add(phoneEmpDefault);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <EmailMessage> TableToList(DataTable table)
{
List <EmailMessage> retVal = new List <EmailMessage>();
EmailMessage emailMessage;
for (int i = 0; i < table.Rows.Count; i++)
{
emailMessage = new EmailMessage();
emailMessage.EmailMessageNum = PIn.Long(table.Rows[i]["EmailMessageNum"].ToString());
emailMessage.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
emailMessage.ToAddress = PIn.String(table.Rows[i]["ToAddress"].ToString());
emailMessage.FromAddress = PIn.String(table.Rows[i]["FromAddress"].ToString());
emailMessage.Subject = PIn.String(table.Rows[i]["Subject"].ToString());
emailMessage.BodyText = PIn.String(table.Rows[i]["BodyText"].ToString());
emailMessage.MsgDateTime = PIn.DateT(table.Rows[i]["MsgDateTime"].ToString());
emailMessage.SentOrReceived = (EmailSentOrReceived)PIn.Int(table.Rows[i]["SentOrReceived"].ToString());
emailMessage.RecipientAddress = PIn.String(table.Rows[i]["RecipientAddress"].ToString());
emailMessage.RawEmailIn = PIn.String(table.Rows[i]["RawEmailIn"].ToString());
emailMessage.ProvNumWebMail = PIn.Long(table.Rows[i]["ProvNumWebMail"].ToString());
emailMessage.PatNumSubj = PIn.Long(table.Rows[i]["PatNumSubj"].ToString());
retVal.Add(emailMessage);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <SigMessage> TableToList(DataTable table)
{
List <SigMessage> retVal = new List <SigMessage>();
SigMessage sigMessage;
foreach (DataRow row in table.Rows)
{
sigMessage = new SigMessage();
sigMessage.SigMessageNum = PIn.Long(row["SigMessageNum"].ToString());
sigMessage.ButtonText = PIn.String(row["ButtonText"].ToString());
sigMessage.ButtonIndex = PIn.Int(row["ButtonIndex"].ToString());
sigMessage.SynchIcon = PIn.Byte(row["SynchIcon"].ToString());
sigMessage.FromUser = PIn.String(row["FromUser"].ToString());
sigMessage.ToUser = PIn.String(row["ToUser"].ToString());
sigMessage.MessageDateTime = PIn.DateT(row["MessageDateTime"].ToString());
sigMessage.AckDateTime = PIn.DateT(row["AckDateTime"].ToString());
sigMessage.SigText = PIn.String(row["SigText"].ToString());
sigMessage.SigElementDefNumUser = PIn.Long(row["SigElementDefNumUser"].ToString());
sigMessage.SigElementDefNumExtra = PIn.Long(row["SigElementDefNumExtra"].ToString());
sigMessage.SigElementDefNumMsg = PIn.Long(row["SigElementDefNumMsg"].ToString());
retVal.Add(sigMessage);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Schedule> TableToList(DataTable table)
{
List <Schedule> retVal = new List <Schedule>();
Schedule schedule;
foreach (DataRow row in table.Rows)
{
schedule = new Schedule();
schedule.ScheduleNum = PIn.Long(row["ScheduleNum"].ToString());
schedule.SchedDate = PIn.Date(row["SchedDate"].ToString());
schedule.StartTime = PIn.Time(row["StartTime"].ToString());
schedule.StopTime = PIn.Time(row["StopTime"].ToString());
schedule.SchedType = (OpenDentBusiness.ScheduleType)PIn.Int(row["SchedType"].ToString());
schedule.ProvNum = PIn.Long(row["ProvNum"].ToString());
schedule.BlockoutType = PIn.Long(row["BlockoutType"].ToString());
schedule.Note = PIn.String(row["Note"].ToString());
schedule.Status = (OpenDentBusiness.SchedStatus)PIn.Int(row["Status"].ToString());
schedule.EmployeeNum = PIn.Long(row["EmployeeNum"].ToString());
schedule.DateTStamp = PIn.DateT(row["DateTStamp"].ToString());
schedule.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
retVal.Add(schedule);
}
return(retVal);
}
public void Reactivations_GetReactivationList_HappyPath()
{
string name = MethodBase.GetCurrentMethod().Name;
Clinic clinic = ClinicT.CreateClinic(name);
long provNum = ProviderT.CreateProvider(name);
Patient pat = PatientT.CreatePatient(name, provNum, clinic.ClinicNum, TestEmaiAddress, TestPatPhone, ContactMethod.Mail);
//Patient has not been seen since further in the past than the ReactivationDaysPast preference.
Procedure proc = ProcedureT.CreateProcedure(pat, "D0120", ProcStat.C, "", 50, procDate: DateTime.Now.AddYears(-3), provNum: provNum); //3 year old proc
//Patient has been contacted, and the ReactivationContactInterval has elapsed.
Commlog comm = new Commlog()
{
PatNum = pat.PatNum,
CommDateTime = DateTime.Now.AddYears(-1),
CommType = _reactivationCommLogType,
Mode_ = CommItemMode.Email,
SentOrReceived = CommSentOrReceived.Sent,
CommSource = CommItemSource.ApptReminder,
};
comm.CommlogNum = Commlogs.Insert(comm);
//Patient has not been marked "Do Not Contact"
Reactivations.Insert(new Reactivation()
{
PatNum = pat.PatNum,
DoNotContact = false,
});
DateTime dateSince = DateTime.Today.AddDays(-PrefC.GetInt(PrefName.ReactivationDaysPast));
DateTime dateStop = dateSince.AddMonths(-36);
//Confirm that the patient appears in the Reactivation List
DataTable tbl = Reactivations.GetReactivationList(dateSince, dateStop, false, false, true, provNum, clinic.ClinicNum, 0, 0
, ReactivationListSort.LastContacted, RecallListShowNumberReminders.One);
//Only one patient should be in the list
Assert.AreEqual(1, tbl.Rows.Count);
Assert.AreEqual(pat.PatNum, PIn.Int(tbl.Rows[0]["PatNum"].ToString()));
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Benefit> TableToList(DataTable table)
{
List <Benefit> retVal = new List <Benefit>();
Benefit benefit;
for (int i = 0; i < table.Rows.Count; i++)
{
benefit = new Benefit();
benefit.BenefitNum = PIn.Long(table.Rows[i]["BenefitNum"].ToString());
benefit.PlanNum = PIn.Long(table.Rows[i]["PlanNum"].ToString());
benefit.PatPlanNum = PIn.Long(table.Rows[i]["PatPlanNum"].ToString());
benefit.CovCatNum = PIn.Long(table.Rows[i]["CovCatNum"].ToString());
benefit.BenefitType = (InsBenefitType)PIn.Int(table.Rows[i]["BenefitType"].ToString());
benefit.Percent = PIn.Int(table.Rows[i]["Percent"].ToString());
benefit.MonetaryAmt = PIn.Double(table.Rows[i]["MonetaryAmt"].ToString());
benefit.TimePeriod = (BenefitTimePeriod)PIn.Int(table.Rows[i]["TimePeriod"].ToString());
benefit.QuantityQualifier = (BenefitQuantity)PIn.Int(table.Rows[i]["QuantityQualifier"].ToString());
benefit.Quantity = PIn.Byte(table.Rows[i]["Quantity"].ToString());
benefit.CodeNum = PIn.Long(table.Rows[i]["CodeNum"].ToString());
benefit.CoverageLevel = (BenefitCoverageLevel)PIn.Int(table.Rows[i]["CoverageLevel"].ToString());
retVal.Add(benefit);
}
return(retVal);
}