public int XoaHocKi(QLHS_DTO ma)
{
int nRow = 0;
DBConnect provider = new DBConnect();
try
{
string strSql = "DELETE FROM HOCKI WHERE MaHocKi = @MaHocKi;";
provider.Connect();
nRow = provider.ExecuteNonQuery(CommandType.Text, strSql,
new SqlParameter {
ParameterName = "@MaHocKi", Value = ma.MaHocKi
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
provider.DisConnect();
}
return(nRow);
}
private void btn_XacNhan_Click(object sender, EventArgs e)
{
try
{
if (txt_mamonhoc.Text != "" && txt_tenmonhoc.Text != "")
{
QLHS_DTO hs = new QLHS_DTO();
hs.MaMonHoc = txt_mamonhoc.Text;
hs.TenMonHoc = txt_tenmonhoc.Text;
QLHS_BUS bus = new QLHS_BUS();
bus.ThemMonHoc(hs);
MessageBox.Show("Thêm thành công môn học " + txt_tenmonhoc.Text + " !", "Thông báo");
LoadData();
btn_themmon.Visible = true;
btn_XacNhan.Visible = false;
txt_mamonhoc.Enabled = false;
txt_tenmonhoc.Enabled = false;
btn_capnhatmon.Enabled = true;
btn_xoa.Enabled = true;
btn_nhapdiemmonhoc.Enabled = true;
}
else
{
MessageBox.Show("Mời nhập đầy đủ thông tin Môn Học!");
}
}
catch
{
MessageBox.Show("Mã môn học này đã tồn tại!");
}
}
private void btn_htthem_Click(object sender, EventArgs e)
{
try
{
QLHS_DTO hs = new QLHS_DTO();
hs.MaKhoiLop = txt_makhoilop.Text;
hs.TenKhoiLop = txt_tenkhoilop.Text;
QLHS_BUS bus = new QLHS_BUS();
bus.ThemKhoiLop(hs);
MessageBox.Show("Thêm thành công khối lớp " + txt_tenkhoilop.Text + " !", "Thông báo");
LoadData();
btn_themkhoilop.Visible = true;
btn_capnhatkhoilop.Enabled = true;
btn_xoakhoilop.Enabled = true;
btn_htthem.Visible = false;
btn_themlop.Enabled = true;
btn_htcapnhat.Visible = false;
btn_htthem.Visible = false;
txt_makhoilop.Enabled = false;
txt_tenkhoilop.Enabled = false;
txt_makhoilop.DataBindings.Clear();
txt_makhoilop.DataBindings.Add("Text", dtgv_khoilop.DataSource, "MaKhoiLop");
txt_tenkhoilop.DataBindings.Clear();
txt_tenkhoilop.DataBindings.Add("Text", dtgv_khoilop.DataSource, "TenKhoiLop");
}
catch
{
MessageBox.Show("Đã tồn tại mã Khối!");
}
}
public void LoadData()
{
try
{
QLHS_BUS bus = new QLHS_BUS();
DataTable dt = bus.DSLop();
DataTable dt_1 = bus.LayKhoiLop();
dtgv_danhsachlop.DataSource = dt;
cb_khoi.DataSource = dt_1;
cb_khoi.DisplayMember = "MaKhoiLop";
cb_khoi.ValueMember = "MaKhoiLop";
if (dt.Rows.Count > 0)
{
dtgv_danhsachlop.Rows[0].Selected = true;
RowSelected = new QLHS_DTO();
RowSelected.MaHocSinh = dtgv_danhsachlop.SelectedRows[0].Cells["MaHocSinh"].Value.ToString();
RowSelected.HoTen = dtgv_danhsachlop.SelectedRows[0].Cells["HoTen"].Value.ToString();
RowSelected.TenKhoiLop = dtgv_danhsachlop.SelectedRows[0].Cells["TenKhoiLop"].Value.ToString();
RowSelected.TenLop = dtgv_danhsachlop.SelectedRows[0].Cells["TenLop"].Value.ToString();
RowSelected.SiSo = dtgv_danhsachlop.SelectedRows[0].Cells["SiSo"].Value.ToString();
}
}
catch (Exception ex)
{
}
}
private void btn_htcapnhat_Click(object sender, EventArgs e)
{
try
{
if ((txt_makhoilop.Text != "") && (txt_tenkhoilop.Text != ""))
{
QLHS_DTO hs = new QLHS_DTO();
hs.MaKhoiLop = txt_makhoilop.Text;
hs.TenKhoiLop = txt_tenkhoilop.Text;
QLHS_BUS bus = new QLHS_BUS();
bus.CapNhatKhoiLop(hs);
MessageBox.Show("Cập nhật thành công khối lớp " + txt_makhoilop.Text + " !", "Thông báo");
LoadData();
btn_themkhoilop.Enabled = true;
btn_xoakhoilop.Enabled = true;
btn_capnhatkhoilop.Visible = true;
btn_themlop.Enabled = true;
btn_htthem.Visible = false;
btn_htcapnhat.Visible = false;
txt_makhoilop.Enabled = false;
txt_tenkhoilop.Enabled = false;
txt_makhoilop.DataBindings.Clear();
txt_makhoilop.DataBindings.Add("Text", dtgv_khoilop.DataSource, "MaKhoiLop");
txt_tenkhoilop.DataBindings.Clear();
txt_tenkhoilop.DataBindings.Add("Text", dtgv_khoilop.DataSource, "TenKhoiLop");
}
else
{
MessageBox.Show("Cập nhật không thành công! Mời bạn xem lại dữ liệu nhập! ", "Thông báo");
}
}
catch (Exception ex)
{
}
}
public int CapNhatLop(QLHS_DTO hs)
{
int nRow = 0;
DBConnect provider = new DBConnect();
try
{
string strSql = "UPDATE DANHSACHLOP SET MaLop = @MaLop, TenLop = @TenLop, SiSo = @SiSo, MaKhoiLop = @MaKhoiLop WHERE MaLop = @MaLop";
provider.Connect();
nRow = provider.ExecuteNonQuery(CommandType.Text, strSql,
new SqlParameter {
ParameterName = "@MaLop", Value = hs.MaLop
},
new SqlParameter {
ParameterName = "@TenLop", Value = hs.TenLop
},
new SqlParameter {
ParameterName = "@SiSo", Value = hs.SiSo
},
new SqlParameter {
ParameterName = "@MaKhoiLop", Value = hs.MaKhoiLop
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
provider.DisConnect();
}
return(nRow);
}
public int CapNhatHocKi(QLHS_DTO hs)
{
int nRow = 0;
DBConnect provider = new DBConnect();
try
{
string strSql = "UPDATE HOCKI SET MaHocKi = @MaHocKi, TenHocKi = @TenHocKi";
provider.Connect();
nRow = provider.ExecuteNonQuery(CommandType.Text, strSql,
new SqlParameter {
ParameterName = "@MaHocKi", Value = hs.MaHocKi
},
new SqlParameter {
ParameterName = "@TenHocKi", Value = hs.TenHocKi
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
provider.DisConnect();
}
return(nRow);
}
private void btn_xoalop_Click(object sender, EventArgs e)
{
try
{
DialogResult DR = MessageBox.Show("Bạn có chắc chắn xoá lớp này!", "Thông báo", MessageBoxButtons.YesNo);
if (DialogResult.Yes == DR)
{
QLHS_DTO hs = new QLHS_DTO();
hs.MaLop = txt_malop.Text;
QLHS_BUS bus = new QLHS_BUS();
bus.XoaLop(hs);
MessageBox.Show("Xoá thành công lớp " + txt_malop.Text + " !", "Thông báo");
LoadData();
txt_tenlop.DataBindings.Clear();
txt_tenlop.DataBindings.Add("Text", dtgv_themlop.DataSource, "TenLop");
txt_siso.DataBindings.Clear();
txt_siso.DataBindings.Add("Text", dtgv_themlop.DataSource, "SiSo");
txt_malop.DataBindings.Clear();
txt_malop.DataBindings.Add("Text", dtgv_themlop.DataSource, "MaLop");
cb_Khoi_LopHoc.DataBindings.Clear();
cb_Khoi_LopHoc.DataBindings.Add("Text", dtgv_themlop.DataSource, "MaKhoiLop");
}
else
{
LoadData();
}
}
catch (Exception ex)
{
}
}
public int ThemHocKi(QLHS_DTO hs)
{
int nRow = 0;
DBConnect provider = new DBConnect();
try
{
string strSql = "INSERT INTO HOCKI(MaHocKi, TenHocKi) VALUES(@MaHocKi, @TenHocKi)";
provider.Connect();
nRow = provider.ExecuteNonQuery(CommandType.Text, strSql,
new SqlParameter {
ParameterName = "@MaHocKi", Value = hs.MaHocKi
},
new SqlParameter {
ParameterName = "@TenHocKi", Value = hs.TenHocKi
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
provider.DisConnect();
}
return(nRow);
}
public int ThemCTDSLOP(QLHS_DTO hs)
{
int nRow = 0;
DBConnect provider = new DBConnect();
try
{
string strSql = "INSERT INTO CHITIETDSLOP(MaChiTietDSLop, MaHocSinh) VALUES(@MaHocSinh, @MaHocSinh)";
provider.Connect();
nRow = provider.ExecuteNonQuery(CommandType.Text, strSql,
new SqlParameter {
ParameterName = "@MaHocSinh", Value = hs.MaHocSinh
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
provider.DisConnect();
}
return(nRow);
}
public int ThemLop(QLHS_DTO hs)
{
int nRow = 0;
DBConnect provider = new DBConnect();
try
{
string strSql = "INSERT INTO DANHSACHLOP(MaLop, TenLop, SiSo, MaKhoiLop) VALUES(@MaLop, @TenLop, @SiSo, @MaKhoiLop)";
provider.Connect();
nRow = provider.ExecuteNonQuery(CommandType.Text, strSql,
new SqlParameter {
ParameterName = "@MaLop", Value = hs.MaLop
},
new SqlParameter {
ParameterName = "@TenLop", Value = hs.TenLop
},
new SqlParameter {
ParameterName = "@SiSo", Value = hs.SiSo
},
new SqlParameter {
ParameterName = "@MaKhoiLop", Value = hs.MaKhoiLop
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
provider.DisConnect();
}
return(nRow);
}
public int ThemKhoiLop(QLHS_DTO hs)
{
int nRow = 0;
DBConnect provider = new DBConnect();
if (Check_MaKL(hs.MaKhoiLop) == true)
{
try
{
string strSql = "INSERT INTO KHOILOP(MaKhoiLop, TenKhoiLop) VALUES(@MaKhoiLop, @TenKhoiLop)";
provider.Connect();
nRow = provider.ExecuteNonQuery(CommandType.Text, strSql,
new SqlParameter {
ParameterName = "@MaKhoiLop", Value = hs.MaKhoiLop
},
new SqlParameter {
ParameterName = "@TenKhoiLop", Value = hs.TenKhoiLop
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
provider.DisConnect();
}
}
return(nRow);
}
private void btn_luu_Click(object sender, EventArgs e)
{
try
{
if ((txt_diem15phut.Text != "") && (txt_diem1tiet.Text != "") && (txt_diemck.Text != "") && (txt_mahocsinh.Text != "") && (txt_tenhs.Text != ""))
{
QLHS_DTO hs = new QLHS_DTO();
hs.MaHocSinh = txt_mahocsinh.Text;
hs.MaMonHoc = lb_mamonhoc.Text;
hs.Diem15phut = txt_diem15phut.Text;
hs.Diem1tiet = txt_diem1tiet.Text;
hs.DiemCuoiKi = txt_diemck.Text;
QLHS_BUS bus = new QLHS_BUS();
bus.ThemBangDiem(hs);
MessageBox.Show("Thêm thành công bảng điểm cho học sinh " + txt_mahocsinh.Text + " !", "Thông báo");
LoadData();
}
else
{
MessageBox.Show("Thêm không thành công! Mời bạn xem lại dữ liệu nhập! ", "Thông báo");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public void LoadData()
{
try
{
QLHS_BUS bus = new QLHS_BUS();
DataTable dt = bus.LayTatCaLop();
DataTable dt_1 = bus.LayKhoiLop();
dtgv_themlop.DataSource = dt;
cb_Khoi_LopHoc.DataSource = dt_1;
cb_Khoi_LopHoc.DisplayMember = "MaKhoiLop";
cb_Khoi_LopHoc.ValueMember = "MaKhoiLop ";
if (dt.Rows.Count > 0)
{
dtgv_themlop.Rows[0].Selected = true;
RowSelected = new QLHS_DTO();
RowSelected.MaLop = dtgv_themlop.SelectedRows[0].Cells["MaLop"].Value.ToString();
RowSelected.TenLop = dtgv_themlop.SelectedRows[0].Cells["TenLop"].Value.ToString();
RowSelected.SiSo = dtgv_themlop.SelectedRows[0].Cells["SiSo"].Value.ToString();
RowSelected.MaKhoiLop = dtgv_themlop.SelectedRows[0].Cells["MaKhoiLop"].Value.ToString();
}
}
catch (Exception ex)
{
}
}
public void LoadData()
{
try
{
QLHS_BUS bus = new QLHS_BUS();
DataTable dt = bus.LayTatCaBangDiem();
DataTable dt_1 = bus.LayDSMonHoc();
cb_tenmh.DataSource = dt_1;
cb_tenmh.DisplayMember = "TenMonHoc";
cb_tenmh.ValueMember = "TenMonHoc";
dtgv_danhsachbangdiem.DataSource = dt;
if (dt.Rows.Count > 0)
{
dtgv_danhsachbangdiem.Rows[0].Selected = true;
RowSelected = new QLHS_DTO();
RowSelected.MaBangDiem = dtgv_danhsachbangdiem.SelectedRows[0].Cells["MaBangDiem"].Value.ToString();
RowSelected.MaHocSinh = dtgv_danhsachbangdiem.SelectedRows[0].Cells["MaHocSinh"].Value.ToString();
RowSelected.MaMonHoc = dtgv_danhsachbangdiem.SelectedRows[0].Cells["MaMonHoc"].Value.ToString();
RowSelected.Diem15phut = dtgv_danhsachbangdiem.SelectedRows[0].Cells["Diem15phut"].Value.ToString();
RowSelected.Diem1tiet = dtgv_danhsachbangdiem.SelectedRows[0].Cells["Diem1tiet"].Value.ToString();
RowSelected.DiemCuoiKi = dtgv_danhsachbangdiem.SelectedRows[0].Cells["DiemCuoiKi"].Value.ToString();
}
}
catch (Exception ex)
{
}
}
public int ThemCTDSLOP(QLHS_DTO hs)
{
try
{
DAL_HOCSINH dal = new DAL_HOCSINH();
return(dal.ThemCTDSLOP(hs));
}
catch (SqlException ex)
{
throw ex;
}
}
public int CapNhatHocKi(QLHS_DTO hs)
{
try
{
DAL_HOCSINH dal = new DAL_HOCSINH();
return(dal.CapNhatHocKi(hs));
}
catch (SqlException ex)
{
throw ex;
}
}
private void btn_themhocki_Click(object sender, EventArgs e)
{
QLHS_DTO hs = new QLHS_DTO();
hs.MaHocKi = txt_mahocki.Text;
hs.TenHocKi = txt_tenhocki.Text;
QLHS_BUS bus = new QLHS_BUS();
bus.ThemHocKi(hs);
MessageBox.Show("Thêm thành công học kì " + txt_tenhocki.Text + " !", "Thông báo");
LoadData();
}
public int XoaHocKi(QLHS_DTO ma)
{
try
{
DAL_HOCSINH dal = new DAL_HOCSINH();
return(dal.XoaHocKi(ma));
}
catch (SqlException ex)
{
throw ex;
}
}
public int ThemKhoiLop(QLHS_DTO hs)
{
try
{
DAL_HOCSINH dal = new DAL_HOCSINH();
return(dal.ThemKhoiLop(hs));
}
catch (SqlException ex)
{
return(0);
}
}
private void btn_Luu_HS_Click(object sender, EventArgs e)
{
try
{
if ((txt_hovaten.Text != "") && (dt_ngaysinh.Value.ToString() != "") && (cb_gioitinh.Text != "") && (txt_diachi.Text != "") && (txt_email.Text != ""))
{
QLHS_DTO hs = new QLHS_DTO();
hs.MaHocSinh = txt_mahocsinh.Text;
hs.HoTen = txt_hovaten.Text;
hs.NgaySinh = dt_ngaysinh.Value.ToString();
hs.GioiTinh = cb_gioitinh.Text;
hs.DiaChi = txt_diachi.Text;
hs.Email = txt_email.Text;
QLHS_BUS bus = new QLHS_BUS();
bus.CapNhatHocSinh(hs);
MessageBox.Show("Cập nhật thành công học sinh " + txt_mahocsinh.Text + " !", "Thông báo");
btn_capnhathocsinh.Visible = true;
btn_ThemHS.Visible = true;
btn_Luu_HS.Visible = false;
txt_mahocsinh.Enabled = true;
txt_mahocsinh.Enabled = false;
txt_hovaten.Enabled = false;
txt_email.Enabled = false;
txt_diachi.Enabled = false;
cb_gioitinh.Enabled = false;
dt_ngaysinh.Enabled = false;
LoadData();
txt_hovaten.DataBindings.Clear();
txt_hovaten.DataBindings.Add("Text", dtgv_danhsachhocsinh.DataSource, "HoTen");
txt_mahocsinh.DataBindings.Clear();
txt_mahocsinh.DataBindings.Add("Text", dtgv_danhsachhocsinh.DataSource, "MaHocSinh");
txt_email.DataBindings.Clear();
txt_email.DataBindings.Add("Text", dtgv_danhsachhocsinh.DataSource, "Email");
txt_diachi.DataBindings.Clear();
txt_diachi.DataBindings.Add("Text", dtgv_danhsachhocsinh.DataSource, "DiaChi");
cb_gioitinh.DataBindings.Clear();
cb_gioitinh.DataBindings.Add("Text", dtgv_danhsachhocsinh.DataSource, "GioiTinh");
dt_ngaysinh.DataBindings.Clear();
dt_ngaysinh.DataBindings.Add("Text", dtgv_danhsachhocsinh.DataSource, "NgaySinh");
}
else
{
MessageBox.Show("Cập nhật không thành công! Mời bạn xem lại dữ liệu nhập! ", "Thông báo");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void txt_mahocsinh_TextChanged(object sender, EventArgs e)
{
try
{
QLHS_BUS bus = new QLHS_BUS();
QLHS_DTO hs = new QLHS_DTO();
hs.MaHocSinh = txt_mahocsinh.Text;
DataTable dt = bus.TIMHSBANGMA(hs.MaHocSinh);
txt_tenhs.Text = dt.Rows[0]["HoTen"].ToString();
}
catch (Exception ex)
{
txt_tenhs.Text = "";
}
}
private void txt_mahocsinh_TextChanged(object sender, EventArgs e)
{
try
{
QLHS_BUS bus = new QLHS_BUS();
QLHS_DTO hs = new QLHS_DTO();
hs.MaHocSinh = txt_mahocsinh.Text;
DataTable dt = bus.TIMHSBANGMA(hs.MaHocSinh);
txt_tenhocsinh.Text = dt.Rows[0]["HoTen"].ToString();
dt_ngaysinh.Format = DateTimePickerFormat.Custom;
dt_ngaysinh.CustomFormat = "dd/MM/yyyy";
dt_ngaysinh.Text = dt.Rows[0]["NgaySinh"].ToString();
}
catch (Exception ex)
{
}
}
private void btn_XacNhan_Click(object sender, EventArgs e)
{
btn_XacNhan.Visible = false;
btn_them.Visible = true;
try
{
QLHS_BUS bus = new QLHS_BUS();
DataTable dt = bus.ThamSo();
string t = txt_siso.Text.ToString();
if ((0 < Int32.Parse(t) && Int32.Parse(t) < Int32.Parse(dt.Rows[0]["SiSo"].ToString())))
{
QLHS_DTO hs = new QLHS_DTO();
hs.MaLop = txt_malop.Text;
hs.TenLop = txt_tenlop.Text;
hs.SiSo = txt_siso.Text;
hs.MaKhoiLop = cb_Khoi_LopHoc.Text;
bus.ThemLop(hs);
MessageBox.Show("Thêm thành công lớp " + txt_malop.Text + " !", "Thông báo");
LoadData();
btn_capnhatlop.Enabled = true;
btn_xoalop.Enabled = true;
btn_xeplop.Enabled = true;
txt_malop.Enabled = false;
txt_siso.Enabled = false;
txt_tenlop.Enabled = false;
cb_Khoi_LopHoc.Enabled = false;
txt_tenlop.DataBindings.Clear();
txt_tenlop.DataBindings.Add("Text", dtgv_themlop.DataSource, "TenLop");
txt_siso.DataBindings.Clear();
txt_siso.DataBindings.Add("Text", dtgv_themlop.DataSource, "SiSo");
txt_malop.DataBindings.Clear();
txt_malop.DataBindings.Add("Text", dtgv_themlop.DataSource, "MaLop");
cb_Khoi_LopHoc.DataBindings.Clear();
cb_Khoi_LopHoc.DataBindings.Add("Text", dtgv_themlop.DataSource, "MaKhoiLop");
}
else
{
MessageBox.Show("Sỉ số lớp sai quy định");
}
}
catch
{
MessageBox.Show("Mời nhập lại đúng quy định!");
}
}
public void LoadData()
{
try
{
QLHS_BUS bus = new QLHS_BUS();
DataTable dt = bus.LayTatCaKhoiLop();
dtgv_khoilop.DataSource = dt;
if (dt.Rows.Count > 0)
{
dtgv_khoilop.Rows[0].Selected = true;
RowSelected = new QLHS_DTO();
RowSelected.MaKhoiLop = dtgv_khoilop.SelectedRows[0].Cells["MaKhoiLop"].Value.ToString();
RowSelected.TenKhoiLop = dtgv_khoilop.SelectedRows[0].Cells["TenKhoiLop"].Value.ToString();
}
}
catch (Exception ex)
{
}
}
public void LoadData()
{
try
{
QLHS_BUS bus = new QLHS_BUS();
DataTable dt = bus.LayTatCaHocKi();
dtgv_danhsachhocki.DataSource = dt;
if (dt.Rows.Count > 0)
{
dtgv_danhsachhocki.Rows[0].Selected = true;
RowSelected = new QLHS_DTO();
RowSelected.MaHocKi = dtgv_danhsachhocki.SelectedRows[0].Cells["MaHocKi"].Value.ToString();
RowSelected.TenHocKi = dtgv_danhsachhocki.SelectedRows[0].Cells["TenHocKi"].Value.ToString();
}
}
catch (Exception ex)
{
}
}
public void LoadData()
{
try
{
QLHS_BUS bus = new QLHS_BUS();
DataTable dt = bus.LayTatCaMonHoc();
dtgv_danhsachmonhoc.DataSource = dt;
if (dt.Rows.Count > 0)
{
dtgv_danhsachmonhoc.Rows[0].Selected = true;
RowSelected = new QLHS_DTO();
RowSelected.MaHocSinh = dtgv_danhsachmonhoc.SelectedRows[0].Cells["MaMonHoc"].Value.ToString();
RowSelected.HoTen = dtgv_danhsachmonhoc.SelectedRows[0].Cells["TenMonHoc"].Value.ToString();
}
}
catch (Exception ex)
{
}
}
private void btn_Luu_Lai_Click(object sender, EventArgs e)
{
try
{
if ((txt_malop.Text != "") && (txt_tenlop.Text != "") && (txt_siso.Text != "") && (cb_Khoi_LopHoc.Text != ""))
{
QLHS_DTO hs = new QLHS_DTO();
hs.MaLop = txt_malop.Text;
hs.TenLop = txt_tenlop.Text;
hs.SiSo = txt_siso.Text;
hs.MaKhoiLop = cb_Khoi_LopHoc.Text;
QLHS_BUS bus = new QLHS_BUS();
bus.CapNhatLop(hs);
MessageBox.Show("Cập nhật thành công lớp " + txt_malop.Text + " !", "Thông báo");
LoadData();
btn_capnhatlop.Visible = true;
btn_Luu_Lai.Visible = false;
btn_them.Enabled = true;
btn_xoalop.Enabled = true;
btn_xeplop.Enabled = true;
txt_malop.Enabled = false;
txt_siso.Enabled = false;
txt_tenlop.Enabled = false;
cb_Khoi_LopHoc.Enabled = false;
txt_tenlop.DataBindings.Clear();
txt_tenlop.DataBindings.Add("Text", dtgv_themlop.DataSource, "TenLop");
txt_siso.DataBindings.Clear();
txt_siso.DataBindings.Add("Text", dtgv_themlop.DataSource, "SiSo");
txt_malop.DataBindings.Clear();
txt_malop.DataBindings.Add("Text", dtgv_themlop.DataSource, "MaLop");
cb_Khoi_LopHoc.DataBindings.Clear();
cb_Khoi_LopHoc.DataBindings.Add("Text", dtgv_themlop.DataSource, "MaKhoiLop");
}
else
{
MessageBox.Show("Cập nhật không thành công! Mời bạn xem lại dữ liệu nhập! ", "Thông báo");
}
}
catch (Exception ex)
{
}
}
public int ThemHocSinh(QLHS_DTO hs)
{
int nRow = 0;
DBConnect provider = new DBConnect();
try
{
string strSql = "INSERT INTO HOCSINH(MaHocSinh, HoTen, NgaySinh, GioiTinh, DiaChi, Email) VALUES(@MaHocSinh, @HoTen, @NgaySinh, @GioiTinh, @DiaChi, @Email)";
provider.Connect();
nRow = provider.ExecuteNonQuery(CommandType.Text, strSql,
new SqlParameter {
ParameterName = "@MaHocSinh", Value = hs.MaHocSinh
},
new SqlParameter {
ParameterName = "@HoTen", Value = hs.HoTen
},
new SqlParameter {
ParameterName = "@NgaySinh", Value = hs.NgaySinh
},
new SqlParameter {
ParameterName = "@GioiTinh", Value = hs.GioiTinh
},
new SqlParameter {
ParameterName = "@DiaChi", Value = hs.DiaChi
},
new SqlParameter {
ParameterName = "@Email", Value = hs.Email
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
provider.DisConnect();
}
return(nRow);
}
public int CapNhatHocSinh(QLHS_DTO hs)
{
int nRow = 0;
DBConnect provider = new DBConnect();
try
{
string strSql = "UPDATE HOCSINH SET HoTen = @HoTen, NgaySinh = @NgaySinh, GioiTinh = @GioiTinh, DiaChi = @DiaChi, Email = @Email WHERE MaHocSinh = @MaHocSinh";
provider.Connect();
nRow = provider.ExecuteNonQuery(CommandType.Text, strSql,
new SqlParameter {
ParameterName = "@MaHocSinh", Value = hs.MaHocSinh
},
new SqlParameter {
ParameterName = "@HoTen", Value = hs.HoTen
},
new SqlParameter {
ParameterName = "@NgaySinh", Value = hs.NgaySinh
},
new SqlParameter {
ParameterName = "@GioiTinh", Value = hs.GioiTinh
},
new SqlParameter {
ParameterName = "@DiaChi", Value = hs.DiaChi
},
new SqlParameter {
ParameterName = "@Email", Value = hs.Email
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
provider.DisConnect();
}
return(nRow);
}
