public ActionResult Enable(int id = 0)
{
tblMiProject tblmiproject = db.tblMiProjects.Find(id);
if (tblmiproject == null)
{
return(HttpNotFound());
}
return(View("Enable", tblmiproject));
}
public ActionResult EnableTaskConfirmed(int id)
{
tblMiProject proj = db.tblMiProjects.Find(int.Parse(Request.QueryString["projid"]));
tblMiProjectTask tblmiprojecttask = db.tblMiProjectTasks.Find(id);
tblmiprojecttask.Active = true;
tblmiprojecttask.UpdatedOn = DateTime.Today;
db.Entry(tblmiprojecttask).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", new { id = proj.projectId }));
}
public ActionResult EnableConfirmed(int id)
{
tblMiProject tblmiproject = db.tblMiProjects.Find(id);
//db.tblMiProjects.Remove(tblmiproject);
tblmiproject.Active = true;
tblmiproject.UpdatedOn = DateTime.Today;
db.Entry(tblmiproject).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(tblMiProject tblmiproject, int id)
{
if (ModelState.IsValid)
{
db.Entry(tblmiproject).State = EntityState.Modified;
tblmiproject.UpdatedOn = DateTime.Today;
db.SaveChanges();
return(RedirectToAction("Details", new { id = tblmiproject.projectId }));
}
return(View(tblmiproject));
}
public ActionResult EditTask(int id = 0, int projid = 0)
{
tblMiProjectTask tblmiprojecttask = db.tblMiProjectTasks.Find(id);
if (tblmiprojecttask == null)
{
return(HttpNotFound());
}
tblMiProject proj = db.tblMiProjects.Find(projid);
ViewData["projname"] = proj.ProjectName;
return(View(tblmiprojecttask));
}
public ActionResult Create(tblMiProject tblmiproject)
{
if (ModelState.IsValid)
{
tblmiproject.CreatedOn = DateTime.Today;
tblmiproject.UpdatedOn = DateTime.Today;
db.tblMiProjects.Add(tblmiproject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblmiproject));
}
public ActionResult CreateTask(int?projid = 0)
{
tblMiProject tblmiproject = db.tblMiProjects.Find(projid);
if (!projid.HasValue || projid == 0)
{
return(View("Error"));
}
else
{
tblMiProject proj = db.tblMiProjects.Find(projid);
ViewData["projectname"] = proj.ProjectName;
return(View());
}
}
//
// GET: /Home/Details/5
public ActionResult Details(int id = 0)
{
tblMiProject tblmiproject = db.tblMiProjects.Find(id);
ProjectViewModel p = new ProjectViewModel
{
CreatedOn = tblmiproject.CreatedOn,
ProjectId = tblmiproject.projectId,
ProjectName = tblmiproject.ProjectName,
UpdatedOn = tblmiproject.UpdatedOn,
Notes = tblmiproject.Notes
};
if ((bool)tblmiproject.Active)
{
p.Active = "Yes";
}
else
{
p.Active = "No";
}
var query = from t in db.tblMiProjectTasks
where t.projectId == id
select new
{
t.taskId,
t.TaskName,
t.Priority,
t.Progress,
t.CreatedOn,
t.UpdatedOn,
t.AssignedTo,
t.Deadline,
t.Notes,
t.Active,
t.projectId
};
double totalprogress = 0;
double totalpriority = 0;
var total = query.Count();
foreach (var a in query)
{
if (total > 0)
{
if ((bool)a.Active)
{
totalpriority += (double)(1 / (double)a.Priority);
}
}
}
if (total > 0)
{
foreach (var a in query)
{
TaskViewModel tv = new TaskViewModel
{
ProjectId = a.projectId,
TaskId = a.taskId,
TaskName = a.TaskName,
Priority = a.Priority,
Progress = a.Progress,
CreatedOn = a.CreatedOn,
UpdatedOn = a.UpdatedOn,
AssignedTo = a.AssignedTo,
Deadline = a.Deadline,
Notes = a.Notes
};
if (String.IsNullOrEmpty(a.Notes) == true)
{
tv.Notes = "";
}
else
{
tv.Notes = a.Notes.Length > 50 ? a.Notes.Substring(0, 50) + "..." : a.Notes;
}
if ((bool)a.Active)
{
tv.Active = "Yes";
totalprogress += (double)(((double)(1 / (double)a.Priority) / (double)totalpriority)) * (double)a.Progress;
}
else
{
tv.Active = "No";
}
p.ProjectTasks.Add(tv);
}
int x1 = (int)totalprogress;
p.Progress = x1.ToString() + "%";
p.intProgress = (int)totalprogress;
}
else
{
p.Progress = "0%";
p.intProgress = 0;
}
if (tblmiproject == null)
{
return(HttpNotFound());
}
// ---GET PROJECT LIST--
var projects = (from c in db.tblMiProjects
select new ProjectsList {
ProjectId = c.projectId, ProjectName = c.ProjectName
}).OrderBy(x => x.ProjectName).ToList();
ViewBag.projects = projects;
return(View(p));
}
