partial void UpdatePassengerDetail(PassengerDetail instance);
partial void DeletePassengerDetail(PassengerDetail instance);
partial void InsertPassengerDetail(PassengerDetail instance);
private void detach_PassengerDetails(PassengerDetail entity)
{
this.SendPropertyChanging();
entity.TrainDetail = null;
}
private void attach_PassengerDetails(PassengerDetail entity)
{
this.SendPropertyChanging();
entity.LoginDetail = this;
}
public ActionResult Reservation(FormCollection collection)
{
if (Session["UserId"] == null && Session["SessionID"] == null)
{
return RedirectToAction("Login", "User");
}
int TrainID = int.Parse(collection["TrainID"]);
List<PassengerDetail> list = pm.GetAllSeatForTrain(TrainID, collection["Compartment"], Convert.ToDateTime(collection["DateOfTravel"]));
int[] seats = new int[Utils.getMaxNumberOfClass(collection["Compartment"], tm.GetOneByID(TrainID))];
foreach (PassengerDetail pd in list)
{
seats[pd.SEAT_NUM - 1] = 1;
}
ViewData["TrainName"] = collection["TrainName"];
ViewData["Compartment"] = collection["Compartment"];
ViewData["StationFrom"] = collection["StationFrom"];
ViewData["StationTo"] = collection["StationTo"];
ViewData["Distance"] = collection["Distance"];
ViewData["ArrivalTime"] = collection["ArrivalTime"];
ViewData["DepartureTime"] = collection["DepartureTime"];
ViewData["DateOfTravel"] = collection["DateOfTravel"];
for (int i = 0; i < seats.Length; i++)
{
if (seats[i] == 0)
{
ViewData["SeatNum"] = i + 1;
break;
}
}
ViewData["CoachNum"] = Utils.getCoachNumber(Convert.ToString(ViewData["Compartment"]), int.Parse(ViewData["SeatNum"].ToString()));
TrainDetail td = tm.FindOneById(TrainID);
FareDetail fd = fm.GetByType(td.TRAIN_TYPE, collection["Compartment"]);
ViewData["Price"] = fd.FARE_VALUE * (int.Parse(collection["Distance"]) / fd.FARE_DISTANCE);
ViewData["Data"] = tsm.GetOnyById(TrainID);
PassengerDetail pgd = new PassengerDetail
{
TRAIN_ID = TrainID,
PASSENGER_NAME = "",
PASSENGER_AGE = 0,
PASSENGER_GENDER = "undefined",
FROM_TO = collection["StationFrom"] + "-" + collection["StationTo"],
LOGIN_ID = int.Parse(Session["UserId"].ToString()),
CLASS = collection["Compartment"],
SEAT_NUM = int.Parse(ViewData["SeatNum"].ToString()),
TIKET_TYPE = 0,
TRAIN_FARE = double.Parse(ViewData["Price"].ToString()),
DATE_OF_TRAVEL = Convert.ToDateTime(collection["DateOfTravel"]),
PD_TIME_CRT = DateTime.Now,
ARRIVAL = TimeSpan.Parse(collection["ArrivalTime"]),
DEPARTURE = TimeSpan.Parse(collection["DepartureTime"]),
COACH_NUM = int.Parse(ViewData["CoachNum"].ToString())
};
ViewData["PNR"] = pm.Insert(pgd);
return View();
}
public int Insert(PassengerDetail pgd)
{
db.PassengerDetails.InsertOnSubmit(pgd);
try
{
db.SubmitChanges();
return pgd.PNR_ID;
}
catch (Exception ex) {
Console.WriteLine(ex.Message);
return 0;
}
}
