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);
}
}
