public void Add(Coutry coutry)
{
using (var connection = _providerFactory.CreateConnection())
using (var command = connection.CreateCommand())
{
try
{
connection.ConnectionString = _connectionString;
connection.Open();
command.CommandText = "insert into Countries (Id,Name,CreationDate) values (@Id,@Name,@CreationDate)";
DbParameter idParameter = command.CreateParameter();
idParameter.ParameterName = "@Id";
idParameter.DbType = System.Data.DbType.Guid;
idParameter.Value = coutry.Id;
DbParameter nameParameter = command.CreateParameter();
nameParameter.ParameterName = "@Name";
nameParameter.DbType = System.Data.DbType.String;
nameParameter.Value = coutry.Name;
DbParameter creationDateParameter = command.CreateParameter();
creationDateParameter.ParameterName = "@CreationDate";
creationDateParameter.DbType = System.Data.DbType.DateTime;
creationDateParameter.Value = coutry.CreationDate;
DbParameter deletedDateParameter = command.CreateParameter();
deletedDateParameter.ParameterName = "@DeletedDate";
deletedDateParameter.DbType = System.Data.DbType.DateTime;
deletedDateParameter.Value = coutry.DeletedDate;
command.Parameters.AddRange(new DbParameter[] { idParameter, nameParameter, creationDateParameter /*, deletedDateParameter*/ });
var affectrdRows = command.ExecuteNonQuery();
if (affectrdRows < 1)
{
throw new Exception("Вставка не удалась");
}
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
throw;
}
}
}
public void Update(Coutry coutry)
{
using (var connection = _providerFactory.CreateConnection())
using (var command = connection.CreateCommand())
{
try
{
connection.ConnectionString = _connectionString;
connection.Open();
command.CommandText = "update Reciver set Name = @Name WHERE Id = @Id";
DbParameter idParameter = command.CreateParameter();
idParameter.ParameterName = "@Id";
idParameter.DbType = System.Data.DbType.Guid;
idParameter.Value = coutry.Id;
DbParameter nameParameter = command.CreateParameter();
nameParameter.ParameterName = "@Name";
nameParameter.DbType = System.Data.DbType.String;
nameParameter.Value = coutry.Name;
command.Parameters.AddRange(new DbParameter[] { idParameter, nameParameter });
var affectrdRows = command.ExecuteNonQuery();
if (affectrdRows < 1)
{
throw new Exception("Обновление не удалось");
}
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
throw;
}
}
}
private void ButtonAddCountryClick(object sender, EventArgs e)
{
AddForm addForm = new AddForm();
DialogResult result = addForm.ShowDialog(this);
if (result == DialogResult.Cancel)
{
return;
}
if (addForm.textBoxName.Text.Count() < 1)
{
MessageBox.Show("Вы не ввели название");
return;
}
Coutry coutry = new Coutry {
Name = addForm.textBoxName.Text
};
countryDataService.Add(coutry);
LoadDataGridViewCountries();
}
