public IEnumerable<ActivityLog> ReportActivityLogPage(int accountid, string username,
string entitytype, string entityaction,
DateTime startdate, DateTime enddate,
string sortby, bool isdescending, int pagenumber, int pagecount)
{
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);
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<ActivityLog> activitylogs = query.Skip(iSkip).Take(Constants.PageSize).ToList();
return activitylogs;
}
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 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 ReportPlayerScreenLogRecordCount(int accountid, string playername, string screenname,
DateTime startdate, DateTime enddate)
{
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);
// Get a Count of all filtered records
return query.Count();
}
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();
}