/// <Summary> /// <Description>This method will fetch Audit results data from the database.</Description> /// <MethodName>GetAuditResultdData</MethodName> /// <RetunType>Void</RetunType> /// <InputParams> /// <param1>int reci_seq</param1> /// <param1>string sdate</param1> /// <param1>string edate</param1> /// /// </InputParams> /// </Summary> public string GetAuditResultdData(int reci_seq, string sdate, string edate) { DBResults objDb = new DBResults(); WEIS.AuditResults objAuditResults = new WEIS.AuditResults(); DataSet dsAuditResults = new DataSet(); string abc = string.Empty; try { objDb = objAuditResults.GetAuditResultsData(reci_seq, sdate, edate); dsAuditResults = objDb.oraResultSet; //if (dsAuditResults.Tables.Count > 0) //{ abc = PrepareHTML(dsAuditResults, sdate, edate); //} dsAuditResults.Dispose(); dsAuditResults = null; objDb = null; objAuditResults = null; } catch (Exception ex) { Utilities.StopDisplayAndLogMessage(Resources.Resource.AuditResults_Title.ToString(), Resources.Resource.AuditResults_GetDataError.ToString(), 1, ex.StackTrace.ToString(), WEIS.SessionManager.Current.UserID, Resources.Resource.Error_Details.ToString() + ex.Message, ""); } return(abc); }
//look up comments between current result and and most recent audited result public string getCommentsForCurrentResults(string RSLT_SEQ, string fDate, string tDate) { string strCurrentComments = string.Empty; string strDeletedComments = string.Empty; string strComments = string.Empty; WEIS.AuditResults objAuditResults = new WEIS.AuditResults(); try { strCurrentComments = objAuditResults.GetCommentsForCurrentResults(RSLT_SEQ, fDate, tDate, "NO"); strDeletedComments = objAuditResults.GetCommentsForCurrentResults(RSLT_SEQ, fDate, tDate, "YES"); if (strCurrentComments != "") { //calling database function to look up comments between current result and and most recent audited result strComments = strCurrentComments; } else if (strDeletedComments != "") { strComments = strDeletedComments; } objAuditResults = null; } catch (Exception ex) { Utilities.StopDisplayAndLogMessage(Resources.Resource.AuditResults_Title.ToString(), Resources.Resource.AuditResults_GetDataError.ToString(), 1, ex.StackTrace.ToString(), WEIS.SessionManager.Current.UserID, Resources.Resource.Error_Details.ToString() + ex.Message, ""); } return(strComments); }
//if there are no audit records, search for any comments saved before current result public string GetCommentsWhenNoAudit(string RSLT_SEQ, string fDate) { string strComments = string.Empty; WEIS.AuditResults objAuditResults = new WEIS.AuditResults(); try { strComments = objAuditResults.GetCommentsWhenNoAudit(RSLT_SEQ, fDate); objAuditResults = null; } catch (Exception ex) { Utilities.StopDisplayAndLogMessage(Resources.Resource.AuditResults_Title.ToString(), Resources.Resource.AuditResults_GetDataError.ToString(), 1, ex.StackTrace.ToString(), WEIS.SessionManager.Current.UserID, Resources.Resource.Error_Details.ToString() + ex.Message, ""); } return(strComments); }
// public string getAuditRecordsForCurrentResults(string RSLT_SEQ, string aDate) { string strAudit = string.Empty; DBResults objDb = new DBResults(); WEIS.AuditResults objAuditResults = new WEIS.AuditResults(); DataSet dsAuditResults = new DataSet(); DataTable dt1 = new DataTable(); int i = 0; string strDate1 = string.Empty; string strDate2 = string.Empty; try { objDb = objAuditResults.GetAuditRecordsForCurrentResults(RSLT_SEQ, aDate); dsAuditResults = objDb.oraResultSet; dt1 = dsAuditResults.Tables[0]; if (dt1.Rows.Count > 0) // if not rs2.eof of ASP { for (i = 0; i < dt1.Rows.Count; i++) // while rs2.eof of ASP { //calling database function to look up comments between current result and and most recent audited result if (i == 0) { strAudit = strAudit + getCommentsForCurrentResults(RSLT_SEQ, aDate, dt1.Rows[i]["audit_date"].ToString()); } strAudit = strAudit + "<tr><td> </td><td bgcolor=#99CCFF>"; strAudit = strAudit + dt1.Rows[i]["value"] + "</td><td bgcolor=#99CCFF> </td><td bgcolor=#99CCFF>"; strAudit = strAudit + dt1.Rows[i]["created"] + "</td><td bgcolor=#99CCFF>"; strAudit = strAudit + dt1.Rows[i]["status"] + "</td><td bgcolor=#99CCFF>"; strAudit = strAudit + dt1.Rows[i]["audit_user"] + "</td><td bgcolor=#99CCFF>"; strAudit = strAudit + dt1.Rows[i]["audit_date"] + "</td><td bgcolor=#99CCFF>"; strAudit = strAudit + dt1.Rows[i]["datestamp"] + "</td><td bgcolor=#99CCFF>"; strAudit = strAudit + dt1.Rows[i]["action"] + "</td></tr>"; //'save dates for looking up comments strDate1 = dt1.Rows[i]["audit_date"].ToString(); if (i <= (dt1.Rows.Count)) { strDate2 = dt1.Rows[i + 1]["audit_date"].ToString(); } else { strDate2 = "1/1/1999 12:00:00 AM"; } //'display all comments between current result and previous result strAudit = strAudit + getCommentsForCurrentResults(RSLT_SEQ, strDate1, strDate2); } } else { //if there are no audit records, search for any comments saved before current result strAudit = strAudit + GetCommentsWhenNoAudit(RSLT_SEQ, aDate); } dt1 = null; dsAuditResults.Dispose(); dsAuditResults = null; objDb = null; objAuditResults = null; } catch (Exception ex) { Utilities.StopDisplayAndLogMessage(Resources.Resource.AuditResults_Title.ToString(), Resources.Resource.AuditResults_GetDataError.ToString(), 1, ex.StackTrace.ToString(), WEIS.SessionManager.Current.UserID, Resources.Resource.Error_Details.ToString() + ex.Message, ""); } return(strAudit); }