public ActionResult edit(string pid, int bid)
{
Modelclass model = new Modelclass();
try
{
datamodel data = new datamodel();
int j = (int)Session["id"];
ViewBag.bid = bid;
string job = data.roles.Where(i => i.userid == j).Select(i => i.work).FirstOrDefault();
if (job == "PM")
{
int projm = data.projects.Where(i => i.projectname == pid).Select(i => i.projectid).FirstOrDefault();
var devs = data.roles.Where(i => i.work == "DEV" && i.projectid == projm).Select(i => i.userid);
foreach (var n in devs)
{
var p = data.logins.Where(i => i.loginId == n).FirstOrDefault();
model.dev.Add(new SelectListItem()
{
Text = p.username, Value = p.loginId.ToString()
});
}
}
else
{
return(RedirectToAction("login", "login"));
}
}
catch
{
return(RedirectToAction("login", "login"));
}
return(View(model));
}
public ActionResult status(int bid)
{
Modelclass model = new Modelclass();
try
{
datamodel data = new datamodel();
int j = (int)Session["id"];
string job = data.roles.Where(i => i.userid == j).Select(i => i.work).FirstOrDefault();
if (job != null)
{
List <Modelclass> modellist = new List <Modelclass>();
var hist = data.historys.Where(i => i.bugid == bid);
foreach (var val in hist)
{
string user = data.logins.Where(i => i.loginId == val.ModifieduserId).Select(i => i.username).FirstOrDefault();
string role = data.roles.Where(i => i.userid == val.ModifieduserId).Select(i => i.work).FirstOrDefault();
modellist.Add(new Modelclass()
{
username = user, status = val.status, comments = val.comment, time = val.time, job = role
});
}
return(View(modellist));
}
else
{
return(RedirectToAction("login", "login"));
}
}
catch
{
return(RedirectToAction("login", "login"));
}
}
public ActionResult close(int bid)
{
Modelclass model = new Modelclass();
try
{
datamodel data = new datamodel();
int j = (int)Session["id"];
var role = data.roles.Where(i => i.userid == j);
string job = role.Select(i => i.work).FirstOrDefault();
if (job == "TESTER")
{
ViewBag.bid = bid;
}
else
{
return(RedirectToAction("login", "login"));
}
}
catch
{
return(RedirectToAction("login", "login"));
}
return(View(model));
}
// GET: testing
public ActionResult bug()
{
ViewBag.msg = "BUG Report";
Modelclass model = new Modelclass();
try
{
datamodel data = new datamodel();
int j = (int)Session["id"];
var role = data.roles.Where(i => i.userid == j);
string job = role.Select(i => i.work).FirstOrDefault();
if (job == "TESTER")
{
var projnm = role.Select(i => i.projectid);
foreach (var n in projnm)
{
var p = data.projects.Where(i => i.projectid == n).FirstOrDefault();
model.projectlist.Add(new SelectListItem()
{
Text = p.projectname, Value = p.projectid.ToString()
});
}
SelectListItem[] list = new SelectListItem[3];
list[0] = new SelectListItem()
{
Text = "Blocking", Value = "Blocking"
};
list[1] = new SelectListItem()
{
Text = "High Priority", Value = "High"
};
list[2] = new SelectListItem()
{
Text = "Low Priority", Value = "Low"
};
ViewBag.list = list;
}
else
{
return(RedirectToAction("login", "login"));
}
}
catch
{
return(RedirectToAction("login", "login"));
}
return(View(model));
}
public ActionResult close(int bid, Modelclass model)
{
datamodel data = new datamodel();
bugpool bugs = data.bugpools.Where(i => i.bugid == bid).Select(i => i).FirstOrDefault();
history hist = new history();
bugs.status = "Closed";
data.SaveChanges();
hist.bugid = bugs.bugid;
hist.ModifieduserId = (int)Session["id"];
hist.comment = model.comments;
hist.status = bugs.status;
hist.time = DateTime.Now;
data.historys.Add(hist);
data.SaveChanges();
return(Redirect("/testing/dashboard"));
}
// GET: dev
public ActionResult resolve()
{
try
{
datamodel data = new datamodel();
int j = (int)Session["id"];
string job = data.roles.Where(i => i.userid == j).Select(i => i.work).FirstOrDefault();
if (job == "DEV")
{
}
else
{
return(RedirectToAction("login", "login"));
}
}
catch
{
return(RedirectToAction("login", "login"));
}
return(View());
}
public ActionResult login(Modelclass model)
{
datamodel data = new datamodel();
try
{
if (ModelState.IsValid)
{
int id = data.logins.Where(i => i.username == model.username.ToLower() && i.password == model.password).Select(i => i.loginId).FirstOrDefault();
if (id != 0)
{
Session["id"] = id;
string work = data.roles.Where(i => i.userid == id).Select(i => i.work).FirstOrDefault();
if (work == "PM")
{
return(Redirect("/pm/assign"));
}
if (work == "TESTER")
{
return(Redirect("/testing/bug"));
}
if (work == "DEV")
{
return(Redirect("/dev/resolve"));
}
}
else
{
return(RedirectToAction("login", "login"));
}
}
}
catch
{
return(RedirectToAction("login", "login"));
}
return(View(model));
}
public ActionResult bug(Modelclass model)
{
datamodel data = new datamodel();
bugpool bugs = new bugpool();
history hist = new history();
int j = (int)Session["id"];
bugs.testerid = j;
bugs.projectid = int.Parse(model.projid);
bugs.bugname = model.bugname;
bugs.bugtype = model.bugtype;
bugs.status = "Open";
data.bugpools.Add(bugs);
data.SaveChanges();
hist.bugid = bugs.bugid;
hist.ModifieduserId = bugs.testerid;
hist.comment = model.comments;
hist.status = bugs.status;
hist.time = DateTime.Now;
data.historys.Add(hist);
data.SaveChanges();
return(Redirect("/testing/dashboard"));
}
public ActionResult dashboard()
{
Modelclass model = new Modelclass();
try
{
datamodel data = new datamodel();
int j = (int)Session["id"];
var role = data.roles.Where(i => i.userid == j);
string job = role.Select(i => i.work).FirstOrDefault();
List <Modelclass> modellist = new List <Modelclass>();
if (job != null)
{
if (job == "TESTER")
{
var info = data.bugpools.Where(i => i.testerid == j).Select(i => i);
foreach (var val in info)
{
var proj = data.projects.Where(i => i.projectid == val.projectid).Select(i => i.projectname).FirstOrDefault();
modellist.Add(new Modelclass()
{
status = val.status, bugname = val.bugname, projid = proj, bugtype = val.bugtype, bugid = val.bugid, job = job
});
}
}
else if (job == "DEV")
{
var info = data.bugpools.Where(i => i.assigntoId == j).Select(i => i);
foreach (var val in info)
{
var proj = data.projects.Where(i => i.projectid == val.projectid).Select(i => i.projectname).FirstOrDefault();
modellist.Add(new Modelclass()
{
status = val.status, bugname = val.bugname, projid = proj, bugtype = val.bugtype, bugid = val.bugid, job = job
});
}
}
else if (job == "PM")
{
var projnm = role.Select(i => i.projectid);
foreach (var val in projnm)
{
var devs = role.Where(i => i.work == "DEV" && i.projectid == val).Select(i => i.userid);
foreach (var n in devs)
{
var p = data.logins.Where(i => i.loginId == n).FirstOrDefault();
model.dev.Add(new SelectListItem()
{
Text = p.username, Value = p.loginId.ToString()
});
}
var info = data.bugpools.Where(i => i.projectid == val).Select(i => i);
foreach (var bg in info)
{
var proj = data.projects.Where(i => i.projectid == bg.projectid).Select(i => i.projectname).FirstOrDefault();
modellist.Add(new Modelclass()
{
status = bg.status, bugname = bg.bugname, projid = proj, bugtype = bg.bugtype, bugid = bg.bugid, job = job
});
}
}
}
return(View(modellist));
}
else
{
return(RedirectToAction("login", "login"));
}
}
catch
{
return(RedirectToAction("login", "login"));
}
}