private void CreateAppointment_Click(object sender, RoutedEventArgs e) { if (CheckInputs() == true) { string selTime = SelectedTime.Text; if (IsAvailable(DateTime.Parse(SelectedDate.Content.ToString()).ToString("yyyy-MM-dd"), DateTime.Parse(selTime).ToString("HH:mm:ss"), GetPriest(AssignedPriest.Text)) == false) { MsgNotAvailable(DateTime.Parse(SelectedDate.Content.ToString()).ToString("MMM dd, yyyy"), DateTime.Parse(selTime).ToString("HH:mm tt"), AssignedPriest.Text); this.Close(); } else { dbman = new DBConnectionManager(); pmsutil = new PMSUtil(); //TODO try { string apmID = pmsutil.GenAppointmentID(); MySqlCommand cmd = dbman.DBConnect().CreateCommand(); cmd.CommandText = "INSERT INTO appointments(appointment_id, appointment_date, appointment_time, appointment_type, requested_by, placed_by, remarks, status, assigned_priest, venue)" + "VALUES(@appointment_id, @appointment_date, @appointment_time, @appointment_type, @requested_by, @placed_by, @remarks, @status, @a_priest, @venue)"; cmd.Parameters.AddWithValue("@appointment_id", apmID); cmd.Parameters.AddWithValue("@appointment_date", DateTime.Parse(SelectedDate.Content.ToString()).ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@appointment_time", DateTime.Parse(selTime).ToString("HH:mm:ss")); cmd.Parameters.AddWithValue("@appointment_type", GetATypeID(TypeHolder.Content.ToString())); cmd.Parameters.AddWithValue("@requested_by", RequestedBy.Text); cmd.Parameters.AddWithValue("@placed_by", Application.Current.Resources["uid"].ToString()); cmd.Parameters.AddWithValue("@remarks", Remarks.Text); cmd.Parameters.AddWithValue("@status", 1); cmd.Parameters.AddWithValue("@a_priest", GetPriest(AssignedPriest.Text)); cmd.Parameters.AddWithValue("@venue", Venue.Text); cmd.Prepare(); int stat_code = cmd.ExecuteNonQuery(); dbman.DBClose(); if (stat_code > 0) { this.Close(); MsgSuccess(); } else { MsgFail(); } string tmp = pmsutil.LogScheduling(apmID, "LOGC-01"); pmsutil.InsertTransaction("Liturgical Service - " + TypeHolder.Content.ToString(), "Unpaid", apmID, Convert.ToDouble(Fee.Value)); } catch (MySqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } } } else { } }
private int PrintEntry() { string[] bspl = MarriageDate.Text.Split('/'); string bsuff = GetDaySuffix(int.Parse(bspl[1])); string bmon = PrepMonth(int.Parse(bspl[0])); Document doc = new Document(); doc.LoadFromFile("Data\\temp_marriage.docx"); doc.Replace("name", FullName1.Text, true, true); doc.Replace("name2", FullName2.Text, true, true); doc.Replace("age", Age1.Value.ToString(), true, true); doc.Replace("age2", Age2.Value.ToString(), true, true); doc.Replace("nationality", "Filipino", true, true); doc.Replace("nationality2", "Filipino", true, true); doc.Replace("residence", Residence1.Text, true, true); doc.Replace("residence2", Residence2.Text, true, true); doc.Replace("civil", Status1.Text, true, true); doc.Replace("civil2", Status2.Text, true, true); doc.Replace("father", Parent1.Text, true, true); doc.Replace("father2", Parent3.Text, true, true); doc.Replace("mother", Parent2.Text, true, true); doc.Replace("mother2", Parent4.Text, true, true); doc.Replace("witness", Sponsor1.Text, true, true); doc.Replace("witness2", Sponsor2.Text, true, true); doc.Replace("place", "St. Raphael Parish", true, true); doc.Replace("date", bmon + " " + bspl[1] + bsuff + ", " + bspl[2], true, true); doc.Replace("priest", Minister.Text, true, true); doc.Replace("sign", Signatory.Text, true, true); //doc.Replace("no", EntryNum.Value.ToString(), true, true); doc.Replace("no", bookNum.ToString(), true, true); doc.Replace("page", PageNum.Value.ToString(), true, true); string[] date = DateTime.Now.ToString("MMMM,d,yyyy").Split(','); doc.Replace("month", date[0], true, true); date[1] = date[1] + GetDaySuffix(int.Parse(date[1])); doc.Replace("days", date[1], true, true); doc.Replace("YY", date[2].Remove(0, 2), true, true); doc.SaveToFile("Data\\print.docx", FileFormat.Docx); //Load Document Document document = new Document(); document.LoadFromFile(@"Data\\print.docx"); //Convert Word to PDF document.SaveToFile("Output\\print_file.pdf", FileFormat.PDF); System.Diagnostics.Process.Start("Output\\print_file.pdf"); string tmp = pmsutil.LogRecord(recordID, "LOGC-03"); pmsutil.InsertTransaction("Matrimonial Cert.", "Unpaid", recordID, Convert.ToDouble(PrintingFee.Value)); return(1); }
/// <summary> /// Inserts the request to the database. /// </summary> private int PrintEntry() { string[] bspl = BurialDate.Text.Split('/'); string bmon = PrepMonth(int.Parse(bspl[0])); string[] dspl = DeathDate.Text.Split('/'); string dmon = PrepMonth(int.Parse(dspl[0])); Document doc = new Document(); doc.LoadFromFile("Data\\temp_death.docx"); doc.Replace("name", fullName, true, true); doc.Replace("age", Convert.ToString(age), true, true); doc.Replace("nationality", Nationality.Text, true, true); doc.Replace("residence", residence1, true, true); doc.Replace("civil", status, true, true); doc.Replace("father", p1, true, true); doc.Replace("mother", p2, true, true); doc.Replace("spouse", spouse, true, true); doc.Replace("date_of_birth", bmon + " " + bspl[1] + ", " + bspl[2], true, true); doc.Replace("cause_of_death", causeOfDeath, true, true); doc.Replace("date_of_burial", dmon + " " + dspl[1] + ", " + dspl[2], true, true); doc.Replace("place_of_burial", intermentPlace, true, true); doc.Replace("priest", minister, true, true); doc.Replace("sign", Signatory.Text, true, true); doc.Replace("no", Convert.ToString(entryNum), true, true); doc.Replace("page", Convert.ToString(pageNum), true, true); string[] date = DateTime.Now.ToString("MMMM,d,yyyy").Split(',');; doc.Replace("month", date[0], true, true); doc.Replace("day", date[1], true, true); doc.Replace("YY", date[2].Remove(0, 2), true, true); doc.SaveToFile("Data\\print.docx", FileFormat.Docx); //Load Document Document document = new Document(); document.LoadFromFile(@"Data\\print.docx"); //Convert Word to PDF document.SaveToFile("Output\\print_file.pdf", FileFormat.PDF); System.Diagnostics.Process.Start("Output\\print_file.pdf"); //Reference string tmp = pmsutil.LogRecord(recordID, "LOGC-03"); pmsutil.InsertTransaction("Burial Cert.", "Unpaid", recordID, Convert.ToDouble(PrintingFee.Value)); return(1); }
private void BatchPrint(object sender, DoWorkEventArgs e) { int tick = 0; int total = _items.Count; string signature = ""; string purpose = ""; double fee = 0d; App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE { QueueCounter.Content = tick + "/" + total; QueuePBar.IsIndeterminate = true; signature = Signatory.Text; purpose = Purpose.Text; fee = Convert.ToDouble(PrintingFee.Value); }); for (int i = 0; i < _items.Count; i++) { App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE { QueueCounter.Content = tick + "/" + total; }); RecordEntryMatrimonial recordx = (RecordEntryMatrimonial)_items[i]; string[] bspl = DateTime.Parse(recordx.MarriageDate + "," + recordx.MarriageYear).ToString("MM/dd/yyyy").Split('/'); string bsuff = GetDaySuffix(int.Parse(bspl[1])); string bmon = PrepMonth(int.Parse(bspl[0])); Document doc = new Document(); doc.LoadFromFile("Data\\temp_marriage.docx"); doc.Replace("name", recordx.FullName1, true, true); doc.Replace("name2", recordx.FullName2, true, true); doc.Replace("age", recordx.Age1.ToString(), true, true); doc.Replace("age2", recordx.Age2.ToString(), true, true); doc.Replace("nationality", "Filipino", true, true); doc.Replace("nationality2", "Filipino", true, true); doc.Replace("residence", recordx.Residence1, true, true); doc.Replace("residence2", recordx.Residence2, true, true); doc.Replace("civil", recordx.Status1, true, true); doc.Replace("civil2", recordx.Status2, true, true); doc.Replace("father", recordx.Parent1, true, true); doc.Replace("father2", recordx.Parent3, true, true); doc.Replace("mother", recordx.Parent2, true, true); doc.Replace("mother2", recordx.Parent4, true, true); doc.Replace("witness", recordx.Witness1, true, true); doc.Replace("witness2", recordx.Witness2, true, true); doc.Replace("place", "St. Raphael Parish", true, true); doc.Replace("date", bmon + " " + bspl[1] + bsuff + ", " + bspl[2], true, true); doc.Replace("priest", recordx.Minister, true, true); doc.Replace("sign", signature, true, true); doc.Replace("page", GetPNum(recordx.RecordID).ToString(), true, true); doc.Replace("no", GetBNum(recordx.RecordID).ToString(), true, true); string[] date = DateTime.Now.ToString("MMMM,d,yyyy").Split(','); doc.Replace("month", date[0], true, true); date[1] = date[1] + GetDaySuffix(int.Parse(date[1])); doc.Replace("days", date[1], true, true); doc.Replace("YY", date[2].Remove(0, 2), true, true); doc.SaveToFile("Data\\print-" + i + ".docx", FileFormat.Docx); //Load Document Document document = new Document(); document.LoadFromFile(@"Data\\print-" + i + ".docx"); //Convert Word to PDF document.SaveToFile("Output\\print_file-" + i + ".pdf", FileFormat.PDF); App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE { if (SkipPreview.IsChecked == true) { Spire.Pdf.PdfDocument docx = new Spire.Pdf.PdfDocument(); docx.LoadFromFile(@"Output\\print_file-" + i + ".pdf"); docx.PrintDocument.Print(); } else { System.Diagnostics.Process.Start("Output\\print_file-" + i + ".pdf"); } //Reference string tmp = pmsutil.LogRecord(recordx.RecordID, "LOGC-03"); }); pmsutil.InsertTransaction("Matrimonial Cert.", "Paying", recordx.RecordID, Convert.ToDouble(pmsutil.GetPrintFee("Matrimonial"))); tick++; } }
private void BatchPrint(object sender, DoWorkEventArgs e) { int tick = 0; int total = _items.Count; string signature = ""; string purpose = ""; double fee = 0d; App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE { QueueCounter.Content = tick + "/" + total; QueuePBar.IsIndeterminate = true; signature = Signatory.Text; purpose = Purpose.Text; fee = Convert.ToDouble(PrintingFee.Value); }); for (int i = 0; i < _items.Count; i++) { App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE { QueueCounter.Content = tick + "/" + total; }); RecordEntryBurial recordx = (RecordEntryBurial)_items[i]; string[] bspl = DateTime.Parse(recordx.BurialDate + "," + recordx.BurialYear).ToString("MM/dd/yyyy").Split('/'); string bmon = PrepMonth(int.Parse(bspl[0])); string[] dspl = DateTime.Parse(recordx.DeathDate + "," + recordx.DeathYear).ToString("MM/dd/yyyy").Split('/'); string dmon = PrepMonth(int.Parse(dspl[0])); Document doc = new Document(); doc.LoadFromFile("Data\\temp_death.docx"); doc.Replace("name", recordx.FullName, true, true); doc.Replace("age", Convert.ToString(recordx.Age), true, true); doc.Replace("nationality", "Filipino", true, true); doc.Replace("residence", recordx.Residence1, true, true); doc.Replace("civil", recordx.Status, true, true); if (string.IsNullOrEmpty(recordx.Parent2)) { doc.Replace("father", " ", true, true); doc.Replace("mother", " ", true, true); doc.Replace("spouse", recordx.Parent1, true, true); } else { doc.Replace("father", recordx.Parent1, true, true); doc.Replace("mother", recordx.Parent2, true, true); doc.Replace("spouse", " ", true, true); } doc.Replace("date_of_birth", bmon + " " + bspl[1] + ", " + bspl[2], true, true); doc.Replace("cause_of_death", recordx.CauseOfDeath, true, true); doc.Replace("date_of_burial", dmon + " " + dspl[1] + ", " + dspl[2], true, true); doc.Replace("place_of_burial", recordx.PlaceOfInterment, true, true); doc.Replace("priest", recordx.Minister, true, true); doc.Replace("sign", signature, true, true); doc.Replace("no", recordx.EntryNumber.ToString(), true, true); doc.Replace("page", GetPNum(recordx.RecordID).ToString(), true, true); string[] date = DateTime.Now.ToString("MMMM,d,yyyy").Split(',');; doc.Replace("month", date[0], true, true); doc.Replace("day", date[1], true, true); doc.SaveToFile("Data\\print-" + i + ".docx", FileFormat.Docx); //Load Document Document document = new Document(); document.LoadFromFile(@"Data\\print-" + i + ".docx"); //Convert Word to PDF document.SaveToFile("Output\\print_file-" + i + ".pdf", FileFormat.PDF); App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE { if (SkipPreview.IsChecked == true) { Spire.Pdf.PdfDocument docx = new Spire.Pdf.PdfDocument(); docx.LoadFromFile(@"Output\\print_file-" + i + ".pdf"); docx.PrintDocument.Print(); } else { System.Diagnostics.Process.Start("Output\\print_file-" + i + ".pdf"); } //Reference string tmp = pmsutil.LogRecord(recordx.RecordID, "LOGC-03"); }); pmsutil.InsertTransaction("Burial Cert.", "Paying", recordx.RecordID, Convert.ToDouble(pmsutil.GetPrintFee("Burial"))); tick++; } }
private void BatchPrint(object sender, DoWorkEventArgs e) { int tick = 0; int total = _items.Count; string signature = ""; string purpose = ""; double fee = 0d; App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE { QueueCounter.Content = tick + "/" + total; QueuePBar.IsIndeterminate = true; signature = Signatory.Text; purpose = Purpose.Text; fee = Convert.ToDouble(PrintingFee.Value); }); for (int i = 0; i < _items.Count; i++) { App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE { QueueCounter.Content = tick + "/" + total; }); RecordEntryConfirmation recordx = (RecordEntryConfirmation)_items[i]; string x1; string[] spl = DateTime.Parse(recordx.ConfirmationDate + "," + recordx.ConfirmationYear).ToString("MM/dd/yyyy").Split('/'); string suff = GetDaySuffix(int.Parse(spl[1])); string mon = PrepMonth(int.Parse(spl[0])); if (int.Parse(spl[2]) > 1999) { x1 = ""; spl[2] = spl[2].Remove(0, 2); } else { x1 = "X"; } Document doc = new Document(); doc.LoadFromFile("Data\\temp_confirmation.docx"); doc.Replace("name", recordx.FullName, true, true); doc.Replace("day", int.Parse(spl[1]) + suff, true, true); doc.Replace("month", mon, true, true); doc.Replace("X", x1, true, true); doc.Replace("year", spl[2], true, true); doc.Replace("by", recordx.Minister, true, true); doc.Replace("no", recordx.EntryNumber.ToString(), true, true); doc.Replace("book", GetBNum(recordx.RecordID).ToString(), true, true); doc.Replace("page", GetPNum(recordx.RecordID).ToString(), true, true); doc.Replace("no", recordx.EntryNumber.ToString(), true, true); doc.Replace("priest", recordx.Minister, true, true); doc.Replace("purpose", purpose, true, true); doc.Replace("date", DateTime.Now.ToString("MMMM d, yyyy"), true, true); doc.SaveToFile("Data\\print-" + i + ".docx", FileFormat.Docx); //Load Document Document document = new Document(); document.LoadFromFile(@"Data\\print-" + i + ".docx"); //Convert Word to PDF document.SaveToFile("Output\\print_file-" + i + ".pdf", FileFormat.PDF); App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE { if (SkipPreview.IsChecked == true) { Spire.Pdf.PdfDocument docx = new Spire.Pdf.PdfDocument(); docx.LoadFromFile(@"Output\\print_file-" + i + ".pdf"); docx.PrintDocument.Print(); } else { System.Diagnostics.Process.Start("Output\\print_file-" + i + ".pdf"); } if (Purpose.SelectedIndex == 0) { //Reference string tmp = pmsutil.LogRecord(recordx.RecordID, "LOGC-03"); } else { //Marriage string tmp = pmsutil.LogRecord(recordx.RecordID, "LOGC-04"); } }); pmsutil.InsertTransaction("Confirmation Cert.", "Paying", recordx.RecordID, Convert.ToDouble(pmsutil.GetPrintFee("Confirmation"))); tick++; } }
private void CreateMassRecord(object sender, RoutedEventArgs e) { if (TabControl1.SelectedIndex == 0) { if (CheckInputs() == true) { dbman = new DBConnectionManager(); pmsutil = new PMSUtil(); //TODO try { string apmID = pmsutil.GenAppointmentID(); MySqlCommand cmd = dbman.DBConnect().CreateCommand(); string soulsof_tmp = SoulsOf.Text; if (MassType.Text == "All Souls" || MassType.Text == "Soul/s of") { soulsof_tmp = SoulsOf.Text; } else { soulsof_tmp = "NA."; } cmd.CommandText = "INSERT INTO appointments(appointment_id, appointment_date, appointment_time, appointment_type, requested_by, placed_by, remarks, status)" + "VALUES(@appointment_id, @appointment_date, @appointment_time, @appointment_type, @requested_by, @placed_by, @remarks, @status)"; cmd.Parameters.AddWithValue("@appointment_id", apmID); cmd.Parameters.AddWithValue("@appointment_date", DateTime.Parse(SelectedDate1.Text).ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@appointment_time", DateTime.Parse(SelectedTime1.Text).ToString("HH:mm:ss")); cmd.Parameters.AddWithValue("@appointment_type", GetATypeID(MassType.Text)); cmd.Parameters.AddWithValue("@requested_by", OfferedBy1.Text); cmd.Parameters.AddWithValue("@placed_by", Application.Current.Resources["uid"].ToString()); cmd.Parameters.AddWithValue("@remarks", soulsof_tmp); cmd.Parameters.AddWithValue("@status", 1); cmd.Prepare(); int stat_code = cmd.ExecuteNonQuery(); dbman.DBClose(); if (stat_code > 0) { _caller.SyncEvent2(); MsgSuccess(); this.Close(); } else { MsgFail(); } string tmp = pmsutil.LogScheduling(apmID, "LOGC-01"); pmsutil.InsertTransaction("Regular Serv. - " + MassType.Text, "Unpaid", apmID, Convert.ToDouble(Fee.Value)); } catch (MySqlException ex) { } this.Close(); } else { } } else { if (CheckInputs() == true) { string selTime = THours.Text + ":" + TMinutes.Text + " " + TimeMode.Text; if (IsAvailable(DateTime.Parse(SelectedDate2.Text).ToString("yyyy-MM-dd"), DateTime.Parse(selTime).ToString("HH:mm:ss"), GetPriest(AssignedPriest.Text)) == false) { MsgNotAvailable(DateTime.Parse(SelectedDate2.Text).ToString("MMM dd, yyyy"), DateTime.Parse(selTime).ToString("HH:mm tt"), AssignedPriest.Text); this.Close(); } else { dbman = new DBConnectionManager(); pmsutil = new PMSUtil(); //TODO try { string apmID = pmsutil.GenAppointmentID(); MySqlCommand cmd = dbman.DBConnect().CreateCommand(); cmd.CommandText = "INSERT INTO appointments(appointment_id, appointment_date, appointment_time, appointment_type, requested_by, placed_by, remarks, status, assigned_priest)" + "VALUES(@appointment_id, @appointment_date, @appointment_time, @appointment_type, @requested_by, @placed_by, @remarks, @status, @a_priest)"; cmd.Parameters.AddWithValue("@appointment_id", apmID); cmd.Parameters.AddWithValue("@appointment_date", DateTime.Parse(SelectedDate2.Text).ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@appointment_time", DateTime.Parse(selTime).ToString("HH:mm:ss")); cmd.Parameters.AddWithValue("@appointment_type", GetATypeID(EventServiceType.Text)); cmd.Parameters.AddWithValue("@requested_by", OfferedBy2.Text); cmd.Parameters.AddWithValue("@placed_by", Application.Current.Resources["uid"].ToString()); cmd.Parameters.AddWithValue("@remarks", Remarks.Text); cmd.Parameters.AddWithValue("@status", 1); cmd.Parameters.AddWithValue("@a_priest", GetPriest(AssignedPriest.Text)); cmd.Prepare(); int stat_code = cmd.ExecuteNonQuery(); dbman.DBClose(); if (stat_code > 0) { _caller.SyncEvent2(); MsgSuccess(); this.Close(); } else { MsgFail(); } string tmp = pmsutil.LogScheduling(apmID, "LOGC-01"); pmsutil.InsertTransaction("Special Serv. - " + EventServiceType.Text, "Unpaid", apmID, Convert.ToDouble(Fee2.Value)); } catch (MySqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } } } else { } } }
/// <summary> /// Inserts the request to the database. /// </summary> private int PrintEntry() { string x1; string[] spl = ConfirmationDate.Text.Split('/'); string suff = GetDaySuffix(int.Parse(spl[1])); string mon = PrepMonth(int.Parse(spl[0])); if (int.Parse(spl[2]) > 1999) { x1 = ""; spl[2] = spl[2].Remove(0, 2); } else { x1 = "X"; } Document doc = new Document(); doc.LoadFromFile("Data\\temp_confirmation.docx"); doc.Replace("name", fullName, true, true); doc.Replace("day", int.Parse(spl[1]) + suff, true, true); doc.Replace("month", mon, true, true); doc.Replace("X", x1, true, true); doc.Replace("year", spl[2], true, true); doc.Replace("by", minister, true, true); doc.Replace("no", entryNum.ToString(), true, true); doc.Replace("page", pageNum.ToString(), true, true); doc.Replace("book", bookNum.ToString(), true, true); doc.Replace("priest", Signatory.Text, true, true); doc.Replace("purpose", Purpose.Text, true, true); doc.Replace("date", DateTime.Now.ToString("MMMM d, yyyy"), true, true); doc.SaveToFile("Data\\print.docx", FileFormat.Docx); //Load Document Document document = new Document(); document.LoadFromFile(@"Data\\print.docx"); //Convert Word to PDF document.SaveToFile("Output\\print_file.pdf", FileFormat.PDF); System.Diagnostics.Process.Start("Output\\print_file.pdf"); if (Purpose.SelectedIndex == 0) { //Reference string tmp = pmsutil.LogRecord(recordID, "LOGC-03"); } else { //Marriage string tmp = pmsutil.LogRecord(recordID, "LOGC-04"); } if (Purpose.SelectedIndex == 0) { //Reference string tmp = pmsutil.LogRecord(recordID, "LOGC-03"); } else { //Marriage string tmp = pmsutil.LogRecord(recordID, "LOGC-04"); } pmsutil.InsertTransaction("Confirmation Cert.", "Unpaid", recordID, Convert.ToDouble(PrintingFee.Value)); return(1); }
/// <summary> /// Inserts the request to the database. /// </summary> private int PrintEntry() { string x1, x2; string[] bspl = birthDate.Split('/'); string bsuff = GetDaySuffix(int.Parse(bspl[1])); string bmon = PrepMonth(int.Parse(bspl[0])); if (int.Parse(bspl[2]) > 1999) { x1 = ""; bspl[2] = bspl[2].Remove(0, 2); } else { x1 = "X"; } string[] dspl = baptismDate.Split('/'); string dsuff = GetDaySuffix(int.Parse(dspl[1])); string dmon = PrepMonth(int.Parse(dspl[0])); if (int.Parse(dspl[2]) > 1999) { x2 = ""; dspl[2] = dspl[2].Remove(0, 2); } else { x2 = "X"; } Document doc = new Document(); doc.LoadFromFile("Data\\temp_baptismal.docx"); doc.Replace("name", fullName, true, true); doc.Replace("father", parent1, true, true); doc.Replace("mother", parent2, true, true); doc.Replace("born", birthPlace, true, true); doc.Replace("day1", int.Parse(bspl[1]) + bsuff, true, true); doc.Replace("month1", bmon, true, true); doc.Replace("X1", x1, true, true); //doc.Replace("year1", bspl[2], true, true); doc.Replace("year1", DateTime.Parse(birthDate).ToString("yyyy"), true, true); doc.Replace("day2", int.Parse(dspl[1]) + dsuff, true, true); doc.Replace("month2", dmon, true, true); doc.Replace("X2", x2, true, true); doc.Replace("year2", DateTime.Parse(baptismDate).ToString("yyyy"), true, true); doc.Replace("church", pmsutil.GetChurchName(), true, true); doc.Replace("by", Signatory.Text, true, true); doc.Replace("sponsor1", sponsor1, true, true); doc.Replace("sponsor2", sponsor2, true, true); doc.Replace("book", bookNum.ToString(), true, true); doc.Replace("page", pageNum.ToString(), true, true); doc.Replace("no", entryNum.ToString(), true, true); doc.Replace("priest", minister, true, true); doc.Replace("purpose", Purpose.Text, true, true); doc.Replace("date", DateTime.Now.ToString("MMMM d, yyyy"), true, true); doc.SaveToFile("Data\\print.docx", FileFormat.Docx); //Load Document Document document = new Document(); document.LoadFromFile(@"Data\\print.docx"); //Convert Word to PDF document.SaveToFile("Output\\print_file.pdf", FileFormat.PDF); System.Diagnostics.Process.Start("Output\\print_file.pdf"); if (Purpose.SelectedIndex == 0) { //Reference string tmp = pmsutil.LogRecord(recordID, "LOGC-03"); } else { //Marriage string tmp = pmsutil.LogRecord(recordID, "LOGC-04"); } pmsutil.InsertTransaction("Baptismal Cert.", "Unpaid", recordID, Convert.ToDouble(PrintingFee.Value)); return(1); }