// từ một danh sách học sinh chuyển qua table để đưa lên giao diện
public DataTable chuyenQuaBang_HocSinh_DaCoLop(HocSinh[] dsHocSinh)
{
DataTable table = new DataTable();
table.Columns.Add("stt");
table.Columns.Add("hoTen");
table.Columns.Add("maHocSinh");
table.Columns.Add("lop");
table.Columns.Add("gioiTinh");
table.Columns.Add("ngaySinh");
table.Columns.Add("diaChi");
table.Columns.Add("email");
for (int i = 0; i < dsHocSinh.Length; i++)
{
DataRow row = table.NewRow();
row["stt"] = i + 1;
row["hoTen"] = dsHocSinh[i].HoTen;
row["maHocSinh"] = dsHocSinh[i].MaHocSinh;
row["lop"] = hocsinhBUS.layTenLop_TuHocSinh_BUS(dsHocSinh[i]);
if (dsHocSinh[i].GioiTinh == true)
{
row["gioiTinh"] = "Nam";
}
else
{
row["gioiTinh"] = "Nữ";
}
row["ngaySinh"] = dsHocSinh[i].NgaySinh;
row["diaChi"] = dsHocSinh[i].Diachi;
row["email"] = dsHocSinh[i].Email;
table.Rows.Add(row);
}
return table;
}
public HocSinh[] getAllStudent()
{
string strSql = "SELECT * FROM HocSinh";
DataTable dt = DataProvider.executeQuery(strSql);
int n = dt.Rows.Count;
HocSinh[] allStudent = new HocSinh[n];
for (int i = 0; i < n; i++)
{
HocSinh TK = GetDataFromDataRow(dt, i);
allStudent[i] = TK;
}
return allStudent;
}
public HocSinh getStudentIf(int maTaiKhoan)
{
string nameProc = "sp_LayThongTinHocSinhTuTaiKhoan";
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@maTK", maTaiKhoan);
DataTable dt = DataProvider.executeStoreProcedureQuery(nameProc, para);
int n = dt.Rows.Count;
HocSinh HS = new HocSinh();
if (n == 1)
{
HS = GetDataFromDataRow(dt, 0);
return HS;
}
else
{
return null;
}
}
public HocSinh[] getStudentIf(int maLop, int maMonHoc, int maHocKi)
{
string nameProc = "sp_LayDanhSachHocSinhCua1LopTheoMonHoc";
SqlParameter[] para = new SqlParameter[3];
para[0] = new SqlParameter("@maLop", maLop);
para[1] = new SqlParameter("@maMonHoc", maMonHoc);
para[2] = new SqlParameter("@maHocKi", maHocKi);
DataTable dt = DataProvider.executeStoreProcedureQuery(nameProc, para);
int n = dt.Rows.Count;
HocSinh[] allStudent = new HocSinh[n];
for (int i = 0; i < n; i++)
{
HocSinh TK = GetDataFromDataRow(dt, i);
allStudent[i] = TK;
}
return allStudent;
}
private void frmXemThongTinCaNhan_Load(object sender, EventArgs e)
{
HocSinhBUS adater = new HocSinhBUS();
HocSinh HS = new HocSinh();
HS = adater.getStudentIf_BUS2(BienToanCuc.CurrentUser.MaTaiKhoan);
lbDiaChi.Text = HS.Diachi;
lbEmail.Text = HS.Email;
if (HS.GioiTinh == true)
{
lbGioiTinh.Text = "Nam";
}
else
{
lbGioiTinh.Text = "Nữ";
}
lbHoTen.Text = HS.HoTen;
lbMaHS.Text = HS.MaHocSinh.ToString();
lbNgaySinh.Text = HS.NgaySinh.Day.ToString() + "/" + HS.NgaySinh.Month.ToString() + "/" + HS.NgaySinh.Year.ToString();
}
void XL_Chon()
{
if (flag == true)
{
DiemBUS adapterDiem = new DiemBUS();
MonHocBUS adapterMH = new MonHocBUS();
if (combHocKi.Text != "" && combHocKi.SelectedIndex >= 0)
{
int chi_soHK = combHocKi.SelectedIndex;
HocKi KQHK;
if (chi_soHK >= 0 )
{
HocKi[] HK = (HocKi[])combHocKi.Tag;
KQHK = HK[chi_soHK];
MonHoc []Danh_sach_MH = adapterMH.getAllMH_BUS();
HocSinhBUS adater = new HocSinhBUS();
HocSinh HS = new HocSinh();
HS = adater.getStudentIf_BUS2(BienToanCuc.CurrentUser.MaTaiKhoan);
diem = adapterDiem.getMarkIf_BUS(HS.MaHocSinh,KQHK.MaHocKi);
DataTable dt = new DataTable();
dt.Columns.Add("tenMonHoc");
dt.Columns.Add("diem15Phut");
dt.Columns.Add("diem1Tiet");
dt.Columns.Add("diemHocKi");
for (int i = 0; i < Danh_sach_MH.Length; i++)
{
DataRow Dong = dt.NewRow();
dt.Rows.Add(Dong);
Dong["tenMonHoc"] = Danh_sach_MH[i].TenMonHoc;
Dong["diem15Phut"] = diem[i].Diem15Phut;
Dong["diem1Tiet"] = diem[i].Diem1Tiet;
Dong["diemHocKi"] = diem[i].DiemHocKi;
}
dgvBangDiem.DataSource = dt;
}
}
}
}
public HocSinh layHocSinh_Tu_GUI()
{
HocSinh hocsinh = new HocSinh(); ;
if (tbxDiaChi.Text.CompareTo("")!= 0 || tbxHoTen.Text.CompareTo("")!= 0 || tbxEmail.Text.CompareTo("")!=0)
{
hocsinh.HoTen = tbxHoTen.Text;
hocsinh.Email = tbxEmail.Text;
hocsinh.Diachi = tbxDiaChi.Text;
if (rdioNam.Checked == true)
{
hocsinh.GioiTinh = true;
}
else
{
hocsinh.GioiTinh = false;
}
hocsinh.NgaySinh = dtimeNgaySinh.Value;
}
return hocsinh;
}
public HocSinh[] layDanhSachHocSinh_Tu_Bang(DataTable bangDSHocSinh)
{
HocSinh[] dsHocSinh = new HocSinh[bangDSHocSinh.Rows.Count];
for (int i = 0; i < bangDSHocSinh.Rows.Count; i++)
{
HocSinh hs = new HocSinh();
hs.HoTen = bangDSHocSinh.Rows[i]["hoTen"].ToString();
hs.NgaySinh = Convert.ToDateTime(bangDSHocSinh.Rows[i]["ngaySinh"]);
hs.Diachi = bangDSHocSinh.Rows[i]["diaChi"].ToString();
hs.Email = bangDSHocSinh.Rows[i]["email"].ToString();
hs.MaTaiKhoan = Convert.ToInt32(bangDSHocSinh.Rows[i]["maTaiKhoan"]);
if (bangDSHocSinh.Rows[i]["maLop"].ToString().CompareTo("") != 0)
{
hs.MaLop = Convert.ToInt32(bangDSHocSinh.Rows[i]["maLop"]);
}
hs.GioiTinh = Convert.ToBoolean(bangDSHocSinh.Rows[i]["gioiTinh"]);
hs.MaHocSinh = Convert.ToInt32(bangDSHocSinh.Rows[i]["maHocSinh"]);
dsHocSinh[i] = hs;
}
return dsHocSinh;
}
public string layTenLop_TuHocSinh_BUS(HocSinh hocsinh)
{
return hocsinhDAO.layTenLop_TuHocSinh_DAO(hocsinh);
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (dtgvHocSinh.CurrentRow.Index < dtgvHocSinh.Rows.Count - 1)
{
DialogResult dr = MessageBox.Show("Bạn có muốn xóa hay không", "Thoát", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
HocSinh hocsinh = new HocSinh();
hocsinh.MaHocSinh = Convert.ToInt32(dtgvHocSinh.CurrentRow.Cells["maHocSinh"].Value);
bool check = hocsinhBUS.xoaHocSinh_BUS(hocsinh);
if (check == true)
{
MessageBox.Show("Xóa thành công.");
capNhat_GUI();
}
else
{
MessageBox.Show("Xóa thất bại.");
}
}
}
}
public int layMaLop_TuHocSinh_BUS(HocSinh hocsinh)
{
return hocsinhDAO.layMaLop_TuHocSinh_DAO(hocsinh);
}
// lấy danh sách học sinh từ màn hình giao dien textbox, combobox
public HocSinh layHocSinh_Tu_GUI()
{
HocSinh hocsinh = new HocSinh(); ;
int indexHocSinh = combomaHocSinh.SelectedIndex;
int index = comboLop.SelectedIndex;
Lop[] dsLop = (Lop[])comboLop.Tag;
//HocSinh[] dsHocSinh = hocsinhBUS.layDanhSachHocSinh_ChuaCoLop_BUS();
HocSinh[] dsHocSinh;
if (edit == true)
{
dsHocSinh = new HocSinh[1];
dsHocSinh[0] = hocsinh_hientai;
}
else
{
dsHocSinh = hocsinhBUS.layDanhSachHocSinh_ChuaCoLop_BUS();
}
hocsinh.MaHocSinh = dsHocSinh[indexHocSinh].MaHocSinh;
int indexLop = comboLop.SelectedIndex;
hocsinh.MaLop = dsLop[indexLop].MaLop;
if (tbxDiaChi.Text.CompareTo("") != 0 || tbxHoTen.Text.CompareTo("") != 0 || tbxEmail.Text.CompareTo("") != 0)
{
hocsinh.HoTen = tbxHoTen.Text;
hocsinh.Email = tbxEmail.Text;
hocsinh.Diachi = tbxDiaChi.Text;
if (lbGT.Text.CompareTo("Nam") == 0)
{
hocsinh.GioiTinh = true;
}
else
{
hocsinh.GioiTinh = false;
}
hocsinh.NgaySinh = DateTime.Parse(lbNS.Text);
}
return hocsinh;
}
private HocSinh GetDataFromDataRow(DataTable dt, int i)
{
HocSinh HS = new HocSinh();
HS.MaHocSinh = Convert.ToInt32(dt.Rows[i]["maHocSinh"].ToString());
HS.MaLop = Convert.ToInt32(dt.Rows[i]["maLop"].ToString());
HS.MaTaiKhoan = Convert.ToInt32(dt.Rows[i]["maTaiKhoan"].ToString());
HS.HoTen = dt.Rows[i]["hoTen"].ToString();
HS.GioiTinh = Convert.ToBoolean(dt.Rows[i]["gioiTinh"].ToString());
HS.NgaySinh = Convert.ToDateTime(dt.Rows[i]["ngaySinh"].ToString());
return HS;
}
public bool themHocSinh_VaoLop_BUS(HocSinh hocsinh, Lop lop)
{
return hocsinhDAO.themHocSinh_VaoLop_DAO(hocsinh, lop);
}
public bool xoaHocSinh_RaKhoiLop_BUS(HocSinh hocsinh)
{
return hocsinhDAO.xoaHocSinh_RaKhoiLop_DAO(hocsinh);
}
// lấy học sinh từ một dòng của datagridview
public HocSinh layHocSinh_Tu_DataRowGridView(DataGridViewRow row)
{
HocSinh hocsinh = new HocSinh();
hocsinh.MaHocSinh = Convert.ToInt32(row.Cells["maHocSinh"].Value);
hocsinh.HoTen = row.Cells["hoTen"].Value.ToString();
hocsinh.Email = row.Cells["email"].Value.ToString();
hocsinh.Diachi = row.Cells["diaChi"].Value.ToString();
hocsinh.NgaySinh = DateTime.Parse(row.Cells["ngaySinh"].Value.ToString());
if (row.Cells["gioiTinh"].Value.ToString().CompareTo("Nam") == 0)
{
hocsinh.GioiTinh = true;
}
else
{
hocsinh.GioiTinh = false;
}
hocsinh.MaLop = hocsinhBUS.layMaLop_TuHocSinh_BUS(hocsinh);
return hocsinh;
}
//đưa các thông tin vào giao diện textbox, datetime
public void duaThongTinHocSinh_GUI(HocSinh hocsinh)
{
tbxDiaChi.Text = hocsinh.Diachi;
tbxEmail.Text = hocsinh.Email;
tbxHoTen.Text = hocsinh.HoTen;
lbNS.Text = hocsinh.NgaySinh.ToShortDateString();
if (hocsinh.GioiTinh == true)
{
lbGT.Text = "Nam";
}
else
{
lbGT.Text = "Nữ";
}
}
public bool suaHocSinh_DAO(HocSinh hocsinh)
{
string nameProc_TNHocSinh = "sp_suaHocSinh";
SqlParameter para = new SqlParameter("@maHocSinh", hocsinh.MaHocSinh);
SqlParameter para1 = new SqlParameter("@hoTen", hocsinh.HoTen);
SqlParameter para2 = new SqlParameter("@ngaySinh", hocsinh.NgaySinh);
SqlParameter para3 = new SqlParameter("@gioiTinh", hocsinh.GioiTinh);
SqlParameter para4 = new SqlParameter("@email", hocsinh.Email);
SqlParameter para5 = new SqlParameter("@diaChi", hocsinh.Diachi);
int ketqua = DataProvider.executeStoreProcedureNonQuery(nameProc_TNHocSinh, para, para1, para2, para3, para4, para5);
if (ketqua != 0)
{
return true;
}
return false;
}
public bool suaHocSinh_SuaLop_DAO(HocSinh hocsinh, Lop lop)
{
string nameProc_SuaHocSinh_SuaLop = "sp_suaHocSinh_SuaLop";
SqlParameter para1 = new SqlParameter("@maHocSinh", hocsinh.MaHocSinh);
SqlParameter para2 = new SqlParameter("@maLop", lop.MaLop);
int ketqua = DataProvider.executeStoreProcedureNonQuery(nameProc_SuaHocSinh_SuaLop, para1, para2);
if (ketqua != 0)
{
return true;
}
return false;
}
public string layTenLop_TuHocSinh_DAO(HocSinh hocsinh)
{
string nameProc_LayDSHocSinh_DaCoLop = "sp_layTenLop_TuHocSinh";
SqlParameter para1 = new SqlParameter("@maHocSinh", hocsinh.MaHocSinh);
DataTable bangDSHocSinh = DataProvider.executeStoreProcedureQuery(nameProc_LayDSHocSinh_DaCoLop, para1);
return bangDSHocSinh.Rows[0]["tenLop"].ToString();
}
public int layMaLop_TuHocSinh_DAO(HocSinh hocsinh)
{
string nameProc_LayDSHocSinh_DaCoLop = "sp_layTenLop_TuHocSinh";
SqlParameter para1 = new SqlParameter("@maHocSinh", hocsinh.MaHocSinh);
DataTable bangDSHocSinh = DataProvider.executeStoreProcedureQuery(nameProc_LayDSHocSinh_DaCoLop, para1);
return Convert.ToInt32(bangDSHocSinh.Rows[0]["maLop"]);
}
// lấy danh sách từ gridview đưa lên GUI
public void duaLenGUI_TuGridView()
{
int indexRow = dtgvHocSinh.CurrentRow.Index;
if (indexRow < dtgvHocSinh.RowCount - 1)
{
HocSinh hocsinh = layHocSinh_Tu_DataRowGridView(dtgvHocSinh.CurrentRow);
tbxDiaChi.Text = hocsinh.Diachi;
tbxEmail.Text = hocsinh.Email;
tbxHoTen.Text = hocsinh.HoTen;
if (hocsinh.GioiTinh == true)
{
lbGT.Text = "Nam";
}
else
{
lbGT.Text = "Nữ";
}
lbNS.Text = hocsinh.NgaySinh.ToShortDateString();
HocSinh[] dsHs = new HocSinh[1];
dsHs[0] = hocsinh;
hocsinh_hientai = hocsinh;
combomaHocSinh.DataSource = dsHs;
combomaHocSinh.DisplayMember = "maHocSinh";
combomaHocSinh.ValueMember = "maHocSinh";
}
}
public bool suaHocSinh_SuaLop_DAO(HocSinh hocsinh, Lop lop)
{
return hocsinhDAO.suaHocSinh_SuaLop_DAO(hocsinh, lop);
}
public bool tiepNhanHocSinhDAO(HocSinh hocsinh)
{
string nameProc_TNHocSinh = "sp_tiepNhanHocSinh";
string nameProc_ThemTaiKhoan = "sp_them_TaiKhoanDangNhap";
string nameProc_LayMaTaiKhoan = "sp_layMaTaiKhoan_TheoTenTK";
//------------------
SqlParameter pa1 = new SqlParameter("@tenTaiKhoan", hocsinh.Email.ToLower());
SqlParameter pa2 = new SqlParameter("@matKhau", hocsinh.Email.ToString());
SqlParameter pa3 = new SqlParameter("@loaiTaiKhoan", 3);
DataProvider.executeStoreProcedureNonQuery(nameProc_ThemTaiKhoan, pa1, pa2, pa3);
SqlParameter pa = new SqlParameter("@tenTaiKhoan", hocsinh.Email.ToLower());
DataTable bangMaTaiKhoan = DataProvider.executeStoreProcedureQuery(nameProc_LayMaTaiKhoan, pa);
hocsinh.MaTaiKhoan = layMaTaiKhoan_TuBang_MaTaiKhoan(bangMaTaiKhoan);
//-----------------
SqlParameter para1 = new SqlParameter("@hoTen", hocsinh.HoTen);
SqlParameter para2 = new SqlParameter("@ngaySinh", hocsinh.NgaySinh);
SqlParameter para3 = new SqlParameter("@gioiTinh", hocsinh.GioiTinh);
SqlParameter para4 = new SqlParameter("@email", hocsinh.Email);
SqlParameter para5 = new SqlParameter("@diaChi", hocsinh.Diachi);
SqlParameter para6 = new SqlParameter("@maTaiKhoan", hocsinh.MaTaiKhoan);
int ketqua = DataProvider.executeStoreProcedureNonQuery(nameProc_TNHocSinh, para1, para2, para3, para4, para5, para6);
if (ketqua != 0)
{
return true;
}
return false;
}
public bool themHocSinh_BUS(HocSinh hocsinh)
{
//neu them thi có trả về là thêm đx hay không
return hocsinhDAO.tiepNhanHocSinhDAO(hocsinh);
}
public bool xoaHocSinh_DAO(HocSinh hocsinh)
{
string nameProc_XoaHocSinh = "sp_xoaHocSinh";
string nameProc_XoaTaiKhoan = "sp_xoa_TaiKhoanDangNhap";
string nameProc_LayMaTaiKhoanHS = "sp_layHocSinh";
//---------
SqlParameter para1 = new SqlParameter("@maHocSinh", hocsinh.MaHocSinh);
//------------------
DataTable bangMaTaiKhoan = DataProvider.executeStoreProcedureQuery(nameProc_LayMaTaiKhoanHS, para1);
hocsinh.MaTaiKhoan = layMaTaiKhoanHS_TuBang_MaTaiKhoan(bangMaTaiKhoan);
SqlParameter para2 = new SqlParameter("@maTaiKhoan", hocsinh.MaTaiKhoan);
SqlParameter para3 = new SqlParameter("@maHocSinh", hocsinh.MaHocSinh);
int ketqua = DataProvider.executeStoreProcedureNonQuery(nameProc_XoaHocSinh, para3);
DataProvider.executeStoreProcedureNonQuery(nameProc_XoaTaiKhoan, para2);
if (ketqua != 0)
{
return true;
}
else
{
return false;
}
}
public bool xoaHocSinh_BUS(HocSinh hocsinh)
{
return hocsinhDAO.xoaHocSinh_DAO(hocsinh);
}
public bool xoaHocSinh_RaKhoiLop_DAO(HocSinh hocsinh)
{
string nameProc_ThemHocSinh_VaoLop = "sp_xoaHocSinh_RaKhoiLop";
SqlParameter para1 = new SqlParameter("@maHocSinh", hocsinh.MaHocSinh);
int ketqua = DataProvider.executeStoreProcedureNonQuery(nameProc_ThemHocSinh_VaoLop, para1);
if (ketqua != 0)
{
return true;
}
return false;
}
public bool themHocSinh_VaoLop_DAO(HocSinh hocsinh, Lop lop)
{
bool kiemtra_soluonghs = kiemTraSoLuongHocSinh_TrongMotLop(lop.MaLop);
if (kiemtra_soluonghs == true)
{
string nameProc_ThemHocSinh_VaoLop = "sp_themHocSinh_VaoLop";
SqlParameter para1 = new SqlParameter("@maHocSinh", hocsinh.MaHocSinh);
SqlParameter para2 = new SqlParameter("@maLop", lop.MaLop);
int ketqua = DataProvider.executeStoreProcedureNonQuery(nameProc_ThemHocSinh_VaoLop, para1, para2);
if (ketqua != 0)
{
return true;
}
return false;
}
else
{
return false;
}
}
private void combomaHocSinh_SelectedIndexChanged(object sender, EventArgs e)
{
HocSinh[] dsHocSinh;
if (edit == false)
{
dsHocSinh = hocsinhBUS.layDanhSachHocSinh_ChuaCoLop_BUS();
}
else
{
dsHocSinh = new HocSinh[1];
dsHocSinh[0] = hocsinh_hientai;
}
int index = combomaHocSinh.SelectedIndex;
if (index != -1)
{
duaThongTinHocSinh_GUI(dsHocSinh[index]);
}
else
{
if (index == -1)
{
btnThem.Enabled = false;
}
}
}
