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