def customerFeedback(self, feedback): global customerId try: response = CustomerDetailsTemp.query.filter_by( customerPhone=feedback.get('customerPhone')).first() from utility.utilities import generateUniqueId if response is None: customerDetails = CustomerDetailsTemp( str(generateUniqueId()), feedback.get('customerName'), feedback.get('customerEmail'), feedback.get('customerPhone'), feedback.get('cookName')) customerId = str(generateUniqueId()) comment = Feedback(customerId, customerDetails.id, feedback.get('feedback')) self.session.add(customerDetails) self.session.add(comment) else: customerId = response.id comment = Feedback(str(generateUniqueId()), customerId, feedback.get('feedback')) self.session.add(comment) self.session.commit() cust = CustomerDetailsTemp.query.filter_by( customerPhone=feedback.get('customerPhone')).first() return self.transformer.transformReviewInsert( cust, Constants.STATUS_SUCCESS, Constants.SUCCESS_CODE) except Exception as e: return self.exceptionTransformer.transformException( Constants.DATABASE_ERROR, e.message, Constants.STATUS_FAILED)
def insertUserInCareers(self, userCareer): from utility.utilities import generateUniqueId from models.models import Careers phone = userCareer.get('phone') email = userCareer.get('email') career = Careers(str(generateUniqueId()), userCareer.get('name'), email, phone, userCareer.get('role')) return self.dbConnection.insertUserInCareers(career)
def registerUser(self, userDetails): userType = userDetails.get('user') if (userType == 'admin'): from models.models import AdminUser adminUser = AdminUser(str(generateUniqueId()), userDetails.get('name'), userDetails.get('email'), userDetails.get('password')) return self.dbConnection.registerUser(adminUser)
def registerUser(self, registerUserData): userType = registerUserData.get('user') if userType == Constants.ADMIN_USER: from models.models import AdminUser adminUser = AdminUser(str(generateUniqueId()), registerUserData.get('name'), registerUserData.get('email'), registerUserData.get('password'), userType) return self.dbConnection.registerUser(adminUser)
def insertContactUsDetails(self, contactUsDetails): from utility.utilities import validateEmail, validatePhoneNumber, generateUniqueId # isEmailValidated = validateEmail(contactUsDetails.get('email')) # isPhoneValidated = validatePhoneNumber(contactUsDetails.get('phone')) from models.models import ContactUs contactUsModel = ContactUs(str(generateUniqueId()), contactUsDetails.get('name'), contactUsDetails.get('email'), contactUsDetails.get('phone')) return self.dbConnection.insertContactUsDetails(contactUsModel)
def bookACook(self, cookBookingDetails): from utility.utilities import validateEmail, generateUniqueId from models.models import TemporaryBooking, OcassionsBooking isRequiredInMorning = False isRequiredInEvening = False if (cookBookingDetails.get('isRequiredInMorning') == 'yes'): isRequiredInMorning = True if (cookBookingDetails.get('isRequiredInEvening') == 'yes'): isRequiredInEvening = True bookingFor = cookBookingDetails.get('bookingfor') if (bookingFor == 'household'): bookACook = TemporaryBooking( str(generateUniqueId()), cookBookingDetails.get('customerName'), cookBookingDetails.get('customerLocation'), cookBookingDetails.get('customerPhone'), cookBookingDetails.get('customerEmail'), cookBookingDetails.get('cookPreference'), isRequiredInMorning, isRequiredInEvening, cookBookingDetails.get('numberOfMembers'), cookBookingDetails.get('pincode'), cookBookingDetails.get('city'), cookBookingDetails.get('state'), cookBookingDetails.get('address'), cookBookingDetails.get('alternatePhoneNo')) elif (bookingFor == 'ocassion'): bookACook = OcassionsBooking( str(generateUniqueId()), cookBookingDetails.get('customerName'), cookBookingDetails.get('customerLocation'), cookBookingDetails.get('customerPhone'), cookBookingDetails.get('customerEmail'), cookBookingDetails.get('cookPreference'), isRequiredInMorning, isRequiredInEvening, cookBookingDetails.get('numberOfMembers'), cookBookingDetails.get('pincode'), cookBookingDetails.get('city'), cookBookingDetails.get('state'), cookBookingDetails.get('address'), cookBookingDetails.get('alternatePhoneNo')) return self.dbConnection.bookACook(bookACook)
def subscribe(self, subscribedUser): from utility.utilities import validateEmail, generateUniqueId isEmailValidated = validateEmail(subscribedUser.get('email')) if (isEmailValidated): from models.models import SubscribedUser subscriptionData = SubscribedUser(str(generateUniqueId()), subscribedUser.get('email'), True) return DBOperations().susbscribe(subscriptionData) else: return ExceptionTransformers().transformExceptionSubcribedUser( Constants.INVALID_INPUT, Constants.INVALID_EMAIL, Constants.STATUS_FAILED)
def insertContactUsDetails(self, contactUsDetails): from utility.utilities import validateEmail, validatePhoneNumber, generateUniqueId isEmailValidated = validateEmail(contactUsDetails.get('email')) # isPhoneValidated = validatePhoneNumber(contactUsDetails.get('phone')) if isEmailValidated: from models.models import ContactUs contactUsModel = ContactUs(str(generateUniqueId()), contactUsDetails.get('name'), contactUsDetails.get('email'), contactUsDetails.get('phone')) return self.dbConnection.insertContactUsDetails(contactUsModel) else: return ExceptionTransformers().transformExceptionContactUs( Constants.INVALID_INPUT, Constants.INVALID_EMAIL, Constants.STATUS_FAILED)
def addCookDetails(self, cookBasic): from utility.utilities import generateUniqueId, generateCompanyId from models.models import CookBasicDetails lengthOfTable = self.dbConnection.getLengthOfTable(CookBasicDetails) companyId = str(generateCompanyId(lengthOfTable)) cookBasicDetails = CookBasicDetails(str(generateUniqueId()), companyId, cookBasic.get('name'), cookBasic.get('phone'), cookBasic.get('email'), cookBasic.get('joiningDate'), cookBasic.get('nativePlace'), cookBasic.get('currentPlace'), cookBasic.get('experience'), cookBasic.get('cookStatus'), cookBasic.get('leavingDate'), cookBasic.get('dob'), cookBasic.get('gender')) return (self.dbConnection.addCookBasicDetais(cookBasicDetails))
def subscribe(self, subscribedUser): from utility.utilities import validateEmail, generateUniqueId from models.models import SubscribedUser subscriptionData = SubscribedUser(str(generateUniqueId()), subscribedUser.get('email'), True) return DBOperations().susbscribe(subscriptionData)