public Link retrieveLink(int linkID)
{
using (var db = new PortfolioUnleashedContext())
{
return(db.Links.Include("User").FirstOrDefault(link => link.Id == linkID));
}
}
public ProjectMedium retrieveProjectMedium(int mediumID)
{
using (var db = new PortfolioUnleashedContext())
{
return(db.ProjectMediums.FirstOrDefault(med => med.Id == mediumID));
}
}
public Contribution retrieveContribution(int userID, int projectID)
{
using (var db = new PortfolioUnleashedContext())
{
return(db.Contributions.Include("Project").Include("User").Include("ContributionMedia").FirstOrDefault(cont => (cont.UserId == userID && cont.ProjectId == projectID)));
}
}
public void deleteContribution(Contribution c, int projectID)
{
using (var db = new PortfolioUnleashedContext())
{
db.Projects.Include("Contributions").Include(p => p.Contributions.Select(co => co.ContributionMedia)).FirstOrDefault(u => u.Id == projectID)
.Contributions.Remove(db.Contributions.Where(con => con.ProjectId == projectID && con.UserId == c.UserId).FirstOrDefault());
if (db.ContributionMediums.Any(co => co.UserId == c.UserId && co.ProjectId == projectID)) //Remove all media for contribution
{
foreach (ContributionMedium cm in db.ContributionMediums.Where(co => co.UserId == c.UserId && co.ProjectId == projectID))
{
db.ContributionMediums.Remove(cm);
}
}
db.Contributions.Remove(db.Contributions.Where(cb => cb.UserId == c.UserId && cb.ProjectId == c.ProjectId).FirstOrDefault()); //Remove the contribution
db.SaveChanges();
if (db.Projects.Include("Contributions").FirstOrDefault(proj => proj.Id == projectID).Contributions.Count <= 0) //If no contributions remaining
{
deleteProjectCompletely(db.Projects.Include("Contributions").FirstOrDefault(prod => prod.Id == projectID));
}
else if (db.Users.Include("ProjectPermissions").FirstOrDefault(user => user.Id == c.UserId).ProjectPermissions.Any(proj => proj.IsProjectEditor == true)) //Contributing user was a project editor
{
if (!db.Users.Include("ProjectPermissions").Any(user => (user.ProjectPermissions.Any(proj => (proj.ProjectId == projectID && proj.IsProjectEditor == true))))) //If no remaining contributing users are project editors
{
int selectedUserToPromote = db.Projects.Include("Contributions").FirstOrDefault(proj => proj.Id == projectID).Contributions.FirstOrDefault(cont => cont.UserId != null).UserId;
db.Users.Include("ProjectPermissions").FirstOrDefault(user => user.Id == selectedUserToPromote).ProjectPermissions.FirstOrDefault(perm => perm.ProjectId == projectID).IsProjectEditor = true;
}
}
if (db.ProjectPermissions.Any(perm => perm.UserId == c.UserId && perm.ProjectId == projectID))
{
db.Projects.Include("ProjectPermissions").Where(pr => pr.Id == projectID).FirstOrDefault().ProjectPermissions
.Remove(db.ProjectPermissions.Include("Project").Include("User").Where(perm => perm.UserId == c.UserId && perm.ProjectId == projectID).FirstOrDefault());
}
db.SaveChanges();
}
}
public ContributionMedium retrieveContributionMedium(int mediumID)
{
using (var db = new PortfolioUnleashedContext())
{
return(db.ContributionMediums.Include("User").Include("Projects").FirstOrDefault(med => med.Id == mediumID));
}
}
public List <Project> retrieveAllProjectsByUserID(int userID)
{
using (var db = new PortfolioUnleashedContext())
{
return(db.Projects.Include("Contributions").Include(p => p.Contributions.Select(c => c.ContributionMedia)).Include("ProjectMedia").Include("Portfolios").Include("ProjectPermissions").Where(p => p.Contributions.Any(c => c.UserId == userID)).ToList());
}
}
public ContactInfo retrieveContactInfo(int contactID)
{
using (var db = new PortfolioUnleashedContext())
{
return(db.ContactInfoes.Include("User").FirstOrDefault(cont => cont.Id == contactID));
}
}
public Project retrieveProject(int projectID)
{
using (var db = new PortfolioUnleashedContext())
{
return(db.Projects.Include("Contributions").Include(p => p.Contributions.Select(c => c.ContributionMedia)).Include(p => p.Contributions.Select(c => c.User)).Include("ProjectMedia").Include("Portfolios").Include("ProjectPermissions").FirstOrDefault(proj => proj.Id == projectID));
}
}
public Notification retrieveNotification(int notificationID)
{
using (var db = new PortfolioUnleashedContext())
{
return(db.Notifications.Include("User").FirstOrDefault(noti => noti.Id == notificationID));
}
}
public void deleteAllData()
{
using (var db = new PortfolioUnleashedContext())
{
db.Database.ExecuteSqlCommand("delete from webpages_UsersInRoles");
db.Database.ExecuteSqlCommand("delete from webpages_Membership");
db.Database.ExecuteSqlCommand("delete from QuickReference");
db.Database.ExecuteSqlCommand("delete from ProjectPermission");
db.Database.ExecuteSqlCommand("delete from Portfolio");
db.Database.ExecuteSqlCommand("delete from Notification");
db.Database.ExecuteSqlCommand("delete from ContributionMedium");
db.Database.ExecuteSqlCommand("delete from Link");
db.Database.ExecuteSqlCommand("delete from Education");
db.Database.ExecuteSqlCommand("delete from Contribution");
db.Database.ExecuteSqlCommand("delete from ContactInfo");
db.Database.ExecuteSqlCommand("delete from [User]");
db.Database.ExecuteSqlCommand("delete from Project_Portfolio");
db.Database.ExecuteSqlCommand("delete from ProjectMedium");
db.Database.ExecuteSqlCommand("delete from Project");
db.Database.ExecuteSqlCommand("delete from webpages_OAuthMembership");
db.Database.ExecuteSqlCommand("delete from webpages_Roles");
}
}
public Education retrieveEducation(int educationID)
{
using (var db = new PortfolioUnleashedContext())
{
return(db.Educations.Include("User").FirstOrDefault(cont => cont.Id == educationID));
}
}
public void updatePortfolio(Portfolio p, int userID)
{
using (var db = new PortfolioUnleashedContext())
{
if (p.Title != null)
{
db.Users.Include("Portfolios").FirstOrDefault(user => user.Id == userID).Portfolios.FirstOrDefault(port => port.Id == p.Id).Title = p.Title;
}
if (p.URL != null)
{
db.Users.Include("Portfolios").FirstOrDefault(user => user.Id == userID).Portfolios.FirstOrDefault(port => port.Id == p.Id).URL = p.URL;
}
if (p.Description != null)
{
db.Users.Include("Portfolios").FirstOrDefault(user => user.Id == userID).Portfolios.FirstOrDefault(port => port.Id == p.Id).Description = p.Description;
}
if (p.Visibility != db.Users.Include("Portfolios").FirstOrDefault(user => user.Id == userID).Portfolios.FirstOrDefault(port => port.Id == p.Id).Visibility)
{
db.Users.Include("Portfolios").FirstOrDefault(user => user.Id == userID).Portfolios.FirstOrDefault(port => port.Id == p.Id).Visibility = p.Visibility;
}
if (p.IsMainPortfolio != db.Users.Include("Portfolios").FirstOrDefault(user => user.Id == userID).Portfolios.FirstOrDefault(port => port.Id == p.Id).IsMainPortfolio)
{
db.Users.Include("Portfolios").FirstOrDefault(user => user.Id == userID).Portfolios.FirstOrDefault(port => port.Id == p.Id).IsMainPortfolio = p.IsMainPortfolio;
}
db.SaveChanges();
}
}
public void deleteLink(Link l, int userID)
{
using (var db = new PortfolioUnleashedContext())
{
db.Users.Include("ContactInfoes").Include("Educations").Include("Links").Include("Portfolios").Include("QuickReferences").FirstOrDefault(user => user.Id == userID).Links.Remove(l);
db.SaveChanges();
}
}
public void addLink(Link l, int userID)
{
using (var db = new PortfolioUnleashedContext())
{
db.Users.Include("ContactInfoes").Include("Educations").Include("Links").Include("Portfolios").Include("QuickReferences").FirstOrDefault(user => user.Id == userID).Links.Add(l);
db.SaveChanges();
}
}
public void addFeaturedPortfolio(int folioId)
{
using (var db = new PortfolioUnleashedContext())
{
db.FeaturedPortfolios.Add(new FeaturedPortfolio { PortfolioId = folioId });
db.SaveChanges();
}
}
public void addUser(User u)
{
using (var db = new PortfolioUnleashedContext())
{
db.Users.Add(u);
db.SaveChanges();
}
}
//public void removeProjectfromUserProjects(Project p, int userID)
//{
// using (var db = new PortfolioUnleashedContext())
// {
// }
//}
public void deleteProject(Project p, int portfolioID)
{
using (var db = new PortfolioUnleashedContext())
{
db.Portfolios.Include("User").Include("Projects").FirstOrDefault(port => port.Id == portfolioID).Projects.Remove(db.Projects.Where(pr => pr.Id == p.Id).FirstOrDefault());
db.SaveChanges();
}
}
public void addEducation(Education e, int userID)
{
using (var db = new PortfolioUnleashedContext())
{
db.Users.Include("ContactInfoes").Include("Educations").Include("Links").Include("Portfolios").Include("QuickReferences").FirstOrDefault(user => user.Id == userID).Educations.Add(e);
db.SaveChanges();
}
}
public void updatePermission(ProjectPermission p)
{
using (var db = new PortfolioUnleashedContext())
{
db.ProjectPermissions.FirstOrDefault(pp => pp.UserId == p.UserId && pp.ProjectId == pp.ProjectId).IsProjectEditor = p.IsProjectEditor;
db.SaveChanges();
}
}
public void addContribution(Contribution c, int projectID)
{
using (var db = new PortfolioUnleashedContext())
{
db.Projects.Include("Contributions").Include(p => p.Contributions.Select(co => co.ContributionMedia)).FirstOrDefault(u => u.Id == projectID).Contributions.Add(c);
db.SaveChanges();
}
}
public void removePermissionFromProject(ProjectPermission p, int projectId)
{
using (var db = new PortfolioUnleashedContext())
{
db.ProjectPermissions.Remove(db.ProjectPermissions.FirstOrDefault(pp => pp.UserId == p.UserId && pp.ProjectId == pp.ProjectId));
db.SaveChanges();
}
}
public void addContribution(Contribution c, int projectID)
{
using (var db = new PortfolioUnleashedContext())
{
db.Projects.Include("Contributions").Include(p => p.Contributions.Select(co => co.ContributionMedia)).FirstOrDefault(u => u.Id == projectID).Contributions.Add(c);
db.SaveChanges();
}
}
public void addUserSettings(UserSetting n)
{
using (var db = new PortfolioUnleashedContext())
{
db.Users.FirstOrDefault(user => user.Id == n.UserId).UserSetting = n;
db.SaveChanges();
}
}
public void removePortfolioProjects(int portfolioID)
{
using (var db = new PortfolioUnleashedContext())
{
db.Portfolios.Include("User").Include("Projects").FirstOrDefault(port => port.Id == portfolioID).Projects.Clear();
db.SaveChanges();
}
}
public void addPermissionToProject(ProjectPermission p, int projectId)
{
using (var db = new PortfolioUnleashedContext())
{
p.ProjectId = projectId;
db.ProjectPermissions.Add(p);
db.SaveChanges();
}
}
public void addNotification(Notification n, int userID)
{
using (var db = new PortfolioUnleashedContext())
{
db.Users.Include("Notifications").FirstOrDefault(user => user.Id == userID).Notifications.Add(n);
db.SaveChanges();
}
}
public void removeQuickReference(int UserId, int QuickReferenceUserId)
{
using (var db = new PortfolioUnleashedContext())
{
db.Users.Include("QuickReferences").FirstOrDefault(u => u.Id == UserId).QuickReferences.Remove(
db.Users.Include("QuickReferences").FirstOrDefault(u => u.Id == UserId).QuickReferences.FirstOrDefault(q => q.QuickReferenceId == QuickReferenceUserId));
db.SaveChanges();
}
}
public void addPermissionToProject(ProjectPermission p, int projectId)
{
using (var db = new PortfolioUnleashedContext())
{
p.ProjectId = projectId;
db.ProjectPermissions.Add(p);
db.SaveChanges();
}
}
public void DeleteAllUserNotifications(int userId)
{
using (var db = new PortfolioUnleashedContext())
{
var deletedNotifications = db.Notifications.Where(n => n.UserId == userId);
db.Notifications.RemoveRange(deletedNotifications);
db.SaveChanges();
}
}
public void deleteNotification(int requestOwnerId, int requestSenderId)
{
using (var db = new PortfolioUnleashedContext())
{
var deletedNotifications = db.Notifications.Where(n => n.UserId == requestOwnerId && n.SenderId == requestSenderId);
db.Notifications.RemoveRange(deletedNotifications);
db.SaveChanges();
}
}
public void deleteNotification(int notificationId)
{
using (var db = new PortfolioUnleashedContext())
{
var deletedNotifications = db.Notifications.Where(n => n.Id == notificationId);
db.Notifications.RemoveRange(deletedNotifications);
db.SaveChanges();
}
}
public void addNotification(Notification n, int userID)
{
using (var db = new PortfolioUnleashedContext())
{
db.Users.Include("Notifications").FirstOrDefault(user => user.Id == userID).Notifications.Add(n);
db.SaveChanges();
}
}
public UserSetting retrieveUserSettings(int userId)
{
using (var db = new PortfolioUnleashedContext())
{
//var testy = db.UserSettings.Include("User").FirstOrDefault(set => set.UserId == userId);
var test2 = db.UserSettings.FirstOrDefault(set => set.UserId == userId);
return(test2);
}
}
public void addProjectMedium(ProjectMedium m, int projectId)
{
using (var db = new PortfolioUnleashedContext())
{
m.ProjectId = projectId;//in case they didn't set this (not auto set by db)
db.Projects.Include("ProjectMedia").Where(p => p.Id == projectId).FirstOrDefault().ProjectMedia.Add(m);
db.SaveChanges();
}
}
public void addContributionMedium(ContributionMedium m, int userId, int projectId)
{
using (var db = new PortfolioUnleashedContext())
{
m.UserId = userId;//in case they didn't set this (not auto set by db)
m.ProjectId = projectId;//in case they didn't set this (not auto set by db)
db.Contributions.Include("ContributionMedia").Include("Project").Include("User").FirstOrDefault(c => c.UserId == userId && c.ProjectId == projectId).ContributionMedia.Add(m);
db.SaveChanges();
}
}
public List <Notification> retrieveAllNotifications()
{
List <Notification> result = new List <Notification>();
using (var db = new PortfolioUnleashedContext())
{
result = db.Notifications.Include("User").ToList();
}
return(result);
}
public List<QuickReference> retrieveQuickReferences(int userId)
{
List<QuickReference> result;
using (var db = new PortfolioUnleashedContext())
{
result = db.Users.Include("QuickReferences").FirstOrDefault(u => u.Id == userId).QuickReferences.ToList();
}
return result;
}
public User retrieveUserByEmail(string email)
{
User theUser;
using (var db = new PortfolioUnleashedContext())
{
theUser = db.Users.Include("ContactInfoes").Include("Educations").Include("Links").Include("Portfolios").Include("QuickReferences").Include("UserSetting").FirstOrDefault(user => user.Email == email);
}
return theUser;
}
public User retrieveUser(int userID)
{
User theUser;
using (var db = new PortfolioUnleashedContext())
{
theUser = db.Users.Include("ContactInfoes").Include("Educations").Include("Links").Include("Portfolios").Include("UserSetting").Include(u => u.Portfolios.Select(p => p.Projects)).Include(u => u.Portfolios.Select(p => p.Projects.Select(pr => pr.ProjectMedia))).Include("QuickReferences").Include("Notifications").FirstOrDefault(user => user.Id == userID);
}
return theUser;
}
public Education retrieveEducation(int educationID)
{
using (var db = new PortfolioUnleashedContext())
{
return db.Educations.Include("User").FirstOrDefault(cont => cont.Id == educationID);
}
}
public void updateUserSettings(UserSetting n, int userID)
{
using (var db = new PortfolioUnleashedContext())
{
db.UserSettings.FirstOrDefault(set => set.UserId == userID).IsEmailedForAdminMessage = n.IsEmailedForAdminMessage;
db.UserSettings.FirstOrDefault(set => set.UserId == userID).IsEmailedForCollaborationAddition = n.IsEmailedForCollaborationAddition;
db.UserSettings.FirstOrDefault(set => set.UserId == userID).IsEmailedForCollaborationRemoval = n.IsEmailedForCollaborationRemoval;
db.UserSettings.FirstOrDefault(set => set.UserId == userID).IsEmailedForCollaborationRequest = n.IsEmailedForCollaborationRequest;
db.UserSettings.FirstOrDefault(set => set.UserId == userID).IsEmailedForViewReport = n.IsEmailedForViewReport;
db.UserSettings.FirstOrDefault(set => set.UserId == userID).IsPublic = n.IsPublic;
db.SaveChanges();
}
}
public Portfolio retrievePortfolio(int portfolioID)
{
using (var db = new PortfolioUnleashedContext())
{
return db.Portfolios.Include("User").Include("Projects")
.Include(port => port.Projects.Select(proj => proj.ProjectMedia))
.Include(port => port.Projects.Select(proj => proj.Contributions))
.Include(port => port.Projects.Select(proj => proj.Contributions.Select(c => c.ContributionMedia)))
.FirstOrDefault(port => port.Id == portfolioID);
}
}
public Link retrieveLink(int linkID)
{
using (var db = new PortfolioUnleashedContext())
{
return db.Links.Include("User").FirstOrDefault(link => link.Id == linkID);
}
}
public void updateNotification(Notification n, int userID)
{
using (var db = new PortfolioUnleashedContext())
{
if (n.Description != null) db.Notifications.FirstOrDefault(notif => notif.Id == n.Id).Description = n.Description;
if (n.TimeStamp != null) db.Notifications.FirstOrDefault(notif => notif.Id == n.Id).TimeStamp = n.TimeStamp;
if (n.Title != null) db.Notifications.FirstOrDefault(notif => notif.Id == n.Id).Title = n.Title;
db.SaveChanges();
}
}
public void updateLink(Link l, int userID)
{
using (var db = new PortfolioUnleashedContext())
{
if (l.DisplayText != null) db.Users.Include("Links").FirstOrDefault(u => u.Id == userID).Links.FirstOrDefault(link => link.Id == l.Id).DisplayText = l.DisplayText;
if (l.URL != null) db.Users.Include("Links").FirstOrDefault(u => u.Id == userID).Links.FirstOrDefault(link => link.Id == l.Id).URL = l.URL;
db.SaveChanges();
}
}
public void updatePortfolio(Portfolio p, int userID)
{
using (var db = new PortfolioUnleashedContext())
{
if (p.Title != null) db.Users.Include("Portfolios").FirstOrDefault(user => user.Id == userID).Portfolios.FirstOrDefault(port => port.Id == p.Id).Title = p.Title;
if (p.URL != null) db.Users.Include("Portfolios").FirstOrDefault(user => user.Id == userID).Portfolios.FirstOrDefault(port => port.Id == p.Id).URL = p.URL;
if (p.Description != null) db.Users.Include("Portfolios").FirstOrDefault(user => user.Id == userID).Portfolios.FirstOrDefault(port => port.Id == p.Id).Description = p.Description;
if (p.Visibility != db.Users.Include("Portfolios").FirstOrDefault(user => user.Id == userID).Portfolios.FirstOrDefault(port => port.Id == p.Id).Visibility) db.Users.Include("Portfolios").FirstOrDefault(user => user.Id == userID).Portfolios.FirstOrDefault(port => port.Id == p.Id).Visibility = p.Visibility;
if (p.IsMainPortfolio != db.Users.Include("Portfolios").FirstOrDefault(user => user.Id == userID).Portfolios.FirstOrDefault(port => port.Id == p.Id).IsMainPortfolio) db.Users.Include("Portfolios").FirstOrDefault(user => user.Id == userID).Portfolios.FirstOrDefault(port => port.Id == p.Id).IsMainPortfolio = p.IsMainPortfolio;
db.SaveChanges();
}
}
public void updatePermission(ProjectPermission p)
{
using (var db = new PortfolioUnleashedContext())
{
db.ProjectPermissions.FirstOrDefault(pp => pp.UserId == p.UserId && pp.ProjectId == pp.ProjectId).IsProjectEditor = p.IsProjectEditor;
db.ProjectPermissions.FirstOrDefault(pp => pp.UserId == p.UserId && pp.ProjectId == pp.ProjectId).IsProjectMaster = p.IsProjectMaster;
db.SaveChanges();
}
}
public void updateProject(Project p)
{
using (var db = new PortfolioUnleashedContext())
{
if (p.Title != null) db.Projects.FirstOrDefault(proj => proj.Id == p.Id).Title = p.Title;
if (p.Description != null) db.Projects.FirstOrDefault(proj => proj.Id == p.Id).Description = p.Description;
if (p.Template != db.Projects.FirstOrDefault(proj => proj.Id == p.Id).Template) db.Projects.FirstOrDefault(proj => proj.Id == p.Id).Template = p.Template;
if (p.CollaborationSetting != db.Projects.FirstOrDefault(proj => proj.Id == p.Id).CollaborationSetting) db.Projects.FirstOrDefault(proj => proj.Id == p.Id).CollaborationSetting = p.CollaborationSetting;
db.SaveChanges();
}
}
public void updateProjectMedium(ProjectMedium m)
{
using (var db = new PortfolioUnleashedContext())
{
if (m.Link != null) db.ProjectMediums.FirstOrDefault(med => med.Id == m.Id).Link = m.Link;
if (m.MediumType != db.ProjectMediums.FirstOrDefault(med => med.Id == m.Id).MediumType) db.ProjectMediums.FirstOrDefault(med => med.Id == m.Id).MediumType = m.MediumType;
if (m.Caption != null) db.ProjectMediums.FirstOrDefault(med => med.Id == m.Id).Caption = m.Caption;
db.SaveChanges();
}
}
public void updateUser(User u)
{
using (var db = new PortfolioUnleashedContext())
{
if (u.FirstName != null) db.Users.Include("ContactInfoes").Include("Educations").Include("Links").Include("Portfolios").Include("QuickReferences").Include("UserSetting").FirstOrDefault(user => user.Id == u.Id).FirstName = u.FirstName;
if (u.LastName != null) db.Users.Include("ContactInfoes").Include("Educations").Include("Links").Include("Portfolios").Include("QuickReferences").Include("UserSetting").FirstOrDefault(user => user.Id == u.Id).LastName = u.LastName;
if (u.Email != null) db.Users.Include("ContactInfoes").Include("Educations").Include("Links").Include("Portfolios").Include("QuickReferences").Include("UserSetting").FirstOrDefault(user => user.Id == u.Id).Email = u.Email;
db.SaveChanges();
}
}
public ProjectMedium retrieveProjectMedium(int mediumID)
{
using (var db = new PortfolioUnleashedContext())
{
return db.ProjectMediums.FirstOrDefault(med => med.Id == mediumID);
}
}
public void updateEducation(Education e, int userID)
{
using (var db = new PortfolioUnleashedContext())
{
if (e.School != null) db.Users.Include("Educations").FirstOrDefault(u => u.Id == userID).Educations.FirstOrDefault(edu => edu.Id == e.Id).School = e.School;
if (e.Degree != null) db.Users.Include("Educations").FirstOrDefault(u => u.Id == userID).Educations.FirstOrDefault(edu => edu.Id == e.Id).Degree = e.Degree;
if (e.StartYear != null) db.Users.Include("Educations").FirstOrDefault(u => u.Id == userID).Educations.FirstOrDefault(edu => edu.Id == e.Id).StartYear = e.StartYear;
if (e.EndYear != null) db.Users.Include("Educations").FirstOrDefault(u => u.Id == userID).Educations.FirstOrDefault(edu => edu.Id == e.Id).EndYear = e.EndYear;
db.SaveChanges();
}
}
public Project retrieveProject(int projectID)
{
using (var db = new PortfolioUnleashedContext())
{
return db.Projects.Include("Contributions").Include(p => p.Contributions.Select(c => c.ContributionMedia)).Include(p => p.Contributions.Select(c => c.User)).Include("ProjectMedia").Include("Portfolios").Include("ProjectPermissions").FirstOrDefault(proj => proj.Id == projectID);
}
}
public void updateContribution(Contribution c, int projectID)
{
using (var db = new PortfolioUnleashedContext())
{
if (c.Title != null) db.Projects.Include("Contributions").FirstOrDefault(u => u.Id == projectID).Contributions.FirstOrDefault(cont => cont.UserId == c.UserId && cont.ProjectId == c.ProjectId).Title = c.Title;
if (c.Description != null) db.Projects.Include("Contributions").FirstOrDefault(u => u.Id == projectID).Contributions.FirstOrDefault(cont => cont.UserId == c.UserId && cont.ProjectId == c.ProjectId).Description = c.Description;
db.SaveChanges();
}
}
public Notification retrieveNotification(int notificationID)
{
using (var db = new PortfolioUnleashedContext())
{
return db.Notifications.Include("User").FirstOrDefault(noti => noti.Id == notificationID);
}
}
public void updateContactInfo(ContactInfo c)
{
using (var db = new PortfolioUnleashedContext())
{
//if (c.UserId != retrieveUser(userID).ContactInfoes.FirstOrDefault(cont => cont.Id == c.Id).UserId) retrieveUser(userID).ContactInfoes.FirstOrDefault(cont => cont.Id == c.Id).UserId = c.UserId;
if (c.Title != null) db.ContactInfoes.FirstOrDefault(cont => cont.Id == c.Id).Title = c.Title;
if (c.Information != null) db.ContactInfoes.FirstOrDefault(cont => cont.Id == c.Id).Information = c.Information;
db.SaveChanges();
}
}
public List<Portfolio> retrieveFeaturedPortfolios()
{
List<Portfolio> result = new List<Portfolio>();
using (var db = new PortfolioUnleashedContext())
{
result = db.Portfolios.Include("User").Include("Projects").Where(p => db.FeaturedPortfolios.Contains(db.FeaturedPortfolios.FirstOrDefault(f => f.PortfolioId == p.Id))).ToList();
}
return result;
}
public UserSetting retrieveUserSettings(int userId)
{
using (var db = new PortfolioUnleashedContext())
{
//var testy = db.UserSettings.Include("User").FirstOrDefault(set => set.UserId == userId);
var test2 = db.UserSettings.FirstOrDefault(set => set.UserId == userId);
return test2;
}
}
public void addPortfolio(Portfolio p, int userID)
{
using (var db = new PortfolioUnleashedContext())
{
p.Projects.Clear();
p.UserId = userID;
p.User = null;
p.Id = 0;
db.Portfolios.Add(p);
db.SaveChanges();
}
}
public void updateUserViewsData(User newUserData)
{
using (var db = new PortfolioUnleashedContext())
{
if (newUserData != null && newUserData.Id > 0 && db.Users.FirstOrDefault(u => u.Id == newUserData.Id) != null)
{
db.Users.FirstOrDefault(u => u.Id == newUserData.Id).LastDailyReportSendTime = newUserData.LastDailyReportSendTime;
db.Users.FirstOrDefault(u => u.Id == newUserData.Id).ViewsSinceLastReport = newUserData.ViewsSinceLastReport;
db.Users.FirstOrDefault(u => u.Id == newUserData.Id).TotalViews = newUserData.TotalViews;
db.SaveChanges();
}
}
}
