protected void btnEditPosition_Click(object sender, EventArgs e)
{
string position = txePosition.Text, drivercat = dreDriverCat.SelectedItem.Value, drivertrans = dreDriverTrans.SelectedItem.Value;
string drivercatdoc = feDriverCatDoc.PostedFile.FileName;
uint gvoid = Convert.ToUInt32(lbeShowID.Text), gvpid = Convert.ToUInt32(lbeShowPID.Text);
if (drivercat == null || drivercat == "")
drivercat = " ";
if (drivertrans == null || drivertrans == "")
drivertrans = " ";
if (drivercatdoc == null || drivercatdoc == "")
drivercatdoc = txtDCDoc.Text;
GFRC.Position update = new GFRC.Position(gvpid, gvoid, position, drivercat, drivercatdoc, drivertrans);
update.editPosition(update);
Response.Redirect("/VolunteerPosition.aspx?form=view&ID=" + update.gvoID);
}
protected void btnAddPosition_Click(object sender, EventArgs e)
{
string position = txtPosition.Text, drivercat = drpDriverCat.SelectedItem.Value, drivertrans = drpDriverTrans.SelectedItem.Value;
string drivercatdoc = null;
if (fDriverCatDoc.HasFile)
drivercatdoc = fDriverCatDoc.PostedFile.FileName;
uint gvoid = Convert.ToUInt32(Session["Selected"]);
if (drivercat == null || drivercat == "")
drivercat = " ";
if (drivertrans == null || drivertrans == "")
drivertrans = " ";
if (drivercatdoc == null || drivercatdoc == "")
drivercatdoc = " ";
GFRC.Position create = new GFRC.Position(gvoid, position, drivercat, drivercatdoc, drivertrans);
create.createPosition(create);
Response.Redirect("/VolunteerPosition.aspx?form=view&ID=" + create.gvoID);
}
protected string displayPosition(uint id)
{
string result = "";
GFRC.Position display = new GFRC.Position(id, 'o');
if (display.PositionA == null || display.PositionA == "")
result = "There is no position record for volunteer ID " + id + ". <a href=\"/VolunteerPosition.aspx?form=add&ID=" + id + "\">Add a record now.</a>";
else
{
result = "<table class=\"display\"><tr><td>";
result += string.Format("Position ID: </td><td>{0}</td></tr><tr><td>", display.gvpID);
result += string.Format("Volunteer ID: </td><td>{0}</td></tr><tr><td>", display.gvoID);
result += string.Format("Position: </td><td>{0}</td></tr><tr><td>", display.PositionA);
result += string.Format("Driver Category: </td><td>{0}</td></tr><tr><td>", display.DriverCat);
result += string.Format("Supporting Document: </td><td>{0}</td></tr><tr><td>", display.DriverCatDoc);
result += string.Format("Driver Transmission: </td><td>{0}</td></tr></table>", display.DriverTrans);
}
return result;
}
public bool editPosition(Position edit)
{
bool result = false;
// Command
string query = String.Format(@"UPDATE gfrc_volunteer_position SET gvp_position = '{0}', gvp_driver_cat = '{1}', gvp_driver_cat_doc = '{2}', gvp_driver_trans = '{3}' " +
"WHERE gvo_id = {4} AND gvp_id = {5}", edit.PositionA, edit.DriverCat, edit.DriverCatDoc, edit.DriverTrans, edit.gvoID, edit.gvpID);
int affected = 0;
try
{
using (conn)
{
conn.Open();
cmd = new OleDbCommand(query, conn);
affected = cmd.ExecuteNonQuery();
}
}
catch (Exception e)
{
result = false;
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
// checks if rows were affected by the insert query
if (affected > 0)
{
result = true;
}
return result;
}
public bool createPosition(Position create)
{
bool result = false;
// Command
string query = String.Format(@"INSERT INTO gfrc_volunteer_position (gvo_id, gvp_position, gvp_driver_cat, gvp_driver_cat_doc, gvp_driver_trans) " +
"VALUES({0}, '{1}', '{2}', '{3}', '{4}')",
create.gvoID, create.PositionA, create.DriverCat, create.DriverCatDoc, create.DriverTrans);
int affected = 0;
try
{
using (conn)
{
conn.Open();
cmd = new OleDbCommand(query, conn);
affected = cmd.ExecuteNonQuery();
// checks if rows were affected by the insert query
if (affected > 0)
{
result = true;
query = String.Format(@"SELECT gvp_id FROM gfrc_volunteer_position WHERE gvp_id = (SELECT MAX(gvp_id) FROM gfrc_volunteer_position)");
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
// Set gloID
_gvpID = Convert.ToUInt32(rdr.GetInt32(0));
}
}
}
}
catch (Exception e)
{
result = false;
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return result;
}
protected void showPosition(uint id)
{
GFRC.Position display = new GFRC.Position(id, 'o');
lbeShowPID.Text = display.gvpID.ToString();
lbeShowID.Text = display.gvoID.ToString();
txePosition.Text = display.PositionA;
dreDriverCat.Items.FindByValue(display.DriverCat).Selected = true;
txtDCDoc.Text = display.DriverCatDoc;
dreDriverTrans.Items.FindByValue(display.DriverTrans).Selected = true;
}