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