 |
|
<%!
String firstname = new String(" ");
String lastname = new String(" ");
String country = new String(" ");
String State = new String(" ");
String city = new String(" ");
String address = new String(" ");
String company = new String(" ");
String email = new String(" ");
String phone = new String(" ");
String zip_code = new String(" ");
String userName = new String(" ");
String password = new String(" ");
String sql = new String(" ");
String sql1 = new String(" ");
String s=new String(" ");
String PreferredPayment=new String(" ");
String PaypalEmail=new String(" ");
String checkto=new String(" ");
String selectid=new String(" ");
String TypeId=new String(" ");
String hidden=new String(" ");
String usernamesql=new String(" ");
String checkusername=new String(" ");
int userinvalide = 0;
%>
<%
firstname=request.getParameter("first_name") ;
lastname=request.getParameter("last_name") ;
country = request.getParameter("country") ;
State=request.getParameter("state") ;
city=request.getParameter("city") ;
address=request.getParameter("address") ;
company=request.getParameter("company") ;
email=request.getParameter("email") ;
phone=request.getParameter("phone") ;
zip_code=request.getParameter("Zip-Code") ;
userName = request.getParameter("username") ;
password = request.getParameter("password") ;
hidden=request.getParameter("hidden");
PaypalEmail=request.getParameter("PaypalEmail");
checkto=request.getParameter("checkto");
if(firstname != "" && lastname != "" && country != "" && State != "" && city != "" && address != "" && company != "" && email != "" && phone != "" && zip_code != "" && userName != "" && password != "" && PreferredPayment != "")
{
/////////////////////////
//// This code for connection and making insertion in database
Connection myconn;
String DbDriver = "org.postgresql.Driver";
String DbConStr = "jdbc:postgresql://127.0.0.1/crm";
String DbUser ="revquest";
String DbPwd ="$$!!__TBRS13";
try
{
Integer s=0;
Class.forName(DbDriver);
myconn = DriverManager.getConnection(DbConStr, DbUser,DbPwd);
Statement mystat = myconn.createStatement();
try
{
if (userName !=null)
{
usernamesql="select crm_affiliate_user_name from crm_affiliate where crm_affiliate_user_name='"+userName+"'";
ResultSet uname;
uname = mystat.executeQuery(usernamesql);
if (uname.next())
{
%>
This user name is already used
<%
}
else
{
System.out.println("gowaaaaaaaaaaaaaaaa");
if(PaypalEmail !=null)
TypeId="1";
else
TypeId="2";
sql="insert into crm_affiliate (first_name,last_name,country,crm_affiliate_user_name,adress,company,affiliate_password,email,phone,city,state,zip_code,payment_type_iid) values ('"+firstname+"','"+lastname+"','"+country+"','"+userName+"','"+address+"','"+company+"','"+password+"','"+email+"','"+phone+"','"+city+"','"+State+"','"+zip_code+"','"+TypeId+"') ";
mystat.executeUpdate(sql);
try
{
usernamesql="select crm_affiliate_iid from crm_affiliate where crm_affiliate_user_name='"+userName+"'";
ResultSet rs;
rs = mystat.executeQuery(usernamesql);
System.out.println("gowaaaaaaaaaaaaaaaa22222");
while (rs.next())
{
System.out.println("rs nexxxxxxxxxxxxxxxxxxxxxxxxxxxt");
s = rs.getInt("crm_affiliate_iid");
}
}catch(SQLException e)
{
out.println("Exception insert type in paypal in select iid " + e);
}
try
{
sql1="insert into crm_payment_type (type_id,paypal_email,crm_affiliate_id) values (1,'"+PaypalEmail+"',"+s+")";
mystat.executeUpdate(sql1);
response.setStatus(301);
// response.setHeader( "Location", "http://localhost/login-affiliate.jsp" );
//response.setHeader( "Connection", "close" );
response.sendRedirect("login-affiliate.jsp");
}
catch(SQLException e)
{
out.println("Exception insert type in paypal grrrrrrrrrr " + e);
}
//else if(checkto != "")
//{
// TypeId="2";
// sql="insert into crm_affiliate (first_name,last_name,country,crm_affiliate_user_name,adress,company,affiliate_password,email,phone,city,state,zip_code,payment_type_iid) values ('"+firstname+"','"+lastname+"','"+country+"','"+userName+"','"+address+"','"+company+"','"+password+"','"+email+"','"+phone+"','"+city+"','"+State+"','"+zip_code+"','"+TypeId+"') ";
// mystat.executeUpdate(sql);
// try
// {
// usernamesql="select crm_affiliate_iid from crm_affiliate where crm_affiliate_user_name='"+userName+"'";
// ResultSet rs;
// rs = mystat.executeQuery(usernamesql);
// while (rs.next())
// {
// s = rs.getInt("crm_affiliate_iid");
// }
// }
// catch(SQLException e)
// {
// out.println("Exception insert type in paypal in select iid " + e);
// }
// try
// {
// sql1="insert into crm_payment_type (type_id,check_for,crm_affiliate_id) values (2,'"+checkto+"',"+s+")";
// mystat.executeUpdate(sql1);
// response.sendRedirect("login-affiliate.jsp");
// }
// catch(SQLException e)
// {
// out.println("Exception insert type in check " + e);
// }
// response.setStatus(301);
// response.setHeader( "Location", "http://localhost/login-affiliate.jsp" );
// response.setHeader( "Connection", "close" );
// }
//else
//{
//}
}
}
myconn.close();
} catch (SQLException e) {
// out.println("Exception whole insert " +e );
}
//////////////////////
//// End of isertion in database
}
catch (SQLException e)
{}
}
else
{
}
%>
|
 |
