public ActionResult DeleteConfirmed(int id)
{
Passenger_Details passenger_Details = db.Passenger_Details.Find(id);
db.Passenger_Details.Remove(passenger_Details);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult BookNow(Passenger_Details model)
{
using (var context = new RailwayReservationSystemEntities1())
{
context.Passenger_Details.Add(model);
context.SaveChanges();
}
return(RedirectToAction("Amount", "Booking", model));
}
public ActionResult Edit([Bind(Include = "ID,FName,LName,Age,P_Address,Mobile,Email")] Passenger_Details passenger_Details)
{
if (ModelState.IsValid)
{
db.Entry(passenger_Details).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(passenger_Details));
}
public ActionResult Edit([Bind(Include = "Id,UsersId,PassengerDepartureDate,PassengerArrivalDate,PassengerStatus,Passenger_Class,Passenger_Type")] Passenger_Details passenger_Details)
{
if (ModelState.IsValid)
{
db.Entry(passenger_Details).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(passenger_Details));
}
public ActionResult Create([Bind(Include = "ID,FName,LName,Age,P_Address,Mobile,Email")] Passenger_Details passenger_Details)
{
if (ModelState.IsValid)
{
db.Passenger_Details.Add(passenger_Details);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(passenger_Details));
}
public ActionResult Create([Bind(Include = "Id,UsersId,PassengerDepartureDate,PassengerArrivalDate,PassengerStatus,Passenger_Class,Passenger_Type")] Passenger_Details passenger_Details)
{
if (ModelState.IsValid)
{
db.PassngerDetails.Add(passenger_Details);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(passenger_Details));
}
// GET: Passenger_Details/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Passenger_Details passenger_Details = db.Passenger_Details.Find(id);
if (passenger_Details == null)
{
return(HttpNotFound());
}
return(View(passenger_Details));
}
public bool Post([FromBody] Passenger_Details psg)
{
try
{
db.Passenger_Details.Add(psg);
var res = db.SaveChanges();
if (res > 0)
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
return(false);
}
public ActionResult Amount(Passenger_Details model)
{
using (var context = new RailwayReservationSystemEntities1())
{
int total = 0;
var query = (from a in context.Calculate_Amount where a.PNR_No == model.PNR_No select a).SingleOrDefault();
//int db = (from a in context.Calculate_Amount select a.Total_No_Of_Seats).FirstOrDefault();
switch (query.Class)
{
case "General":
total = 50 * query.Total_No_Of_Seats;
break;
case "Sleeper":
total = 100 * query.Total_No_Of_Seats;
break;
case "AC1":
total = 500 * query.Total_No_Of_Seats;
break;
case "AC2":
total = 350 * query.Total_No_Of_Seats;
break;
case "AC3":
total = 200 * query.Total_No_Of_Seats;
break;
}
TempData["Result"] = total;
//TempData["Result"].keep
}
return(RedirectToAction("Pay", "Payment"));
}
public ActionResult confirmbooking()
{
int countid = 0;
Session["passengererror"] = null;
int count = (int)Session["passengercount"];
Console.WriteLine(count);
List <Passenger_Details> passengerlist = new List <Passenger_Details>();
for (int i = 1; i <= count; i++)
{
if (i == 1)
{
string fname = Request["firstname"].ToString();
string lname = Request["lastname"].ToString();
int age = Convert.ToInt32(Request["age"].ToString());
string address = Request["address"].ToString();
string mobilenumber = Request["mobilenumber"].ToString();
string email = Request["email"].ToString();
int length = mobilenumber.Length;
if (!Regex.Match(fname, "^[A-Z][a-zA-Z]*$").Success)
{
Session["passengererror"] = "Name should contain only Alphabets!";
return(View("PassDetails"));
}
if (!Regex.Match(lname, "^[A-Z][a-zA-Z]*$").Success)
{
Session["passengererror"] = "Name should contain only Alphabets!";
return(View("PassDetails"));
}
if (length != 10)
{
Session["passengererror"] = "Please enter a correct mobile number!";
return(View("PassDetails"));
}
Passenger_Details pd = new Passenger_Details();
pd.FName = fname;
pd.LName = lname;
pd.Age = age;
pd.P_Address = address;
pd.Mobile = mobilenumber;
pd.Email = email;
var rawQuery = db.Database.SqlQuery <int>("SELECT COUNT(*) VALUE FROM Passenger_Details;");
var task = rawQuery.SingleAsync();
int id = (int)task.Result + 1;
countid = id;
pd.ID = id;
passengerlist.Add(pd);
}
if (i == 2)
{
string fname = Request["firstname2"].ToString();
string lname = Request["lastname2"].ToString();
int age = Convert.ToInt32(Request["age2"].ToString());
string address = Request["address2"].ToString();
string mobilenumber = Request["mobilenumber2"].ToString();
string email = Request["email2"].ToString();
Passenger_Details pd = new Passenger_Details();
pd.FName = fname;
pd.LName = lname;
pd.Age = age;
pd.P_Address = address;
pd.Mobile = mobilenumber;
pd.Email = email;
int pid = countid + 1;
pd.ID = pid;
passengerlist.Add(pd);
}
}
Session["passengerlist"] = passengerlist;
return(View("Confirm_Details"));
}
