public ActionResult Create(BugCreateVM newBug)
{
try
{
if (ModelState.IsValid)
{
using (BugsProjectEntities db = new BugsProjectEntities())
{
var bug = new Bug()
{
description = newBug.Description,
projectId = newBug.ProjectId,
userId = newBug.UserId
};
db.Bug.Add(bug);
db.SaveChanges();
}
return(Redirect("/"));
}
return(View(newBug));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
// GET: Bug
public ActionResult Index(int?projectId, int?userId, int?page)
{
List <BugDisplayVM> bugs;
using (BugsProjectEntities db = new BugsProjectEntities())
{
ViewBag.ListProject = new SelectList(db.Project.ToList(), "id", "name");
ViewBag.ListUser = new SelectList(db.User.ToList(), "id", "name");
var Allbugs = db.Bug.AsEnumerable();
if (projectId != null)
{
Allbugs = Allbugs.Where(b => b.projectId == projectId);
}
if (userId != null)
{
Allbugs = Allbugs.Where(b => b.userId == userId);
}
bugs = (Allbugs.Select(b => new BugDisplayVM()
{
Id = b.id,
Project = db.Project.FirstOrDefault(p => p.id == b.projectId).name,
User = db.User.FirstOrDefault(u => u.id == b.userId).name,
Description = b.description
})).ToList();
}
return(View(bugs.ToPagedList((page ?? 1), 10)));
}
public ActionResult Create()
{
using (BugsProjectEntities db = new BugsProjectEntities())
{
ViewBag.ListProject = new SelectList(db.Project.ToList(), "id", "name");
ViewBag.ListUser = new SelectList(db.User.ToList(), "id", "name");
}
return(View());
}
