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