|
| Why Salesboom?
|
Thousands of companies around the world depend on Salesboom to effectively manage their business and streamline operations across all departments in real time, everyday. Salesboom on demand customer facing and back office solutions are the most user friendly, feature rich and honestly priced, today.
|
 |
Comprehinsive CRM & ERP |
| |
99.8% Uptime Guarantee |
| |
Over 3500 customers in 159 countries. |
| |
1200+ Features |
| |
Success Stories |
| |
Comprehinsive CRM & ERP |
| |
99.8% Uptime Guarantee |
| |
Over 3500 customers in 159 countries. |
| |
1200+ Features |
| |
Marketing, Sales, Service, Accounting and HR |
| |
Industry leading adoption rates |
| |
Free upgrades with each release 5 times/year |
| |
Free training and support |
| |
98% customer satisfaction rate. |
| |
Complete customizable CRM & ERP |
|
|
|
 |
 |
| Success Stories |
"When comparing Salesboom to other
CRM platforms it was clear to us that
Salesboom’s technology vastly surpasses
that of its competitors."
Salesboom On Demand CRM has made
the transition from desktop CRM to
hosted Service as a Software seamless.
We are very impressed with the ease of
use and content management
capabilities, in addition Salesboom staff
have been very responsive and
forthcoming with answers and tips to
help use adopt the system. We look
forward to building our business with
Salesboom and are happy with the
decision we made.
"After a recent review of our CRM
system we decided to switch to a more
convenient and cost-effective hosted
solution. We looked at the services and
pricing of numerous CRM software
providers. We found the value offered
by Salesboom.com to be unmatched by
any of their competitors, and after a
one-month evaluation we were
convinced that it was the right choice
for us. From the start, salesboom.com
consultants have provided us with
outstanding service and continue to
help us get the most out of the
program for our business."
|
|
 |
|
| Salesboom In the News |
Salesboom.com CEO, Troy Muise speaks
about Customer Retention at the 2008
SIIA On Demand CRM Conference
Salesboom Lands Two Spots on 2007's
Top 15 CRM Innovations
Salesboom CEO is Among Top CRM
Influencer's of 2007
|
|
|
|
