private void ShowStudyResults()
{
var db = new quanlydiemSinhVienEntities();
//var list = db.ketquahoctaps.ToList();
var lists = (from kq in db.ketquahoctaps
join mon in db.monhocs
on kq.monhoc_id equals mon.monhoc_id
join sv in db.sinhviens
on kq.mssv equals sv.mssv
select new
{
kq.kqht_id,
mon.tenMH,
kq.mssv,
sv.hovaten,
kq.chuyencan,
kq.giuaki,
kq.cuoiki,
kq.DTB
}).ToList();
this.lstStudyResults.DataSource = lists;
this.lstStudyResults.Refresh();
//this.lstStudyResults.Columns["kqht_id"].Visible = true;
//this.lstStudyResults.Columns["monhoc"].Visible = false;
//this.lstStudyResults.Columns["monhoc_id"].Visible = false;
//this.lstStudyResults.Columns["lophoc_id"].Visible = false;
}
private void btnSave_Click(object sender, EventArgs e)
{
sinhvien student = new sinhvien();
int class_id = ((lophoc)this.cboClass.SelectedItem).lophoc_id;
student.lophoc_id = class_id;
student.mssv = this.txtMSSV.Text;
student.hovaten = this.txtName.Text;
student.gioitinh = this.cboGender.Text;
student.sdt = this.txtPhoneNumber.Text;
student.email = this.txtMail.Text;
DateTime parsedDate = DateTime.Parse(this.dtpBirthday.Text);
student.ngaysinh = parsedDate;
try
{
var db = new quanlydiemSinhVienEntities();
db.sinhviens.Add(student);
db.SaveChanges();
MessageBox.Show("Thành Công");
}
catch (Exception)
{
MessageBox.Show("Thất Bại");
}
this.Close();
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
var db = new quanlydiemSinhVienEntities();
var newStudyResult = db.ketquahoctaps.Find(this.KetQuaHocTap.kqht_id);
newStudyResult.mssv = this.txtMssv.Text;
int diemCC = int.Parse(this.txtAttendance.Text);
newStudyResult.chuyencan = diemCC;
int diemGk = int.Parse(this.txtMidterm.Text);
newStudyResult.giuaki = diemGk;
int diemCK = int.Parse(this.txtFinalterm.Text);
newStudyResult.cuoiki = diemCK;
int diemTB = int.Parse(this.txtAverage.Text);
newStudyResult.DTB = diemTB;
db.Entry(newStudyResult).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Thành Công");
this.Close();
}
catch (Exception)
{
MessageBox.Show("Thất Bại");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ketquahoctap KQHT = new ketquahoctap();
//int class_id = ((lophoc)this.cboClass.SelectedItem).lophoc_id;
//KQHT.lophoc_id = class_id;
int monhoc_id = ((monhoc)this.cboSubject.SelectedItem).monhoc_id;
KQHT.monhoc_id = monhoc_id;
KQHT.mssv = this.txtMssv.Text;
int diemCC = int.Parse(txtAttendance.Text);
KQHT.chuyencan = diemCC;
int diemGK = int.Parse(txtMidterm.Text);
KQHT.giuaki = diemGK;
int diemCK = int.Parse(txtFinalterm.Text);
KQHT.cuoiki = diemCK;
int diemTB = int.Parse(txtAverage.Text);
KQHT.DTB = diemTB;
try
{
quanlydiemSinhVienEntities db = new quanlydiemSinhVienEntities();
db.ketquahoctaps.Add(KQHT);
db.SaveChanges();
MessageBox.Show("Thành Công");
this.Close();
}
catch (Exception)
{
MessageBox.Show("Thất Bại");
}
this.Close();
}
private void btnDeleteStudyResults_Click(object sender, EventArgs e)
{
var db = new quanlydiemSinhVienEntities();
if (MessageBox.Show("Bạn có muốn xóa không ?", "Confirm", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
for (int i = 0; i < this.lstStudyResults.SelectedRows.Count; i++)
{
var row = this.lstStudyResults.SelectedRows[i];
var item = (ketquahoctap)row.DataBoundItem;
try
{
ketquahoctap KetQuaHocTap = db.ketquahoctaps.Find(item.kqht_id);
db.ketquahoctaps.Remove(KetQuaHocTap);
db.SaveChanges();
MessageBox.Show("Thành Công");
}
catch (Exception)
{
MessageBox.Show("Thất Bại");
}
}
}
this.ShowStudyResults();
}
private void btnDeleteClass_Click(object sender, EventArgs e)
{
var db = new quanlydiemSinhVienEntities();
if (MessageBox.Show("Bạn có muốn xóa ?", "Confim", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
for (int i = 0; i < lstClass.SelectedRows.Count; i++)
{
var row = this.lstClass.SelectedRows[i];
var item = (lophoc)row.DataBoundItem;
try
{
lophoc lop = db.lophocs.Find(item.lophoc_id);
db.lophocs.Remove(lop);
db.SaveChanges();
MessageBox.Show("Thành Công");
}
catch (Exception)
{
MessageBox.Show("Thất Bại");
}
}
}
this.ShowClassList();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
var db = new quanlydiemSinhVienEntities();
var newStudent = db.sinhviens.Find(this.SinhVien.mssv);
//int class_id = ((lophoc)this.cboClass.SelectedItem).lophoc_id;
//newStudent.lophoc_id = class_id;
newStudent.mssv = this.txtMSSV.Text;
newStudent.hovaten = this.txtName.Text;
DateTime parsedate = DateTime.Parse(this.dtpBirthday.Text);
newStudent.ngaysinh = parsedate;
newStudent.gioitinh = this.cboGender.Text;
newStudent.sdt = this.txtPhoneNumber.Text;
newStudent.email = this.txtMail.Text;
db.Entry(newStudent).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Thành Công");
this.Close();
}
catch (Exception)
{
MessageBox.Show("Thất Bại");
}
}
private void btnDeleteSubject_Click(object sender, EventArgs e)
{
var db = new quanlydiemSinhVienEntities();
if (MessageBox.Show("Bạn có muốn xóa Môn học này không ?", "Confim", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
for (int i = 0; i < lstSubject.SelectedRows.Count; i++)
{
var row = this.lstSubject.SelectedRows[i];
var item = (monhoc)row.DataBoundItem;
try
{
monhoc MonHoc = db.monhocs.Find(item.monhoc_id);
db.monhocs.Remove(MonHoc);
db.SaveChanges();
MessageBox.Show("Thành Công");
}
catch (Exception)
{
MessageBox.Show("Thất Bại");
}
}
}
this.ShowSubjectList();
}
private void FormStudyResultBySubject_Load(int studyResult_id)
{
quanlydiemSinhVienEntities db = new quanlydiemSinhVienEntities();
var lists = (from kq in db.ketquahoctaps
join mon in db.monhocs
on kq.monhoc_id equals mon.monhoc_id
join sv in db.sinhviens
on kq.mssv equals sv.mssv
where kq.monhoc_id == studyResult_id
select new
{
kq.kqht_id,
mon.tenMH,
kq.mssv,
sv.hovaten,
kq.chuyencan,
kq.giuaki,
kq.cuoiki,
kq.DTB
}).ToList();
//var list = db.ketquahoctaps.Where(b => b.monhoc_id == studyResult_id).ToList();
//this.lstStudyResults.DataSource = list;
//this.lstStudyResults.Columns["kqht_id"].Visible = false;
//this.lstStudyResults.Columns["tenMH"].Visible = false;
//this.lstStudyResults.Columns["monhoc_id"].Visible = false;
this.lstStudyResults.DataSource = lists;
this.lstStudyResults.Refresh();
}
private ketquahoctap findKetQuaHocTapByID(int id)
{
quanlydiemSinhVienEntities db = new quanlydiemSinhVienEntities();
var value = db.ketquahoctaps.Where(b => b.kqht_id == id).FirstOrDefault();
return(value);
}
private void btnDeleteStudent_Click(object sender, EventArgs e)
{
var db = new quanlydiemSinhVienEntities();
if (MessageBox.Show("Bạn có muốn xóa ?", "Confim", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
for (int i = 0; i < lstStudent.SelectedRows.Count; i++)
{
var row = this.lstStudent.SelectedRows[i];
var item = (sinhvien)row.DataBoundItem;
try
{
sinhvien SinhVien = db.sinhviens.Find(item.mssv);
db.sinhviens.Remove(SinhVien);
db.SaveChanges();
MessageBox.Show("Thành Công");
this.Close();
}
catch (Exception)
{
MessageBox.Show("Thất Bại");
}
}
this.ShowStudentList();
}
}
private void FormSubject_Load(object sender, EventArgs e)
{
var db = new quanlydiemSinhVienEntities();
this.cboSubjectBySemester.DataSource = db.hockies.ToList(); // load list semester and assign to combobox
this.cboSubjectBySemester.ValueMember = "hocki_id"; // set a value semester
this.cboSubjectBySemester.DisplayMember = "tenhocky"; // set the display semester
}
private void FormAddSubject_Load(object sender, EventArgs e)
{
var db = new quanlydiemSinhVienEntities();
this.cboSemester.DataSource = db.hockies.ToList();
this.cboSemester.ValueMember = "hocki_id";
this.cboSemester.DisplayMember = "tenhocky";
}
private void FormStudent_Load(object sender, EventArgs e)
{
var db = new quanlydiemSinhVienEntities();
this.cboFillterByClass.DataSource = db.lophocs.ToList(); // load list class and assign to combobox
this.cboFillterByClass.ValueMember = "lophoc_id"; // set a value class
this.cboFillterByClass.DisplayMember = "tenlop"; // set the display class
}
private void ShowClassList()
{
var db = new quanlydiemSinhVienEntities();
var list = db.lophocs.ToList();
this.lstClass.DataSource = list;
this.lstClass.Columns["sinhviens"].Visible = false;
//this.lstClass.Columns["ketquahoctaps"].Visible = false;
}
private void FormAddStudyResults_Load(object sender, EventArgs e)
{
var db = new quanlydiemSinhVienEntities();
this.cboSemester.DataSource = db.hockies.ToList(); // load list subject and assign to combobox
this.cboSemester.ValueMember = "hocki_id"; // set a value subject
this.cboSemester.DisplayMember = "tenhocky"; // set the display subject
//this.cboStudyResultBySubject.Enabled = false;
}
private void ShowStudentList()
{
var db = new quanlydiemSinhVienEntities();
var list = db.sinhviens.ToList();
this.lstStudent.DataSource = list;
this.lstStudent.Columns["lophoc_id"].Visible = false;
this.lstStudent.Columns["lophoc"].Visible = false;
}
private void FormStudentByClass_Load(int class_id)
{
var db = new quanlydiemSinhVienEntities();
var listByClass = db.sinhviens.Where(b => b.lophoc_id == class_id).ToList();
lstStudent.DataSource = listByClass;
this.lstStudent.Columns["lophoc_id"].Visible = false;
this.lstStudent.Columns["lophoc"].Visible = false;
}
private void FormEditSubject_Load(object sender, EventArgs e)
{
var db = new quanlydiemSinhVienEntities();
this.cboSemester.Text = MonHoc.hocki_id.ToString();
this.cboSemester.Enabled = false;
this.txtSubjectId.Text = MonHoc.maMH;
this.txtSubjectId.Enabled = false;
this.txtSubjectName.Text = MonHoc.tenMH;
}
private void ShowSubjectList()
{
var db = new quanlydiemSinhVienEntities();
var list = db.monhocs.ToList();
this.lstSubject.DataSource = list;
this.lstSubject.Columns["monhoc_id"].Visible = false;
this.lstSubject.Columns["hocki_id"].Visible = false;
this.lstSubject.Columns["ketquahoctaps"].Visible = false;
this.lstSubject.Columns["hocky"].Visible = false;
}
private void FormSubjectBySemester_Load(int HocKi_Id)
{
var db = new quanlydiemSinhVienEntities();
var listSubjectBySemester = db.monhocs.Where(b => b.hocki_id == HocKi_Id).ToList();
this.lstSubject.DataSource = listSubjectBySemester;
this.lstSubject.Columns["monhoc_id"].Visible = false;
this.lstSubject.Columns["hocki_id"].Visible = false;
this.lstSubject.Columns["ketquahoctaps"].Visible = false;
this.lstSubject.Columns["hocky"].Visible = false;
}
private void cboSubjectBySemester_SelectedIndexChanged(object sender, EventArgs e)
{
var db = new quanlydiemSinhVienEntities();
this.cboStudyResultBySubject.Enabled = true;
int semester_id = ((hocky)this.cboSubjectBySemester.SelectedItem).hocki_id;
this.cboStudyResultBySubject.DataSource = db.monhocs.Where(b => b.hocki_id == semester_id).ToList(); // load list subject and assign to combobox
this.cboStudyResultBySubject.ValueMember = "monhoc_id"; // set a value subject
this.cboStudyResultBySubject.DisplayMember = "tenMH"; // set the display subject
}
private void FormEditStudyResults_Load(object sender, EventArgs e)
{
quanlydiemSinhVienEntities db = new quanlydiemSinhVienEntities();
this.cboSubject.Text = KetQuaHocTap.monhoc_id.ToString();
this.cboSubject.Enabled = false;
this.txtMssv.Text = KetQuaHocTap.mssv;
this.cboSubject.Enabled = false;
this.txtAttendance.Text = KetQuaHocTap.chuyencan.ToString();
this.txtMidterm.Text = KetQuaHocTap.giuaki.ToString();
this.txtFinalterm.Text = KetQuaHocTap.cuoiki.ToString();
this.txtAverage.Text = KetQuaHocTap.DTB.ToString();
}
//private lophoc LopHoc;
private void FormEditStudent_Load(object sender, EventArgs e)
{
var db = new quanlydiemSinhVienEntities();
this.cboClass.Text = SinhVien.lophoc_id.ToString();
this.cboClass.Enabled = false;
this.txtMSSV.Text = SinhVien.mssv;
this.txtMSSV.Enabled = false;
this.txtName.Text = SinhVien.hovaten;
this.dtpBirthday.Text = SinhVien.ngaysinh.ToString();
this.cboGender.Text = SinhVien.gioitinh;
this.txtPhoneNumber.Text = SinhVien.sdt;
this.txtMail.Text = SinhVien.email;
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
var db = new quanlydiemSinhVienEntities();
var newClass = db.lophocs.Find(this.lop.lophoc_id);
newClass.tenlop = this.txtName.Text;
db.Entry(newClass).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Thành Công");
this.Close();
}
catch (Exception)
{
MessageBox.Show("Thất Bại");
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
lophoc qllophoc = new lophoc();
qllophoc.tenlop = this.txtName.Text;
try
{
var db = new quanlydiemSinhVienEntities();
db.lophocs.Add(qllophoc);
db.SaveChanges();
MessageBox.Show("Thành Công");
}
catch (Exception)
{
MessageBox.Show("Thất Bại");
}
this.Close();
}
private void btnSave_Click(object sender, EventArgs e)
{
monhoc MonHoc = new monhoc();
int semester_id = ((hocky)this.cboSemester.SelectedItem).hocki_id;
MonHoc.hocki_id = semester_id;
MonHoc.maMH = this.txtSubjectId.Text;
MonHoc.tenMH = this.txtSubjectName.Text;
try
{
var db = new quanlydiemSinhVienEntities();
db.monhocs.Add(MonHoc);
db.SaveChanges();
MessageBox.Show("Thành Công");
}
catch (Exception)
{
MessageBox.Show("Thất Bại");
}
this.Close();
}
private void FormEditClass_Load(object sender, EventArgs e)
{
var db = new quanlydiemSinhVienEntities();
this.txtName.Text = lop.tenlop;
}
