protected override async Task ExecuteAsync(CancellationToken stoppingToken)
{
try
{
APIhelper.Initialize();
Watch(watchPath);
_logger.LogInformation("conissu being watched");
await Task.Delay(Timeout.Infinite, stoppingToken);
}
catch (Exception e)
{
_logger.LogInformation($"service was stopped error: {e} ");
}
}
private void ReadWriteStream(string path, string fileName)
{
string customerNumber = null;
string cono = null;
string originalPath = path;
string destinationPath = path.Replace(@"\supplypro\", @"\ftpuser\");
var lineCount = File.ReadLines(path).Count();
if (lineCount > 1)
{
using FileStream originalFileStream = new FileStream(path, FileMode.Open, FileAccess.Read);
using StreamReader streamReader = new StreamReader(originalFileStream);
using FileStream destinationFileStream = new FileStream(destinationPath, FileMode.Create, FileAccess.Write);
using StreamWriter streamWriter = new StreamWriter(destinationFileStream);
DataAccess dataAccess = new DataAccess();
oAuth2Client = new OAuth2Client(new Uri(OAuth2TokenEndpoint), ResourceOwnerClientId, ResourceOwnerClientSecret);
TokenResponse token = APIhelper.RequestToken(oAuth2Client, ServiceAccountAccessKey, ServiceAccountSecretKey);
if (!token.IsError)
{
APIhelper.APIclient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", token.AccessToken);
}
try
{
string[] lines = File.ReadAllLines(path);
foreach (string line in lines)
{
string[] col = line.Split('|');
if (col[0] != "" && col[0].ToUpper() != "DEPARTMENT")
{
string[] departmentField = col[0].Split('-');
customerNumber = departmentField[1];
cono = departmentField[3];
break;
}
}
foreach (string line in lines)
{
string[] col = line.Split('|');
bool success = Int32.TryParse(col[17], out int quantity);
if (quantity == 0)
{
continue;
}
if (col[4].ToUpper() == "RETURN")
{
if (success)
{
string[] device = col[34].Split("-");
ReturnItem returnItem = new ReturnItem();
returnItem.CustomerNumber = customerNumber;
returnItem.UserID = col[10];
returnItem.Cono = cono;
returnItem.Whse = device[0];
returnItem.ReplenexNumber = col[24];
returnItem.Qty = quantity;
returnItem.UnitOfIssue = col[38];
returnItem.SupplyProPrice = col[20];
returnItem.ProductName = col[5];
string[] deptSplit = col[0].Split('-');
returnItem.ShipTo = deptSplit[2];
try
{
dataAccess.InsertReturnItem(returnItem);
}
catch (Exception e)
{
_logger.LogError($" failed to write {line} {Environment.NewLine} filename: {fileName} {Environment.NewLine} error: {e}");
}
continue;
}
}
if (col[0] == "")
{
if (col[9] != "REPLENEX ADMIN")
{
if (success)
{
if (quantity < 0)
{
string[] device = col[34].Split("-");
ReturnItem returnItem = new ReturnItem();
returnItem.CustomerNumber = customerNumber;
returnItem.UserID = col[10];
returnItem.Cono = cono;
returnItem.Whse = device[0];
returnItem.ReplenexNumber = col[24];
returnItem.Qty = quantity;
returnItem.UnitOfIssue = col[38];
returnItem.SupplyProPrice = col[20];
returnItem.ProductName = col[5];
if (!token.IsError)
{
Task <Ttblsastaz> ttblsastaz = APIhelper.GetShipTo(token, cono, customerNumber, returnItem.UserID, FetchWhere);
if (ttblsastaz.Result != null)
{
returnItem.ShipTo = ttblsastaz.Result.Codeval[0];
}
}
try
{
dataAccess.InsertReturnItem(returnItem);
}
catch (Exception e)
{
_logger.LogError($" failed to write {line} {Environment.NewLine} filename: {fileName} {Environment.NewLine} error: {e}");
}
continue;
}
}
else
{
_logger.LogError($"Could not parse quantity {col[17]}, from {fileName}. Line {line}");
}
}
}
streamWriter.WriteLine($"{line}");
}
streamReader.Close();
streamWriter.Close();
//archive path
string archivePath = path.Replace(fileName, @"archive\" + fileName);
//move to archive path
while (!IsFileLocked(originalPath))
{
try
{
File.Move(originalPath, archivePath, true);
break;
}
catch (Exception e)
{
_logger.LogError($"Unable to move {fileName} to archive. Error: {e}");
break;
}
}
}
catch (Exception e)
{
//error path
string errorPath = path.Replace(fileName, @"error\" + fileName);
streamReader.Close();
streamWriter.Close();
//move to error path
while (!IsFileLocked(originalPath))
{
File.Move(path, errorPath);
_logger.LogError($"{fileName} was moved to Error folder. Error: {e}");
break;
}
}
finally
{
destinationFileStream.Close();
originalFileStream.Close();
}
}
else
{
File.Delete(path);
}
}
