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");
}
}
