private void buttondongy_Click(object sender, EventArgs e)
{
var tenlop = texttenlop.Text;
var phonghoc = textphonghoc.Text;
if (lophoc == null)
{
System.Random rd = new Random();
var lop = new Classroom
{
//ID = Guid.NewGuid().ToString(),
ID = "ML00" + rd.Next(1, 100000),
Name = tenlop,
Room = phonghoc
};
var db = new APPQLSVDBContext();
db.Classrooms.Add(lop);
db.SaveChanges();
DialogResult = DialogResult.OK;
}
else
{
var db = new APPQLSVDBContext();
var lop = db.Classrooms.Where(t => t.ID == lophoc.ID).FirstOrDefault();
lop.Name = tenlop;
lop.Room = phonghoc;
db.SaveChanges();
DialogResult = DialogResult.OK;
}
}
void loadcombobox()
{
var db = new APPQLSVDBContext();
var cbbox = db.Classrooms.OrderBy(e => e.ID).ToList();
for (int i = 0; i < cbbox.Count; i++)
{
cbMalop.Items.Add(cbbox.ElementAt(i).ID);
}
}
private void button1_Click(object sender, EventArgs e)
{
var firstname = txtfirstnam.Text;
var lastname = txtlastname.Text;
var dob = txtbirthday.Value;
var pod = txtpod.Text;
var gender = 0;
var idclassrom = cbMalop.Text;
if (rdbMale.Checked == true)
{
gender = 0;
}
else if (rdbFeMale.Checked == true)
{
gender = 1;
}
else if (rdbOthersexual.Checked == true)
{
gender = 3;
}
if (sinhvien == null)
{
System.Random rd = new Random();
var sv = new Student
{
//ID = Guid.NewGuid().ToString(),
ID = "17T102" + rd.Next(1, 100000),
FirstName = firstname,
LastName = lastname,
DateOfBirth = dob,
PlaceOfBirth = pod,
Gender = gender,
IDClassRoom = idclassrom
};
var db = new APPQLSVDBContext();
db.Students.Add(sv);
db.SaveChanges();
DialogResult = DialogResult.OK;
}
else
{
var db = new APPQLSVDBContext();
var newsv = db.Students.Where(t => t.ID == sinhvien.ID).FirstOrDefault();
newsv.FirstName = firstname;
newsv.LastName = lastname;
newsv.DateOfBirth = dob;
newsv.PlaceOfBirth = pod;
newsv.Gender = gender;
newsv.IDClassRoom = idclassrom;
db.SaveChanges();
DialogResult = DialogResult.OK;
}
}
private void bdslophoc_CurrentChanged(object sender, EventArgs e)
{
var lopdangchon = bdslophoc.Current as ClassRoomViewModel;
if (lopdangchon != null)
{
var db = new APPQLSVDBContext();
var dssv = db.Students.Where(t => t.IDClassRoom == lopdangchon.ID).ToList();
bdssinhvien.DataSource = dssv;
girdsinhvien.DataSource = bdssinhvien;
}
}
void LoadDanhSachLopHoc()
{
APPQLSVDBContext db = new APPQLSVDBContext();
var ls = db.Classrooms.Select(e => new ClassRoomViewModel
{
ID = e.ID,
Name = e.Name,
Room = e.Room,
TotalStudent = e.Students.Count,
TotalFemale = e.Students.Where(t => t.Gender == 1).Count(),
TotalMale = e.Students.Where(t => t.Gender == 0).Count(),
}).OrderBy(e => e.Name).ToList();
bdslophoc.DataSource = ls;
girdlophoc.DataSource = bdslophoc;
}
private void btnxoalop_Click(object sender, EventArgs e)
{
var lopdangchon = bdslophoc.Current as Classroom;
if (lopdangchon != null)
{
var rs = MessageBox.Show("Bạn có thật sự muốn xóa không ?", "Chú ý", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (rs == DialogResult.OK)
{
//xóa lớp đang chọn
APPQLSVDBContext db = new APPQLSVDBContext();
var lop = db.Classrooms.Where(t => t.ID == lopdangchon.ID).FirstOrDefault();
if (lop != null)
{
db.Classrooms.Remove(lop);
db.SaveChanges();
LoadDanhSachLopHoc();
}
}
}
}
private void btnxoasinhvien_Click(object sender, EventArgs e)
{
var sinhviendangchon = bdssinhvien.Current as Student;
if (sinhviendangchon != null)
{
var rs = MessageBox.Show("Bạn có thật sự muốn xóa không ?", "Chú ý", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (rs == DialogResult.OK)
{
//xóa lớp đang chọn
APPQLSVDBContext db = new APPQLSVDBContext();
var sv = db.Students.Where(t => t.ID == sinhviendangchon.ID).FirstOrDefault();
if (sv != null)
{
db.Students.Remove(sv);
db.SaveChanges();
LoadDanhSachLopHoc();
}
}
}
}
