private void btnDangNhap_Click(object sender, EventArgs e) { string username = txtTenDN.Text; string password = txtMatKhau.Text; if (rdbAd.Checked) { QLSVDataContext qlSV = new QLSVDataContext(); var tpQuery = (from tp in qlSV.Logins where tp.userName == txtTenDN.Text && tp.passWord == txtMatKhau.Text && tp.Quyen == rdbAd.Text select tp); if (tpQuery.Count() > 0) { string user = txtTenDN.Text; string pass = txtMatKhau.Text; MessageBox.Show("Đăng nhập thành công"); frmAdmin ad = new frmAdmin(user, pass, "Admin"); this.Hide(); ad.ShowDialog(); } else { MessageBox.Show("Sai tên đăng nhập hoặc mật khẩu"); txtTenDN.Select(); } } if (rdbMb.Checked) { QLSVDataContext qlSV = new QLSVDataContext(); var vpQuery = (from vp in qlSV.Logins where vp.userName == txtTenDN.Text.Trim() && vp.passWord == txtMatKhau.Text && vp.Quyen == rdbMb.Text select vp); if (vpQuery.Count() > 0) { string user = txtTenDN.Text; string pass = txtMatKhau.Text; MessageBox.Show("Đăng nhập thành công"); frmAdmin ad = new frmAdmin(user, pass, "Member"); this.Hide(); ad.ShowDialog(); } else { MessageBox.Show("Sai tên đăng nhập hoặc mật khẩu"); txtTenDN.Select(); } } }
void LoadDiem(string MaSV) { QLSVDataContext qlSV = new QLSVDataContext(); var tpQuery = (from tp in qlSV.KetQuas from up in qlSV.Mons where tp.maSV == MaSV && up.maMon == tp.maMon select new { tp.maMon, up.soTinChi, up.tenMon, tp.diemGiuaKi, tp.diemCuoiKi, tp.diemTB, up.hocKi, tp.ketQua, } ).ToList(); dgvDiem.DataSource = tpQuery; }
private void dgvSV_CellClick(object sender, DataGridViewCellEventArgs e) { int r = dgvSV.CurrentCell.RowIndex; this.txtMaSV.Text = dgvSV.Rows[r].Cells["maSV"].Value.ToString(); this.txttenSV.Text = dgvSV.Rows[r].Cells["hoTen"].Value.ToString(); this.dateTimePicker1.Text = dgvSV.Rows[r].Cells["ngaySinh"].Value.ToString(); this.txtGT.Text = dgvSV.Rows[r].Cells["gioiTinh"].Value.ToString(); QLSVDataContext qlSV = new QLSVDataContext(); var tpQuery = (from tp in qlSV.Mons from up in qlSV.KetQuas where tp.maMon == up.maMon && up.maSV == txtMaSV.Text orderby up.maSV, tp.hocKi select tp).ToList(); chartTC.DataSource = tpQuery; chartTC.ChartAreas["ChartArea1"].AxisX.Title = "Học Kì"; chartTC.ChartAreas["ChartArea1"].AxisY.Title = "Số tín chỉ"; chartTC.Series["Đăng kí"].XValueMember = "hocKi"; chartTC.Series["Đăng kí"].YValueMembers = "stcHoc"; chartTC.Series["Tích lũy"].XValueMember = "hocKi"; chartTC.Series["Tích lũy"].YValueMembers = "stcdau"; }