public PostToInforPostProcessor(IntegrationJob integrationJob, IUnitOfWorkFactory unitOfWorkFactory, IIntegrationJobSchedulingService integrationJobSchedulingService, OutstandingInvoiceService OutstandingInvoiceService)
{
this.UnitOfWork = unitOfWorkFactory.GetUnitOfWork();
this.IntegrationJobSchedulingService = integrationJobSchedulingService;
this.IntegrationJob = integrationJob;
this.outstandingInvoiceService = OutstandingInvoiceService;
}
public SmartSupplyModifiedOrdersPostProcessor(IntegrationJob integrationJob, IUnitOfWorkFactory unitOfWorkFactory, IIntegrationJobSchedulingService integrationJobSchedulingService, IEmailService emailService, ICurrencyFormatProvider currencyFormatProvider, IOrderLineUtilities OrderLineUtilities)
{
this.UnitOfWork = unitOfWorkFactory.GetUnitOfWork();
this.IntegrationJobSchedulingService = integrationJobSchedulingService;
this.EmailService = emailService;
this.IntegrationJob = integrationJob;
this.CurrencyFormatProvider = currencyFormatProvider;
this.OrderLineUtilities = OrderLineUtilities;
}
private bool InsertIntegrationJob(IntegrationJob profile)
{
if (profile.Id == 0)
{
Repository.Add(profile);
}
else
{
Repository.Update(profile);
}
return(Repository.Save());
}
protected override JobHandle OnUpdate(JobHandle inputDeps)
{
//inputDeps = JobHandle.CombineDependencies(inputDeps, iterationSystem.inputDeps);
var jobHandle = new IntegrationJob()
{
data = data,
dt = Time.deltaTime, //* SimulationBootstrap.SimulationSettings.SimulationSpeed
oldDt = oldDt
}.Schedule(data.Length, 16, inputDeps);
oldDt = Time.deltaTime;
return(jobHandle);
}
void Update()
{
integrationHandle.Complete();
if (Input.GetKeyDown(KeyCode.S))
{
AddPhysicsObject(1);
}
integrationJob = new IntegrationJob()
{
};
integrationHandle = integrationJob.Schedule(transforms);
}
public void LookupInsert(XSSFWorkbook hssfwb, FileDetails file)
{
success = 0;
failed = 0;
error = 0;
proccessed = 0;
//insert the integration data
IntegrationJob integration = new IntegrationJob();
integration.StatusId = (int)IntegrationStatusEnum.Queue;
integration.ProfileId = Repository.FindBy <ImportProfile>(p => p.Name.Contains("Default Lookup Profile")).Select(p => p.Id).SingleOrDefault();
integration.Name = "Import Job Created At " + DateTime.Now;
integration.Description = GetDescription(integration);
integration.CreatedBy = file.CreatedBy;
integration.CreatedDate = file.CreatedDate;
//job in queue
InsertIntegrationJob(integration);
List <LookupTables> sheetNames = GetSheetNames();
ISheet sheet = hssfwb.GetSheetAt(0);
if (sheet.SheetName.ToLower() == "metadata")
{
for (int sheetCount = 1; sheetCount <= sheet.LastRowNum; sheetCount++)
{
if (sheet.GetRow(sheetCount) != null)
{
string sheetName = sheet.GetRow(sheetCount).GetCell(0).ToString();
if (sheet.GetRow(sheetCount).GetCell(1).ToString() == "Yes")
{
ISheet tableSheet = hssfwb.GetSheet(sheetName);
//check if meta data sheet is present in workbook or not
if (tableSheet != null)
{
proccessed++;
integration.Processed = proccessed;
//check if lookup present in database or not
if (sheetNames.Any(t => t.TableName.ToLower() == sheetName.ToLower()))
{
var tableDetails = sheetNames.Where(t => t.TableName.ToLower() == sheetName.ToLower()).FirstOrDefault();
var uniqueCol = tableDetails.Columns.Where(u => u.Unique).Select(u => u.ColumnName).SingleOrDefault();
for (int row = 0; row <= tableSheet.LastRowNum; row++)
{
if (tableSheet.GetRow(row) != null)
{
//To get the header row
if (row == 0)
{
columnModel = import.GetHeader(tableDetails.Columns, tableSheet.GetRow(row), uniqueCol);
//check unique column and match column with the database table
if (!string.IsNullOrEmpty(import.errorMessge))
{
failed++;
integration.StatusId = (int)IntegrationStatusEnum.Running;
integration.Failed = failed;
integration.Description = GetDescription(integration);
integration.ModifiedDate = DateTime.Now;
InsertIntegrationJob(integration);
// to insert the errors in job details
job.MessageTypeId = (int)EnumMessageType.Error;
job.SheetName = sheetName;
job.ErrorMessage = import.errorMessge;
job.IntegrationId = integration.Id;
job.RowNumber = row.ToString();
InsertJobDetails(job);
break;
}
}
else
{
rowDetails = new List <ColumnModel>();
rowDetails = import.GetRow(columnModel, tableSheet.GetRow(row));
string query = string.Empty;
//if record exists then update else insert
if (import.Exists(rowDetails, tableDetails))
{
query = import.UpdateQuery(rowDetails, tableDetails);
}
else
{
query = import.InsertQuery(rowDetails, tableDetails);
}
try
{
// to insert the lookup data
var result = Repository.Context.Database.ExecuteSqlCommand(query, new SqlParameter("@tableName", tableDetails.TableName));
integration.StatusId = (int)IntegrationStatusEnum.Running;
integration.Success = success;
integration.Description = GetDescription(integration);
integration.ModifiedDate = DateTime.Now;
}
catch (Exception ex)
{
failed++;
job = new JobDetails();
integration.StatusId = (int)IntegrationStatusEnum.Error;
integration.Failed = failed;
integration.Description = GetDescription(integration);
integration.ModifiedDate = DateTime.Now;
// to insert the errors in job details
job.MessageTypeId = (int)EnumMessageType.Error;
job.SheetName = sheetName;
job.ErrorMessage = ex.Message;
job.IntegrationId = integration.Id;
job.RowNumber = sheetCount.ToString();
InsertJobDetails(job);
}
InsertIntegrationJob(integration);
}
}
}
if (failed == 0)
{
integration.Success = (success + 1);
}
InsertIntegrationJob(integration);
}
else
{
integration.StatusId = (int)IntegrationStatusEnum.Error;
integration.Description = "Lookup " + sheetName + " is not present in the DataBase ";
// to insert the errors in job details
job.MessageTypeId = (int)EnumMessageType.Error;
job.SheetName = sheet.SheetName;
job.ErrorMessage = integration.Description;
job.IntegrationId = integration.Id;
job.RowNumber = sheetCount.ToString();
InsertJobDetails(job);
}
}
else
{
integration.StatusId = (int)IntegrationStatusEnum.CompleteWithError;
integration.Description = "Sheet " + sheetName + " is not present in file " + file.FileName;
// to insert the errors in job details
job.MessageTypeId = (int)EnumMessageType.Error;
job.SheetName = sheet.SheetName;
job.ErrorMessage = integration.Description;
job.IntegrationId = integration.Id;
job.RowNumber = sheetCount.ToString();
InsertJobDetails(job);
}
}
//meta.Add(new MetaData { SheetName = sheet.GetRow(row).GetCell(0).ToString(), Load = sheet.GetRow(row).GetCell(1).ToString() });
}
}
integration.StatusId = failed == 0 ? (int)IntegrationStatusEnum.Completed : (int)IntegrationStatusEnum.CompleteWithError;
InsertIntegrationJob(integration);;
}
else
{
integration.StatusId = (int)IntegrationStatusEnum.Error;
integration.Description = "MetaData Sheet is missing or it's not the first sheet";
integration.ModifiedDate = DateTime.Now;
InsertIntegrationJob(integration);
}
}
public string GetDescription(IntegrationJob profile)
{
return("Total " + proccessed + " Lookup proccessed. Successful " + profile.Success + " and Failed " + profile.Failed);
}
