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);
