protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int userid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
SqlConnection con = ConnectionString.Connect();
con.Open();
SqlCommand cmd = new SqlCommand("delete from FIR where firID = '" + userid + "'", con);
cmd.ExecuteNonQuery();
con.Close();
LoadGrid();
}
private void LoadGrid()
{
SqlConnection con = ConnectionString.Connect();
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM FIR", con);
DataTable dt = new DataTable();
sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
con.Close();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int userid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
TextBox Status = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1");
if (string.IsNullOrWhiteSpace(Status.Text))
{
string str = Status.Text;
}
SqlConnection con = ConnectionString.Connect();
con.Open();
SqlCommand cmd = new SqlCommand("update deptAdmin set post = '" + Status.Text + "' where deptAdminID = '" + userid + "'", con);
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
loadGrid();
con.Close();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int userid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
//TextBox textName = (TextBox)GridView1.Rows[e.RowIndex].FindControl("Complainant"); //row.FindControl("Complainant");
//TextBox textName = (TextBox)GridView1.Rows[e.RowIndex].FindControl("Complainant");
//if(string.IsNullOrWhiteSpace(textName.Text))
//{
// textName.Text = "*****@*****.**";
//}
string textName = "*****@*****.**";
SqlConnection con = ConnectionString.Connect();
con.Open();
SqlCommand cmd = new SqlCommand("update FIR set Complainant = '" + textName + "' where firID = '" + userid + "'", con);
cmd.ExecuteNonQuery();
con.Close();
GridView1.EditIndex = -1;
LoadGrid();
}
protected void Submit_Click(object sender, EventArgs e)
{
if (password.Text != reTypePassword.Text)
{
Response.Write("<script>alert('Passwords do not match');</script>");
}
else
{
SqlConnection con = ConnectionString.Connect();
con.Open();
SqlCommand cmd = new SqlCommand("RegDeptAdmin", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@firstName", deptAdminFname.Text);
cmd.Parameters.AddWithValue("@lastName", deptAdminLname.Text);
cmd.Parameters.AddWithValue("@city", deptAdminCity.Text);
cmd.Parameters.AddWithValue("@policeStation", deptAdminPoliceStation.Text);
cmd.Parameters.AddWithValue("@post", deptAdminPost.Text);
cmd.Parameters.AddWithValue("@email", deptAdminEmail.Text);
cmd.Parameters.AddWithValue("@password", password.Text);
cmd.ExecuteNonQuery();
Response.Write("<script>alert('Admin Added Succesfully');</script>");
}
}
