private void txttimkiem_TextChanged_1(object sender, EventArgs e)
{
string searchtxt = txttimkiem.Text;
LopDAL lDAL = new LopDAL();
dgvLop.DataSource = lDAL.searchLop(searchtxt);
}
private void HienThiDSLop()
{
dgvLop.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
LopDAL hsDAL = new LopDAL();
dgvLop.DataSource = hsDAL.LoadDS();
}
public void itemcomboBox()
{
LopDAL lop = new LopDAL();
comboBox1.DataSource = lop.LoadDS();
comboBox1.DisplayMember = "TenLop";
comboBox1.ValueMember = "MALOP";
}
public BangDiemBUS()
{
_bangDiemDAL = new BangDiemDAL();
_lopDAL = new LopDAL();
_phanLopDAL = new PhanLopDAL();
_quyDinhBUS = new QuyDinhBUS();
_hocSinhDAL = new HocSinhDAL();
_monHocDAL = new MonHocDAL();
}
private void LoadLop()
{
LopDAL LOPdal = new LopDAL();
DataTable dataLop = LOPdal.LoadDS();
cbLop.DataSource = dataLop;
cbLop.DisplayMember = "TENLOP";
cbLop.ValueMember = "MALOP";
}
private void LoadLop()
{
LopDAL lDAL = new LopDAL();
DataTable dataLOP = lDAL.LoadDS();
cblop.DataSource = dataLOP;
cblop.DisplayMember = "TENLOP";
cblop.ValueMember = "MALOP";
}
public static NamHoc GetInfoNamHoc(string maNamHoc)
{
DataTable dt = LopDAL.GetInfoNamHoc(maNamHoc);
foreach (DataRow row in dt.Rows)
{
return(new NamHoc(row));
}
return(new NamHoc());
}
public static Lop GetInfoLop(string maLop)
{
DataTable dt = LopDAL.GetInfoLop(maLop);
foreach (DataRow row in dt.Rows)
{
return(new Lop(row));
}
return(new Lop());
}
private void dgvdslop_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int numrow = e.RowIndex;
if (dgvdslop.Rows[numrow].Cells[4].Value.ToString() != "")
{
int malop = Convert.ToInt32(dgvdslop.Rows[numrow].Cells[4].Value.ToString());
cblop.SelectedValue = malop;
LopDAL lDAL = new LopDAL();
Lop l = lDAL.getLop(malop);
}
}
public static bool ThemNienKhoa(string maNienKhoa, string tenNienKhoa, DateTime tgBatDau, DateTime tgKetThuc)
{
try
{
LopDAL.ThemNienKhoa(maNienKhoa, tenNienKhoa, tgBatDau, tgKetThuc);
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public static bool CapNhatNienKhoa(string maNienKhoa, string tenNienKhoa)
{
try
{
LopDAL.CapNhatNienKhoa(maNienKhoa, tenNienKhoa);
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public static bool ThemLoaiLop(string maLoaiLop, string tenLoaiLop)
{
try
{
LopDAL.ThemLoaiLop(maLoaiLop, tenLoaiLop);
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public static bool CapNhatLop(string maLop, string tenLop, string maGV)
{
try
{
LopDAL.CapNhatLop(maLop, tenLop, maGV);
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public static bool CapNhatSiSoToiDa(int siSoCu, int siSoMoi)
{
try
{
LopDAL.CapNhatSiSoToiDa(siSoCu, siSoMoi);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
return(true);
}
public static bool CapNhatLoaiLop(string maLoaiLop, string tenLoaiLop)
{
try
{
LopDAL.CapNhatLoaiLop(maLoaiLop, tenLoaiLop);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
return(true);
}
private void btMon_Click(object sender, EventArgs e)
{
try
{
int malop = Convert.ToInt32(txtmalop.Text);
LopDAL lDAL = new LopDAL();
lDAL.XoaMonLop(malop, idMon);
HienThiDSMonLop();
}
catch
{
}
}
public static string GenMaNienKhoa()
{
string id = LopDAL.GetLastIDNienKhoa().Trim();
if (id == "")
{
return("MANH000001");
}
int nextID = int.Parse(id.Remove(0, "MANH".Length)) + 1;
id = "00000" + nextID.ToString();
id = id.Substring(id.Length - 6, 6);
return("MANH" + id);
}
public static bool ThemLop(Entities.Lop lop)
{
DataTable dt = LopDAL.ThemLop(lop);
foreach (DataRow row in dt.Rows)
{
if (row.ItemArray[0].ToString().Trim() == "0")
{
return(true);
}
}
return(false);
}
public static string GenMaLoaiLop()
{
string id = LopDAL.GetLastLoaiLopID().Trim();
if (id == "")
{
return("MLLOP00001");
}
int nextID = int.Parse(id.Remove(0, "MLLOP".Length)) + 1;
id = "0000" + nextID.ToString();
id = id.Substring(id.Length - 5, 5);
return("MLLOP" + id);
}
private void HienThiDSMonLop()
{
LopDAL lopdal = new LopDAL();
try
{
int ma = Convert.ToInt32(txtmalop.Text);
DataTable data = lopdal.getMonLop(ma);
dgvMonLop.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvMonLop.DataSource = data;
}
catch
{
}
}
private void btThemMon_Click(object sender, EventArgs e)
{
try
{
int malop = Convert.ToInt32(txtmalop.Text);
int maMon = Convert.ToInt16(cbMon.SelectedValue.ToString());;
int maGV = Convert.ToInt16(cbGVBM.SelectedValue.ToString());;
LopDAL lDAL = new LopDAL();
lDAL.insertMonLop(malop, maMon, maGV);
HienThiDSMonLop();
}
catch
{
}
}
private void btnsua_Click(object sender, EventArgs e)
{
Lop l = new Lop();
l.MaLop = Convert.ToInt32(txtmalop.Text);
LopDAL lDAL = new LopDAL();
if (txtmalop.Text != l.MaLop.ToString())
{
MessageBox.Show("Không được sửa mã lớp", " lỗi ");
}
else
{
if (txttenlop.TextLength == 0)
{
MessageBox.Show("Chưa nhập tên lớp", " lỗi ");
}
else
{
l.TenLop = txttenlop.Text;
if (txtsiso.TextLength == 0)
{
MessageBox.Show(" Chưa nhập sĩ số", "lỗi");
}
else
{
l.SiSo = Convert.ToInt16(txtsiso.Text);
try
{
int maGV = Convert.ToInt16(cbGiaoVien.SelectedValue.ToString());
l.MaGVCN = maGV;
lDAL.SuaLop(l);
dgvLop.DataSource = lDAL.LoadDS();
}
catch
{
}
}
}
}
}
public LopBUS()
{
_lopDAL = new LopDAL();
}
public int SuaLop(Lop obj)
{
LopDAL db = new LopDAL();
return(db.SuaLop(obj));
}
public int XoaLop(int MaLop)
{
LopDAL db = new LopDAL();
return(db.XoaLop(MaLop));
}
public static ObservableCollection <Lop> HienThiTatCa()
{
LopDAL db = new LopDAL();
return(db.HienThiTatCa());
}
public static ObservableCollection <Lop> HienThiLop(int MaLop)
{
LopDAL db = new LopDAL();
return(db.HienThiLop(MaLop));
}
public static ObservableCollection <Lop> HienThiLopTheoGiaiDoan(int MaGiaiDoan)
{
LopDAL db = new LopDAL();
return(db.HienThiLopTheoGiaiDoan(MaGiaiDoan));
}
public static int GetNamHoc(string maLop)
{
return(LopDAL.GetNamHoc(maLop));
}
public static DataTable GetListLoaiLop()
{
return(LopDAL.GetListLoaiLop());
}
