private static Dictionary<int, List<Program>> FillProgramMapFromDataSet(DataSet dataSet)
{
Dictionary<int, List<Program>> maps = new Dictionary<int, List<Program>>();
int resultCount = dataSet.Tables[0].Rows.Count;
for (int i = 0; i < resultCount; i++)
{
DataRow prog = dataSet.Tables[0].Rows[i];
Program p = new Program(
Convert.ToInt32(prog["idProgram"]),
Convert.ToInt32(prog["idChannel"]),
Convert.ToDateTime(prog["startTime"]),
Convert.ToDateTime(prog["endTime"]),
Convert.ToString(prog["title"]),
Convert.ToString(prog["description"]),
Convert.ToString(prog["genre"]),
(Program.ProgramState)Convert.ToInt32(prog["state"]),
Convert.ToDateTime(prog["originalAirDate"]),
Convert.ToString(prog["seriesNum"]),
Convert.ToString(prog["episodeNum"]),
Convert.ToString(prog["episodeName"]),
Convert.ToString(prog["episodePart"]),
Convert.ToInt32(prog["starRating"]),
Convert.ToString(prog["classification"]),
Convert.ToInt32(prog["parentalRating"])
);
int idChannel = p.IdChannel;
if (!maps.ContainsKey(idChannel))
{
maps[idChannel] = new List<Program>();
}
maps[idChannel].Add(p);
}
return maps;
}