示例#1
0
 public List <Gymnast> GetGymnasts(List <Competitor> competitors)
 {
     _gymnasts = new List <Gymnast>();
     if (competitors.Count == 0)
     {
         return(_gymnasts);
     }
     else
     {
         SqlConnection myConection = new SqlConnection(_connectionString);
         myConection.Open();
         SqlCommand    cmd    = new SqlCommand(GetQuery(competitors), myConection);
         SqlDataReader reader = cmd.ExecuteReader();
         while (reader.Read())
         {
             Gymnast gymnast = new Gymnast()
             {
                 ID        = Convert.ToInt32(reader["Id"]),
                 LastName  = reader["LastName"].ToString(),
                 FirstName = reader["FirstName"].ToString(),
                 Country   = reader["Country"].ToString()
             };
             _gymnasts.Add(gymnast);
         }
         reader.Close();
         myConection.Close();
         return(_gymnasts);
     }
 }
示例#2
0
 public int AddGymnast(Gymnast gymnastInfo)
 {
     using (SqlConnection myConection = new SqlConnection(_connectionString))
     {
         SqlCommand cmd = new SqlCommand("INSERT INTO [dbo].[Gymnasts] (LastName, FirstName, Country) Output Inserted.Id VALUES (@LastName, @FirstName, @Country)", myConection);
         cmd.CommandType = CommandType.Text;
         cmd.Connection  = myConection;
         cmd.Parameters.AddWithValue("@LastName", gymnastInfo.LastName);
         cmd.Parameters.AddWithValue("@FirstName", gymnastInfo.FirstName);
         cmd.Parameters.AddWithValue("@Country", gymnastInfo.Country);
         myConection.Open();
         int idGymnast = (int)cmd.ExecuteScalar();
         return(idGymnast);
     }
 }