/**
* this method returns a list of UserPrograms objects of every program in the system.
* */
public static List <UserPrograms> getAllPrograms()
{
List <UserPrograms> programs = new List <UserPrograms>();
String database = System.Configuration.ConfigurationManager.ConnectionStrings["programaholics_anonymous_databaseConnectionString"].ConnectionString;
using (OleDbConnection sqlConn = new OleDbConnection("PROVIDER=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + database))
{
try
{
String query = "SELECT * FROM [programs] ORDER BY [username]";
OleDbDataAdapter adapter = new OleDbDataAdapter(query, sqlConn);
ProgramsDataSet ds = new ProgramsDataSet();
adapter.Fill(ds, "programs");
DataTable table = new DataTable();
table = ds.Tables["programs"];
int i = 0;
do
{
DataRow dr = table.Rows[i]; //set current data row
List <Program> userPrograms = new List <Program>(); //new list for each user
String username = dr["username"].ToString(); //get current user
while (username == dr["username"].ToString()) //for each user create new Program and add to list of programs
{
Program program = new Program();
program.username = dr["username"].ToString();
program.ID = Convert.ToInt32(dr["ID"].ToString());
program.language = dr["language"].ToString();
program.programName = dr["programName"].ToString();
program.createdOnDate = dr["createdOnDate"].ToString();
userPrograms.Add(program);
i++;
if (i < table.Rows.Count) //make sure we don't out of bounds error
{
dr = table.Rows[i]; //move to next data row
}
else
{
break; //break loop if gone over total data rows in table
}
}
UserPrograms thisUser = new UserPrograms(); //complets list of all programs for user
thisUser.username = username; //set username
thisUser.programs = userPrograms; //add all programs
programs.Add(thisUser); //add to all programs in system.
} while (i < table.Rows.Count);
}
catch (OleDbException ex)
{
}
finally
{
sqlConn.Close();
}
return(programs);
}
}
/**
* this method returns a list of UserPrograms objects of every program in the system.
* */
public static List<UserPrograms> getAllPrograms()
{
List<UserPrograms> programs = new List<UserPrograms>();
String database = System.Configuration.ConfigurationManager.ConnectionStrings["programaholics_anonymous_databaseConnectionString"].ConnectionString;
using (OleDbConnection sqlConn = new OleDbConnection("PROVIDER=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + database))
{
try
{
String query = "SELECT * FROM [programs] ORDER BY [username]";
OleDbDataAdapter adapter = new OleDbDataAdapter(query, sqlConn);
ProgramsDataSet ds = new ProgramsDataSet();
adapter.Fill(ds, "programs");
DataTable table = new DataTable();
table = ds.Tables["programs"];
int i = 0;
do
{
DataRow dr = table.Rows[i]; //set current data row
List<Program> userPrograms = new List<Program>(); //new list for each user
String username = dr["username"].ToString(); //get current user
while (username == dr["username"].ToString()) //for each user create new Program and add to list of programs
{
Program program = new Program();
program.username = dr["username"].ToString();
program.ID = Convert.ToInt32(dr["ID"].ToString());
program.language = dr["language"].ToString();
program.programName = dr["programName"].ToString();
program.createdOnDate = dr["createdOnDate"].ToString();
userPrograms.Add(program);
i++;
if (i < table.Rows.Count) //make sure we don't out of bounds error
{
dr = table.Rows[i]; //move to next data row
}
else
{
break; //break loop if gone over total data rows in table
}
}
UserPrograms thisUser = new UserPrograms(); //complets list of all programs for user
thisUser.username = username; //set username
thisUser.programs = userPrograms; //add all programs
programs.Add(thisUser); //add to all programs in system.
} while (i < table.Rows.Count);
}
catch (OleDbException ex)
{
}
finally
{
sqlConn.Close();
}
return programs;
}
}
