/// <summary> /// Bulk insert PipeLine order file into a staging table /// </summary> /// <param name="id">PipeLine order task id</param> public void Execute(int id) { JobItem jobItem = new JobItem(); jobItem.StartDate = DateTime.UtcNow; jobItem.JobId = id; jobItem.TaskName = Name; try { var taskresult = this.PreviousTaskResult.TaskData; var ftpConfig = _service.GetFtpConfig(FtpConfigurationType.PipelineOrder); string filePath = string.IsNullOrEmpty(_fileName) ? taskresult.FilePath : string.Format("{0}{1}/{2}", ftpConfig.DownloadLocalDirectory, ftpConfig.FtpDirecrory, _fileName); int recordsImported = _service.PopulatePipeLineOrder(filePath); //taskresult.NoOfRecordImported = recordsImported; _taskResult = new dlxTaskResult() { IsSuccess = true, TaskData = string.IsNullOrEmpty(_fileName) ? taskresult: new dlxTaskData { NoOfRecordImported = recordsImported, FilePath = filePath } }; jobItem.Status = true; jobItem.Description = "Pipe line order Bulk Insert Successful"; jobItem.EndDate = DateTime.UtcNow; _service.JobItemLog(jobItem); } catch (Exception ex) { Console.Write(ex.Message); _taskResult = new dlxTaskResult() { IsSuccess = false, ErrorMessage = "Pipe line order Bulk Insert Failed" }; jobItem.Status = false; jobItem.Description = string.Format("Error: {0} Inner Exception: {1} Error Message: {2}", _taskResult.ErrorMessage, ex.InnerException == null ? "" : ex.InnerException.ToString(), ex.Message); jobItem.EndDate = DateTime.UtcNow; _service.JobItemLog(jobItem); } }