public MyAccount()
{
pmsutil = new PMSUtil();
InitializeComponent();
NameTextbox.Text = pmsutil.GetEmpName(Application.Current.Resources["uid"].ToString());
SyncMyLogs();
AccountNameHolder.Content = pmsutil.GetEmpName(Application.Current.Resources["uid"].ToString());
AccountRoleHolder.Content = pmsutil.GetAccountType(Application.Current.Resources["uid"].ToString());
}
public AddBurialRecordEntryWindow(ViewRecordEntries viewRE, int targBook)
{
vre = viewRE;
pmsutil = new PMSUtil();
InitializeComponent();
bookNum = targBook;
FetchBookEntryNum();
Stipend.Value = FetchBurialStipend();
}
private void ArchiveItems(object sender, DoWorkEventArgs e)
{
string uid = Application.Current.Resources["uid"].ToString();
string[] dt = pmsutil.GetServerDateTime().Split(null);
cDate = Convert.ToDateTime(dt[0]);
cTime = DateTime.Parse(dt[1] + " " + dt[2]);
curDate = cDate.ToString("yyyy-MM-dd");
curTime = cTime.ToString("HH:mm:ss");
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
//TODO
try
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText =
"INSERT INTO archives(book_number, date_archived, time_archived, archived_by)" +
"VALUES(@book_number, @date_archived, @time_archived, @archived_by)";
cmd.Parameters.AddWithValue("@book_number", bookNum);
cmd.Parameters.AddWithValue("@date_archived", curDate);
cmd.Parameters.AddWithValue("@time_archived", curTime);
cmd.Parameters.AddWithValue("@archived_by", uid);
cmd.Prepare();
int stat_code = cmd.ExecuteNonQuery();
dbman = new DBConnectionManager();
//TODO
try
{
//Phase 1.2
cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText =
"UPDATE registers SET status = @status WHERE book_number = @book_number;";
cmd.Parameters.AddWithValue("@book_number", bookNum);
cmd.Parameters.AddWithValue("@status", "Archived");
cmd.Prepare();
stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
//return 0;
}
stat_code2 = stat_code;
dbman.DBClose();
Phase2();
//return stat_code;
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
//return 0;
}
}
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;
}
private void CreateAccountButton_Click(object sender, RoutedEventArgs e)
{
if (CheckInputs() == true)
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
string uid = Application.Current.Resources["uid"].ToString();
string[] dt = pmsutil.GetServerDateTime().Split(null);
DateTime cDate = Convert.ToDateTime(dt[0]);
DateTime cTime = DateTime.Parse(dt[1] + " " + dt[2]);
string curDate = cDate.ToString("yyyy-MM-dd");
string curTime = cTime.ToString("HH:mm:ss");
string pid = pmsutil.GenPriestID();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText =
"INSERT INTO residing_priests(priest_id, priest_name, priest_status, created_by, date_created, time_created)" +
"VALUES(@priest_id, @priest_name, @priest_status, @created_by, @date_created, @time_created)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@priest_id", pid);
cmd.Parameters.AddWithValue("@priest_name", PriestName.Text);
cmd.Parameters.AddWithValue("@priest_status", Status.Text);
cmd.Parameters.AddWithValue("@created_by", uid);
cmd.Parameters.AddWithValue("@date_created", curDate);
cmd.Parameters.AddWithValue("@time_created", curTime);
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
if (stat_code > 0)
{
_caller.SyncPriest();
pmsutil.LogAccount("Added priest - Name: " + PriestName.Text);
MsgSuccess();
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
}
else
{
}
}
/// <summary>
/// Creates the AddRequestForm Window and Initializes DB Param.
/// </summary>
public ConfirmPaymentWindow(Transactions trans, string transaction_id)
{
tid = transaction_id;
trans1 = trans;
pmsutil = new PMSUtil();
InitializeComponent();
GetInvoiceDetails(transaction_id);
ConfirmButton.Click += ConfirmPayment_Click;
CashTendered.ValueChanged += CashTendered_ValueChanged;
}
public ConfirmPaymentWindow(Transactions trans, System.Collections.IList items)
{
_list = items;
trans1 = trans;
pmsutil = new PMSUtil();
InitializeComponent();
GetInvoiceDetails2();
ConfirmButton.Click += ConfirmPayment_Click2;
CashTendered.ValueChanged += CashTendered_ValueChanged;
}
private void CreateAccountButton_Click(object sender, RoutedEventArgs e)
{
if (CheckDupli() == true)
{
MsgDupli();
}
else
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
string uid = Application.Current.Resources["uid"].ToString();
string[] dt = pmsutil.GetServerDateTime().Split(null);
DateTime cDate = Convert.ToDateTime(dt[0]);
DateTime cTime = DateTime.Parse(dt[1] + " " + dt[2]);
string curDate = cDate.ToString("yyyy-MM-dd");
string curTime = cTime.ToString("HH:mm:ss");
string selTime = HourPicker.Text + ":" + MinutePicker.Text + " " + ModePicker.Text;
string tid = pmsutil.GenTimeSlotID();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText =
"INSERT INTO timeslots(timeslot_id, timeslot, status)" +
"VALUES(@timeslot_id, @timeslot, @status)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@timeslot_id", tid);
cmd.Parameters.AddWithValue("@timeslot", DateTime.Parse(selTime).ToString("HH:mm:ss"));
cmd.Parameters.AddWithValue("@status", Status.Text);
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
if (stat_code > 0)
{
_caller.SyncTimeSlots();
pmsutil.LogAccount("Added Timeslot: " + DateTime.Parse(selTime).ToString("HH:mm:ss"));
MsgSuccess();
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
}
}
/// <summary>
/// Creates the AddRequestForm Window and Initializes DB Param.
/// </summary>
public ManageEventsWindow(DateTime dt)
{
_dt = dt;
pmsutil = new PMSUtil();
InitializeComponent();
SelectedDate.Content = "Selected Date: " + dt.ToString("MMM dd, yyyy");
SyncEvent2();
ItemsPerPage.SelectionChanged += Update2;
CurrentPage.ValueChanged += Update;
}
public AddConfirmationRecordEntryWindow(ViewRecordEntries viewRE, int targBook)
{
vre = viewRE;
pmsutil = new PMSUtil();
InitializeComponent();
bookNum = targBook;
Stipend.Value = FetchConfirmationStipend();
FetchBookEntryNum();
Parish.TextChanged += ShowSuggestions2;
Province.TextChanged += ShowSuggestions3;
}
private void UpdateDirectoryButton_Click(object sender, RoutedEventArgs e)
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
byte[] ImageData;
if (!string.IsNullOrWhiteSpace(imageURI))
{
FileStream fs = new FileStream(imageURI, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
ImageData = br.ReadBytes((int)fs.Length);
br.Close();
fs.Close();
}
else
{
ImageData = null;
}
MySqlCommand cmd = conn.CreateCommand();
cmd = conn.CreateCommand();
cmd.CommandText =
"UPDATE burial_directory SET block = @block, lot = @lot, plot = @plot, gravestone = @gravestone, relative_contact_number = @rcon WHERE record_id = @rid";
cmd.Prepare();
cmd.Parameters.AddWithValue("@rid", _rid);
cmd.Parameters.AddWithValue("@block", Block.Text);
cmd.Parameters.AddWithValue("@lot", Lot.Text);
cmd.Parameters.AddWithValue("@plot", Plot.Text);
cmd.Parameters.AddWithValue("@gravestone", ImageData);
cmd.Parameters.AddWithValue("@rcon", RContactNo.Text);
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
if (stat_code > 0)
{
MsgSuccess();
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
}
/// <summary>
/// Creates the AddRequestForm Window and Initializes DB Param.
/// </summary>
public EditRegisterWindow(Registers reg, int bookNumx)
{
_bookNum = bookNumx;
reg1 = reg;
pmsutil = new PMSUtil();
InitializeComponent();
BookNo.Value = bookNumx;
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 registers WHERE book_number = @book_num LIMIT 1;";
cmd.Parameters.AddWithValue("@book_num", bookNumx);
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
if (db_reader.GetString("book_type") == "Baptismal")
{
RegisterType.SelectedIndex = 0;
}
else if (db_reader.GetString("book_type") == "Confirmation")
{
RegisterType.SelectedIndex = 1;
}
else if (db_reader.GetString("book_type") == "Matrimonial")
{
RegisterType.SelectedIndex = 2;
}
else if (db_reader.GetString("book_type") == "Burial")
{
RegisterType.SelectedIndex = 3;
}
RegisterNo.Value = db_reader.GetInt32("register_number");
Book.Text = db_reader.GetString("book");
CreationDate.Text = db_reader.GetString("creation_date");
}
}
}
}
}
}
private void GetInvoiceDetails2()
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
double total = 0;
for (int i = 0; i < _list.Count; i++)
{
Transaction ti = (Transaction)_list[i];
total = total + ti.Fee;
}
AmountToBePaid.Content = total;
}
private void CreateEventTypeButton_Click(object sender, RoutedEventArgs e)
{
if (CheckInputs() == true)
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
string eid = pmsutil.GenEventTypeID();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText =
"INSERT INTO appointment_types(type_id, appointment_type, custom, fee, status)" +
"VALUES(@eid, @appointment_type, @custom, @fee, @status)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@eid", eid);
cmd.Parameters.AddWithValue("@appointment_type", EType.Text);
cmd.Parameters.AddWithValue("@custom", Status.SelectedIndex + 1);
cmd.Parameters.AddWithValue("@fee", Fee.Value);
cmd.Parameters.AddWithValue("@status", Active.SelectedIndex + 1);
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
if (stat_code > 0)
{
_caller.SyncEventTypes();
pmsutil.LogAccount("Added event type - Type: " + EType.Text + " Fee: " + Fee.Value);
MsgSuccess();
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
}
else
{
}
}
private void EditEventTypeButton_Click(object sender, RoutedEventArgs e)
{
if (CheckInputs() == true)
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd = conn.CreateCommand();
cmd.CommandText =
"UPDATE appointment_types SET appointment_type = @appointment_type, custom = @custom, fee = @fee, status = @status WHERE type_id = @tid";
cmd.Prepare();
cmd.Parameters.AddWithValue("@tid", _tid);
cmd.Parameters.AddWithValue("@appointment_type", EType.Text);
cmd.Parameters.AddWithValue("@custom", Status.SelectedIndex + 1);
cmd.Parameters.AddWithValue("@fee", Fee.Value);
cmd.Parameters.AddWithValue("@status", Active.SelectedIndex + 1);
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
if (stat_code > 0)
{
_caller.SyncEventTypes();
pmsutil.LogAccount("Edited Event Type: " + EType.Text);
MsgSuccess();
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
}
else
{
}
}
/// <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();
}
private void EditPriestButton_Click(object sender, RoutedEventArgs e)
{
if (CheckInputs() == true)
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText =
"UPDATE residing_priests SET priest_name = @priest_name, priest_status = @priest_status WHERE priest_id = @pid";
cmd.Prepare();
cmd.Parameters.AddWithValue("@pid", pid);
cmd.Parameters.AddWithValue("@priest_name", PriestName.Text);
cmd.Parameters.AddWithValue("@priest_status", Status.Text);
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
if (stat_code > 0)
{
_caller.SyncPriest();
pmsutil.LogAccount("Edited Priest: " + PriestName.Text);
MsgSuccess();
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
}
else
{
}
}
internal void CheckArchiveDrive()
{
DriveInfo[] allDrives = DriveInfo.GetDrives();
pmsutil = new PMSUtil();
if (pmsutil.CheckArchiveDrive(path) != "dc")
{
this.Dispatcher.Invoke(() =>
{
ArchiveStatus.Content = "Archive Status: Connected";
archiveDrive = pmsutil.CheckArchiveDrive(path);
});
}
else
{
this.Dispatcher.Invoke(() =>
{
ArchiveStatus.Content = "Archive Status: Disconnected";
archiveDrive = "init";
});
}
Thread.Sleep(5000); // 5sec
}
/// <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();
}
private void GetInvoiceDetails(string tid)
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM transactions WHERE transaction_id = @tid";
cmd.Prepare();
cmd.Parameters.AddWithValue("@tid", tid);
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
AmountToBePaid.Content = db_reader.GetString("fee");
}
}
}
}
}
/// <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();
}
public ViewHistoryWindow(string recordID)
{
InitializeComponent();
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT * FROM records_log, accounts WHERE record_id = @record_id;";
cmd.Parameters.AddWithValue("@record_id", recordID);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
history = new ObservableCollection <HistoryItem>();
while (db_reader.Read())
{
if (db_reader.GetString("log_code") == "LOGC-01")
{
history.Add(new HistoryItem()
{
Details = "Recorded by " + pmsutil.GetUsername(db_reader.GetString("log_creator")),
Date = DateTime.Parse(db_reader.GetString("log_date")).ToString("MMM dd, yyyy"),
Time = DateTime.Parse(db_reader.GetString("log_time")).ToString("hh:mm tt"),
Purpose = "NA"
});
}
else if (db_reader.GetString("log_code") == "LOGC-02")
{
history.Add(new HistoryItem()
{
Details = "Edited by " + pmsutil.GetUsername(db_reader.GetString("log_creator")),
Date = DateTime.Parse(db_reader.GetString("log_date")).ToString("MMM dd, yyyy"),
Time = DateTime.Parse(db_reader.GetString("log_time")).ToString("hh:mm tt"),
Purpose = "NA"
});
}
else if (db_reader.GetString("log_code") == "LOGC-03")
{
history.Add(new HistoryItem()
{
Details = "Certificate printed by " + pmsutil.GetUsername(db_reader.GetString("log_creator")),
Date = DateTime.Parse(db_reader.GetString("log_date")).ToString("MMM dd, yyyy"),
Time = DateTime.Parse(db_reader.GetString("log_time")).ToString("hh:mm tt"),
Purpose = "For Reference"
});
}
else if (db_reader.GetString("log_code") == "LOGC-04")
{
history.Add(new HistoryItem()
{
Details = "Certificate printed by " + pmsutil.GetUsername(db_reader.GetString("log_creator")),
Date = DateTime.Parse(db_reader.GetString("log_date")).ToString("MMM dd, yyyy"),
Time = DateTime.Parse(db_reader.GetString("log_time")).ToString("HH:mm tt"),
Purpose = "For Marriage"
});
}
}
//close Connection
dbman.DBClose();
}
else
{
}
HistoryContainer2.ItemsSource = history;
}
private void DoWork(object sender, DoWorkEventArgs e)
{
try
{
DataTable dt = new DataTable();
dt = ((DataView)databap.ItemsSource).ToTable();
for (int i = 0; i < dt.Rows.Count; i++)
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
bool doProceed = false;
//Check inputs
for (int _tmp = 0; _tmp < 12; _tmp++)
{
if (String.IsNullOrEmpty(dt.Rows[i][i].ToString()) == true)
{
doProceed = false;
}
else
{
doProceed = true;
}
}
if (doProceed == true)
{
App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
{
PBar.Visibility = Visibility.Visible;
CancelButton1.IsEnabled = false;
ConfirmBtn.IsEnabled = false;
string recID = pmsutil.GenRecordID();
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText =
"INSERT INTO records(record_id, book_number, page_number, entry_number, record_date, recordholder_fullname, parent1_fullname, parent2_fullname)" +
"VALUES(@record_id, @book_number, @page_number, @entry_number, @record_date, @recordholder_fullname, @parent1_fullname, @parent2_fullname)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@record_id", recID);
cmd.Parameters.AddWithValue("@book_number", _bookNum);
cmd.Parameters.AddWithValue("@page_number", PageNum.Value);
cmd.Parameters.AddWithValue("@entry_number", Convert.ToInt32(dt.Rows[i][0].ToString()));
cmd.Parameters.AddWithValue("@record_date", dt.Rows[i][1].ToString());
cmd.Parameters.AddWithValue("@recordholder_fullname", dt.Rows[i][2].ToString());
cmd.Parameters.AddWithValue("@parent1_fullname", dt.Rows[i][6].ToString());
cmd.Parameters.AddWithValue("@parent2_fullname", dt.Rows[i][7].ToString());
int stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText =
"INSERT INTO baptismal_records(record_id, birthday, legitimacy, place_of_birth, sponsor1, sponsor2, stipend, minister, remarks)" +
"VALUES(@record_id, @birthday, @legitimacy, @place_of_birth, @sponsor1, @sponsor2, @stipend, @minister, @remarks)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@record_id", recID);
cmd.Parameters.AddWithValue("@birthday", dt.Rows[i][3].ToString());
cmd.Parameters.AddWithValue("@legitimacy", dt.Rows[i][4].ToString());
cmd.Parameters.AddWithValue("@place_of_birth", dt.Rows[i][5].ToString());
cmd.Parameters.AddWithValue("@sponsor1", dt.Rows[i][8].ToString());
cmd.Parameters.AddWithValue("@sponsor2", dt.Rows[i][9].ToString());
cmd.Parameters.AddWithValue("@stipend", Convert.ToDouble(dt.Rows[i][10].ToString()));
cmd.Parameters.AddWithValue("@minister", dt.Rows[i][11].ToString());
cmd.Parameters.AddWithValue("@remarks", dt.Rows[i][12].ToString());
stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
string tmp = pmsutil.LogRecord(recID, "LOGC-01");
//return stat_code;
_statcode = stat_code;
PBar.Visibility = Visibility.Hidden;
CancelButton1.IsEnabled = true;
ConfirmBtn.IsEnabled = true;
});
}
else
{
_statcode = 601;
}
}
else
{
}
}
}
this.Close();
}
catch
{
}
}
private DataTable GenerateList()
{
DataTable dtNames = new DataTable();
if (ListType.SelectedIndex == 2)
{
dtNames.Columns.Add("No", typeof(string));
dtNames.Columns.Add("Time", typeof(string));
dtNames.Columns.Add("Type", typeof(string));
dtNames.Columns.Add("Sponsor", typeof(string));
dtNames.Columns.Add("Venue", typeof(string));
dtNames.Columns.Add("Remarks", typeof(string));
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
//Year
using (MySqlConnection conn2 = new MySqlConnection(dbman.GetConnStr()))
{
string[] dt = pmsutil.GetServerDateTime().Split(null);
DateTime cDate = Convert.ToDateTime(dt[0]);
conn2.Open();
MySqlCommand cmd = conn2.CreateCommand();
cmd.CommandText = "SELECT * FROM appointments WHERE appointment_date > @min AND appointment_date < @max ORDER BY appointment_date ASC;";
cmd.Parameters.AddWithValue("@min", DateTime.Parse(ListMinDate.SelectedDate.ToString()));
cmd.Parameters.AddWithValue("@max", DateTime.Parse(ListMaxDate.SelectedDate.ToString()));
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
int count = 1;
while (db_reader.Read())
{
if (ListType.SelectedIndex == 0)
{
dtNames.Rows.Add(count, DateTime.Parse(db_reader.GetString("appointment_time")).ToString("hh:mm tt"), GetAType(db_reader.GetString("appointment_type")), db_reader.GetString("requested_by"), db_reader.GetString("venue"), db_reader.GetString("remarks"));
}
else if (ListType.SelectedIndex == 1)
{
if (IsCustom(db_reader.GetString("appointment_type")) == false)
{
dtNames.Rows.Add(count, DateTime.Parse(db_reader.GetString("appointment_time")).ToString("hh:mm tt"), GetAType(db_reader.GetString("appointment_type")), db_reader.GetString("requested_by"), db_reader.GetString("venue"), db_reader.GetString("remarks"));
}
}
else
{
if (IsCustom(db_reader.GetString("appointment_type")) == true)
{
dtNames.Rows.Add(count, DateTime.Parse(db_reader.GetString("appointment_time")).ToString("hh:mm tt"), GetAType(db_reader.GetString("appointment_type")), db_reader.GetString("requested_by"), db_reader.GetString("venue"), db_reader.GetString("remarks"));
}
}
count++;
}
}
}
}
}
}
else
{
dtNames.Columns.Add("No", typeof(string));
dtNames.Columns.Add("Time", typeof(string));
dtNames.Columns.Add("Type", typeof(string));
dtNames.Columns.Add("Sponsor", typeof(string));
dtNames.Columns.Add("Remarks", typeof(string));
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
//Year
using (MySqlConnection conn2 = new MySqlConnection(dbman.GetConnStr()))
{
string[] dt = pmsutil.GetServerDateTime().Split(null);
DateTime cDate = Convert.ToDateTime(dt[0]);
conn2.Open();
MySqlCommand cmd = conn2.CreateCommand();
cmd.CommandText = "SELECT * FROM appointments WHERE appointment_date > @min AND appointment_date < @max ORDER BY appointment_date ASC;";
cmd.Parameters.AddWithValue("@min", DateTime.Parse(ListMinDate.SelectedDate.ToString()));
cmd.Parameters.AddWithValue("@max", DateTime.Parse(ListMaxDate.SelectedDate.ToString()));
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
int count = 1;
while (db_reader.Read())
{
if (ListType.SelectedIndex == 0)
{
dtNames.Rows.Add(count, DateTime.Parse(db_reader.GetString("appointment_time")).ToString("hh:mm tt"), GetAType(db_reader.GetString("appointment_type")), db_reader.GetString("requested_by"), db_reader.GetString("remarks"));
}
else if (ListType.SelectedIndex == 1)
{
if (IsCustom(db_reader.GetString("appointment_type")) == false)
{
dtNames.Rows.Add(count, DateTime.Parse(db_reader.GetString("appointment_time")).ToString("hh:mm tt"), GetAType(db_reader.GetString("appointment_type")), db_reader.GetString("requested_by"), db_reader.GetString("remarks"));
}
}
else
{
if (IsCustom(db_reader.GetString("appointment_type")) == true)
{
dtNames.Rows.Add(count, DateTime.Parse(db_reader.GetString("appointment_time")).ToString("hh:mm tt"), GetAType(db_reader.GetString("appointment_type")), db_reader.GetString("requested_by"), db_reader.GetString("remarks"));
}
}
count++;
}
}
}
}
}
}
return(dtNames);
}
private void GenerateDailyReport()
{
pmsutil = new PMSUtil();
string[] dt = pmsutil.GetServerDateTime().Split(null);
DateTime cDate = Convert.ToDateTime(dt[0]);
DateTime cTime = DateTime.Parse(dt[1] + " " + dt[2]);
PdfDocument pdfDoc = new PdfDocument();
PdfPageBase page = pdfDoc.Pages.Add();
var stream = this.GetType().GetTypeInfo().Assembly.GetManifestResourceStream("PMS.Assets.st_raphael_logo_dark.png");
PdfImage logo = PdfImage.FromStream(stream);
float _width = 200;
float height = 80;
float x = (page.Canvas.ClientSize.Width - _width) / 2;
page.Canvas.DrawImage(logo, 0, -25, _width, height);
page.Canvas.DrawString("Peñaranda St, Legazpi Port District",
new PdfFont(PdfFontFamily.TimesRoman, 13f),
new PdfSolidBrush(Color.Black),
245, 0);
page.Canvas.DrawString("Legazpi City, Albay",
new PdfFont(PdfFontFamily.TimesRoman, 13f),
new PdfSolidBrush(Color.Black),
280, 20);
page.Canvas.DrawLine(new PdfPen(Color.Black), new PointF(1, 49), new PointF(530, 49));
page.Canvas.DrawString("PMS Scheduling Module Report",
new PdfFont(PdfFontFamily.TimesRoman, 12f),
new PdfSolidBrush(Color.Black),
350, 52);
page.Canvas.DrawString("Generated on: " + DateTime.Now.ToString("MMMM dd, yyyy hh:mm tt"),
new PdfFont(PdfFontFamily.TimesRoman, 12f),
new PdfSolidBrush(Color.Black),
10, 52);
page.Canvas.DrawString("Type: " + ListType.Text,
new PdfFont(PdfFontFamily.TimesRoman, 12f),
new PdfSolidBrush(System.Drawing.Color.Black),
380, 90);
page.Canvas.DrawLine(new PdfPen(Color.Black), new PointF(1, 70), new PointF(530, 70));
if (ListType.SelectedIndex == 1)
{
page.Canvas.DrawString(cDate.ToString("MMMM dd, yyyy").ToUpper() + " (" + cDate.ToString("dddd").ToUpper() + ")",
new PdfFont(PdfFontFamily.TimesRoman, 12f),
new PdfSolidBrush(Color.Black),
10, 90);
}
else
{
page.Canvas.DrawString(DateTime.Parse(ListMinDate.SelectedDate.ToString()).ToString("MMMM dd, yyyy").ToUpper() + " TO " + DateTime.Parse(ListMaxDate.SelectedDate.ToString()).ToString("MMMM dd, yyyy").ToUpper(),
new PdfFont(PdfFontFamily.TimesRoman, 12f),
new PdfSolidBrush(Color.Black),
10, 90);
}
PdfTable table = new PdfTable();
table.Style.CellPadding = 2;
table.Style.DefaultStyle.Font = new PdfTrueTypeFont(new Font("Times New Roman", 11f));
table.Style.AlternateStyle = new PdfCellStyle();
table.Style.AlternateStyle.Font = new PdfTrueTypeFont(new Font("Times New Roman", 11f));
table.Style.HeaderSource = PdfHeaderSource.ColumnCaptions;
table.Style.HeaderStyle.Font = new PdfFont(PdfFontFamily.TimesRoman, 13f);
table.Style.HeaderStyle.StringFormat = new PdfStringFormat(PdfTextAlignment.Center);
table.Style.ShowHeader = true;
table.DataSourceType = PdfTableDataSourceType.TableDirect;
table.DataSource = GenerateList();
//Set the width of column
float width = page.Canvas.ClientSize.Width - (table.Columns.Count + 1);
table.Columns[0].Width = width * 0.24f * width;
table.Columns[0].StringFormat = new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle);
table.Columns[1].Width = width * 0.21f * width;
table.Columns[1].StringFormat = new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle);
table.Columns[2].Width = width * 0.24f * width;
table.Columns[2].StringFormat = new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle);
table.Columns[3].Width = width * 0.24f * width;
table.Columns[3].StringFormat = new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle);
table.Columns[4].Width = width * 0.24f * width;
table.Columns[4].StringFormat = new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle);
if (ListType.SelectedIndex == 2)
{
table.Columns[5].Width = width * 0.24f * width;
table.Columns[5].StringFormat = new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle);
}
table.Draw(page, new PointF(10, 120));
string fname = "Scheduling_Report-" + ListType.Text + "-" + DateTime.Now.ToString("MMM_dd_yyyy") + ".pdf";
//save
pdfDoc.SaveToFile(@"..\..\" + fname);
//launch the pdf document
System.Diagnostics.Process.Start(@"..\..\" + fname);
}
private void SyncMatrimonialEntries(int targBook, int pageNum)
{
records = new ObservableCollection <RecordEntryMatrimonial>();
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 registers WHERE book_number = @book_number LIMIT 1;";
cmd.Parameters.AddWithValue("@book_number", targBook);
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
if (db_reader.GetString("status") == "Archived")
{
MsgArchived();
EditRegButton.IsEnabled = false;
PrintRegButton.IsEnabled = false;
using (MySqlConnection conn3 = new MySqlConnection(dbman.GetConnStr()))
{
conn3.Open();
MySqlCommand cmd2 = conn3.CreateCommand();
cmd2.CommandText = "SELECT * FROM records WHERE records.book_number = @book_number AND records.page_number = @page_number ORDER BY records.entry_number ASC;";
cmd2.Parameters.AddWithValue("@book_number", targBook);
cmd2.Parameters.AddWithValue("@page_number", pageNum);
cmd2.Prepare();
using (MySqlDataReader db_reader2 = cmd2.ExecuteReader())
{
string archiveDrive = "init";
string path = @"\archive.db";
while (db_reader2.Read())
{
pmsutil = new PMSUtil();
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 matrimonial_records WHERE record_id='" + db_reader2.GetString("record_id") + "';";
using (SQLiteCommand cmdx = new SQLiteCommand(stm, connection))
{
using (SQLiteDataReader rdr = cmdx.ExecuteReader())
{
EditRegButton.IsEnabled = true;
PrintRegButton.IsEnabled = true;
while (rdr.Read())
{
App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
{
records.Add(new RecordEntryMatrimonial()
{
RecordID = db_reader2.GetString("record_id"),
EntryNumber = db_reader2.GetInt32("entry_number"),
MarriageYear = DateTime.Parse(db_reader2.GetString("record_date")).ToString("yyyy"),
MarriageDate = DateTime.Parse(db_reader2.GetString("record_date")).ToString("MMM dd"),
FullName1 = db_reader2.GetString("recordholder_fullname"),
FullName2 = rdr["recordholder2_fullname"].ToString(),
Status1 = rdr["status1"].ToString(),
Status2 = rdr["status2"].ToString(),
Age1 = Convert.ToInt32(rdr["age1"]),
Age2 = Convert.ToInt32(rdr["age2"]),
Hometown1 = rdr["place_of_origin1"].ToString(),
Hometown2 = rdr["place_of_origin2"].ToString(),
Residence1 = rdr["residence1"].ToString(),
Residence2 = rdr["residence2"].ToString(),
Parent1 = db_reader2.GetString("parent1_fullname"),
Parent2 = db_reader2.GetString("parent2_fullname"),
Parent3 = rdr["parent1_fullname2"].ToString(),
Parent4 = rdr["parent2_fullname2"].ToString(),
Witness1 = rdr["witness1"].ToString(),
Witness2 = rdr["witness2"].ToString(),
W1Residence = rdr["witness1address"].ToString(),
W2Residence = rdr["witness2address"].ToString(),
Stipend = Convert.ToDouble(rdr["stipend"]),
Minister = rdr["minister"].ToString()
});
});
}
}
}
}
}
else
{
archiveDrive = "init";
App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
{
records.Add(new RecordEntryMatrimonial()
{
RecordID = db_reader2.GetString("record_id"),
EntryNumber = db_reader2.GetInt32("entry_number"),
MarriageYear = DateTime.Parse(db_reader2.GetString("record_date")).ToString("yyyy"),
MarriageDate = DateTime.Parse(db_reader2.GetString("record_date")).ToString("MMM dd"),
FullName1 = db_reader2.GetString("recordholder_fullname"),
FullName2 = "---",
Status1 = "---",
Status2 = "---",
Age1 = 0,
Age2 = 0,
Hometown1 = "---",
Hometown2 = "---",
Residence1 = "---",
Residence2 = "---",
Parent1 = "---",
Parent2 = "---",
Parent3 = "---",
Parent4 = "---",
Witness1 = "---",
Witness2 = "---",
W1Residence = "---",
W2Residence = "---",
Stipend = 0,
Minister = "---"
});
});
}
}
}
}
}
else
{
using (MySqlConnection conn3 = new MySqlConnection(dbman.GetConnStr()))
{
conn3.Open();
MySqlCommand cmd2 = conn3.CreateCommand();
cmd2.CommandText = "SELECT * FROM records, matrimonial_records WHERE records.book_number = @book_number AND records.page_number = @page_number AND records.record_id = matrimonial_records.record_id ORDER BY records.entry_number ASC;";
cmd2.Parameters.AddWithValue("@book_number", targBook);
cmd2.Parameters.AddWithValue("@page_number", pageNum);
cmd2.Prepare();
using (MySqlDataReader db_reader2 = cmd2.ExecuteReader())
{
while (db_reader2.Read())
{
App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
{
records.Add(new RecordEntryMatrimonial()
{
RecordID = db_reader2.GetString("record_id"),
EntryNumber = db_reader2.GetInt32("entry_number"),
MarriageYear = DateTime.Parse(db_reader2.GetString("record_date")).ToString("yyyy"),
MarriageDate = DateTime.Parse(db_reader2.GetString("record_date")).ToString("MMM dd"),
FullName1 = db_reader2.GetString("recordholder_fullname"),
FullName2 = db_reader2.GetString("recordholder2_fullname"),
Status1 = db_reader2.GetString("status1"),
Status2 = db_reader2.GetString("status2"),
Age1 = db_reader2.GetInt32("age1"),
Age2 = db_reader2.GetInt32("age2"),
Hometown1 = db_reader2.GetString("place_of_origin1"),
Hometown2 = db_reader2.GetString("place_of_origin2"),
Residence1 = db_reader2.GetString("residence1"),
Residence2 = db_reader2.GetString("residence2"),
Parent1 = db_reader2.GetString("parent1_fullname"),
Parent2 = db_reader2.GetString("parent2_fullname"),
Parent3 = db_reader2.GetString("parent1_fullname2"),
Parent4 = db_reader2.GetString("parent2_fullname2"),
Witness1 = db_reader2.GetString("witness1"),
Witness2 = db_reader2.GetString("witness2"),
W1Residence = db_reader2.GetString("witness1address"),
W2Residence = db_reader2.GetString("witness2address"),
Stipend = db_reader2.GetFloat("stipend"),
Minister = db_reader2.GetString("minister")
});
});
}
}
}
}
}
}
}
SyncChanges();
System.Threading.Thread.Sleep(1);
}
else
{
}
//close Connection
//conn.Close();
}
}
public ViewInfoWindow(string rid)
{
_rid = rid;
InitializeComponent();
pmsutil = new PMSUtil();
dbman = new DBConnectionManager();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM records, burial_records, burial_directory WHERE records.record_id = burial_records.record_id AND burial_records.record_id = burial_directory.record_id AND burial_directory.record_id = @rid LIMIT 1;";
cmd.Parameters.AddWithValue("@rid", rid);
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
_name = db_reader.GetString("recordholder_fullname");
_age = db_reader.GetString("age");
_residence = db_reader.GetString("residence");
_parent1 = db_reader.GetString("parent1_fullname");
_parent2 = db_reader.GetString("parent2_fullname");
_deathDate = DateTime.Parse(db_reader.GetString("record_date")).ToString("MMMM dd, yyyy");
_burialDate = DateTime.Parse(db_reader.GetString("burial_date")).ToString("MMMM dd, yyyy");
_causeOfDeath = db_reader.GetString("cause_of_death");
_sacrament = db_reader.GetString("sacrament");
_interment = db_reader.GetString("place_of_interment");
NameHolder.Content = db_reader.GetString("recordholder_fullname").ToUpper();
AgeHolder.Content = db_reader.GetInt32("age");
ResidenceHolder.Content = db_reader.GetString("residence");
Parent1Holder.Content = db_reader.GetString("parent1_fullname");
Parent2Holder.Content = db_reader.GetString("parent2_fullname");
DateOfDeathHolder.Content = DateTime.Parse(db_reader.GetString("record_date")).ToString("MMMM dd, yyyy");
BurialDateHolder.Content = DateTime.Parse(db_reader.GetString("burial_date")).ToString("MMMM dd, yyyy");
CauseOfDeathHolder.Content = db_reader.GetString("cause_of_death");
SacramentHolder.Content = db_reader.GetString("sacrament");
PlaceOfIntermentHolder.Text = db_reader.GetString("place_of_interment");
}
conn.Close();
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT gravestone FROM burial_directory WHERE burial_directory.record_id = @rid LIMIT 1;";
cmd.Parameters.AddWithValue("@rid", rid);
db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
var tmpy = db_reader.GetOrdinal("gravestone");
if (db_reader.IsDBNull(tmpy))
{
//Load default img
}
else
{
byte[] data = (byte[])db_reader[0];
using (System.IO.MemoryStream ms = new System.IO.MemoryStream(data))
{
var imageSource = new BitmapImage();
imageSource.BeginInit();
imageSource.StreamSource = ms;
imageSource.CacheOption = BitmapCacheOption.OnLoad;
imageSource.EndInit();
// Assign the Source property of your image
GravePicture.Source = imageSource;
}
}
}
conn.Close();
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT block, lot, plot FROM burial_directory WHERE burial_directory.record_id = @rid LIMIT 1;";
cmd.Parameters.AddWithValue("@rid", rid);
db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
_block = db_reader.GetString("block");
_lot = db_reader.GetString("lot");
_plot = db_reader.GetString("plot");
BlockHolder.Content = db_reader.GetString("block");
LotHolder.Content = db_reader.GetString("lot");
PlotHolder.Content = db_reader.GetString("plot");
}
conn.Close();
}
}
GetNearbyGraves();
}
private async void ConfirmPayment_Click(object sender, RoutedEventArgs e)
{
if (TransactionItemsContainer.SelectedItems.Count == 1)
{
Transaction ti = (Transaction)TransactionItemsContainer.SelectedItem;
//Label transactionID = (Label)ti.FindName("IDLabel");
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM transactions WHERE transaction_id = @transaction_id LIMIT 1;";
cmd.Parameters.AddWithValue("@transaction_id", ti.TransactionID);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetString("status") == "Paid")
{
MsgAlreadyPaid();
}
else if (db_reader.GetString("status") == "Cancelled")
{
MsgCancelled();
}
else
{
var metroWindow = (Application.Current.MainWindow as MetroWindow);
await metroWindow.ShowChildWindowAsync(new ConfirmPaymentWindow(this, ti.TransactionID));
}
}
}
}
}
else
{
Transaction transaction = (Transaction)TransactionItemsContainer.SelectedItem;
if (transaction == null)
{
MsgNoItemSelected();
}
else
{
int doProceed = 0;
for (int i = 0; i < TransactionItemsContainer.SelectedItems.Count; i++)
{
Transaction recordx = (Transaction)TransactionItemsContainer.SelectedItems[i];
if (CheckTrans(recordx.TransactionID) == 0)
{
doProceed = 0;
}
else if (CheckTrans(recordx.TransactionID) == 1)
{
doProceed = 1;
}
else if (CheckTrans(recordx.TransactionID) == 2)
{
doProceed = 2;
}
}
if (doProceed == 0)
{
MsgAlreadyPaid();
}
else if (doProceed == 1)
{
MsgCancelled();
}
else
{
var metroWindow = (Application.Current.MainWindow as MetroWindow);
await metroWindow.ShowChildWindowAsync(new ConfirmPaymentWindow(this, TransactionItemsContainer.SelectedItems));
}
}
}
}
/// <summary>
/// Updates Stats
/// </summary>
private void SyncStat()
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
//Counts Total
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM transactions;";
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
TotalRequestsHolder.Content = db_reader.GetString("COUNT(*)");
}
//close Connection
conn.Close();
conn.Open();
//Counts Baptismal
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM transactions WHERE type = @type;";
cmd.Parameters.AddWithValue("@type", "Baptismal Cert.");
cmd.Prepare();
db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
StatBaptismalHolder.Content = db_reader.GetString("COUNT(*)");
}
//close Connection
conn.Close();
conn.Open();
//Counts Confirmation
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM transactions WHERE type = @type;";
cmd.Parameters.AddWithValue("@type", "Confirmation Cert.");
cmd.Prepare();
db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
StatConfirmationHolder.Content = db_reader.GetString("COUNT(*)");
}
//close Connection
conn.Close();
conn.Open();
//Counts Burial
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM transactions WHERE type = @type;";
cmd.Parameters.AddWithValue("@type", "Burial Cert.");
cmd.Prepare();
db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
StatBurialHolder.Content = db_reader.GetString("COUNT(*)");
}
//close Connection
conn.Close();
conn.Open();
//Counts Marriage
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM transactions WHERE type = @type;";
cmd.Parameters.AddWithValue("@type", "Matrimonial Cert.");
cmd.Prepare();
db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
StatMatrimonialHolder.Content = db_reader.GetString("COUNT(*)");
}
//close Connection
conn.Close();
conn.Open();
//Counts Paying
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM transactions WHERE status = @status;";
cmd.Parameters.AddWithValue("@status", "Unpaid");
cmd.Prepare();
db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
BadgePaying.Badge = db_reader.GetString("COUNT(*)");
}
//close Connection
conn.Close();
conn.Open();
//Counts Finished
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM transactions WHERE status = @status;";
cmd.Parameters.AddWithValue("@status", "Paid");
cmd.Prepare();
db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
BadgeFinished.Badge = db_reader.GetString("COUNT(*)");
}
//close Connection
conn.Close();
conn.Open();
//Counts Cancelled
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM transactions WHERE status = @status;";
cmd.Parameters.AddWithValue("@status", "Cancelled");
cmd.Prepare();
db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
BadgeCancelled.Badge = db_reader.GetString("COUNT(*)");
}
//close Connection
conn.Close();
}
}
}
private void SyncBaptismalEntries(string query, string type)
{
pmsutil = new PMSUtil();
records = new ObservableCollection <RecordEntryBaptismal>();
records_final = new ObservableCollection <RecordEntryBaptismal>();
ComboBoxItem ci = (ComboBoxItem)ItemsPerPage.SelectedItem;
int itemsPerPage = Convert.ToInt32(ci.Content);
int page = 1;
int count = 0;
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 cmd2 = conn2.CreateCommand();
if (_coverage == 0)
{
//All
cmd2.CommandText = "SELECT DISTINCT * FROM records, registers WHERE registers.book_type = @book_type AND records.book_number = registers.book_number AND " +
"(records.recordholder_fullname LIKE @query OR " +
"records.parent1_fullname LIKE @query OR " +
"records.parent2_fullname LIKE @query) ORDER BY records.entry_number ASC;";
cmd2.Parameters.AddWithValue("@book_type", type);
cmd2.Parameters.AddWithValue("@query", "%" + query + "%");
}
else if (_coverage == 1)
{
//Name
cmd2.CommandText = "SELECT DISTINCT * FROM records, registers WHERE registers.book_type = @book_type AND records.book_number = registers.book_number AND " +
"(records.recordholder_fullname LIKE @query) ORDER BY records.entry_number ASC;";
cmd2.Parameters.AddWithValue("@book_type", type);
cmd2.Parameters.AddWithValue("@query", "%" + query + "%");
}
else if (_coverage == 2)
{
DateTime dateValue;
if (DateTime.TryParse(query, out dateValue))
{
//Date
cmd2.CommandText = "SELECT DISTINCT * FROM records, registers WHERE registers.book_type = @book_type AND records.book_number = registers.book_number AND " +
"(records.record_date LIKE @query) ORDER BY records.entry_number ASC;";
cmd2.Parameters.AddWithValue("@book_type", type);
cmd2.Parameters.AddWithValue("@query", "%" + DateTime.Parse(query).ToString("yyyy-MM-dd") + "%");
}
else
{
MsgNotDate();
//Date
cmd2.CommandText = "SELECT DISTINCT * FROM records, registers WHERE registers.book_type = @book_type AND records.book_number = registers.book_number AND " +
"(records.record_date LIKE @query) ORDER BY records.entry_number ASC;";
cmd2.Parameters.AddWithValue("@book_type", type);
cmd2.Parameters.AddWithValue("@query", "%" + query + "%");
}
}
else if (_coverage == 3)
{
//Parents
cmd2.CommandText = "SELECT DISTINCT * FROM records, registers WHERE registers.book_type = @book_type AND records.book_number = registers.book_number AND " +
"(records.parent1_fullname LIKE @query OR " +
"records.parent2_fullname LIKE @query) ORDER BY records.entry_number ASC;";
cmd2.Parameters.AddWithValue("@book_type", type);
cmd2.Parameters.AddWithValue("@query", "%" + query + "%");
}
cmd2.Prepare();
using (MySqlDataReader db_reader2 = cmd2.ExecuteReader())
{
string archiveDrive = "init";
while (db_reader2.Read())
{
if (db_reader2.GetString("status") == "Archived")
{
string path = @"\archive.db";
pmsutil = new PMSUtil();
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 baptismal_records WHERE record_id='" + db_reader2.GetString("record_id") + "';";
using (SQLiteCommand cmdx = new SQLiteCommand(stm, connection))
{
using (SQLiteDataReader rdr = cmdx.ExecuteReader())
{
while (rdr.Read())
{
DateTime dateOfBirth = Convert.ToDateTime(rdr["birthday"].ToString());
App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
{
records.Add(new RecordEntryBaptismal()
{
RecordID = db_reader2.GetString("record_id"),
EntryNumber = db_reader2.GetInt32("entry_number"),
BaptismalYear = DateTime.Parse(db_reader2.GetString("record_date")).ToString("yyyy"),
BaptismalDate = DateTime.Parse(db_reader2.GetString("record_date")).ToString("MMM dd"),
FullName = db_reader2.GetString("recordholder_fullname"),
BirthDate = dateOfBirth.ToString("MMM dd, yyyy"),
Legitimacy = rdr["legitimacy"].ToString(),
PlaceOfBirth = rdr["place_of_birth"].ToString(),
Parent1 = db_reader2.GetString("parent1_fullname"),
Parent2 = db_reader2.GetString("parent2_fullname"),
Godparent1 = rdr["sponsor1"].ToString(),
Godparent2 = rdr["sponsor2"].ToString(),
Stipend = Convert.ToDouble(rdr["stipend"]),
Minister = rdr["minister"].ToString(),
Page = page
});
});
}
}
}
}
}
else
{
archiveDrive = "init";
App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
{
records.Add(new RecordEntryBaptismal()
{
RecordID = db_reader2.GetString("record_id"),
EntryNumber = db_reader2.GetInt32("entry_number"),
BaptismalYear = DateTime.Parse(db_reader2.GetString("record_date")).ToString("yyyy"),
BaptismalDate = DateTime.Parse(db_reader2.GetString("record_date")).ToString("MMM dd"),
FullName = db_reader2.GetString("recordholder_fullname"),
BirthDate = "---",
Legitimacy = "---",
PlaceOfBirth = "---",
Parent1 = db_reader2.GetString("parent1_fullname"),
Parent2 = db_reader2.GetString("parent2_fullname"),
Godparent1 = "---",
Godparent2 = "---",
Stipend = 0,
Minister = "---",
Page = page
});
});
}
}
else
{
using (MySqlConnection conn3 = new MySqlConnection(dbman.GetConnStr()))
{
conn3.Open();
MySqlCommand cmd3 = conn3.CreateCommand();
cmd3.CommandText = "SELECT DISTINCT * FROM baptismal_records WHERE record_id = @rid;";
cmd3.Parameters.AddWithValue("@rid", db_reader2.GetString("record_id"));
cmd3.Prepare();
using (MySqlDataReader db_reader3 = cmd3.ExecuteReader())
{
while (db_reader3.Read())
{
App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
{
records.Add(new RecordEntryBaptismal()
{
RecordID = db_reader2.GetString("record_id"),
EntryNumber = db_reader2.GetInt32("entry_number"),
BaptismalYear = DateTime.Parse(db_reader2.GetString("record_date")).ToString("yyyy"),
BaptismalDate = DateTime.Parse(db_reader2.GetString("record_date")).ToString("MMM dd"),
FullName = db_reader2.GetString("recordholder_fullname"),
BirthDate = DateTime.Parse(db_reader3.GetString("birthday")).ToString("MMM dd, yyyy"),
Legitimacy = db_reader3.GetString("legitimacy"),
PlaceOfBirth = db_reader3.GetString("place_of_birth"),
Parent1 = db_reader2.GetString("parent1_fullname"),
Parent2 = db_reader2.GetString("parent2_fullname"),
Godparent1 = db_reader3.GetString("sponsor1"),
Godparent2 = db_reader3.GetString("sponsor2"),
Stipend = db_reader3.GetFloat("stipend"),
Minister = db_reader3.GetString("minister"),
Page = page
});
});
}
}
}
}
count++;
if (count == itemsPerPage)
{
page++;
count = 0;
}
}
}
}
foreach (var cur in records)
{
if (cur.Page == CurrentPage.Value)
{
records_final.Add(new RecordEntryBaptismal()
{
RecordID = cur.RecordID,
EntryNumber = cur.EntryNumber,
BaptismalYear = cur.BaptismalYear,
BaptismalDate = cur.BaptismalDate,
FullName = cur.FullName,
BirthDate = cur.BirthDate,
Legitimacy = cur.Legitimacy,
PlaceOfBirth = cur.PlaceOfBirth,
Parent1 = cur.Parent1,
Parent2 = cur.Parent2,
Godparent1 = cur.Godparent1,
Godparent2 = cur.Godparent2,
Stipend = cur.Stipend,
Minister = cur.Minister,
Page = cur.Page
});
}
}
SyncChanges();
System.Threading.Thread.Sleep(1);
CurrentPage.Maximum = page;
}
else
{
}
}
}
