// GET: Purchase public ActionResult Index() { var list = (from o in db.Orders where o.Employee.Email == User.Identity.Name join s in db.SupervisorApprovals on o.ID equals s.ID into ThisList from s in ThisList.DefaultIfEmpty() select new { EmployeeName = o.Employee.FirstName + " " + o.Employee.LastName, SupervisorName = s.Employee.FirstName + " " + s.Employee.LastName, StatusName = o.Status.StatusName, CategoryName = o.Category.CategoryName, BudgetCodeName = o.BudgetCode.BudgetCodeName, DateMade = o.DateMade, DateOrdered = o.DateOrdered, StateContract = o.StateContract, BusinessJustification = o.BusinessJustification }).ToList() .Select(x => new PurchaseReqWithReqestViewModels() { EmployeeName = x.EmployeeName, SupervisorName = x.SupervisorName, StatusName = x.StatusName, CategoryName = x.CategoryName, BudgetCodeName = x.BudgetCodeName, DateMade = x.DateMade, DateOrdered = x.DateOrdered, StateContract = x.StateContract, BusinessJustification = x.BusinessJustification }); return(View(list)); }
// GET: CampusAndAddress public ActionResult Index() { var list = (from c in db.Campuses join a in db.Addresses on c.ID equals a.ID into ThisList from a in ThisList.DefaultIfEmpty() select new { CampusName = c.CampusName, Active = c.Active, City = a.City, State = a.State, StreetAddress = a.StreetAddress, ZIP = a.ZIP }).ToList() .Select(x => new CampusWithAddressViewModels() { CampusName = x.CampusName, Active = x.Active, City = x.City, State = x.State, StreetAddress = x.StreetAddress, ZIP = x.ZIP }); return(View(list)); }
// Display BudgetCodes with Amount public ActionResult Index() { var list = (from c in db.BudgetCodes join a in db.BudgetAmounts on c.ID equals a.ID into ThisList from a in ThisList.DefaultIfEmpty() select new { DA_CODE = c.DA_CODE, BudgetCodeName = c.BudgetCodeName, Type = c.Type, Active = c.Active, TotalAmount = a.TotalAmount }).ToList() .Select(x => new BudgetCodeWithAmountViewModels() { DA_CODE = x.DA_CODE, BudgetCodeName = x.BudgetCodeName, Type = x.Type, Active = x.Active, TotalAmount = x.TotalAmount }); return(View(list)); }
// GET: Vendors public ActionResult Index() { //var vendors = db.Vendors.Include(v => v.Address); //return View(vendors.ToList()); var list = (from v in db.Vendors join a in db.Addresses on v.AddressID equals a.ID into ThisList from a in ThisList.DefaultIfEmpty() select new { VendorName = v.VendorName, Phone = v.Phone, Fax = v.Fax, Website = v.Website, City = a.City, State = a.State, StreetAddress = a.StreetAddress, ZIP = a.ZIP }).ToList() .Select(x => new VendorWithAddressViewModels() { VendorName = x.VendorName, Phone = x.Phone, Fax = x.Fax, Website = x.Website, City = x.City, State = x.State, StreetAddress = x.StreetAddress, ZIP = x.ZIP }); return(View(list)); }
// GET: Rooms public ActionResult Index() { //var rooms = db.Rooms.Include(r => r.Campus); //return View(rooms.ToList()); var list = (from r in db.Rooms join c in db.Campuses on r.CampusID equals c.ID into ThisList from c in ThisList.DefaultIfEmpty() select new { RoomCode = r.RoomCode, RoomName = r.RoomName, Active = r.Active, CampusName = c.CampusName, }).ToList() .Select(x => new RoomWithCampusViewModels() { RoomCode = x.RoomCode, RoomName = x.RoomName, Active = x.Active, CampusName = x.CampusName, }); return(View(list)); }
//Renders view with the selected livestock's images public ActionResult ViewLivestockImage(int id) { //joins livestock with the respective images that have that livestock's ID var listWthEmpty = from l in db.LivesStocks where l.LivestockID == id join li in db.LivestockImages on l.LivestockID equals li.LivestockID into ThisList from li in ThisList.DefaultIfEmpty() select new LivestockImagesVM { ImageId = li.ImageId, LivestockCode = l.Code, UploadDate = li.UploadtDate }; return(View(listWthEmpty)); }
// GET: Supervisor public ActionResult Index() { var list = (from a in db.SupervisorApprovals join e in db.Employees on a.SupervisorID equals e.Id into ThisList from e in ThisList.DefaultIfEmpty() select new { ApprovalName = a.Approval.ApprovalName, SupervisorName = e.FirstName + " " + e.LastName, DeniedJustification = a.DeniedJustification }).ToList() .Select(x => new SupervisorApprovalWithApprovalViewModels() { ApprovalName = x.ApprovalName, SupervisorName = x.SupervisorName, DeniedJustification = x.DeniedJustification }); return(View(list)); }
public ActionResult viewDepartments() { var list = (from d in db.Departments join div in db.Divisions on d.ID equals div.ID into ThisList from div in ThisList.DefaultIfEmpty() select new { DepartmentName = d.DepartmentName, Active = d.Active, DivisionName = div.DivisionName }).ToList() .Select(x => new DepartmentWithDivisionViewModels() { DepartmentName = x.DepartmentName, Active = x.Active, DivisionName = x.DivisionName }); return(View(list)); }
public ActionResult ItemWithVendor() { var list = (from r in db.Requests join v in db.Vendors on r.VendorID equals v.ID into ThisList from v in ThisList.DefaultIfEmpty() select new { QuantityRequested = r.QuantityRequested, EstimatedCost = r.EstimatedCost, EstimatedTotal = r.EstimatedTotal, PaidCost = r.PaidCost, PaidTotal = r.PaidTotal, Chosen = r.Chosen, orderID = r.OrderID, Attachments = r.Attachments, ItemName = r.Item.ItemName, Description = r.Item.Description, ReasonChosen = r.ReasonChosen, VendorName = v.VendorName }).ToList() .Select(x => new RequestWithVendorViewModels() { QuantityRequested = x.QuantityRequested, EstimatedCost = x.EstimatedCost, EstimatedTotal = x.EstimatedTotal, PaidCost = x.PaidCost, PaidTotal = x.PaidTotal, Chosen = x.Chosen, orderID = x.orderID, Attachments = x.Attachments, ItemName = x.ItemName, Description = x.Description, ReasonChosen = x.ReasonChosen, VendorName = x.VendorName }); return(View(list)); }
// GET: Divisions public ActionResult Index() { //var divisions = db.Divisions.Include(d => d.Supervisor); //return View(divisions.ToList()); var list = (from d in db.Divisions join e in db.Employees on d.SupervisorID equals e.Id into ThisList from e in ThisList.DefaultIfEmpty() select new { DivisionName = d.DivisionName, Active = d.Active, SupervisorName = e.FirstName + " " + e.LastName, }).ToList() .Select(x => new DivisionWithSupervisorViewModels() { DivisionName = x.DivisionName, Active = x.Active, SupervisorName = x.SupervisorName }); return(View(list)); }
/// <summary> /// Display all of the restaurants based on the provided parameters /// </summary> /// <param name="sort">Obtain the type of sorting</param> /// <param name="cuisineType">Obtainthe cuisine type</param> /// <param name="searchWord">Obtain the word that the user wants to search</param> /// <returns></returns> public IActionResult Index(int?sort, string cuisineType, string searchWord, string serviceType) { // Bypass parameters if necessary, using character x if (cuisineType == "x") { cuisineType = ""; } if (searchWord == "x") { searchWord = ""; } if (serviceType == "x") { serviceType = ""; } else if (!string.IsNullOrEmpty(cuisineType) && cuisineType != "undefined") { ViewBag.Message = "You are viewing " + cuisineType + " cuisine . . ."; } // Obtain the filtering sort ViewBag.Sort = sort; // Obtain cuisines as a list ViewData["Cuisine"] = _goEats.ReadAllTypes(); var restList = (from p in _db.Restaurants join f in _db.Covid19 on p.id equals f.restaurant_id into ThisList from f in ThisList.DefaultIfEmpty() select new { Id = p.id, CID = f.id, Name = p.name, Address = p.address, City = p.city, State = p.state_code, ZipCode = p.zip_code, Phone = p.telephone, CovidPolicy = f.comments, Covid_I = f.indoor_dining, Covid_L = f.limit_seating, Covid_T = f.take_out, Covid_C = f.curbside, Food = p.cuisines, Delivery = p.has_delivery, TakeOut = p.has_takeaway, PriceRange = p.price_range, Time = p.timings, Menu = p.menu_url }).ToList() .Select(x => new RestaurantInfoVM() { Rest_Id = x.Id, Rest_COVID_Id = x.CID, Rest_Name = x.Name, Rest_Address = x.Address, Rest_City = x.City, Rest_State = x.State, Rest_ZipCode = x.ZipCode, Rest_Phone = x.Phone, Rest_CurbSide = x.Covid_C, Rest_Delivery = x.Delivery, Rest_IndoorSeating = x.Covid_I, Rest_LimitedSeating = x.Covid_L, Rest_TakeOut = x.Covid_T, Rest_CovidPolicy = x.CovidPolicy, Rest_PriceRange = x.PriceRange, Rest_Time = x.Time, Rest_Cuisine = x.Food, Rest_Menu = x.Menu }); // Adjust results via parameters if (!string.IsNullOrEmpty(searchWord)) { return(View(restList.Where(x => x.Rest_Name.Contains(searchWord.ToString())).OrderByDescending(x => x.Rest_Name))); } if (!string.IsNullOrEmpty(cuisineType) && sort == 0) { return(View(restList.Where(x => x.Rest_Cuisine.Contains(cuisineType.ToString())).OrderByDescending(x => x.Rest_Name))); } else if (!string.IsNullOrEmpty(cuisineType) && sort == 1) { return(View(restList.Where(x => x.Rest_Cuisine.Contains(cuisineType.ToString())).OrderBy(x => x.Rest_Name))); } else if (string.IsNullOrEmpty(cuisineType) && sort == 0) { return(View(restList.OrderByDescending(x => x.Rest_Name))); } else if (string.IsNullOrEmpty(cuisineType) && sort == 1) { return(View(restList.OrderBy(x => x.Rest_Name))); } else { return(View(restList)); } }