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 IEnumerable<Ticket> GetTicketDetails(string mobile_number)
{
DAL dal = new DAL();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "GetTicketDetail";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@mobile_number", mobile_number);
DataTable dt = dal.Execute(cmd);
List<Ticket> tickets = new List<Ticket>();
foreach (DataRow dr in dt.Rows)
{
Ticket ticket = new Ticket
{
passenger_id = Int64.Parse(dr["passenger_id"].ToString()),
ticket_id = Int64.Parse(dr["ticket_id"].ToString()),
schedule_id = Int64.Parse(dr["schedule_id"].ToString())
};
tickets.Add(ticket);
}
return tickets;
}
public List<> getOrders(string email)
{
DAL dal = new DAL();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetOrders";
cmd.Parameters.AddWithValue("@email", email);
DataTable dt = db.Execute(cmd);
List<OrderSummary> orders = new List<OrderSummary>();
foreach (DataRow dr in dt.Rows)
{
OrderSummary ordersummary = new OrderSummary
{
OrderID = Int32.Parse(dr["OrderNo"].ToString()),
OrderDate = DateTime.Parse(dr["OrderDate"].ToString()),
ShipDate = DateTime.Parse(dr["ShipDate"].ToString()).Date,
OrderStatus = dr["OrderStatus"].ToString(),
BillingStatus = dr["BillingStatus"].ToString(),
OrderType = dr["OrderType"].ToString(),
OrderAmount = double.Parse(dr["OrderAmount"].ToString())
};
orders.Add(ordersummary);
}
return orders;
}
public IEnumerable<Location> GetAll(long id)
{
DAL dal = new DAL();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "GetLocationGongTo";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@location_leaving_from", id);
DataTable dt = dal.Execute(cmd);
List<Location> locations = new List<Location>();
foreach (DataRow dr in dt.Rows)
{
Location location = new Location
{
location_id = Int64.Parse(dr["location_id"].ToString()),
location_name = dr["location_name"].ToString(),
active = bool.Parse(dr["active"].ToString()),
date_created = DateTime.Parse(dr["date_created"].ToString()),
created_by = dr["created_by"].ToString(),
date_updated = DateTime.Parse(dr["date_updated"].ToString()),
updated_by = dr["updated_by"].ToString(),
};
locations.Add(location);
}
return locations;
}
public IEnumerable<Stop> GetStopDetails(Int64 route_id)
{
DAL dal = new DAL();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetStopDetails";
cmd.Parameters.AddWithValue("@route_id", route_id);
DataTable dt = dal.Execute(cmd);
List<Stop> stops = new List<Stop>();
foreach (DataRow dr in dt.Rows)
{
Stop stop = new Stop
{
stop_id = Int64.Parse(dr["stop_id"].ToString()),
stop_name = dr["stop_name"].ToString(),
route_id = Int64.Parse(dr["route_id"].ToString()),
sort = int.Parse(dr["sort"].ToString()),
};
stops.Add(stop);
}
return stops;
}
public Ticket AddTicket(Ticket item )
{
DAL dal = new DAL();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SaveTicket";
cmd.Parameters.AddWithValue("@mobile_number", item.mobileNumber);
cmd.Parameters.AddWithValue("@schedule_id", item.schedule_id);
int ticketsAdded = dal.ExecuteProcNonQuery(cmd);
return item;
}
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 IEnumerable<Schedule> GetScheduleWithAmount(Int64 fromlocation, Int64 toLocation)
{
DAL dal = new DAL();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetScheduleWithAmount";
cmd.Parameters.AddWithValue("@location_leaving_from", fromlocation);
cmd.Parameters.AddWithValue("@location_going_to", toLocation);
DataTable dt = dal.Execute(cmd);
List<Schedule> schedules = new List<Schedule>();
foreach (DataRow dr in dt.Rows)
{
Schedule schedule = new Schedule
{
schedule_id = Int64.Parse(dr["schedule_id"].ToString()),
route_id = Int64.Parse(dr["route_id"].ToString()),
route_name = dr["route_name"].ToString(),
departure_date = DateTime.Parse(dr["departure_date"].ToString()),
departure_time = dr["departure_time"].ToString(),
arrival_date = DateTime.Parse(dr["arrival_date"].ToString()),
arrival_time = dr["arrival_time"].ToString(),
deparature_city = dr["deparature_city"].ToString(),
arrival_city = dr["arrival_city"].ToString(),
fare = double.Parse(dr["fare"].ToString()),
active = bool.Parse(dr["active"].ToString()),
date_created = DateTime.Parse(dr["date_created"].ToString()),
created_by = dr["created_by"].ToString(),
date_updated = DateTime.Parse(dr["date_updated"].ToString()),
updated_by = dr["updated_by"].ToString(),
};
schedules.Add(schedule);
}
return schedules;
}
public IEnumerable<Schedule> GetAll()
{
DAL dal = new DAL();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetSchedules";
DataTable dt = dal.Execute(cmd);
List<Schedule> schedules = new List<Schedule>();
foreach (DataRow dr in dt.Rows)
{
Schedule schedule = new Schedule
{
schedule_id = Int64.Parse(dr["schedule_id"].ToString()),
bus_id = Int64.Parse(dr["bus_id"].ToString()),
vehicle_id = Int64.Parse(dr["vehicle_id"].ToString()),
route_id = Int64.Parse(dr["route_id"].ToString()),
route_name = dr["route_name"].ToString(),
departure_date = DateTime.Parse(dr["departure_date"].ToString()),
departure_time = dr["departure_time"].ToString(),
arrival_date = DateTime.Parse(dr["arrival_date"].ToString()),
arrival_time = dr["arrival_time"].ToString(),
active = bool.Parse(dr["active"].ToString()),
date_created = DateTime.Parse(dr["date_created"].ToString()),
created_by = dr["created_by"].ToString(),
date_updated = DateTime.Parse(dr["date_updated"].ToString()),
updated_by = dr["updated_by"].ToString(),
};
schedules.Add(schedule);
}
return schedules;
}
