public void CreateItem(MonHocMo monHocMo) { try { if (connection.State != ConnectionState.Open) { connection.Open(); } OleDbCommand command = new OleDbCommand( "INSERT INTO MON_HOC_MO (DsMonHocMo, MonHoc) VALUES (@mads, @monhoc)", connection); command.Parameters.Add("@mads", OleDbType.Numeric).Value = monHocMo.DsMonHocMo; command.Parameters.Add("@monhoc", OleDbType.Numeric).Value = monHocMo.MonHoc; command.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { connection.Close(); } }
private void XacNhanLuuDsMonHocMo() { string errorString = ""; if (dsMonHocMo.HocKy == 0) { errorString = "\nHọc Kỳ không hợp lệ"; MessageBox.Show(errorString, "ERROR"); return; } List <MonHocMo> monHocMos = new List <MonHocMo>(); foreach (DataRow row in DanhMucMonHocMo.Rows) { MonHocMo monHocMo = new MonHocMo(); int number; if (!int.TryParse(row["MonHoc"].ToString(), out number)) { continue; } monHocMo.MonHoc = number; monHocMos.Add(monHocMo); } errorString = CheckThongTinDsMonHocMo(monHocMos); if (errorString == "") { MonHocMoDAL monHocMoDAL = new MonHocMoDAL(dbConnection); monHocMoDAL.DeleteItemsByDs(dsMonHocMo.MaDsMonHocMo); foreach (MonHocMo monHocMo in monHocMos) { monHocMoDAL.CreateItem(monHocMo); } MessageBox.Show("Lưu Danh sách Môn Học Mở thành công"); } else { MessageBox.Show(errorString, "ERROR"); } }