/// <summary> /// Creates the AddRequestForm Window and Initializes DB Param. /// </summary> public ConfirmDeletePriestWindow(Priests sender, string priest_id) { pid = priest_id; priests = sender; pmsutil = new PMSUtil(); InitializeComponent(); }
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; } } } } } } }
public AddPriestWindow(Priests caller) { _caller = caller; InitializeComponent(); }