/// <summary>
/// This method is used to add a record into Auditing table
/// </summary>
/// <param name="auditEntry"></param>
/// <returns></returns>
public int AddAuditEntry(AuditEntry auditEntry)
{
int result = -1;
try
{
objCommonDataAccess = new CommonDataAccess();
sqlParamList = new List <SqlParameter>();
sqlParamList.Add(objCommonDataAccess.AddSqlParameter("@pin_BaudRate", SqlDbType.VarChar, auditEntry.BaudRate));
sqlParamList.Add(objCommonDataAccess.AddSqlParameter("@pin_ComPort", SqlDbType.VarChar, auditEntry.ComPort));
sqlParamList.Add(objCommonDataAccess.AddSqlParameter("@pin_DataBits", SqlDbType.VarChar, auditEntry.DataBits));
sqlParamList.Add(objCommonDataAccess.AddSqlParameter("@pin_DataDirection", SqlDbType.VarChar, auditEntry.DataDirection));
sqlParamList.Add(objCommonDataAccess.AddSqlParameter("@pin_Parity", SqlDbType.VarChar, auditEntry.Parity));
sqlParamList.Add(objCommonDataAccess.AddSqlParameter("@pin_StopBits", SqlDbType.VarChar, auditEntry.StopBits));
sqlParamList.Add(objCommonDataAccess.AddSqlParameter("@pin_TextMessage", SqlDbType.VarChar, auditEntry.TextMessage));
sqlParamList.Add(objCommonDataAccess.AddSqlParameter("@pin_CommandDateTime", SqlDbType.DateTime, System.DateTime.Now));
result = objCommonDataAccess.ExecuteNonQuery(ADD_AUDIT_SP_NAME, sqlParamList);
}
catch (Exception ex)
{
//Do not throw since return value will be -1;
}
return(result);
}
public DataSet GetAuditRecords(AuditEntry auditEntry)
{
objCommonDataAccess = new CommonDataAccess();
DataSet dsUDT = null;
try
{
objCommonDataAccess = new CommonDataAccess();
sqlParamList = new List <SqlParameter>();
//sqlParamList.Add(objCommonDataAccess.AddSqlParameter("@pin_ComPort", SqlDbType.VarChar, auditEntry.ComPort));
//sqlParamList.Add(objCommonDataAccess.AddSqlParameter("@pin_DataDirection", SqlDbType.VarChar, auditEntry.DataDirection));
//dsUDT = objCommonDataAccess.FillDataset(GET_AUDIT_RECORD_SP_NAME,sqlParamList);
dsUDT = objCommonDataAccess.FillDataset(GET_AUDIT_RECORD_SP_NAME);
}
catch (Exception ex)
{
System.Diagnostics.Debug.Print(ex.StackTrace);
}
finally
{
objCommonDataAccess = null;
}
return(dsUDT);
}