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