public object Count()
{
DateTime startTime = DateTime.Now;
const string viewName = "vw_allAds";
List<string> images = new List<string>();
var db = new Database();
var result = db.ExecuteScalar(string.Format("SELECT COUNT(id) FROM {0}", viewName));
db.Dispose();
return new
{
TimeStamp = (int)Math.Truncate((DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds),
TimeConsumed = (DateTime.Now - startTime).TotalMilliseconds,
Status = "Success",
Result = new { Count = result }
};
}
