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