//Hàm sửa
public bool SuaDuLieu(EC_LichHoc ec)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "dbo.[LichHoc_Update]";
cmd.CommandType = CommandType.StoredProcedure;
try
{
con.MoKetNoi();
// Use connection object of base class
cmd.Connection = con.connect;
cmd.Parameters.AddWithValue("@Ma_LopHoc", ec.Ma_LopHoc);
cmd.Parameters.AddWithValue("@NgayHoc", ec.NgayHoc);
cmd.Parameters.AddWithValue("@KipHoc", ec.KipHoc);
cmd.Parameters.AddWithValue("@Ma_BuoiHoc", ec.Ma_BuoiHoc);
cmd.Parameters.AddWithValue("@TongHocPhi_Buoi", ec.TongHocPhi_Buoi);
cmd.Parameters.AddWithValue("@PhongHoc", ec.PhongHoc);
cmd.Parameters.AddWithValue("@STT_Buoi", ec.STT_Buoi);
cmd.Parameters.AddWithValue("@TrangThai", ec.TrangThai);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
throw new Exception("Lỗi khi sửa lich hoc: " + e.ToString());
}
finally
{
con.DongKetNoi();
cmd.Dispose();
}
}
private void btThem_Click(object sender, EventArgs e)
{
if (txbMa_LopHoc.Text != "")
{
return;
}
string Ma_LopHoc = TaoMa_LopHoc();
string Ma_MonHoc = txbMa_MonHoc.Text;
if (Ma_MonHoc == "")
{
return;
}
string Ma_GiaoVien = "";
if (dgGiaoVien.Rows.Count == 0)
{
return;
}
foreach (DataGridViewRow row in dgGiaoVien.Rows)
{
if (Convert.ToBoolean(row.Cells["Check"].Value.ToString()) == true)
{
Ma_GiaoVien = row.Cells["Ma"].Value.ToString();
}
}
if (Ma_GiaoVien == "")
{
return;
}
//Thêm lớp học
EC_LopHoc ecLop = new EC_LopHoc(Ma_LopHoc, txbMaGV.Text, Ma_MonHoc, cbTrinhDo.SelectedItem.ToString(), Convert.ToInt32(txbTongHP.Text)
, Convert.ToInt32(txbSoBuoi.Text), dtNgayBatdau.Value);
new BUS_LopHoc().ThemDuLieu(ecLop);
//Thêm các buổi học với thời gian mặc định là ngày hôm nay
int HocPhi_Buoi = Convert.ToInt32(txbTongHP.Text) / Convert.ToInt32(txbSoBuoi.Text);
string Ma_BuoiHoc_Cu = LayMa_BuoiHoc_Cu(new BUS_LichHoc().SelectAll());
for (int i = 0; i < Convert.ToInt32(txbSoBuoi.Text); i++)
{
string Ma_BuoiHoc = TaoMa_BuoiHoc(Ma_BuoiHoc_Cu);
EC_LichHoc ecLich = new EC_LichHoc(Ma_LopHoc, DateTime.Now, 1, Ma_BuoiHoc, "", i + 1, HocPhi_Buoi, false);
new BUS_LichHoc().ThemDuLieu(ecLich);
Ma_BuoiHoc_Cu = Ma_BuoiHoc;
}
DialogResult result = MessageBox.Show("Thêm thành công lớp học!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (result == DialogResult.OK)
{
txbMaGV.Text = "";
txbSoBuoi.Text = "";
txbTongHP.Text = "";
}
LoadForm();
}
/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of SinhVien</returns>
internal List <EC_LichHoc> PopulateObjectsFromReader(IDataReader dataReader)
{
List <EC_LichHoc> list = new List <EC_LichHoc>();
while (dataReader.Read())
{
EC_LichHoc businessObject = new EC_LichHoc();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
private void dgLichHoc_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
if (e.ColumnIndex == 7)
{
string ThaoTac = dgLichHoc.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
if (ThaoTac == "Thêm")
{
string Ma_BuoiHoc_Cu = new BUS_LichHoc().SelectAll()[0].Ma_BuoiHoc;
string Ma_BuoiHoc_Moi = TaoMa_BuoiHoc(Ma_BuoiHoc_Cu);
DataGridViewRow cell = dgLichHoc.Rows[e.RowIndex];
int Kip = Int32.Parse(cell.Cells["KipHoc"].Value.ToString());
string Phong = cell.Cells["Phong"].Value.ToString();
DateTime NgayHoc = Convert.ToDateTime(cell.Cells["NgayHoc"].Value.ToString());
int TongHocPhi_Buoi = Convert.ToInt32(cell.Cells["TongHocPhi_Buoi"].Value.ToString());
bool TrangThai = cell.Cells[6].Value.ToString() == "Đã học" ? true : false;
int Stt_Buoi = Convert.ToInt32(cell.Cells["STT"].Value);
List <EC_LichHoc> ListLichHoc = new BUS_LichHoc().SelectByFields("Ma_LopHoc", Ma_LopHoc);
foreach (EC_LichHoc Buoi in ListLichHoc)
{
if (Stt_Buoi == Buoi.STT_Buoi)
{
MessageBox.Show("Số thứ tự buổi học đã tồn tại", "Thông báo");
return;
}
}
EC_LichHoc BuoiHoc = new EC_LichHoc(Ma_LopHoc, DateTime.Now, Kip, Ma_BuoiHoc_Moi,
Phong, Stt_Buoi, TongHocPhi_Buoi, TrangThai);
new BUS_LichHoc().ThemDuLieu(BuoiHoc);
}
else if (ThaoTac == "Sửa")
{
DataGridViewRow cell = dgLichHoc.Rows[e.RowIndex];
EC_LichHoc BuoiHoc = new BUS_LichHoc().Select_ByPrimaryKey(cell.Cells["Ma_BuoiHoc"].Value.ToString());
BuoiHoc.STT_Buoi = Int32.Parse(cell.Cells["STT"].Value.ToString());
BuoiHoc.NgayHoc = Convert.ToDateTime(cell.Cells["NgayHoc"].Value);
BuoiHoc.PhongHoc = cell.Cells["PhongHoc"].Value.ToString();
new BUS_LichHoc().SuaDuLieu(BuoiHoc);
}
}
else
{
}
}
private void btDiemDanh_Click(object sender, EventArgs e)
{
EC_LichHoc BuoiHoc = listBuoiHoc[Stt];
string Ma_BuoiHoc = BuoiHoc.Ma_BuoiHoc;
int SoDiHoc = 0;
foreach (DataGridViewRow row in dgLopHoc.Rows)
{
if (Convert.ToBoolean(row.Cells["DiemDanhh"].Value) == true)
{
SoDiHoc++;
}
}
int TongSoTien_Buoi = BuoiHoc.TongHocPhi_Buoi;
int SoTien_Buoi;
if (SoDiHoc == 0)
{
SoTien_Buoi = 0;
return;
}
else
{
SoTien_Buoi = TongSoTien_Buoi / SoDiHoc;
}
foreach (DataGridViewRow row in dgLopHoc.Rows)
{
string Ten_HocSinh = row.Cells["Ten_HocSinh"].Value.ToString();
string SDT = row.Cells["SDT"].Value.ToString();
string Ma_HocSinh = "";
foreach (EC_HocSinh hs in DanhSachLop)
{
if (hs.Ten_HocSinh == Ten_HocSinh && hs.SDT == SDT)
{
Ma_HocSinh = hs.Ma_HocSinh;
}
}
EC_BuoiHoc_HocSinh bhhs = new EC_BuoiHoc_HocSinh();
bhhs.Ma_HocSinh = Ma_HocSinh;
bhhs.Ma_BuoiHoc = Ma_BuoiHoc;
bhhs.DiemDanh = Convert.ToBoolean(row.Cells["DiemDanhh"].Value);
bhhs.DongTien = false;
bhhs.SoTien_Buoi = SoTien_Buoi;
bhhs.DanhGia = "";
new BUS_BuoiHoc_HocSinh().SuaDuLieu(bhhs);
}
new BUS_LichHoc().SuaTrangThai(Ma_BuoiHoc, true);
LoadForm();
}
private void btThem_Click(object sender, EventArgs e)
{
string Ma_LopHoc = TaoMa_LopHoc();
string Ten_MonHoc = cbTenMon.SelectedItem.ToString();
string Ma_MonHoc = "";
List <EC_MonHoc> list1 = new BUS_MonHoc().SelectByFields("Ten_MonHoc", Ten_MonHoc);
List <EC_MonHoc> list2 = new BUS_MonHoc().SelectByFields("Lop", cbLop.SelectedItem.ToString());
foreach (EC_MonHoc ec1 in list1)
{
foreach (EC_MonHoc ec2 in list2)
{
if (ec1.Ma_MonHoc == ec2.Ma_MonHoc)
{
Ma_MonHoc = ec1.Ma_MonHoc;
}
}
}
EC_LopHoc ecLop = new EC_LopHoc(Ma_LopHoc, txbMaGV.Text, Ma_MonHoc, cbTrinhDo.SelectedItem.ToString(), Convert.ToInt32(txbTongHP.Text)
, Convert.ToInt32(txbSoBuoi.Text), dtNgayBatdau.Value);
new BUS_LopHoc().ThemDuLieu(ecLop);
int HocPhi_Buoi = Convert.ToInt32(txbTongHP.Text) / Convert.ToInt32(txbSoBuoi.Text);
string Ma_BuoiHoc_Cu = LayMa_BuoiHoc_Cu(new BUS_LichHoc().SelectAll());
for (int i = 0; i < Convert.ToInt32(txbSoBuoi.Text); i++)
{
string Ma_BuoiHoc = TaoMa_BuoiHoc(Ma_BuoiHoc_Cu);
EC_LichHoc ecLich = new EC_LichHoc(Ma_LopHoc, DateTime.Now, 1, Ma_BuoiHoc, "", i + 1, HocPhi_Buoi, false);
new BUS_LichHoc().ThemDuLieu(ecLich);
Ma_BuoiHoc_Cu = Ma_BuoiHoc;
}
DialogResult result = MessageBox.Show("Thêm thành công lớp học!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (result == DialogResult.OK)
{
txbMaGV.Text = "";
txbSoBuoi.Text = "";
txbTongHP.Text = "";
}
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(EC_LichHoc businessObject, IDataReader dataReader)
{
businessObject.Ma_BuoiHoc = dataReader.GetString(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.Ma_BuoiHoc.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.Ma_LopHoc.ToString())))
{
businessObject.Ma_LopHoc = dataReader.GetString(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.Ma_LopHoc.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.KipHoc.ToString())))
{
businessObject.KipHoc = dataReader.GetInt32(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.KipHoc.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.NgayHoc.ToString())))
{
businessObject.NgayHoc = dataReader.GetDateTime(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.NgayHoc.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.PhongHoc.ToString())))
{
businessObject.PhongHoc = dataReader.GetString(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.PhongHoc.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.STT_Buoi.ToString())))
{
businessObject.STT_Buoi = dataReader.GetInt32(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.STT_Buoi.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.TongHocPhi_Buoi.ToString())))
{
businessObject.TongHocPhi_Buoi = dataReader.GetInt32(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.TongHocPhi_Buoi.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.TrangThai.ToString())))
{
businessObject.TrangThai = dataReader.GetBoolean(dataReader.GetOrdinal(EC_LichHoc.LichHocFields.TrangThai.ToString()));
}
}
public EC_LichHoc Select_ByPrimaryKey(string Ma_BuoiHoc)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[LichHoc_Select_By_Ma]";
sqlCommand.CommandType = CommandType.StoredProcedure;
try
{
sqlCommand.Parameters.AddWithValue("@Ma_BuoiHoc", Ma_BuoiHoc);
con.MoKetNoi();
// Use connection object of base class
sqlCommand.Connection = con.connect;
IDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
EC_LichHoc businessObject = new EC_LichHoc();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("Lỗi khi lấy tất cả buổi học.", ex);
}
finally
{
con.DongKetNoi();
sqlCommand.Dispose();
}
}
private void btXoa_Click(object sender, EventArgs e)
{
string Ma_BuoiHoc = txbMa_BuoiHoc.Text;
if (Ma_BuoiHoc == "")
{
return;
}
try
{
BUS_LichHoc busLichHoc = new BUS_LichHoc();
BUS_LopHoc busLopHoc = new BUS_LopHoc();
EC_LichHoc LichHoc = busLichHoc.Select_ByPrimaryKey(Ma_BuoiHoc);
EC_LopHoc LopHoc = busLopHoc.Select_ByPrimaryKey(LichHoc.Ma_LopHoc);
if (LichHoc.TrangThai == true)
{
MessageBox.Show("Buổi học không thể xóa do đã học rồi", "Thông báo");
return;
}
LopHoc.SoBuoi -= 1;
busLopHoc.SuaDuLieu(LopHoc);
busLichHoc.XoaDuLieu_Ma_BuoiHoc(LichHoc.Ma_BuoiHoc);
List <EC_LichHoc> listBuoiHoc = busLichHoc.SelectByFields("Ma_LopHoc", LichHoc.Ma_LopHoc);
int SoBuoi_ChuaHoc = 0;
int TongTien_DaHoc = 0;
foreach (EC_LichHoc ec in listBuoiHoc)
{
if (ec.TrangThai == false)
{
SoBuoi_ChuaHoc++;
}
else
{
TongTien_DaHoc += ec.TongHocPhi_Buoi;
}
}
int TongHocPhi_Buoi = (LopHoc.TongHocPhi_KhoaHoc - TongTien_DaHoc) / SoBuoi_ChuaHoc;
foreach (EC_LichHoc ec in listBuoiHoc)
{
if (ec.TrangThai == false)
{
if (ec.STT_Buoi > LichHoc.STT_Buoi)
{
ec.STT_Buoi -= 1;
}
ec.TongHocPhi_Buoi = TongHocPhi_Buoi;
}
}
foreach (EC_LichHoc ec in listBuoiHoc)
{
busLichHoc.SuaDuLieu(ec);
}
MessageBox.Show("Xóa thành công buổi học", "Thông báo");
}
catch
{
MessageBox.Show("Xóa không thành công buổi học", "Thông báo");
}
LoadForm();
}
public void SuaDuLieu(EC_LichHoc ec)
{
sql.SuaDuLieu(ec);
}
public void ThemDuLieu(EC_LichHoc ec)
{
sql.ThemDuLieu(ec);
}
void LayDuLieu(int SttBuoi)
{
int SoHS_DiHoc = 0;
EC_LichHoc ecLichHoc = new EC_LichHoc();
DanhSachLop = new List <EC_HocSinh>();
dgLopHoc.Rows.Clear();
foreach (EC_LichHoc ec in listBuoiHoc)
{
if (ec.STT_Buoi == (SttBuoi + 1))
{
ecLichHoc = ec;
}
}
if (ecLichHoc == null)
{
return;
}
List <EC_BuoiHoc_HocSinh> listBH_HS = new BUS_BuoiHoc_HocSinh().SelectByFields("Ma_BuoiHoc", ecLichHoc.Ma_BuoiHoc);
if (listBH_HS.Count == 0)
{
return;
}
foreach (EC_BuoiHoc_HocSinh bhhs in listBH_HS)
{
EC_HocSinh hs = new BUS_HocSinh().Select_ByPrimaryKey(bhhs.Ma_HocSinh);
DanhSachLop.Add(hs);
if (bhhs.DiemDanh == true)
{
SoHS_DiHoc++;
}
}
int i = 1;
foreach (EC_HocSinh HocSinh in DanhSachLop)
{
string gioitinh = HocSinh.GioiTinh == true ? "Nam" : "Nữ";
bool DiemDanh = false;
foreach (EC_BuoiHoc_HocSinh bhhs in listBH_HS)
{
if (bhhs.Ma_HocSinh == HocSinh.Ma_HocSinh)
{
DiemDanh = bhhs.DiemDanh;
}
}
dgLopHoc.Rows.Add(i.ToString(), HocSinh.Ten_HocSinh, HocSinh.NgaySinh,
gioitinh, HocSinh.SDT, DiemDanh);
i++;
}
DateTime NgayHoc = ecLichHoc.NgayHoc;
if (NgayHoc.Day == DateTime.Now.Day && NgayHoc.Month == DateTime.Now.Month && NgayHoc.Year == DateTime.Now.Year)
{
btDiemDanh.Visible = true;
}
else
{
btDiemDanh.Visible = false;
}
dateTimePicker1.Value = NgayHoc;
txbKip.Text = ecLichHoc.KipHoc.ToString();
txbSoHocSinh.Text = DanhSachLop.Count.ToString();
int SoHS_Vang = DanhSachLop.Count - SoHS_DiHoc;
txbDiHoc.Text = SoHS_DiHoc.ToString();
txbVang.Text = SoHS_Vang.ToString();
txbTrangThai.Text = ecLichHoc.TrangThai == true ? "Đã học" : "Chưa học";
txbHocPhi_Buoi.Text = ecLichHoc.TongHocPhi_Buoi.ToString();
txbMa_BuoiHoc.Text = ecLichHoc.Ma_BuoiHoc;
}
