public StudentModel Roll(string Roll)
{
try
{
var query = "SELECT * FROM tblStudent WHERE Roll='" + Roll + "'";
var reader = _sDB.ExecuteReader(query, _connectionString);
if (reader.HasRows)
{
reader.Read();
var StudentModel = new StudentModel()
{
Id = Convert.ToInt32(reader["Id"]),
DepartmentId = Convert.ToInt32(reader["DepartmentId"]),
CourseId = Convert.ToInt32(reader["CourseId"]),
StudentName = reader["StudentName"].ToString(),
Roll = reader["Roll"].ToString(),
Email = reader["Email"].ToString()
};
return(StudentModel);
}
return(null);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public StudentInfoModel DepartmentId(string DepartmentId)
{
try
{
var query = "SELECT * FROM tblStudentInfo WHERE DepartmentId='" + DepartmentId + "'";
var reader = _sDB.ExecuteReader(query, _connectionString);
if (reader.HasRows)
{
reader.Read();
var StudentInfoModel = new StudentInfoModel()
{
Id = Convert.ToInt32(reader["Id"]),
StudentId = Convert.ToInt32(reader["StudentId"]),
DepartmentId = Convert.ToInt32(reader["DepartmentId"]),
CourseId = Convert.ToInt32(reader["CourseId"]),
};
return(StudentInfoModel);
}
return(null);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public CourseModel GetByCourse(string Course)
{
try
{
var query = "SELECT * FROM tblCourse WHERE CourseName='" + Course + "'";
var reader = _sDB.ExecuteReader(query, _connectionString);
if (reader.HasRows)
{
reader.Read();
var CourseModel = new CourseModel()
{
Id = Convert.ToInt32(reader["Id"]),
DepartmentId = Convert.ToInt32(reader["DepartmentId"]),
CourseCode = reader["CourseCode"].ToString(),
CourseName = reader["CourseName"].ToString()
};
return(CourseModel);
}
return(null);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public DepartmentModel GetByDepartment(string Department)
{
try
{
var query = "SELECT * FROM tblDepartment WHERE Department='" + Department + "'";
var reader = _sDB.ExecuteReader(query, _connectionString);
if (reader.HasRows)
{
reader.Read();
var category = new DepartmentModel()
{
Id = Convert.ToInt32(reader["Id"]),
Code = reader["Code"].ToString(),
Department = reader["Department"].ToString()
};
return(category);
}
return(null);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
