/// <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();
}
