//[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")); //} }