protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (RS2015DBEntities entities = new RS2015DBEntities()) { TotalLabel.Text = "總報名人數:" + Convert.ToString(entities.Checkins.Count()) + "<br/>"; CurrentLabel.Text = "已報到人數:" + Convert.ToString((from a in entities.Checkins where a.Checkin1 == true select a).Count()); } } }
protected void Page_Load(object sender, EventArgs e) { using (RS2015DBEntities entities = new RS2015DBEntities()) { total = entities.Checkins.Count(); current = (from a in entities.Checkins where a.Checkin1 == true select a).Count(); } TotalLabel.Text = "總報名人數:" + Convert.ToString(total) + "<br/>"; CurrentLabel.Text = "已報名人數:" + Convert.ToString(current) + "<br/>"; }
protected void Button2_Click(object sender, EventArgs e) { if (processing) { return; } processing = true; Label2.Visible = false; ListZip.Clear(); string name = TextBox2.Text; using (RS2015DBEntities entities = new RS2015DBEntities()) { var user = (from a in entities.Checkins where a.Name.Contains(name) select a).ToList(); if (user.Count() == 0) { Label1.Visible = true; Label1.Text = "Not found!!!"; processing = false; GridView1.DataSource = null; GridView1.DataBind(); return; } Label1.Visible = false; foreach (var item in user) { ListZip.Add(new Student(item.ID, item.Name, item.Phone, item.School, item.Department, item.Grade)); } GridView1.DataSource = ListZip; GridView1.DataBind(); } processing = false; }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Checkin") { Button BTN = (Button)e.CommandSource; GridViewRow myRow = (GridViewRow)BTN.NamingContainer; int id = Convert.ToInt32(GridView1.Rows[myRow.DataItemIndex].Cells[1].Text); GridView1.DataSource = null; GridView1.DataBind(); using (RS2015DBEntities entities = new RS2015DBEntities()) { var user = (from a in entities.Checkins where a.ID == id select a).FirstOrDefault(); user.Checkin1 = true; entities.SaveChanges(); Label2.Visible = true; Label2.Text = user.Name + " 同學簽到成功!"; CurrentLabel.Text = "已報到人數:" + Convert.ToString((from a in entities.Checkins where a.Checkin1 == true select a).Count()); } } }