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);
}
