public ActionResult Index([Bind(Include = "UserName, Password")] LoginClass l)
{
BakeryEntities db = new BakeryEntities();
//use the stored procedure to validate the user
int result = db.usp_Login(l.UserName, l.Password);
//Initialize the Message object
Message m = new Message();
//if the login is valid get the personkey for the user
if (result != -1)
{
var userkey = (from p in db.People
where p.PersonEmail.Equals(l.UserName)
select p.PersonKey).FirstOrDefault();
int pkey = (int)userkey;
//write the personkey to a session
Session["PersonKey"] = pkey;
//Create the welcome message
m.MessageText = "Welcome, " + l.UserName;
}
else
{
//if not valid send the the invalid login message
m.MessageText = "Invalid Login";
}
return(View("Result", m));
}
public ActionResult Index([Bind(Include = "PersonLastName, PersonEmail, PersonPhone, LoginTime")] LoginClass lc)
{ //connecting database
BakeryEntities db = new BakeryEntities();
Person p = new Person();
var email = (from pl in db.People
where pl.PersonLastName.Equals(lc.PersonLastName)
select pl.PersonEmail).FirstOrDefault();
var phone = (from pl in db.People
where pl.PersonLastName.Equals(lc.PersonLastName)
select pl.PersonPhone).FirstOrDefault();
if (lc.PersonEmail == email || lc.PersonPhone == phone)
{ //lookup user key
int uID = (from pl in db.People
where pl.PersonLastName.Equals(lc.PersonLastName) && (pl.PersonEmail.Equals(lc.PersonEmail) || pl.PersonPhone.Equals(lc.PersonPhone))
select pl.PersonKey).FirstOrDefault();
var FName = (from pl in db.People
where pl.PersonLastName.Equals(lc.PersonLastName) && (pl.PersonEmail.Equals(lc.PersonEmail) || pl.PersonPhone.Equals(lc.PersonPhone))
select pl.PersonFirstName).FirstOrDefault();
Session["LoginTime"] = DateTime.Now;
Session["CustomerID"] = uID;
//create a message class and pass the string to the result view
Message msg = new Message("Welcome " + FName + ", You can now shop!");
return(RedirectToAction("Result", msg));
}
//if it fails pass this message to the result view
Message message = new Message("Invalid Login");
return(View("Result", message));
}
public ActionResult Index([Bind(Include = " PersonKey, PersonLastName, PersonFirstName,PersonEmail, PersonPhone,PersonDateAdded")] CustomerRegister cr)
{ //connecting database of bakery
BakeryEntities db = new BakeryEntities();
Person p = new Person();
p.PersonLastName = cr.PersonLastName;
p.PersonFirstName = cr.PersonFirstName;
var email = (from pl in db.People
where pl.PersonLastName.Equals(cr.PersonLastName) || pl.PersonFirstName.Equals(cr.PersonFirstName) || pl.PersonEmail.Equals(cr.PersonEmail)
select pl.PersonEmail).FirstOrDefault();
var phone = (from pl in db.People
where pl.PersonLastName.Equals(cr.PersonLastName) || pl.PersonFirstName.Equals(cr.PersonFirstName) || pl.PersonPhone.Equals(cr.PersonPhone)
select pl.PersonPhone).FirstOrDefault();
//checking if the personkey existed by comparing the input email and phone
if (email == cr.PersonEmail || phone == cr.PersonPhone)
{
Message msg = new Message("Account Existed");
return(RedirectToAction("Result", msg));
}
p.PersonEmail = cr.PersonEmail;
p.PersonPhone = cr.PersonPhone;
p.PersonDateAdded = DateTime.Now;
db.People.Add(p);
db.SaveChanges();
Message m = new Message();
m.MessageText = "Thank you, the book has been added";
return(View("Result", m));
}
public ActionResult Index([Bind(Include = "ProductName, ProductPrice")] Product p)
{
BakeryEntities db = new BakeryEntities();
db.Products.Add(p);
db.SaveChanges();
return(View());
}
public ActionResult Index()
{
//initialize entities classes
BakeryEntities db = new BakeryEntities();
//pass the collection categories to the index as a list
return(View(db.Products.ToList()));
}
public ActionResult Index([Bind(Include = "ProductName, ProductPrice")]Product formProduct)
{
BakeryEntities db = new BakeryEntities();
Product dbProduct = new Product();
dbProduct.ProductName = formProduct.ProductName;
dbProduct.ProductPrice = formProduct.ProductPrice;
db.Products.Add(dbProduct);
db.SaveChanges();
return View("Verification");
}
public ActionResult Index([Bind(Include = "PersonEmail")] Person lp)
{
BakeryEntities be = new BakeryEntities();
var loginKey = (from p in be.People
where p.PersonEmail.Equals(lp.PersonEmail)
select p.PersonKey).FirstOrDefault();
if (loginKey == 0)
{
Message bad = new Message();
bad.MessageTitle = "Login";
bad.MessageText = "Sorry, you need to register before you can login.";
return(RedirectToAction("Result", bad));
}
// store user personKey in Session
int pKey = (int)loginKey;
Session["personKey"] = pKey;
//store username
String first = (from p in be.People
where p.PersonKey.Equals(pKey)
select p.PersonFirstName).FirstOrDefault();
Session["personName"] = first;
//store user phone
String phone = (from p in be.People
where p.PersonKey.Equals(pKey)
select p.PersonPhone).FirstOrDefault();
Session["personPhone"] = phone;
//store user email
String email = (from p in be.People
where p.PersonKey.Equals(pKey)
select p.PersonEmail).FirstOrDefault();
Session["personEmail"] = email;
Message m = new Message();
m.MessageTitle = "Login";
m.MessageText = "Thank you, " + first + " your login was successful.";
return(RedirectToAction("Result", m));
}
public ActionResult Index([Bind(Include = "LastName, FirstName, Email, Phone, Password")] NewPerson p)
{
BakeryEntities db = new BakeryEntities();
Message msg = new Message();
int result = db.usp_newPerson(p.LastName, p.FirstName, p.Email, p.Phone, p.Password);
if (result != -1)
{
msg.MessageText = "Thank you for registering";
}
else
{
msg.MessageText = "Something went wrong with the registration";
}
return(View("Result", msg));
}
public ActionResult Index([Bind(Include = "PersonLastName, PersonFirstName," +
"PersonEmail, PersonPhone")] Person formPerson)
{
BakeryEntities db = new BakeryEntities();
Person dbPerson = new Person();
dbPerson.PersonLastName = formPerson.PersonLastName;
dbPerson.PersonFirstName = formPerson.PersonFirstName;
dbPerson.PersonEmail = formPerson.PersonEmail;
dbPerson.PersonPhone = formPerson.PersonPhone;
dbPerson.PersonDateAdded = DateTime.Now;
db.People.Add(dbPerson);
db.SaveChanges();
return(View("Validation"));
}
public ActionResult Index([Bind(Include = "Email, Password")] LoginClass lc)
{
BakeryEntities db = new BakeryEntities();
int loginResult = db.usp_Login(lc.PersonEmail, lc.PersonPhone);
if (loginResult != -1)
{
var uid = (from r in db.People
where r.PersonEmail.Equals(lc.PersonEmail)
select r.PersonKey).FirstOrDefault();
int rKey = (int)uid;
Session["personKey"] = rKey;
MessageClass msg = new MessageClass();
msg.MessageText = "Thank You! You are now logged in as '" + lc.PersonEmail + "'.";
return(RedirectToAction("Result", msg));
}
MessageClass message = new MessageClass();
message.MessageText = "Invalid Login";
return(View("Result", message));
}
public ActionResult Index([Bind(Include = "PersonLastName, PersonEmail, PersonPhone")] LoginClass lc)
{ //connecting database
BakeryEntities db = new BakeryEntities();
Person p = new Person();
var email = (from pl in db.People
where pl.PersonLastName.Equals(lc.PersonLastName)
select pl.PersonEmail).FirstOrDefault();
var phone = (from pl in db.People
where pl.PersonLastName.Equals(lc.PersonLastName)
select pl.PersonPhone).FirstOrDefault();
if (lc.PersonEmail == email || lc.PersonPhone == phone)
{ //lookup user key
int uID = (from pl in db.People
where pl.PersonLastName.Equals(lc.PersonLastName) && (pl.PersonEmail.Equals(lc.PersonEmail) || pl.PersonPhone.Equals(lc.PersonPhone))
select pl.PersonKey).FirstOrDefault();
var FName = (from pl in db.People
where pl.PersonLastName.Equals(lc.PersonLastName) && (pl.PersonEmail.Equals(lc.PersonEmail) || pl.PersonPhone.Equals(lc.PersonPhone))
select pl.PersonFirstName).FirstOrDefault();
int eID = 0;
eID = (from e in db.Employees
where e.PersonKey == (uID)
select e.EmployeeKey).FirstOrDefault();
Session["EmployeeID"] = eID;
if (Session["EmployeeID"] != null)
{ //create a message class and pass the string to the result view
Message msg = new Message("Welcome " + FName + ", you can Operate the system now.");
return(RedirectToAction("Result", msg));
}
Message message1 = new Message("Invalid Employee Login");
return(View("Result", message1));
}
//if it fails pass this message to the result view
Message message = new Message("Invalid Login");
return(View("Result", message));
}
public ActionResult Index([Bind(Include = "UserName, Password, PersonKey")] LoginClass loginClass)
{
BakeryEntities db = new BakeryEntities();
loginClass.PersonKey = 0;
int result = db.usp_Login(loginClass.UserName, loginClass.Password);
Message msg = new Message();
if (result != -1)
{
var ukey = (from r in db.People
where r.PersonEmail.Equals(loginClass.UserName)
select r.PersonKey).FirstOrDefault();
loginClass.PersonKey = (int)ukey;
Session["NewPersonKey"] = loginClass.PersonKey;
msg.MessageText = "Welcome " + loginClass.UserName;
}
else
{
msg.MessageText = "Invalid Login";
}
return(View("Result", loginClass));
}
public ActionResult Index()
{
BakeryEntities db = new BakeryEntities();
return(View());
}
public ActionResult Index()
{
BakeryEntities db = new BakeryEntities();
return(View(db.Products.ToList()));
}
