protected void Button2_Click(object sender, EventArgs e)
{
var db = new QCDBMLDataContext();
canteen_master canteen = db.canteen_masters.Single(canteen_master => canteen_master.canteen_id == (int)Session["id"]);
canteen.wallet -= Int32.Parse(TextBox2.Text);
db.SubmitChanges();
DetailsView2.DataBind();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
var db = new QCDBMLDataContext();
canteen_master sel_canteen = (from canteen in db.canteen_masters where canteen.canteen_name.Equals(DropDownList1.SelectedItem.Text) select canteen).FirstOrDefault();
int can_id = sel_canteen.canteen_id;
GridView1.DataSource = from food_item in db.food_masters join menu in db.menu_masters on food_item.food_item_id
equals menu.food_item_id where menu.canteen_id == can_id
select new { food_item.name, menu.qty, menu.rate };
GridView1.DataBind();
Session["can_id"] = can_id;
}
protected void Button7_Click(object sender, EventArgs e)
{
var db = new QCDBMLDataContext();
canteen_master canteen = db.canteen_masters.Single(canteen_master => canteen_master.canteen_name.Equals(DropDownList2.SelectedValue));
double ratings = (double)canteen.rating;
long fb_count = (long)canteen.feedback_count;
int x = Int32.Parse(DropDownList3.SelectedValue);
ratings = ((ratings * fb_count) + x) / (fb_count + 1);
fb_count = fb_count + 1;
canteen.rating = (decimal)ratings;
canteen.feedback_count = fb_count;
db.SubmitChanges();
}
protected void Button6_Click(object sender, EventArgs e)
{
int rate;
var db = new QCDBMLDataContext();
int pending_order = db.order_headers.Count(order_header => order_header.canteen_id == (int)Session["can_id"] && order_header.status == "placed");
canteen_master canteen = db.canteen_masters.Single(canteen_master => canteen_master.canteen_id == (int)Session["can_id"]);
if (canteen.order_limit <= pending_order)
{
Label4.Text = "Canteen is overcrowded. Please order after a few minutes";
}
else
{
student_master student = db.student_masters.Single(student_master => student_master.id == (int)Session["id"]);
long stu_wallet = (long)student.wallet;
if (((int)Session["tot_amt"]) > stu_wallet)
{
Label4.Text = "You dont have enough money in your wallet";
}
else
{
student.wallet -= (int)Session["tot_amt"];
db.SubmitChanges();
canteen_master sel_canteen = db.canteen_masters.Single(canteen_master => canteen_master.canteen_id == (int)Session["can_id"]);
sel_canteen.wallet += (int)Session["tot_amt"];
db.SubmitChanges();
order_header neworder = new order_header();
neworder.stu_id = (int)Session["id"];
neworder.canteen_id = (int)Session["can_id"];
neworder.order_date = DateTime.Now;
DateTime temp_date = (DateTime)neworder.order_date;
neworder.amount = (int)Session["tot_amt"];
neworder.status = "placed";
db.order_headers.InsertOnSubmit(neworder);
db.SubmitChanges();
order_header oh = db.order_headers.Single(order_header => order_header.order_date.Equals(temp_date));
int oid = oh.order_id;
foreach (GridViewRow gv2row in GridView2.Rows)
{
order_detail neworderdet = new order_detail();
neworderdet.order_id = oid;
food_master sel_food = db.food_masters.Single(food_master => food_master.name.Equals(gv2row.Cells[1].Text));
int sel_food_id = sel_food.food_item_id;
neworderdet.food_item_id = sel_food_id;
foreach (GridViewRow gvrow in GridView1.Rows)
{
if (gvrow.Cells[1].Text.Equals(gv2row.Cells[1].Text))
{
rate = Int32.Parse(gvrow.Cells[3].Text);
neworderdet.rate = rate;
neworderdet.qty = Int32.Parse(gv2row.Cells[2].Text);
break;
}
}
db.order_details.InsertOnSubmit(neworderdet);
menu_master menu = db.menu_masters.Single(menu_master => menu_master.canteen_id == neworder.canteen_id && menu_master.food_item_id == neworderdet.food_item_id);
menu.qty -= neworderdet.qty;
db.SubmitChanges();
}
}
}
DropDownList1_SelectedIndexChanged(sender, e);
}
partial void Deletecanteen_master(canteen_master instance);
partial void Updatecanteen_master(canteen_master instance);
partial void Insertcanteen_master(canteen_master instance);
protected void Button1_Click(object sender, EventArgs e)
{
string pass = "";
admin_master admin = new admin_master();
canteen_master canteen = new canteen_master();
student_master student = new student_master();
/*int rows;
* string acc_select_SQL;
* SqlCommand acc_select = new SqlCommand();
* SqlConnection con = (SqlConnection)Application["conobj"]; */
var db = new QCDBMLDataContext();
if (RadioButtonList1.SelectedValue.Equals("admin"))
{
admin = db.admin_masters.Single(admin_master => admin_master.uname.Equals(TextBox1.Text));
pass = admin.pass;
/*acc_select_SQL = "SELECT * FROM admin_master WHERE uname = @tb_uname;";
* acc_select.CommandText = acc_select_SQL;
* acc_select.Connection = con;
* acc_select.Parameters.AddWithValue("@tb_uname", TextBox1.Text);*/
}
else if (RadioButtonList1.SelectedValue.Equals("manager"))
{
canteen = db.canteen_masters.Single(canteen_master => canteen_master.uname.Equals(TextBox1.Text));
pass = canteen.pass;
/*acc_select_SQL = "SELECT * FROM canteen_master WHERE uname = @tb_uname;";
* acc_select.CommandText = acc_select_SQL;
* acc_select.Connection = con;*/
//acc_select.Parameters.AddWithValue("@tb_uname", TextBox1.Text);
}
else if (RadioButtonList1.SelectedValue.Equals("student"))
{
student = db.student_masters.Single(student_master => student_master.uname.Equals(TextBox1.Text));
pass = student.pass;
/*acc_select_SQL = "SELECT * FROM student_master WHERE uname = @tb_uname;";
* acc_select.CommandText = acc_select_SQL;
* acc_select.Connection = con;
* acc_select.Parameters.AddWithValue("@tb_uname", TextBox1.Text);*/
}
else
{
Response.Write("Not Valid");
}
/*SqlDataAdapter adapter = new SqlDataAdapter(acc_select);
* DataSet dsAcc = new DataSet();
*
* try
* {
* con.Open();
* rows = adapter.Fill(dsAcc, "accounts");
* con.Close();
* if(rows != 0)
* {
* foreach(DataRow row in dsAcc.Tables["accounts"].Rows)
* {*/
if (TextBox2.Text.Equals(pass))
{
Session["logged_in"] = true;
Session["role"] = RadioButtonList1.SelectedValue;;
switch (RadioButtonList1.SelectedValue)
{
case "admin": Session["id"] = (int)admin.admin_id;
Response.Redirect("admin_dashboard.aspx");
break;
case "manager": Session["id"] = (int)canteen.canteen_id;
Response.Redirect("canteen_dashboard.aspx");
break;
case "student": Session["id"] = (int)student.id;
Response.Redirect("student_dashboard1.aspx");
break;
}
} /*
* }
* }
* else
* {
* Response.Write("Invalid username/password");
* }
* }
* catch(Exception mess)
* {
* Response.Write(mess.Message);
* con.Close();
* } */
}
