//To fetch Student by details
public StudentDetails GetStudentDetailsById(int studentId)
{
StudentDetails student = new StudentDetails();
string cs = ConfigurationManager.ConnectionStrings["GIFDBConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("usp_GetStudentDetailsById", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", studentId);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
student.StudentId = (int)reader["StudentId"];
student.StudentFirstName = reader["StudentFirstName"].ToString();
student.StudentLastName = reader["StudentLastName"].ToString();
student.Active = (bool)reader["Active"];
student.ParentId = (int)reader["ParentId"];
student.ParentFirstName = reader["ParentFirstName"].ToString();
student.ParentLastName = reader["ParentLastName"].ToString();
student.ParentEmail = reader["ParentEmail"].ToString();
student.ParentMobile = reader["ParentMobile"].ToString();
student.ClassId = (int)reader["ClassId"];
student.ClassName = reader["ClassName"].ToString();
}
if (reader.NextResult())
{
student.SchoolClass = new List <SchoolClass>();
while (reader.Read())
{
SchoolClass sc = new SchoolClass();
sc.Id = (int)reader["Id"];
sc.Name = reader["Name"].ToString();
student.SchoolClass.Add(sc);
}
}
}
return(student);
}
//Update Student Details
public void UpdateStudentDetails(StudentDetails student)
{
string cs = ConfigurationManager.ConnectionStrings["GIFDBConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("usp_UpdateStudent", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StudentId", student.StudentId);
cmd.Parameters.AddWithValue("@StudentFirstName", student.StudentFirstName);
cmd.Parameters.AddWithValue("@StudentLastName", student.StudentLastName);
cmd.Parameters.AddWithValue("@ParentId", student.ParentId);
cmd.Parameters.AddWithValue("@ParentEmail", student.ParentEmail);
cmd.Parameters.AddWithValue("@ParentMobile", student.ParentMobile);
cmd.Parameters.AddWithValue("@ClassId", student.ClassId);
cmd.Parameters.AddWithValue("@Active", student.Active);
con.Open();
cmd.ExecuteNonQuery();
}
}
public List <StudentDetails> GetAllStudents()
{
List <StudentDetails> students = new List <StudentDetails>();
string cs = ConfigurationManager.ConnectionStrings["GIFDBConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("uspGetAllStudents", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
StudentDetails student = new StudentDetails();
student.StudentId = (int)reader["StudentId"];
student.StudentFirstName = reader["StudentFirstName"].ToString();
student.StudentLastName = reader["StudentLastName"].ToString();
student.Active = (bool)reader["Active"];
student.ParentId = (int)reader["ParentId"];
student.ParentFirstName = reader["ParentFirstName"].ToString();
student.ParentLastName = reader["ParentLastName"].ToString();
student.ParentEmail = reader["ParentEmail"].ToString();
student.ParentMobile = reader["ParentMobile"].ToString();
student.ClassId = (int)reader["ClassId"];
student.ClassName = reader["ClassName"].ToString();
students.Add(student);
}
}
return(students);
}
