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