public static string GetAdsInfo() { var output = new StringBuilder(); using (var db = new AdsEntities()) { var ads = db.Ads; foreach (var ad in ads) { var category = "[No Category]"; var town = "[No Town]"; if (ad.Category != null) { category = ad.Category.Name; } if (ad.Town != null) { town = ad.Town.Name; } output.AppendFormat("{0} \r\nStatus: {1} \r\nCategory: {2} \r\nTown: {3} \r\nUser: {4}\r\n\r\n", ad.Title, ad.AdStatus.Status, category, town, ad.AspNetUser.UserName); } return output.ToString(); } }
public static string GetActiveAds() { var output = new StringBuilder(); using (var db = new AdsEntities()) { var activeAds = from a in db.Ads join c in db.Categories on a.CategoryId equals c.Id into catGroup from c in catGroup.DefaultIfEmpty() join t in db.Towns on a.TownId equals t.Id into townsGroup from t in townsGroup.DefaultIfEmpty() join s in db.AdStatuses on a.StatusId equals s.Id where s.Status == "Published" orderby a.Date select new { a.Title, Category = c.Name ?? "[No category]", Town = t.Name ?? "[No town]" }; var serializer = new JavaScriptSerializer(); Console.WriteLine(serializer.Serialize(activeAds)); foreach (var ad in activeAds) { output.AppendLine(ad.ToString()); } return output.ToString(); } }
public static string GetAdsDetails() { var output = new StringBuilder(); using (var db = new AdsEntities()) { var ads = (from a in db.Ads join s in db.AdStatuses on a.StatusId equals s.Id join c in db.Categories on a.CategoryId equals c.Id into categoryGroup from c in categoryGroup.DefaultIfEmpty() join t in db.Towns on a.TownId equals t.Id into townGroup from t in townGroup.DefaultIfEmpty() join u in db.AspNetUsers on a.OwnerId equals u.Id select new { a.Title, s.Status, Category = c.Name ?? "[No category]", Town = t.Name ?? "[No town]", u.UserName }).ToList(); foreach (var ad in ads) { output.AppendLine(ad.ToString()); } return output.ToString(); } }
public static string SelectAllFromAds() { var output = new StringBuilder(); using (var db = new AdsEntities()) { var ads = db.Ads.ToList(); foreach (var ad in ads) { output.AppendFormat("Id: {0} \r\nTitle: {1} \r\nText: {2} \r\nImageDataURL: {3} \r\nOwnerId: {4}" + "\r\nCategoryId: {5} \r\nTownId: {6} \r\nDate: {7} \r\nStatusId: {8}", ad.Id, ad.Title, ad.Text, ad.ImageDataURL, ad.OwnerId, ad.CategoryId, ad.TownId, ad.Date, ad.StatusId); } return output.ToString(); } }
public static string SelectAdsTitle() { var output = new StringBuilder(); using (var db = new AdsEntities()) { var adsTitles = db.Ads.Select(a => a.Title).ToList(); foreach (var title in adsTitles) { output.AppendLine(title); } return output.ToString(); } }
public static string GetAllActiveAds() { var output = new StringBuilder(); using (var db = new AdsEntities()) { var activeAds = db.Ads.ToList() .Where(s => s.AdStatus.Status == "Published").ToList() .OrderBy(o => o.Date) .Select(x => new { x.Title, Category = x.Category == null ? "[No Category]" : x.Category.Name, Town = x.Town == null ? "[No Town]" : x.Town.Name }).ToList(); foreach (var ad in activeAds) { output.AppendLine(ad.ToString()); } return output.ToString(); } }