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