protected void btn_accept_Click(object sender, EventArgs e) { bool flag = true; int oid = int.Parse(lbl_orderid.Text); var item = from i in db.tbl_indexOrders where i.OrderID == oid select i.BookID; var ite = from o in db.tbl_orders join x in db.tbl_indexOrders on o.OrderID equals x.OrderID where o.State == "Accepted" && item.Contains(x.BookID) select new { x.BookID }; foreach (var z in ite) { Label1.ForeColor = Color.Red; Label1.Text = "You cannot add this book Because, This book Barrowed please try again Later."; flag = false; } if (flag) { var it = from o in db.tbl_orders where o.OrderID == int.Parse(Request.QueryString["oid"].ToString()) select o; foreach (var z in it) { z.State = "Accepted"; db.SubmitChanges(); tbl_Message ne = new tbl_Message(); ne.message = "Your Order whose number is " + Request.QueryString["oid"].ToString() + " Has Been Accepted Succesfully"; ne.userID = z.UserID; ne.state = "Unreaded"; db.tbl_Messages.InsertOnSubmit(ne); db.SubmitChanges(); Response.Redirect("AcceptOrders.aspx"); } } }
protected void btn_ignore_Click(object sender, EventArgs e) { var it = from o in db.tbl_orders where o.OrderID == int.Parse(Request.QueryString["oid"].ToString()) select o; foreach (var z in it) { z.State = "Ignored"; db.SubmitChanges(); tbl_Message ne = new tbl_Message(); ne.message = "Your Order whose number is " + Request.QueryString["oid"].ToString() + " Has Been Ignored"; ne.userID = z.UserID; ne.state = "Unreaded"; db.tbl_Messages.InsertOnSubmit(ne); db.SubmitChanges(); Response.Redirect("AcceptOrders.aspx"); } }
partial void Deletetbl_Message(tbl_Message instance);
partial void Updatetbl_Message(tbl_Message instance);
partial void Inserttbl_Message(tbl_Message instance);