public ActionResult Index() { Search sd = new Search(); FlightBookingEntity db = new FlightBookingEntity(); List <airline> ob = db.airlines.ToList(); return(View(sd)); }
public ActionResult signUp(customer_book customerModel1) { Session["useremail"] = customerModel1.customer_emailaddress; using (FlightBookingEntity db = new FlightBookingEntity()) { db.customer_book.Add(customerModel1); db.SaveChanges(); } ModelState.Clear(); ViewData["message"] = "Successfully signed up.Go to Login Page!"; customerModel1 = null; return(View("signUp", new customer_book())); }
public ActionResult ForgotPasswordView(customer_book customerModel) { String connetionString = System.Configuration.ConfigurationManager.ConnectionStrings["FlightBookingEntity"].ConnectionString; SqlConnection connection = new SqlConnection(connetionString); FlightBookingEntity db = new FlightBookingEntity(); var customerid = db.customer_book.Where(x => x.customer_emailaddress == customerModel.customer_emailaddress).Select(x => x.customer_id).FirstOrDefault(); String sqlPattern = @"update customer_book set customer_password="******"where customer_id=" + customerid; String sqlSentence = String.Format(sqlPattern); connection.Open(); SqlCommand command = new SqlCommand(sqlSentence, connection); command.ExecuteNonQuery(); ViewData["message"] = "Password updated successfully."; return(View()); }
public ActionResult Login(customer_book customerModel) { using (FlightBookingEntity db = new FlightBookingEntity()) { var obj = db.customer_book.Where(x => x.customer_emailaddress == customerModel.customer_emailaddress && x.customer_password == customerModel.customer_password).FirstOrDefault(); if (obj == null) { customerModel.LoginErrorMessage = "Please enter valid Username or Password"; return(View("Login", customerModel)); } Session["username"] = obj.customer_name; Session["userId"] = obj.customer_id; return(RedirectToAction("Index")); } }