protected void btndeleteadmin_Click(object sender, EventArgs e)
{
Pnlforadminupdate.Visible = false;
Pnlforadmin.Visible = false;
Pnladmintosearchuserdetails.Visible = false;
pnlfordeleteadmin.Visible = true;
// lbldeletadminfinal.Visible = false;
lbldeleteadminmessage.Visible = false;
dt_delete.Clear();
OracleConnection conn = new OracleConnection("Data Source =XE; User ID = system; Password= Wright2015");
conn.Open();
OracleDataAdapter oadp = new OracleDataAdapter("SELECT PARKING_DETAILS.PARKID,PARKING_DETAILS.PARKAREA,PARKING_DETAILS.PARKLOTNO FROM PARKING_DETAILS WHERE PARKING_DETAILS.PARKID NOT IN (SELECT PARKS.PARKID FROM PARKS WHERE PARKING_DETAILS.PARKID=PARKS.PARKID AND PARKS.PARKDATE >=TRUNC(CURRENT_DATE))", conn);
oadp.Fill(dt_delete);
if (dt_delete.Rows.Count == 0)
{
lbldeleteadminmessage.Text = "All the parking lots are used and cannot be deleted";
lbldeleteadminmessage.Visible = true;
lbldeletadminfinal.Visible = false;
}
else
{
Gridviewforadmindeletedisplay.DataSource = dt_delete;
Gridviewforadmindeletedisplay.DataBind();
lbldeletadminfinal.Visible = true;
}
conn.Close();
}
protected void lbldeletadminfinal_Click(object sender, EventArgs e)
{
OracleCommand command;
string Commandtxt;
OracleConnection conn = new OracleConnection("Data Source =XE; User ID = system; Password= Wright2015");
conn.Open();
DataTable dtnewwww = new DataTable();
foreach (GridViewRow row in Gridviewforadmindeletedisplay.Rows)
{
// Access the CheckBox
CheckBox cb = (CheckBox)row.Cells[0].FindControl("CheckBoxfroadmindelete");
if (cb != null && cb.Checked)
{
OracleDataAdapter oadp = new OracleDataAdapter("SELECT * FROM PARKS WHERE PARKS.PARKID='" + dt_delete.Rows[row.RowIndex]["PARKID"].ToString() + "'AND NOT PARKS.PARKDATE >=TRUNC(CURRENT_DATE)", conn);
oadp.Fill(dtnewwww);
if (dtnewwww.Rows.Count > 0)
{
Commandtxt = "DELETE FROM PARKS WHERE PARKID='" + dt_delete.Rows[row.RowIndex]["PARKID"].ToString() + "' AND NOT PARKS.PARKDATE >=TRUNC(CURRENT_DATE)";
command = new OracleCommand(Commandtxt, conn);
command.ExecuteNonQuery();
// dt_delete.Rows[row.RowIndex].Delete();
command.Dispose();
}
else
{
Commandtxt = "DELETE FROM PARKING_DETAILS WHERE PARKID='" + dt_delete.Rows[row.RowIndex]["PARKID"].ToString() + "'";
command = new OracleCommand(Commandtxt, conn);
command.ExecuteNonQuery();
dt_delete.Rows[row.RowIndex].Delete();
}
}
}
Gridviewforadmindeletedisplay.DataSource = dt_delete;
Gridviewforadmindeletedisplay.DataBind();
}
