private int CountEvents(DateTime d)
{
int ret = 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 cmd = conn2.CreateCommand();
cmd.CommandText = "SELECT COUNT(appointment_id) FROM appointments WHERE appointment_date = @sdate;";
cmd.Parameters.AddWithValue("@sdate", d.ToString("yyyy-MM-dd"));
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
ret = db_reader.GetInt32("COUNT(appointment_id)");
}
}
}
}
}
return(ret);
}
public EditDirectoryWindow(string rid)
{
_rid = rid;
InitializeComponent();
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 burial_directory WHERE record_id = @rid LIMIT 1;";
cmd.Parameters.AddWithValue("@rid", rid);
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
Block.Text = db_reader.GetString("block");
Lot.Text = db_reader.GetString("lot");
Plot.Text = db_reader.GetString("plot");
RContactNo.Text = db_reader.GetString("relative_contact_number");
}
}
}
}
}
}
public EditEventTypeWindow(EventTypes caller, string tid)
{
_caller = caller;
InitializeComponent();
_tid = tid;
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 appointment_types WHERE type_id = @tid LIMIT 1;";
cmd.Parameters.AddWithValue("@tid", tid);
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
EType.Text = db_reader.GetString("appointment_type");
Status.SelectedIndex = db_reader.GetInt32("custom") - 1;
Fee.Value = db_reader.GetDouble("fee");
Active.SelectedIndex = db_reader.GetInt32("status") - 1;
}
}
}
}
}
}
private DataTable GenerateList()
{
DataTable dtNames = new DataTable();
dtNames.Columns.Add("Time", typeof(string));
dtNames.Columns.Add("Type", typeof(string));
dtNames.Columns.Add("Sponsor", typeof(string));
dtNames.Columns.Add("Additional Info", 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]);
var start = new DateTime(cDate.Year, 1, 1);
var end = new DateTime(cDate.Year, 12, 31);
conn2.Open();
MySqlCommand cmd = conn2.CreateCommand();
cmd.CommandText = "SELECT * FROM appointments WHERE appointment_date = @date ORDER BY appointment_time ASC;";
cmd.Parameters.AddWithValue("@date", _dt.ToString("yyyy-MM-dd"));
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
if (ReportType.SelectedIndex == 0)
{
dtNames.Rows.Add(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 (ReportType.SelectedIndex == 1)
{
if (IsCustom(db_reader.GetString("appointment_type")) == false)
{
dtNames.Rows.Add(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(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"));
}
}
}
}
}
}
}
return(dtNames);
}
/// <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");
}
}
}
}
}
}
internal bool CheckDupli()
{
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 COUNT(*) FROM accounts WHERE user_name = @username;";
cmd.Prepare();
cmd.Parameters.AddWithValue("@username", Username.Text);
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
if (db_reader.GetInt32("COUNT(*)") > 0)
{
Username.ToolTip = "Username already exists.";
Username.BorderBrush = Brushes.Red;
UsernameIcon.BorderBrush = Brushes.Red;
return(true);
}
else
{
return(false);
}
}
}
}
}
return(true);
}
/// <summary>
/// Inserts the request to the database.
/// </summary>
private int UpdateRegister()
{
int ret = 0;
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 registers SET book_number = @book_num, register_number = @register_number, book = @book, creation_date = @creation_date WHERE book_number = @book_number;";
cmd.Prepare();
cmd.Parameters.AddWithValue("@book_num", bookNum);
cmd.Parameters.AddWithValue("@book_number", _bookNum);
cmd.Parameters.AddWithValue("@register_number", registerNum);
cmd.Parameters.AddWithValue("@book", book);
cmd.Parameters.AddWithValue("@creation_date", creationDate);
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
ret = stat_code;
}
else
{
}
}
return(ret);
}
private void CreateAccountButton_Click(object sender, RoutedEventArgs e)
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
string selTime = HourPicker.Text + ":" + MinutePicker.Text + " " + ModePicker.Text;
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE timeslots SET timeslot = @timeslot, status = @status WHERE timeslot_id = @tid;";
cmd.Prepare();
cmd.Parameters.AddWithValue("@tid", 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("Edited Timeslot: " + DateTime.Parse(selTime).ToString("HH:mm:ss"));
MsgSuccess();
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
}
private void ConfirmPayment_Click(object sender, System.Windows.RoutedEventArgs e)
{
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 = "DELETE FROM appointment_types WHERE type_id = @eid LIMIT 1;";
cmd.Parameters.AddWithValue("@eid", eid);
cmd.Prepare();
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
if (stat_code > 0)
{
etype.SyncEventTypes();
MsgSuccess();
this.Close();
}
else
{
InfoArea.Foreground = new SolidColorBrush(Colors.Red);
InfoArea.Content = "Unable to Delete Selected Event Type!";
}
}
}
}
private string GetAType(string tid)
{
string ret = "";
dbman = new DBConnectionManager();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT appointment_type FROM appointment_types WHERE type_id = @tid;";
cmd.Parameters.AddWithValue("@tid", tid);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
ret = db_reader.GetString("appointment_type");
}
}
else
{
ret = "";
}
}
return(ret);
}
/// <summary>
/// Inserts the request to the database.
/// </summary>
private int UpdateTransaction()
{
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();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText =
"UPDATE transactions SET status = @status, completion_date = @completion_date, completion_time = @completion_time, completed_by = @completed_by WHERE transaction_id = @transaction_id;";
cmd.Parameters.AddWithValue("@transaction_id", tid);
cmd.Parameters.AddWithValue("@status", "Cancelled");
cmd.Parameters.AddWithValue("@completion_date", cDate);
cmd.Parameters.AddWithValue("@completion_time", cTime);
cmd.Parameters.AddWithValue("@completed_by", uid);
cmd.Prepare();
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
return(stat_code);
}
else
{
return(0);
}
}
}
internal bool CheckDupli()
{
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 COUNT(*) FROM residing_priests WHERE priest_name = @pname";
cmd.Prepare();
cmd.Parameters.AddWithValue("@pname", PriestName.Text);
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
if (db_reader.GetInt32("COUNT(*)") > 0)
{
return(true);
}
}
}
}
}
return(false);
}
internal bool CheckDupli()
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
string selTime = HourPicker.Text + ":" + MinutePicker.Text + " " + ModePicker.Text;
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM timeslots WHERE timeslot = @tslot";
cmd.Prepare();
cmd.Parameters.AddWithValue("@tslot", DateTime.Parse(selTime).ToString("HH:mm:ss"));
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
if (db_reader.GetInt32("COUNT(*)") > 0)
{
return(true);
}
}
}
}
}
return(false);
}
private string GetPriestID(string pname)
{
string ret = "";
dbman = new DBConnectionManager();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT priest_id FROM residing_priests WHERE priest_name = @pname LIMIT 1;";
cmd.Parameters.AddWithValue("@pname", pname);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
ret = db_reader.GetString("priest_id");
}
}
else
{
ret = "";
}
}
return(ret);
}
internal bool IsArchived(int bookNum)
{
dbman = new DBConnectionManager();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM registers WHERE book_number = @bookNum;";
cmd.Parameters.AddWithValue("@bookNum", bookNum);
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetString("status") == "Archived")
{
return(true);
}
else
{
return(false);
}
}
}
}
return(false);
}
private int CountAssignedServicesUnfinished(string pid)
{
int ret = 0;
dbman = new DBConnectionManager();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM appointments WHERE assigned_priest = @pid AND status = 1;";
cmd.Parameters.AddWithValue("@pid", pid);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
ret = db_reader.GetInt32("COUNT(*)");
}
//close Connection
dbman.DBClose();
}
else
{
ret += 0;
}
}
return(ret);
}
//private string GetPriestFilters()
//{
// string ret = "";
// dbman = new DBConnectionManager();
// if (dbman.DBConnect().State == ConnectionState.Open)
// {
// MySqlCommand cmd = dbman.DBConnect().CreateCommand();
// cmd.CommandText = "SELECT priest_name FROM residing_priests ORDER BY priest_name ASC";
// cmd.Prepare();
// MySqlDataReader db_reader = cmd.ExecuteReader();
// while (db_reader.Read())
// {
// PriestFilter.Items.Add(db_reader.GetString("priest_name"));
// }
// //close Connection
// dbman.DBClose();
// }
// else
// {
// ret = "";
// }
// return ret;
//}
internal void FetchAptType()
{
dbman = new DBConnectionManager();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM appointment_types;";
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
Label lbl = new Label();
lbl.HorizontalAlignment = HorizontalAlignment.Stretch;
var bc = new System.Windows.Media.BrushConverter();
lbl.Foreground = (System.Windows.Media.Brush)bc.ConvertFrom("#FF3E3E3E");
lbl.MouseDown += DragTest;
lbl.Content = new EventTypeItemDraggable(db_reader.GetString("appointment_type"), null);
AppointmentTypeList.Items.Add(lbl);
}
}
}
}
}
private int CheckTrans(string tid)
{
int ret = 2;
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", tid);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetString("status") == "Paid")
{
ret = 0;
}
else if (db_reader.GetString("status") == "Cancelled")
{
ret = 1;
}
else
{
}
}
}
}
return(ret);
}
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
{
}
}
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
{
}
}
}
}
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
{
}
}
}
internal void SyncMyLogs()
{
string uid = Application.Current.Resources["uid"].ToString();
entries = new ObservableCollection <MyLogsEntry>();
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 account_logs WHERE account_id = @aid;";
cmd.Parameters.AddWithValue("@aid", uid);
MySqlDataReader db_reader = cmd.ExecuteReader();
int temp = 1;
while (db_reader.Read())
{
entries.Add(new MyLogsEntry()
{
No = temp,
Details = db_reader.GetString("log_details"),
Date = DateTime.Parse(db_reader.GetString("log_date")).ToString("MMM dd, yyyy"),
Time = DateTime.Parse(db_reader.GetString("log_time")).ToString("hh:mm tt")
});
temp++;
}
}
}
}
LogHolder.Items.Refresh();
LogHolder.ItemsSource = entries;
LogHolder.Items.Refresh();
}
private List <string> GetEvents(DateTime d)
{
List <string> events = new List <string>();
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();
if (Calendar.cal.AppFilter.Text == "All")
{
cmd.CommandText = "SELECT * FROM appointments WHERE appointment_date = @sdate LIMIT 5;";
}
else
{
cmd.CommandText = "SELECT * FROM appointments WHERE appointment_date = @sdate AND assigned_priest = @priest LIMIT 5;";
}
cmd.Parameters.AddWithValue("@sdate", d.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("@priest", GetPriestID(Calendar.cal.AppFilter.Text));
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
events.Add(GetAType(db_reader.GetString("appointment_type")) + " - " + GetPriest(db_reader.GetString("assigned_priest")));
}
}
}
}
}
return(events);
}
public EditPriestWindow(Priests caller, string p_id)
{
_caller = caller;
pid = p_id;
InitializeComponent();
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 residing_priests WHERE priest_id = @pid LIMIT 1;";
cmd.Parameters.AddWithValue("@pid", pid);
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
PriestName.Text = db_reader.GetString("priest_name");
if (db_reader.GetString("priest_status") == "Active")
{
Status.SelectedIndex = 0;
}
else
{
Status.SelectedIndex = 1;
}
}
}
}
}
}
}
private bool VerifyKey(string uid)
{
bool ret = false;
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 accounts WHERE accounts.account_id = @aid LIMIT 1;";
cmd.Parameters.AddWithValue("@aid", uid);
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
if (SecurePasswordHasher.Verify(VerificationPass.Password, db_reader.GetString("pass_key")) == true)
{
ret = true;
}
else
{
ret = false;
}
}
}
}
}
}
return(ret);
}
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
{
}
}
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 CheckAccess(string record_id)
{
dbman = new DBConnectionManager();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM records_log WHERE record_id = @record_id AND log_code = 'LOGC-03' OR log_code = 'LOGC-04';";
cmd.Parameters.AddWithValue("@record_id", record_id);
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetInt32("COUNT(*)") > 0)
{
MsgNotice();
}
}
}
}
}
internal void GetNearbyGraves()
{
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.block = @block AND burial_directory.lot = @lot;";
cmd.Parameters.AddWithValue("@block", _block);
cmd.Parameters.AddWithValue("@lot", _lot);
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetString("record_id") != _rid)
{
Nearby.Items.Add(db_reader.GetString("recordholder_fullname"));
}
}
}
}
}
