public ActionResult CopyProject(FormCollection formcollection)
{
DateTime extendDate = DateTime.Parse(formcollection["ExtendDate"]);
int projectid_ = int.Parse(formcollection["projectId"]);
Project myproject = db.Projects.AsNoTracking().Include(p => p.RequestIssues).Include(p => p.Locations).Include(p => p.CorporateAccounts).Include(p => p.Personnels).Where(i => i.ProjectID == projectid_).SingleOrDefault();
double extendAsDays = extendDate.Subtract(myproject.StartDate).Days;
Project newproject = new Project
{
Description = myproject.Description,
cUserID = myproject.cUserID,
EndDate = myproject.EndDate.Value.AddDays(extendAsDays),
RequestStateID = 1,
StartDate = myproject.StartDate.AddDays(extendAsDays),
TimeStamp = DateTime.Now,
UserID = myproject.UserID,
Locations = new List<Location>(),
CorporateAccounts = new List<CorporateAccount>(),
Personnels = new List<Personnel>(),
RequestIssues = new List<RequestIssue>()
};
db.Projects.Add(newproject);
db.SaveChanges();
foreach (Location loc_ in myproject.Locations.ToList())
{
newproject.Locations.Add(db.Locations.Find(loc_.LocationID));
}
foreach (CorporateAccount corp_ in myproject.CorporateAccounts.ToList())
{
newproject.CorporateAccounts.Add(db.CorporateAccounts.Find(corp_.CorporateAccountID));
}
foreach (Personnel pers_ in myproject.Personnels.ToList())
{
newproject.Personnels.Add(db.Personnels.Find(pers_.PersonnelID));
}
db.SaveChanges();
foreach (RequestIssue rq_ in myproject.RequestIssues.ToList())
{
//var copyoldnotrackrq_ = db.RequestIssues.Include(p=>p.Locations).Include(p=>p.CorporateAccounts).Include(p=>p.Personnels).Include(p=>p.Projects).Where(i=>i.RequestIssueID==rq_.RequestIssueID).SingleOrDefault();
RequestIssue newrq_ = db.RequestIssues.Include(p=>p.Locations).Include(p=>p.CorporateAccounts).Include(p=>p.Personnels).Include(p=>p.Projects).Where(i=>i.RequestIssueID==rq_.RequestIssueID).SingleOrDefault();
var _mylocations = newrq_.Locations.ToList();
var _mycorps = newrq_.CorporateAccounts.ToList();
var _mypersonnels = newrq_.Personnels.ToList();
var _myprojects = newrq_.Projects.ToList();
db.Entry(newrq_).State = EntityState.Detached;
db.Entry(newrq_).State = EntityState.Added;
db.SaveChanges();
RequestIssue myrqformanys_ = db.RequestIssues.Find(newrq_.RequestIssueID);
myrqformanys_.StartDate = myrqformanys_.StartDate.AddDays(extendAsDays);
myrqformanys_.EndDate = myrqformanys_.EndDate.Value.AddDays(extendAsDays);
foreach (var _loc in _mylocations)
{
myrqformanys_.Locations.Add(_loc);
}
foreach (var _pers in _mypersonnels)
{
myrqformanys_.Personnels.Add(_pers);
}
foreach (var _corp in _mycorps )
{
myrqformanys_.CorporateAccounts.Add(_corp);
}
myrqformanys_.Projects.Add(newproject);
/*
newrq_.StartDate.AddDays(extendAsDays);
newrq_.EndDate.Value.AddDays(extendAsDays);
newrq_.Locations = copyoldnotrackrq_.Locations;
newrq_.Personnels = copyoldnotrackrq_.Personnels;
newrq_.Projects = copyoldnotrackrq_.Projects;
newrq_.CorporateAccounts = copyoldnotrackrq_.CorporateAccounts;
*/
//db.Entry(newrq_).State = EntityState.Modified;
db.SaveChanges();
//newproject.RequestIssues.Add(db.RequestIssues.Find(newrq_.RequestIssueID));
// newproject.RequestIssues.Add(rq_);
}
return RedirectToAction("Index");
}
public ActionResult Edit(Project project, FormCollection formcollection)
{
if (ModelState.IsValid)
{
db.Entry(project).State = EntityState.Modified;
db.SaveChanges();
//locations bosalt
Project project_ = db.Projects.Include(p => p.Locations).Include(p => p.Personnels).Include(p => p.CorporateAccounts).Where(i => i.ProjectID == project.ProjectID).SingleOrDefault();
project_.Locations.Clear();
project_.Personnels.Clear();
project_.CorporateAccounts.Clear();
db.SaveChanges();
if (formcollection["LocationID"] != null)
{
foreach (var location_ in formcollection["LocationID"].Split(',').ToList())
{
try
{
int location_index = int.Parse(location_.ToString());
var x_location = db.Locations.Find(location_index);
x_location.Projects.Add(project);
}
catch
{ }
db.SaveChanges();
}
}
if (formcollection["CorporateAccountID"] != null)
{
foreach (var corp_ in formcollection["CorporateAccountID"].Split(',').ToList())
{
try
{
int corporation_index = int.Parse(corp_.ToString());
var x_corp = db.CorporateAccounts.Find(corporation_index);
x_corp.Projects.Add(project);
}
catch
{ }
db.SaveChanges();
}
}
if (formcollection["PersonnelID"] != null)
{
foreach (var pers_ in formcollection["PersonnelID"].Split(',').ToList())
{
try
{
int pers_index = int.Parse(pers_.ToString());
var x_pers = db.Personnels.Find(pers_index);
x_pers.Projects.Add(project);
}
catch
{ }
db.SaveChanges();
}
}
if (formcollection["AddNewRq"] != null)
{
return RedirectToAction("Create", "RequestIssue", new { projectid = project.ProjectID });
}
return RedirectToAction("Index");
}
ViewBag.RequestStateID = new SelectList(db.RequestStates, "RequestStateID", "Description", project.RequestStateID);
ViewBag.UserID = new SelectList(db.Users, "UserId", "FullName", project.UserID);
ViewBag.cUserID = new SelectList(db.Users, "UserId", "FullName", project.cUserID);
Project project__ = db.Projects.Include(p => p.Locations).Include(p => p.Personnels).Include(p => p.CorporateAccounts).Where(i => i.ProjectID == project.ProjectID).SingleOrDefault();
/*project.Locations = project__.Locations;
project.CorporateAccounts = project__.CorporateAccounts;
project.Personnels = project__.Personnels;
*/
ViewBag.LocationID = new MultiSelectList(db.Locations, "LocationID", "CapitalizedDescription", project__.Locations.Select(p => p.LocationID).ToList());
ViewBag.CorporateAccountID = new MultiSelectList(db.CorporateAccounts, "CorporateAccountID", "Title", project__.CorporateAccounts.Select(p => p.CorporateAccountID).ToList());
ViewBag.PersonnelID = new MultiSelectList(db.Personnels, "PersonnelID", "FullName", project__.Personnels.Select(p => p.PersonnelID).ToList());
return View(project);
}
public ActionResult Create(Project project, FormCollection formcollection)
{
MembershipUser currentuser_ = new UserRepository().GetUser(User.Identity.Name);
int user_wherecondition = int.Parse((currentuser_.ProviderUserKey).ToString());
if (ModelState.IsValid)
{
project.TimeStamp = DateTime.Now;
project.cUserID = user_wherecondition;
project.RequestStateID = 4;
db.Projects.Add(project);
db.SaveChanges();
if (formcollection["LocationID"] != null)
{
foreach (var location_ in formcollection["LocationID"].Split(',').ToList())
{
try
{
int location_index = int.Parse(location_.ToString());
var x_location = db.Locations.Find(location_index);
x_location.Projects.Add(project);
}
catch
{ }
db.SaveChanges();
}
}
if (formcollection["CorporateAccountID"] != null)
{
foreach (var corp_ in formcollection["CorporateAccountID"].Split(',').ToList())
{
try
{
int corp_index = int.Parse(corp_.ToString());
var x_corp = db.CorporateAccounts.Find(corp_index);
x_corp.Projects.Add(project);
}
catch
{ }
db.SaveChanges();
}
}
if (formcollection["PersonnelID"] != null)
{
foreach (var pers_ in formcollection["PersonnelID"].Split(',').ToList())
{
try
{
int pers_index = int.Parse(pers_.ToString());
var x_pers = db.Personnels.Find(pers_index);
x_pers.Projects.Add(project);
}
catch
{ }
db.SaveChanges();
}
}
return RedirectToAction("Index");
}
ViewBag.RequestStateID = new SelectList(db.RequestStates, "RequestStateID", "Description", project.RequestStateID);
ViewBag.UserID = new SelectList(db.Users, "UserId", "FullName", project.UserID);
ViewBag.cUserID = new SelectList(db.Users, "UserId", "UserName", project.cUserID);
if (formcollection["LocationID"] != null)
{
ViewBag.LocationID = new MultiSelectList(db.Locations, "LocationID", "CapitalizedDescription", formcollection["LocationID"].Split(',').ToList());
}
else
{
ViewBag.LocationID = new MultiSelectList(db.Locations, "LocationID", "Description");
}
if (formcollection["CorporateAccountID"] != null)
{
ViewBag.CorporateAccountID = new MultiSelectList(db.CorporateAccounts, "CorporateAccountID", "Title", formcollection["CorporateAccountID"].Split(',').ToList());
}
else
{
ViewBag.CorporateAccountID = new MultiSelectList(db.CorporateAccounts, "CorporateAccountID", "Title");
}
if (formcollection["PersonnelID"] != null)
{
ViewBag.PersonnelID = new MultiSelectList(db.Personnels, "PersonnelID", "FullName", formcollection["PersonnelID"].Split(',').ToList());
}
else
{
ViewBag.PersonnelID = new MultiSelectList(db.Personnels, "PersonnelID", "FullName");
}
return View(project);
}
