//public MsgRetriever SaveAMaint(AuditLoggerModel _auditLog)
//{
// var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
// objDataEngine.InitiateConnection();
// SqlParameter[] Parameters = new SqlParameter[4];
// Parameters[0] = string.IsNullOrEmpty(_auditLog.SelectedModule) ? new SqlParameter("@Module", DBNull.Value) : new SqlParameter("@Module", _auditLog.SelectedModule);
// Parameters[1] = string.IsNullOrEmpty(_auditLog.TblName) ? new SqlParameter("@TblName", DBNull.Value) : new SqlParameter("@TblName", _auditLog.TblName);
// Parameters[2] = string.IsNullOrEmpty(_auditLog.Date) ? new SqlParameter("@Date", DBNull.Value) : new SqlParameter("@Date", _auditLog.Date);
// Parameters[3] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
// Parameters[3].Direction = ParameterDirection.ReturnValue;
// var Cmd = objDataEngine.ExecuteWithReturnValue("WebAuditMaintSearch", CommandType.StoredProcedure, Parameters);
// var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
// var Descp = GetMessageCode(Result);
// objDataEngine.CloseConnection();
// return Descp;
// }
public AuditLoggerModel GetAudLoggerDetail(AuditLoggerModel _AudLogger)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = string.IsNullOrEmpty(_AudLogger.SelectedModule) ? new SqlParameter("@Module", DBNull.Value) : new SqlParameter("@Module", _AudLogger.SelectedModule);
Parameters[1] = new SqlParameter("@AuditId", _AudLogger.AudId);
var execResult = objDataEngine.ExecuteCommand("WebAuditMaintSelect", CommandType.StoredProcedure, Parameters);
while (execResult.Read())
{
var _auditLog = new AuditLoggerModel
{
AudId = Convert.ToString(execResult["AuditId"]),
SelectedTblName = Convert.ToString(execResult["TableName"]),
FieldName = Convert.ToString(execResult["FieldName"]),
RefKey = Convert.ToString(execResult["Ref Key"]),
subRefKey1 = Convert.ToString(execResult["Sub Ref Key1"]),
subRefKey2 = Convert.ToString(execResult["Sub Ref Key2"]),
ActionAud = Convert.ToString(execResult["Action"]),
OldData = Convert.ToString(execResult["Old Data"]),
NewData = Convert.ToString(execResult["New Data"]),
ActionBy = Convert.ToString(execResult["Actioned By"]),
CreationDate = Convert.ToString(execResult["Creation Date"]),
};
return(_auditLog);
}
;
return(new AuditLoggerModel());
}
finally
{
objDataEngine.CloseConnection();
}
}
public List <AuditLoggerModel> GetAuditSearch(AuditLoggerModel _auditLog)
{
var objDataEngine = new FleetDataEngine(AccessMode.Admin, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = string.IsNullOrEmpty(_auditLog.SelectedModule) ? new SqlParameter("@Module", DBNull.Value) : new SqlParameter("@Module", _auditLog.SelectedModule);
Parameters[1] = string.IsNullOrEmpty(_auditLog.SelectedTblName) ? new SqlParameter("@TblName", DBNull.Value) : new SqlParameter("@TblName", _auditLog.SelectedTblName);
Parameters[2] = new SqlParameter("@Date", ConvertDatetimeDB(_auditLog.Date));
var execResult = objDataEngine.ExecuteCommand("WebAuditMaintSearch", CommandType.StoredProcedure, Parameters);
var AuditSearch = new List <AuditLoggerModel>();
while (execResult.Read())
{
AuditSearch.Add(new AuditLoggerModel
{
SelectedTblName = Convert.ToString(execResult["TableName"]),
FieldName = Convert.ToString(execResult["FieldName"]),
RefKey = Convert.ToString(execResult["Ref Key"]),
ActionAud = Convert.ToString(execResult["Action"]),
OldData = Convert.ToString(execResult["Old Data"]),
NewData = Convert.ToString(execResult["New Data"]),
CreationDate = DateConverter(execResult["Creation Date"]),
// UserId=Convert.ToString(execResult["UserId"])
});
}
;
return(AuditSearch);
}
finally
{
objDataEngine.CloseConnection();
}
}
