protected void Page_Load(object sender, EventArgs e)
{
loginwebservice.login1 s1 = new loginwebservice.login1();
string[] b = new string[10];
string main_name = Session["main_name"].ToString();
b = s1.user_retrieve(main_name);
name.Text = b[0];
contact.Text = b[2];
email.Text = b[1];
zipcode.Text = b[3];
/*
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbString"].ConnectionString);
//Open the connection
conn.Open();
string[] b = new string[10];
string main_name = Session["main_name"].ToString();
SqlCommand cmd = new SqlCommand("select * from registration where name='" + main_name + "' ", conn);
SqlDataReader r = cmd.ExecuteReader();
while (r.Read())
{
name.Text = r["name"].ToString();
contact.Text = r["contactno"].ToString();
zipcode.Text = r["zipcode"].ToString();
email.Text = r["email"].ToString();
}
cmd.Dispose();
conn.Close();
* */
}
protected void register_Click(object sender, EventArgs e)
{
loginwebservice.login1 s1 = new loginwebservice.login1();
string emailid = email.Text;
string cat1 = cat.SelectedValue;
int a = s1.vendor_reg(name.Text, email.Text, password.Text, contactno.Text, zipcode.Text, street.Text, city.Text, officetiming.Text, cat1);
if (a == 1)
{
Label1.Visible = true;
Label1.Text = "Registration successful";
//Response.Redirect("login.aspx");
}
else if (a == -1)
{
Label1.Visible = true;
Label1.Text = "Email already exists";
}
else
{
Label1.Visible = true;
Label1.Text = "Registration failure";
}
/*
string name1 = name.Text;
string email1 = email.Text;
string password1 = password.Text;
string contactno1 = contactno.Text;
string zipcode1 = zipcode.Text;
string city1 = city.Text;
string street1 = street.Text;
string time1 = officetiming.Text;
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbString"].ConnectionString);
//Open the connection
conn.Open();
SqlCommand cmd = new SqlCommand("insert into vendor (vname,vemail,vpassword,vcontactno,vzipcode,vcity,vstreet,vtime) values('" + name1 + "','" + email1 + "','" + password1 + "','" + contactno1 + "','" + zipcode1 + "','" + city1 + "','" + street1 + "','" + time1 + "')", conn);
int result = cmd.ExecuteNonQuery();
Label1.Visible = true;
if (result != 0)
{
Label1.Text = "Registration successful";
// Response.Redirect("login.aspx");
}
else
{
Label1.Text = "Registration Failed";
}
conn.Close();
* */
}
protected void register_Click(object sender, EventArgs e)
{
loginwebservice.login1 s1 = new loginwebservice.login1();
int a = s1.user_reg(name.Text, email.Text, password.Text, contactno.Text, zipcode.Text);
if (a == 1)
{
Label1.Visible = true;
Label1.Text = "Registration successful";
//Response.Redirect("login.aspx");
}
else if (a == -1)
{
Label1.Text = "Email already exists";
}
else
{
Label1.Text = "Registration failed";
}
/*
string name1 = name.Text;
string email1 = email.Text;
string password1 = password.Text;
string contactno1 = contactno.Text;
string zipcode1 = zipcode.Text;
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbString"].ConnectionString);
//Open the connection
conn.Open();
SqlCommand cmd = new SqlCommand("insert into registration (name,email,password,contactno,zipcode) values('" + name1 + "','" + email1 + "','" + password1 + "','" + contactno1 + "','" + zipcode1 + "')", conn);
int result = cmd.ExecuteNonQuery();
Label1.Visible = true;
if (result != 0)
{
Label1.Text = "Registration successful";
// Response.Redirect("login.aspx");
}
else
{
Label1.Text = "Registration Failed";
}
cmd.Dispose();
conn.Close();
* */
}
protected void user_click(object sender, EventArgs e)
{
loginwebservice.login1 s1 = new loginwebservice.login1();
int a = s1.user_login_check(name.Text, password.Text, 0);
string name1 = name.Text;
if (a == 1)
{
Label3.Visible = true;
Session["main_name"] = name1;
Label3.Text = "Login successful";
Response.Redirect("userProfile.aspx");
}
else
{
Label3.Visible = true;
Label3.Text = "Login Failed";
}
/*
string name1 = name.Text;
string password1 = password.Text;
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbString"].ConnectionString);
//Open the connection
conn.Open();
SqlCommand cmd = new SqlCommand("select name,password from registration where name='" + name1 + "' and password='******'" , conn);
string CurrentName;
CurrentName = (string)cmd.ExecuteScalar();
Label3.Visible = true;
if (CurrentName != null)
{
Label3.Text = "Login successful";
Session["main_name"] = name1;
Response.Redirect("userProfile.aspx");
}
else
{
Label3.Text = "Login Failed! Please check the login name/password !";
}
cmd.Dispose();
conn.Close(); */
}
protected void Page_Load(object sender, EventArgs e)
{
loginwebservice.login1 s1 = new loginwebservice.login1();
string[] b = new string[10];
//string emailid = Session["main_res"].ToString();
string main_vname = Session["main_vname"].ToString();
b = s1.vendor_retrieve(main_vname);
name.Text = b[0];
email.Text = b[1];
contact.Text = b[2];
zipcode.Text = b[3];
street.Text = b[4];
city.Text = b[5];
time.Text = b[6];
service.Text = b[7];
/*
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbString"].ConnectionString);
//Open the connection
conn.Open();
string[] b = new string[10];
string main_vname = Session["main_vname"].ToString();
SqlCommand cmd = new SqlCommand("select * from vendor where vname='" + main_vname + "' ", conn);
SqlDataReader r = cmd.ExecuteReader();
while (r.Read())
{
name.Text = r["vname"].ToString();
contact.Text = r["vcontactno"].ToString();
zipcode.Text = r["vzipcode"].ToString();
email.Text = r["vemail"].ToString();
city.Text = r["vcity"].ToString();
street.Text = r["vstreet"].ToString();
time.Text = r["vtime"].ToString();
}
cmd.Dispose();
conn.Close();*/
}
protected void Page_Load(object sender, EventArgs e)
{
string v1 = "";
v1 = Request.QueryString["vendor_name"];
string[] f = new string[10];
//Declare Connection by passing the connection string from the web config file
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbString"].ConnectionString);
//Open the connection
conn.Open();
//Declare the sql command
SqlCommand cmd1 = new SqlCommand("select * from photo where vname='" + v1 + "'", conn);
SqlDataReader reader = cmd1.ExecuteReader();
while (reader.Read())
{
style.Text = reader["style"].ToString();
package.Text = reader["package"].ToString();
employee.Text = reader["employee"].ToString();
album.Text = reader["album"].ToString();
media.Text = reader["media"].ToString();
insurance.Text = reader["insurance"].ToString();
fee.Text = reader["fee"].ToString();
}
cmd1.Dispose();
conn.Close();
try
{
loginwebservice.login1 l1 = new loginwebservice.login1();
string[] a = l1.vendor_retrieve(v1);
name.Text = a[0];
contact.Text = a[3];
street.Text = a[4];
city.Text = a[5];
zipcode.Text = a[1];
service1.Text = a[7];
timings.Text = a[6];
gimg.Text = "<a class='details' data-fancybox-type='iframe' href='http://maps.google.com/?output=embed&f=q&source=s_q&hl=en&geocode=&q=" + street.Text + "," + city.Text + "," + zipcode.Text + "'><img src='images/google-map.png'></a>";
loginwebservice.login1 l2 = new loginwebservice.login1();
ArrayList b = new ArrayList(l2.vendor_try(v1));
ArrayList c = new ArrayList();
c = (ArrayList)b;
string[,] data = new string[100, 4];
int iterator = 0;
foreach (string d in c)
{
string[] row = d.Split('^');
data[iterator, 0] = row[0];
data[iterator, 1] = row[1];
data[iterator, 2] = row[2];
data[iterator, 3] = row[3];
iterator++;
}
DataTable newsDataTable = new DataTable();
// add some columns to our datatable
newsDataTable.Columns.Add("vname");
newsDataTable.Columns.Add("vzipcode");
newsDataTable.Columns.Add("vemail");
newsDataTable.Columns.Add("vcontactno");
// adding new rows
for (int i = 0; i < iterator; i++)
{
DataRow newsDataRow = newsDataTable.NewRow();
newsDataRow["vname"] = data[i, 0];
newsDataRow["vzipcode"] = data[i, 1];
newsDataRow["vemail"] = data[i, 2];
newsDataRow["vcontactno"] = data[i, 3];
newsDataTable.Rows.Add(newsDataRow);
}
//Label1.Text = "<a title='Send Mail to Restaurant' href='mailto:" + param1 + "'><img src ='images/email-to.png'></a>";
// bind our datatable to our repeater
category.DataSource = newsDataTable;
category.DataBind();
}
catch (Exception e1)
{
//error.Visible = true;
//error.Text = "error";
//int abc = 1;
}
}
protected void vendor_click(object sender, EventArgs e)
{
string name2 = name.Text;
string password2 = password.Text;
/* SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbString"].ConnectionString);
//Open the connection
conn.Open();
SqlCommand cmd = new SqlCommand("select vname,vpassword from vendor where vname='" + name2 + "' and vpassword='******'" , conn);
string CurrentName;
CurrentName = (string)cmd.ExecuteScalar();
Label3.Visible = true;
if (CurrentName != null)
{
Label3.Text = "Login successful";
Session["main_vname"] = name2;
Response.Redirect("vendorProfile.aspx");
}
else
{
Label3.Text = "Login Failed! Please check the login name/password !";
}
cmd.Dispose();
conn.Close(); */
loginwebservice.login1 s1 = new loginwebservice.login1();
int a = s1.user_login_check(name.Text, password.Text, 1);
string[] b = new string[10];
if (a == 1)
{
Label3.Visible = true;
Session["main_vname"] = name2;
Label3.Text = "Login successful";
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbString"].ConnectionString);
//Open the connection
conn.Open();
//Declare the sql command
SqlCommand cmd1 = new SqlCommand("select * from vendor where vname ='" + name2 + "' ", conn);
SqlDataReader reader = cmd1.ExecuteReader();
while (reader.Read())
{
b[0] = reader["vname"].ToString();
b[2] = reader["vemail"].ToString();
b[3] = reader["vcontactno"].ToString();
b[1] = reader["vzipcode"].ToString();
b[4] = reader["vstreet"].ToString();
b[5] = reader["vcity"].ToString();
b[6] = reader["vtime"].ToString();
b[7] = reader["vservice"].ToString();
}
cmd1.Dispose();
conn.Close();
if (b[7] == "Catering" || b[7] == "Theme")
{
Response.Redirect("vendorProfile.aspx");
}
else if (b[7] == "Venue")
{
Response.Redirect("vp1.aspx");
}
else if (b[7] == "Photography")
{
Response.Redirect("vp2.aspx");
}
}
else
{
Label3.Visible = true;
Label3.Text = "Login Failed";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string v1 = "";
v1 = Request.QueryString["vendor_name"];
//Session["vn"] = Request.QueryString["vendor_name"];
try
{
loginwebservice.login1 l1 = new loginwebservice.login1();
string[] a = l1.vendor_retrieve(v1);
name.Text = a[0];
contact.Text = a[3];
street.Text = a[4];
city.Text = a[5];
zipcode.Text = a[1];
service1.Text = a[7];
timings.Text = a[6];
gimg.Text = "<a class='details' data-fancybox-type='iframe' href='http://maps.google.com/?output=embed&f=q&source=s_q&hl=en&geocode=&q=" + street.Text + "," + city.Text + "," + zipcode.Text + "'><img src='images/google-map.png'></a>";
loginwebservice.login1 l2 = new loginwebservice.login1();
ArrayList b = new ArrayList(l2.vendor_try(v1));
ArrayList c = new ArrayList();
c = (ArrayList)b;
string[,] data = new string[100, 4];
int iterator = 0;
foreach (string d in c)
{
string[] row = d.Split('^');
data[iterator, 0] = row[0];
data[iterator, 1] = row[1];
data[iterator, 2] = row[2];
data[iterator, 3] = row[3];
iterator++;
}
DataTable newsDataTable = new DataTable();
// add some columns to our datatable
newsDataTable.Columns.Add("vname");
newsDataTable.Columns.Add("vzipcode");
newsDataTable.Columns.Add("vemail");
newsDataTable.Columns.Add("vcontactno");
// adding new rows
for (int i = 0; i < iterator; i++)
{
DataRow newsDataRow = newsDataTable.NewRow();
newsDataRow["vname"] = data[i, 0];
newsDataRow["vzipcode"] = data[i, 1];
newsDataRow["vemail"] = data[i, 2];
newsDataRow["vcontactno"] = data[i, 3];
newsDataTable.Rows.Add(newsDataRow);
}
//Label1.Text = "<a title='Send Mail to Restaurant' href='mailto:" + param1 + "'><img src ='images/email-to.png'></a>";
// bind our datatable to our repeater
category.DataSource = newsDataTable;
category.DataBind();
}
catch (Exception e1)
{
//error.Visible = true;
//error.Text = "error";
//int abc = 1;
}
}