public KindOfSport GetKindOfSport(int id)
{
KindOfSport Kind = new KindOfSport()
{
Id = id
};
using (SqlConnection connection = new SqlConnection(_connectingString))
{
connection.Open();
SqlCommand command = new SqlCommand
{
CommandText = "GetKindOfSport",
CommandType = System.Data.CommandType.StoredProcedure,
Connection = connection
};
command.Parameters.AddWithValue("@Id", id);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows) // если есть данные
{
reader.Read();
Kind.Name = (string)reader["Name"];
}
reader.Close();
}
return(Kind);
}
public void AddKindOfSport(KindOfSport kindOfSport)
{
using (SqlConnection connection = new SqlConnection(connectionstring))
{
SqlCommand cmd = new SqlCommand("AddKindOfSport", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@nameOfKind", kindOfSport.NameOfKind);
connection.Open();
cmd.ExecuteNonQuery();
}
}
public ActionResult AddSport(KindOfSport kindOfSport)
{
if (ModelState.IsValid && kindOfSportLogic.GetNeedKindOfSports(kindOfSport.NameOfKind).Any())
{
ModelState.AddModelError("NameOfKind", "Вид спорта с таким названием уже существует!");
}
if (ModelState.IsValid)
{
kindOfSportLogic.AddKindOfSport(kindOfSport);
return(RedirectToAction("GetSports"));
}
else
{
return(View());
}
}
private void button1_Click(object sender, EventArgs e)
{
string name = textBox1.Text;
if (!kindOfSportLogic.GetNeedKindOfSports(name).Any())
{
KindOfSport kindOfSport = new KindOfSport
{
NameOfKind = name
};
kindOfSportLogic.AddKindOfSport(kindOfSport);
MessageBox.Show("Вид спорта добавлен!");
Close();
}
else
{
MessageBox.Show("Вид спорта с таким названием уже существует!");
}
}
public IEnumerable <KindOfSport> GetKindOfSports()
{
var result = new List <KindOfSport>();
using (SqlConnection connection = new SqlConnection(connectionstring))
{
SqlCommand cmd = new SqlCommand("GetSports", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
connection.Open();
SqlDataReader read = cmd.ExecuteReader();
while (read.Read()) //пока читаем
{
var kindOfSport = new KindOfSport
{
IDKindOfSport = (int)read["IDOfKind"],
NameOfKind = (string)read["NameOfKind"]
};
result.Add(kindOfSport);
}
}
return(result);
}
/// <summary>
/// Инициализирует новый экземпляр класса <see cref="Skill"/>.
/// </summary>
/// <param name="kindOfSport">Вид спорта.</param>
public Skill(KindOfSport kindOfSport)
{
KindOfSport = kindOfSport;
}
public void AddKindOfSport(KindOfSport kindOfSport)
{
kindOfSportDao.AddKindOfSport(kindOfSport);
}
/// <summary>
/// Инициализирует новый экземпляр класса <see cref="Game"/>.
/// </summary>
/// <param name="id"></param>
/// <param name="kindOfSport"></param>
public Game(ObjectId id, KindOfSport kindOfSport)
{
Id = id;
KindOfSport = kindOfSport;
}
