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)); }