private void btnXacNhan_Click(object sender, EventArgs e)
{
string ten = txtTenMoi.Text;
string gioitinh = cbGioiTinhMoi.Text;
string ngaysinh = dtpNgaySinhMoi.Text;
LopHoc lh = cbTenLop.SelectedValue as LopHoc;
if (ckbNgaySinh.Checked == false)
{
ngaysinh = "";
}
else
{
ngaysinh = String.Format("{0:yyyy/MM/dd}", ngaysinh);
}
if (kiemTra(ten, gioitinh, ngaysinh))
{
int ketQua = 0;
ketQua = HocSinhControl.suaThongTin(id, ten, ngaysinh, gioitinh, lh.MaLH);
if (ketQua > 0)
{
MessageBox.Show("thay đổi thành công");
this.Close();
}
}
}
private void dgvDanhSach_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvDanhSach.Rows.Count == e.RowIndex + 1 || e.RowIndex == -1)
{
return;
}
int id = Convert.ToInt32(dgvDanhSach.Rows[e.RowIndex].Cells["colMa"].Value.ToString());
if (e.ColumnIndex == dgvDanhSach.Columns["colSua"].Index)
{
frmSuaHS f = new frmSuaHS(id);
f.ShowDialog();
loadDuLieu();
}
else if (e.ColumnIndex == dgvDanhSach.Columns["colXoa"].Index)
{
int ketQua = HocSinhControl.xoaThongTin(id);
if (ketQua <= 0)
{
MessageBox.Show("Thực hiện thất bại");
}
else
{
loadDuLieu();
}
}
else if (e.ColumnIndex == dgvDanhSach.Columns["colChiTiet"].Index)
{
frmDiemHS frm = new frmDiemHS(id);
frm.ShowDialog();
}
}
private void loadDuLieu()
{
dgvDanhSach.Rows.Clear();
DataTable dt = HocSinhControl.layDanhSach();
for (int i = 0; i < dt.Rows.Count; ++i)
{
string date = String.Format("{0:dd/MM/yyyy}", dt.Rows[i][2]);
dgvDanhSach.Rows.Add(new object[] { false, dt.Rows[i][0], dt.Rows[i][1], date, dt.Rows[i][3], dt.Rows[i][4] });
}
}
private void frmThemHS_Load(object sender, EventArgs e)
{
List <LopHoc> listLop = new List <LopHoc>();
DataTable dt = HocSinhControl.layDanhSachLop();
for (int i = 0; i < dt.Rows.Count; ++i)
{
listLop.Add(new LopHoc {
MaLH = Convert.ToInt32(dt.Rows[i][0].ToString()), TenLH = dt.Rows[i][1].ToString(), GVCN = dt.Rows[i][2].ToString()
});
}
cbLopHoc.DataSource = listLop;
cbLopHoc.DisplayMember = "TenLH";
cbLopHoc.Text = "Chon lop hoc";
}
private void timKiem()
{
// get text
string value = txtTimKiem.Text;
if (value.Length == 0)
{
loadDuLieu();
return;
}
dgvDanhSach.Rows.Clear();
DataTable dt = HocSinhControl.timKiem(value);
for (int i = 0; i < dt.Rows.Count; ++i)
{
string date = String.Format("{0:dd/MM/yyyy}", dt.Rows[i][2]);
dgvDanhSach.Rows.Add(new object[] { false, dt.Rows[i][0], dt.Rows[i][1], date, dt.Rows[i][3], dt.Rows[i][4] });
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
int ketQua = 0;
for (int i = 0; i < dgvDanhSach.Rows.Count - 1; ++i)
{
if (Convert.ToBoolean(dgvDanhSach.Rows[i].Cells["colCheck"].Value.ToString()))
{
ketQua += HocSinhControl.xoaThongTin(Convert.ToInt32(dgvDanhSach.Rows[i].Cells["colMa"].Value.ToString()));
}
}
if (ketQua > 0)
{
MessageBox.Show("xóa thành công " + ketQua);
loadDuLieu();
}
else
{
MessageBox.Show("xóa thất bại");
}
}
public frmSuaHS(int id)
{
InitializeComponent();
List <LopHoc> listLop = new List <LopHoc>();
DataTable dt = HocSinhControl.layDanhSachLop();
for (int i = 0; i < dt.Rows.Count; ++i)
{
listLop.Add(new LopHoc {
MaLH = Convert.ToInt32(dt.Rows[i][0].ToString()), TenLH = dt.Rows[i][1].ToString(), GVCN = dt.Rows[i][2].ToString()
});
}
cbTenLop.DataSource = listLop;
cbTenLop.DisplayMember = "TenLH";
this.id = id;
dt = HocSinhControl.layThongTin(id);
txtTenCu.Text = dt.Rows[0][1].ToString();
txtGioiTinh.Text = dt.Rows[0][3].ToString();
txtNgaySinhCu.Text = String.Format("{0:dd/MM/yyyy}", dt.Rows[0][2]);
txtTenLopCu.Text = dt.Rows[0][4].ToString();
cbTenLop.SelectedIndex = cbTenLop.FindStringExact(dt.Rows[0][4].ToString());
}
