//GET ALL PENDING REQUEST public JsonResult AllPendingRequest() { try { //List<Account> account = new List<Account>();//account = Account model List <Request> requests = new List <Request>(); //requests = Requests model using (var context = new InventoryDbContext()) //Use DbInventory { //SELECT ALL REQUEST FROM DbInventory requests = (from req in context.Request join loc in context.Location on req.LocationId equals loc.LocationId select new Request { RequestID = req.RequestId, SpecialInstruction = req.SpecialInstruction, RequisitionDate = req.RequestDate, RequiredDate = req.RequiredDate, RequisitionType = req.RequisitionType, Status = req.Status, LocationID = loc.LocationId, LocationName = loc.LocationName, UserID = req.UserId }).ToList(); } var users = _iFUser.Read(); //using (var context = new AccountDbContext())//Use dbAccount //{ // var userIDs = requests.Select(b => b.UserID); // //SELECT ALL USER FROM DbAccount // account = (from user in context.Users // where userIDs.Contains(user.UserId) // select new Account // { // UserID = user.UserId, // Firstname = user.Firstname, // Middlename = user.Middlename, // Lastname = user.Lastname, // Department = user.Department, // Contact = user.Contact, // Email = user.Email, // }).ToList(); //} // //SELECT ALL USER FROM DbAccount // account = (from user in context.Users // where userIDs.Contains(user.UserId) // select new Account // { // UserID = user.UserId, // Firstname = user.Firstname, // Middlename = user.Middlename, // Lastname = user.Lastname, // Department = user.Department, // Contact = user.Contact, // Email = user.Email, // }).ToList(); //} //JOIN TABLE USER AND TABLE REQUEST requests = (from req in requests join acc in users on req.UserID equals acc.UserId where req.Status == "Pending" select new Request { RequestID = req.RequestID, Firstname = acc.Username, //Middlename = acc.Middlename, //Lastname = acc.Lastname, //Department = acc.Department, //Contact = acc.Contact, //Email = acc.Email, SpecialInstruction = req.SpecialInstruction, RequisitionDateString = req.RequisitionDate.ToString(), RequiredDateString = req.RequiredDate.ToString(), RequisitionType = req.RequisitionType, Status = req.Status, LocationID = req.LocationID, LocationName = req.LocationName }).ToList(); return(Json(requests));//Return as json } catch (Exception ex) { return(Json(ex.ToString())); } }
public JsonResult Read() { return(Json(_iFUser.Read())); }