public DataTable SearchUserFlight(Bal_SearchFlight search, out bool availablestatus) { SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["cnflamingo"].ConnectionString); SqlCommand cmd = new SqlCommand("sp_SearchFlight", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@from", search.From); cmd.Parameters.AddWithValue("@to", search.To); cmd.Parameters.AddWithValue("@neededtickets", search.Traveller); cmd.Parameters.AddWithValue("@departuredate", search.Departure); SqlParameter p1 = new SqlParameter("@status", SqlDbType.Bit); p1.Direction = ParameterDirection.Output; cmd.Parameters.Add(p1); cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); availablestatus = false; DataTable dt = new DataTable(); if (dr.HasRows) { availablestatus = true; dt.Load(dr); } cn.Close(); return(dt); }
public bool CheckCredentials(Bal_SearchFlight searchResult) { SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["cnflamingo"].ConnectionString); SqlCommand cmd = new SqlCommand("sp_Insert_Login_Details", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@from", searchResult.From); cmd.Parameters.AddWithValue("@to", searchResult.To); cmd.Parameters.AddWithValue("@departure", searchResult.Departure); cmd.Parameters.AddWithValue("@arrival", searchResult.Arrival); cmd.Parameters.AddWithValue("@traveller", searchResult.Traveller); cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); bool status = false; if (dr.HasRows) { status = true; } else { status = false; } cn.Close(); return(status); }
public ActionResult Search(clsSearchFlight searchflight) { Bal_SearchFlight flightdetails = new Bal_SearchFlight(); flightdetails.From = searchflight.From; flightdetails.To = searchflight.To; flightdetails.Departure = searchflight.Departure; flightdetails.Traveller = searchflight.Traveller; Dal_SearchFlight search = new DALlibraries.Dal_SearchFlight(); bool status = false; DataTable showFlights = search.SearchUserFlight(flightdetails, out status); TempData["Data"] = showFlights; TempData["noOfTickets"] = flightdetails.Traveller; if (status) { return(RedirectToAction("ShowFlightsOnSearch")); } return(View()); }