public IEnumerable<Passenger> GetPassengerDetail(string mobile_number)
{
DAL dal = new DAL();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "GetPassengerDetail";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@mobile_number", mobile_number);
DataTable dt = dal.Execute(cmd);
List<Passenger> passengers = new List<Passenger>();
foreach (DataRow dr in dt.Rows)
{
Passenger passenger = new Passenger
{
passenger_id = Int64.Parse(dr["passenger_id"].ToString()),
passenger_name = dr["passenger_name"].ToString(),
mobile_number = dr["mobile_number"].ToString(),
email_address = dr["email_address"].ToString()
};
passengers.Add(passenger);
}
return passengers;
}
public Passenger AddPassenger(Passenger item)
{
DAL dal = new DAL();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SavePassenger";
cmd.Parameters.AddWithValue("@mobile_number", item.mobile_number);
cmd.Parameters.AddWithValue("@email_address", item.email_address);
cmd.Parameters.AddWithValue("@passenger_name", item.passenger_name);
int ticketsAdded = dal.ExecuteProcNonQuery(cmd);
return item;
}
public Passenger AddPassenger(Passenger item)
{
return repository.AddPassenger(item);
}
