public void ImportFromExcelFile(string path) { var excelRepository = new ExcelRepository(); var data = excelRepository.GetAllDataFrom(path, "CID.xls", "CID10"); var list = new List<CID>(); foreach (DataRow row in data.Rows) { var cid = new CID(); foreach (DataColumn column in data.Columns) { switch (column.Caption) { case "CODIGO": cid.Code = (string)row[column]; break; case "DESCRICAO": cid.Description = (string)row[column]; break; case "DESCRABREV": cid.AbbreviatedDescription = (string)row[column]; break; } } list.Add(cid); } var cids = new CIDRepository(); cids.SaveList(list); }
public void UpdateIndex() { var repository = new CIDRepository(); var cids = repository.All<CID>().ToList(); var service = new SaveCidInLuceneService(ConfigurationManager.AppSettings["CIDIndexPath"]); service.Save(cids); }