/// <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 { } }