//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; }