public static int DeleteT_ATTAINS_REPORT(int aTTAINS_REPORT_IDX)
{
using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
{
try
{
T_ATTAINS_REPORT r = (from c in ctx.T_ATTAINS_REPORT
where c.ATTAINS_REPORT_IDX == aTTAINS_REPORT_IDX
select c).FirstOrDefault();
if (r.ATTAINS_SUBMIT_STATUS == "Y" || r.ATTAINS_SUBMIT_STATUS == "U")
{
return(-1);
}
ctx.DeleteObject(r);
ctx.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
}
private void PopulateForm()
{
int rptID = hdnReportIDX.Value.ConvertOrDefault <int>();
if (rptID > 0)
{
//general info
T_ATTAINS_REPORT rpt = db_Attains.GetT_ATTAINS_REPORT_byID(rptID);
if (rpt != null)
{
txtRptName.Text = rpt.REPORT_NAME;
txtRptFrom.Text = rpt.DATA_FROM.ToString();
txtRptTo.Text = rpt.DATA_TO.ToString();
//assessment units
grdAssessUnits.DataSource = db_Attains.GetT_ATTAINS_ASSESS_UNITS_byReportID(rptID);
grdAssessUnits.DataBind();
//assessments
grdAssess.DataSource = db_Attains.GetT_ATTAINS_ASSESS_byReportID(rptID);
grdAssess.DataBind();
}
pnlTabs.Visible = (rpt != null);
}
}
public static void ATTAINS_byReport(int ReportIDX)
{
//get OrgID for the report
T_ATTAINS_REPORT r = db_Attains.GetT_ATTAINS_REPORT_byID(ReportIDX);
if (r != null)
{
//get CDX username, password, and CDX destination URL
CDXCredentials cred = WQXSubmit.GetCDXSubmitCredentials2(r.ORG_ID);
//*******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;
}
StatusResponseType subStatus = WQXSubmit.SubmitHelper(cred.NodeURL, token, "ATTAINS", "default", bytes, "submit.xml", DocumentFormatType.XML, "1");
if (subStatus != null)
{
//*******GET STATUS********************************************************************************************************
string status = "";
int i = 0;
do
{
i += 1;
Thread.Sleep(10000);
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 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 = "******")
{
using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
{
Boolean insInd = false;
try
{
T_ATTAINS_REPORT a = new T_ATTAINS_REPORT();
if (aTTAINS_REPORT_IDX != null)
{
a = (from c in ctx.T_ATTAINS_REPORT
where c.ATTAINS_REPORT_IDX == aTTAINS_REPORT_IDX
select c).FirstOrDefault();
}
if (aTTAINS_REPORT_IDX == null) //insert case
{
insInd = true;
}
if (oRG_ID != null)
{
a.ORG_ID = oRG_ID;
}
if (rEPORT_NAME != null)
{
a.REPORT_NAME = rEPORT_NAME;
}
if (dATA_FROM != null)
{
a.DATA_FROM = dATA_FROM;
}
if (dATA_TO != null)
{
a.DATA_TO = dATA_TO;
}
if (aTTAINS_IND != null)
{
a.ATTAINS_IND = aTTAINS_IND;
}
if (aTTAINS_SUBMIT_STATUS != null)
{
a.ATTAINS_SUBMIT_STATUS = aTTAINS_SUBMIT_STATUS;
}
if (aTTAINS_UPDATE_DT != null)
{
a.ATTAINS_UPDATE_DT = aTTAINS_UPDATE_DT;
}
if (insInd) //insert case
{
a.CREATE_USERID = cREATE_USER.ToUpper();
a.CREATE_DT = System.DateTime.Now;
ctx.AddToT_ATTAINS_REPORT(a);
}
ctx.SaveChanges();
return(a.ATTAINS_REPORT_IDX);
}
catch (Exception ex)
{
return(0);
}
}
}
