protected void btnupdate_Click(object sender, EventArgs e)
{
clspassinggrade objpass = new clspassinggrade();
objpass.ID = Convert.ToInt32(Label9.Text);
objpass.Name = txtname.Text;
objpass.EquivallentGPA = txtequiGpa.Text;
objpass.Active = Convert.ToInt32(chkstatus.Checked);
objpass.executenonupdate_pass();
//cmd = new SqlCommand("update PassingGrade set Name='"+txtname.Text+"' , EquivallentGPA='"+txtequiGpa.Text+"' , Active='"+chkstatus.Checked+"' where ID='"+Label9.Text+"' " ,con);
//if (cmd.Connection.State.ToString() != "Open")
//{
// con.Open();
//}
//cmd.ExecuteNonQuery();
//con.Close();
fillgrid();
clear();
btnupdate.Visible = false;
btnsubmit.Visible = true;
lblmessage.Text = "Record updated successfully.";
lblmessage.Visible = true;
lbllegend.Text = "";
Panel1.Visible = false;
Button1.Visible = true;
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
clspassinggrade objpass = new clspassinggrade();
objpass.Name = txtname.Text;
objpass.EquivallentGPA = txtequiGpa.Text;
objpass.Active = Convert.ToInt32(chkstatus.Checked);
objpass.executenoninsert_pass();
//cmd = new SqlCommand("insert into PassingGrade(Name,EquivallentGPA,Active) values('"+txtname.Text+"' , '"+txtequiGpa.Text+"' , '"+chkstatus.Checked+"')",con);
//if (cmd.Connection.State.ToString() != "Open")
//{
// con.Open();
//}
//cmd.ExecuteNonQuery();
//con.Close();
fillgrid();
clear();
lblmessage.Text = "Record inserted successfully.";
lblmessage.Visible = true;
Panel1.Visible = false;
Button1.Visible = true;
lbllegend.Text = "";
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
clspassinggrade objpass = new clspassinggrade();
if (e.CommandName == "Edit")
{
lbllegend.Text = "Edit Passing Grade";
Panel1.Visible = true;
Button1.Visible = false;
int i = Convert.ToInt32(e.CommandArgument);
Label9.Text = i.ToString();
objpass.ID = i;
// da = new SqlDataAdapter("select * from PassingGrade where ID="+i,con);
dt = new DataTable();
dt = objpass.filgrid_pas2();
// da.Fill(dt);
txtname.Text = dt.Rows[0]["Name"].ToString();
txtequiGpa.Text = dt.Rows[0]["EquivallentGPA"].ToString();
chkstatus.Checked = Convert.ToBoolean(dt.Rows[0]["Active"]);
txtname.Focus();
}
if (e.CommandName == "Delete")
{
int i = Convert.ToInt32(e.CommandArgument);
cmd = new SqlCommand("delete from PassingGrade where ID=" + i, con);
if (cmd.Connection.State.ToString() != "Open")
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
fillgrid();
lblmessage.Visible = true;
lblmessage.Text = "Record deleted successfully.";
}
}
