public void addAgencies(Agencyes entity) { string query = $"INSERT INTO [dbo].[Agencyes] ([Id] ,[Name] ,[License] ,[Address] ,[PhoneNumber] ,[DirectorId]) VALUES ({entity.Id},'{entity.Name}', {entity.License}, '{entity.Address}','{entity.PhoneNumber}',{entity.DirectorId})"; executeQuery(query); }
public void updateAgencyes(Agencyes entity) { string query = $"UPDATE [dbo].[Agencyes] SET [Id] = {entity.Id} ,[Name] = '{entity.Name}',[License] = {entity.License},[Address] ='{entity.Address}' ,[PhoneNumber] ='{entity.PhoneNumber}' ,[DirectorId] = {entity.DirectorId} WHERE Id= {entity.Id};"; executeQuery(query); }