public ActionResult SignUps(ViewByTime time_back, int limit = 3, int skip = 0) { return new CustomJsonResult() { Data = Factory.GetActivityProvider().GetSignUps(time_back, limit,skip), JsonRequestBehavior = JsonRequestBehavior.AllowGet }; }
public DataTable ViewbyTime(ViewByTime viewByTime) { SqlConnection con = new SqlConnection(_conString); // string query = @"SELECT (select Name from Items i where i.Id=s.ItemId ) Name, Sell SaleQuantity FROM SummaryStock s WHERE CreateDate BETWEEN '" + viewByTime.FromDate+"' and '"+viewByTime.ToDate+"'"; string query = @" SELECT (select Name from Items i where i.Id=s.ItemId ) ItemName, Sell SaleQuantity FROM SummaryStock s WHERE s.CreateDate>= '" + viewByTime.FromDate + "' and s.CreateDate<='" + viewByTime.ToDate + "'"; SqlCommand com = new SqlCommand(query, con); con.Open(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(com); da.Fill(dt); con.Close(); return(dt); }
public dynamic GetFilledProfile(ViewByTime time_back, int limit, int skip) { DatingBookDataProvider prov = new DatingBookDataProvider(); long count = 0; //var users = prov.GetUsersWithProfileOrPictures(GetTimeBack(time_back), limit, skip, out count); //var activesUsers = new List<BsonDocument>(); //DateTime now = DateTime.UtcNow; //foreach (var deatuhorized in deauthorizers) //{ // //handle when unknown deatuhorized date // deatuhorized["deauthorized_date"] = deatuhorized["date_modified"]; // //signup["_id"] = signup["_id"].ToString(); // deatuhorized.Add("age", (int)((now - deatuhorized["birthday"].AsDateTime).TotalDays / 365)); // deatuhorized.Remove("birthday"); //} return new { // items = deauthorizers, total = count }; }
public dynamic GetDeauthorizedUsers(ViewByTime timeBack, int limit, int skip) { ActivityDataProvider prov = new ActivityDataProvider(); long count; var deauthorizers = prov.GetDeauthorized(GetTimeBack(timeBack), limit, skip, out count); var activesUsers = new List<BsonDocument>(); DateTime now = DateTime.UtcNow; foreach (var deatuhorized in deauthorizers) { //handle when unknown deatuhorized date deatuhorized["deauthorized_date"] = deatuhorized["date_modified"]; //signup["_id"] = signup["_id"].ToString(); deatuhorized.Add("age", (int)((now - deatuhorized["birthday"].AsDateTime).TotalDays / 365)); deatuhorized.Remove("birthday"); } return new { items = deauthorizers, total = count }; }
public dynamic GetMostActive(ViewByTime timeBack, int limit, int skip) { ActivityDataProvider prov = new ActivityDataProvider(); long count; var actives = prov.GetMostActive(GetTimeBack(timeBack), limit,skip, out count); var activesUsers = new List<BsonDocument>(); DatingBookDataProvider datingDal = new DatingBookDataProvider(); foreach (var active in actives) { var bsonDoc = datingDal.GetDatingBookUser(active["Key"].AsObjectId, "fname", "lname", "fbid", "gender", "birthday", "last_visit"); if (bsonDoc != null) { //bsonDoc["_id"] = bsonDoc["_id"].ToString(); bsonDoc = GetUserForDisplay(bsonDoc); bsonDoc.Add("visits_count", active["Value"]); activesUsers.Add(bsonDoc); } } return new { items = activesUsers, total = count }; }
public dynamic GetRecentMessageSessions(ViewByTime timeBack, int limit, int skip) { ActivityDataProvider prov = new ActivityDataProvider(); long count; var messageSessions = prov.GetMessageSessions(GetTimeBack(timeBack), limit, skip, out count); DateTime now = DateTime.UtcNow; DatingBookDataProvider datingDal = new DatingBookDataProvider(); foreach (var session in messageSessions) { var user1 = datingDal.GetDatingBookUser(session["user_1"].AsObjectId, "fname", "lname", "fbid", "gender", "birthday", "last_visit"); user1 = GetUserForDisplay(user1); var user2 = datingDal.GetDatingBookUser(session["user_2"].AsObjectId, "fname", "lname", "fbid", "gender", "birthday", "last_visit"); user2 = GetUserForDisplay(user2); session["user_1"] = user1; session["user_2"] = user2; session["messages_count"] = session["messages"].AsBsonArray.Count; session.Remove("messages"); } return new { items = messageSessions, total = count }; }
private DateTime GetTimeBack(ViewByTime timeback) { var currentTime = DateTime.UtcNow; switch (timeback) { case ViewByTime.Today: return new DateTime(currentTime.Year, currentTime.Month, currentTime.Day, 0, 0, 0); case ViewByTime.Yesterday: return currentTime.Date.AddDays(-1.0); case ViewByTime.InTheLastWeek: return currentTime.Date.AddDays(-7); case ViewByTime.InTheLastMonth: return currentTime.Date.AddMonths(-1); case ViewByTime.None: default: return currentTime; } }
public dynamic GetSignUps(ViewByTime timeBack, int limit, int skip) { ActivityDataProvider prov = new ActivityDataProvider(); long count; var signUps = prov.GetSignUps(GetTimeBack(timeBack), limit,skip, out count); DateTime now = DateTime.UtcNow; foreach (var signup in signUps) { //signup["_id"] = signup["_id"].ToString(); signup.Add("age", (int)((now - signup["birthday"].AsDateTime).TotalDays / 365)); signup.Remove("birthday"); } return new { items = signUps, total = count }; }
public DataTable ViewbyTime(ViewByTime viewByTime) { return(_viewByTimeGetway.ViewbyTime(viewByTime)); }