public DataTable GetSource()
{
string conStr = GetConnection.GetConnectionString();
SqlConnection con = new SqlConnection(conStr);
SqlDataReader dr;
SqlCommand cmd;
DataTable dt = new DataTable();
string query;
con.Open();
query = "prc_SelectSource";
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
dr = cmd.ExecuteReader();
dt.Load(dr);
con.Close();
return(dt);
}
public DataTable GetDestination(string selectedSource)
{
string conStr = GetConnection.GetConnectionString();
SqlConnection con = new SqlConnection(conStr);
SqlDataReader dr;
SqlCommand cmd;
DataTable dt = new DataTable();
string query;
con.Open();
query = "prc_SelectDestination";
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@source", selectedSource);
dr = cmd.ExecuteReader();
dt.Load(dr);
con.Close();
return(dt);
}
public int updatePassengersBeforePayment(int PassengerId,
string ReferenceId,
string PassengerName,
int PassengerAge,
char PassengerGender,
string BookingStatus)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = GetConnection.GetConnectionString();
SqlCommand cmd;
int cnt = 0;
try
{
//Establish connection with db
con.Open();
string query1 = "prc_InsertPassengersBeforePayment";
cmd = new SqlCommand(query1, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PassengerId", PassengerId);
cmd.Parameters.AddWithValue("@ReferenceId", ReferenceId);
cmd.Parameters.AddWithValue("@PassengerName", PassengerName);
cmd.Parameters.AddWithValue("@PassengerAge", PassengerAge);
cmd.Parameters.AddWithValue("@PassengerGender", PassengerGender);
cmd.Parameters.AddWithValue("@BookingStatus", BookingStatus);
cnt = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(cnt);
}
public void CancelTicket(int PassengerId, string ReferenceId, string user)
{
try
{
SqlConnection con = new SqlConnection();
con.ConnectionString = GetConnection.GetConnectionString();
con.Open();
SqlCommand cmd;
string query1 = "prc_UpdateCancelledStatus";
cmd = new SqlCommand(query1, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PassengerId", PassengerId);
cmd.Parameters.AddWithValue("@ReferenceId", ReferenceId);
cmd.Parameters.AddWithValue("@user", user);
int cnt = cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception) { }
}
public DataTable ViewBookingHistory(string CustomerId)
{
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection();
con.ConnectionString = GetConnection.GetConnectionString();
con.Open();
SqlDataReader dr;
SqlCommand cmd;
string query1 = "prc_BookingHistory";
cmd = new SqlCommand(query1, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CustomerId", CustomerId);
dr = cmd.ExecuteReader();
dt.Load(dr);
con.Close();
return(dt);
}
}//checkEmail
public int SettingNewPassword(string EmailId, string pwd)
{
int n = 0;
SqlConnection con = new SqlConnection();
con.ConnectionString = GetConnection.GetConnectionString();
SqlCommand cmd;
try
{
//Establish connection with db
con.Open();
string query1 = "Prc_SetNewUserPassword";
cmd = new SqlCommand(query1, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EmailId", EmailId);
cmd.Parameters.AddWithValue("@NewPwd", pwd);
n = cmd.ExecuteNonQuery();
//int j=Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception)
{
}
return(n);
}
public DataTable GetPassengers(string ReferenceId)
{
DataTable dtPassengers = new DataTable();
SqlConnection con = new SqlConnection();
con.ConnectionString = GetConnection.GetConnectionString();
SqlDataReader dr;
SqlCommand cmd;
con.Open();
string query1 = "prc_GetPassengerData";
cmd = new SqlCommand(query1, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ReferenceId", ReferenceId);
dr = cmd.ExecuteReader();
dtPassengers.Load(dr);
con.Close();
return(dtPassengers);
}