//pagination (resource Christine Bittle: Pet Grooming Project) // int perpage = 5; // int OnlineCheckIncount = OnlineCheckIn.Count(); // int maxpage = (int)Math.Ceiling((decimal)OnlineCheckIncount / perpage) - 1; // if (maxpage < 0) maxpage = 0; // if (pagenum < 0) pagenum = 0; // if (pagenum > maxpage) pagenum = maxpage; // int start = (int)(perpage * pagenum); // ViewData["pagenum"] = pagenum; // ViewData["pagesummary"] = ""; // if (maxpage > 0) // { // ViewData["pagesummary"] = (pagenum + 1) + " of " + (maxpage + 1); // List<SqlParameter> newparams = new List<SqlParameter>(); //if (petsearchkey != "") //{ // newparams.Add(new SqlParameter("@searchkey", "%" + onlinecheckinsearchkey + "%")); // ViewData["onlinecheckinsearchkey"] = onlinecheckinsearchkey; // } // newparams.Add( new SqlParameter("@start", start)); // newparams.Add( new SqlParameter("@perpage", perpage)); // string pagedquery = query + " order by OnlineCheckInID offset @start rows fetch first @perpage rows only "; // Debug.WriteLine(pagedquery); // Debug.WriteLine("offset "+start); // Debug.WriteLine("fetch first "+perpage); // OnlineCheckIn = db.OnlineCheckIn.SqlQuery(pagedquery, newparams.ToArray()).ToList(); // } //End of Pagination Algorithm //Show Online CheckIn public ActionResult Show(int?id) { Debug.WriteLine(id); //Get the information regarding one record id var first_query = "select * from OnlineCheckIns where CheckInID= @id"; var first_parameter = new SqlParameter("@id", id); OnlineCheckIn OnlineCheckIninfo = db.OnlineCheckIns.SqlQuery(first_query, first_parameter).FirstOrDefault(); if (OnlineCheckIninfo == null) { return(HttpNotFound()); } var second_parameter = new SqlParameter("@id", id); //Find information about the booking related to that record var second_query = "select * from Bookings join CheckIns on Bookings.BookingID = CheckIns.BookingID where CheckInID= @id"; Booking bookinginfo = db.Bookings.SqlQuery(second_query, second_parameter).FirstOrDefault(); if (bookinginfo == null) { return(HttpNotFound()); } ListOnlineCheckIns viewmodel = new ListOnlineCheckIns(); viewmodel.OnlineCheckIninfo = OnlineCheckIninfo; viewmodel.bookinginfo = bookinginfo; return(View(viewmodel)); }
//List Online CheckIn public ActionResult List() { string query = "Select * from OnlineCheckIns join Bookings on OnlineCheckIns.BookingID = Bookings.BookingID order by BookingDate Desc"; Debug.WriteLine(query); //List<OnlineCheckIn> OnlineCheckIns = db.OnlineCheckIns(query, sqlparams.ToArray()).ToList(); List <OnlineCheckIn> allonlinecheckins = db.OnlineCheckIns.SqlQuery(query).ToList(); ListOnlineCheckIns viewmodel = new ListOnlineCheckIns(); viewmodel.OnlineCheckIns = allonlinecheckins; return(View(viewmodel)); }