public static void Insert(ChiTietMonDTO chiTietMonDTO)
{
OleDbConnection connection = DataProvider.CreateConnection();
string cmdText = "Insert into CHITIETMON(MaLopMon, MaNamHoc, ThoiGianHoc, GioHoc, GiangDuong, GiangVien, NgayThiLan1, GioThiLan1, GiangDuongThiLan1, CanBoCoiThiLan1, SoBaiThiLan1, NgayThiLan2, GioThiLan2, GiangDuongThiLan2, CanBoCoiThiLan2, SoBaiThiLan2, GhiChu) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
OleDbCommand command = new OleDbCommand(cmdText, connection);
command.Parameters.Add("@MaLopMon", OleDbType.Numeric);
command.Parameters.Add("@MaNamHoc", OleDbType.Numeric);
command.Parameters.Add("@ThoiGianHoc", OleDbType.WChar);
command.Parameters.Add("@GioHoc", OleDbType.WChar);
command.Parameters.Add("@GiangDuong", OleDbType.WChar);
command.Parameters.Add("@GiangVien", OleDbType.WChar);
command.Parameters.Add("@NgayThiLan1", OleDbType.WChar);
command.Parameters.Add("@GioThiLan1", OleDbType.WChar);
command.Parameters.Add("@GiangDuongThiLan1", OleDbType.WChar);
command.Parameters.Add("@CanBoCoiThiLan1", OleDbType.WChar);
command.Parameters.Add("@SoBaiThiLan1", OleDbType.Numeric);
command.Parameters.Add("@NgayThiLan2", OleDbType.WChar);
command.Parameters.Add("@GioThiLan2", OleDbType.WChar);
command.Parameters.Add("@GiangDuongThiLan2", OleDbType.WChar);
command.Parameters.Add("@CanBoCoiThiLan2", OleDbType.WChar);
command.Parameters.Add("@SoBaiThiLan2", OleDbType.Numeric);
command.Parameters.Add("@GhiChu", OleDbType.WChar);
command.Parameters.Add("@MaChiTietMon", OleDbType.Numeric);
command.Parameters["@MaLopMon"].Value = chiTietMonDTO.MaLopMon;
command.Parameters["@MaNamHoc"].Value = chiTietMonDTO.MaNamHoc;
command.Parameters["@ThoiGianHoc"].Value = chiTietMonDTO.ThoiGianHoc;
command.Parameters["@GioHoc"].Value = chiTietMonDTO.GioHoc;
command.Parameters["@GiangDuong"].Value = chiTietMonDTO.GiangDuong;
command.Parameters["@GiangVien"].Value = chiTietMonDTO.GiangVien;
command.Parameters["@NgayThiLan1"].Value = chiTietMonDTO.NgayThiLan1;
command.Parameters["@GioThiLan1"].Value = chiTietMonDTO.GioThiLan1;
command.Parameters["@GiangDuongThiLan1"].Value = chiTietMonDTO.GiangDuongThiLan1;
command.Parameters["@CanBoCoiThiLan1"].Value = chiTietMonDTO.CanBoCoiThiLan1;
command.Parameters["@SoBaiThiLan1"].Value = chiTietMonDTO.SoBaiThiLan1;
command.Parameters["@NgayThiLan2"].Value = chiTietMonDTO.NgayThiLan2;
command.Parameters["@GioThiLan2"].Value = chiTietMonDTO.GioThiLan2;
command.Parameters["@GiangDuongThiLan2"].Value = chiTietMonDTO.GiangDuongThiLan2;
command.Parameters["@CanBoCoiThiLan2"].Value = chiTietMonDTO.CanBoCoiThiLan2;
command.Parameters["@SoBaiThiLan2"].Value = chiTietMonDTO.SoBaiThiLan2;
command.Parameters["@GhiChu"].Value = chiTietMonDTO.GhiChu;
command.Parameters["@MaChiTietMon"].Value = chiTietMonDTO.MaChiTietMon;
command.ExecuteNonQuery();
command.CommandText = "select @@IDENTITY";
chiTietMonDTO.MaChiTietMon = (int)command.ExecuteScalar();
connection.Close();
}
public static void UpdateCanBoCoiThiLan2(ChiTietMonDTO chiTietMonDTO)
{
OleDbConnection connection = DataProvider.CreateConnection();
string cmdText = "Update CHITIETMON Set [CanBoCoiThiLan2] = ? Where [MaChiTietMon] = ?";
OleDbCommand command = new OleDbCommand(cmdText, connection);
command.Parameters.Add("@CanBoCoiThiLan2", OleDbType.WChar);
command.Parameters.Add("@MaChiTietMon", OleDbType.Numeric);
command.Parameters["@CanBoCoiThiLan2"].Value = chiTietMonDTO.CanBoCoiThiLan2;
command.Parameters["@MaChiTietMon"].Value = chiTietMonDTO.MaChiTietMon;
command.ExecuteNonQuery();
connection.Close();
}
public static void UpdateRecord(ChiTietMonDTO chiTietMonDTO)
{
OleDbConnection connection = DataProvider.CreateConnection();
string cmdText = "Update CHITIETMON Set [MaNamHoc] = ?, [ThoiGianHoc] = ?, [GioHoc] = ?, [GiangDuong] = ?, [NgayThiLan1] = ?, [GioThiLan1] = ?, [GiangDuongThiLan1] = ?, [SoBaiThiLan1] = ?, [NgayThiLan2] = ?, [GioThiLan2] = ?, [GiangDuongThiLan2] = ?, [SoBaiThiLan2] = ?, [GhiChu] = ? Where [MaChiTietMon] = ?";
OleDbCommand command = new OleDbCommand(cmdText, connection);
command.Parameters.Add("@MaNamHoc", OleDbType.Integer);
command.Parameters.Add("@ThoiGianHoc", OleDbType.WChar);
command.Parameters.Add("@GioHoc", OleDbType.WChar);
command.Parameters.Add("@GiangDuong", OleDbType.WChar);
//command.Parameters.Add("@GiangVien", OleDbType.WChar);
command.Parameters.Add("@NgayThiLan1", OleDbType.WChar);
command.Parameters.Add("@GioThiLan1", OleDbType.WChar);
command.Parameters.Add("@GiangDuongThiLan1", OleDbType.WChar);
//command.Parameters.Add("@CanBoCoiThiLan1", OleDbType.WChar);
command.Parameters.Add("@SoBaiThiLan1", OleDbType.Numeric);
command.Parameters.Add("@NgayThiLan2", OleDbType.WChar);
command.Parameters.Add("@GioThiLan2", OleDbType.WChar);
command.Parameters.Add("@GiangDuongThiLan2", OleDbType.WChar);
//command.Parameters.Add("@CanBoCoiThiLan2", OleDbType.WChar);
command.Parameters.Add("@SoBaiThiLan2", OleDbType.Numeric);
command.Parameters.Add("@GhiChu", OleDbType.WChar);
command.Parameters.Add("@MaChiTietMon", OleDbType.Numeric);
command.Parameters["@MaNamHoc"].Value = chiTietMonDTO.MaNamHoc;
command.Parameters["@ThoiGianHoc"].Value = chiTietMonDTO.ThoiGianHoc;
command.Parameters["@GioHoc"].Value = chiTietMonDTO.GioHoc;
command.Parameters["@GiangDuong"].Value = chiTietMonDTO.GiangDuong;
//command.Parameters["@GiangVien"].Value = chiTietMonDTO.GiangVien;
command.Parameters["@NgayThiLan1"].Value = chiTietMonDTO.NgayThiLan1;
command.Parameters["@GioThiLan1"].Value = chiTietMonDTO.GioThiLan1;
command.Parameters["@GiangDuongThiLan1"].Value = chiTietMonDTO.GiangDuongThiLan1;
//command.Parameters["@CanBoCoiThiLan1"].Value = chiTietMonDTO.CanBoCoiThiLan1;
command.Parameters["@SoBaiThiLan1"].Value = chiTietMonDTO.SoBaiThiLan1;
command.Parameters["@NgayThiLan2"].Value = chiTietMonDTO.NgayThiLan2;
command.Parameters["@GioThiLan2"].Value = chiTietMonDTO.GioThiLan2;
command.Parameters["@GiangDuongThiLan2"].Value = chiTietMonDTO.GiangDuongThiLan2;
//command.Parameters["@CanBoCoiThiLan2"].Value = chiTietMonDTO.CanBoCoiThiLan2;
command.Parameters["@SoBaiThiLan2"].Value = chiTietMonDTO.SoBaiThiLan2;
command.Parameters["@GhiChu"].Value = chiTietMonDTO.GhiChu;
command.Parameters["@MaChiTietMon"].Value = chiTietMonDTO.MaChiTietMon;
command.ExecuteNonQuery();
connection.Close();
}
private void btnCapNhatChiTietMon_Click(object sender, EventArgs e)
{
try
{
DialogResult result = MessageBox.Show("Bạn có chắc muốn cập nhật chi tiết môn học cho lớp này không?",
"Question",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button1);
if (result == DialogResult.Yes)
{
foreach (DataGridViewRow row in dtgvChiTietMon.Rows)
{
ChiTietMonDTO chiTietMonDTO = new ChiTietMonDTO();
chiTietMonDTO.MaChiTietMon = Int32.Parse(row.Cells["MaChiTietMon"].Value.ToString());
chiTietMonDTO.ThoiGianHoc = row.Cells["ThoiGianHoc"].Value.ToString();
chiTietMonDTO.GioHoc = row.Cells["GioHoc"].Value.ToString();
chiTietMonDTO.GiangDuong = row.Cells["GiangDuong"].Value.ToString();
//chiTietMonDTO.GiangVien = row.Cells["GiangVien"].Value.ToString();
chiTietMonDTO.NgayThiLan1 = row.Cells["NgayThiLan1"].Value.ToString();
chiTietMonDTO.GioThiLan1 = row.Cells["GioThiLan1"].Value.ToString();
chiTietMonDTO.GiangDuongThiLan1 = row.Cells["GiangDuongThiLan1"].Value.ToString();
chiTietMonDTO.CanBoCoiThiLan1 = row.Cells["CanBoCoiThiLan1"].Value.ToString();
chiTietMonDTO.SoBaiThiLan1 = Int32.Parse(row.Cells["SoBaiThiLan1"].Value.ToString());
chiTietMonDTO.NgayThiLan2 = row.Cells["NgayThiLan2"].Value.ToString();
chiTietMonDTO.GioThiLan2 = row.Cells["GioThiLan2"].Value.ToString();
chiTietMonDTO.GiangDuongThiLan2 = row.Cells["GiangDuongThiLan2"].Value.ToString();
chiTietMonDTO.CanBoCoiThiLan2 = row.Cells["CanBoCoiThiLan2"].Value.ToString();
chiTietMonDTO.SoBaiThiLan2 = Int32.Parse(row.Cells["SoBaiThiLan2"].Value.ToString());
chiTietMonDTO.GhiChu = row.Cells["GhiChu"].Value.ToString();
ChiTietMonBUS.UpdateRecord(chiTietMonDTO);
}
MessageBox.Show("Cập nhật chi tiết môn thành công");
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static ChiTietMonDTO TimTheoMaChiTietMon(int maCTM)
{
ArrayList arrList = new ArrayList();
ChiTietMonDTO chiTietMon = new ChiTietMonDTO();
OleDbConnection connection = DataProvider.CreateConnection();
string cmdText = "Select * from CHITIETMON where MaChiTietMon = ?";
OleDbCommand command = new OleDbCommand(cmdText, connection);
command.Parameters.Add("@MaChiTietMon", OleDbType.Integer);
command.Parameters["@MaChiTietMon"].Value = maCTM;
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
chiTietMon.MaChiTietMon = (int)reader["MaChiTietMon"];
chiTietMon.MaLopMon = (int)reader["MaLopMon"];
chiTietMon.MaNamHoc = (int)reader["MaNamHoc"];
chiTietMon.ThoiGianHoc = (string)reader["ThoiGianHoc"];
chiTietMon.GioHoc = (string)reader["GioHoc"];
chiTietMon.GiangDuong = (string)reader["GiangDuong"];
chiTietMon.GiangVien = (string)reader["GiangVien"];
chiTietMon.NgayThiLan1 = (string)reader["NgayThiLan1"];
chiTietMon.GioThiLan1 = (string)reader["GioThiLan1"];
chiTietMon.GiangDuongThiLan1 = (string)reader["GiangDuongThiLan1"];
chiTietMon.CanBoCoiThiLan1 = (string)reader["CanBoCoiThiLan1"];
chiTietMon.SoBaiThiLan1 = (int)reader["SoBaiThiLan1"];
chiTietMon.NgayThiLan2 = (string)reader["NgayThiLan2"];
chiTietMon.GioThiLan2 = (string)reader["GioThiLan2"];
chiTietMon.GiangDuongThiLan2 = (string)reader["GiangDuongThiLan2"];
chiTietMon.CanBoCoiThiLan2 = (string)reader["CanBoCoiThiLan2"];
chiTietMon.SoBaiThiLan2 = (int)reader["SoBaiThiLan2"];
chiTietMon.GhiChu = (string)reader["GhiChu"];
arrList.Add(chiTietMon);
}
reader.Close();
connection.Close();
return(chiTietMon);
}
public static IList GetList()
{
ArrayList arrList = new ArrayList();
ChiTietMonDTO chiTietMon = null;
OleDbConnection connection = DataProvider.CreateConnection();
string cmdText = "Select * from CHITIETMON";
OleDbCommand command = new OleDbCommand(cmdText, connection);
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
chiTietMon = new ChiTietMonDTO();
chiTietMon.MaChiTietMon = (int)reader["MaChiTietMon"];
chiTietMon.MaLopMon = (int)reader["MaLopMon"];
chiTietMon.MaNamHoc = (int)reader["MaNamHoc"];
chiTietMon.ThoiGianHoc = (string)reader["ThoiGianHoc"];
chiTietMon.GioHoc = (string)reader["GioHoc"];
chiTietMon.GiangDuong = (string)reader["GiangDuong"];
chiTietMon.GiangVien = (string)reader["GiangVien"];
chiTietMon.NgayThiLan1 = (string)reader["NgayThiLan1"];
chiTietMon.GioThiLan1 = (string)reader["GioThiLan1"];
chiTietMon.GiangDuongThiLan1 = (string)reader["GiangDuongThiLan1"];
chiTietMon.CanBoCoiThiLan1 = (string)reader["CanBoCoiThiLan1"];
chiTietMon.SoBaiThiLan1 = (int)reader["SoBaiThiLan1"];
chiTietMon.NgayThiLan2 = (string)reader["NgayThiLan2"];
chiTietMon.GioThiLan2 = (string)reader["GioThiLan2"];
chiTietMon.GiangDuongThiLan2 = (string)reader["GiangDuongThiLan2"];
chiTietMon.CanBoCoiThiLan2 = (string)reader["CanBoCoiThiLan2"];
chiTietMon.SoBaiThiLan2 = (int)reader["SoBaiThiLan2"];
chiTietMon.GhiChu = (string)reader["GhiChu"];
arrList.Add(chiTietMon);
}
reader.Close();
connection.Close();
return(arrList);
}
public static void UpdateCanBoCoiThiLan2(ChiTietMonDTO chiTietMonDTO)
{
ChiTietMonDAO.UpdateCanBoCoiThiLan2(chiTietMonDTO);
}
public static void UpdateGiangVien(ChiTietMonDTO chiTietMonDTO)
{
ChiTietMonDAO.UpdateGiangVien(chiTietMonDTO);
}
public static void UpdateRecord(ChiTietMonDTO chiTietMonDTO)
{
ChiTietMonDAO.UpdateRecord(chiTietMonDTO);
}
public static void Insert(ChiTietMonDTO chiTietMonDTO)
{
ChiTietMonDAO.Insert(chiTietMonDTO);
}
private void btnThemLop_Click(object sender, EventArgs e)
{
try
{
if (txtTenLop.Text == "")
{
MessageBox.Show("Phải nhập tên lớp");
return;
}
if (countSelectedRow() == 0)
{
MessageBox.Show("Phải chọn ít nhất 1 môn học");
return;
}
DialogResult result = MessageBox.Show("Bạn có chắc muốn thêm lớp này không?",
"Question",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button1);
if (result == DialogResult.Yes)
{
lopDTO.TenLop = txtTenLop.Text;
if (txtSoLuongSinhVien.Text == "")
{
lopDTO.SoLuongSinhVien = 0;
}
else
{
lopDTO.SoLuongSinhVien = Int32.Parse(txtSoLuongSinhVien.Text);
}
if (txtSoLuongTrongNganSach.Text == "")
{
lopDTO.SoLuongTrongNganSach = 0;
}
else
{
lopDTO.SoLuongTrongNganSach = Int32.Parse(txtSoLuongTrongNganSach.Text);
}
if (txtSoLuongNgoaiNganSach.Text == "")
{
lopDTO.SoLuongNgoaiNganSach = 0;
}
else
{
lopDTO.SoLuongNgoaiNganSach = Int32.Parse(txtSoLuongNgoaiNganSach.Text);
}
//lopDTO.MaNamHoc = (cmbNamHoc.SelectedItem as NamHocDTO).MaNamHoc;
LopBUS.Insert(lopDTO);
foreach (DataGridViewRow row in dtgvDSMon.Rows)
{
if (row.Cells[0].Value != null)
{
LopMonDTO lopMonDTO = new LopMonDTO();
lopMonDTO.MaLop = lopDTO.MaLop;
lopMonDTO.MaMon = Int32.Parse(row.Cells["MaMon"].Value.ToString());
LopMonBUS.Insert(lopMonDTO);
ChiTietMonDTO chiTietMonDTO = new ChiTietMonDTO();
chiTietMonDTO.MaLopMon = lopMonDTO.MaLopMon;
ChiTietMonBUS.Insert(chiTietMonDTO);
}
}
MessageBox.Show("Thêm lớp thành công");
LayDanhSachChiTietMon();
btnCapNhatChiTietMon.Visible = true;
dtgvChiTietMon.Visible = true;
btnThemLop.Enabled = false;
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
