private void btnTimKiem_Click(object sender, EventArgs e)
{
gridKetQuaTimKiem.DataSource = GiangDay.SelectAll(GlobalSettings.UserID, rdKhoangThoiGian.Checked ? (DateTime?)dateTuNgay.Value : null,
rdKhoangThoiGian.Checked ? (DateTime?)dateDenNgay.Value : null, rdKhoaHoc.Checked ? cboKhoaHoc.SelectedValue.ToString() : null);
gridKetQuaTimKiem_Click(sender, e);
}
public void insertGiangDay(GiangDay d)
{
openConn();
string query = "insert into GiangDay(magiaovien, malop, mamonhoc, thu, tiet, sotiet) values (@magiaovien, @malop, @mamonhoc, @thu, @tiet, @sotiet)";
SqlCommand cmd = new SqlCommand(query, Conn);
cmd.Parameters.AddWithValue("@magiaovien", d.MaGiaoVien);
cmd.Parameters.AddWithValue("@malop", d.MaLopHoc);
cmd.Parameters.AddWithValue("@mamonhoc", d.MaMonHoc);
cmd.Parameters.AddWithValue("@thu", d.Thu);
cmd.Parameters.AddWithValue("@tiet", d.Tiet);
cmd.Parameters.AddWithValue("@sotiet", d.SoTiet);
cmd.ExecuteNonQuery();
}
public void deleteGiangDay(GiangDay gd)
{
try
{
openConn();
String query = "delete from GiangDay where malop= @malop and magiaovien = @magiaovien and mamonhoc=@mamonhoc and thu=@thu and tiet=@tiet ";
SqlCommand cmd = new SqlCommand(query, Conn);
cmd.Parameters.AddWithValue("@malop", gd.MaLopHoc);
cmd.Parameters.AddWithValue("@magiaovien", gd.MaGiaoVien);
cmd.Parameters.AddWithValue("@mamonhoc", gd.MaMonHoc);
cmd.Parameters.AddWithValue("@thu", gd.Thu);
cmd.Parameters.AddWithValue("@tiet", gd.Tiet);
cmd.ExecuteNonQuery();
}
catch (Exception msg)
{
}
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
qLHS = new QLHS();
lg = new frmLogin();
quanLyChung = new QuanLyChung();
hocSinhSql = new HocSinhSql();
hs = new HocSinh();
giaoVienSql = new GiaoVienSql();
gv = new GiaoVien();
qLGV = new QLGV();
giangDay = new GiangDay();
giangDaySql = new GiangDaySql();
lop = new Lop();
lopSql = new LopSql();
diem = new Diem();
diemSql = new DiemSql();
userSql = new UserSql();
Application.Run(lg);
}
private void btnXemTatCa_Click(object sender, EventArgs e)
{
gridKetQuaTimKiem.DataSource = GiangDay.SelectAll(GlobalSettings.UserID, null, null, null);
gridKetQuaTimKiem_Click(sender, e);
}
public bool KiemTraQuyenTaoCauHoi()
{
string maMH = ((DataRowView)mONHOCBindingSource.Current)[0].ToString();
return(GiangDay.KiemTraQuyenTaoCauHoi(Program.username, maMH));
}
private void gridGV_Click(object sender, EventArgs e)
{
gridLop.AutoGenerateColumns = false;
gridLop.DataSource = GiangDay.Select(gridGV.SelectedRows[0].Cells["clmMaGV"].Value.ToString());
}
