protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { StuDT = StuAdapter.Select_UNAME(Session["sname"].ToString()); AttDT = AttAdapter.Select_By_ROLLNO(StuDT.Rows[0]["rollno"].ToString()); lbltotalatt.Text = AttDT.Rows.Count.ToString(); AttDT = AttAdapter.Select_Roll_Atatus(StuDT.Rows[0]["rollno"].ToString(), "Present"); lblpresent.Text = AttDT.Rows.Count.ToString(); AttDT = AttAdapter.Select_Roll_Atatus(StuDT.Rows[0]["rollno"].ToString(), "Absent"); lblabsent.Text = AttDT.Rows.Count.ToString(); AttDT = AttAdapter.Select_Roll_Atatus(StuDT.Rows[0]["rollno"].ToString(), "Leave"); lblleave.Text = AttDT.Rows.Count.ToString(); LeaveDT = LeaveAdapter.Select_By_RollNo(StuDT.Rows[0]["rollno"].ToString()); lbltotalleave.Text = LeaveDT.Rows.Count.ToString(); CompDT = CompAdapter.Select_By_ROLL(StuDT.Rows[0]["rollno"].ToString()); lbltotalattcompl.Text = CompDT.Rows.Count.ToString(); } }
protected void Button8_Click(object sender, EventArgs e) { MultiView1.ActiveViewIndex = 1; StuDT = StuAdapter.Select_UNAME(Session["sname"].ToString()); LeaveDT = LeaveAdapter.Select_By_RollNo(StuDT.Rows[0]["rollno"].ToString()); GridView1.DataSource = LeaveDT; GridView1.DataBind(); }
protected void btnreject_Click(object sender, EventArgs e) { MultiView1.ActiveViewIndex = 2; LeaveDT = LeaveAdapter.Select_By_STD_and_STATUS(Session["std"].ToString(), "Reject"); GridView3.DataSource = LeaveDT; GridView3.DataBind(); lblrej.Text = GridView3.Rows.Count.ToString(); }
protected void btnapprove_Click(object sender, EventArgs e) { MultiView1.ActiveViewIndex = 1; LeaveDT = LeaveAdapter.Select_By_STD_and_STATUS(drpstd.SelectedItem.Text, "Approve"); GridView2.DataSource = LeaveDT; GridView2.DataBind(); lblapp.Text = GridView2.Rows.Count.ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { MultiView1.ActiveViewIndex = 0; LeaveDT = LeaveAdapter.Select_By_STD_and_STATUS(Session["std"].ToString(), "Pending"); GridView1.DataSource = LeaveDT; GridView1.DataBind(); lblnew.Text = GridView1.Rows.Count.ToString(); } }
protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Approve") { LeaveAdapter.LeaveMst_UPDATE_STATU(Convert.ToInt32(e.CommandArgument.ToString()), "Approve"); MultiView1.ActiveViewIndex = 2; LeaveDT = LeaveAdapter.Select_By_STD_and_STATUS(Session["std"].ToString(), "Reject"); GridView3.DataSource = LeaveDT; GridView3.DataBind(); lblrej.Text = GridView3.Rows.Count.ToString(); } }