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)
