public ActionResult btnClosed() { tblActionItem actionitems = new tblActionItem(); return(RedirectToAction("ActionItems", "Home", new { Status = "Closed" })); }
public ActionResult ActionItems(string Status, string Sales) { tblActionItem actionitems = new tblActionItem(); if (Status == null) { // var incc = (SELECT * FROM tblActionItem // INNER JOIN tblTripReport ON tblTripReport.tripreportID = tblActionItem.TripReportID // INNER JOIN tblCustomers ON tblCustomers.CustomerID = tblTripReport.[Customer ID] // INNER JOIN tblEmployees ON tblEmployees.EmployeeID = tblCustomers.EmployeeID // WHERE Sales = 'MW'); //var incc = (from sa in db.tblActionItems // //join trid in db.tblTripReports on sa.TripReportID equals trid.tripreportID // //join cust in db.tblCustomers on trid.Customer_ID equals cust.CustomerID // //join emp in db.tblEmployees on cust.EmployeeID equals emp.EmployeeID // select new // { // Status = sa.Status, // Action_Item = sa.Action_Item, // Owners = sa.Owners, // Due_Date = sa.Due_Date, // Updated = sa.Updated, // CreateDate = sa.CreateDate, // // Principal = trid.PrinName // // Sales = emp.Sales // }).ToList(); //var incc = (from sa in db.tblActionItems // // join trid in db.tblTripReports on sa.TripReportID equals trid.tripreportID // // join cust in db.tblCustomers on trid.Customer_ID equals cust.CustomerID // // join emp in db.tblEmployees on cust.EmployeeID equals emp.EmployeeID // select new // { // Status = sa.Status, // Action_Item = sa.Action_Item, // Owners = sa.Owners, // Due_Date = sa.Due_Date, // Updated = sa.Updated, // CreateDate = sa.CreateDate, // // Sales = emp.Sales // }).ToList().Select(i => new tblActionItem // { // Status = Status, // Action_Item = Action_Item, // Owners = Owners, // Due_Date = Due_Date, // Updated = Updated, // CreateDate = CreateDate, // // Sales = Sales // }).ToList(); //return View(incc.ToList()); return(View(db.tblActionItems.ToList())); } else { // var sales = from sa in db.tblActionItems // join trid in db.tblTripReports on sa.TripReportID equals trid.tripreportID // join cust in db.tblCustomers on trid.Customer_ID equals cust.CustomerID // join emp in db.tblEmployees on cust.EmployeeID equals emp.EmployeeID // select emp; //sales = sales.Where(employee => employee.Sales.Contains(S); //if(sales.) var s = from st in db.tblActionItems select st; s = s.Where(status => status.Status.Contains(Status)); //actionitems = db.tblActionItems.Where(x => x.Status == Status); return(View(s.ToList())); } }
public ActionResult btnPending() { tblActionItem actionitems = new tblActionItem(); return(RedirectToAction("ActionItems", "Home", new { Status = "Pending" })); }