protected void btnupdate_Click(object sender, EventArgs e)
{
clsareaofstudies objarea = new clsareaofstudies();
objarea.Name = txtname.Text;
objarea.Active = Convert.ToInt32(chkstatus.Checked);
objarea.ID = Convert.ToInt32(Label8.Text);
objarea.executenonupdte();
//cmd = new SqlCommand("update AreaofStudiesTbl set Name='" + txtname.Text + "' , Active='" + chkstatus.Checked + "' where ID='" + Label8.Text + "'", con);
//if (cmd.Connection.State.ToString() != "Open")
//{
// con.Open();
//}
//cmd.ExecuteNonQuery();
//con.Close();
fillgrid();
clear();
btnupdate.Visible = false;
btnsubmit.Visible = true;
Panel1.Visible = false;
Button2.Visible = true;
lblmessage.Text = "Record updated successfully.";
lblmessage.Visible = true;
lbllegend.Text = "";
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
clsareaofstudies objarea = new clsareaofstudies();
objarea.Name = txtname.Text;
objarea.Active = Convert.ToInt32(chkstatus.Checked);
objarea.executenoninsert();
//cmd = new SqlCommand("insert into AreaofStudiesTbl(Name,Active) values('" + txtname.Text + "' , '" + chkstatus.Checked + "')", con);
//if (cmd.Connection.State.ToString() != "Open")
//{
// con.Open();
//}
//cmd.ExecuteNonQuery();
//con.Close();
fillgrid();
clear();
Panel1.Visible = false;
Button2.Visible = true;
lblmessage.Text = "Record inserted successfully.";
lblmessage.Visible = true;
lbllegend.Text = "";
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
clsareaofstudies objarea = new clsareaofstudies();
if (e.CommandName == "Edit")
{
Panel1.Visible = true;
Button2.Visible = false;
lbllegend.Text = "Edit Study";
lblmessage.Text = "";
int i = Convert.ToInt32(e.CommandArgument);
Label8.Text = i.ToString();
objarea.ID = i;
// da = new SqlDataAdapter("select * from AreaofStudiesTbl where ID=" +i,con);
dt = new DataTable();
dt = objarea.rowcmod_selc();
// da.Fill(dt);
txtname.Text = dt.Rows[0]["Name"].ToString();
chkstatus.Checked = Convert.ToBoolean(dt.Rows[0]["Active"]);
}
if (e.CommandName == "Delete")
{
int i = Convert.ToInt32(e.CommandArgument);
string strwh = "select * from LevelofEducationTBL where AreaofStudyID='" + i + "' ";
SqlCommand cmdwh = new SqlCommand(strwh, con);
SqlDataAdapter adpwh = new SqlDataAdapter(cmdwh);
DataTable dts = new DataTable();
adpwh.Fill(dts);
if (dts.Rows.Count == 0)
{
string strwh3 = "select * from SpecialisedSubjectTBL where AreaofStudiesId='" + i + "' ";
SqlCommand cmdwh3 = new SqlCommand(strwh3, con);
SqlDataAdapter adpwh3 = new SqlDataAdapter(cmdwh3);
DataTable dts3 = new DataTable();
adpwh3.Fill(dts3);
if (dts3.Rows.Count == 0)
{
SqlCommand cmd = new SqlCommand("delete from AreaofStudiesTbl where ID=" + i, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
lblmessage.Visible = true;
lblmessage.Text = "Record deleted successfully.";
}
else
{
lblmessage.Visible = true;
lblmessage.Text = "sorry,you are not able to delete this record as child record exist using this record.";
}
}
else
{
lblmessage.Visible = true;
lblmessage.Text = "sorry,you are not able to delete this record as child record exist using this record.";
}
}
fillgrid();
}