public ActionResult Index() { DataBaseForHome Data = new DataBaseForHome(); if (db.Ads.Where(w => w.StartDate < DateTime.Now && w.EndDate > DateTime.Now).OrderByDescending(w => w.StartDate).Count() >= 20) { Data.Elanler = db.Ads.Where(w => w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).Take(AdCount).ToList(); } else { Data.Elanler = db.Ads.Where(w => w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).ToList(); } Data.Agentler = db.Agents.ToList(); if (db.Ads.Where(w => w.VIP == true && w.StartDate < DateTime.Now && w.EndDate > DateTime.Now).OrderByDescending(w => w.StartDate).Count() >= 40) { Data.VipElanlar = db.Ads.Where(w => w.VIP == true && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).Take(VipCount).ToList(); } else { Data.VipElanlar = db.Ads.Where(w => w.VIP == true && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).ToList(); } Data.Sekiller = db.Images.ToList(); Data.TamSiyahi = db.Ads.ToList(); return(View(Data)); }
// GET: Agent public ActionResult Index(int id) { DataBaseForHome data = new DataBaseForHome(); data.Elanler = db.Ads.Where(w => w.AgentId == id && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).ToList(); data.Sekiller = db.Images.ToList(); return(View(data)); }
public ActionResult MenuSearch(int id) { DataBaseForHome data = new DataBaseForHome(); data.Agentler = db.Agents.ToList(); data.Elanler = db.Ads.Where(w => w.RegionId == id && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).ToList(); data.Sekiller = db.Images.ToList(); data.VipElanlar = db.Ads.Where(w => w.VIP == true && w.RegionId == id && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).ToList(); if (data.VipElanlar.Count < 1) { data.VipElanlar = db.Ads.Where(w => w.VIP == true && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).ToList(); } return(View(data)); }
// GET: AdPage public ActionResult Index(int id) { DataBaseForHome data = new DataBaseForHome(); data.TamSiyahi = db.Ads.Where(w => w.Id == id).ToList(); data.Sekiller = db.Images.ToList(); if (db.Ads.Where(w => w.VIP == true && w.StartDate < DateTime.Now && w.EndDate > DateTime.Now).OrderByDescending(w => w.StartDate).Count() >= 9) { data.Elanler = db.Ads.Where(w => w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).Take(9).ToList(); } else { data.Elanler = db.Ads.Where(w => w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).ToList(); } return(View(data)); }
public ActionResult Vip() { alaparSql2Entities db = new alaparSql2Entities(); DataBaseForHome data = new DataBaseForHome(); if (db.Ads.Where(w => w.VIP == true && w.StartDate < DateTime.Now && w.EndDate > DateTime.Now).Count() >= 20) { data.Elanler = db.Ads.Where(w => w.VIP == true && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).Take(20).ToList(); } else { data.Elanler = db.Ads.Where(w => w.VIP == true && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).ToList(); } data.Sekiller = db.Images.ToList(); data.TamSiyahi = db.Ads.Where(w => w.VIP == true && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).ToList(); return(View(data)); }
public ActionResult Category(int id, int room) { DataBaseForHome data = new DataBaseForHome(); data.Agentler = db.Agents.ToList(); if (room == 0) { data.Elanler = db.Ads.Where(w => w.CategoryId == id && w.StartDate < DateTime.Now).ToList(); data.Sekiller = db.Images.ToList(); data.VipElanlar = db.Ads.Where(w => w.VIP == true && w.CategoryId == id && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).ToList(); if (data.VipElanlar.Count < 1) { data.VipElanlar = db.Ads.Where(w => w.VIP == true && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).ToList(); } } else { if (room < 5) { data.Elanler = db.Ads.Where(w => w.CategoryId == id & w.RoomId == room && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).ToList(); data.Sekiller = db.Images.ToList(); data.VipElanlar = db.Ads.Where(w => w.VIP == true && w.CategoryId == id && w.RoomId == room && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).ToList(); if (data.VipElanlar.Count < 1) { data.VipElanlar = db.Ads.Where(w => w.VIP == true && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).ToList(); } } else if (room == 5) { data.Elanler = db.Ads.Where(w => w.CategoryId == id & w.RoomId >= room && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).ToList(); data.Sekiller = db.Images.ToList(); data.VipElanlar = db.Ads.Where(w => w.VIP == true && w.CategoryId == id && w.RoomId >= room && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).ToList(); if (data.VipElanlar.Count < 1) { data.VipElanlar = db.Ads.Where(w => w.VIP == true && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).OrderByDescending(w => w.StartDate).ToList(); } } } return(View(data)); }