protected void Page_Load(object sender, EventArgs e)
{
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_res(i);
}
StringBuilder xmlData = new StringBuilder();
xmlData.Append("<chart bgAlpha='0,0' 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", "600", "300", false, true);
}
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 Page_Load(object sender, EventArgs e)
{
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_res(i);
}
StringBuilder xmlData = new StringBuilder();
xmlData.Append("<chart bgAlpha='0,0' 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", "600", "300", false, true);
}
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 submit_Click(object sender, EventArgs e)
{
string res_id = Request.QueryString["email"];
string user_id = "";
if (Session["main_user"] != null)
{
user_id = Session["main_user"].ToString();
}
else
{
user_id = "guest";
}
string name1 = name.Text;
string phone1 = phone.Text;
string time1 = "";
string message1 = "Table Booking: \r\n Requestor Name: " + name1 + "\r\n Phone number =" + phone1 + "\r\n Time = " + time1;
order_details.order r = new order_details.order();
int x = r.table_bokking(res_id, user_id, name1, phone1, time1);
int y = x;
var fromAddress = new MailAddress("*****@*****.**", "From Name");
var toAddress = new MailAddress(res_id, "To Name");
const string fromPassword = "******";
const string subject = "Table Booking Request";
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);
}
}
protected void submit_Click(object sender, EventArgs e)
{
string res_id = Request.QueryString["email"];
string user_id = "";
if(Session["main_user"] != null)
{
user_id = Session["main_user"].ToString();
}
else
{
user_id = "guest";
}
string name1 = name.Text;
string phone1 = phone.Text;
string time1 = "";
string message1 = "Table Booking: \r\n Requestor Name: " + name1 + "\r\n Phone number =" + phone1 + "\r\n Time = " + time1;
order_details.order r = new order_details.order();
int x = r.table_bokking(res_id, user_id, name1, phone1, time1);
int y = x;
var fromAddress = new MailAddress("*****@*****.**", "From Name");
var toAddress = new MailAddress(res_id, "To Name");
const string fromPassword = "******";
const string subject = "Table Booking Request";
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);
}
}
protected void checkout_Click(object sender, EventArgs e)
{
string det = details1.Text;
string main_user = Session["main_user"].ToString();
string res_id = Session["mail_res"].ToString();
string tott = price.Text;
int tot = Convert.ToInt32(tott);
order_details.order r = new order_details.order();
int result = r.order_enter(main_user, res_id, det, tot);
if (result != 0)
{
Response.Redirect("order_address.aspx?id=" + result);
}
else
{
price.Text = "zero";
}
}
protected void checkout_Click(object sender, EventArgs e)
{
string det = details1.Text;
string main_user = Session["main_user"].ToString();
string res_id = Session["mail_res"].ToString();
string tott = price.Text;
int tot = Convert.ToInt32(tott);
order_details.order r = new order_details.order();
int result = r.order_enter(main_user, res_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 main_user = "";
if (Session["main_user"] != null)
{
main_user = Session["main_user"].ToString();
}
else
{
main_user = "******";
}
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_user(i, main_user);
}
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='100' />");
xmlData.Append("<set label='Feb' value='120' />");
xmlData.Append("<set label='Mar' value='120' />");
xmlData.Append("<set label='Apr' value='120' />");
xmlData.Append("<set label='May' value='120' />");
xmlData.Append("<set label='Jun' value='120' />");
xmlData.Append("<set label='Jul' value='120' />");
xmlData.Append("<set label='Aug' value='120' />");
xmlData.Append("<set label='Sep' value='120' />");
xmlData.Append("<set label='Oct' value='120' />");
xmlData.Append("<set label='Nov' value='120' />");
xmlData.Append("<set label='Dec' value='120' />");
xmlData.Append("</chart>");
Literal1.Text = FusionCharts.RenderChart("js/Column3D.swf", "", xmlData.ToString(), "myNext", "500", "300", false, true);
}
protected void Page_Load(object sender, EventArgs e)
{
string res_id = "";
if (Session["main_res"] != null)
{
res_id = Session["main_res"].ToString();
}
else
{
res_id = "*****@*****.**";
}
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_res(i,res_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 Page_Load(object sender, EventArgs e)
{
string emailid = "";
if (Session["main_user"] != null)
{
emailid = Session["main_user"].ToString();
}
order_details.order r = new order_details.order();
ArrayList b = new ArrayList(r.user_order(emailid));
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('#');
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];
iterator++;
}
DataTable newsDataTable = new DataTable();
// add some columns to our datatable
newsDataTable.Columns.Add("res_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["res_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();
}
protected void Page_Load(object sender, EventArgs e)
{
string emailid = "";
if (Session["main_res"] != null)
{
emailid = Session["main_res"].ToString();
}
order_details.order r = new order_details.order();
ArrayList b = new ArrayList(r.res_order(emailid));
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();
}
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 state1 = state.Text;
string phone1 = phone.Text;
int id = Convert.ToInt32(Request.QueryString["id"]);
string date1 = datepicker.Value;
int x = r.address_insert(street1, city1, state1, phone1, id, date1);
string main_user = Session["main_user"].ToString();
string res_id = Session["mail_res"].ToString();
/* Email to User */
string message1 = "Your Order has been successfully Placed.";
var fromAddress = new MailAddress("*****@*****.**", "From Name");
var toAddress = new MailAddress(main_user, "To Name");
const string fromPassword = "******";
const string subject = "Your Order Confirmation from EatHub";
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 User */
string message2 = "A new Order has been placed. Please Login to your profile to process the order";
var fromAddress1 = new MailAddress("*****@*****.**", "From Name");
var toAddress1 = new MailAddress(res_id, "To Name");
const string fromPassword1 = "eatasulike";
const string subject1 = "New order from EatHub";
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");
}
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 state1 = state.Text;
string phone1 = phone.Text;
int id = Convert.ToInt32(Request.QueryString["id"]);
string date1 = datepicker.Value;
int x = r.address_insert(street1, city1, state1, phone1, id, date1);
string main_user = Session["main_user"].ToString();
string res_id = Session["mail_res"].ToString();
/* Email to User */
string message1 = "Your Order has been successfully Placed.";
var fromAddress = new MailAddress("*****@*****.**", "From Name");
var toAddress = new MailAddress(main_user, "To Name");
const string fromPassword = "******";
const string subject = "Your Order Confirmation from EatHub";
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 User */
string message2 = "A new Order has been placed. Please Login to your profile to process the order";
var fromAddress1 = new MailAddress("*****@*****.**", "From Name");
var toAddress1 = new MailAddress(res_id, "To Name");
const string fromPassword1 = "eatasulike";
const string subject1 = "New order from EatHub";
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");
}
