public List<Phase> GetPhase()
{
List<Phase> PhaseList = new List<Phase>();
string query = "SELECT [Contest_ID],[Phase_ID],[Phase_Name],[Phase_Score],[Phase_Minus],[Phase_Time],[Sequence]"
+" FROM [Phase]";
DataTable dt = DA.SelectDatabase(query);
//int i = 1;
if (dt!= null)
{
foreach (DataRow item in dt.Rows)
{
Phase Phase = new Phase();
Phase.IDContest = Convert.ToInt32(item["Contest_ID"].ToString());
Phase.IDPhase = Convert.ToInt32(item["Phase_ID"].ToString());
Phase.NamePhase = item["Phase_Name"].ToString();
Phase.ScorePhase = Convert.ToInt32(item["Phase_Score"].ToString());
Phase.MinusPhase = Convert.ToInt32(item["Phase_Minus"].ToString());
Phase.TimePhase = Convert.ToInt32(item["Phase_Time"].ToString());
Phase.Sequence = Convert.ToInt32(item["Sequence"].ToString());
PhaseList.Add(Phase);
//i++;
}
}
return PhaseList;
}