protected void showStudentNotifs()
{
int id = Convert.ToInt32(Session["id"]);
QCDBMLDataContext ctx = new QCDBMLDataContext();
var notifs = from notif in ctx.student_notification_masters where notif.student_id == id select notif;
if (notifs != null && notifs.Count <student_notification_master>() > 0)
{
foreach (student_notification_master s in notifs)
{
TableRow tr = new TableRow();
TableCell c1 = new TableCell();
Label lmsg = new Label();
lmsg.Text = s.message;
c1.Controls.Add(lmsg);
tr.Cells.Add(c1);
TableCell c2 = new TableCell();
c2.Text = "Date :" + s.not_date.ToShortDateString();
tr.Cells.Add(c2);
LinkButton link = new LinkButton();
link.Text = "Dismiss";
link.Command += new CommandEventHandler(DismissNotfStu);
link.CommandName = s.student_id.ToString();
link.CommandArgument = s.message;
TableCell c3 = new TableCell();
c3.Controls.Add(link);
tr.Cells.Add(c3);
Notif_Table.Rows.Add(tr);
}
}
else
{
Debug.Write("Else of Student Notif");
}
}
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 Button1_Click(object sender, EventArgs e)
{
var db = new QCDBMLDataContext();
student_master student = db.student_masters.Single(student_master => student_master.id == (int)Session["id"]);
student.wallet += Int32.Parse(TextBox1.Text);
db.SubmitChanges();
DetailsView1.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 Page_Load(object sender, EventArgs e)
{
if (Session["logged_in"].Equals(false))
{
Response.Redirect("login.aspx");
}
var db = new QCDBMLDataContext();
int student_count = (from student in db.student_masters select student.id).Count();
Label1.Text = student_count.ToString();
int canteen_count = (from canteen in db.canteen_masters select canteen.canteen_id).Count();
Label2.Text = student_count.ToString();
}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
var db = new QCDBMLDataContext();
food_master sel_food = db.food_masters.Single(food_master => food_master.name.Equals(Label1.Text));
int sel_food_id = sel_food.food_item_id;
menu_master menu = (from sel_menu in db.menu_masters
where sel_menu.canteen_id == (int)Session["can_id"] &&
sel_menu.food_item_id == sel_food_id
select sel_menu).FirstOrDefault();
if (Int32.Parse(TextBox1.Text) > menu.qty)
{
Label2.Text = "Reduce your quantity or select a new food item";
}
}
protected void ApproveNotifStu(object o, CommandEventArgs e)
{
string msg = e.CommandArgument.ToString();
int index = msg.IndexOf("order ID: ");
int o_id = Convert.ToInt32(msg.Substring(index + 9));
int s_id;
QCDBMLDataContext ctx = new QCDBMLDataContext();
var order = ctx.order_headers.Single(order_header => order_header.order_id == o_id);
order.status = "can_app";
ctx.SubmitChanges();
//var notif = ctx.canteen_notification_masters.Single(canteen_notification_master => canteen_notification_master.canteen_id.ToString() == e.CommandName && canteen_notification_master.message == e.CommandArgument.ToString());
string cons = WebConfigurationManager.ConnectionStrings["QuickCanteenDBConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(cons);
string q = "delete from canteen_notification_master where canteen_id=" + Convert.ToInt32(e.CommandName) + " AND message='" + e.CommandArgument.ToString() + "'";
SqlCommand cmd = new SqlCommand();
con.Open();
cmd.Connection = con;
cmd.CommandText = q;
cmd.ExecuteNonQuery();
/*if(order != null)
* {
* s_id = order.stu_id;
* var o_details = ctx.order_details.Single(order_detail => order_detail.order_id == order.order_id);
* if(o_details != null)
* {
* ctx.order_details.DeleteOnSubmit(o_details);
* }
* ctx.order_headers.DeleteOnSubmit(order);
* student_notification_master snm = new student_notification_master();
* snm.student_id = s_id;
* snm.message = "Your Cancellation Of Order No: " + o_id + " Approved !";
* snm.not_date = DateTime.Now;
* ctx.student_notification_masters.InsertOnSubmit(snm);
* var notif = ctx.canteen_notification_masters.Single(canteen_notification_master => canteen_notification_master.canteen_id.ToString() == e.CommandName && canteen_notification_master.message == e.CommandArgument.ToString());
* if(notif != null)
* {
* ctx.canteen_notification_masters.DeleteOnSubmit(notif);
* }
* ctx.SubmitChanges();
* }*/
}
protected void Button5_Click(object sender, EventArgs e)
{
var db = new QCDBMLDataContext();
int price = 0, tmp_sum = 0, rate;
foreach (FoodCartItem cartitem in (List <FoodCartItem>)Session["cart_obj"])
{
foreach (GridViewRow gvrow in GridView1.Rows)
{
if (gvrow.Cells[1].Text.Equals(cartitem.name))
{
rate = Int32.Parse(gvrow.Cells[3].Text);
price = cartitem.qty * rate;
break;
}
}
tmp_sum += price;
}
Label3.Visible = true;
Session["tot_amt"] = tmp_sum;
Label3.Text = "Total Amount:" + tmp_sum.ToString();
}
protected void Button1_Click(object sender, EventArgs e)
{
var db = new QCDBMLDataContext();
List <string> can_list = (from canteen in db.canteen_masters
where DateTime.Now.TimeOfDay > (TimeSpan)canteen.open_time && DateTime.Now.TimeOfDay < (TimeSpan)canteen.close_time
select canteen.canteen_name).ToList();
if (can_list.Count == 0)
{
Label5.Text = "No canteens are open at this time";
}
else
{
DropDownList1.DataSource = can_list;
DropDownList1.DataBind();
DropDownList1.SelectedIndex = 0;
DropDownList1_SelectedIndexChanged(sender, e);
Panel1.Visible = true;
Panel2.Visible = true;
Panel3.Visible = false;
Panel4.Visible = false;
}
}
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);
}
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();
* } */
}