public void Create(Meeting meeting)
{
using ( var connection = new SqlConnection(_connectionString))
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = "INSERT INTO [dbo].[meeting] (place_id, theme, time, duration) " +
"VALUES (@place_id, @theme, @time, @duration)";
command.Parameters.AddWithValue("@place_id", meeting.FPlace);
command.Parameters.AddWithValue("@theme", meeting.Theme);
command.Parameters.AddWithValue("@time", meeting.Time);
command.Parameters.AddWithValue("@duration", meeting.Duration);
command.ExecuteNonQuery();
}
}
}
public void UpdateMeeting(Meeting meeting, int id)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = "UPDATE [dbo].[meeting] " +
"SET theme = @theme, time=@time, " +
"duration = @duration WHERE id = @id";
command.Parameters.AddWithValue("@id", id);
command.Parameters.AddWithValue("@time", meeting.Time);
command.Parameters.AddWithValue("@theme", meeting.Theme);
command.Parameters.AddWithValue("@duration", meeting.Duration);
command.ExecuteNonQuery();
}
}
}
public Meeting UpdateMeeting(Meeting meeting, int id)
{
_repository.UpdateMeeting(meeting,id);
return _repository.GetMeeting(id);
}
