// // 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()); }