public ActionResult _SliderPartial()
{
List <Slider> Records = Slider.
Query("Where Status=1").ToList();
if (Records.Any())
{
foreach (var i in Records)
{
string avatar = i.Image == null ? "" : i.Image;
if (System.IO.File.Exists(Server.MapPath(avatar)))
{
avatar = CreateThumb.ResizeImage(new[] { avatar, "thumb", "800", "1800", "", "4" });
}
i.Image = avatar;
}
}
ViewBag.Sliders = Records;
return(PartialView());
}
public ActionResult _GalleryPartial()
{
List <DogImageAndVideo_View00> Records = DogImageAndVideo_View00.
//Query("Select Top 12 * From Dog Where status=1 Order By NEWID()").ToList();
Query("select * from(select *, r = row_number() over(partition by Type Order By Name)from DogImageAndVideo_View00) a where r <= 4 Order By NEWID()").ToList();
if (Records.Any())
{
foreach (var i in Records.Where(c => c.Type == 1))
{
string avatar = i.Url == null ? "" : i.Url;
if (System.IO.File.Exists(Server.MapPath(avatar)))
{
avatar = CreateThumb.ResizeImage(new[] { avatar, "thumb", "800", "800", "", "4" });
}
i.Url = i.Url + "|" + avatar;
}
}
ViewBag.Dogs = Records;
return(PartialView());
}