//
// GET: /Tasks/Create
public ActionResult Create(int id, System.Nullable<int> devId)
{
var db = new BurnDown.Models.DB();
var developers = db.developers;
IList<SelectListItem> devList = new List<SelectListItem>();
foreach (BurnDown.Models.developer dev in developers)
{
SelectListItem DevItem = new SelectListItem();
DevItem.Text = dev.firstName + " " + dev.lastName;
DevItem.Value = dev.developerId.ToString();
devList.Add(DevItem);
if (devId == dev.developerId) DevItem.Selected = true;
DevItem = null;
}
ViewData["ddList"] = devList;
var projects = db.projects;
IList<SelectListItem> projList = new List<SelectListItem>();
foreach (BurnDown.Models.project proj in projects)
{
SelectListItem ProjItem = new SelectListItem();
ProjItem.Text = proj.projectName;
ProjItem.Value = proj.projectId.ToString();
projList.Add(ProjItem);
if (id == proj.projectId) ProjItem.Selected = true;
ProjItem = null;
}
ViewData["projDDList"] = projList;
return View();
}
public ActionResult Create(FormCollection collection)
{
//try
//{
// TODO: Add insert logic here
var newTask = new BurnDown.Models.task();
newTask.priority = int.Parse(collection["priority"]);
newTask.taskName = collection["taskName"];
newTask.developer_developerId = int.Parse(collection["ddList"]);
// newTask.hoursSpentOnTask = int.Parse(collection["hoursSpentOnTask"]);
newTask.originalEstimatedHours = int.Parse(collection["originalEstimatedHours"]);
//newTask.percentCompleted = int.Parse(collection["percentCompleted"]);
newTask.project_projectId = int.Parse(collection["projDDList"]);
// newTask.shareOfProject = int.Parse(collection["shareOfProject"]);
newTask.hoursForTasksWithHigherPriority = int.Parse(collection["hoursForTasksWithHigherPriority"] + "0");
newTask.startDate = DateTime.Parse(collection["startDate"]);
newTask.dueDate = DateTime.Parse(collection["dueDate"]);
var db = new BurnDown.Models.DB();
var Tasks = db.tasks;
Tasks.AddObject(newTask);
db.SaveChanges();
return RedirectToAction("Index");
//}
//catch
//{
// var db = new BurnDown.Models.DB();
// var developers = db.developers;
// IList<SelectListItem> devList = new List<SelectListItem>();
// foreach (BurnDown.Models.developer dev in developers)
// {
// SelectListItem DevItem = new SelectListItem();
// DevItem.Text = dev.firstName + " " + dev.lastName;
// DevItem.Value = dev.developerId.ToString();
// devList.Add(DevItem);
// DevItem = null;
// }
// ViewData["ddList"] = devList;
// var projects = db.projects;
// IList<SelectListItem> projList = new List<SelectListItem>();
// foreach (BurnDown.Models.project proj in projects)
// {
// SelectListItem ProjItem = new SelectListItem();
// ProjItem.Text = proj.projectName;
// ProjItem.Value = proj.projectId.ToString();
// projList.Add(ProjItem);
// ProjItem = null;
// }
// ViewData["projDDList"] = projList;
// return View();
//}
}
//
// GET: /Projects/Create
public ActionResult Create()
{
var db = new BurnDown.Models.DB();
var developers = db.developers;
IList<SelectListItem> devList = new List<SelectListItem>();
foreach (BurnDown.Models.developer dev in developers)
{
SelectListItem DevItem = new SelectListItem();
DevItem.Text = dev.firstName + " " + dev.lastName;
DevItem.Value = dev.developerId.ToString();
devList.Add(DevItem);
DevItem = null;
}
ViewData["ddList"] = devList;
return View();
}
public ActionResult Create(FormCollection collection)
{
try
{
// TODO: Add insert logic here
var newProject = new BurnDown.Models.project();
newProject.priority = int.Parse(collection["priority"]);
newProject.projectName = collection["projectName"];
newProject.leadDeveloper = int.Parse(collection["ddList"]);
var db = new BurnDown.Models.DB();
var projects = db.projects;
projects.AddObject(newProject);
db.SaveChanges();
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public ActionResult UpdateAgendaItem(FormCollection pST)
{
var db = new BurnDown.Models.DB();
var agendaItem =
(from st in db.agendaItems
where st.agendaItemId == int.Parse(pST["agendaItemId"])
select st).SingleOrDefault();
agendaItem.agendaItemName = pST["agendaItemName"];
agendaItem.completed = Boolean.Parse(pST["completed"].Split(new char[] {','})[0]);
db.SaveChanges();
var allPtagendaItems =
from aptst in db.agendaItems
where aptst.task_taskId == int.Parse(pST["task_taskId"])
select aptst;
var completedPtagendaItems =
from aptst in db.agendaItems
where aptst.task_taskId == int.Parse(pST["task_taskId"]) && aptst.completed == true
select aptst;
double a = completedPtagendaItems.Count();
double b = allPtagendaItems.Count();
double percentageCompleted = (double)(a / b ) * 100;
BurnDown.Models.task paretnTask =
(from pt in db.tasks
where pt.taskId == int.Parse(pST["task_taskId"])
select pt).SingleOrDefault();
paretnTask.percentCompleted = (int)Math.Round(percentageCompleted, 0);
db.SaveChanges();
ViewBag.parentId = int.Parse(pST["task_taskId"]);
return RedirectToAction("Details", new { id = int.Parse(pST["task_taskId"]) });
}
//
// GET: /Tasks/
public ActionResult Index()
{
var db = new BurnDown.Models.DB();
var tasks = db.tasks;
return View(tasks);
}
public ActionResult GetagendaItems(int id)
{
var db = new BurnDown.Models.DB();
var agendaItems =
from st in db.agendaItems
where st.task_taskId == id
select st;
ViewBag.parentId = id;
return PartialView(agendaItems);
}
public ActionResult Edit(int id, FormCollection collection)
{
var db = new BurnDown.Models.DB();
var tasks = db.tasks;
var task = tasks
.Where(w => w.taskId == id)
.SingleOrDefault();
task.developer_developerId = int.Parse(collection["developer_developerId"]);
task.dueDate = DateTime.Parse(collection["dueDate"]);
task.hoursSpentOnTask= int.Parse(collection["hoursSpentOnTask"]);
task.originalEstimatedHours= int.Parse(collection["originalEstimatedHours"]);
task.percentCompleted= int.Parse(collection["percentCompleted"]);
task.priority = int.Parse(collection["priority"]);
task.shareOfProject = int.Parse(collection["shareOfProject"]);
task.project_projectId = int.Parse(collection["project"]);
task.startDate = DateTime.Parse(collection["startDate"]);
task.taskName = collection["taskName"];
db.SaveChanges();
// TODO: Add insert logic here
return RedirectToAction("Details", new { controller = "Projects", id = collection["project"] });
// try
// { }
//catch
//{
// var db = new BurnDown.Models.DB();
// var developers = db.developers;
// IList<SelectListItem> devList = new List<SelectListItem>();
// foreach (BurnDown.Models.developer dev in developers)
// {
// SelectListItem DevItem = new SelectListItem();
// DevItem.Text = dev.firstName + " " + dev.lastName;
// DevItem.Value = dev.developerId.ToString();
// devList.Add(DevItem);
// DevItem = null;
// }
// ViewData["developer_developerId"] = devList;
// var projects = db.projects;
// IList<SelectListItem> projList = new List<SelectListItem>();
// foreach (BurnDown.Models.project proj in projects)
// {
// SelectListItem ProjItem = new SelectListItem();
// ProjItem.Text = proj.projectName;
// ProjItem.Value = proj.projectId.ToString();
// projList.Add(ProjItem);
// ProjItem = null;
// }
// ViewData["project"] = projList;
// var tasks = db.tasks;
// var task =
// from t in tasks
// where t.taskId == id
// select t;
// return View(task.FirstOrDefault());
//}
}
//
// GET: /Tasks/Edit/5
public ActionResult Edit(int id)
{
var db = new BurnDown.Models.DB();
var developers = db.developers;
IList<SelectListItem> devList = new List<SelectListItem>();
foreach (BurnDown.Models.developer dev in developers)
{
SelectListItem DevItem = new SelectListItem();
DevItem.Text = dev.firstName + " " + dev.lastName;
DevItem.Value = dev.developerId.ToString();
devList.Add(DevItem);
DevItem = null;
}
ViewData["developer_developerId"] = devList;
var projects = db.projects;
IList<SelectListItem> projList = new List<SelectListItem>();
foreach (BurnDown.Models.project proj in projects)
{
SelectListItem ProjItem = new SelectListItem();
ProjItem.Text = proj.projectName;
ProjItem.Value = proj.projectId.ToString();
projList.Add(ProjItem);
ProjItem = null;
}
ViewData["project"] = projList;
var tasks = db.tasks;
var task =
from t in tasks
where t.taskId == id
select t;
return View(task.FirstOrDefault());
}
//
// GET: /Tasks/Details/5
public ActionResult Details(int id)
{
var db = new BurnDown.Models.DB();
var tasks = db.tasks;
var task =
from t in tasks
where t.taskId == id
select t;
return View(task.FirstOrDefault());
}
public ActionResult CreateagendaItem(Models.agendaItem newT)
{
var db = new BurnDown.Models.DB();
db.agendaItems.AddObject(newT);
db.SaveChanges();
var allPtagendaItems =
from aptst in db.agendaItems
where aptst.task_taskId == newT.task_taskId
select aptst;
var completedPtagendaItems =
from aptst in db.agendaItems
where aptst.task_taskId == newT.task_taskId && aptst.completed == true
select aptst;
double a = completedPtagendaItems.Count();
double b = allPtagendaItems.Count();
double percentageCompleted = (double)(a / b) * 100;
BurnDown.Models.task paretnTask =
(from pt in db.tasks
where pt.taskId == newT.task_taskId
select pt).SingleOrDefault();
paretnTask.percentCompleted = (int)Math.Round(percentageCompleted, 0);
db.SaveChanges();
return RedirectToAction("Details", new {id = newT.task_taskId});
}
//
// GET: /Projects/Details/5
public ActionResult Details(int id)
{
var db = new BurnDown.Models.DB();
var tasks = db.tasks;
var project =
from t in tasks
where t.project_projectId == id
select t;
var pr =
(from t in db.projects
where t.projectId == id
select t).Single();
ViewData["projectName"] = pr.projectName;
ViewData["projectId"] = pr.projectId;
ViewData["devId"] = pr.leadDeveloper;
foreach (var task in project)
{
var dev =
from t in tasks
where t.developer_developerId == task.developer_developerId && t.priority > task.priority
select new { t.originalEstimatedHours, t.hoursSpentOnTask };
int hoursWithHigherPriority = 0;
foreach (var times in dev)
{
hoursWithHigherPriority = hoursWithHigherPriority + (times.originalEstimatedHours - times.hoursSpentOnTask);
}
task.hoursForTasksWithHigherPriority = hoursWithHigherPriority;
}
Models.projectChart pc = new Models.projectChart(project.ToArray());
ViewData["projectChart"] = pc.createTasksChart("chartCanvas",150, 400);
return View(project);
}
//
// GET: /Projects/
public ActionResult Index()
{
var db = new BurnDown.Models.DB();
var projects = db.projects;
//var developers = db.developers;
//Dictionary<int,Models.developer> devsResultDict = developers.ToDictionary(d=>d.developerId);
//ViewData["developers"] = devsResultDict;
// BurnDown.Models.projectChart pc = new Models.projectChart(projects.ToArray());
// ViewData["projectChart"] = pc.createProjectsChart("chartCanvas", 150, 400);
return View(projects);
}
public ActionResult Edit(int id, FormCollection collection)
{
try
{
// TODO: Add insert logic here
var db = new BurnDown.Models.DB();
var projects = db.projects;
var newProject =
(from p in projects
where p.projectId == id
select p
).SingleOrDefault();
newProject.priority = int.Parse(collection["priority"]);
newProject.projectName = collection["projectName"];
newProject.leadDeveloper = int.Parse(collection["ddList"]);
db.SaveChanges();
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public ActionResult UpdateAgendaItem(int id)
{
var db = new BurnDown.Models.DB();
var agendaItem =
(from st in db.agendaItems
where st.agendaItemId == id
select st).SingleOrDefault();
return View(agendaItem);
}
public ActionResult CreateagendaItemFromCSL(FormCollection collection)
{
var db = new BurnDown.Models.DB();
string[] namesArr = collection["agendaItemName"].Split('\n');
int task_taskId = int.Parse(collection["task_taskId"]);
foreach (string s in namesArr)
{
Models.agendaItem newT = new Models.agendaItem();
newT.agendaItemName = s;
newT.task_taskId = task_taskId;
if (s != "")
db.agendaItems.AddObject(newT);
}
db.SaveChanges();
var allPtagendaItems =
from aptst in db.agendaItems
where aptst.task_taskId == task_taskId
select aptst;
var completedPtagendaItems =
from aptst in db.agendaItems
where aptst.task_taskId == task_taskId && aptst.completed == true
select aptst;
double a = completedPtagendaItems.Count();
double b = allPtagendaItems.Count();
double percentageCompleted = (double)(a / b) * 100;
BurnDown.Models.task paretnTask =
(from pt in db.tasks
where pt.taskId == task_taskId
select pt).SingleOrDefault();
paretnTask.percentCompleted = (int)Math.Round(percentageCompleted, 0);
db.SaveChanges();
return RedirectToAction("Details", new { id = task_taskId });
}
//
// GET: /Projects/Edit/5
public ActionResult Edit(int id)
{
var db = new BurnDown.Models.DB();
var project = db.projects;
var proj = from p in project where p.projectId == id select p;
IList<SelectListItem> devList = new List<SelectListItem>();
var developers = db.developers;
foreach (BurnDown.Models.developer dev in developers)
{
SelectListItem DevItem = new SelectListItem();
DevItem.Text = dev.firstName + " " + dev.lastName;
DevItem.Value = dev.developerId.ToString();
devList.Add(DevItem);
DevItem = null;
}
ViewData["ddList"] = devList;
return View(proj.FirstOrDefault());
}
