protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { UsFuns uf = new UsFuns(); User tmp = uf.UsrInfo(Session["login"].ToString()); if (Session["login"] == null) { Response.Write("<script language='javascript'>alert('Response Timeout, Please Try Again.'); location.href='login.aspx'</script>"); } else if (tmp.Admin == '2') { this.U_service1.Visible = false; this.U_showmsg1.Visible = false; this.U_showpet1.Visible = false; this.Button_submit.Visible = false; this.DropDownList_pet.Visible = false; SqlFuns sf = new SqlFuns(); bindusr(sf.SearchUserByPermission('1')); } else { Response.Write("<script language='javascript'>alert('Response Timeout, Please Try Again.'); location.href='login.aspx'</script>"); } } }
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 Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SqlFuns sf = new SqlFuns(); bind(sf.SearchStudent(true)); } }
protected void show_usr(object sender, CommandEventArgs e) { SqlFuns sf = new SqlFuns(); bindpet(sf.SearchPetByUsrid(e.CommandName.ToString())); this.DropDownList_pet.Visible = true; DropDownList_pet_SelectedIndexChanged(sender, e); }
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 show_pet(object sender, CommandEventArgs e) { this.U_pet1.Visible = true; SqlFuns sf = new SqlFuns(); this.U_pet1.pet = sf.SearchPetById(int.Parse(e.CommandName.ToString())); this.U_pet1.Visible = true; this.Button_update.Visible = true; this.Button_submit_pet.Visible = true; }
protected void Button_submit_pet_Click(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); int result = sf.EditPet(this.U_pet1.pet); if (result > 0) { Response.Write("<script language='javascript'>alert('Create Successfully.'); location.href='manager.aspx</script>"); } else { Response.Write("<script language='javascript'>alert('Failed, Please Connect System Manager.');</script>"); } }
protected void Button_update_Click(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); int result = sf.EditUser(this.U_usr1.user); if (result > 0) { Response.Write("<script language='javascript'>alert('Update Successfully.'); location.href='manager.aspx'</script>"); } else { Response.Write("<script language='javascript'>alert('Failed, Please Connect System Manager.');</script>"); } }
static void Main(string[] args) { SqlFuns sf = new SqlFuns(); IList <Student> st = sf.SearchStudent(true); for (int i = 2; i < st.Count; i++) { StudentRank t = new StudentRank(); t.Stnum = st[i].Stnum; t.Rank = 1; t.Date = st[i].Joindate; sf.AddStudentRank(t); } }
protected void Button_login_Click(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); UsFuns uf = new UsFuns(); Member login = uf.UserLogin(TextBox_usr.Text, TextBox_pwd.Text); if (login != null) { Response.Write("<script language='javascript'>alert('Login Succed.'); location.href='Manage.aspx'</script>"); } else { Response.Write("<script language='javascript'>alert('Failed!!! Please login again.')</script>"); } }
protected void show_usr(object sender, CommandEventArgs e) { SqlFuns sf = new SqlFuns(); bindpet(sf.SearchPetByUsrid(e.CommandName.ToString())); this.U_usr1.user = sf.SearchUserById(e.CommandName.ToString()); this.U_usr1.Visible = true; this.U_usr2.Visible = false; this.U_pet1.Visible = false; this.U_pet1.Visible = false; this.Repeater_petlist.Visible = true; this.Button_newpet.Visible = true; this.Button_update.Visible = true; this.Button_submit_pet.Visible = false; this.Button_insert.Visible = false; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["login"] == null) { Response.Write("<script language='javascript'>alert('Response Timeout, Please Try Again.'); location.href='login.aspx'</script>"); } else { SqlFuns sf = new SqlFuns(); IList <Pet> pets = sf.SearchPetByUsrid(Session["login"].ToString()); bindpet(pets); DropDownList_pet_SelectedIndexChanged(sender, e); } } }
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; } } } }
static void Main(string[] args) { SqlFuns sf = new SqlFuns(); for (int i = 4; i <= 30; i++) { StuParent sp0 = new StuParent(); StuParent sp1 = new StuParent(); sp0.Stnum = uint.Parse(i + ""); sp1.Stnum = uint.Parse(i + ""); sp0.Mord = true; sp1.Mord = false; Random r = new Random(); double seed = r.NextDouble(); if (seed > 0.5) { sp0.Stpar = true; double stmp = r.NextDouble() * 30; sp0.Spnum = (uint)(stmp % 30); } else { sp0.Stpar = false; double stmp = r.NextDouble() * 10; sp0.Spnum = (uint)(stmp % 10); } sf.AddStuParent(sp0); double sed = r.NextDouble(); if (sed > 0.5) { sp0.Stpar = true; double stmp = r.NextDouble() * 30; sp0.Spnum = (uint)(stmp % 30); } else { sp0.Stpar = false; double stmp = r.NextDouble() * 10; sp0.Spnum = (uint)(stmp % 10); } sf.AddStuParent(sp1); } }
protected void Button_submit_Click(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); Services tmp = this.U_service1.services; tmp.Date = DateTime.Now; tmp.Peid = int.Parse(this.DropDownList_pet.SelectedValue); int result = sf.AddServices(tmp); if (result > 0) { Response.Write("<script language='javascript'>alert('Submit Successfully.');</script>"); //Response.Redirect("manager.aspx"); } else { Response.Write("<script language='javascript'>alert('Failed, Please Connect System Manager.');</script>"); } }
protected void DropDownList_pet_SelectedIndexChanged(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); IList <Pet> pets = sf.SearchPetByUsrid(Session["login"].ToString()); this.U_showpet1.petinfo = pets[DropDownList_pet.SelectedIndex]; IList <Services> pslist = sf.SearchServicesByPeid(pets[DropDownList_pet.SelectedIndex].ID); if (pslist != null) { this.U_showmsg1.msgdata = pslist; DateTime ndt = pslist[0].Date.AddHours(sf.SearchOperationById(pslist[0].Operation).NextTime); this.Label_lasttime.Text = ndt.ToString(); } else { this.Label_lasttime.Text = ""; } }
protected void Button_submit_Click(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); Attendance tmp = new Attendance(); tmp.Course = uint.Parse(DropDownList_cos.SelectedValue); tmp.Student = uint.Parse(DropDownList_stu.SelectedValue); tmp.Date = DateTime.Parse(TextBox_dt.Text); int result = sf.AddAttendance(tmp); if (result > 0) { Response.Write("<script language='javascript'>alert('Success!!!');</script>"); } else { Response.Write("<script language='javascript'>alert('Failed!!!');</script>"); } }
protected void Button_submit_Click(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); Payment tmp = new Payment(); tmp.Stnum = uint.Parse(DropDownList_stu.SelectedValue); tmp.Payfor = ushort.Parse(DropDownList_pf.SelectedValue); tmp.Fee = double.Parse(TextBox_fee.Text); tmp.Paydt = DateTime.Now; int result = sf.AddPayment(tmp); if (result > 0) { Response.Write("<script language='javascript'>alert('Success!!!');</script>"); } else { Response.Write("<script language='javascript'>alert('Failed!!!');</script>"); } }
protected void DropDownList_pet_SelectedIndexChanged(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); Pet ptmp = sf.SearchPetById(int.Parse(DropDownList_pet.SelectedValue)); this.U_showpet1.petinfo = ptmp; this.U_showpet1.Visible = true; this.U_service1.Visible = true; this.Button_submit.Visible = true; IList <Services> pslist = sf.SearchServicesByPeid(ptmp.ID); if (pslist != null) { this.U_showmsg1.Visible = true; this.U_showmsg1.msgdata = pslist; DateTime ndt = pslist[0].Date.AddHours(sf.SearchOperationById(pslist[0].Operation).NextTime); } else { } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { UsFuns uf = new UsFuns(); User tmp = uf.UsrInfo(Session["login"].ToString()); if (Session["login"] == null) { Response.Write("<script language='javascript'>alert('Response Timeout, Please Try Again.'); location.href='login.aspx'</script>"); } else if (tmp.Admin == '0') { SqlFuns sf = new SqlFuns(); bindusr(sf.SearchUserAll()); } else { Response.Write("<script language='javascript'>alert('Response Timeout, Please Try Again.'); location.href='login.aspx'</script>"); } } }
protected void Button_newpet_Click(object sender, EventArgs e) { Pet newpet = new Pet(); newpet.Usid = this.U_usr1.user.Username; newpet.Name = "Default"; newpet.Birth = DateTime.Now; newpet.Species = 0; newpet.Gender = '2'; newpet.Image0 = "Default.png"; SqlFuns sf = new SqlFuns(); int result = sf.AddPet(newpet); if (result > 0) { Response.Write("<script language='javascript'>alert('Create Successfully.'); location.href='manager.aspx</script>"); } else { Response.Write("<script language='javascript'>alert('Failed, Please Connect System Manager.');</script>"); } }
protected void DropDownList_dow_SelectedIndexChanged(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); bind(sf.SearchTimetable(short.Parse(DropDownList_dow.SelectedValue))); }
protected void DropDownList_req_SelectedIndexChanged(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); bind(sf.SearchRequirement(uint.Parse(DropDownList_req.SelectedValue))); }
protected void DropDownList_level_SelectedIndexChanged(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); bind(sf.SearchCourseLEVEL(ushort.Parse(DropDownList_level.SelectedValue))); }
protected void Page_Load(object sender, EventArgs e) { SqlFuns sf = new SqlFuns(); bind_operation(sf.SearchOperationAll()); }