private void btnLuu_Click(object sender, EventArgs e)
{
int numberOfRow = lVDiem.Items.Count;
for (int i = 0; i < numberOfRow; i++)
{
ListViewItem item = lVDiem.Items[i];
DiemInfo diem = new DiemInfo();
diem = (DiemInfo)item.Tag;
m_DiemCtrl.LuuDiem(diem.HocSinh.MaHocSinh, diem.MonHoc.MaMonHoc, diem.HocKy.MaHocKy, diem.NamHoc.MaNamHoc, diem.Lop.MaLop, diem.LoaiDiem.MaLoai, diem.Diem);
}
lVDiem.Items.Clear();
MessageBoxEx.Show("Đã lưu vào bảng điểm!", "COMPLETED", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void simpleButtonLuu_Click(object sender, EventArgs e)
{
if (dGVDiem.RowCount == 0)
{
MessageBoxEx.Show("Chưa có học sinh!", "CHÚ Ý", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (KiemTraDiemTruocKhiLuu("colDiem") == true)
{
if (MsgboxUtil.YesNo("Bạn có chắc chắn muốn cập nhật không ?")
== DialogResult.Yes)
{
if (STT != null)
{
int rowcount = 0;
foreach (DataGridViewRow row in dGVDiem.Rows)
{
rowcount++;
#region Kiểm tra miệng
if (row.Cells["colDiem"].Value != null)
{
String chuoiDiemChuaXuLy = row.Cells["colDiem"].Value.ToString();
String diemDaXuLy = null;
int count = 0;
for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++)
{
if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1)
{
count++;
}
else
{
if (i == chuoiDiemChuaXuLy.Length - 1)
{
i++;
count++;
}
diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count);
if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy))
{
m_DiemCtrl.LuuDiem(row.Cells["colMaQuaTrinhHoc"].Value.ToString(),
cmbMonHoc.SelectedValue.ToString(),
cmbLoaiDiem.SelectedValue.ToString(),
float.Parse(diemDaXuLy.ToString()));
}
diemDaXuLy = null;
count = 0;
}
}
}
#endregion
#region Lưu vào bảng kết quả
if (rowcount <= dGVDiem.Rows.Count)
{
m_BaoCaoTongKetMonCtrl.LuuKetQuaSD(row.Cells["colMaQuaTrinhHoc"].Value.ToString(), cmbMonHoc.SelectedValue.ToString());
m_BaoCaoTongKetMonCtrl.LuuKetQua1(cmbHocKy.SelectedValue.ToString(), cmbLop.SelectedValue.ToString(), cmbMonHoc.SelectedValue.ToString());
m_BaoCaoTongKetHocKyCtrl.LuuKetQua1(cmbHocKy.SelectedValue.ToString(), cmbLop.SelectedValue.ToString());
}
#endregion
#region Xóa các kết quả cũ
if (STT != null)
{
for (int i = 1; i < 60; i++)
{
for (int j = 1; j < 20; j++)
{
int id = STT[i, j];
if (id > 0)
{
m_DiemCtrl.XoaBangDiem(id);
// m_DiemCtrl.XoaDiem(id);
}
else
{
break;
}
}
}
}
#endregion
}
MessageBoxEx.Show("Cập nhật thành công!", "COMPLETED", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
private void btnLuuDiem_Click(object sender, EventArgs e)
{
if (KiemTraDiemTruocKhiLuu("colDiemMieng") == true &&
KiemTraDiemTruocKhiLuu("colDiem15Phut") == true &&
KiemTraDiemTruocKhiLuu("colDiem45Phut") == true &&
KiemTraDiemTruocKhiLuu("colDiemThi") == true)
{
#region Nếu nhập điểm
if (buttonItemNhapDuLieu.Checked == true && STT == null)
{
int rowcount = 0;
foreach (DataGridViewRow row in dGVDiem.Rows)
{
rowcount++;
#region Kiểm tra miệng
if (row.Cells["colDiemMieng"].Value != null)
{
String chuoiDiemChuaXuLy = row.Cells["colDiemMieng"].Value.ToString();
String diemDaXuLy = null;
int count = 0;
for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++)
{
if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1)
{
count++;
}
else
{
if (i == chuoiDiemChuaXuLy.Length - 1)
{
i++;
count++;
}
diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count);
if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy))
{
m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(),
cmbMonHoc.SelectedValue.ToString(),
cmbHocKy.SelectedValue.ToString(),
cmbNamHoc.SelectedValue.ToString(),
cmbLop.SelectedValue.ToString(),
"LD0001",
float.Parse(diemDaXuLy.ToString()));
}
diemDaXuLy = null;
count = 0;
}
}
}
#endregion
#region Kiểm tra 15 phút
if (row.Cells["colDiem15Phut"].Value != null)
{
String chuoiDiemChuaXuLy = row.Cells["colDiem15Phut"].Value.ToString();
String diemDaXuLy = null;
int count = 0;
for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++)
{
if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1)
{
count++;
}
else
{
if (i == chuoiDiemChuaXuLy.Length - 1)
{
i++;
count++;
}
diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count);
if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy))
{
m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(),
cmbMonHoc.SelectedValue.ToString(),
cmbHocKy.SelectedValue.ToString(),
cmbNamHoc.SelectedValue.ToString(),
cmbLop.SelectedValue.ToString(),
"LD0002",
float.Parse(diemDaXuLy.ToString()));
}
diemDaXuLy = null;
count = 0;
}
}
}
#endregion
#region Kiểm tra 45 phút
if (row.Cells["colDiem45Phut"].Value != null)
{
String chuoiDiemChuaXuLy = row.Cells["colDiem45Phut"].Value.ToString();
String diemDaXuLy = null;
int count = 0;
for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++)
{
if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1)
{
count++;
}
else
{
if (i == chuoiDiemChuaXuLy.Length - 1)
{
i++;
count++;
}
diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count);
if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy))
{
m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(),
cmbMonHoc.SelectedValue.ToString(),
cmbHocKy.SelectedValue.ToString(),
cmbNamHoc.SelectedValue.ToString(),
cmbLop.SelectedValue.ToString(),
"LD0003",
float.Parse(diemDaXuLy.ToString()));
}
diemDaXuLy = null;
count = 0;
}
}
}
#endregion
#region Thi học kỳ
if (row.Cells["colDiemThi"].Value != null)
{
String diemThi = row.Cells["colDiemThi"].Value.ToString();
if (quyDinh.KiemTraDiem(diemThi))
{
m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(),
cmbMonHoc.SelectedValue.ToString(),
cmbHocKy.SelectedValue.ToString(),
cmbNamHoc.SelectedValue.ToString(),
cmbLop.SelectedValue.ToString(),
"LD0004",
float.Parse(diemThi.ToString()));
}
}
#endregion
#region Lưu vào bảng kết quả
if (rowcount <= dGVDiem.Rows.Count)
{
m_KQHocKyMonHocCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(),
cmbLop.SelectedValue.ToString(),
cmbMonHoc.SelectedValue.ToString(),
cmbHocKy.SelectedValue.ToString(),
cmbNamHoc.SelectedValue.ToString());
m_KQCaNamMonHocCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(),
cmbLop.SelectedValue.ToString(),
cmbMonHoc.SelectedValue.ToString(),
cmbNamHoc.SelectedValue.ToString());
m_KQHocKyTongHopCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(),
cmbLop.SelectedValue.ToString(),
cmbHocKy.SelectedValue.ToString(),
cmbNamHoc.SelectedValue.ToString());
m_KQCaNamTongHopCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(),
cmbLop.SelectedValue.ToString(),
cmbNamHoc.SelectedValue.ToString());
}
#endregion
}
MessageBoxEx.Show("Đã lưu thành công vào bảng điểm!", "COMPLETED", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
#endregion
#region Nếu sửa điểm
if (buttonItemCapNhatDuLieu.Checked == true || STT != null)
{
int rowcount = 0;
foreach (DataGridViewRow row in dGVDiem.Rows)
{
rowcount++;
#region Kiểm tra miệng
if (row.Cells["colDiemMieng"].Value != null)
{
String chuoiDiemChuaXuLy = row.Cells["colDiemMieng"].Value.ToString();
String diemDaXuLy = null;
int count = 0;
for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++)
{
if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1)
{
count++;
}
else
{
if (i == chuoiDiemChuaXuLy.Length - 1)
{
i++;
count++;
}
diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count);
if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy))
{
m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(),
cmbMonHocSD.SelectedValue.ToString(),
cmbHocKySD.SelectedValue.ToString(),
cmbNamHocSD.SelectedValue.ToString(),
cmbLopSD.SelectedValue.ToString(),
"LD0001",
float.Parse(diemDaXuLy.ToString()));
}
diemDaXuLy = null;
count = 0;
}
}
}
#endregion
#region Kiểm tra 15 phút
if (row.Cells["colDiem15Phut"].Value != null)
{
String chuoiDiemChuaXuLy = row.Cells["colDiem15Phut"].Value.ToString();
String diemDaXuLy = null;
int count = 0;
for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++)
{
if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1)
{
count++;
}
else
{
if (i == chuoiDiemChuaXuLy.Length - 1)
{
i++;
count++;
}
diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count);
if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy))
{
m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(),
cmbMonHocSD.SelectedValue.ToString(),
cmbHocKySD.SelectedValue.ToString(),
cmbNamHocSD.SelectedValue.ToString(),
cmbLopSD.SelectedValue.ToString(),
"LD0002",
float.Parse(diemDaXuLy.ToString()));
}
diemDaXuLy = null;
count = 0;
}
}
}
#endregion
#region Kiểm tra 45 phút
if (row.Cells["colDiem45Phut"].Value != null)
{
String chuoiDiemChuaXuLy = row.Cells["colDiem45Phut"].Value.ToString();
String diemDaXuLy = null;
int count = 0;
for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++)
{
if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1)
{
count++;
}
else
{
if (i == chuoiDiemChuaXuLy.Length - 1)
{
i++;
count++;
}
diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count);
if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy))
{
m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(),
cmbMonHocSD.SelectedValue.ToString(),
cmbHocKySD.SelectedValue.ToString(),
cmbNamHocSD.SelectedValue.ToString(),
cmbLopSD.SelectedValue.ToString(),
"LD0003",
float.Parse(diemDaXuLy.ToString()));
}
diemDaXuLy = null;
count = 0;
}
}
}
#endregion
#region Thi học kỳ
if (row.Cells["colDiemThi"].Value != null)
{
String diemThi = row.Cells["colDiemThi"].Value.ToString();
if (quyDinh.KiemTraDiem(diemThi))
{
m_DiemCtrl.LuuDiem(row.Cells["colMaHocSinh"].Value.ToString(),
cmbMonHocSD.SelectedValue.ToString(),
cmbHocKySD.SelectedValue.ToString(),
cmbNamHocSD.SelectedValue.ToString(),
cmbLopSD.SelectedValue.ToString(),
"LD0004",
float.Parse(diemThi.ToString()));
}
}
#endregion
#region Lưu vào bảng kết quả
if (rowcount <= dGVDiem.Rows.Count)
{
m_KQHocKyMonHocCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(),
cmbLopSD.SelectedValue.ToString(),
cmbMonHocSD.SelectedValue.ToString(),
cmbHocKySD.SelectedValue.ToString(),
cmbNamHocSD.SelectedValue.ToString());
m_KQCaNamMonHocCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(),
cmbLopSD.SelectedValue.ToString(),
cmbMonHocSD.SelectedValue.ToString(),
cmbNamHocSD.SelectedValue.ToString());
m_KQHocKyTongHopCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(),
cmbLopSD.SelectedValue.ToString(),
cmbHocKySD.SelectedValue.ToString(),
cmbNamHocSD.SelectedValue.ToString());
m_KQCaNamTongHopCtrl.LuuKetQua(row.Cells["colMaHocSinh"].Value.ToString(),
cmbLopSD.SelectedValue.ToString(),
cmbNamHocSD.SelectedValue.ToString());
}
#endregion
#region Xóa các kết quả cũ
if (STT != null)
{
for (int i = 1; i < 60; i++)
{
for (int j = 1; j < 20; j++)
{
int id = STT[i, j];
if (id > 0)
{
m_DiemCtrl.XoaDiem(id);
}
else
{
break;
}
}
}
}
#endregion
}
MessageBoxEx.Show("Cập nhật thành công!", "COMPLETED", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
#endregion
}
}
private void simpleButtonLuu_Click(object sender, EventArgs e)
{
if (dGVDiem.RowCount == 0)
{
MessageBoxEx.Show("Chưa có học sinh!", "CHÚ Ý", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (cmbHocKy.SelectedValue == null)
{
MessageBoxEx.Show("Bạn chưa chọn học kỳ!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (cmbLop.SelectedValue == null)
{
MessageBoxEx.Show("Bạn chưa chọn lớp!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (cmbMonHoc.SelectedValue == null)
{
MessageBoxEx.Show("Bạn chưa chọn môn học!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (KiemTraDiemTruocKhiLuu("colDiem") == true)
{
if (MsgboxUtil.YesNo("Bạn có chắc chắn muốn lưu không ?")
== DialogResult.Yes)
{
if (STT == null)
{
int rowcount = 0;
foreach (DataGridViewRow row in dGVDiem.Rows)
{
rowcount++;
if (row.Cells["colDiem"].Value != null)
{
String chuoiDiemChuaXuLy = row.Cells["colDiem"].Value.ToString();
String diemDaXuLy = null;
int count = 0;
for (int i = 0; i < chuoiDiemChuaXuLy.Length; i++)
{
if (chuoiDiemChuaXuLy[i] != ';' && i != chuoiDiemChuaXuLy.Length - 1)
{
count++;
}
else
{
if (i == chuoiDiemChuaXuLy.Length - 1)
{
i++;
count++;
}
diemDaXuLy = chuoiDiemChuaXuLy.Substring(i - count, count);
if (diemDaXuLy != null && diemDaXuLy != " " && quyDinh.KiemTraDiem(diemDaXuLy))
{
m_DiemCtrl.LuuDiem(row.Cells["colMaQuaTrinhHoc"].Value.ToString(),
cmbMonHoc.SelectedValue.ToString(),
cmbLoaiDiem.SelectedValue.ToString(),
float.Parse(diemDaXuLy.ToString()));
}
diemDaXuLy = null;
count = 0;
}
}
}
if (rowcount <= dGVDiem.Rows.Count)
{
m_BaoCaoTongKetMonCtrl.LuuKetQua(row.Cells["colMaQuaTrinhHoc"].Value.ToString(), cmbMonHoc.SelectedValue.ToString());
m_BaoCaoTongKetHocKyCtrl.LuuKetQua(row.Cells["colMaQuaTrinhHoc"].Value.ToString());
}
}
m_BaoCaoTongKetMonCtrl.LuuKetQua1(cmbHocKy.SelectedValue.ToString(), cmbLop.SelectedValue.ToString(), cmbMonHoc.SelectedValue.ToString());
m_BaoCaoTongKetHocKyCtrl.LuuKetQua1(cmbHocKy.SelectedValue.ToString(), cmbLop.SelectedValue.ToString());
}
MessageBoxEx.Show("Đã lưu thành công!", "Thành Công", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
return;
}
}
}
