private void AddUpdateUserAuditTrailRecord(string strPageName, string UserLoginID)
{
UserAuditTrail objUserAudit = new UserAuditTrail();
objUserAudit.UserLoginID = UserLoginID;
objUserAudit.LogInGuID = Session[SessionKey.Key.GuIdAtLogin.ToString()].ToString();
objUserAudit.Description = strPageName;
objUserAudit.CurrentActionTime = DateTime.Now;
UserAuditTrailBLL.Instance.AddUpdateUserAuditTrailRecord(objUserAudit);
}
public void UpdateUserLogOutTime(UserAuditTrail objUserAudit)
{
try
{
SqlDatabase database = MSSQLDataBase.Instance.GetDefaultDatabase();
{
DbCommand command = database.GetStoredProcCommand("SP_UpdateUserAuditLogOutTime");
command.CommandType = CommandType.StoredProcedure;
database.AddInParameter(command, "@LogInGuID", DbType.String, objUserAudit.LogInGuID);
database.AddInParameter(command, "@LogOutTime", DbType.String, objUserAudit.LogOutTime);
database.ExecuteScalar(command);
//int res = Convert.ToInt32(database.GetParameterValue(command, "@result"));
}
}
catch (Exception ex)
{
}
}
public void AddUpdateUserAuditTrailRecord(UserAuditTrail objUserAudit)
{
try
{
SqlDatabase database = MSSQLDataBase.Instance.GetDefaultDatabase();
{
DbCommand command = database.GetStoredProcCommand("SP_AddUpdateUserAuditRecord");
command.CommandType = CommandType.StoredProcedure;
database.AddInParameter(command, "@LogInGuID", DbType.String, objUserAudit.LogInGuID);
database.AddInParameter(command, "@UserLoginID", DbType.String, objUserAudit.UserLoginID);
database.AddInParameter(command, "@Description", DbType.String, objUserAudit.Description);
database.AddInParameter(command, "@CurrentActionTime", DbType.DateTime, objUserAudit.CurrentActionTime);
database.ExecuteScalar(command);
//int res = Convert.ToInt32(database.GetParameterValue(command, "@result"));
}
}
catch (Exception ex)
{
}
}
public void UpdateUserLogOutTime(UserAuditTrail objUserAudit)
{
UserAuditTrailDAL.Instance.UpdateUserLogOutTime(objUserAudit);
}
public void AddUpdateUserAuditTrailRecord(UserAuditTrail objUserAudit)
{
UserAuditTrailDAL.Instance.AddUpdateUserAuditTrailRecord(objUserAudit);
}
