protected void Button_submit_Click(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); IList <Payment> res = sf.SearchPayment(DateTime.Parse(TextBox1.Text), DateTime.Parse(TextBox2.Text)); bind(res); ShowTotal(res); }
protected void Button3_Click(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); IList <Payment> res = sf.SearchPayment(ushort.Parse(DropDownList_pf.SelectedValue)); bind(res); ShowTotal(res); }
protected void Button_all_Click(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); IList <Payment> res = sf.SearchPayment(uint.Parse(DropDownList_stu.SelectedValue), ushort.Parse(DropDownList_pf.SelectedValue), DateTime.Parse(TextBox1.Text), DateTime.Parse(TextBox2.Text)); bind(res); ShowTotal(res); }
protected void DropDownList_stu_SelectedIndexChanged(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); uint snum = uint.Parse(DropDownList_stu.SelectedValue); Student stu = sf.SearchStudent(snum); Label_name.Text = stu.Name; Label_birth.Text = stu.Birth.ToLongDateString(); Label_jodate.Text = stu.Joindate.ToLongDateString(); Label_mobile.Text = stu.Mobile; Label_email.Text = stu.Email; Label_addr.Text = stu.Address; bind(sf.SearchPayment(snum)); bind(sf.SearchStudentRank(snum)); bind(sf.SearchAttendanceSNUM(snum)); Label1.Text = Label2.Text = ""; IList <StuParent> spr = sf.SearchStuParent(snum); for (int i = 0; i < spr.Count; i++) { if (spr[i].Stpar == true) { Student pst = sf.SearchStudent(spr[i].Spnum); if (spr[i].Mord == true) { Label1.Text = "Student Number: " + pst.Stnum + ", <br />Name: " + pst.Name + ", <br />Birthday: " + pst.Birth.ToShortDateString() + ", <br />Join Date: " + pst.Joindate.ToShortDateString() + ", <br />Address: " + pst.Address + ", <br />Phone Number: " + pst.Mobile + ", <br />Email: " + pst.Email; } else { Label2.Text = "Student Number: " + pst.Stnum + ", <br />Name: " + pst.Name + ", <br />Birthday: " + pst.Birth.ToShortDateString() + ", <br />Join Date: " + pst.Joindate.ToShortDateString() + ", <br />Address: " + pst.Address + ", <br />Phone Number: " + pst.Mobile + ", <br />Email: " + pst.Email; } } else { Parent par = sf.SearchParent(spr[i].Spnum); if (spr[i].Mord == true) { Label1.Text = "Name: " + par.Name + ", <br />Phone Number: " + par.Mobile + ", <br />Email: " + par.Email; } else { Label2.Text = "Name: " + par.Name + ", <br />Phone Number: " + par.Mobile + ", <br />Email: " + par.Email; } } } }