public static void Insert(LopMonDTO lopMonDTO) { OleDbConnection connection = DataProvider.CreateConnection(); string cmdText = "Insert into LopMON(MaLop, MaMon) values(?,?)"; OleDbCommand command = new OleDbCommand(cmdText, connection); command.Parameters.Add("@MaLop", OleDbType.Numeric); command.Parameters.Add("@MaMon", OleDbType.Numeric); command.Parameters["@MaLop"].Value = lopMonDTO.MaLop; command.Parameters["@MaMon"].Value = lopMonDTO.MaMon; command.ExecuteNonQuery(); command.CommandText = "select @@IDENTITY"; lopMonDTO.MaLopMon = (int)command.ExecuteScalar(); connection.Close(); }
public static void UpdateRecord(LopMonDTO lopMonDTO) { OleDbConnection connection = DataProvider.CreateConnection(); string cmdText = "Update LOPMON Set [MaLop] = ?, [MaMon] = ? Where [MaLopMon] = ?"; OleDbCommand command = new OleDbCommand(cmdText, connection); command.Parameters.Add("@MaLop", OleDbType.Integer); command.Parameters.Add("@MaMon", OleDbType.Integer); command.Parameters.Add("@MaLopMon", OleDbType.Integer); command.Parameters["@MaLop"].Value = lopMonDTO.MaLop; command.Parameters["@MaMon"].Value = lopMonDTO.MaMon; command.Parameters["@MaLopMon"].Value = lopMonDTO.MaLopMon; command.ExecuteNonQuery(); connection.Close(); }
public static IList GetList() { ArrayList arrList = new ArrayList(); LopMonDTO lopMonDTO = null; OleDbConnection connection = DataProvider.CreateConnection(); string cmdText = "Select * from LOPMON"; OleDbCommand command = new OleDbCommand(cmdText, connection); OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { lopMonDTO = new LopMonDTO(); lopMonDTO.MaLopMon = (int)reader["MaLopMon"]; lopMonDTO.MaLop = (int)reader["MaLop"]; lopMonDTO.MaMon = (int)reader["MaMon"]; arrList.Add(lopMonDTO); } reader.Close(); connection.Close(); return(arrList); }
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); } }
public static void UpdateRecord(LopMonDTO lopMonDTO) { LopMonDAO.UpdateRecord(lopMonDTO); }
public static void Insert(LopMonDTO lopMonDTO) { LopMonDAO.Insert(lopMonDTO); }