protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int id = Convert.ToInt16(GridView1.DataKeys[e.RowIndex].Values["Id"].ToString());
TextBox txtFname = GridView1.Rows[e.RowIndex].FindControl("Fnametxt") as TextBox;
TextBox txtLname = GridView1.Rows[e.RowIndex].FindControl("Lnametxt") as TextBox;
TextBox txtAge = GridView1.Rows[e.RowIndex].FindControl("Agetxt") as TextBox;
TextBox txtSex = GridView1.Rows[e.RowIndex].FindControl("Sextxt") as TextBox;
StudentEntites = new StudentEntites();
StudentEntites.FName = txtFname.Text;
StudentEntites.LName = txtLname.Text;
StudentEntites.Age = Convert.ToInt32(txtAge.Text);
StudentEntites.Sex = txtSex.Text;
StudentBusinessLogic.UpdateStudent(id, StudentEntites);
GridView1.EditIndex = -1;
RefreshData();
}
//Method for Insert
public int StudentEntry(StudentEntites entites)
{
bool status = false;
cmd = new SqlCommand("spInsertStudent", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FName", entites.FName);
cmd.Parameters.AddWithValue("@LName", entites.LName);
cmd.Parameters.AddWithValue("@Age", Convert.ToInt32(entites.Age));
cmd.Parameters.AddWithValue("@Sex", entites.Sex);
con.Open();
int res = cmd.ExecuteNonQuery();
con.Close();
//if (res > 0)
//{
// status = true;
//}
return(res);
}
//Method for update student
public void UpdateStudent(int id, StudentEntites entites)
{
_studentDataAccess.UpdateStudent(id, entites.FName, entites.LName, entites.Age, entites.Sex);
}
//Method for insert
public int StudentEntry(StudentEntites entites)
{
//bool status = false;
return(_studentDataAccess.StudentEntry(entites));
}
