protected void Page_Load(object sender, EventArgs e)
{
lbl_hit.Text = Global.TotalNumberOfUsers.ToString();
GenelDataContext db = new GenelDataContext();
var item = from b in db.tbl_Books
select b;
int num = 0;
foreach (var z in item)
{
num++;
}
Label1.Text = num.ToString();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
GenelDataContext db = new GenelDataContext();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
if (((CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox1")).Checked)
{
var item = from m in db.tbl_Messages
where m.MessageID == int.Parse(GridView1.Rows[i].Cells[1].Text)
select m;
foreach (var z in item)
{
z.state = "Readed";
db.SubmitChanges();
GridView1.DataBind();
}
}
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
GenelDataContext db = new GenelDataContext();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
if (((CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox_Select")).Checked)
{
var item = from o in db.tbl_orders
where o.OrderID == int.Parse(GridView1.Rows[i].Cells[1].Text)
select o;
foreach (var z in item)
{
z.State = "Done";
z.FinishDate = DateTime.Now;
db.SubmitChanges();
GridView1.DataBind();
}
}
}
}