public static PassengerBooking Get(int passengerId)
{
PassengerBooking passengerBooking = null;
try
{
// string connectionString = null;
using (var con = new MySqlConnection(connectionString))
{
string query = "SELECT * FROM passengerBooking WHERE passengerId=@passengerId";
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.Add(new MySqlParameter("@passengerId", passengerId));
MySqlDataReader reader = cmd.ExecuteReader();
if (reader != null)
{
if (reader.HasRows)
{
if (reader.Read())
{
passengerBooking = new PassengerBooking()
{
PassangerId = int.Parse(reader["passengerId"].ToString()),
BookingId = int.Parse(reader["firstName"].ToString())
};
}
reader.Close();
}
}
}
}
catch (Exception ex)
{ throw ex; }
return(passengerBooking);
}
public static bool Insert(PassengerBooking passengerBooking)
{
bool status;
try
{
using (var mySqlConnection = new MySqlConnection(connectionString))
{
mySqlConnection.Open();
string query = "INSERT passengerBooking(bookingId,passengerId) " +
"VALUES (@bookingId,@passengerId)";
var sqlCommand = new MySqlCommand(query, mySqlConnection);
sqlCommand.Parameters.Add(new MySqlParameter("@bookingId", passengerBooking.BookingId));
sqlCommand.Parameters.Add(new MySqlParameter("@passengerId", passengerBooking.PassangerId));
sqlCommand.ExecuteNonQuery();
status = true;
}
}
catch (Exception ex)
{
Logger.LogException(ex);
throw new Exception("Error while connecting with database, please contact site admin for more detail.");
}
finally
{
}
return(status);
}
public ActionResult DeleteConfirmed(int id)
{
PassengerBooking passengerBooking = db.PassengerBookings.Find(id);
db.PassengerBookings.Remove(passengerBooking);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "PassengerBookingId,UserId,ShipId,Tickets_Available,TicketCost,NoOfTickets,TotalPrice,BookingDate")] PassengerBooking passengerBooking)
{
if (ModelState.IsValid)
{
db.Entry(passengerBooking).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ShipId = new SelectList(db.Ships, "ShipId", "ShipModel", passengerBooking.ShipId);
ViewBag.UserId = new SelectList(db.Users, "UserId", "FirstName", passengerBooking.UserId);
return(View(passengerBooking));
}
// GET: PassengerBookings/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PassengerBooking passengerBooking = db.PassengerBookings.Find(id);
if (passengerBooking == null)
{
return(HttpNotFound());
}
return(View(passengerBooking));
}
public ActionResult Booking([Bind(Include = "PassengerBookingId,UserId,ShipId,Tickets_Available,TicketCost,NoOfTickets,TotalPrice,BookingDate")] PassengerBooking passengerBooking)
{
db.PassengerBookings.Add(passengerBooking);
//int id = 1;
//ShipAccount sa = db.ShipAccounts.Find(id);
//sa.AccountBalance += (decimal)passengerBooking.TotalPrice;
//db.Entry(sa).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "Users"));
ViewBag.ShipId = new SelectList(db.Ships, "ShipId", "ShipModel", passengerBooking.ShipId);
ViewBag.UserId = new SelectList(db.Users, "UserId", "FirstName", passengerBooking.UserId);
return(View(passengerBooking));
}
// GET: PassengerBookings/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PassengerBooking passengerBooking = db.PassengerBookings.Find(id);
if (passengerBooking == null)
{
return(HttpNotFound());
}
ViewBag.ShipId = new SelectList(db.Ships, "ShipId", "ShipModel", passengerBooking.ShipId);
ViewBag.UserId = new SelectList(db.Users, "UserId", "FirstName", passengerBooking.UserId);
return(View(passengerBooking));
}
public async Task CreateAsync(Guid id, Guid proposalId)
{
var proposal = await _passengerBookingProposalRepository.GetOrFailAsync(proposalId);
var dailyRoute = await _dailyRouteRepository.GetOrFailAsync(proposal.DailyRouteId);
var driver = await _driverRepository.GetOrFailAsync(dailyRoute.DriverId);
var user = await _userRepository.GetOrFailAsync(proposal.UserProposalId);
var passengerBooking = new PassengerBooking(proposalId, id, driver.PhoneNumber, true,
user.Username, dailyRoute.Route.StartNode.Address,
dailyRoute.Route.EndNode.Address, dailyRoute.StartDate);
await _passengerBookingRepository.CreateAsync(passengerBooking);
}
public static List <PassengerBooking> GetAll()
{
List <PassengerBooking> passaPassengerses = new List <PassengerBooking>();
try
{
using (var con = new MySqlConnection(connectionString))
{
string query = "SELECT * FROM passengerBooking";
MySqlCommand cmd = new MySqlCommand(query, con);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader != null)
{
if (reader.HasRows)
{
while (reader.Read())
{
PassengerBooking passengerbooking = new PassengerBooking()
{
PassangerId = int.Parse(reader["passengerId"].ToString()),
BookingId = int.Parse(reader["bookingId"].ToString())
};
passaPassengerses.Add(passengerbooking);
}
reader.Close();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(passaPassengerses);
}
public async Task CreateAsync(PassengerBooking passengerBooking)
{
await _bookingRepository.CreateAsync(passengerBooking);
}
