private void ImportOptionsData(DataTable optionsData)
{
var validColumnNames = new[] { "SBD", "NV1.N", "NV1.TH", "NV2.N", "NV2.TH",
"NV3.N", "NV3.TH", "NV4.N", "NV4.TH"};
var columnNames = from column in optionsData.Columns.Cast<DataColumn>()
select column.ColumnName;
ValidateColumnNames(columnNames, validColumnNames);
var entities = new Entities();
entities.Configuration.AutoDetectChangesEnabled = false;
int id = 0;
foreach (DataRow dataRow in optionsData.Rows)
{
var option = OptionFromDataRow(dataRow);
entities.Options.Add(option);
id++;
if (id % 777 == 776)
{
entities.SaveChanges();
entities.Dispose();
entities = new Entities();
entities.Configuration.AutoDetectChangesEnabled = false;
}
}
entities.SaveChanges();
entities.Dispose();
}
private void ImportCandidatesData(DataTable candidatesData)
{
var validColumnNames = new[] { "SBD", "HoTen", "NgaySinh", "KV", "DT", "UT",
"Toan", "Van", "Ly", "Hoa", "Sinh", "Su", "Dia", "Anh", "Nga", "Phap", "Trung", "Duc", "Nhat" };
var columnNames = from column in candidatesData.Columns.Cast<DataColumn>()
select column.ColumnName;
ValidateColumnNames(columnNames, validColumnNames);
var validSubjectNames = new[] { "Toán", "Văn", "Lý", "Hóa", "Sinh", "Sử", "Địa",
"Anh", "Nga", "Pháp", "Trung", "Đức", "Nhật" };
ValidateSubjectNames(validSubjectNames);
var entities = new Entities();
entities.Configuration.AutoDetectChangesEnabled = false;
int id = 0;
foreach (DataRow dataRow in candidatesData.Rows)
{
var candidate = CandidateFromData(dataRow);
entities.Candidates.Add(candidate);
id++;
for (int i = 0; i < 13; i++)
{
int subjectID = i + 1;
var markString = (string)dataRow[6 + i];
if (markString == "NA")
continue;
var mark = MarkFromData(id, subjectID, markString);
entities.Marks.Add(mark);
}
if (id % 777 == 776)
{
entities.SaveChanges();
entities.Dispose();
entities = new Entities();
entities.Configuration.AutoDetectChangesEnabled = false;
}
}
entities.SaveChanges();
entities.Dispose();
}