/// <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; }
}
public void DeleteTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
Guid portfolioProjectGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblPortfolioProject portfolioProject = dc.tblPortfolioProjects.FirstOrDefault(p => p.Id == portfolioProjectGuid);
dc.tblPortfolioProjects.Remove(portfolioProject);
dc.SaveChanges();
tblPortfolioProject deletedPortfolioProject = dc.tblPortfolioProjects.FirstOrDefault(p => p.Id == portfolioProjectGuid);
Assert.IsNull(deletedPortfolioProject);
}
}
public void UpdateTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Retrieve test portfolioProject based on ID and update it
Guid portfolioProjectGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblPortfolioProject portfolioProject = dc.tblPortfolioProjects.FirstOrDefault(p => p.Id == portfolioProjectGuid);
Guid projectGuid = Guid.Parse("88887777-6666-5555-4444-333322221111");
portfolioProject.ProjectId = projectGuid;
//Save changes and get it back out
dc.SaveChanges();
tblPortfolioProject updatedPortfolioProject = dc.tblPortfolioProjects.FirstOrDefault(p => p.ProjectId == projectGuid);
//Make sure the Ids match
Assert.AreEqual(portfolioProject.Id, updatedPortfolioProject.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 int Delete()
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblPortfolioProject portfolioProject = dc.tblPortfolioProjects.Where(pp => pp.Id == Id).FirstOrDefault();
if (portfolioProject != null)
{
dc.tblPortfolioProjects.Remove(portfolioProject);
return(dc.SaveChanges());
}
else
{
throw new Exception("Portfolio Project not found");
}
}
}
catch (Exception ex) { throw ex; }
}
/// <summary>
/// Delete project from portfolio by passing projectid and portfolioid
/// </summary>
/// <param name="ProjectId"> The Id of Project to Remove</param>
/// <param name="PortfolioId">The Id of Portfolio to remove Project from</param>
public void RemoveProjectByPortProj(Guid ProjectId, Guid PortfolioId)
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblPortfolioProject portProj = dc.tblPortfolioProjects.Where(pp => pp.ProjectId == ProjectId && pp.PortfolioId == PortfolioId).FirstOrDefault();
if (portProj != null)
{
dc.tblPortfolioProjects.Remove(portProj);
dc.SaveChanges();
}
else
{
throw new Exception("Project not found in portfolio");
}
}
}
catch (Exception ex) { throw ex; }
}
// Deletes project from portfolio
public void DeleteFromPortfolio(Guid portProjId)
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblPortfolioProject portProj = dc.tblPortfolioProjects.Where(pp => pp.Id == portProjId).FirstOrDefault();
if (portProj != null)
{
dc.tblPortfolioProjects.Remove(portProj);
dc.SaveChanges();
}
else
{
throw new Exception("Project not found in portfolio");
}
}
}
catch (Exception ex) { throw ex; }
}
public int Insert()
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblPortfolioProject portfolioProject = new tblPortfolioProject()
{
Id = Guid.NewGuid(),
PortfolioId = PortfolioId,
ProjectId = ProjectId
};
//Save the Id
this.Id = portfolioProject.Id;
dc.tblPortfolioProjects.Add(portfolioProject);
return(dc.SaveChanges());
}
}
catch (Exception ex) { throw ex; }
}
public void InsertTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Create a portfolioProject
tblPortfolioProject portfolioProject = new tblPortfolioProject
{
//PortfolioProject a GUID for testing purposes
Id = Guid.Parse("11112222-3333-4444-5555-666677778888"),
PortfolioId = Guid.NewGuid(),
ProjectId = Guid.NewGuid()
};
//Add the portfolioProject to the database
dc.tblPortfolioProjects.Add(portfolioProject);
//Commit changes
int rowsInserted = dc.SaveChanges();
Assert.IsTrue(rowsInserted == 1);
}
}
// Insert project with portfolio
public void Insert(Guid userId, Guid portfolioId)
{
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);
tblPortfolioProject portProj = new tblPortfolioProject()
{
Id = Guid.NewGuid(),
ProjectId = project.Id,
PortfolioId = portfolioId
};
dc.tblPortfolioProjects.Add(portProj);
dc.SaveChanges();
}
}
catch (Exception ex) { throw ex; }
}
