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()); }