public ActionResult colissuesajax(int projid = 0, int colid = 0, int sort = 0, int filter = 0)
{
// for displaying the agile board
var columns = db.columns.Include(c => c.project);
var pr = db.projects.Select(x => x).Where(x => x.id == projid).FirstOrDefault();
//for the current sprint
int currsp = pr.currentsprint.Value;
//for the issues in the current sprint
var xx = db.issues.Select(x => x).Where(x => x.projectid == projid && x.sprintid == currsp).ToList();
//for the columns in the project
var cols = db.columns.Select(x => x).Where(x => x.projectid == projid).ToList();
// agile class contains columns and its issues
AgileClass cc = new AgileClass();
cc.Columns = cols;
// for sorting 1: priority high to low , 2: priority low to high , 3: key name , 4: key name desc , 5 : name , 6 : name desc
if (sort == 1)
{
xx = db.issues.Select(x => x).Where(x => x.projectid == projid && x.sprintid == currsp).OrderBy(x => x.priority).ToList();
}
if (sort == 2)
{
xx = db.issues.Select(x => x).Where(x => x.projectid == projid && x.sprintid == currsp).OrderByDescending(x => x.priority).ToList();
}
if (sort == 3)
{
xx = db.issues.Select(x => x).Where(x => x.projectid == projid && x.sprintid == currsp).OrderBy(x => x.keyname).ToList();
}
if (sort == 4)
{
xx = db.issues.Select(x => x).Where(x => x.projectid == projid && x.sprintid == currsp).OrderByDescending(x => x.keyname).ToList();
}
if (sort == 5)
{
xx = db.issues.Select(x => x).Where(x => x.projectid == projid && x.sprintid == currsp).OrderBy(x => x.descreption.Substring(0, 25)).ToList();
}
if (sort == 6)
{
xx = db.issues.Select(x => x).Where(x => x.projectid == projid && x.sprintid == currsp).OrderByDescending(x => x.descreption.Substring(0, 25)).ToList();
}
// filter 1 : User Story , 2 : bug
if (filter == 1)
{
xx = xx.Where(x => x.type == "User Story").ToList();
}
if (filter == 2)
{
xx = xx.Where(x => x.type == "Bug").ToList();
}
ViewBag.pid = projid;
ViewBag.cid = colid;
ViewBag.currentsprintid = currsp;
cc.issues = xx;
return(PartialView("omardrag", cc));
}
public ActionResult Indexproject2(int id = 0, int sprintnum = 0, int sort = 0, int filter = 0)
{
// for displaying the agile board of the old sprints same as Indexproject
if (User.IsInRole("developer"))
{
var adminproj = db.pojectdevs.Select(x => x).Where(x => x.projectid == id && x.devname == User.Identity.Name).FirstOrDefault();
if (adminproj == null)
{
return(RedirectToAction("Index", "project"));
}
}
if (User.IsInRole("projectowner"))
{
var adminproj = db.projects.Select(x => x).Where(x => x.id == id && x.projectowner == User.Identity.Name).FirstOrDefault();
if (adminproj == null)
{
return(RedirectToAction("Index", "project"));
}
}
if (User.IsInRole("teamleader"))
{
var adminproj = db.projects.Select(x => x).Where(x => x.id == id && x.projectleader == User.Identity.Name).FirstOrDefault();
if (adminproj == null)
{
return(RedirectToAction("Index", "project"));
}
}
// ViewBag.projectid = id;
//// var zz = db.projects.Select(x => x).Where(x => x.id == id).FirstOrDefault();
// ViewBag.currentsp = sprintnum;
// var columns = db.columns.Include(c => c.project);
// var xx = db.columns.Select(x => x).Where(x => x.projectid == id).ToList();
// return View(xx);
var columns = db.columns.Include(c => c.project);
var pr = db.projects.Select(x => x).Where(x => x.id == id).FirstOrDefault();
int currsp = sprintnum;
var xx = db.issues.Select(x => x).Where(x => x.projectid == id && x.sprintid == currsp).ToList();
var cols = db.columns.Select(x => x).Where(x => x.projectid == id).ToList();
AgileClass cc = new AgileClass();
cc.Columns = cols;
// 1: priority high to low , 2: priority low to high , 3: key name , 4: key name desc
if (sort == 1)
{
xx = db.issues.Select(x => x).Where(x => x.projectid == id && x.sprintid == currsp).OrderBy(x => x.priority).ToList();
}
if (sort == 2)
{
xx = db.issues.Select(x => x).Where(x => x.projectid == id && x.sprintid == currsp).OrderByDescending(x => x.priority).ToList();
}
if (sort == 3)
{
xx = db.issues.Select(x => x).Where(x => x.projectid == id && x.sprintid == currsp).OrderBy(x => x.keyname).ToList();
}
if (sort == 4)
{
xx = db.issues.Select(x => x).Where(x => x.projectid == id && x.sprintid == currsp).OrderByDescending(x => x.keyname).ToList();
}
if (sort == 5)
{
xx = db.issues.Select(x => x).Where(x => x.projectid == id && x.sprintid == currsp).OrderBy(x => x.descreption.Substring(0, 25)).ToList();
}
if (sort == 6)
{
xx = db.issues.Select(x => x).Where(x => x.projectid == id && x.sprintid == currsp).OrderByDescending(x => x.descreption.Substring(0, 25)).ToList();
}
// filter 1 :
if (filter == 1)
{
xx = xx.Where(x => x.type == "User Story").ToList();
}
if (filter == 2)
{
xx = xx.Where(x => x.type == "Bug").ToList();
}
cc.issues = xx;
// 1: priority high to low , 2: priority low to high , 3: key name , 4: key name desc
//if (sort == 1) { xx = db.issues.Select(x => x).Where(x => x.projectid == projid && x.status == colid && x.sprintid == currsp).OrderBy(x => x.priority).ToList(); }
//if (sort == 2) { xx = db.issues.Select(x => x).Where(x => x.projectid == projid && x.status == colid && x.sprintid == currsp).OrderByDescending(x => x.priority).ToList(); }
//if (sort == 3) { xx = db.issues.Select(x => x).Where(x => x.projectid == projid && x.status == colid && x.sprintid == currsp).OrderBy(x => x.keyname).ToList(); }
//if (sort == 4) { xx = db.issues.Select(x => x).Where(x => x.projectid == projid && x.status == colid && x.sprintid == currsp).OrderByDescending(x => x.keyname).ToList(); }
//if (sort == 5) { xx = db.issues.Select(x => x).Where(x => x.projectid == projid && x.status == colid && x.sprintid == currsp).OrderBy(x => x.descreption).ToList(); }
//if (sort == 6) { xx = db.issues.Select(x => x).Where(x => x.projectid == projid && x.status == colid && x.sprintid == currsp).OrderByDescending(x => x.descreption).ToList(); }
//// filter 1 :
//if (filter == 1) { xx = xx.Where(x => x.type == "Epic").ToList(); }
//if (filter == 2) { xx = xx.Where(x => x.type == "User Story").ToList(); }
//if (filter == 3) { xx = xx.Where(x => x.type == "Bug").ToList(); }
// ViewBag.cid = colid;
//ViewBag.currentsprintid = currsp;
var zz = db.sprints.Select(x => x).Where(x => x.sid == sprintnum).FirstOrDefault();
ViewBag.currentsprintid = zz.number;
ViewBag.spid = zz.sid;
ViewBag.pid = id;
return(View("omardrag2", cc));
}
