public static IDataReader Get()
{
con = new Connections();
string queryStr = "SELECT Id, FullName, Email, College, Username, Password, " +
"Subject, Age, Birthday, Assigned FROM Student ";
return(con.ExecuteReader(queryStr));
}
public static IDataReader GetByMember(int studentId)
{
con = new Connections();
string queryStr = "SELECT GroupId FROM GroupMember " +
" WHERE StudentId = " + studentId;
return(con.ExecuteReader(queryStr));
}
public static IDataReader Get()
{
con = new Connections();
string queryStr = "SELECT Id, FullName, Email, Username," +
"Password, PhoneNumber, Address, CreatedBy, CreatedAt, Status, avatar FROM Professors";
return(con.ExecuteReader(queryStr));
}
public static IDataReader GetByQuestion(int questionId)
{
con = new Connections();
string queryStr = "SELECT Id, Answer, QuestionId, Status" +
"FROM Answer" +
"WHERE QuestionId = " + questionId;
return(con.ExecuteReader(queryStr));
}
public static IDataReader GetByAdmin(int id)
{
con = new Connections();
string queryStr = "SELECT Professors.Id, Professors.FullName, Professors.Email, Professors.Username," +
"Professors.Password, Professors.PhoneNumber, Professors.Address, Professors.CreatedBy, Administrator.FullName as CreatedByStr, CreatedAt, Status, Professors.avatar FROM Professors, Administrator" +
" WHERE Administrator.Id = Professors.CreatedBy AND CreatedBy = " + id;
return(con.ExecuteReader(queryStr));
}
public static IDataReader Get(int groupId)
{
con = new Connections();
string queryStr = "SELECT Student.Id, Student.FullName, Student.Email, Student.College, Student.Username, Student.Password, " +
"Student.Subject, Student.Age, Student.Birthday, Student.Assigned, JoinAt FROM Student, GroupMember " +
" WHERE Student.Id = GroupMember.StudentId AND GroupId = " + groupId;
return(con.ExecuteReader(queryStr));
}
public static IDataReader Get(string code)
{
con = new Connections();
string queryStr = "SELECT Student.Id, Student.FullName, Student.Email, Student.College, Student.Username, Student.Password, " +
"Student.Subject, Student.Age, Student.Birthday, Student.Assigned, JoinAt FROM Student, GroupMember, [dbo].[Group] " +
" WHERE Student.Id = GroupMember.StudentId AND [dbo].[Group].Id = GroupMember.GroupId AND [dbo].[Group].GroupCode like '" + code + "'";
return(con.ExecuteReader(queryStr));
}
public static IDataReader GetById(int id)
{
con = new Connections();
string queryStr = "SELECT Id, StudentId, StartDate, " +
"ExpiryDate, Score, SubmitAt FROM OnlineTest " +
" WHERE Id = '" + id + "'";
return(con.ExecuteReader(queryStr));
}
public static IDataReader GetByProject(int projectId)
{
con = new Connections();
string queryStr = "SELECT Id, Question, ProjectId" +
"FROM Question" +
"WHERE ProjectId = " + projectId;
return(con.ExecuteReader(queryStr));
}
public static IDataReader Get(int id)
{
con = new Connections();
string queryStr = "SELECT Id, FullName, Email, Username," +
"Password, Avatar FROM Administrator" +
" WHERE Id = " + id;
return(con.ExecuteReader(queryStr));
}
public static IDataReader Get(string projectCode)
{
con = new Connections();
string queryStr = "SELECT Id, ProjectCode, Name, CreatedAt, CreatedBy, StartDate, EndDate " +
"FROM Project " +
"WHERE ProjectCode like '" + projectCode + "'";
return(con.ExecuteReader(queryStr));
}
public static IDataReader GetByProfessor(int id)
{
con = new Connections();
string queryStr = "SELECT Id, ProjectCode, Name, CreatedAt, CreatedBy, StartDate, EndDate " +
"FROM Project" +
" WHERE CreatedBy = " + id;
return(con.ExecuteReader(queryStr));
}
public static IDataReader GetById(int id)
{
con = new Connections();
string queryStr = "SELECT [dbo].[Group].Id, [dbo].[Group].GroupCode, [dbo].[Group].GroupName, " +
"[dbo].[Group].CreatedAt, [dbo].[Group].CreatedBy, Student.FullName as CreatedByStr, [dbo].[Group].AssignBy, [dbo].[Group].ProjectId " +
" FROM [dbo].[Group], Student WHERE [dbo].[Group].CreatedBy = Student.Id AND Id = '" + id + "'";
return(con.ExecuteReader(queryStr));
}
public static IDataReader TestSelect()
{
return(con.ExecuteReader("Select * From Administrator"));
}
