public List<Contest> GetContest()
{
List<Contest> ContestList = new List<Contest>();
string query = "SELECT [Contest_ID],[Round_ID],[Contest_Name],[Bonus],[Request_Time],[Challenge_Score],[Number_Challenge]"
+ ",[Time_show_Anwer],[Time_show_Question],[Time_of_True],[Time_of_False]"
+ " FROM [Contest]";
DataTable dt = DA.SelectDatabase(query);
//int i = 1;
if (dt!= null)
{
foreach (DataRow item in dt.Rows)
{
Contest Contest = new Contest();
Contest.IDContest = Convert.ToInt32(item["Contest_ID"].ToString());
Contest.IDRound = Convert.ToInt32(item["Round_ID"].ToString());
Contest.NameContest = (item["Contest_Name"]).ToString();
Contest.Bonus = Convert.ToInt32(item["Bonus"].ToString());
Contest.TimeSupport = Convert.ToInt32(item["Request_Time"].ToString());
Contest.ChallengceScore = Convert.ToInt32(item["Challenge_Score"].ToString());
Contest.NumberChallenge = Convert.ToInt32(item["Number_Challenge"].ToString());
Contest.TimeShowAnswer = Convert.ToInt32(item["Time_show_Anwer"].ToString());
Contest.TimeShowQuestion = Convert.ToInt32(item["Time_show_Question"].ToString());
Contest.TimesTrue = Convert.ToInt32(item["Time_of_True"].ToString());
Contest.TimesFalse= Convert.ToInt32(item["Time_of_False"].ToString());
ContestList.Add(Contest);
//i++;
}
}
return ContestList;
}