public static void ATTAINS_byReport(int ReportIDX)
{
//get OrgID for the report
TAttainsReport r = db_Attains.GetT_ATTAINS_REPORT_byID(ReportIDX);
if (r != null)
{
//get CDX username, password, and CDX destination URL
CDXCredentials cred = WQXSubmit.GetCDXSubmitCredentials2(r.OrgId);
//*******AUTHENTICATE*********************************************************************************************************
string token = WQXSubmit.AuthHelper(cred.userID, cred.credential, "Password", "default", cred.NodeURL);
//*******SUBMIT***************************************************************************************************************
string requestXml = db_Attains.SP_GenATTAINSXML(ReportIDX); //get XML from DB stored procedure
byte[] bytes = Utils.StrToByteArray(requestXml);
if (bytes == null)
{
return;
}
NetworkNode2.StatusResponseType subStatus = WQXSubmit.SubmitHelper(cred.NodeURL, token, "ATTAINS", "default", bytes, "submit.xml", NetworkNode2.DocumentFormatType.XML, "1");
if (subStatus != null)
{
//*******GET STATUS********************************************************************************************************
string status = "";
int i = 0;
do
{
i += 1;
Thread.Sleep(10000);
NetworkNode2.StatusResponseType gsResp = WQXSubmit.GetStatusHelper(cred.NodeURL, token, subStatus.transactionId);
if (gsResp != null)
{
status = gsResp.status.ToString();
//exit if waiting too long
if (i > 30)
{
//UpdateRecordStatus(typeText, RecordIDX, "N");
//db_Ref.InsertUpdateWQX_TRANSACTION_LOG(null, typeText, RecordIDX, "I", null, "Timed out while getting status from EPA", subStatus.transactionId, "Failed", orgID);
return;
}
}
} while (status != "Failed" && status != "Completed");
}
}
}
public static int DeleteT_ATTAINS_REPORT(int aTTAINS_REPORT_IDX)
{
try
{
TAttainsReport r = (from c in _db.TAttainsReport
where c.AttainsReportIdx == aTTAINS_REPORT_IDX
select c).FirstOrDefault();
if (r.AttainsSubmitStatus == "Y" || r.AttainsSubmitStatus == "U")
{
return(-1);
}
_db.TAttainsReport.Remove(r);
_db.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
public static int InsertOrUpdateATTAINS_REPORT(int?aTTAINS_REPORT_IDX, string oRG_ID, string rEPORT_NAME, DateTime?dATA_FROM, DateTime?dATA_TO,
bool?aTTAINS_IND, string aTTAINS_SUBMIT_STATUS, DateTime?aTTAINS_UPDATE_DT, String cREATE_USER = "******")
{
Boolean insInd = false;
try
{
TAttainsReport a = new TAttainsReport();
if (aTTAINS_REPORT_IDX != null)
{
a = (from c in _db.TAttainsReport
where c.AttainsReportIdx == aTTAINS_REPORT_IDX
select c).FirstOrDefault();
}
if (aTTAINS_REPORT_IDX == null) //insert case
{
insInd = true;
}
if (oRG_ID != null)
{
a.OrgId = oRG_ID;
}
if (rEPORT_NAME != null)
{
a.ReportName = rEPORT_NAME;
}
if (dATA_FROM != null)
{
a.DataFrom = dATA_FROM;
}
if (dATA_TO != null)
{
a.DataTo = dATA_TO;
}
if (aTTAINS_IND != null)
{
a.AttainsInd = aTTAINS_IND;
}
if (aTTAINS_SUBMIT_STATUS != null)
{
a.AttainsSubmitStatus = aTTAINS_SUBMIT_STATUS;
}
if (aTTAINS_UPDATE_DT != null)
{
a.AttainsUpdateDt = aTTAINS_UPDATE_DT;
}
if (insInd) //insert case
{
a.CreateUserid = cREATE_USER.ToUpper();
a.CreateDt = System.DateTime.Now;
_db.TAttainsReport.Add(a);
}
else
{
_db.TAttainsReport.Update(a);
}
_db.SaveChanges();
return(a.AttainsReportIdx);
}
catch (Exception ex)
{
return(0);
}
}
