public static Response redirection(Request req)
{
Response res;
Console.WriteLine("[Database Flag]: " + req.Flag);
switch (req.Flag)
{
//create account
case 0:
res = Sql.CreateAccount((CreateAccount)req.Data);
break;
case 1:
res = Sql.LoginAccount((LoginAccount)req.Data);
break;
case 2:
res = Sql.RetrieveUserDetails((User)req.Data);
break;
case 3:
res = Sql.UpdateUserObjDetails((User)req.Data);
break;
case 4:
res = Sql.ChangePassword((ChangePassword)req.Data);
break;
case 5:
res = Sql.UpdateUserForgetPasswordDetails((UpdateUserForgetPasswordDetails)req.Data);
break;
//credit card
case 6:
res = Sql.AddCreditCard((AddCreditCard)req.Data);
break;
case 7:
res = Sql.DeleteCreditCard((CreditCard)req.Data);
break;
case 8:
res = Sql.CreateWishList((WishList)req.Data);
break;
case 9:
res = Sql.CreateHouseBackup((House)req.Data);
break;
case 10:
res = Sql.CreateHouse((House)req.Data);
break;
case 11:
res = Sql.DeleteHouse((House)req.Data);
break;
case 12:
res = Sql.UpdateHouse((House)req.Data);
break;
case 13:
res = Sql.RetrieveHouseDetails((House)req.Data);
break;
case 14:
res = Sql.CreateFeedback((Feedback)req.Data);
break;
case 15:
res = Sql.RetrieveFeedback((Feedback)req.Data);
break;
case 16:
res = Sql.CreateBooking((Booking)req.Data);
break;
case 17:
res = Sql.DeleteBooking((Booking)req.Data);
break;
case 18:
res = Sql.RetrieveBookingViaHost((House)req.Data);
break;
case 19:
res = Sql.RetrieveBookingViaClient((Booking)req.Data);
break;
case 20:
res = Sql.RetrieveHouseViaCountry((House)req.Data);
break;
case 21:
res = Sql.RetrieveHouseViaDate((Booking)req.Data);
break;
case 22:
res = Sql.CreateChat((Booking)req.Data);
break;
case 23:
//res = Sql.CreateMessage((MessageData)req.Data);
res = null;
break;
case 24:
//res = Sql.RetrieveMessage((Chat)req.Data);
res = null;
break;
case 25:
res = Sql.RetrieveCreditCard((CreditCard)req.Data);
break;
case 26:
res = Sql.RetrieveWishList((WishList)req.Data);
break;
case 27:
//res = Sql.RetrieveChat((Chat)req.Data);
res = null;
break;
case 28:
res = Sql.RetrieveHouseDisplay((SearchBooking)req.Data);
break;
case (int)Constants.Database.RetrieveIndividualHouseDisplay:
res = Sql.RetrieveIndividualHouseDisplay((SearchBooking)req.Data);
break;
case (int)Constants.Database.RetrieveHouseViaHost:
res = Sql.RetrieveHouseViaHost((User)req.Data);
break;
case (int)Constants.Database.RetrieveUserDetailsViaUsername:
res = Sql.RetrieveUserDetailsViaUsername((User)req.Data);
break;
case (int)Constants.Database.CreateUserLog:
res = Sql.CreateUserLog((User)req.Data);
break;
case (int)Constants.Database.CheckLockAccount:
res = Sql.CheckLockAccount((CheckAccountLock)req.Data);
break;
case (int)Constants.Database.RetrieveChatList:
res = Sql.RetrieveChatList((Chat)req.Data);
break;
case (int)Constants.Database.GetNoOfUserInChat:
res = Sql.GetNoOfUserInChat((Chat)req.Data);
break;
case (int)Constants.Database.CheckForConnectionId:
res = Sql.CheckForConnectionId((Chat)req.Data);
break;
case (int)Constants.Database.InsertConnectionId:
res = Sql.InsertConnectionId((Chat)req.Data);
break;
case (int)Constants.Database.RetrieveUserChatCredential:
res = Sql.RetrieveUserChatCredential((Chat)req.Data);
break;
case (int)Constants.Database.RetriveChatMessage:
res = Sql.RetriveChatMessage((Chat)req.Data);
break;
case (int)Constants.Database.InsertChatMessage:
res = Sql.InsertChatMessage((EncryptMessage)req.Data);
break;
//case 22:
// res = Sql.LoginAccountviaEmail((LoginAccountviaEmail)req.Data);
// break;
/*
* case 19:
* res = Sql.RetrieveBookingViaClient((RetrieveBookingViaClient)req.Data);
* break;//update account details
* case 20:
* res = Sql.RetrieveCreditCard(req.Data);
* break;
* //add credit card to account
*
* //remove credit card
*
* //create wish list
*
* //update wishlist
* case 6:
* res= Sql.UpdateWishList(req.Data);
* break;
* //create host backup for halfway filled form
*
* //delete hostbackup once create house is created
*
* //create house
*
* //update details on the house
*
* //delete house when not in use
*
* //feedback for users who stayed in the house
*
* //booking for users
* case 13:
* res = Sql.CreateBooking(req.Data);
* break;
* //delete booking
*
* //update booking incase of any changes (HOST MUST ALLOW BEFORE UPDATE)
* case 15:
* res = Sql.UpdateBooking(req.Data);
* break;
* //select user
* case 16:
* res = Sql.SelectUserAcc(req.Data);
* break;
* //retrieve host backup
* case 17:
* res = Sql.RetrieveHostBackup(req.Data);
* break;
* //retrieve booking
* case 18:
* res = Sql.RetrieveBooking(req.Data);
* break;
* //retrieve house
*
* //retrieve credit card
*/
default:
Console.WriteLine("[Flag not exist]");
res = null;
break;
}
return(res);
}
