private static void HandleExcelTable(VoterRegisterFile voterRegisterFile, DataSet dataSet)
{
GetListOfIdentityNumbersFromTableRows(dataSet, voterRegisterFile);
}
private VoterRegisterFile handleUploadedFile(HttpPostedFileBase file)
{
var voterRegisterFile = new VoterRegisterFile
{
Voters = new List<Voter>()
};
var myStream = file.InputStream;
var excelReader = ExcelReaderFactory.CreateOpenXmlReader(myStream);
excelReader.IsFirstRowAsColumnNames = true;
var result = excelReader.AsDataSet();
HandleExcelTable(voterRegisterFile, result);
excelReader.Close();
return voterRegisterFile;
}
private static void GetListOfIdentityNumbersFromTableRows(DataSet dataSet, VoterRegisterFile voterRegisterFile)
{
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
var voter = new Voter
{
IdentityNumber = dataSet.Tables[0].Rows[i].ItemArray[0].ToString()
};
voterRegisterFile.Voters.Add(voter);
}
}
