public async Task <ActionResult> DeleteConfirmed(int id)
{
customer_book customer_book = await db.customer_book.FindAsync(id);
db.customer_book.Remove(customer_book);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "customer_id,country,Gender,customer_name,birth_Date,customer_address,customer_phonenumber,customer_emailaddress,customer_postalcode,customer_password")] customer_book customer_book)
{
if (ModelState.IsValid)
{
db.Entry(customer_book).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(customer_book));
}
// GET: customer_book/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
customer_book customer_book = await db.customer_book.FindAsync(id);
if (customer_book == null)
{
return(HttpNotFound());
}
return(View(customer_book));
}
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"));
}
}
