public PlaceHolder BuildNotifications(string userId) { DataHandler handler = new DataHandler(); string query; PlaceHolder ph = new PlaceHolder(); DataTable[] tables = new DataTable[2]; ArrayList messages = new ArrayList(); GroupService groupService = new GroupService(); //http://stackoverflow.com/questions/5672862/check-if-datetime-instance-falls-in-between-other-two-datetime-objects //notification: you added a teacher query = "SELECT * FROM user_UserHasTeachers " + "WHERE TeacherId = ''" + "ORDER BY Timestamp"; tables[0] = handler.GetDataTable(query); foreach (DataRow row in tables[0].Rows) { } //make sense of the data tables //for each table foreach (DataTable dt in tables) { //check timestamp //insert into position } return ph; }
public DataTable GetMemberOfData(string UserId) { handler = new DataHandler(); string select = "SELECT * FROM user_Groups, user_UsersInGroups " + "WHERE user_UsersInGroups.UserId = '" + UserId + "' " + "AND user_Groups.GroupId = user_Groups.GroupId"; return handler.GetDataTable(select); }
public DataTable GetHasTeachersData(string UserId) { handler = new DataHandler(); string select = "SELECT user_UserHasTeachers.TeacherId, aspnet_Users.UserName " + "FROM user_UserHasTeachers, aspnet_Users " + "WHERE user_UserHasTeachers.TeacherId = aspnet_Users.UserId " + "AND user_UserHasTeachers.UserId = '" + UserId + "'"; return handler.GetDataTable(select); }
public DataTable GetUsersInGroup(string groupId) { handler = new DataHandler(); string select = "SELECT aspnet_Users.UserId, aspnet_Users.UserName " + "FROM user_UsersInGroups, aspnet_Users " + "WHERE user_UsersInGroups.UserId = aspnet_Users.UserId " + "AND user_UsersInGroups.GroupId = '" + groupId + "'"; return handler.GetDataTable(select); }
public DataTable GetTable(string userId, string tableId) { handler = new DataHandler(); string select; switch (tableId) { case "supervisorOf": select = "SELECT * FROM user_Groups WHERE TeacherId = '" + userId + "'"; return handler.GetDataTable(select); case "memberOf": select = "SELECT * FROM user_Groups, user_UsersInGroups " + "WHERE user_UsersInGroups.UserId = '" + userId + "' " + "AND user_Groups.GroupId = user_Groups.GroupId"; return handler.GetDataTable(select); } return null; }
public DataTable GetSupervisorOfData(string UserId) { handler = new DataHandler(); string select = "SELECT * FROM user_Groups WHERE TeacherId = '" + UserId + "'"; return handler.GetDataTable(select); }
public DataTable GetProspectiveStudentsData(string UserId) { handler = new DataHandler(); string select = "SELECT aspnet_Users.UserName, aspnet_Users.UserId " + "FROM user_UserHasTeachers, aspnet_Users " + "WHERE TeacherId = '" + UserId + "' " + "AND aspnet_Users.UserId = user_UserHasTeachers.UserId " + "AND aspnet_Users.UserId NOT IN " + "(SELECT UserId FROM user_UsersInGroups)"; return handler.GetDataTable(select); }