/// <summary> /// Creates the AddRequestForm Window and Initializes DB Param. /// </summary> public BatchPrintWindow(System.Collections.IList items) { _items = items; pmsutil = new PMSUtil(); InitializeComponent(); GetResidingPriests(); PrintingFee.Value = Convert.ToDouble(pmsutil.GetPrintFee("Baptismal")); records = new ObservableCollection <RecordEntryBaptismal>(); for (int i = 0; i < items.Count; i++) { RecordEntryBaptismal recordx = (RecordEntryBaptismal)items[i]; Console.WriteLine(recordx.RecordID); records.Add(new RecordEntryBaptismal() { RecordID = recordx.RecordID, EntryNumber = recordx.EntryNumber, BaptismalYear = recordx.BaptismalYear, BaptismalDate = recordx.BaptismalDate, FullName = recordx.FullName, BirthDate = recordx.BirthDate, Legitimacy = recordx.Legitimacy, PlaceOfBirth = recordx.PlaceOfBirth, Parent1 = recordx.Parent1, Parent2 = recordx.Parent2, Godparent1 = recordx.Godparent1, Godparent2 = recordx.Godparent2, Stipend = recordx.Stipend, Minister = recordx.Minister }); } EntriesHolder.Items.Refresh(); EntriesHolder.ItemsSource = records; EntriesHolder.Items.Refresh(); }
private void SyncFee(object sender, System.Windows.Input.MouseButtonEventArgs e) { pmsutil = new PMSUtil(); NumericUpDown nud = (NumericUpDown)sender; nud.Value = Convert.ToDouble(string.Format("{0:N3}", pmsutil.GetPrintFee("Baptismal"))); }
public PrintBurialRecordEntryWindow(string targRecord) { pmsutil = new PMSUtil(); InitializeComponent(); recordID = targRecord; GetResidingPriests(); CheckAccess(targRecord); PrintingFee.Value = Convert.ToDouble(pmsutil.GetPrintFee("Burial")); Stipend.Value = FetchBurialStipend(); dbman = new DBConnectionManager(); if (dbman.DBConnect().State == ConnectionState.Open) { MySqlCommand cmd = dbman.DBConnect().CreateCommand(); cmd.CommandText = "SELECT * FROM burial_records, records WHERE records.record_id = @record_id AND records.record_id = burial_records.record_id LIMIT 1;"; cmd.Parameters.AddWithValue("@record_id", targRecord); cmd.Prepare(); MySqlDataReader db_reader = cmd.ExecuteReader(); while (db_reader.Read()) { EntryNum.Value = Convert.ToDouble(db_reader.GetString("entry_number")); PageNum.Value = Convert.ToDouble(db_reader.GetString("page_number")); DeathDate.Text = db_reader.GetString("record_date"); BurialDate.Text = db_reader.GetString("burial_date"); Age.Value = Convert.ToDouble(db_reader.GetString("age")); FullName.Text = db_reader.GetString("recordholder_fullname"); Age.Value = Convert.ToDouble(db_reader.GetString("age")); Status.Text = db_reader.GetString("status"); Parent1.Text = db_reader.GetString("parent1_fullname"); Parent2.Text = db_reader.GetString("parent2_fullname"); Residence1.Text = db_reader.GetString("residence"); Residence2.Text = db_reader.GetString("residence2"); Sacrament.Text = db_reader.GetString("sacrament"); CauseOfDeath.Text = db_reader.GetString("cause_of_death"); PlaceOfInterment.Text = db_reader.GetString("place_of_interment"); Stipend.Value = Convert.ToDouble(db_reader.GetString("stipend")); Minister.Text = db_reader.GetString("minister"); Remarks.Text = db_reader.GetString("remarks"); } //close Connection dbman.DBClose(); } else { } Suggestions1.Visibility = Visibility.Hidden; Suggestions2.Visibility = Visibility.Hidden; Suggestions3.Visibility = Visibility.Hidden; Suggestions4.Visibility = Visibility.Hidden; Suggestions5.Visibility = Visibility.Hidden; Suggestions6.Visibility = Visibility.Hidden; }
/// <summary> /// Creates the AddRequestForm Window and Initializes DB Param. /// </summary> public BatchPrintWindow2(System.Collections.IList items) { _items = items; pmsutil = new PMSUtil(); InitializeComponent(); GetResidingPriests(); PrintingFee.Value = Convert.ToDouble(pmsutil.GetPrintFee("Matrimonial")); records = new ObservableCollection <RecordEntryMatrimonial>(); for (int i = 0; i < items.Count; i++) { RecordEntryMatrimonial recordx = (RecordEntryMatrimonial)items[i]; Console.WriteLine(recordx.RecordID); records.Add(new RecordEntryMatrimonial() { RecordID = recordx.RecordID, EntryNumber = recordx.EntryNumber, MarriageYear = recordx.MarriageYear, MarriageDate = recordx.MarriageDate, FullName1 = recordx.FullName1, FullName2 = recordx.FullName2, Age1 = Convert.ToInt32(recordx.Age1), Age2 = Convert.ToInt32(recordx.Age2), Hometown1 = recordx.Hometown1, Hometown2 = recordx.Hometown2, Residence1 = recordx.Residence1, Residence2 = recordx.Residence2, Parent1 = recordx.Parent1, Parent2 = recordx.Parent2, Parent3 = recordx.Parent3, Parent4 = recordx.Parent4, Witness1 = recordx.Witness1, Witness2 = recordx.Witness2, W1Residence = recordx.W1Residence, W2Residence = recordx.W2Residence, Stipend = Convert.ToDouble(recordx.Stipend), Minister = recordx.Minister }); } EntriesHolder.Items.Refresh(); EntriesHolder.ItemsSource = records; EntriesHolder.Items.Refresh(); }
/// <summary> /// Creates the AddRequestForm Window and Initializes DB Param. /// </summary> public BatchPrintWindow3(System.Collections.IList items) { _items = items; pmsutil = new PMSUtil(); InitializeComponent(); GetResidingPriests(); PrintingFee.Value = Convert.ToDouble(pmsutil.GetPrintFee("Burial")); records = new ObservableCollection <RecordEntryBurial>(); for (int i = 0; i < items.Count; i++) { RecordEntryBurial recordx = (RecordEntryBurial)items[i]; Console.WriteLine(recordx.RecordID); records.Add(new RecordEntryBurial() { RecordID = recordx.RecordID, EntryNumber = recordx.EntryNumber, DeathYear = recordx.DeathYear, DeathDate = recordx.DeathDate, BurialYear = recordx.BurialYear, BurialDate = recordx.BurialDate, FullName = recordx.FullName, Age = Convert.ToInt32(recordx.Age), Status = recordx.Status, Residence1 = recordx.Residence2, Residence2 = recordx.Residence1, Sacrament = recordx.Sacrament, CauseOfDeath = recordx.CauseOfDeath, PlaceOfInterment = recordx.PlaceOfInterment, Parent1 = recordx.Parent1, Parent2 = recordx.Parent2, Stipend = Convert.ToDouble(recordx.Stipend), Minister = recordx.Minister }); } EntriesHolder.Items.Refresh(); EntriesHolder.ItemsSource = records; EntriesHolder.Items.Refresh(); }
/// <summary> /// Creates the AddRequestForm Window and Initializes DB Param. /// </summary> public BatchPrintWindow1(System.Collections.IList items) { _items = items; pmsutil = new PMSUtil(); InitializeComponent(); GetResidingPriests(); PrintingFee.Value = Convert.ToDouble(pmsutil.GetPrintFee("Confirmation")); records = new ObservableCollection <RecordEntryConfirmation>(); for (int i = 0; i < items.Count; i++) { RecordEntryConfirmation recordx = (RecordEntryConfirmation)items[i]; Console.WriteLine(recordx.RecordID); records.Add(new RecordEntryConfirmation() { RecordID = recordx.RecordID, EntryNumber = recordx.EntryNumber, ConfirmationYear = recordx.ConfirmationYear, ConfirmationDate = recordx.ConfirmationDate, FullName = recordx.FullName, Age = Convert.ToInt32(recordx.Age), Parish = recordx.Parish, Province = recordx.Province, PlaceOfBaptism = recordx.PlaceOfBaptism, Parent1 = recordx.Parent1, Parent2 = recordx.Parent2, Sponsor1 = recordx.Sponsor1, Sponsor2 = recordx.Sponsor2, Stipend = recordx.Stipend, Minister = recordx.Minister }); } EntriesHolder.Items.Refresh(); EntriesHolder.ItemsSource = records; EntriesHolder.Items.Refresh(); }
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++; } }
/// <summary> /// Creates the AddRequestForm Window and Initializes DB Param. /// </summary> public PrintMatrimonialRecordEntryWindow(string targRecord) { pmsutil = new PMSUtil(); recordID = targRecord; InitializeComponent(); GetResidingPriests(); CheckAccess(targRecord); PrintingFee.Value = Convert.ToDouble(pmsutil.GetPrintFee("Matrimonial")); recordID = targRecord; Stipend.Value = FetchMatrimonialStipend(); dbman = new DBConnectionManager(); if (dbman.DBConnect().State == ConnectionState.Open) { MySqlCommand cmd = dbman.DBConnect().CreateCommand(); cmd.CommandText = "SELECT * FROM matrimonial_records, records WHERE records.record_id = @record_id AND records.record_id = matrimonial_records.record_id LIMIT 1;"; cmd.Parameters.AddWithValue("@record_id", targRecord); cmd.Prepare(); MySqlDataReader db_reader = cmd.ExecuteReader(); while (db_reader.Read()) { bookNum = db_reader.GetInt32("book_number"); EntryNum.Value = Convert.ToDouble(db_reader.GetString("entry_number")); PageNum.Value = Convert.ToDouble(db_reader.GetString("page_number")); MarriageDate.Text = db_reader.GetString("record_date"); Age1.Value = Convert.ToDouble(db_reader.GetString("age1")); Age2.Value = Convert.ToDouble(db_reader.GetString("age2")); Status1.Text = db_reader.GetString("status1"); Status2.Text = db_reader.GetString("status2"); FullName1.Text = db_reader.GetString("recordholder_fullname"); FullName2.Text = db_reader.GetString("recordholder2_fullname"); Hometown1.Text = db_reader.GetString("place_of_origin1"); Hometown2.Text = db_reader.GetString("place_of_origin2"); Residence1.Text = db_reader.GetString("residence1"); Residence2.Text = db_reader.GetString("residence2"); Stipend.Value = Convert.ToDouble(db_reader.GetString("stipend")); Parent1.Text = db_reader.GetString("parent1_fullname"); Parent2.Text = db_reader.GetString("parent2_fullname"); Parent3.Text = db_reader.GetString("parent1_fullname2"); Parent4.Text = db_reader.GetString("parent2_fullname2"); Sponsor1.Text = db_reader.GetString("witness1"); Sponsor2.Text = db_reader.GetString("witness2"); Residence3.Text = db_reader.GetString("witness1address"); Residence4.Text = db_reader.GetString("witness2address"); Minister.Text = db_reader.GetString("minister"); Remarks.Text = db_reader.GetString("remarks"); } //close Connection dbman.DBClose(); } else { } Suggestions1.Visibility = Visibility.Hidden; Suggestions2.Visibility = Visibility.Hidden; Suggestions3.Visibility = Visibility.Hidden; Suggestions4.Visibility = Visibility.Hidden; Suggestions5.Visibility = Visibility.Hidden; Suggestions6.Visibility = Visibility.Hidden; Suggestions7.Visibility = Visibility.Hidden; }
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++; } }
/// <summary> /// Creates the AddRequestForm Window and Initializes DB Param. /// </summary> public PrintConfirmationRecordEntryWindow(string targRecord) { pmsutil = new PMSUtil(); recordID = targRecord; InitializeComponent(); GetResidingPriests(); CheckAccess(targRecord); PrintingFee.Value = Convert.ToDouble(pmsutil.GetPrintFee("Confirmation")); dbman = new DBConnectionManager(); using (conn = new MySqlConnection(dbman.GetConnStr())) { conn.Open(); if (conn.State == ConnectionState.Open) { using (MySqlConnection conn2 = new MySqlConnection(dbman.GetConnStr())) { conn2.Open(); MySqlCommand cmd = conn2.CreateCommand(); cmd.CommandText = "SELECT * FROM records, registers WHERE records.record_id = @rid AND records.book_number = registers.book_number LIMIT 1;"; cmd.Parameters.AddWithValue("@rid", recordID); cmd.Prepare(); using (MySqlDataReader db_reader = cmd.ExecuteReader()) { while (db_reader.Read()) { if (db_reader.GetString("status") == "Archived") { using (MySqlConnection conn3 = new MySqlConnection(dbman.GetConnStr())) { conn3.Open(); MySqlCommand cmd2 = conn3.CreateCommand(); cmd2.CommandText = "SELECT * FROM records WHERE records.record_id = @rid ORDER BY records.entry_number ASC;"; cmd2.Parameters.AddWithValue("@rid", recordID); cmd2.Prepare(); using (MySqlDataReader db_reader2 = cmd2.ExecuteReader()) { string archiveDrive = "init"; string path = @"\archive.db"; while (db_reader2.Read()) { if (pmsutil.CheckArchiveDrive(path) != "dc") { archiveDrive = pmsutil.CheckArchiveDrive(path); SQLiteConnectionStringBuilder connectionString = new SQLiteConnectionStringBuilder { FailIfMissing = true, DataSource = archiveDrive }; using (SQLiteConnection connection = new SQLiteConnection(connectionString.ToString())) { // open the connection: connection.Open(); string stm = "SELECT * FROM confirmation_records WHERE record_id='" + db_reader2.GetString("record_id") + "';"; using (SQLiteCommand cmdx = new SQLiteCommand(stm, connection)) { using (SQLiteDataReader rdr = cmdx.ExecuteReader()) { while (rdr.Read()) { bookNum = db_reader2.GetInt32("book_number"); EntryNum.Value = db_reader2.GetInt32("entry_number"); PageNum.Value = db_reader2.GetInt32("page_number"); ConfirmationDate.Text = db_reader2.GetString("record_date"); FullName.Text = db_reader2.GetString("recordholder_fullname"); Age.Value = Convert.ToInt32(rdr["age"]); PlaceOfBaptism.Text = rdr["place_of_baptism"].ToString(); Parent1.Text = db_reader2.GetString("parent1_fullname"); Parent2.Text = db_reader2.GetString("parent2_fullname"); Sponsor1.Text = rdr["sponsor"].ToString(); Sponsor2.Text = rdr["sponsor2"].ToString(); Minister.Text = rdr["minister"].ToString(); Remarks.Text = rdr["remarks"].ToString(); } } } } } else { archiveDrive = "init"; bookNum = db_reader2.GetInt32("book_number"); EntryNum.Value = db_reader2.GetInt32("entry_number"); PageNum.Value = db_reader2.GetInt32("page_number"); ConfirmationDate.Text = db_reader2.GetString("record_date"); FullName.Text = db_reader2.GetString("recordholder_fullname"); Age.Value = db_reader2.GetInt32("age"); PlaceOfBaptism.Text = db_reader2.GetString("place_of_baptism"); Parent1.Text = db_reader2.GetString("parent1_fullname"); Parent2.Text = db_reader2.GetString("parent2_fullname"); Sponsor1.Text = db_reader2.GetString("sponsor"); Sponsor2.Text = db_reader2.GetString("sponsor2"); Minister.Text = db_reader2.GetString("minister"); Remarks.Text = db_reader2.GetString("remarks"); } } } } } else { using (MySqlConnection conn3 = new MySqlConnection(dbman.GetConnStr())) { conn3.Open(); MySqlCommand cmd2 = conn3.CreateCommand(); cmd2.CommandText = "SELECT * FROM records, confirmation_records WHERE records.record_id = @rid AND records.record_id = confirmation_records.record_id ORDER BY records.entry_number ASC;"; cmd2.Parameters.AddWithValue("@rid", recordID); cmd2.Prepare(); using (MySqlDataReader db_reader2 = cmd2.ExecuteReader()) { while (db_reader2.Read()) { bookNum = db_reader2.GetInt32("book_number"); EntryNum.Value = db_reader2.GetInt32("entry_number"); PageNum.Value = db_reader2.GetInt32("page_number"); ConfirmationDate.Text = db_reader2.GetString("record_date"); FullName.Text = db_reader2.GetString("recordholder_fullname"); Age.Value = db_reader2.GetInt32("age"); PlaceOfBaptism.Text = db_reader2.GetString("place_of_baptism"); Parent1.Text = db_reader2.GetString("parent1_fullname"); Parent2.Text = db_reader2.GetString("parent2_fullname"); Sponsor1.Text = db_reader2.GetString("sponsor"); Sponsor2.Text = db_reader2.GetString("sponsor2"); Minister.Text = db_reader2.GetString("minister"); } } } } } } } } } Suggestions1.Visibility = Visibility.Hidden; Suggestions4.Visibility = Visibility.Hidden; }