public ActionResult CostDown(int id)
{
//get the data
var item = db.project_cost.FirstOrDefault(x => x.CostID == id);
var items = db.project_cost.Where(x => x.ProjectID == item.ProjectID).OrderByDescending("Order");
project_cost otheritem = null;
foreach (var updateContent in items)
{
if (updateContent.CostID == id)
{
break;
}
otheritem = updateContent;
}
if (otheritem != null)
{
int oldorder = item.Order;
item.Order = otheritem.Order;
otheritem.Order = oldorder;
db.SaveChanges();
}
return(RedirectToAction("Edit", "Projects", new { id = item.ProjectID }, "costs"));
}
public ActionResult Delete(int id, int projectid)
{
project_cost project_cost = db.project_cost.Single(p => p.CostID == id);
ViewBag.Project = db.projects.FirstOrDefault(x => x.ProjectID == project_cost.ProjectID);
return(View(project_cost));
}
public ActionResult Create(project_cost project_cost)
{
if (ModelState.IsValid)
{
if (db.project_cost.Any(x => x.ProjectID == project_cost.ProjectID))
{
int order = db.project_cost.Where(x => x.ProjectID == project_cost.ProjectID).Max(x => x.Order);
order = order + 1;
project_cost.Order = order;
}
else
{
project_cost.Order = 20;
}
project_cost.Date = DateTime.Now;
db.project_cost.AddObject(project_cost);
db.SaveChanges();
return(RedirectToAction("Edit", "Projects", new { id = project_cost.ProjectID }, "costs"));
}
ViewBag.ProjectID = new SelectList(db.projects, "ProjectID", "Title", project_cost.ProjectID);
ViewBag.Project = db.projects.FirstOrDefault(x => x.ProjectID == project_cost.ProjectID);
return(View(project_cost));
}
public ActionResult Edit(int id)
{
project_cost project_cost = db.project_cost.Single(p => p.CostID == id);
ViewBag.ProjectID = new SelectList(db.projects, "ProjectID", "Title", project_cost.ProjectID);
ViewBag.Project = db.projects.FirstOrDefault(x => x.ProjectID == project_cost.ProjectID);
return(View(project_cost));
}
public ActionResult Edit(project_cost project_cost)
{
if (ModelState.IsValid)
{
project_cost.Date = DateTime.Now;
db.project_cost.Attach(project_cost);
db.ObjectStateManager.ChangeObjectState(project_cost, EntityState.Modified);
db.SaveChanges();
return(RedirectToAction("Edit", "Projects", new { id = project_cost.ProjectID }, "costs"));
}
ViewBag.ProjectID = new SelectList(db.projects, "ProjectID", "Title", project_cost.ProjectID);
ViewBag.Project = db.projects.FirstOrDefault(x => x.ProjectID == project_cost.ProjectID);
return(View(project_cost));
}
public ActionResult DeleteConfirmed(int id, int projectid)
{
project_cost project_cost = db.project_cost.Single(p => p.CostID == id);
db.project_cost.DeleteObject(project_cost);
db.SaveChanges();
//comes from project
if (projectid > 0)
{
return(RedirectToAction("Edit", "Projects", new { id = projectid }, "costs"));
}
return(RedirectToAction("Edit", "Projects", new { id = project_cost.ProjectID }, "costs"));
}
public ActionResult Delete(int id, int projectid)
{
project_cost project_cost = db.project_cost.Single(p => p.CostID == id);
var project = db.projects.FirstOrDefault(x => x.ProjectID == project_cost.ProjectID && x.UserID == CurrentUser.UserID);
if (project == null)
{
return(RedirectToAction("Index", "Home"));
}
db.project_cost.DeleteObject(project_cost);
db.SaveChanges();
return(RedirectToAction("Edit", "Projects", new { id = project_cost.ProjectID }, "costs"));
}
