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); }