Пример #1
0
        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);
        }
Пример #2
0
        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);
        }