private UpdateJobStatusSerializable GetRequestObject(string p_wrNumber, string p_jobStatus)
{
UpdateJobStatusSerializable oUpdateJob = new UpdateJobStatusSerializable();
RequestHeaderType oRequest = new RequestHeaderType();
string sTransactionID = string.Empty;
DataAccess oDataAccess = new DataAccess(m_oApp);
sTransactionID = oDataAccess.GetFirstFieldValueFromRecordset("select CORRELATION_ID_SEQ.nextval from dual");
oRequest.TransactionType = "RequestReply";
oRequest.SourceSystem = "GIS";
oRequest.TransactionId = sTransactionID;
oRequest.Requestor = m_oApp.DataContext.DatabaseUserName;
oRequest.Timestamp = DateTime.Now;
WorkRequestType oWork = new WorkRequestType();
oWork.WRNumber = p_wrNumber;
oWork.WRStatus = p_jobStatus;
oUpdateJob.RequestHeaderType = oRequest;
oUpdateJob.WorkRequestType = oWork;
return(oUpdateJob);
}
private string GetRequestXML(UpdateJobStatusSerializable p_oUpdateJob)
{
string sRequestXML = string.Empty;
var xmlString = new StringWriter();
XmlSerializer xmlSerializer = new XmlSerializer(typeof(UpdateJobStatusSerializable));
XmlSerializerNamespaces ns = new XmlSerializerNamespaces();
//ns.Add("xsi", "http://www.w3.org/2001/XMLSchema-instance");
ns.Add("xsi", "http://www.w3.org/2001/XMLSchema-instance");
xmlSerializer.Serialize(xmlString, p_oUpdateJob, ns);
sRequestXML = xmlString.ToString();
return(sRequestXML);
}
/// <summary>
/// Method to call processing of Update Job Status
/// </summary>
/// <param name="p_wrNumber">G3E_JOB.WR_NBR</param>
/// <param name="p_jobStatus">G3E_JOB.JOB_STATUS</param>
/// <param name="p_errorInfo">Any error infor</param>
/// <returns>returns the Status as SUCCESS or FAILURE</returns>
public string ProcessUpdateJobStatus(string p_wrNumber, string p_jobStatus, out string p_errorInfo)
{
string status = string.Empty;
p_errorInfo = string.Empty;
try
{
UpdateJobStatusSerializable oUpdateJob = GetRequestObject(p_wrNumber, p_jobStatus);
DataAccess oDataAccess = new DataAccess(m_oApp);
string sRequestURL = oDataAccess.GetEFUrl("WMIS_UpdateStatus", "EdgeFrontier");
string sRequestXML = GetRequestXML(oUpdateJob);
// --------------------------------------------------- Begin Temporary Logging ------------------------------------------
//string sql = "insert into command_log " +
// "columns(command_name,command_nbr,log_code,log_context,log_type,log_msg) " +
// "values(?,?,?,?,?,?)";
//IGTApplication app = GTClassFactory.Create<IGTApplication>();
//// This CCNO is 71
//app.DataContext.Execute(sql, out int recs, (int)ADODB.CommandTypeEnum.adCmdText, "SharedWriteBackLibrary.ProcessJobStatusUpdate", 0, "", "XML for RequestJobStatusUpdate", "INFO", sRequestXML);
//app.DataContext.Execute(sql, out recs, (int)ADODB.CommandTypeEnum.adCmdText, "SharedWriteBackLibrary.ProcessJobStatusUpdate", 0, "", "URL for RequestJobStatusUpdate", "INFO", sRequestURL);
//app.DataContext.Execute("commit", out recs, (int)ADODB.CommandTypeEnum.adCmdText);
// --------------------------------------------------- End Temporary Logging ------------------------------------------
status = ProcessRequest(sRequestURL, sRequestXML, out p_errorInfo);
return(status);
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print(ex.Message);
throw;
}
}