public IEnumerable <LoginLog> ReportLoginLogPage(int accountid, string username, DateTime startdate,
DateTime enddate,
string sortby, bool isdescending, int pagenumber, int pagecount)
{
VodigiLogsContext db = new VodigiLogsContext();
var query = from loginlog in db.LoginLogs
select loginlog;
query = query.Where(lls => lls.AccountID.Equals(accountid));
if (!String.IsNullOrEmpty(username))
{
query = query.Where(lls => lls.Username.Equals(username));
}
query = query.Where(lls => lls.LoginDateTime >= startdate);
query = query.Where(lls => lls.LoginDateTime < enddate);
if (!String.IsNullOrEmpty(sortby))
{
query = query.OrderBy(sortby, isdescending);
}
// Get a single page from the filtered records
int iSkip = (pagenumber * Constants.PageSize) - Constants.PageSize;
List <LoginLog> loginlogs = query.Skip(iSkip).Take(Constants.PageSize).ToList();
return(loginlogs);
}
public int ReportActivityLogRecordCount(int accountid, string username,
string entitytype, string entityaction,
DateTime startdate, DateTime enddate)
{
VodigiLogsContext db = new VodigiLogsContext();
var query = from activitylog in db.ActivityLogs
select activitylog;
query = query.Where(als => als.AccountID.Equals(accountid));
if (!String.IsNullOrEmpty(username))
{
query = query.Where(als => als.Username.Equals(username));
}
if (!String.IsNullOrEmpty(entitytype))
{
query = query.Where(als => als.EntityType.Equals(entitytype));
}
if (!String.IsNullOrEmpty(entityaction))
{
query = query.Where(als => als.EntityAction.Equals(entityaction));
}
query = query.Where(als => als.ActivityDateTime >= startdate);
query = query.Where(als => als.ActivityDateTime < enddate);
// Get a Count of all filtered records
return(query.Count());
}
public int ReportPlayerScreenContentLogRecordCount(int accountid, string playername,
string screenname, string screencontentname, string screencontenttypename,
DateTime startdate, DateTime enddate)
{
VodigiLogsContext db = new VodigiLogsContext();
var query = from playerscreencontentlog in db.PlayerScreenContentLogs
select playerscreencontentlog;
query = query.Where(pscls => pscls.AccountID.Equals(accountid));
if (!String.IsNullOrEmpty(playername))
{
query = query.Where(pscls => pscls.PlayerName.Equals(playername));
}
if (!String.IsNullOrEmpty(screenname))
{
query = query.Where(pscls => pscls.ScreenName.Equals(screenname));
}
if (!String.IsNullOrEmpty(screencontentname))
{
query = query.Where(pscls => pscls.ScreenContentName.Equals(screencontentname));
}
if (!String.IsNullOrEmpty(screencontenttypename))
{
query = query.Where(pscls => pscls.ScreenContentTypeName.Equals(screencontenttypename));
}
query = query.Where(pscls => pscls.DisplayDateTime >= startdate);
query = query.Where(pscls => pscls.DisplayDateTime < enddate);
// Get a Count of all filtered records
return(query.Count());
}
public IEnumerable <PlayerScreenLog> ReportPlayerScreenLogPage(int accountid, string playername, string screenname,
DateTime startdate, DateTime enddate,
string sortby, bool isdescending, int pagenumber, int pagecount)
{
VodigiLogsContext db = new VodigiLogsContext();
var query = from playerscreenlog in db.PlayerScreenLogs
select playerscreenlog;
query = query.Where(psls => psls.AccountID.Equals(accountid));
if (!String.IsNullOrEmpty(playername))
{
query = query.Where(psls => psls.PlayerName.Equals(playername));
}
if (!String.IsNullOrEmpty(screenname))
{
query = query.Where(psls => psls.ScreenName.Equals(screenname));
}
query = query.Where(psls => psls.DisplayDateTime >= startdate);
query = query.Where(psls => psls.DisplayDateTime < enddate);
// Apply the ordering
if (!String.IsNullOrEmpty(sortby))
{
query = query.OrderBy(sortby, isdescending);
}
// Get a single page from the filtered records
int iSkip = (pagenumber * Constants.PageSize) - Constants.PageSize;
List <PlayerScreenLog> playerscreenlogs = query.Skip(iSkip).Take(Constants.PageSize).ToList();
return(playerscreenlogs);
}
public int ReportLoginLogRecordCount(int accountid, string username, DateTime startdate, DateTime enddate)
{
VodigiLogsContext db = new VodigiLogsContext();
var query = from loginlog in db.LoginLogs
select loginlog;
query = query.Where(lls => lls.AccountID.Equals(accountid));
if (!String.IsNullOrEmpty(username))
{
query = query.Where(lls => lls.Username.Equals(username));
}
query = query.Where(lls => lls.LoginDateTime >= startdate);
query = query.Where(lls => lls.LoginDateTime < enddate);
// Get a Count of all filtered records
return(query.Count());
}