public async Task <Teacher> GetTeacher(int id)
{
string query = @"SELECT * FROM TEACHER WHERE Id = @id";
List <SqlParam> collection = new List <SqlParam>()
{
new SqlParam("@id", SqlDbType.Int, id)
};
return(await _dao.FetchItemAsync <Teacher>(query, collection));
}
public async Task <User> GetUser(int id)
{
string query = @"SELECT U.*,R.Name AS RoleName FROM [USER] U INNER JOIN [ROLE] R ON U.RoleId = R.Id WHERE U.Id = @id";
List <SqlParam> collection = new List <SqlParam>()
{
new SqlParam("@id", SqlDbType.Int, id)
};
return(await _dao.FetchItemAsync <User>(query, collection));
}
public async Task <Role> GetRole(int id)
{
string query = @"SELECT * FROM ROLE WHERE Id = @id";
List <SqlParam> collection = new List <SqlParam>()
{
new SqlParam("@id", SqlDbType.Int, id)
};
return(await _dao.FetchItemAsync <Role>(query, collection));
}
public async Task <Student> GetStudent(int studentId)
{
string query = @"SELECT * FROM STUDENT WHERE Id = @studentId";
List <SqlParam> collection = new List <SqlParam>()
{
new SqlParam("@studentId", SqlDbType.Int, studentId)
};
return(await _dao.FetchItemAsync <Student>(query, collection));
}
public async Task <Module> GetModule(int id)
{
string query = @"SELECT M.*,C.Name AS CourseName,S.Name AS SemesterName FROM Module M INNER JOIN COURSE C ON M.CourseId= C.Id
INNER JOIN Semester S ON M.SemesterId = S.Id WHERE M.Id = @id";
List <SqlParam> collection = new List <SqlParam>()
{
new SqlParam("@id", SqlDbType.Int, id)
};
return(await _dao.FetchItemAsync <Module>(query, collection));
}
public async Task <User> GetUser(Login data)
{
string query = @"USP_LOGIN";
List <SqlParam> collection = new List <SqlParam>()
{
new SqlParam("@USERNAME", SqlDbType.VarChar, data.UserName),
new SqlParam("@PASSWORD", SqlDbType.VarChar, data.Password),
};
return(await _dao.FetchItemAsync <User>(query, collection, CommandType.StoredProcedure));
}
public async Task <StudentModuleMapping> GetStudentModuleMapping(int id)
{
string query = @"SELECT SMM.*,S.Name AS StudentName,M.Name AS ModuleName FROM StudentModuleMapping SMM INNER JOIN Student S
ON SMM.StudentId = S.Id INNER JOIN Module M ON SMM.ModuleId= M.Id WHERE SMM.Id = @id";
List <SqlParam> collection = new List <SqlParam>()
{
new SqlParam("@id", SqlDbType.Int, id)
};
return(await _dao.FetchItemAsync <StudentModuleMapping>(query, collection));
}
public async Task <Timetable> GetTimetable(int id)
{
string query = @"SELECT T.*,S.Name AS SemesterName, M.Name AS ModuleName,TE.Name AS TeacherName FROM Timetable T INNER JOIN Semester S ON T.SemesterId = S.Id
INNER JOIN Module M on T.ModuleId = M.Id INNER JOIN Teacher TE ON T.TeacherId = TE.Id WHERE T.Id = @id";
List <SqlParam> collection = new List <SqlParam>()
{
new SqlParam("@id", SqlDbType.Int, id)
};
return(await _dao.FetchItemAsync <Timetable>(query, collection));
}
