private void RunProcedure(Processes processes, ProcessJob job, ProcessTrigger processTrigger) { var actionName = processes.PackageName; var parameters = new List <SqlParameter>(); Log.WriteErrorLog(string.Format("Starting store procedure execution for {0}-{1}.", _serviceName, processes.Title)); //Update tigger to Running processTrigger.Status = PackageStatus.Running; processTrigger.Remark = "Store procedure currently running..."; _dataManager.UpdateProcessTrigger(_connectionString, processTrigger); var result = string.Empty; SqlDataManager.RunProcedureWithMessage(_connectionString, actionName, parameters.ToArray()); if (result.Contains("Success")) { Log.WriteErrorLog(string.Format("Store procedure execution for {0}-{1} successfull.", _serviceName, processes.Title)); //Update tigger to Done processTrigger.Status = PackageStatus.Done; processTrigger.Remark = result; _dataManager.UpdateProcessTrigger(_connectionString, processTrigger); } else { Log.WriteErrorLog(string.Format("Store procedure execution for {0}-{1} failed.{2}", _serviceName, processes.Title, result)); //Update tigger to Fail processTrigger.Status = PackageStatus.Fail; processTrigger.Remark = string.Format("Package {0}-{1} failed. {2}", _serviceName, processes.Title, result); _dataManager.UpdateProcessTrigger(_connectionString, processTrigger); } }
private void RunProcedure(Extraction extraction, ExtractionJob job, ExtractionTrigger extractionTrigger) { var actionName = extraction.PackageName; var parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter() { ParameterName = "StartDate", Value = job.StartDate.GetOracleDate() }); parameters.Add(new SqlParameter() { ParameterName = "EndDate", Value = job.EndDate.GetOracleDate() }); parameters.Add(new SqlParameter() { ParameterName = "FYYear", Value = string.Format("FY{0}", job.EndDate.Year.ToString()) }); parameters.Add(new SqlParameter() { ParameterName = "Year", Value = string.Format("{0}", job.EndDate.Year.ToString()) }); parameters.Add(new SqlParameter() { ParameterName = "Period", Value = string.Format("M{0}", job.EndDate.Month.ToString().PadLeft(2, '0')) }); Log.WriteErrorLog(string.Format("Starting store procedure execution for {0}-{1}.", _serviceName, extraction.Title)); //Update tigger to Running extractionTrigger.Status = PackageStatus.Running; extractionTrigger.Remark = "Store procedure currently running..."; _dataManager.UpdateExtractionTrigger(_connectionString, extractionTrigger); var result = string.Empty; SqlDataManager.RunProcedureWithMessage(_connectionString, actionName, parameters.ToArray()); if (result.Contains("Success")) { Log.WriteErrorLog(string.Format("Store procedure execution for {0}-{1} successfull.", _serviceName, extraction.Title)); //Update tigger to Done extractionTrigger.Status = PackageStatus.Done; extractionTrigger.Remark = result; _dataManager.UpdateExtractionTrigger(_connectionString, extractionTrigger); } else { Log.WriteErrorLog(string.Format("Store procedure execution for {0}-{1} failed.{2}", _serviceName, extraction.Title, result)); //Update tigger to Fail extractionTrigger.Status = PackageStatus.Fail; extractionTrigger.Remark = string.Format("Package {0}-{1} failed. {2}", _serviceName, extraction.Title, result); _dataManager.UpdateExtractionTrigger(_connectionString, extractionTrigger); } }