%
if session("login")="" then
response.redirect "default.asp"
end if
set conn=server.createobject("ADODB.connection")
path=server.mappath("../database/sol.mdb")
conn.open "driver={Microsoft Access Driver (*.mdb)}; dbq=" & path & "; uid=admin"
if request("action")="Submit" then
FUNCTION fixQuotes( ByVal theString )
fixQuotes = Replace( theString, "'", "''" )
END FUNCTION
cat=request("Cat")
subcat=request("subcat")
prodname=request("ProdName")
proddesc=request("ProdDesc")
location=request("Loc")
price=request("price")
mysql1="select count(*) from purchase WHERE (login='" &session("login")& "')"
set rs=conn.execute(mysql1)
if (rs(0)<5) then
mysql="select * from MLogin where(Login='" &session("login") &"')"
set rs1=conn.execute(mysql)
mysql2="select * from purchase WHERE (status='yes' AND login='" &session("login")& "')"
set rs2=conn.execute(mysql2)
if rs2.eof then
status="no"
mysql2="insert into purchase(login,name,email,category,subcategory,product,description,location,price,entrydate,status) values('"& session("login") &"','" &rs1("FName")&"','" &rs1("EMail")&"','"&cat&"','"&subcat&"','"& fixQuotes(prodname)&"','"& fixQuotes(proddesc)&"','"& location &"','"& price &"','" &date() &"','"& status &"') "
conn.execute(mysql2)
mailbody = "Thanks for your interest in suratonline buy & sell section
"
mailbody = mailbody & "your user id is : " &rs1("Login")& "
"
mailbody = mailbody & "your password is : " &rs1("Password")& "
"
mailbody = mailbody & "Please remember your id and password
"
mailbody = mailbody & "You have to enable your requirements through this link :
"
mailbody = mailbody & "http://www.suratonline.com/business/mailconfirm.asp?loginid=" &session("login")&""
set mails=server.createobject("JMail.SMTPMail")
mails.ServerAddress="210.212.217.209:25"
mails.Sender="team4suratonline@yahoo.com"
mails.AddRecipient rs1("EMail")
mails.Priority=3
mails.Subject="Regarding your purchase from suratonline"
mails.ContentType ="text/html"
mails.ISOEncodeHeaders = false
mails.ContentTransferEncoding = "8bit"
mails.Body=mailbody
mails.Execute
set mails=nothing
response.write "Thanks for providing your Product requirements,Please check your mail to activate your requirements."
else
status="yes"
mysql2="insert into purchase(login,name,email,category,subcategory,product,description,location,price,entrydate,status) values('"& session("login") &"','" &rs1("FName")&"','" &rs1("EMail")&"','"&cat&"','"&subcat&"','"& fixQuotes(prodname)&"','"& fixQuotes(proddesc)&"','"& location &"','"& price &"','" &date() &"','"& status &"') "
conn.execute(mysql2)
mailbody = "Thanks for your interest in suratonline buy & sell section
"
mailbody = mailbody & "Your product requirements have been successfully uploaded.Be in touch with Suratonline,the complete portal.you can contact us for any of your suggetions regarding suratonline"
mailbody = mailbody & "Your views & ideas will be helpful for us."
set mails=server.createobject("JMail.SMTPMail")
mails.ServerAddress="210.212.217.209:25"
mails.Sender="team4suratonline@yahoo.com"
mails.AddRecipient rs1("EMail")
mails.Priority=3
mails.Subject="Regarding your purchase from suratonline"
mails.ContentType ="text/html"
mails.ISOEncodeHeaders = false
mails.ContentTransferEncoding = "8bit"
mails.Body=mailbody
mails.Execute
set mails=nothing
end if
else
response.redirect"purchaseadmin.asp"
end if
end if
%>
SuratOnline.Com - 2nd Sale Help
|
|
 |
|
|
|
2nd
Sell Help Page
|
Welcome to Suratonline 2nd Sell Section.We
appreciate Your efforts towards Suratonline 2nd Sell. The
Concept here is too simple. You can put your Products for
the Sell, as well as you can also buy your required products
too from suratonline 2nd Sell.
Just "Login" before going to any section of 2nd
Sell,just login yourself, if you are a new member, register
yourself as a new user. Remember Your user id &
password there.
As per the Sell section is concerned, Simply Submit the
Form, the form requires your Product Name, Description,
Category (categorize your product Belongs to), Subcategory
(subcategory will show products according to your selected
category, choose your required product).
The main thing is the photograph for your products, you
can submit your product photograph according to category,
or you can select the default photograph, it will
take the default photograph as per the category, that is
upto you. Also the price will be the important factor, you
just give the Minimum Price you want from your product.
After submssion you will get the E-mail from Suratonline,just
check that mail to enable your products in sell,
Untill & Unless your Products will not be visible
to users..
If someone found your required item he can mail you,just
directy, Buy your Required products easily without any hard
work only through Suratonline 2nd-Sell.
The main thing as per the 2nd Sell, Max. Products Limit
for any of the section (Buy/Sell). You can put the Max.
of 5 Products, if you want to add new products in
sell delete any of your previous Products through your own
admin that will be activated only through Suratonline when
you want to access your produts limit more than Defined
(5).
The
easiest way to sell & purchase 2nds & new is only
suratonline
So,
ENJOY
YOUR SHOPPING MALL ONLY @ SURATONLINE.COM
|
|
|
|
|
|