protected void Button1_Click(object sender, EventArgs e)
{
string un;
un = TextBox1.Text;
string pa;
pa = TextBox2.Text;
string selectquery = "select * from Reg_Table where ULoginName='" + un + "' and Password='******'";
//foodfantacy ta3 = new foodfantacy();
//ta3.FoodS(query);
foodfantacy obj = new foodfantacy();
//DataTable obj = new DataTable();
DataTable ta1 = obj.FoodS(selectquery);
if (ta1.Rows.Count >= 1)
{
Response.Redirect("chomepage.aspx");
}
else
{
string msg1 = "<script>alert('Enter Correct Username Or Password!,');</script>";
ScriptManager.RegisterStartupScript(this, typeof(Control), "alertmsg", msg1, false);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string selectquery = "select * from Reg_Table where UloginName='" + txtulname.Text + "'";
foodfantacy obj = new foodfantacy();
//DataTable obj = new DataTable();
DataTable ta1 = obj.FoodS(selectquery);
if (ta1.Rows.Count >= 1)
{
string msg1 = "<script>alert('User Already Exist!,');</script>";
ScriptManager.RegisterStartupScript(this, typeof(Control), "alertmsg", msg1, false);
}
else
{
string save = "insert into Reg_Table(uname,uloginname,password,location,mobno,email)values('" + txtrname.Text + "','" + txtulname.Text + "','" + txtpass.Text + "','" + txtloca.Text + "','" + txtmobno.Text + "','" + txtemail.Text + "')";
foodfantacy ob = new foodfantacy();
ob.FoodI(save);
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Registred Sucessfully');", true);
txtulname.Text = "";
txtulname.Text = "";
txtpass.Text = "";
txtloca.Text = "";
txtmobno.Text = "";
txtemail.Text = "";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string un;
un = TextBox1.Text;
string pa;
pa = TextBox2.Text;
string query;
query = "select * from Admin_Table where Name='" + un + "' and password='******'";
//foodfantacy ta3 = new foodfantacy();
//ta3.FoodS(query);
foodfantacy obj = new foodfantacy();
//DataTable obj = new DataTable();
DataTable ta1 = obj.FoodS(query);
if (ta1.Rows.Count >= 1)
{
Response.Redirect("ahomepage.aspx");
}
else
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt1 = new DataTable();
string querry2 = "SELECT DISTINCT onum, del_date, del_address FROM cancle_table";
dt1 = obj.FoodS(querry2);
GridView3.DataSource = dt1;
GridView3.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
string query;
query = "select * from order_Table where onum='" + TextBox1.Text + "'";
//foodfantacy ta3 = new foodfantacy();
//ta3.FoodS(query);
foodfantacy obj = new foodfantacy();
//DataTable obj = new DataTable();
DataTable ta1 = obj.FoodS(query);
GridView2.DataSource = ta1;
GridView2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//DataTable dt1 = new DataTable();
//string querry2 = "select * from order_table";
//dt1 = obj.FoodS(querry2);
//GridView1.DataSource = dt1;
//GridView1.DataBind();
//SqlDataSource1.SelectCommand = "select * from ordernum";
DataTable dt1 = new DataTable();
string querry2 = "SELECT DISTINCT onum, del_date, resturant FROM order_table";
dt1 = obj.FoodS(querry2);
GridView1.DataSource = dt1;
GridView1.DataBind();
}
protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
{
if (RadioButtonList1.SelectedIndex == 0)
{
string retrive = "select * from ItemMaster where itemType='" + RadioButtonList1.SelectedItem.Text + "'";
foodfantacy obj = new foodfantacy();
//DataTable obj = new DataTable();
DataTable ta1 = obj.FoodS(retrive);
GridView1.DataSource = ta1;
GridView1.DataBind();
}
else if (RadioButtonList1.SelectedIndex == 1)
{
string retrive = "select * from ItemMaster where itemType='" + RadioButtonList1.SelectedItem.Text + "'";
foodfantacy obj = new foodfantacy();
//DataTable obj = new DataTable();
DataTable ta1 = obj.FoodS(retrive);
GridView1.DataSource = ta1;
GridView1.DataBind();
}
else if (RadioButtonList1.SelectedIndex == 2)
{
string retrive = "select * from ItemMaster where itemType='" + RadioButtonList1.SelectedItem.Text + "'";
foodfantacy obj = new foodfantacy();
//DataTable obj = new DataTable();
DataTable ta1 = obj.FoodS(retrive);
GridView1.DataSource = ta1;
GridView1.DataBind();
}
else if (RadioButtonList1.SelectedIndex == 3)
{
string retrive = "select * from ItemMaster where itemType='" + RadioButtonList1.SelectedItem.Text + "'";
foodfantacy obj = new foodfantacy();
//DataTable obj = new DataTable();
DataTable ta1 = obj.FoodS(retrive);
GridView1.DataSource = ta1;
GridView1.DataBind();
}
else if (RadioButtonList1.SelectedIndex == 4)
{
string retrive = "select * from ItemMaster where itemType='" + RadioButtonList1.SelectedItem.Text + "'";
foodfantacy obj = new foodfantacy();
//DataTable obj = new DataTable();
DataTable ta1 = obj.FoodS(retrive);
GridView1.DataSource = ta1;
GridView1.DataBind();
}
else if (RadioButtonList1.SelectedIndex == 5)
{
string retrive = "select * from ItemMaster where itemType='" + RadioButtonList1.SelectedItem.Text + "'";
foodfantacy obj = new foodfantacy();
//DataTable obj = new DataTable();
DataTable ta1 = obj.FoodS(retrive);
GridView1.DataSource = ta1;
GridView1.DataBind();
}
else if (RadioButtonList1.SelectedIndex == 6)
{
string retrive = "select * from ItemMaster where itemType='" + RadioButtonList1.SelectedItem.Text + "'";
foodfantacy obj = new foodfantacy();
//DataTable obj = new DataTable();
DataTable ta1 = obj.FoodS(retrive);
GridView1.DataSource = ta1;
GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
// Label1.Visible = true;
DateTime today = DateTime.Today;
TimeSpan current_time = DateTime.Now.TimeOfDay;
//TimeSpan m = TimeSpan.FromMinutes(30);
//TimeSpan n = current_time.Add(m);
//TimeSpan current_time = new TimeSpan(current);
DateTime time = DateTime.Today.Add(current_time);
string displayTime = time.ToString("hh:mm tt");
string current_date = today.ToString("dd/MM/yyyy");
//TimeSpan m = TimeSpan.FromMinutes(15);
//TimeSpan n = tspan.Add(m);
// txttime.Text = displayTime;
DataTable dt1 = new DataTable();
string querry2 = "select * from order_table where onum='" + TextBox1.Text + "'";
dt1 = obj.FoodS(querry2);
if (dt1.Rows.Count > 0)
{
string date = dt1.Rows[0]["del_date"].ToString();
string time1 = dt1.Rows[0]["del_time"].ToString();
TimeSpan tspan;
tspan = DateTime.ParseExact(time1, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay;
//DateTime today = DateTime.Today;
//string today1 = today.ToString("dd/MM/yyyy");
TimeSpan m = TimeSpan.FromMinutes(30);
TimeSpan n = tspan.Add(m);
if (date == current_date)
{
if (n >= current_time && current_time >= tspan)
{
//ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Order Can't be cancelled');", true);
// return;
DataTable dt2 = new DataTable();
SqlDataReader dr4;
SqlConnection con4 = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\FoodFanctsy.mdf;Integrated Security=True;User Instance=True");
con4.Open();
SqlCommand com4 = new SqlCommand("select * from order_table where onum='" + TextBox1.Text + "'", con4);
dr4 = com4.ExecuteReader();
while (dr4.Read() == true)
{
//string querry3 = "select * from order_table where onum='" + TextBox1.Text + "'";
//dt2 = obj.FoodS(querry3);
// if (dt2.Rows.Count > 0)
//{
SqlConnection con1 = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\FoodFanctsy.mdf;Integrated Security=True;User Instance=True");
SqlCommand com1 = new SqlCommand("insert into cancle_table(onum,Product_id,Item_Name,date,Price,Quantity,Total,resturant,del_date,del_time,del_address) values ('" + dr4["onum"].ToString() + "','" + dr4["Product_id"].ToString() + "','" + dr4["Item_Name"].ToString() + "','" + dr4["date"].ToString() + "','" + dr4["Price"].ToString() + "','" + dr4["Quantity"].ToString() + "','" + dr4["Total"].ToString() + "','" + dr4["resturant"].ToString() + "','" + dr4["del_date"].ToString() + "','" + dr4["del_time"].ToString() + "','" + dr4["del_address"].ToString() + "')", con1);
con1.Open();
com1.ExecuteNonQuery();
con1.Close();
}
dr4.Close();
con4.Close();
SqlConnection con5 = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\FoodFanctsy.mdf;Integrated Security=True;User Instance=True");
con5.Open();
SqlCommand com2 = new SqlCommand("delete from order_table where onum='" + TextBox1.Text + "'", con5);
com2.ExecuteNonQuery();
con5.Close();
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Order Cancelled Successfully');", true);
TextBox1.Text = "";
}
TextBox1.Text = "";
return;
}
TextBox1.Text = "";
return;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//DataTable dt1 = new DataTable();
//string querry2 = "select onum from order_table where onum='" + order1 + "' and del_date='"+txtdate.Text+"' and del_time='" + txttime.Text + "'";
///dt1 = obj.FoodS(querry2);
//if (dt1.Rows.Count > 0)
//{
//ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Order Number Exists ');", true);
//return;
// }
// else
foreach (GridViewRow g1 in GridView1.Rows)
{
string prod = g1.Cells[1].Text;
int prod_id = Convert.ToInt32(prod);
string pr = g1.Cells[4].Text;
int price = Convert.ToInt32(pr);
string qty = g1.Cells[5].Text;
int quantity = Convert.ToInt32(qty);
string tot = g1.Cells[6].Text;
int total = Convert.ToInt32(tot);
DataTable dt1 = new DataTable();
string querry2 = "select * from order_table where del_date='" + txtdate.Text + "' and Product_id='" + prod_id + "' and Item_Name='" + g1.Cells[2].Text + "' and Price='" + price + "' and Quantity='" + quantity + "' and Total='" + total + "'";
dt1 = obj.FoodS(querry2);
if (dt1.Rows.Count > 0)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Order Exists ');", true);
txt_ord_no.Text = "";
DropDownList1.SelectedIndex = -1;
txtdate.Text = "";
txttime.Text = "";
txtaddress.Text = "";
return;
}
//if(DateTime.Now.TimeOfDay >= System.TimeSpan.Parse("11:00:00"))
//{
// ClientScript.RegisterStartupScript(GetType(), "alert", "alert('vvv ');", true);
// txt_ord_no.Text = "";
// DropDownList1.SelectedIndex = -1;
// txtdate.Text = "";
// txttime.Text = "";
// txtaddress.Text = "";
// return;
//}
//else
//{
// if (System.DateTime.Now.Hour >= 10)
// {
// ClientScript.RegisterStartupScript(GetType(), "alert", "alert('can't');", true);
// }
//}
//else
//{
// else if(DateTime.Now.TimeOfDay == System.TimeSpan.Parse("00:09:00"))
//{
// ClientScript.RegisterStartupScript(GetType(), "alert", "alert('can't ');", true);
//}
SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\FoodFanctsy.mdf;Integrated Security=True;User Instance=True");
SqlCommand com = new SqlCommand("insert into order_table(onum,Product_id,Item_Name,date,Price,Quantity,Total,resturant,del_date,del_time,del_address,mobno) values (" + order1 + ",'" + prod_id + "','" + g1.Cells[2].Text + "','" + g1.Cells[3].Text + "','" + price + "','" + quantity + "','" + total + "','" + DropDownList1.SelectedItem.Text + "','" + txtdate.Text + "','" + txttime.Text + "','" + txtaddress.Text + "','" + TextBox1.Text + "')", con);
con.Open();
com.ExecuteNonQuery();
con.Close();
string save = "insert into temp_table(onum,Product_id,Item_Name,date,Price,Quantity,Total,resturant,del_date,del_time,del_address) values (" + order1 + ",'" + prod_id + "','" + g1.Cells[2].Text + "','" + g1.Cells[3].Text + "','" + price + "','" + quantity + "','" + total + "','" + DropDownList1.SelectedItem.Text + "','" + txtdate.Text + "','" + txttime.Text + "','" + txtaddress.Text + "')";
foodfantacy ob = new foodfantacy();
ob.FoodI(save);
}
SqlConnection con1 = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\FoodFanctsy.mdf;Integrated Security=True;User Instance=True");
SqlCommand com1 = new SqlCommand("insert into ordernum(onum) values (" + order1 + ")", con1);
con1.Open();
com1.ExecuteNonQuery();
con1.Close();
txt_ord_no.Text = "";
DropDownList1.SelectedIndex = -1;
txtdate.Text = "";
txttime.Text = "";
txtaddress.Text = "";
TextBox1.Text = "";
//GridView1.Dispose();
//Session["cart"] = null;
//GridView1.Rows.Clear();
GridView1.Visible = false;
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Order Placed Sucessfully');", true);
sendsms();
}