public void addBrockers(Brockers brocker)
{
string query = $"INSERT INTO Brockers (Id ,FirstName ,LastName ,PhoneNumber ,AgencyId) VALUES ({brocker.Id},'{brocker.FirstName}', '{brocker.LastName}', '{brocker.PhoneNumber}',{brocker.AgencyId});";
executeQuery(query);
}
public void updateBrockers(Brockers entity)
{
string query = $"UPDATE [dbo].[Brockers] SET [Id] = {entity.Id},[FirstName] = '{entity.FirstName}' ,[LastName] ='{entity.LastName}' ,[PhoneNumber] = '{entity.PhoneNumber}' ,[AgencyId] = {entity.AgencyId} WHERE Id = {entity.Id};";
executeQuery(query);
}