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