private DataTable _getLoginRecords(LoginData.LoginDataRequest Request) { Int32 RowLimit = CswConvert.ToInt32(_CswNbtResources.ConfigVbls.getConfigVariableValue(CswEnumNbtConfigurationVariables.treeview_resultlimit.ToString())); RowLimit = (RowLimit > 0) ? RowLimit : 250; String WhereClauseTemplate = @"where logindate >= {0} and logindate < {1} + 1"; String WhereClause = String.Format(WhereClauseTemplate, _CswNbtResources.getDbNativeDate(DateTime.Parse(Request.StartDate)), _CswNbtResources.getDbNativeDate(DateTime.Parse(Request.EndDate)) ); CswTableSelect LoginDataSelect = _CswNbtResources.makeCswTableSelect("Login_Data Select", "login_data"); DataTable TargetTable = LoginDataSelect.getTable(WhereClause: WhereClause, PageLowerBoundExclusive: 0, PageUpperBoundInclusive: RowLimit, //Yuck. RequireOneRow: false, OrderByColumns: null, FilterColumn: null, FilterValue: Int32.MinValue, SelectColumns: null); return(TargetTable); }
public LoginData getLoginData(LoginData.LoginDataRequest Request) { DataTable LoginTable = _getLoginRecords(Request); foreach (DataRow LoginDataRow in LoginTable.Rows) { LoginData.Login LoginRecord = new LoginData.Login { Username = LoginDataRow["username"].ToString(), IPAddress = LoginDataRow["ipaddress"].ToString(), LoginDate = LoginDataRow["logindate"].ToString(), LoginStatus = LoginDataRow["loginstatus"].ToString(), FailureReason = LoginDataRow["failurereason"].ToString(), FailedLoginCount = CswConvert.ToInt32(LoginDataRow["failedlogincount"]) }; Data.Logins.Add(LoginRecord); } return(Data); }