Beispiel #1
0
        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);
        }
Beispiel #2
0
        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);
        }