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(); } }