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