Esempio n. 1
0
        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 }
            };
        }
Esempio n. 2
0
        public object All()
        {
            DateTime startTime = DateTime.Now;
            List<Ad> ads = new List<Ad>();
            var db = new Database();
            using (var result = db.View("vw_allAds"))
            {
                while (result.Read())
                {

                    ads.Add(new Ad
                    {
                        Id = result.GetInt32(0),
                        UniqueId = result.GetString(1),
                        Title = result.GetString(2),
                        Location = result.GetString(3),
                        AdId = result.GetString(4),
                        Price = result.GetString(5),
                        Seller = result.GetString(6),
                        SellerContact = result.GetString(7),
                        Description = result.GetString(8),
                        Type = result.GetString(9),
                        HasPictures = result.GetBoolean(10),
                        AddedOn = result.GetDateTime(11),
                        Url = result.GetString(12)
                    });
                }

            }
            db.Dispose();

            return new
            {
                TimeStamp = (int)Math.Truncate((DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds),
                TimeConsumed = (DateTime.Now - startTime).TotalMilliseconds,
                TotalRecords = ads.Count,
                Status = "Success",
                Result = ads.OrderBy(x => x.Id).ToList()
            };
        }
Esempio n. 3
0
        public object Images(string uniqueId)
        {
            DateTime startTime = DateTime.Now;
            const string guidPattern = @"\b[A-F0-9]{8}(?:-[A-F0-9]{4}){3}-[A-F0-9]{12}\b";
            Regex regex = new Regex(guidPattern, RegexOptions.IgnoreCase);

            if (regex.IsMatch(uniqueId))
            {

                List<string> images = new List<string>();
                var db = new Database();
                using (var result = db.ViewWithCondition("vw_imgs", string.Format("uniqueId = '{0}' and url not like '%nophoto%'", uniqueId)))
                {
                    while (result.Read())
                    {
                        images.Add(result.GetString(2));
                    }

                }
                db.Dispose();

                return new
                {
                    TimeStamp = (int)Math.Truncate((DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds),
                    TimeConsumed = (DateTime.Now - startTime).TotalMilliseconds,
                    TotalRecords = images.Count,
                    Status = "Success",
                    Result = new { UniqueId = uniqueId, Images = images }
                };
            }

            return new
            {
                TimeStamp = (int)Math.Truncate((DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds),
                TimeConsumed = (DateTime.Now - startTime).TotalMilliseconds,
                Status = "Error",
                Result = "Invalid Unique Id"
            };
        }