public static async Task <int> CreateProjectTechnologyAsync(ProjectTechnology projectTechnology)
        {
            using (var db = new AppDbContext(ConnectionParameters.connectionString))
            {
                db.ProjectTechnologies.Add(projectTechnology);
                await db.SaveChangesAsync();

                return(projectTechnology.ProjectTechnologyID);
            }
        }
 public static async Task DeleteProjectTechnologyAsync(int projectID, int technologyID)
 {
     using (var db = new AppDbContext(ConnectionParameters.connectionString))
     {
         ProjectTechnology projectTechnology = db.ProjectTechnologies
                                               .Where(x => x.ProjectID == projectID && x.TechnologyID == technologyID)
                                               .FirstOrDefault();
         db.ProjectTechnologies.Remove(projectTechnology);
         await db.SaveChangesAsync();
     }
 }