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