static void Main(string[] args)
{
_log = log4net.LogManager.GetLogger(typeof(Program));
//onetime stuff
RadarHttpClient.DefaultRequestHeaders.Accept.Clear();
RadarHttpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
//get directory from config
//TODO: change this to read from config
//NOTES:
//file name is batch ID - use to retreive batch to assign details.
// also use to determine company ID of sheet.
var curDir = Directory.GetCurrentDirectory();
_log.InfoFormat("running in {0}", curDir);
var xlsxFiles = Directory.GetFiles(curDir, "*.xlsx");
if (!xlsxFiles.Any())
{
_log.InfoFormat("No xlsx files found in {0}", curDir);
}
else
{
//go get column positions from DB.
_prodTask = new UowPRODTask();
_mapping = _prodTask.Template.GetAllWithInclude(t => t.TemplateMapping)
.Where(t => t.AuditStatusCode == Radar.Core.Common.Constants.StatusCode.Audit.ACTIVE)
.Select(t => t);
foreach (var xlsxFile in xlsxFiles)
{
processFile(xlsxFile);
}
}
// import only supports XLSX files... right?
Console.Write("Press <enter> key to exit");
Console.ReadLine();
}
static void Main(string[] args)
{
_log = log4net.LogManager.GetLogger(typeof(Program));
//onetime stuff
RadarHttpClient.DefaultRequestHeaders.Accept.Clear();
RadarHttpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
//get directory from config
//TODO: change this to read from config
//NOTES:
//file name is batch ID - use to retreive batch to assign details.
// also use to determine company ID of sheet.
var curDir = Directory.GetCurrentDirectory();
_log.InfoFormat("running in {0}", curDir);
var xlsxFiles = Directory.GetFiles(curDir, "*.xlsx");
if (!xlsxFiles.Any())
{
_log.InfoFormat("No xlsx files found in {0}", curDir);
}
else
{
//go get column positions from DB.
_prodTask = new UowPRODTask();
_mapping = _prodTask.Template.GetAllWithInclude(t => t.TemplateMapping)
.Where(t => t.AuditStatusCode == Radar.Core.Common.Constants.StatusCode.Audit.ACTIVE)
.Select(t => t);
foreach (var xlsxFile in xlsxFiles)
{
processFile(xlsxFile);
}
}
// import only supports XLSX files... right?
Console.Write("Press <enter> key to exit");
Console.ReadLine();
}
