public List<Round> GetRoundByIDCompetition(Round round)
{
List<Round> RoundList = new List<Round>();
string query = "SELECT [Round_ID],[Competition_ID],[Round_Name]"
+ " FROM [Round]"
+ "WHERE [Competition_ID] = '"+round.IDCompetition+"'";
DataTable dt = DA.SelectDatabase(query);
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
Round Round = new Round();
Round.IDRound = Convert.ToInt32(item["Round_ID"].ToString());
Round.IDCompetition = Convert.ToInt32(item["Competition_ID"].ToString());
Round.NameRound = item["Round_Name"].ToString();
RoundList.Add(Round);
}
}
return RoundList;
}