public static List <string> GetUserLoginHistoryUrls() { var lst = new List <string>(); var data = new Framework.Components.LogAndTrace.UserLoginHistoryDataModel(); data.UserId = SessionVariables.RequestProfile.AuditId; var dt = Framework.Components.LogAndTrace.UserLoginHistoryDataManager.Search(data, SessionVariables.RequestProfile); dt = dt.AsEnumerable() .OrderByDescending(t => t.Field <DateTime>(Framework.Components.LogAndTrace.UserLoginHistoryDataModel.DataColumns.DateVisited)).CopyToDataTable(); lst = (from row in dt.AsEnumerable() select row[Framework.Components.LogAndTrace.UserLoginHistoryDataModel.DataColumns.URL].ToString().Trim()).Distinct().Take(7).ToList(); return(lst); }
// GET api/<controller> public IEnumerable <Framework.Components.LogAndTrace.UserLoginHistoryDataModel> Get(string userId) { var auditId = 0; if (!string.IsNullOrEmpty(userId)) { auditId = Convert.ToInt32(userId); } var requestProfile = new RequestProfile(); requestProfile.AuditId = auditId; requestProfile.ApplicationId = Convert.ToInt32(ConfigurationManager.AppSettings["StartupApplicationId"]); var data = new Framework.Components.LogAndTrace.UserLoginHistoryDataModel(); data.UserId = auditId; var list = Framework.Components.LogAndTrace.UserLoginHistoryDataManager.GetLastUrls(data, 7, requestProfile); return(list); }
protected void btnSearch_Click(object sender, EventArgs e) { var data = new Framework.Components.LogAndTrace.UserLoginHistoryDataModel(); if (oDate.FromDate != null) { data.FromSearchDate = oDate.FromDate; } if (oDate.ToDate != null) { data.ToSearchDate = oDate.ToDate; } LoginHistoryGrid.DataSource = Framework.Components.LogAndTrace.UserLoginHistoryDataManager.Search(data, SessionVariables.RequestProfile); LoginHistoryGrid.DataBind(); PerferenceUtility.UpdateUserPreference("General", ApplicationCommon.DateRangeFormat, oDate.DateRangeFormatId.ToString()); PerferenceUtility.UpdateUserPreference("General", ApplicationCommon.FromDateRange, oDate.FromDate.ToString()); //ApplicationCommon.UpdateUserPreference("General", ApplicationCommon.ToDate, oDate.ToDate.ToString()); }