/// <summary>
/// Interaction logic for the AddRegConfirm button. Gathers and prepares the data
/// for database insertion.
/// </summary>
private void AddRegConfirm(object sender, System.Windows.RoutedEventArgs e)
{
if (CheckInputs() == true)
{
regType = RegisterType.Text;
bookNum = Convert.ToInt32(BookNo.Value);
registerNum = Convert.ToInt32(RegisterNo.Value);
book = Book.Text;
creationDate = Convert.ToDateTime(CreationDate.Text).ToString("yyyy-MM-dd");
if (UpdateRegister() > 0)
{
pmsutil.LogAccount("Edited Register No " + RegisterNo.Value + " Type: " + regType);
reg1.SyncRegisters();
var metroWindow = (Application.Current.MainWindow as MetroWindow);
MsgSuccess();
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
public UIManager()
{
pmsutil = new PMSUtil();
Login li = new Login();
if (Application.Current.Resources["uid"] == null)
{
//this.Hide();
li.ShowDialog();
}
if (Application.Current.Resources["uid"] != null)
{
SplashScreen splashScreen = new SplashScreen("assets/splash.png");
splashScreen.Show(true);
//WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen;
this.Top = 10;
this.Left = 80;
pmsutil.LogAccount("Account Logged In");
//this.Show();
}
InitializeComponent();
InitPriv();
}
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
{
}
}
}
/// <summary>
/// Interaction logic for the AddRegConfirm button. Gathers and prepares the data
/// for database insertion.
/// </summary>
private void AddRegConfirm(object sender, System.Windows.RoutedEventArgs e)
{
if (CheckInputs() == true)
{
switch (RegisterType.SelectedIndex)
{
case 0:
regType = "Baptismal";
break;
case 1:
regType = "Matrimonial";
break;
case 2:
regType = "Confirmation";
break;
case 3:
regType = "Burial";
break;
default:
regType = "NULL";
break;
}
bookNum = Convert.ToInt32(BookNo.Value);
registerNum = Convert.ToInt32(RegisterNo.Value);
book = Book.Text;
creationDate = Convert.ToDateTime(CreationDate.Text).ToString("yyyy-MM-dd");
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");
if (InsertRegister() > 0)
{
reg1.SyncRegisters();
var metroWindow = (Application.Current.MainWindow as MetroWindow);
pmsutil.LogAccount("Added Register Number: " + RegisterNo.Value + " Type: " + regType);
MsgSuccess();
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
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 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
{
}
}
private void CreateAccountButton_Click(object sender, RoutedEventArgs e)
{
if (CheckInputs() == true)
{
string uid = Application.Current.Resources["uid"].ToString();
if (VerifyKey(uid) == true)
{
if (AccountType.SelectedIndex == 4)
{
priv = "6";
if (Priv1.IsChecked == true)
{
priv += "2";
}
if (Priv2.IsChecked == true)
{
priv += "3";
}
if (Priv3.IsChecked == true)
{
priv += "4";
}
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
if (string.IsNullOrWhiteSpace(Password.Text))
{
cmd.CommandText =
"UPDATE accounts SET user_name = @user_name, account_type = @account_type WHERE account_id = @aid";
cmd.Prepare();
cmd.Parameters.AddWithValue("@aid", aid);
cmd.Parameters.AddWithValue("@user_name", Username.Text);
cmd.Parameters.AddWithValue("@account_type", Convert.ToInt32(priv));
}
else
{
cmd.CommandText =
"UPDATE accounts SET user_name = @user_name, pass_key = @pass_key, account_type = @account_type WHERE account_id = @aid";
cmd.Prepare();
cmd.Parameters.AddWithValue("@aid", aid);
cmd.Parameters.AddWithValue("@user_name", Username.Text);
cmd.Parameters.AddWithValue("@pass_key", SecurePasswordHasher.Hash(Password.Text));
cmd.Parameters.AddWithValue("@account_type", Convert.ToInt32(priv));
}
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText =
"UPDATE accounts_info SET name = @emp_name WHERE account_id = @aid";
cmd.Prepare();
cmd.Parameters.AddWithValue("@aid", aid);
cmd.Parameters.AddWithValue("@emp_name", Username.Text);
stat_code = cmd.ExecuteNonQuery();
conn.Close();
if (stat_code > 0)
{
pmsutil.LogAccount("Edited account: " + Username.Text);
MsgSuccess();
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
}
else
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
if (string.IsNullOrWhiteSpace(Password.Text))
{
cmd.CommandText =
"UPDATE accounts SET user_name = @user_name, account_type = @account_type WHERE account_id = @aid";
cmd.Prepare();
cmd.Parameters.AddWithValue("@aid", aid);
cmd.Parameters.AddWithValue("@user_name", Username.Text);
cmd.Parameters.AddWithValue("@account_type", Convert.ToInt32(AccountType.SelectedIndex + 1));
}
else
{
cmd.CommandText =
"UPDATE accounts SET user_name = @user_name, pass_key = @pass_key, account_type = @account_type WHERE account_id = @aid";
cmd.Prepare();
cmd.Parameters.AddWithValue("@aid", aid);
cmd.Parameters.AddWithValue("@user_name", Username.Text);
cmd.Parameters.AddWithValue("@pass_key", SecurePasswordHasher.Hash(Password.Text));
cmd.Parameters.AddWithValue("@account_type", Convert.ToInt32(AccountType.SelectedIndex + 1));
}
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText =
"UPDATE accounts_info SET name = @emp_name WHERE account_id = @aid";
cmd.Prepare();
cmd.Parameters.AddWithValue("@aid", aid);
cmd.Parameters.AddWithValue("@emp_name", Username.Text);
stat_code = cmd.ExecuteNonQuery();
conn.Close();
if (stat_code > 0)
{
MsgSuccess();
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
}
}
else
{
MsgWrongKey();
}
}
else
{
}
}
private void CreateAccountButton_Click(object sender, RoutedEventArgs e)
{
if (CheckInputs() == true)
{
if (AccountType.SelectedIndex == 4)
{
priv = "6";
if (Priv1.IsChecked == true)
{
priv += "2";
}
if (Priv2.IsChecked == true)
{
priv += "3";
}
if (Priv3.IsChecked == true)
{
priv += "4";
}
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 accID = pmsutil.GenAccountID();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText =
"INSERT INTO accounts(account_id, user_name, pass_key, account_type)" +
"VALUES(@account_id, @user_name, @pass_key, @account_type)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@account_id", accID);
cmd.Parameters.AddWithValue("@user_name", Username.Text);
cmd.Parameters.AddWithValue("@pass_key", SecurePasswordHasher.Hash(Password.Text));
cmd.Parameters.AddWithValue("@account_type", Convert.ToInt32(priv));
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText =
"INSERT INTO accounts_info(account_id, name, date_created, time_created, creator)" +
"VALUES(@account_id, @emp_name, @date_created, @time_created, @creator)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@account_id", accID);
cmd.Parameters.AddWithValue("@emp_name", Username.Text);
cmd.Parameters.AddWithValue("@date_created", curDate);
cmd.Parameters.AddWithValue("@time_created", curTime);
cmd.Parameters.AddWithValue("@creator", uid);
stat_code = cmd.ExecuteNonQuery();
conn.Close();
if (stat_code > 0)
{
_caller.SyncAccounts();
MsgSuccess();
pmsutil.LogAccount("Created an account - Username: "******" Type: " + Convert.ToInt32(priv));
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
}
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 accID = pmsutil.GenAccountID();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText =
"INSERT INTO accounts(account_id, user_name, pass_key, account_type)" +
"VALUES(@account_id, @user_name, @pass_key, @account_type)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@account_id", accID);
cmd.Parameters.AddWithValue("@user_name", Username.Text);
cmd.Parameters.AddWithValue("@pass_key", SecurePasswordHasher.Hash(Password.Text));
cmd.Parameters.AddWithValue("@account_type", Convert.ToInt32(AccountType.SelectedIndex + 1));
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText =
"INSERT INTO accounts_info(account_id, name, date_created, time_created, creator)" +
"VALUES(@account_id, @emp_name, @date_created, @time_created, @creator)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@account_id", accID);
cmd.Parameters.AddWithValue("@emp_name", Username.Text);
cmd.Parameters.AddWithValue("@date_created", curDate);
cmd.Parameters.AddWithValue("@time_created", curTime);
cmd.Parameters.AddWithValue("@creator", uid);
stat_code = cmd.ExecuteNonQuery();
conn.Close();
if (stat_code > 0)
{
MsgSuccess();
pmsutil.LogAccount("Created an account - Username: "******" Type: " + Convert.ToInt32(priv));
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
}
}
else
{
}
}
