public void CreateProject(Project o)
{
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var p = new ProjectsDataContext();
o.ProjectName = (o.ProjectName == "null") ? null : o.ProjectName.Substring(1, o.ProjectName.Length - 2);
o.Comment = (o.Comment == "null") ? null : o.Comment.Substring(1, o.Comment.Length - 2);
o.ProjectID = Guid.NewGuid();
p.Projects.InsertOnSubmit(o);
p.SubmitChanges();
}
}
public void UpdateProject(ProjectViewModel m)
{
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var now = DateTime.UtcNow;
var d = new ProjectsDataContext();
var p = new Project();
p.ProjectName = (m.ProjectName == "null") ? null : m.ProjectName;
p.Comment = (m.Comment == "null") ? null : m.Comment;
p.ProjectID = Guid.NewGuid();
p.VersionOwnerContactID = m.Creator;
p.VersionUpdated = now;
p.VersionUpdatedBy = m.User;
d.Projects.InsertOnSubmit(p);
var n = new ProjectPlan();
n.ProjectPlanID = Guid.NewGuid();
n.ProjectID = p.ProjectID;
n.ProjectPlanName = "Resource Modelling";
n.ResponsibleContactID = m.Creator;
n.VersionOwnerContactID = m.User;
n.VersionUpdated = now;
n.VersionUpdatedBy = m.User;
d.ProjectPlans.InsertOnSubmit(n);
var t = new ProjectPlanTask();
t.ProjectPlanTaskID = Guid.NewGuid();
t.ProjectPlanID = n.ProjectPlanID;
t.ProjectTaskName = m.StageName;
t.VersionOwnerContactID = m.Creator;
t.VersionUpdated = now;
t.VersionUpdatedBy = m.User;
d.ProjectPlanTasks.InsertOnSubmit(t);
var tr = new ProjectPlanTask();
tr.ProjectPlanTaskID = Guid.NewGuid();
tr.ProjectPlanID = n.ProjectPlanID;
tr.ProjectTaskName = "Review";
tr.VersionOwnerContactID = m.Reviewer;
tr.VersionUpdated = now.AddSeconds(-1); //This is not the current task
tr.VersionUpdatedBy = m.User;
d.ProjectPlanTasks.InsertOnSubmit(tr);
var tc = new ProjectPlanTask();
tc.ProjectPlanTaskID = Guid.NewGuid();
tc.ProjectPlanID = n.ProjectPlanID;
tc.ProjectTaskName = "Complete";
tc.VersionOwnerContactID = m.User;
tc.VersionUpdated = now.AddSeconds(-1); //This is not the current task
tc.VersionUpdatedBy = m.User;
d.ProjectPlanTasks.InsertOnSubmit(tr);
d.SubmitChanges();
}
}
public IEnumerable<Project> GetProjects() {
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var dataContext = new ProjectsDataContext();
return dataContext.Projects.ToArray();
}
}
public void EmailAllProjectOwners(string subject, string body)
{
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var d = new ProjectsDataContext();
var o = d.Projects.Where(x => x.VersionOwnerContactID != null).Select(f=>(Guid)f.VersionOwnerContactID).ToArray();
_userServices.EmailUsers(_userServices.GetUserEmails(o), subject, body);
}
}
public void DeleteProject(Guid projectID, Guid contactID)
{
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var d = new ProjectsDataContext();
var o = d.Projects.Where(x => x.ProjectID == projectID).Single();
o.VersionDeletedBy = contactID;
o.VersionUpdated = DateTime.UtcNow;
d.SubmitChanges();
}
}
public IEnumerable<ProjectPlanTask> GetStages(Guid ProjectID)
{
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var dataContext = new ProjectsDataContext();
return dataContext.ProjectPlanTasks.Where(x=>x.ProjectPlan.ProjectID == ProjectID).ToArray();
}
}