public string ManipulateUserAccessLog(SEC_UserLog userLogin)
{
string errorNumber = String.Empty;
try
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
SqlDatabase db = factory.CreateDefault() as SqlDatabase;
using (DbCommand dbCommandWrapper = db.GetStoredProcCommand("Set_UserActionLogg"))
{
// Set parameters
db.AddInParameter(dbCommandWrapper, "@LogID", SqlDbType.NVarChar, userLogin.LogID);
db.AddInParameter(dbCommandWrapper, "@UserID", SqlDbType.NVarChar, userLogin.UserID);
db.AddInParameter(dbCommandWrapper, "@UsedIP", SqlDbType.NVarChar, userLogin.UsedIP);
db.AddInParameter(dbCommandWrapper, "@UserAction ", SqlDbType.NVarChar, userLogin.UserAction);
db.AddInParameter(dbCommandWrapper, "@ActionUrl", SqlDbType.NVarChar, userLogin.ActionUrl);
db.AddInParameter(dbCommandWrapper, "@ActionEventTime", SqlDbType.DateTime, userLogin.ActionEventTime);
db.AddInParameter(dbCommandWrapper, "@ActionExecuteTime ", SqlDbType.NVarChar, userLogin.ActionExecuteTime);
db.AddInParameter(dbCommandWrapper, "@Status", SqlDbType.Int, userLogin.Status);
// Execute SP.
db.ExecuteNonQuery(dbCommandWrapper);
// Getting output parameters and setting response details.
errorNumber = "done";
}
}
catch (Exception ex)
{
errorNumber = "faild"; // Log ex.Message Insert Log Table
}
return(errorNumber);
}
public override void OnResultExecuted(ResultExecutedContext filterContext)
{
SEC_UserLog _userLog = new SEC_UserLog();
RouteData route_data = filterContext.RouteData;
_userLog.ActionExecuteTime = (DateTime.Now - start_time).ToString();
_userLog.ActionUrl = (route_data.DataTokens["area"] as string) + "/" + (route_data.Values["controller"] as string) + "/" + route_data.Values["action"] as string;
_userLog.UserID = UserID;
_userLog.UsedIP = GetIPAddress.LocalIPAddress();
_userLog.UserAction = route_data.Values["action"] as string;
_userLog.ActionEventTime = DateTime.Now.ToString();
userAccessLogService.ManipulateUserAccessLog(_userLog);
}
public string ManipulateUserAccessLog(SEC_UserLog userLogin)
{
return(_accessLogDataService.ManipulateUserAccessLog(userLogin));
}
