protected void btnLogin_Click(object sender, EventArgs e) { db = new ScoreManageDataContext(); string username = txtUser.Value; string password = txtPass.Value; var myquery = from i in db.Accounts join j in db.Students on i.Username equals j.ID where i.Username == username && i.Password == password select new { i.Username, j.FirstName, j.LastName }; if (myquery.Any()) { Session["id"] = myquery.First().Username; Session["username"] = myquery.First().FirstName + " " + myquery.First().LastName; Response.Redirect("SVHome.aspx"); } else { var myquery2 = from i in db.Accounts join j in db.Lecturers on i.Username equals j.ID where i.Username == username && i.Password == password select new { i.Username, j.FirstName, j.LastName }; if (myquery2.Any()) { Session["id"] = myquery2.First().Username; Session["username"] = myquery2.First().FirstName + " " + myquery2.First().LastName; Response.Redirect("LopHocPhanGV.aspx"); } else { Response.Write("<script>alert('Đăng nhập thất bại mời thử lại')</script>"); } } }
protected void btnXem_Click(object sender, EventArgs e) { db = new ScoreManageDataContext(); string id = Session["id"].ToString(); var namhoc = DropNamhoc.SelectedValue.ToString(); var hocky = Convert.ToInt32(Drophocky.SelectedValue.ToString()); var monhoc = DropMonhoc.SelectedValue.ToString(); var query = from en in db.Enrollments join sc in db.Scores on en.ID equals sc.IDEnrollment join sct in db.SchoolTerms on en.IdSchoolTerm equals sct.ID join st in db.Students on sc.IDStudent equals st.ID join t in db.Terms on en.IDTerm equals t.ID where st.ID == id && sct.SchoolYear == namhoc && t.Name == monhoc select new { t.Name, sc.Diligent, sc.MidTerm, sc.Pratice, sc.Exam, Tongket = (((double)sc.Diligent * 0.1 + (double)sc.MidTerm * 0.2 + ((double)sc.Exam * 45 + (double)sc.Pratice * 15)) / 60).ToString().Substring(0, 4), Diemhe4 = (((((double)sc.Diligent * 0.1 + (double)sc.MidTerm * 0.2 + ((double)sc.Exam * 45 + (double)sc.Pratice * 15)) / 60) * 4) / 10).ToString().Substring(0, 4), sc.Evaluate }; GridView1.DataSource = query; GridView1.DataBind(); }
protected void btnkiemtra_Click(object sender, EventArgs e) { db = new ScoreManageDataContext(); AddModal.Visible = true; var query = from st in db.Students where st.ID == txtaddSV.Text select st; if (query.Any()) { var query2 = from i in db.Students join sc in db.Scores on i.ID equals sc.IDStudent where sc.IDStudent == query.First().ID select sc; if (query2.Any()) { thongbao.Text = "Sinh viên đã tồn tại trong lớp"; lbNameSV.Text = ""; btnThem.Visible = false; } else { thongbao.Text = "Bạn có muốn thêm sinh viên: "; lbNameSV.Text = query.First().FirstName + " " + query.First().LastName; } } else { thongbao.Text = "Sinh viên không tồn tại"; lbNameSV.Text = ""; btnThem.Visible = false; } }
protected void btnSave_Click(object sender, EventArgs e) { string id = Session["id"].ToString(); string username = Session["username"].ToString(); db = new ScoreManageDataContext(); string IDT = Dlist.SelectedValue.ToString(); var query = from l in db.Lecturers join en in db.Enrollments on l.ID equals en.IDLecturer join sc in db.Scores on en.ID equals sc.IDEnrollment join st in db.Students on sc.IDStudent equals st.ID join t in db.Terms on en.IDTerm equals t.ID where l.ID == id && t.ID == IDT && st.ID == txtmasv.Text select sc; Score myscore = query.FirstOrDefault(); myscore.Diligent = Convert.ToDouble(txtcc.Text); myscore.MidTerm = Convert.ToDouble(txtgk.Text); myscore.Pratice = Convert.ToDouble(txtth.Text); myscore.Exam = Convert.ToDouble(txtthi.Text); double tongket = (Convert.ToDouble(txtcc.Text) * 0.1 + Convert.ToDouble(txtgk.Text) * 0.2 + (Convert.ToDouble(txtthi.Text) * 45 + Convert.ToDouble(txtth.Text) * 15) / 60) * 0.7; if (tongket > 4.0) { myscore.Evaluate = "DAT"; } else { myscore.Evaluate = "KHONG DAT"; } db.SubmitChanges(); EditModal.Visible = false; //Response.Redirect("QLDiemGV.aspx"); Dlist_SelectedIndexChanged(sender, e); }
protected void Dlist_SelectedIndexChanged(object sender, EventArgs e) { string id = Session["id"].ToString(); string username = Session["username"].ToString(); string IDT = Dlist.SelectedValue.ToString(); db = new ScoreManageDataContext(); var query = from l in db.Lecturers join en in db.Enrollments on l.ID equals en.IDLecturer join sc in db.Scores on en.ID equals sc.IDEnrollment join st in db.Students on sc.IDStudent equals st.ID join t in db.Terms on en.IDTerm equals t.ID where l.ID == id && t.ID == IDT select new { st.FirstName, st.LastName, st.ID, sc.Diligent, sc.Pratice, sc.MidTerm, sc.Exam, Tongket = ((double)sc.Diligent * 0.1 + (double)sc.MidTerm * 0.2 + (((double)sc.Exam * 45 + (double)sc.Pratice * 15) / 60) * 0.7).ToString().Substring(0, 4) }; GridView1.DataSource = query; GridView1.DataBind(); }
protected void btnCapnhat_Click(object sender, EventArgs e) { string id = Session["id"].ToString(); db = new ScoreManageDataContext(); var query = from l in db.Students where l.ID == id select l; Student myStu = query.First(); myStu.FirstName = txtFname.Text; myStu.LastName = txtLname.Text; //myStu.Gender = txtGioitinh.SelectedValue.ToString(); myStu.DateOfBirth = DateTime.Parse(txtNgaysinh.Text); if (txtGioitinh.Text == "Nam") { myStu.Gender = true; } else { myStu.Gender = false; } myStu.Address = txtDiachi.Text; myStu.Phone = txtDienthoai.Text; db.SubmitChanges(); Response.Write("<script>alert('Cập nhật thành công'); window.location.href = 'SVHome.aspx';</script>"); }
protected void btnChange_Click(object sender, EventArgs e) { string id = Session["id"].ToString(); db = new ScoreManageDataContext(); var query = from i in db.Accounts where i.Username == id && i.Password == txtPass.Text select i; if (query.Any()) { if (txtnewPass.Text == txtrePass.Text) { Account myAcc = query.First(); myAcc.Password = txtnewPass.Text; db.SubmitChanges(); Response.Write("<script>alert('Đổi mật khẩu thành công'); window.location.href = 'PasswordSV.aspx'</script>"); //Response.Redirect("PasswordGv.aspx"); } else { Response.Write("<script>alert('Mật khẩu nhập lại không đúng');</script>"); } } else { Response.Write("<script>alert('Mật khẩu cũ sai!'); window.location.href = 'PasswordSV.aspx'</script>"); } }
protected void Page_Load(object sender, EventArgs e) { db = new ScoreManageDataContext(); string id = Session["id"].ToString(); string user = Session["username"].ToString(); accname.Text = user; var query = from st in db.Students join c in db.Conducts on st.ID equals c.IDStudent join sct in db.SchoolTerms on c.IDSchoolTerm equals sct.ID where st.ID == id select new { sct.SchoolYear, sct.Semester, c.ScoreOfConduct, c.Classification }; GridView1.DataSource = query; GridView1.DataBind(); }
protected void DropNamhoc_SelectedIndexChanged(object sender, EventArgs e) { db = new ScoreManageDataContext(); string id = Session["id"].ToString(); var monhoc = from en in db.Enrollments join sc in db.Scores on en.ID equals sc.IDEnrollment join sct in db.SchoolTerms on en.IdSchoolTerm equals sct.ID join st in db.Students on sc.IDStudent equals st.ID join t in db.Terms on en.IDTerm equals t.ID where st.ID == id && sct.SchoolYear == DropNamhoc.SelectedValue.ToString() select new { t.Name }; DropMonhoc.DataSource = monhoc; DropMonhoc.DataTextField = "Name"; DropMonhoc.DataBind(); Page_Load(sender, e); }
protected void btnXoa_Click(object sender, EventArgs e) { string id = Session["id"].ToString(); db = new ScoreManageDataContext(); string IDT = Dlist.SelectedValue.ToString(); DeleteModal.Visible = false; var query = from l in db.Lecturers join en in db.Enrollments on l.ID equals en.IDLecturer join sc in db.Scores on en.ID equals sc.IDEnrollment join st in db.Students on sc.IDStudent equals st.ID join t in db.Terms on en.IDTerm equals t.ID where l.ID == id && t.ID == IDT && st.ID == svID.Text select sc; db.Scores.DeleteAllOnSubmit(query); db.SubmitChanges(); Dlist_SelectedIndexChanged(sender, e); }
protected void Page_Load(object sender, EventArgs e) { string id = Session["id"].ToString(); string username = Session["username"].ToString(); accname.Text = username; db = new ScoreManageDataContext(); if (!IsPostBack) { var query = from l in db.Students where l.ID == id select new { l.ID, l.FirstName, l.LastName, l.DateOfBirth, l.Gender, l.Address, l.Phone }; txtMasv.Text = query.First().ID; txtFname.Text = query.First().FirstName; txtLname.Text = query.First().LastName; txtNgaysinh.Text = Convert.ToString(query.First().DateOfBirth); //txtGioitinh.SelectedValue.ToString(); string Gioitinh = Convert.ToString(query.First().Gender); if (Gioitinh == "True") { txtGioitinh.Text = "Nam"; } else { txtGioitinh.Text = "Nữ"; } txtDiachi.Text = query.First().Address; txtDienthoai.Text = query.First().Phone; accname.Text = username; } }
protected void Page_Load(object sender, EventArgs e) { string id = Session["id"].ToString(); string username = Session["username"].ToString(); db = new ScoreManageDataContext(); if (!IsPostBack) { var query = from l in db.Lecturers join s in db.Specializes on l.IdSpecialize equals s.ID join m in db.Majors on s.IdMajors equals m.ID join d in db.Departments on m.IDDepartment equals d.ID where l.ID == id select new { l.ID, l.FirstName, l.LastName, l.Degree, l.Position, l.Phone, l.Email, s.SpecializeName, mName = m.Name, dName = d.Name, }; txtMagv.Text = query.First().ID; txtFname.Text = query.First().FirstName; txtLname.Text = query.First().LastName; txtTrinhdo.Text = query.First().Degree; txtChucvu.Text = query.First().Position; txtDienthoai.Text = query.First().Phone; txtEmail.Text = query.First().Email; txtChuyennganh.Text = query.First().SpecializeName; txtNganh.Text = query.First().mName; txtKhoa.Text = query.First().dName; accName.Text = username; } }
protected void btnCapnhat_Click(object sender, EventArgs e) { string id = Session["id"].ToString(); db = new ScoreManageDataContext(); var query = from l in db.Lecturers join s in db.Specializes on l.IdSpecialize equals s.ID join m in db.Majors on s.IdMajors equals m.ID join d in db.Departments on m.IDDepartment equals d.ID where l.ID == id select l; Lecturer myLec = query.First(); myLec.FirstName = txtFname.Text; myLec.LastName = txtLname.Text; myLec.Degree = txtTrinhdo.Text; myLec.Position = txtChucvu.Text; myLec.Phone = txtDienthoai.Text; myLec.Email = txtEmail.Text; db.SubmitChanges(); Response.Write("<script>alert('Cập nhật thành công'); window.location.href = 'ProfileGV.aspx';</script>"); }
protected void btnThem_Click(object sender, EventArgs e) { string id = Session["id"].ToString(); string IDT = Dlist.SelectedValue.ToString(); db = new ScoreManageDataContext(); var query = from l in db.Lecturers join en in db.Enrollments on l.ID equals en.IDLecturer join sc in db.Scores on en.ID equals sc.IDEnrollment join st in db.Students on sc.IDStudent equals st.ID join t in db.Terms on en.IDTerm equals t.ID where l.ID == id && t.ID == IDT select en.ID; Score mysc = new Score(); mysc.IDEnrollment = query.First(); mysc.IDStudent = txtaddSV.Text; db.Scores.InsertOnSubmit(mysc); db.SubmitChanges(); AddModal.Visible = false; Dlist_SelectedIndexChanged(sender, e); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { db = new ScoreManageDataContext(); string id = Session["id"].ToString(); string username = Session["username"].ToString(); accname.Text = username; var query = from l in db.Lecturers join en in db.Enrollments on l.ID equals en.IDLecturer join sc in db.Scores on en.ID equals sc.IDEnrollment join st in db.Students on sc.IDStudent equals st.ID join t in db.Terms on en.IDTerm equals t.ID where l.ID == id select new { t.ID, t.Name }; Dlist.DataSource = query.Distinct(); Dlist.DataValueField = "ID"; Dlist.DataTextField = "Name"; Dlist.DataBind(); Dlist_SelectedIndexChanged(sender, e); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { db = new ScoreManageDataContext(); string id = Session["id"].ToString(); string user = Session["username"].ToString(); accname.Text = user; var namhoc = from i in db.SchoolTerms select i.SchoolYear; DropNamhoc.DataSource = namhoc.Distinct(); //DropNamhoc.DataTextField = "SchoolYear"; DropNamhoc.DataBind(); var query = from en in db.Enrollments join sc in db.Scores on en.ID equals sc.IDEnrollment join st in db.Students on sc.IDStudent equals st.ID join t in db.Terms on en.IDTerm equals t.ID where st.ID == id select new { t.Name, sc.Diligent, sc.MidTerm, sc.Pratice, sc.Exam, Tongket = ((double)sc.Diligent * 0.1 + (double)sc.MidTerm * 0.2 + (((double)sc.Exam * 45 + (double)sc.Pratice * 15) / 60) * 0.7).ToString().Substring(0, 4), Diemhe4 = ((((double)sc.Diligent * 0.1 + (double)sc.MidTerm * 0.2 + (((double)sc.Exam * 45 + (double)sc.Pratice * 15) / 60) * 0.7) * 4) / 10).ToString().Substring(0, 4), sc.Evaluate }; GridView1.DataSource = query; GridView1.DataBind(); } }
protected void Dlist_SelectedIndexChanged(object sender, EventArgs e) { string id = Session["id"].ToString(); string username = Session["username"].ToString(); string IDT = Dlist.SelectedValue.ToString(); db = new ScoreManageDataContext(); var query = from l in db.Lecturers join en in db.Enrollments on l.ID equals en.IDLecturer join sc in db.Scores on en.ID equals sc.IDEnrollment join st in db.Students on sc.IDStudent equals st.ID join t in db.Terms on en.IDTerm equals t.ID where l.ID == id && t.ID == IDT select new { st.FirstName, st.LastName, st.ID, st.DateOfBirth }; GridView1.DataSource = query; GridView1.DataBind(); }