//[Authorize]
public ActionResult AddJourney()
{
tblSchedule_HMS03_Team7 sch = db.tblSchedule_HMS03_Team7.Find(int.Parse(Session["ScheduleID"].ToString()));
tblJourney_HMS03_Team7 jr = new tblJourney_HMS03_Team7();
jr.ScheduleID = sch.ScheduleID;
jr.NoOfPassengers_Adult = int.Parse(Session["NOofADULT"].ToString());
jr.NoOfPassengers_Child = int.Parse((Session["NOofCHILD"]).ToString());
jr.BonusRequstStatus = Session["Class"].ToString(); //class premium
if (jr.BonusRequstStatus == "Premium")
{
decimal adultfare = Convert.ToDecimal(sch.Fare_Premium_Adult);
decimal childfare = Convert.ToDecimal(sch.Fare_Premium_Child);
jr.TotalBookingFare = (jr.NoOfPassengers_Adult * adultfare) + (jr.NoOfPassengers_Child * childfare);
}
else if (jr.BonusRequstStatus == "FirstClass")
{
decimal adultfare = Convert.ToDecimal(sch.Fare_Firstclass_Adult);
decimal childfare = Convert.ToDecimal(sch.Fare_Firstclass_Child);
jr.TotalBookingFare = (jr.NoOfPassengers_Adult * adultfare) + (jr.NoOfPassengers_Child * childfare);
}
else if (jr.BonusRequstStatus == "Economy")
{
decimal adultfare = Convert.ToDecimal(sch.Fare_Economy_Adult);
decimal childfare = Convert.ToDecimal(sch.Fare_Economy_Child);
jr.TotalBookingFare = (jr.NoOfPassengers_Adult * adultfare) + (jr.NoOfPassengers_Child * childfare);
}
jr.NoOfPassengers_Adult = int.Parse(Session["NOofADULT"].ToString());
jr.NoOfPassengers_Child = int.Parse((Session["NOofCHILD"]).ToString());
jr.PaymentStatus = "Pending";
jr.BookingDate = DateTime.Now;
db.tblJourney_HMS03_Team7.Add(jr);
db.SaveChanges();
Session["count"] = 1;
Session["jour"] = jr.JourneyID;
Session["TotalFare"] = jr.TotalBookingFare;
try
{
jr.CustomerID = int.Parse(Session["cid"].ToString());
db.SaveChanges();
}
catch
{
if (jr.CustomerID == null)
{
MessageBox.Show("You haven't Signed-In");
return(RedirectToAction("Log", "tblLogin_HMS03_Team7"));
}
}
return(RedirectToAction("Details", new { id = jr.JourneyID }));
}
public ActionResult Create([Bind(Include = "TransactionID,JourneyID,CardType,CardNumber,CVV,ExpiryDate,PaymentDate,PaymentType,CustomerID,ScheduleID")] tblPayment_HMS03_Team7 tblPayment_HMS03_Team7)
{
if (ModelState.IsValid)
{
//if (DateTime.Parse(tblPayment_HMS03_Team7.PaymentDate.ToString()).Subtract(DateTime.Now).TotalDays < 0)
if (tblPayment_HMS03_Team7.ExpiryDate < DateTime.Now)
{
MessageBox.Show("Expire Date should be in FUTURE");
return(RedirectToAction("Create"));
}
tblPayment_HMS03_Team7.JourneyID = int.Parse(Session["JourneyID"].ToString());
tblPayment_HMS03_Team7.CustomerID = int.Parse(Session["cid"].ToString());//int.Parse(Session["custid"].ToString());
tblPayment_HMS03_Team7.PaymentDate = DateTime.Now;
tblPayment_HMS03_Team7.PaymentType = "Successful";
//
tblJourney_HMS03_Team7 tj = db.tblJourney_HMS03_Team7.Find(int.Parse(Session["JourneyID"].ToString()));
tj.PaymentStatus = "Successful";
//
db.tblPayment_HMS03_Team7.Add(tblPayment_HMS03_Team7);
db.SaveChanges();
Session["TransactionID"] = tblPayment_HMS03_Team7.TransactionID;
return(RedirectToAction("changeseat", "tblSchedule_HMS03_Team7"));
}
ViewBag.CustomerID = new SelectList(db.tblCustomer_HMS03_Team7, "CustomerID", "Title", tblPayment_HMS03_Team7.CustomerID);
ViewBag.JourneyID = new SelectList(db.tblJourney_HMS03_Team7, "JourneyID", "PaymentStatus", tblPayment_HMS03_Team7.JourneyID);
ViewBag.ScheduleID = new SelectList(db.tblSchedule_HMS03_Team7, "ScheduleID", "Source", tblPayment_HMS03_Team7.ScheduleID);
return(View(tblPayment_HMS03_Team7));
}
public ActionResult DeleteConfirmed(int id)
{
tblJourney_HMS03_Team7 tblJourney_HMS03_Team7 = db.tblJourney_HMS03_Team7.Find(id);
db.tblJourney_HMS03_Team7.Remove(tblJourney_HMS03_Team7);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ViewTicket()
{
tblJourney_HMS03_Team7 tblJourney_HMS03_Team7 = db.tblJourney_HMS03_Team7.Find(int.Parse(Session["JourneyID"].ToString()));
if (tblJourney_HMS03_Team7 == null)
{
return(HttpNotFound());
}
return(View(tblJourney_HMS03_Team7));
}
public ActionResult Create([Bind(Include = "JourneyID,CustomerID,ScheduleID,TotalBookingFare,NoOfPassengers_Adult,NoOfPassengers_Child,PaymentStatus,BonusRequstStatus,BookingDate,AdditionalBaggageCharge")] tblJourney_HMS03_Team7 tblJourney_HMS03_Team7)
{
if (ModelState.IsValid)
{
db.tblJourney_HMS03_Team7.Add(tblJourney_HMS03_Team7);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerID = new SelectList(db.tblCustomer_HMS03_Team7, "CustomerID", "Title", tblJourney_HMS03_Team7.CustomerID);
ViewBag.ScheduleID = new SelectList(db.tblSchedule_HMS03_Team7, "ScheduleID", "Source", tblJourney_HMS03_Team7.ScheduleID);
return(View(tblJourney_HMS03_Team7));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblJourney_HMS03_Team7 tblJourney_HMS03_Team7 = db.tblJourney_HMS03_Team7.Find(id);
if (tblJourney_HMS03_Team7 == null)
{
return(HttpNotFound());
}
return(View(tblJourney_HMS03_Team7));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblJourney_HMS03_Team7 tblJourney_HMS03_Team7 = db.tblJourney_HMS03_Team7.Find(id);
if (tblJourney_HMS03_Team7 == null)
{
return(HttpNotFound());
}
ViewBag.CustomerID = new SelectList(db.tblCustomer_HMS03_Team7, "CustomerID", "Title", tblJourney_HMS03_Team7.CustomerID);
ViewBag.ScheduleID = new SelectList(db.tblSchedule_HMS03_Team7, "ScheduleID", "Source", tblJourney_HMS03_Team7.ScheduleID);
return(View(tblJourney_HMS03_Team7));
}
public ActionResult Edit([Bind(Include = "JourneyID,CustomerID,ScheduleID,TotalBookingFare,NoOfPassengers_Adult,NoOfPassengers_Child,PaymentStatus,BonusRequstStatus,BookingDate,AdditionalBaggageCharge")] tblJourney_HMS03_Team7 tblJourney_HMS03_Team7)
{
if (ModelState.IsValid)
{
tblSchedule_HMS03_Team7 sch = db.tblSchedule_HMS03_Team7.Find(int.Parse(Session["ScheduleID"].ToString()));
if (tblJourney_HMS03_Team7.BonusRequstStatus == "Premium")
{
decimal?adultfare = sch.Fare_Premium_Adult;
decimal?childfare = sch.Fare_Premium_Child;
tblJourney_HMS03_Team7.TotalBookingFare = (tblJourney_HMS03_Team7.NoOfPassengers_Adult * adultfare) + (tblJourney_HMS03_Team7.NoOfPassengers_Child * childfare);
}
else if (tblJourney_HMS03_Team7.BonusRequstStatus == "FirstClass")
{
decimal?adultfare = sch.Fare_Firstclass_Adult;
decimal?childfare = sch.Fare_Firstclass_Child;
tblJourney_HMS03_Team7.TotalBookingFare = (tblJourney_HMS03_Team7.NoOfPassengers_Adult * adultfare) + (tblJourney_HMS03_Team7.NoOfPassengers_Child * childfare);
}
else if (tblJourney_HMS03_Team7.BonusRequstStatus == "Economy")
{
decimal?adultfare = sch.Fare_Economy_Adult;
decimal?childfare = sch.Fare_Economy_Child;
tblJourney_HMS03_Team7.TotalBookingFare = (tblJourney_HMS03_Team7.NoOfPassengers_Adult * adultfare) + (tblJourney_HMS03_Team7.NoOfPassengers_Child * childfare);
}
db.Entry(tblJourney_HMS03_Team7).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerID = new SelectList(db.tblCustomer_HMS03_Team7, "CustomerID", "Title", tblJourney_HMS03_Team7.CustomerID);
ViewBag.ScheduleID = new SelectList(db.tblSchedule_HMS03_Team7, "ScheduleID", "Source", tblJourney_HMS03_Team7.ScheduleID);
return(View(tblJourney_HMS03_Team7));
}
public ActionResult Log([Bind(Include = "LoginID,uname,pwd,roles")] tblLogin_HMS03_Team7 tblLogin_HMS03_Team7)
{
List <tblLogin_HMS03_Team7> ulist = db.tblLogin_HMS03_Team7.ToList();
foreach (var i in ulist)
{
if (i.uname.Equals(tblLogin_HMS03_Team7.uname) && i.pwd.Equals(tblLogin_HMS03_Team7.pwd) && i.roles.Equals("Customer"))
{
FormsAuthentication.SetAuthCookie(i.uname, false);
MessageBox.Show("Logged in successfully as: " + tblLogin_HMS03_Team7.uname);
Session["username"] = i.uname;
Session["userid"] = i.LoginID;
ViewBag.uname = i.uname;
List <tblCustomer_HMS03_Team7> clist = db.tblCustomer_HMS03_Team7.ToList();
foreach (var customer in clist)
{
if (i.LoginID == customer.LoginID)
{
Session["cid"] = customer.CustomerID;
}
}
if (Session["ScheduleId"] == null)
{
return(RedirectToAction("Create", "tblSearch_HMS03_Team7"));
}
else
{
int jid = int.Parse(Session["jour"].ToString());
List <tblJourney_HMS03_Team7> jlist = db.tblJourney_HMS03_Team7.ToList();
int cust = int.Parse((Session["cid"]).ToString());
tblJourney_HMS03_Team7 journeys = db.tblJourney_HMS03_Team7.Find(jid);
journeys.CustomerID = cust;
db.SaveChanges();
return(RedirectToAction("Details", "tblJourney_HMS03_Team7", new { id = jid }));
}
}
else if (i.uname.Equals(tblLogin_HMS03_Team7.uname) && i.pwd.Equals(tblLogin_HMS03_Team7.pwd) && i.roles.Equals("Manager"))
{
FormsAuthentication.SetAuthCookie(i.uname, false);
List <tblEmployee_HMS03_Team7> elist = db.tblEmployee_HMS03_Team7.ToList();
foreach (var item in elist)
{
if (i.LoginID == item.LoginID)
{
Session["FMID"] = item.EmployeeID;
Session["FMAirline"] = item.Airlines;
}
}
MessageBox.Show("Logged in successfully as: " + tblLogin_HMS03_Team7.uname);
return(RedirectToAction("Index", "tblAeroplane_HMS03_Team7"));
}
else if (i.uname.Equals(tblLogin_HMS03_Team7.uname) && i.pwd.Equals(tblLogin_HMS03_Team7.pwd) && i.roles.Equals("Flight"))
{
FormsAuthentication.SetAuthCookie(i.uname, false);
List <tblEmployee_HMS03_Team7> elist = db.tblEmployee_HMS03_Team7.ToList();
foreach (var item in elist)
{
if (i.LoginID == item.LoginID)
{
Session["FSID"] = item.EmployeeID;
}
}
MessageBox.Show("Logged in successfully as: " + tblLogin_HMS03_Team7.uname);
return(RedirectToAction("VeiwScheduleToScheduler", "tblSchedule_HMS03_Team7"));
}
}
MessageBox.Show("Invalid");
return(RedirectToAction("Log"));
//}
}
