/// <summary>
/// Thêm một record vào table THOIKHOABIEU
/// thêm thành công trả về 1 và ngược lại
/// </summary>
public int Them(int MaLop, String MaGiaoVien, int Tiet)
{
int result = DB.usp_InsertThoiKhoaBieu(MaLop, MaGiaoVien, Tiet);
DB.SubmitChanges();
return(result);
}
private void btnDeleteClass_Click(object sender, EventArgs e)
{
QLHSDataContext context = new QLHSDataContext();
var Class = (from LopHoc in context.LOPHOCs
where LopHoc.MaLop == Int32.Parse(txtClass.Text)
select LopHoc).FirstOrDefault();
var students = (from student in context.HOCSINHs
where student.MaLop == Int32.Parse(txtClass.Text)
select student).ToList();
if (students.Count > 0)
{
context.HOCSINHs.DeleteAllOnSubmit(students);
context.SubmitChanges();
}
if (Class != null)
{
context.LOPHOCs.DeleteOnSubmit(Class);
context.SubmitChanges();
clearListClass();
showListClass();
txtClass.Text = "";
if (txtClass.Text != string.Empty)
{
var Class1 = context.LOPHOCs.Where(lh => lh.MaLop == Int32.Parse(txtClass.Text)).ToList();
if (Class1.Count == 0)
{
lbError.Show();
btnDeleteClass.Enabled = false;
btnUpdateClass.Enabled = false;
btnShowListStudent.Enabled = false;
}
}
else
{
lbError.Hide();
}
}
context.Dispose();
}
private void btnAdd_Click(object sender, EventArgs e)
{
HOCSINH hocsinh = new HOCSINH
{
MaHocSinh = Int32.Parse(txtIDStudent.Text),
TenHocSinh = txtFullName.Text,
NgaySinh = Convert.ToDateTime(dtNgaySinh.Text),
GioiTinh = txtSex.Text,
MaLop = Int32.Parse(txtIDClass.Text)
};
QLHSDataContext context = new QLHSDataContext();
context.HOCSINHs.InsertOnSubmit(hocsinh);
context.SubmitChanges();
context.Dispose();
this.Close();
}
private void btnAdd_Click(object sender, EventArgs e)
{
LOPHOC lophoc = new LOPHOC
{
MaLop = Int32.Parse(txtIDClass.Text),
SiSo = Int32.Parse(txtNumberOfStudent.Text),
LopTruong = Int32.Parse(txtClassPresident.Text),
GVQuanLy = Int32.Parse(txtIDTeacher.Text),
NamBatDau = Convert.ToDateTime(dateTimePicker1.Text),
NamKetThuc = Convert.ToDateTime(dateTimePicker2.Text)
};
QLHSDataContext context = new QLHSDataContext();
context.LOPHOCs.InsertOnSubmit(lophoc);
context.SubmitChanges();
context.Dispose();
this.Close();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
QLHSDataContext context = new QLHSDataContext();
var student = (from HocSinh in context.HOCSINHs
where HocSinh.MaHocSinh == Int32.Parse(txtIDStudent.Text)
select HocSinh).FirstOrDefault();
if (student != null)
{
student.MaLop = Int32.Parse(txtIDClass.Text);
student.NgaySinh = Convert.ToDateTime(dateTimePicker1.Text);
student.TenHocSinh = txtFullName.Text;
student.GioiTinh = txtSex.Text;
context.SubmitChanges();
}
context.Dispose();
this.Close();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
QLHSDataContext context = new QLHSDataContext();
var Class = (from LopHoc in context.LOPHOCs
where LopHoc.MaLop.ToString() == txtIDClass.Text
select LopHoc).FirstOrDefault();
if (Class != null)
{
Class.SiSo = Int32.Parse(txtNumberOfStudent.Text);
Class.LopTruong = Int32.Parse(txtClassPresident.Text);
Class.GVQuanLy = Int32.Parse(txtIDTeacher.Text);
Class.NamBatDau = Convert.ToDateTime(dateTimePicker1.Text);
Class.NamKetThuc = Convert.ToDateTime(dateTimePicker2.Text);
context.SubmitChanges();
}
context.Dispose();
this.Close();
}
private void btnDeleteStudent_Click(object sender, EventArgs e)
{
if (context == null)
{
context = new QLHSDataContext();
}
var Student = (from HocSinh in context.HOCSINHs
where HocSinh.MaHocSinh == Int32.Parse(txtStudent.Text)
select HocSinh).FirstOrDefault();
if (Student != null)
{
context.HOCSINHs.DeleteOnSubmit(Student);
context.SubmitChanges();
clearListStudent();
showListStudent();
txtStudent.Text = "";
if (txtStudent.Text != string.Empty)
{
var Student1 = context.HOCSINHs.Where(hs => hs.MaHocSinh.ToString() == txtStudent.Text);
if (Student1.Count() == 0)
{
btnDeleteStudent.Enabled = false;
btnUpdateStudent.Enabled = false;
lbError.Hide();
}
else
{
lbError.Show();
}
}
else
{
lbError.Hide();
}
}
context.Dispose();
}
/// <summary>
/// thêm một học sinh vào bảng
/// </summary>
/// <param name="_HoTen"></param>
/// <param name="_DiaChi"></param>
/// <param name="_NgaySinh"></param>
/// <param name="_Email"></param>
/// <param name="_GioiTinh"></param>
public void Them(String _HoTen, String _DiaChi, DateTime _NgaySinh, String _Email, String _GioiTinh)
{
DB.usp_InsertHosohocsinh(LayMaHocSinhCuoi() + 1, _HoTen, _DiaChi, _NgaySinh, _Email, _GioiTinh);
DB.SubmitChanges();
}
public void Delete(String MaGiaoVien)
{
DB.usp_DeleteGiaoVien(MaGiaoVien);
DB.SubmitChanges();
}
//Lưu thay đổi
public void SAVE()
{
qlhs.GetChangeSet();
qlhs.SubmitChanges();
}