public Departmentsrb GetDepartment(int id)
{
Departmentsrb aDepartment = new Departmentsrb();
Query = "SELECT * FROM Department WHERE DepartmentId='" + id + "'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
aDepartment.Id = Convert.ToInt32(Reader["DepartmentId"]);
aDepartment.NAME = Reader["DepartmentName"].ToString();
}
return(aDepartment);
}
public JsonResult GetDepartment(int studentId)
{
int departmentid = 0;
StudentsManagersrb aManagersrb = new StudentsManagersrb();
var students = aManagersrb.GetallStudent();
var requiredstudent = students.Where(m => m.StudentId == studentId).ToList();
foreach (var i in requiredstudent)
{
departmentid = i.DeptId;
}
DepartmentManagersrb aManager = new DepartmentManagersrb();
List <Departmentsrb> departments = new List <Departmentsrb>();
Departmentsrb aDepartmentsrb = aManager.GetDepartment(departmentid);
departments.Add(aDepartmentsrb);
return(Json(departments));
}