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(); }