public void setProccess()
{
switch (processName)
{
case "users":
//the Sql query strings on this class could have been procedure,
//but because of host does not allow procedures and trigers
users.setUsers("SELECT * FROM user"); //procedure sould have been: view_users()
this.feedback_JArray = users.getUsers();
break;
case "check_users_existance":
/*
* since email address is unique to everty user
* the following code uses the unique identifier email
* to check for the user's existance
*/
users.CheckUserExist(email);
this.feedback_JArray = JArray.Parse("[{\"exist\":\"" + users.getExistance() + "\"}]");
break;
case "login":
users.setUsers("SELECT * FROM `user` WHERE password='******' AND email='" + email + "'");
this.feedback_JArray = users.getUsers();
/*
* if user exist session contoller check if session already created
* if session does not contain user append user to a session using sessionModel
* else do nothing
*/
break;
case "register":
if (users.getExistance() == false)
{
response = users.RegisterUser("SELECT * FROM booking");//refactor to be insert statement
this.feedback_JArray = JArray.Parse("[{\"response\":\"registered " + response + "\"}]");
}
else
{
this.feedback_JArray = JArray.Parse("[{\"response\":\"user already exists\"}]");
}
break;
case "styles":
//get from the database table all styles
styles.setStyles("SELECT * FROM styles");
this.feedback_JArray = styles.getStyles();
break;
case "bookings":
//get from the database table all the bookings made
styles.setStyles("SELECT * FROM styles");
booking.stylesArray = styles.getStyles();
booking.setBooking("SELECT * FROM booking"); //to minmise the load i would filter by dates between x AND y
this.feedback_JArray = booking.getBooking();
break;
case "book":
//insert values to database table
// users.CheckUserExist(email);
// if (users.getExistance() == false)
// {
response = booking.insertBooking(userid, styleid, date, time);
// }
// else
// {
// response = "user already exists";
// }
this.feedback_JArray = JArray.Parse("[{\"response\":\"booked " + response + "\"}]");
break;
default:
this.feedback_JArray = null;
break;
}
}
