public static dynamic Generate() { using (MonitoringEntities context = new MonitoringEntities()) { return(context.GithubLinkedinCrossTables.Join(context.GithubProfiles, x => x.GithubUserId, y => y.Id, (x, y) => new { ID = y.Id, LinkedinUserId = x.LinkedinUserId, GithubUsername = y.UserName }).Join(context.LinkedinProfiles, x => x.LinkedinUserId, y => y.Id, (x, y) => new { Id = x.ID, GithubUsername = x.GithubUsername, LinkedinUsername = y.Username }).Select(x => new { x.Id, x.GithubUsername, x.LinkedinUsername }).ToList()); } }
public static void UpdateEducation(int ID, string updatedEducation) { using (MonitoringEntities context = new MonitoringEntities()) { context.LinkedinProfiles.FirstOrDefault(x => x.Id == ID).Education = updatedEducation; context.SaveChanges(); } }
public static void RemoveSchool(int ID) { using (MonitoringEntities context = new MonitoringEntities()) { context.LinkedinEducations.Remove(context.LinkedinEducations.Single(x => x.Id == ID)); context.SaveChanges(); } }
public static void AddPerson(string username, string fullName, string specialty, string location, string education, string company, int connectionCount) { using (MonitoringEntities context = new MonitoringEntities()) { context.LinkedinProfiles.Add(new LinkedinProfile { Username = username, FullName = fullName, Specialty = specialty, Location = location, Education = education, Company = company, ConnectionCount = connectionCount }); context.SaveChanges(); } }
public static List <string> GetAllCompanies() { List <string> companies = new List <string>(); using (MonitoringEntities context = new MonitoringEntities()) { companies = context.LinkedinProfiles.Select(x => x.Company).Distinct().ToList(); } return(companies); }