List createLead(LeadEntryForm lform, String cse, String SalesId) throws SQLException, Exception {
LeadVO objLeadVO = new LeadVO();
objLeadVO.setBroadbandtype(lform.getBroadbandtype());
objLeadVO.setCNICid(lform.getCNICid());
objLeadVO.setChanneltype(lform.getChanneltype());
objLeadVO.setContactnumber(lform.getContactnumber());
objLeadVO.setWillingPay(lform.getDialup());
objLeadVO.setEmail(lform.getEmail());
objLeadVO.setFirstname(lform.getFirstname());
objLeadVO.setJobtitle(lform.getJobtitle());
objLeadVO.setLastname(lform.getLastname());
objLeadVO.setLeadsource(lform.getLeadsource());
objLeadVO.setMonthlyspend(lform.getMonthlyspend());
objLeadVO.setNameofISP(lform.getNameofISP());
// objLeadVO.setReqISP(lform.getReqISP());
objLeadVO.setOccupation(lform.getOccupation());
objLeadVO.setPackageinfo(lform.getPackageinfo());
objLeadVO.setPriority(lform.getPriority());
objLeadVO.setQuery(lform.getQuery());
objLeadVO.setSalutation(lform.getSalutation());
objLeadVO.setServicetype(lform.getServicetype());
objLeadVO.setCurrentSpeed(lform.getSpeed());
// objLeadVO.setPlot(lform.getPlot());
// objLeadVO.setStreet(lform.getStreet());
objLeadVO.setSubzone(lform.getSubzone());
objLeadVO.setOthersubzone(lform.getOthersubzone());
objLeadVO.setZone(lform.getZone());
objLeadVO.setOtherzone(lform.getOtherzone());
objLeadVO.setCity(lform.getCity());
objLeadVO.setProvince(lform.getProvince());
objLeadVO.setCountry(lform.getCountry());
objLeadVO.setZip(lform.getZip());
objLeadVO.setVolumelimit(lform.getVolumelimit());
objLeadVO.setLeadaddress(lform.getLeadaddress());
objLeadVO.setReasonId(lform.getReasonId());
objLeadVO.setTransitionState(lform.getTransitionState());
objLeadVO.setReasonCode(lform.getReasonCode());
objLeadVO.setReasonComment("Created");
objLeadVO.setReferredBy(lform.getReferredBy());
WitribeBO objBO = new WitribeBO();
List status = objBO.createLead(objLeadVO, cse, SalesId);
return status;
// return true;
}
LeadVO checkDuplicateLead(LeadEntryForm lform) throws SQLException, Exception {
LeadVO objLeadVO = new LeadVO();
objLeadVO.setBroadbandtype(lform.getBroadbandtype());
objLeadVO.setCNICid(lform.getCNICid());
objLeadVO.setChanneltype(lform.getChanneltype());
objLeadVO.setContactnumber(lform.getContactnumber());
objLeadVO.setWillingPay(lform.getDialup());
objLeadVO.setEmail(lform.getEmail());
objLeadVO.setFirstname(lform.getFirstname());
objLeadVO.setJobtitle(lform.getJobtitle());
objLeadVO.setLastname(lform.getLastname());
objLeadVO.setLeadsource(lform.getLeadsource());
objLeadVO.setMonthlyspend(lform.getMonthlyspend());
objLeadVO.setNameofISP(lform.getNameofISP());
// objLeadVO.setReqISP(lform.getReqISP());
objLeadVO.setOccupation(lform.getOccupation());
objLeadVO.setPackageinfo(lform.getPackageinfo());
objLeadVO.setPriority(lform.getPriority());
objLeadVO.setQuery(lform.getQuery());
objLeadVO.setSalutation(lform.getSalutation());
objLeadVO.setServicetype(lform.getServicetype());
objLeadVO.setCurrentSpeed(lform.getSpeed());
// objLeadVO.setPlot(lform.getPlot());
// objLeadVO.setStreet(lform.getStreet());
objLeadVO.setSubzone(lform.getSubzone());
objLeadVO.setOthersubzone(lform.getOthersubzone());
objLeadVO.setZone(lform.getZone());
objLeadVO.setOtherzone(lform.getOtherzone());
objLeadVO.setCity(lform.getCity());
objLeadVO.setProvince(lform.getProvince());
objLeadVO.setCountry(lform.getCountry());
objLeadVO.setZip(lform.getZip());
objLeadVO.setVolumelimit(lform.getVolumelimit());
objLeadVO.setLeadaddress(lform.getLeadaddress());
WitribeBO objBO = new WitribeBO();
LeadVO duplicateLeadVo = objBO.checkDuplicateLead(objLeadVO);
return duplicateLeadVo;
// return true;
}