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