//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));
}
