private void btnSua_Click(object sender, EventArgs e)
{
MonHoc mh = new MonHoc();
mh.MaMonHoc = Convert.ToInt32(txtMaMH.Text);
MonHocDAL mhDAL = new MonHocDAL();
if (txtMaMH.Text != mh.MaMonHoc.ToString())
{
MessageBox.Show("Không sửa được mã môn học", " lỗi ");
}
else
{
if (txtTenMH.TextLength == 0)
{
MessageBox.Show("Chưa nhập tên môn học", " lỗi ");
}
else
{
mh.TenMonHoc = txtTenMH.Text;
mhDAL.SuaMonHoc(mh);
dgvMonHoc.DataSource = mhDAL.LoadDS();
}
}
}
private void HienThiDSMonHoc()
{
dgvMonHoc.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
MonHocDAL hsDAL = new MonHocDAL();
dgvMonHoc.DataSource = hsDAL.LoadDS();
}
private void txtTimKiem_TextChanged(object sender, EventArgs e)
{
string searchtxt = txtTimKiem.Text;
MonHocDAL monhocDAL = new MonHocDAL();
dgvMonHoc.DataSource = monhocDAL.searchMonHoc(searchtxt);
}
private void LoadDanhMucMonHoc()
{
MonHocDAL monHocDAL = new MonHocDAL(dbConnection);
List <MonHoc> monHocs = monHocDAL.ReadAllItems();
DanhMucMonHoc = new ObservableCollection <MonHoc>(monHocs);
OnPropertyChanged("DanhMucMonHoc");
}
private void LoadMon()
{
MonHocDAL mondal = new MonHocDAL();
DataTable data = mondal.LoadDS();
cbMon.DataSource = data;
cbMon.DisplayMember = "TENMONHOC";
cbMon.ValueMember = "MAMONHOC";
}
public BangDiemBUS()
{
_bangDiemDAL = new BangDiemDAL();
_lopDAL = new LopDAL();
_phanLopDAL = new PhanLopDAL();
_quyDinhBUS = new QuyDinhBUS();
_hocSinhDAL = new HocSinhDAL();
_monHocDAL = new MonHocDAL();
}
private void XacNhanLuuDanhMucMonHoc()
{
MonHocDAL monHocDAL = new MonHocDAL(dbConnection);
monHocDAL.DeleteAllItems();
foreach (MonHoc mh in DanhMucMonHoc)
{
monHocDAL.CreateItem(mh);
}
MessageBox.Show("Lưu Danh sách Môn Học thành công");
}
private string CheckThongTinCtChuongTrinhHoc(CT_ChuongTrinhHoc cT_ChuongTrinhHoc)
{
string invalidProperties = "";
MonHocDAL monHocDAL = new MonHocDAL(dbConnection);
if (!monHocDAL.IsMaSoExisted(cT_ChuongTrinhHoc.MonHoc))
{
invalidProperties += "\nMôn Học không hợp lệ";
}
return(invalidProperties);
}
public static List <MonHocDTO> LoadMonHoc()
{
DataTable dt = MonHocDAL.LoadMonHoc();
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
List <MonHocDTO> lstMonHoc = new List <MonHocDTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
MonHocDTO objMonHoc = new MonHocDTO();
objMonHoc.MaMH = dt.Rows[i]["MAMH"].ToString().Trim();
objMonHoc.TenMH = dt.Rows[i]["TENMH"].ToString().Trim();
lstMonHoc.Add(objMonHoc);
}
return(lstMonHoc);
}
private void btnXoa_Click(object sender, EventArgs e)
{
MonHocDAL mhDAL = new MonHocDAL();
if (txtMaMH.TextLength == 0)
{
MessageBox.Show("Chưa có mã môn học", " lỗi ");
}
else
{
try
{
int id = Convert.ToInt16(txtMaMH.Text);
mhDAL.deleteMonHoc(id);
dgvMonHoc.DataSource = mhDAL.LoadDS();
}
catch
{
MessageBox.Show("Mã môn học không thỏa mãn", " lỗi ");
}
}
}
private void btnThem_Click(object sender, EventArgs e)
{
MonHoc mh = new MonHoc();
MonHocDAL mhDAL = new MonHocDAL();
if (txtMaMH.TextLength != 0)
{
MessageBox.Show("Không cần nhập mã môn học", " lỗi ");
}
else
{
if (txtTenMH.TextLength == 0)
{
MessageBox.Show("Chưa nhập tên môn học", " lỗi ");
}
else
{
mh.TenMonHoc = txtTenMH.Text;
mhDAL.insertMonHoc(mh);
dgvMonHoc.DataSource = mhDAL.LoadDS();
}
}
}
private void LoadDanhMucMonHoc()
{
MonHocDAL monhocDAL = new MonHocDAL(dbConnection);
DanhMucMonHoc = monhocDAL.ReadAllItems();
}
public int ThemMonHoc(MonHoc obj)
{
MonHocDAL db = new MonHocDAL();
return(db.ThemMonHoc(obj));
}
public static bool IsExistedAtTableDiem(string x_strMaMonHoc)
{
return(MonHocDAL.IsExistedAtTableDiem(x_strMaMonHoc));
}
public static ObservableCollection <MonHoc> HienThiMonHoc(int MaMonHoc)
{
MonHocDAL db = new MonHocDAL();
return(db.HienThiMonHoc(MaMonHoc));
}
public static ObservableCollection <MonHoc> HienThiTatCa()
{
MonHocDAL db = new MonHocDAL();
return(db.HienThiTatCa());
}
public int XoaMonHoc(int MaMonHoc)
{
MonHocDAL db = new MonHocDAL();
return(db.XoaMonHoc(MaMonHoc));
}
public int SuaMonHoc(MonHoc obj)
{
MonHocDAL db = new MonHocDAL();
return(db.SuaMonHoc(obj));
}
public static bool InsertMonHoc(string x_strMaMonHoc, string x_strTenMonHoc)
{
return(MonHocDAL.InsertMonHoc(x_strMaMonHoc, x_strTenMonHoc));
}
public static bool UpdateMonHoc(string x_strMaMonHoc, string x_strTenMonHoc)
{
return(MonHocDAL.UpdateMonHoc(x_strMaMonHoc, x_strTenMonHoc));
}
public MonHocBUS()
{
_monHocDAL = new MonHocDAL();
}
public static bool DeleteMonHoc(string x_strMaMonHoc)
{
return(MonHocDAL.DeleteMonHoc(x_strMaMonHoc));
}
