public static Object getAllGroups() { String[] list = new String[4]; List <Group> groupList = null; try { String connectionString = DatabaseConnections.getConnectionString("NARAYANA_CLIENT"); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); String sqlQuery = "SELECT * FROM " + GROUPS_TABLE; using (SqlCommand command = new SqlCommand(sqlQuery, connection)) { groupList = new List <Group>(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Console.Write(reader.GetString(1)); Group group = GroupsUtility.getGroupFormReader(reader); groupList.Add(group); } } } } } catch (InvalidOperationException e) { return(e); } catch (SqlException e) { return(e); } catch (Exception e) { return(e); } return(groupList); }
public static Object getGroupForId(int id) { Group group = null; try { String connectionString = DatabaseConnections.getConnectionString("NARAYANA_CLIENT"); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); String sqlQuery = "SELECT * FROM " + GROUPS_TABLE + " WHERE ID = " + id; using (SqlCommand command = new SqlCommand(sqlQuery, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Console.Write(reader.GetString(1)); group = GroupsUtility.getGroupFormReader(reader); } } } } } catch (SqlException e) { return(e); } catch (InvalidOperationException e) { return(e); } catch (InvalidCastException e) { return(e); } catch (Exception e) { return(e); } if (null != group) { return(group); } else { return(new Exception("Student Not Found")); } }