public void Update(AbstractConnection conn, AbstractTransaction trans, BasketballTeams teams)
{
SqlParameter id = new SqlParameter();
id.ParameterName = "@Id";
id.SourceColumn = "Id";
SqlParameter name = new SqlParameter();
name.ParameterName = "@Name";
name.SourceColumn = "Name";
SqlParameter surname = new SqlParameter();
surname.ParameterName = "@Surname";
surname.SourceColumn = "Surname";
SqlParameter telNumber = new SqlParameter();
telNumber.ParameterName = "@TelNumber";
telNumber.SourceColumn = "TelNumber";
SqlParameter email = new SqlParameter();
email.ParameterName = "@Email";
email.SourceColumn = "Email";
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.UpdateCommand = new SqlCommand(@"update Manager set Name = @Name, Surname = @Surname, TelNumber = @TelNumber, Email = @Email where Id = @Id", conn.Connection, trans.Transaction);
adapter.UpdateCommand.Parameters.Add(id);
adapter.UpdateCommand.Parameters.Add(name);
adapter.UpdateCommand.Parameters.Add(surname);
adapter.UpdateCommand.Parameters.Add(telNumber);
adapter.UpdateCommand.Parameters.Add(email);
SqlParameter id1 = new SqlParameter();
id1.ParameterName = "@Id";
id1.SourceColumn = "Id";
SqlParameter name1 = new SqlParameter();
name1.ParameterName = "@Name";
name1.SourceColumn = "Name";
SqlParameter surname1 = new SqlParameter();
surname1.ParameterName = "@Surname";
surname1.SourceColumn = "Surname";
SqlParameter telNumber1 = new SqlParameter();
telNumber1.ParameterName = "@TelNumber";
telNumber1.SourceColumn = "TelNumber";
SqlParameter email1 = new SqlParameter();
email1.ParameterName = "@Email";
email1.SourceColumn = "Email";
adapter.InsertCommand = new SqlCommand(@"insert into Manager(Name, Surname, TelNumber, Email) values(@Name, @Surname, @TelNumber, @Email)", conn.Connection, trans.Transaction);
adapter.InsertCommand.Parameters.Add(name1);
adapter.InsertCommand.Parameters.Add(surname1);
adapter.InsertCommand.Parameters.Add(telNumber1);
adapter.InsertCommand.Parameters.Add(email1);
adapter.DeleteCommand = new SqlCommand(@"delete from Manager where Id = @Id", conn.Connection, trans.Transaction);
adapter.DeleteCommand.Parameters.Add(id1);
adapter.Update(teams, "Manager");
}
