private static void InstanceBridgeExport()
{
string dir = Path.GetDirectoryName(_path);
string extract = CodeBase.ODFileUtils.CombinePaths(dir, "extract.xml");
CheckCreatedFile(extract);
double linesProcessedCount = 0;
string licenseKey = ProgramProperties.GetPropVal(Programs.GetProgramNum(ProgramName.DemandForce), "Enter your DemandForce license key (required)");
string versionCur = new Version(Application.ProductVersion).ToString();
string extractDateTime = DateTime.Now.ToUniversalTime().ToString("yyyy-MM-ddTHH:mm:ss.fffK");
Dictionary <long, DateTime> dateLastVisit = Appointments.GetDateLastVisit();
Dictionary <long, List <Appointment> > allPatApts = Appointments.GetAptsForPats(DateTime.Now.ToUniversalTime(), DateTime.Now.AddDays(210).ToUniversalTime()); //appointments from todays date forward 210 days
Dictionary <long, List <long> > allAptProcNums = Appointments.GetCodeNumsAllApts();
long[] arrayPatNums = Patients.GetAllPatNums(false);
Patient patient;
Appointment apt;
List <Appointment> listApts;
List <long> listProcNums;
double totalLines = CalculateTotalLinesOfCode(arrayPatNums, allAptProcNums, allPatApts);
while (!_formProg.IsHandleCreated)
{
} //Wait for the form to show the first time, or else the Invoke calls will cause an exception.
_formProg.Invoke(new PassProgressDelegate(PassPercentProgressToDialog), new object[] { linesProcessedCount,
Lan.g(_formProg, "Executing the bridge to DemandForce"),
100.0, "" });
Thread.Sleep(1000); //Wait 1 second so the user can see the progress bar popup.
try {
StringBuilder strb = new StringBuilder();
XmlWriterSettings settings = new XmlWriterSettings();
settings.Encoding = Encoding.UTF8;
settings.Indent = true;
settings.IndentChars = " ";
settings.NewLineChars = "\r\n";
settings.OmitXmlDeclaration = true;
XmlWriter writer = XmlWriter.Create(strb, settings);
writer.WriteRaw("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n");
writer.WriteStartElement("DemandForce");
writer.WriteAttributeString("licenseKey", licenseKey);
writer.WriteAttributeString("scope", "full");
writer.WriteStartElement("Business");
writer.WriteStartElement("Extract");
writer.WriteAttributeString("extractDateTime", extractDateTime);
writer.WriteAttributeString("managementSystemName", "Open Dental");
writer.WriteAttributeString("managementSystemVersion", versionCur);
writer.WriteEndElement(); //Extract
for (int i = 0; i < arrayPatNums.Length; i++)
{
patient = Patients.GetPat(arrayPatNums[i]);
writer.WriteStartElement("Customer");
writer.WriteAttributeString("id", patient.PatNum.ToString());
if (patient.ChartNumber != "")
{
writer.WriteAttributeString("chartId", patient.ChartNumber);
}
if (dateLastVisit.ContainsKey(patient.PatNum)) //Need input. Will it ever be null? Or will it check empty string?
{
writer.WriteAttributeString("lastVisit", dateLastVisit[patient.PatNum].ToUniversalTime().ToString("yyyy-MM-ddTHH:mm:ss.fffK"));
}
else
{
writer.WriteAttributeString("lastVisit", PIn.DateT("0001-01-01 00:00:00").ToUniversalTime().ToString("yyyy-MM-ddTHH:mm:ss.fffK"));
}
writer.WriteStartElement("Demographics");
if (patient.FName != "")
{
writer.WriteAttributeString("firstName", patient.FName);
}
else
{
writer.WriteAttributeString("firstName", "X"); //need input on what to do with patients who don't have a FName.
}
writer.WriteAttributeString("lastName", patient.LName);
if (patient.Gender.ToString() == "Female")
{
writer.WriteAttributeString("gender", "Female");
}
else
{
writer.WriteAttributeString("gender", "Male");
}
if (patient.Birthdate.Year > 1880)
{
writer.WriteAttributeString("birthday", patient.Birthdate.ToUniversalTime().ToString("yyyy-MM-ddTHH:mm:ss.fffK"));
}
if (patient.Address != "")
{
writer.WriteAttributeString("address1", patient.Address);
}
if (patient.City != "")
{
writer.WriteAttributeString("city", patient.City);
}
if (patient.State != "")
{
writer.WriteAttributeString("State", patient.State);
}
if (patient.Zip != "")
{
writer.WriteAttributeString("Zip", patient.Zip);
}
if (patient.Email != "")
{
writer.WriteAttributeString("Email", patient.Email);
}
writer.WriteEndElement(); //Demographics
if (allPatApts.ContainsKey(patient.PatNum))
{
listApts = allPatApts[patient.PatNum];
for (int j = 0; j < listApts.Count; j++)
{
apt = listApts[j];
writer.WriteStartElement("Appointment");
writer.WriteAttributeString("id", apt.AptNum.ToString());
if (apt.AptStatus.ToString() == "Complete")
{
writer.WriteAttributeString("status", "1");
}
else
{
writer.WriteAttributeString("status", "3");
}
if (Defs.GetDef(DefCat.ApptConfirmed, apt.Confirmed).ItemName.ToLower() == "unconfirmed")
{
writer.WriteAttributeString("confirmed", "0");
}
else
{
writer.WriteAttributeString("confirmed", "1");
}
writer.WriteAttributeString("date", apt.AptDateTime.ToUniversalTime().ToString("yyyy-MM-ddTHH:mm:ss.fffK"));
writer.WriteAttributeString("duration", (apt.Pattern.Length * 5).ToString());
if (allAptProcNums.ContainsKey(apt.AptNum))
{
listProcNums = allAptProcNums[apt.AptNum];
string codes = "";
for (int k = 0; k < listProcNums.Count; k++)
{
codes += ProcedureCodes.GetStringProcCode(listProcNums[k]);
if (k < listProcNums.Count - 1)
{
codes += ", ";
}
if (linesProcessedCount < totalLines) //this avoids setting progress bar to max, which would close the dialog.
{
_formProg.Invoke(new PassProgressDelegate(PassPercentProgressToDialog), new object[] { (linesProcessedCount / totalLines * 100),
Lan.g(_formProg, "Creating export file: ?currentVal % of ?maxVal % completed"),
100.0, "" });
}
linesProcessedCount += 2;
}
if (codes != "")
{
writer.WriteAttributeString("code", codes);
}
}
writer.WriteEndElement(); //Appointment
if (linesProcessedCount < totalLines) //this avoids setting progress bar to max, which would close the dialog.
{
_formProg.Invoke(new PassProgressDelegate(PassPercentProgressToDialog), new object[] { (linesProcessedCount / totalLines * 100),
Lan.g(_formProg, "Creating export file: ?currentVal % of ?maxVal % completed"),
100.0, "" });
}
linesProcessedCount += 12;
}
}
writer.WriteEndElement(); //Customer
if (linesProcessedCount < totalLines) //this avoids setting progress bar to max, which would close the dialog.
{
_formProg.Invoke(new PassProgressDelegate(PassPercentProgressToDialog), new object[] { (linesProcessedCount / totalLines * 100),
Lan.g(_formProg, "Creating export file: ?currentVal % of ?maxVal % completed"),
100.0, "" });
}
linesProcessedCount += 20;
}
writer.WriteEndElement(); //Business
writer.WriteEndElement(); //DemandForce
writer.Flush();
writer.Close();
ODFileUtils.WriteAllText(extract, strb.ToString());
}
catch {
MessageBox.Show(Lan.g("DemandForce", "Export file creation failed") + ". " + Lan.g("DemandForce", "User may not have sufficient permissions") + ".");
}
if (linesProcessedCount >= totalLines) //this avoids setting progress bar to max, which would close the dialog.
{
_formProg.DisplayText = "Creating export file: 100 % of 100 % completed";
}
Thread.Sleep(600); //Wait a little bit so the user can see that it got to 100% complete.
//force dialog to close even if no files copied or calculation was slightly off.
_formProg.Invoke(new PassProgressDelegate(PassPercentProgressToDialog), new object[] { 0, "", 0, "" });
}
