public void Activate(Projects project)
{
Projects dbEntry = context.Projects.Find(project.Id);
if (dbEntry != null)
{
dbEntry.Active = "Aktywny";
}
context.SaveChanges();
}
public ActionResult Create([Bind(Include = "ProjectId,ProjectName,ProjectDescription,ProjectScreenshot,ProjectGitHub")] Project project)
{
if (ModelState.IsValid)
{
db.Projects.Add(project);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(project));
}
public int ClearForgottenPasswordsByUser(tblUser user)
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
var links = (from link in dc.tblForgotPasswords
join u in dc.tblUsers on link.UserId equals u.Id
where link.UserId == user.Id
select new
{
link.Id,
link.UserId,
link.ExpirationDate
}).ToList();
foreach (var link in links)
{
tblForgotPassword forgottenpass = dc.tblForgotPasswords.Where(p => p.Id == link.Id).FirstOrDefault();
forgottenpass.Id = link.Id;
forgottenpass.ExpirationDate = link.ExpirationDate;
forgottenpass.UserId = link.UserId;
dc.tblForgotPasswords.Remove(forgottenpass);
}
return(dc.SaveChanges());
}
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Create a user
tblUser user = new tblUser
{
//User a GUID for testing purposes
Id = Guid.Parse("11112222-3333-4444-5555-666677778888"),
Email = "*****@*****.**",
Password = "******",
FirstName = "Test",
LastName = "Test",
ProfileImage = "Test.Test",
UserTypeId = Guid.NewGuid()
};
//Add the user to the database
dc.tblUsers.Add(user);
//Commit changes
int rowsInserted = dc.SaveChanges();
Assert.IsTrue(rowsInserted == 1);
}
}
public int Update()
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblPortfolio portfolio = dc.tblPortfolios.Where(p => p.Id == Id).FirstOrDefault();
if (portfolio != null)
{
portfolio.Name = Name;
portfolio.Description = Description;
portfolio.PrivacyId = PrivacyId;
portfolio.PortfolioImage = PortfolioImage;
portfolio.UserId = UserId;
return(dc.SaveChanges());
}
else
{
throw new Exception("Portfolio not found");
}
}
}
catch (Exception ex) { throw ex; }
}
/// <summary>
/// Insert project into portfolio
/// </summary>
/// <param name="projectId"> Id of Project to add to Portfolio object </param>
/// <returns> bool for success status </returns>
public bool AddProject(Guid projectId)
{
try
{
Project project = new Project();
project.LoadById(projectId);
Portfolio port = new Portfolio();
ProjectList prjs = new ProjectList();
prjs = port.LoadProjects(port.Id);
foreach (Project prj in prjs)
{
if (prj.Name == project.Name)
{
// Already exists in Portfolio
return(false); //this should probably be a throw ex
}
}
using (PortfolioEntities dc = new PortfolioEntities())
{
tblPortfolio portfolio = dc.tblPortfolios.Where(p => p.Id == Id).FirstOrDefault();
tblPortfolioProject portProj = new tblPortfolioProject()
{
Id = Guid.NewGuid(),
ProjectId = projectId,
PortfolioId = portfolio.Id
};
dc.tblPortfolioProjects.Add(portProj);
dc.SaveChanges();
}
return(true);
}
catch (Exception ex) { throw ex; }
}
//------------------- END CONSTRUCTORS ---------------------
#endregion Constructors
#region User Password
//------------------- START PASSWORD METHODS ---------------------
// Update Password
public int UpdatePassword(string password, string oldpassword, Guid userId)
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblUser user = dc.tblUsers.Where(u => u.Id == Id).FirstOrDefault();
if (user != null)
{
if (user.Password == GetHash(oldpassword, user.Id))
{
user.Password = GetHash(password, user.Id);
return(dc.SaveChanges());
}
else
{
throw new Exception("Incorrect Password");
}
}
else
{
throw new Exception("User not found");
}
}
}
catch (Exception ex) { throw ex; }
}
// Change Password from Forgot password key
public int ChangeForgottenPassword(string password)
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblForgotPassword forgottenpass = dc.tblForgotPasswords.Where(u => u.UserId == Id).FirstOrDefault();
if ((DateTime.Now) < (forgottenpass.ExpirationDate))
{
// Current time is earlier than expiration date of reset link
tblUser user = dc.tblUsers.Where(u => u.Id == Id).FirstOrDefault();
if (user != null)
{
// User exists
user.Password = GetHash(password, user.Id);
return(dc.SaveChanges());
}
else
{
throw new Exception("User not found");
}
}
else
{
throw new Exception("Password Reset Link Expired");
}
}
}
catch (Exception ex) { throw ex; }
}
//------------------- START STANDARD INSERT UPDATE DELETE METHODS ---------------------
// Standard Insert Method
public int Insert()
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
Guid userId = Guid.NewGuid();
tblUser user = new tblUser()
{
Id = userId,
Email = Email,
Password = GetHash(this.Password, userId),
FirstName = FirstName,
LastName = LastName,
ProfileImage = ProfileImage,
UserTypeId = UserTypeId,
Username = Username,
Bio = Bio
};
//Save the Id
this.Id = user.Id;
dc.tblUsers.Add(user);
return(dc.SaveChanges());
}
}
catch (Exception ex) { throw ex; }
}
public int Delete()
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblProject project = dc.tblProjects.Where(p => p.Id == Id).FirstOrDefault();
if (project != null)
{
ProjectLanguageList pll = new ProjectLanguageList();
pll.LoadByProjectId(project.Id);
foreach (ProjectLanguage pl in pll)
{
pl.Delete();
}
dc.tblProjects.Remove(project);
return(dc.SaveChanges());
}
else
{
throw new Exception("Project not found");
}
}
}
catch (Exception ex) { throw ex; }
}
// Standard Update Method
public int Update()
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
// Password is done in seperate Passwordupdate Method
tblUser user = dc.tblUsers.Where(u => u.Id == Id).FirstOrDefault();
if (user != null)
{
user.Email = Email;
user.FirstName = FirstName;
user.LastName = LastName;
user.ProfileImage = ProfileImage;
user.UserTypeId = UserTypeId;
user.Username = Username;
user.Bio = Bio;
return(dc.SaveChanges());
}
else
{
throw new Exception("User not found");
}
}
}
catch (Exception ex) { throw ex; }
}
// Inserts project without portfolio
public void Insert(Guid userId)
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblProject project = new tblProject()
{
Id = Guid.NewGuid(),
Name = Name,
Location = Location,
Filepath = Filepath,
PrivacyId = PrivacyId,
Image = Image,
Description = Description,
UserId = userId,
DateCreated = DateCreated,
Purpose = Purpose,
Environment = Environment,
Challenges = Challenges,
FuturePlans = FuturePlans,
Collaborators = Collaborators,
LastUpdated = LastUpdated,
SoftwareUsed = SoftwareUsed,
StatusId = StatusId
};
dc.tblProjects.Add(project);
dc.SaveChanges();
}
}
catch (Exception ex) { throw ex; }
}
public ActionResult Create(Portfolio portfolio, HttpPostedFileBase file)
{
if (file != null && file.ContentLength > 0)
{
string path = Path.Combine(Server.MapPath("../Images"),
Path.GetFileName(file.FileName));
file.SaveAs(path);
portfolio.ImagePath = Path.Combine(("../Images/"), Path.GetFileName(file.FileName));
ViewBag.Message = "File uploaded successfully";
}
if (ModelState.IsValid)
{
db.Portfolios.Add(portfolio);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(portfolio));
}
public void DeleteTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
Guid screenshotGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblScreenshot screenshot = dc.tblScreenshots.FirstOrDefault(s => s.Id == screenshotGuid);
dc.tblScreenshots.Remove(screenshot);
dc.SaveChanges();
tblScreenshot deletedScreenshot = dc.tblScreenshots.FirstOrDefault(s => s.Id == screenshotGuid);
Assert.IsNull(deletedScreenshot);
}
}
public void DeleteTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
Guid privacyGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblPrivacy privacy = dc.tblPrivacies.FirstOrDefault(u => u.Id == privacyGuid);
dc.tblPrivacies.Remove(privacy);
dc.SaveChanges();
tblPrivacy deletedPrivacy = dc.tblPrivacies.FirstOrDefault(u => u.Id == privacyGuid);
Assert.IsNull(deletedPrivacy);
}
}
public void DeleteTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
Guid statusGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblStatus status = dc.tblStatuses.FirstOrDefault(s => s.Id == statusGuid);
dc.tblStatuses.Remove(status);
dc.SaveChanges();
tblStatus deletedStatus = dc.tblStatuses.FirstOrDefault(s => s.Id == statusGuid);
Assert.IsNull(deletedStatus);
}
}
public void DeleteTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
Guid projectGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblProject project = dc.tblProjects.FirstOrDefault(p => p.Id == projectGuid);
dc.tblProjects.Remove(project);
dc.SaveChanges();
tblProject deletedProject = dc.tblProjects.FirstOrDefault(p => p.Id == projectGuid);
Assert.IsNull(deletedProject);
}
}
public void DeleteTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
Guid languageGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblLanguage language = dc.tblLanguages.FirstOrDefault(l => l.Id == languageGuid);
dc.tblLanguages.Remove(language);
dc.SaveChanges();
tblLanguage deletedLanguage = dc.tblLanguages.FirstOrDefault(l => l.Id == languageGuid);
Assert.IsNull(deletedLanguage);
}
}
public void DeleteTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
Guid userGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblUser user = dc.tblUsers.FirstOrDefault(u => u.Id == userGuid);
dc.tblUsers.Remove(user);
dc.SaveChanges();
tblUser deletedUser = dc.tblUsers.FirstOrDefault(u => u.Id == userGuid);
Assert.IsNull(deletedUser);
}
}
public void UpdateTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Retrieve test status based on ID and update it
Guid statusGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblStatus status = dc.tblStatuses.FirstOrDefault(s => s.Id == statusGuid);
status.Description = "UpdatedDescription";
//Save changes and get it back out
dc.SaveChanges();
tblStatus updatedStatus = dc.tblStatuses.FirstOrDefault(s => s.Description == "UpdatedDescription");
//Make sure the Ids match
Assert.AreEqual(status.Id, updatedStatus.Id);
}
}
public void UpdateTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Retrieve test privacy based on ID and update it
Guid privacyGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblPrivacy privacy = dc.tblPrivacies.FirstOrDefault(u => u.Id == privacyGuid);
privacy.Description = "UpdatedPrivacy";
//Save changes and get it back out
dc.SaveChanges();
tblPrivacy updatedPrivacy = dc.tblPrivacies.FirstOrDefault(u => u.Description == "UpdatedPrivacy");
//Make sure the Ids match
Assert.AreEqual(privacy.Id, updatedPrivacy.Id);
}
}
public void UpdateTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Retrieve test language based on ID and update it
Guid languageGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblLanguage language = dc.tblLanguages.FirstOrDefault(l => l.Id == languageGuid);
language.Description = "UpdatedLang";
//Save changes and get it back out
dc.SaveChanges();
tblLanguage updatedLanguage = dc.tblLanguages.FirstOrDefault(l => l.Description == "UpdatedLang");
//Make sure the Ids match
Assert.AreEqual(language.Id, updatedLanguage.Id);
}
}
public void UpdateTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Retrieve test userType based on ID and update it
Guid userTypeGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblUserType userType = dc.tblUserTypes.FirstOrDefault(u => u.Id == userTypeGuid);
userType.Description = "UpdatedUserType";
//Save changes and get it back out
dc.SaveChanges();
tblUserType updatedUserType = dc.tblUserTypes.FirstOrDefault(u => u.Description == "UpdatedUserType");
//Make sure the Ids match
Assert.AreEqual(userType.Id, updatedUserType.Id);
}
}
public void UpdateTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Retrieve test user based on ID and update it
Guid projectGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblProject project = dc.tblProjects.FirstOrDefault(p => p.Id == projectGuid);
Guid privacyGuid = Guid.Parse("88887777-6666-5555-4444-333322221111");
project.PrivacyId = privacyGuid;
//Save changes and get it back out
dc.SaveChanges();
tblProject updatedProject = dc.tblProjects.FirstOrDefault(p => p.PrivacyId == privacyGuid);
//Make sure the Ids match
Assert.AreEqual(project.Id, updatedProject.Id);
}
}
// Adds project to porfolio
public void AddToPortfolio(Guid portfolioId)
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblProject project = dc.tblProjects.Where(p => p.Id == Id).FirstOrDefault();
tblPortfolioProject portProj = new tblPortfolioProject()
{
Id = Guid.NewGuid(),
PortfolioId = portfolioId,
ProjectId = project.Id
};
dc.tblPortfolioProjects.Add(portProj);
dc.SaveChanges();
}
}
catch (Exception ex) { throw ex; }
}
public Profile SaveProfile(Profile profile)
{
Profile dbEntry = context.Profile.FirstOrDefault();
if (dbEntry != null)
{
dbEntry.Description = profile.Description;
dbEntry.Image = profile.Image;
dbEntry.Name = profile.Name;
dbEntry.Surname = profile.Surname;
}
else
{
context.Profile.Add(profile);
}
context.SaveChanges();
return(dbEntry);
}
public int Insert()
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblProjectLanguage projectlanguage = new tblProjectLanguage();
projectlanguage.Id = Guid.NewGuid();
projectlanguage.ProjectId = this.ProjectId;
projectlanguage.LanguageId = this.LanguageId;
this.Id = projectlanguage.Id;
dc.tblProjectLanguages.Add(projectlanguage);
return(dc.SaveChanges());
}
}
catch (Exception ex) { throw ex; }
}
public void UpdateTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Retrieve test user based on ID and update it
Guid userGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblUser user = dc.tblUsers.FirstOrDefault(u => u.Id == userGuid);
Guid userTypeGuid = Guid.Parse("88887777-6666-5555-4444-333322221111");
user.UserTypeId = userTypeGuid;
//Save changes and get it back out
dc.SaveChanges();
tblUser updatedUser = dc.tblUsers.FirstOrDefault(u => u.UserTypeId == userTypeGuid);
//Make sure the Ids match
Assert.AreEqual(user.Id, updatedUser.Id);
}
}
public void UpdateTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Retrieve test portfolio based on ID and update it
Guid portfolioGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblPortfolio portfolio = dc.tblPortfolios.FirstOrDefault(p => p.Id == portfolioGuid);
Guid userGuid = Guid.Parse("88887777-6666-5555-4444-333322221111");
portfolio.UserId = userGuid;
//Save changes and get it back out
dc.SaveChanges();
tblPortfolio updatedPortfolio = dc.tblPortfolios.FirstOrDefault(p => p.UserId == userGuid);
//Make sure the Ids match
Assert.AreEqual(portfolio.Id, updatedPortfolio.Id);
}
}
public void Insert(IList <string> SelectedLanguages)
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblProject project = new tblProject()
{
Id = Guid.NewGuid(),
Name = Name,
Location = Location,
Filepath = Filepath,
PrivacyId = PrivacyId,
Image = Image,
Description = Description,
UserId = UserId,
DateCreated = DateCreated,
Purpose = Purpose,
Environment = Environment,
Challenges = Challenges,
FuturePlans = FuturePlans,
Collaborators = Collaborators,
LastUpdated = LastUpdated,
SoftwareUsed = SoftwareUsed,
StatusId = StatusId
};
//Save the Id
this.Id = project.Id;
dc.tblProjects.Add(project);
dc.SaveChanges();
foreach (var pl in SelectedLanguages)
{
ProjectLanguage projlang = new ProjectLanguage();
projlang.ProjectId = project.Id;
projlang.LanguageId = (Guid.Parse(pl));
projlang.Insert();
}
}
}
catch (Exception ex) { throw ex; }
}
