protected override void OnStart(string[] args)
{
string serverFolder = ConfigurationManager.AppSettings["CSVUploadFolder"];
string doneFolder = ConfigurationManager.AppSettings["DoneFolder"];
string notDoneFolder = ConfigurationManager.AppSettings["NotDoneFolder"];
_csvWorker = new CsvWorker(serverFolder, doneFolder, notDoneFolder);
_csvWorker.RunWatch();
}
public void ImportResources(string path)
{
_resContext.Resources.RemoveRange(Resources);
_resContext.SaveChanges();
List <Resource> resources = new List <Resource>();
CsvWorker.ImportResources(path, resources);
_resContext.Resources.AddRange(resources);
_resContext.SaveChanges();
}
public void ImportFiles(string path)
{
_fileContext.Files.RemoveRange(Files);
_fileContext.SaveChanges();
List <File> files = new List <File>();
CsvWorker.ImportFiles(path, files);
_fileContext.Files.AddRange(files);
_fileContext.SaveChanges();
}
static void Main(string[] args)
{
string serverFolder = ConfigurationManager.AppSettings["CSVUploadFolder"];
string doneFolder = ConfigurationManager.AppSettings["DoneFolder"];
string notDoneFolder = ConfigurationManager.AppSettings["NotDoneFolder"];
CsvWorker csvWorker = new CsvWorker(serverFolder, doneFolder, notDoneFolder);
csvWorker.RunWatch();
Console.WriteLine(@"Press 'q' to exit");
while (Console.Read() != 'q')
{
}
}
public List <CsvWorker> GetCsvWorkers(string csvFilePath)
{
List <CsvWorker> csvWorkers = new List <CsvWorker>();
using (var reader = new StreamReader(csvFilePath, true))
{
using (var csv = new CsvReader(reader))
{
var CswInitialWorkers = csv.GetRecords <CsvInitialWorker>();
foreach (var cswInitialWorker in CswInitialWorkers)
{
cswInitialWorker.officePhone = cswInitialWorker.officePhone.Trim();
if (string.IsNullOrEmpty(cswInitialWorker.officePhone))
{
continue;
}
List <string> phoneNumbers = cswInitialWorker.officePhone.Split(',').ToList();
for (int i = 0; i < phoneNumbers.Count(); i++)
{
phoneNumbers[i] = phoneNumbers[i].Trim();
if (string.IsNullOrEmpty(phoneNumbers[i]))
{
continue;
}
var cswWorker = new CsvWorker
{
Department = cswInitialWorker.department,
GivenName = cswInitialWorker.givenName,
DisplayName = cswInitialWorker.displayName,
Mail = cswInitialWorker.mail,
Office = cswInitialWorker.office,
OfficePhone = phoneNumbers[i],
Sn = cswInitialWorker.sn,
Title = cswInitialWorker.title
};
csvWorkers.Add(cswWorker);
}
}
}
}
return(csvWorkers);
}
public FileImporter(AcumaticaWorker acWorker, CsvWorker csvWorker)
{
_acWorker = acWorker;
_csvWorker = csvWorker;
}
public void ExportResources(string path)
{
CsvWorker.ExportResources(path, Resources);
}
public void ExportFiles(string path)
{
CsvWorker.ExportFiles(path, Files);
}
