protected void Page_Load(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
if (id == null)
{
id = 1;
}
order_details.order r = new order_details.order();
string res = r.order_details(id);
string[] a = res.Split('^');
string details = a[2];
string price = a[3];
string street = a[5];
string city = a[6];
string state = a[7];
string phone = a[8];
price1.Text = price;
string[] each_details = details.Split('&');
int len = each_details.Length;
DataTable newsDataTable = new DataTable();
// add some columns to our datatable
newsDataTable.Columns.Add("item_name");
newsDataTable.Columns.Add("price");
for (int i = 0; i < len - 1; i++)
{
string[] each_single = each_details[i].Split(',');
DataRow newsDataRow = newsDataTable.NewRow();
newsDataRow["item_name"] = each_single[0];
newsDataRow["price"] = each_single[1];
newsDataTable.Rows.Add(newsDataRow);
}
//Binding data to repeater
cart.DataSource = newsDataTable;
cart.DataBind();
/* city1.Text = city;
street1.Text = street;
state1.Text = state;
phone1.Text = phone;
* /*/
}
protected void checkout_Click(object sender, EventArgs e)
{
int result = 0;
string det = details1.Text;
string main_user = Session["main_name"].ToString();
string ven_id = Session["vn"].ToString();
string tott = price.Text;
int tot = Convert.ToInt32(tott);
order_details.order r = new order_details.order();
result = r.order_enter(main_user, ven_id, det, tot);
if (result != 0)
{
Response.Redirect("order_address.aspx?id=" + result);
}
else
{
price.Text = "zero";
}
/*
* order_details.order r = new order_details.order();
* result = r.order_enter(main_user, ven_id, det, tot);*/
//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();
*
* // SqlCommand cmd1 = new SqlCommand("insert into order_details (user_id,res_id,details,total,date) values('"+user_id + "'," +user_id + "',"+details +"',"+total +",' sysdate()')",conn);
* SqlCommand cmd1 = new SqlCommand("insert into order_details (user_id,ven_id,details,total) values('" + main_user + "','" + ven_id + "','" + det + "','" + tott + "')", conn);
* int x = cmd1.ExecuteNonQuery();
*
* int y = 0;
* if (x != 0)
* {
* SqlCommand cm = new SqlCommand("select id from order_details where user_id = '" + main_user + "' and ven_id='" + ven_id + "' and details = '" + det + "' and total = '" + tot + "'", conn);
* SqlDataReader red = cm.ExecuteReader();
*
* while (red.Read())
* {
*
* y = Convert.ToInt32(red["id"]);
* }
*
* }
*
* if (y != 0)
* {
* Response.Redirect("order_address.aspx?id=" + y);
*
* }
* else
* {
* price.Text = "zero";
* }
* cmd1.Dispose();
* conn.Close();*/
}
protected void checkout_Click(object sender, EventArgs e)
{
int result = 0;
string det = details1.Text;
string main_user = Session["main_name"].ToString();
string ven_id = Session["vn"].ToString();
string tott = price.Text;
int tot = Convert.ToInt32(tott);
order_details.order r = new order_details.order();
result = r.order_enter(main_user, ven_id, det, tot);
if (result != 0)
{
Response.Redirect("order_address.aspx?id=" + result);
}
else
{
price.Text = "zero";
}
/*
order_details.order r = new order_details.order();
result = r.order_enter(main_user, ven_id, det, tot);*/
//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();
// SqlCommand cmd1 = new SqlCommand("insert into order_details (user_id,res_id,details,total,date) values('"+user_id + "'," +user_id + "',"+details +"',"+total +",' sysdate()')",conn);
SqlCommand cmd1 = new SqlCommand("insert into order_details (user_id,ven_id,details,total) values('" + main_user + "','" + ven_id + "','" + det + "','" + tott + "')", conn);
int x = cmd1.ExecuteNonQuery();
int y = 0;
if (x != 0)
{
SqlCommand cm = new SqlCommand("select id from order_details where user_id = '" + main_user + "' and ven_id='" + ven_id + "' and details = '" + det + "' and total = '" + tot + "'", conn);
SqlDataReader red = cm.ExecuteReader();
while (red.Read())
{
y = Convert.ToInt32(red["id"]);
}
}
if (y != 0)
{
Response.Redirect("order_address.aspx?id=" + y);
}
else
{
price.Text = "zero";
}
cmd1.Dispose();
conn.Close();*/
}
protected void checkout_Click(object sender, EventArgs e)
{
int result = 0;
string det = details1.Text;
string main_user = Session["main_name"].ToString();
string ven_id = Session["vn"].ToString();
string tott = price.Text;
int tot = Convert.ToInt32(tott);
order_details.order r = new order_details.order();
result = r.order_enter(main_user, ven_id, det, tot);
if (result != 0)
{
Response.Redirect("order_address.aspx?id=" + result);
}
else
{
price.Text = "zero";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string ven_id = "";
if (Session["main_vname"] != null)
{
ven_id = Session["main_vname"].ToString();
}
else
{
ven_id = "Plaza Catering";
}
int[] ab = new int[12];
order_details.order r = new order_details.order();
for (int i = 1; i < 13; i++)
{
ab[i - 1] = r.chart_ven(i, ven_id);
}
StringBuilder xmlData = new StringBuilder();
xmlData.Append("<chart bgImageAlpha='30' bgImage='img1.jpg' canvasBgAlpha='0' caption='Monthly Order Sales' xAxisName='Month' yAxisName='Amount'>");
xmlData.Append("<set label='Jan' value='" + ab[0] + "' />");
xmlData.Append("<set label='Feb' value='" + ab[1] + "' />");
xmlData.Append("<set label='Mar' value='" + ab[2] + "' />");
xmlData.Append("<set label='Apr' value='" + ab[3] + "' />");
xmlData.Append("<set label='May' value='" + ab[4] + "' />");
xmlData.Append("<set label='Jun' value='" + ab[5] + "' />");
xmlData.Append("<set label='Jul' value='" + ab[6] + "' />");
xmlData.Append("<set label='Aug' value='" + ab[7] + "' />");
xmlData.Append("<set label='Sep' value='" + ab[8] + "' />");
xmlData.Append("<set label='Oct' value='" + ab[9] + "' />");
xmlData.Append("<set label='Nov' value='" + ab[10] + "' />");
xmlData.Append("<set label='Dec' value='" + ab[11] + "' />");
xmlData.Append("</chart>");
Literal1.Text = FusionCharts.RenderChart("js/Column3D.swf", "", xmlData.ToString(), "myNext", "500", "300", false, true);
}
protected void submit_Click(object sender, EventArgs e)
{
order_details.order r = new order_details.order();
string street1 = street.Text;
string city1 = city.Text;
string email1 = email.Text;
string state1 = state.Text;
string phone1 = phone.Text;
int id = Convert.ToInt32(Request.QueryString["id"]);
string date1 = lblbday.Text;
string email2 = "";
/* int x = r.address_insert(street1,email1, city1, state1, phone1, id,date1);*/
//Declare Connection by passing the connection string from the web config file
SqlConnection conn4 = new SqlConnection(ConfigurationManager.ConnectionStrings["dbString"].ConnectionString);
//Open the connection
conn4.Open();
string yDate = Convert.ToDateTime(date1).ToString("MM-dd-yyyy");
//SqlCommand cmd1 = new SqlCommand("UPDATE order_details SET street = '" + street + "', city = '" + city + "', state = '" + state + "', phone = '" + phone + "' where id = " + id + ")", conn);
SqlCommand cmd1 = new SqlCommand("UPDATE order_details SET email = '" + email1 + "', street = '" + street1 + "', city = '" + city1 + "', state = '" + state1 + "' , phone = '" + phone1 + "', date = '" + yDate + "' where id = '" + id + "'", conn4);
int x = cmd1.ExecuteNonQuery();
string main_name = Session["main_name"].ToString();
// string res_id = Session["mail_res"].ToString();
string ven_id = Session["vn"].ToString();
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='" + ven_id + "' ", conn);
SqlDataReader f = cmd.ExecuteReader();
while (f.Read())
{
email2 = f["vemail"].ToString();
}
if (x != 0)
{
Label1.Visible = true;
//Label1.Text = "Success";
//Email to User
string message1 = "Your Order has been successfully Placed.";
var fromAddress = new MailAddress("*****@*****.**", "Occasions on the Go");
var toAddress = new MailAddress(email1, "To Name");
const string fromPassword = "******";
const string subject = "Your Order Confirmation from Occasions On The Go";
string body = message1;
var smtp = new SmtpClient
{
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword),
Timeout = 20000
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body
})
{
smtp.Send(message);
}
//Email to Vendor
string message2 = "A new Order has been placed. Please Login to your profile to process the order";
var fromAddress1 = new MailAddress("*****@*****.**", "Occasions on the Go");
var toAddress1 = new MailAddress(email2, "To Name");
const string fromPassword1 = "aseproject";
const string subject1 = "New order from Occasions on the Go";
string body1 = message2;
var smtp1 = new SmtpClient
{
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
Credentials = new NetworkCredential(fromAddress1.Address, fromPassword1),
Timeout = 20000
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject1,
Body = body1
})
{
smtp.Send(message);
}
Response.Redirect("order_success.aspx");
cmd1.Dispose();
conn4.Close();
}
else if (x == 0)
{
Label1.Visible = true;
Label1.Text = "Placing order failed !! Please retry after sometime !!";
}
cmd.Dispose();
conn.Close();
//Response.Redirect("order_success.aspx");
}
protected void submit_Click(object sender, EventArgs e)
{
order_details.order r = new order_details.order();
string street1 = street.Text;
string city1 = city.Text;
string email1 = email.Text;
string state1 = state.Text;
string phone1 = phone.Text;
int id = Convert.ToInt32(Request.QueryString["id"]);
string date1 = lblbday.Text;
string email2 = "";
/* int x = r.address_insert(street1,email1, city1, state1, phone1, id,date1);*/
//Declare Connection by passing the connection string from the web config file
SqlConnection conn4 = new SqlConnection(ConfigurationManager.ConnectionStrings["dbString"].ConnectionString);
//Open the connection
conn4.Open();
string yDate = Convert.ToDateTime(date1).ToString("MM-dd-yyyy");
//SqlCommand cmd1 = new SqlCommand("UPDATE order_details SET street = '" + street + "', city = '" + city + "', state = '" + state + "', phone = '" + phone + "' where id = " + id + ")", conn);
SqlCommand cmd1 = new SqlCommand("UPDATE order_details SET email = '" + email1 + "', street = '" + street1 + "', city = '" + city1 + "', state = '" + state1 + "' , phone = '" + phone1 + "', date = '" + yDate + "' where id = '" + id + "'", conn4);
int x = cmd1.ExecuteNonQuery();
string main_name = Session["main_name"].ToString();
// string res_id = Session["mail_res"].ToString();
string ven_id = Session["vn"].ToString();
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='" + ven_id + "' ", conn);
SqlDataReader f = cmd.ExecuteReader();
while (f.Read())
{
email2 = f["vemail"].ToString();
}
if (x != 0)
{
Label1.Visible = true;
//Label1.Text = "Success";
//Email to User
string message1 = "Your Order has been successfully Placed.";
var fromAddress = new MailAddress("*****@*****.**", "Occasions on the Go");
var toAddress = new MailAddress(email1, "To Name");
const string fromPassword = "******";
const string subject = "Your Order Confirmation from Occasions On The Go";
string body = message1;
var smtp = new SmtpClient
{
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword),
Timeout = 20000
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body
})
{
smtp.Send(message);
}
//Email to Vendor
string message2 = "A new Order has been placed. Please Login to your profile to process the order";
var fromAddress1 = new MailAddress("*****@*****.**", "Occasions on the Go");
var toAddress1 = new MailAddress(email2, "To Name");
const string fromPassword1 = "aseproject";
const string subject1 = "New order from Occasions on the Go";
string body1 = message2;
var smtp1 = new SmtpClient
{
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
Credentials = new NetworkCredential(fromAddress1.Address, fromPassword1),
Timeout = 20000
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject1,
Body = body1
})
{
smtp.Send(message);
}
Response.Redirect("order_success.aspx");
cmd1.Dispose();
conn4.Close();
}
else if (x == 0)
{
Label1.Visible = true;
Label1.Text = "Placing order failed !! Please retry after sometime !!";
}
cmd.Dispose();
conn.Close();
//Response.Redirect("order_success.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
string venid = "";
if (Session["main_vname"] != null)
{
venid = Session["main_vname"].ToString();
}
order_details.order r = new order_details.order();
ArrayList b = new ArrayList(r.ven_order(venid));
ArrayList c = new ArrayList();
c = (ArrayList)b;
string[,] data = new string[100, 6];
int iterator = 0;
foreach (string d in c)
{
string[] row = d.Split('#');
int ab = row.Length;
data[iterator, 0] = row[0];
data[iterator, 1] = row[1];
data[iterator, 2] = row[2];
data[iterator, 3] = row[3];
data[iterator, 4] = row[4];
/* data[iterator, 5] = row[5];*/
iterator++;
}
DataTable newsDataTable = new DataTable();
// add some columns to our datatable
newsDataTable.Columns.Add("user_id");
newsDataTable.Columns.Add("date");
newsDataTable.Columns.Add("price");
newsDataTable.Columns.Add("id");
// adding new rows
for (int i = 0; i < iterator; i++)
{
DataRow newsDataRow = newsDataTable.NewRow();
newsDataRow["user_id"] = data[i, 0];
newsDataRow["price"] = data[i, 2];
newsDataRow["date"] = data[i, 3];
newsDataRow["id"] = data[i, 4];
newsDataTable.Rows.Add(newsDataRow);
}
// bind our datatable to our repeater
details.DataSource = newsDataTable;
details.DataBind();
}
