public static AnonUser InitAnonUser(this ApplicationDbContext db, string userHostAddress, string userHostName, string userAgent, string browser)
{
var anonUser = db.AnonUsers.FirstOrDefault(x => x.UserHostAddress == userHostAddress &&
x.UserHostName == userHostName &&
x.Browser == browser &&
x.UserAgent == userAgent);
if (anonUser == null)
{
anonUser = new AnonUser()
{
UserHostAddress = userHostAddress,
UserHostName = userHostName,
UserAgent = userAgent,
Browser = browser,
RequstsLeft = Globals.DefaultRequestLeft
};
db.AnonUsers.Add(anonUser);
db.SaveChanges();
}
return(anonUser);
}
public static AnonUser FindUser(this ApplicationDbContext db, string userHostAddress, string userHostName, string userAgent, string browser)
{
AnonUser res = null;
res = db.AnonUsers.FirstOrDefault(x => x.UserHostAddress == userHostAddress &&
x.UserHostName == userHostName &&
x.Browser == browser &&
x.UserAgent == userAgent);
return(res);
}
public static AnonUser FindAnonUser(this ApplicationDbContext db, HttpContextBase httpContext)
{
AnonUser res = null;
res = db.FindUser(httpContext.Request.UserHostAddress,
httpContext.Request.UserHostName,
httpContext.Request.UserAgent,
httpContext.Request.Browser.Browser);
return(res);
}
public AnonTrackingGrid GetGrid(AnonTrackingGridRequest model)
{
AnonTrackingGrid singleItem = new AnonTrackingGrid();
DataProvider.ExecuteCmd("dbo.AnonTracking_Grid"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@DisplayLength", model.displayLength);
paramCollection.AddWithValue("@DisplayStart", model.displayStart);
paramCollection.AddWithValue("@SortCol", model.sortCol);
paramCollection.AddWithValue("@SortDir", model.sortDir);
paramCollection.AddWithValue("@Search", model.search);
}
, singleRecordMapper : delegate(IDataReader reader, short set)
{
switch (set)
{
case 0:
singleItem.recordsTotal = reader.GetSafeInt32(0);
break;
case 1:
singleItem.recordsFiltered = reader.GetSafeInt32(0);
break;
case 2:
AnonUser singleItem2 = new AnonUser();
int startingIndex = 0; //startingOrdinal
singleItem2.Id = reader.GetSafeInt32(startingIndex++);
singleItem2.Email = reader.GetSafeString(startingIndex++);
singleItem2.VisitCount = reader.GetSafeInt32(startingIndex++);
singleItem2.DateCreated = reader.GetSafeDateTime(startingIndex++);
singleItem2.DateModified = reader.GetSafeDateTime(startingIndex++);
if (singleItem.data == null)
{
singleItem.data = new List <AnonUser>();
}
singleItem.data.Add(singleItem2);
break;
default:
singleItem = null;
break;
}
});
return(singleItem);
}
public AnonUser SelectUserByEmail(string Email)
{
AnonUser singleItem = null;
DataProvider.ExecuteCmd("Anon_SelectByEmail"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Email", Email);
}
, singleRecordMapper : delegate(IDataReader reader, short set)
{
singleItem = new AnonUser();
int startingIndex = 0; //startingOrdinal
singleItem.Id = reader.GetSafeInt32(startingIndex++);
singleItem.VisitCount = reader.GetSafeInt32(startingIndex++);
singleItem.DateCreated = reader.GetSafeDateTime(startingIndex++);
});
return(singleItem);
}
