protected void Button7_Click(object sender, EventArgs e) { StuDT = StuAdapter.Select_By_STD_DIV(drpstd.SelectedItem.Text, drpdiv.SelectedItem.Text); GridView1.DataSource = StuDT; GridView1.DataBind(); lbl.Text = "Total Student = " + GridView1.Rows.Count.ToString(); }
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 Button7_Click(object sender, EventArgs e) { StuDT = StuAdapter.Select_By_STD_DIV(lblstd.Text, drpdiv.SelectedItem.Text); GridView1.DataSource = StuDT; GridView1.DataBind(); MultiView1.ActiveViewIndex = 0; }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { StuDT = StuAdapter.Select_UNAME(Session["sname"].ToString()); Label1.Text = StuDT.Rows[0]["name"].ToString(); } }
protected void btnappluleave_Click(object sender, EventArgs e) { StuDT = StuAdapter.Select_UNAME(Session["sname"].ToString()); LeaveAdapter.Insert(StuDT.Rows[0]["rollno"].ToString(), StuDT.Rows[0]["Name"].ToString(), StuDT.Rows[0]["stdname"].ToString(), txtmsg.Text, Convert.ToInt32(DropDownList1.SelectedItem.Text), "Pending"); lbl.Text = "Apply for leave successfully"; txtmsg.Text = ""; DropDownList1.SelectedIndex = 0; }
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 drpdiv_SelectedIndexChanged(object sender, EventArgs e) { StuDT = StuAdapter.Select_By_STD_DIV(drpstd.SelectedItem.Text, drpdiv.SelectedItem.Text); drpstudent.DataSource = StuDT; drpstudent.DataTextField = "rollno"; drpstudent.DataValueField = "sid"; drpstudent.DataBind(); drpstudent.Items.Insert(0, "SELECT"); }
protected void btnstudenlogin_Click(object sender, EventArgs e) { StuDT = StuAdapter.Select_LOGIN(txtstuuname.Text, txtstupass.Text); if (StuDT.Rows.Count == 1) { } else { lblstuerror.Text = "Login Error !!"; } }
protected void btnsend_Click(object sender, EventArgs e) { StuDT = StuAdapter.Select_UNAME(Session["sname"].ToString()); CompAdapter.Insert(StuDT.Rows[0]["rollno"].ToString(), StuDT.Rows[0]["Name"].ToString(), txtsubj.Text, txtmsg.Text, "Pending"); CompDT = CompAdapter.SelectCompalin(); GridView1.DataSource = CompDT; GridView1.DataBind(); lbl.Text = "complain Sent"; txtmsg.Text = ""; txtsubj.Text = ""; }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { StuDT = StuAdapter.Select_UNAME(Session["sname"].ToString()); lblname.Text = StuDT.Rows[0]["Name"].ToString(); lblroll.Text = StuDT.Rows[0]["rollno"].ToString(); ViewState["sid"] = StuDT.Rows[0]["SID"].ToString(); } }
protected void btnstudenlogin_Click(object sender, EventArgs e) { StuDT = StuAdapter.Select_LOGIN(txtstuuname.Text, txtstupass.Text); if (StuDT.Rows.Count == 1) { Session["sname"] = txtstuuname.Text; Response.Redirect("Student/Main.aspx"); } else { lblstuerror.Text = "Login Error !!"; } }
protected void btnchangepass_Click(object sender, EventArgs e) { StuDT = StuAdapter.Select_Check_Current_pas(txtcurrent.Text, Session["sname"].ToString()); if (StuDT.Rows.Count == 1) { StuAdapter.StudentMST_SELECT_ChangePass(txtnewpass.Text, Session["sname"].ToString()); lbl.Text = "Password Changed"; } else { lbl.Text = "Invalid Current Password"; } }
protected void btnreport_Click(object sender, EventArgs e) { if (drpmonth.SelectedIndex == 0) { lbl.Text = "Select month first !!"; } else { StuDT = StuAdapter.Select_UNAME(Session["sname"].ToString()); AttDT = AttAdapter.Select_Roll_month(StuDT.Rows[0]["rollno"].ToString(), "%" + drpmonth.SelectedValue + "%"); GridView1.DataSource = AttDT; GridView1.DataBind(); lbl.Text = "Result = " + GridView1.Rows.Count.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { StuDT = StuAdapter.Select_UNAME(Session["sname"].ToString()); lblname.Text = StuDT.Rows[0]["Name"].ToString(); lblroll.Text = StuDT.Rows[0]["rollno"].ToString(); txtemail.Text = StuDT.Rows[0]["email"].ToString(); txtmobile.Text = StuDT.Rows[0]["mobile"].ToString(); txtadd.Text = StuDT.Rows[0]["add"].ToString(); txtcity.Text = StuDT.Rows[0]["city"].ToString(); txtpin.Text = StuDT.Rows[0]["pincode"].ToString(); Imgprofile.ImageUrl = StuDT.Rows[0]["image"].ToString(); ViewState["sid"] = StuDT.Rows[0]["SID"].ToString(); } }
protected void btnstuadd_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath("~/Studentimg/" + FileUpload1.FileName)); DateTime bdate = Convert.ToDateTime(drpdd.SelectedItem.Text + " " + drpmm.SelectedItem.Text + " " + drpyyyy.SelectedItem.Text); StuAdapter.Insert(txtroll.Text, txtname.Text, lblstd.Text, drpdiv.SelectedItem.Text, txtemail.Text, txtmobi.Text, bdate.GetDateTimeFormats()[8].ToString(), "~/Studentimg/" + FileUpload1.FileName, txtadd.Text, txtcity.Text, txtpin.Text, txtuname.Text, txtpass.Text); lblmsg.Text = "Student Added."; txtname.Text = ""; txtadd.Text = ""; txtcity.Text = ""; txtemail.Text = ""; txtmobi.Text = ""; txtpass.Text = ""; txtpin.Text = ""; txtuname.Text = ""; txtcpass.Text = ""; drpdd.SelectedIndex = 0; drpmm.SelectedIndex = 0; drpyyyy.SelectedIndex = 0; DivDT = DivAdapter.SELECT_BY_ID(Convert.ToInt32(drpdiv.SelectedValue)); lblcnt.Text = "Total Seat = " + DivDT.Rows[0]["Seat"].ToString(); MultiView1.ActiveViewIndex = 0; StuDT = StuAdapter.Select_By_STD_DIV(lblstd.Text, drpdiv.SelectedItem.Text); int rstu = Convert.ToInt32(DivDT.Rows[0]["Seat"].ToString()) - Convert.ToInt32(StuDT.Rows.Count.ToString()); lblstudent.Text = "Total Admitted =" + StuDT.Rows.Count.ToString() + " , Remaining Student = " + rstu; string stddd = lblstd.Text.Substring(0, 1); int rno = Convert.ToInt32(StuDT.Rows.Count.ToString()) + 1; if (rno.ToString().Length < 2) { string newrno = "0" + rno.ToString(); txtroll.Text = stddd + drpdiv.SelectedItem.Text + newrno; } else { txtroll.Text = stddd + drpdiv.SelectedItem.Text + rno; } } }
protected void btnsarch_Click(object sender, EventArgs e) { StuDT = StuAdapter.SELECT_BY_ID(Convert.ToInt32(drpstudent.SelectedValue)); if (StuDT.Rows.Count == 1) { lblroll.Text = StuDT.Rows[0]["rollno"].ToString(); lblname.Text = StuDT.Rows[0]["name"].ToString(); lblemail.Text = StuDT.Rows[0]["email"].ToString(); lblmobile.Text = StuDT.Rows[0]["mobile"].ToString(); lbldob.Text = StuDT.Rows[0]["dob"].ToString(); lbladd.Text = StuDT.Rows[0]["add"].ToString(); lblcity.Text = StuDT.Rows[0]["city"].ToString(); lblpin.Text = StuDT.Rows[0]["pincode"].ToString(); lbluname.Text = StuDT.Rows[0]["uname"].ToString(); lblpass.Text = StuDT.Rows[0]["pass"].ToString(); imgg.ImageUrl = StuDT.Rows[0]["image"].ToString(); MultiView1.ActiveViewIndex = 0; } else { MultiView1.ActiveViewIndex = -1; } }
protected void Button7_Click(object sender, EventArgs e) { DivDT = DivAdapter.SELECT_BY_ID(Convert.ToInt32(drpdiv.SelectedValue)); lblcnt.Text = "Total Seat = " + DivDT.Rows[0]["Seat"].ToString(); MultiView1.ActiveViewIndex = 0; StuDT = StuAdapter.Select_By_STD_DIV(lblstd.Text, drpdiv.SelectedItem.Text); int rstu = Convert.ToInt32(DivDT.Rows[0]["Seat"].ToString()) - Convert.ToInt32(StuDT.Rows.Count.ToString()); lblstudent.Text = "Total Admitted =" + StuDT.Rows.Count.ToString() + " , Remaining Student = " + rstu; string stddd = lblstd.Text.Substring(0, 1); int rno = Convert.ToInt32(StuDT.Rows.Count.ToString()) + 1; if (rno.ToString().Length < 2) { string newrno = "0" + rno.ToString(); txtroll.Text = stddd + drpdiv.SelectedItem.Text + newrno; } else { txtroll.Text = stddd + drpdiv.SelectedItem.Text + rno; } }