public ActionResult Available()
{
var entities = new DataEntities();
var latestFeatureDate = entities.Dogs.Max(d => d.DateFeatured);
var dogs = (
from dog in entities.Dogs
where !dog.AdoptedDate.HasValue
orderby dog.DateFeatured descending
select new {
dog.DogId, dog.Profile, dog.Name, dog.Birthday,
dog.DateFeatured, dog.Breed, dog.Gender }
).ToList();
return View(
from dog in dogs
select new AdoptableDogViewModel
{
Id = dog.DogId,
Profile = dog.Profile,
ImageUrl = Url.Action("Image", new { id = dog.DogId }),
ThumbnailUrl = Url.Action(
"Thumbnail", new { id = dog.DogId }),
Name = dog.Name,
Age = GetDogAge(dog.Birthday ?? DateTime.Today),
Featured =
dog.DateFeatured.HasValue
&& dog.DateFeatured == latestFeatureDate,
Breed = dog.Breed,
Gender = (dog.Gender ?? "m").ToLower() == "m" ? "Male" : "Female"
}
);
}
protected override void OnResultExecuting(
ResultExecutingContext filterContext)
{
// Add "Dog of the Week" info to the view bag
var dog = new DataEntities()
.Dogs
.OrderByDescending(d => d.DateFeatured)
.Select(d => new
{
Id = d.DogId,
Name = d.Name,
Birthday = d.Birthday, Breed = d.Breed,
})
.FirstOrDefault();
ViewBag.DogOfTheWeek = new DogOfTheWeekSummaryViewModel {
Id = dog.Id,
Name = dog.Name,
ThumbnailUrl = Url.Action(
"Image", "Dog", new { id = dog.Id }),
Age = GetDogAge(dog.Birthday ?? DateTime.Now),
Breed = dog.Breed
};
ViewBag.SupportsTelUrls = Request.Browser.CanInitiateVoiceCall;
base.OnResultExecuting(filterContext);
}
//
// GET: /NewsStory/Delete/5
public ActionResult Delete(Guid id)
{
var _db = new DataEntities();
var story = _db.NewsStories.FirstOrDefault(n => n.NewsStoryId == id);
return View(story);
}
//
// GET: /Events/Details/5
public ActionResult Details(Guid id)
{
var _db = new DataEntities();
var evt = _db.Events.FirstOrDefault(e => e.EventId == id);
return View(evt);
}
public ActionResult Create(SpecialNeedsStory story)
{
ViewBag.exMsg = "";
try
{
if (!ModelState.IsValid) return View();
// we need to gen the primary key
story.SpecialNeedsStoryId = Guid.NewGuid();
if (Request.Files != null & Request.Files.Count > 0)
{
HttpPostedFileBase storyImageFile = Request.Files["image"];
if (storyImageFile != null)
story.Image = ImageUtils.GetBytes(storyImageFile.InputStream);
}
// Add and Save
var _db = new DataEntities();
_db.SpecialNeedsStories.AddObject(story);
_db.SaveChanges();
return RedirectToAction("Index");
}
catch (Exception ex)
{
ViewBag.exMsg = ex.Message;
return View();
}
}
public ActionResult Delete(Guid id)
{
var _db = new DataEntities();
var content = _db.Contents.FirstOrDefault(e => e.ContentId == id);
return View(content);
}
public ActionResult Image(Guid id)
{
var dog = new DataEntities()
.Dogs
.FirstOrDefault(d => d.DogId == id);
if (dog == null || dog.Image == null)
{
return File(Server.MapPath("~/content/images/default-dog-pic.png"), "image/png");
}
else
{
return File(dog.Image, "image/jpeg");
}
}
public ActionResult SpecialNeedsImage(Guid id)
{
var story = new DataEntities()
.SpecialNeedsStories
.FirstOrDefault(s => s.SpecialNeedsStoryId == id);
if (story == null || story.Image == null)
{
return HttpNotFound();
}
else
{
return File(story.Image, "image/jpeg");
}
}
public ActionResult Delete(Guid id, FormCollection collection)
{
try
{
var _db = new DataEntities();
var story = _db.NewsStories.FirstOrDefault(n => n.NewsStoryId == id);
_db.DeleteObject(story);
_db.SaveChanges();
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public ActionResult Delete(Guid id, FormCollection collection)
{
try
{
var _db = new DataEntities();
var content = _db.Contents.FirstOrDefault(e => e.ContentId == id);
_db.DeleteObject(content);
_db.SaveChanges();
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public ActionResult Index()
{
var entities = new DataEntities();
var news =
from article in entities
.NewsStories
.OrderByDescending(s => s.DateCreated)
.Take(10)
.ToList()
select new NewsOrEventViewModel
{
Id = article.NewsStoryId,
Date = article.Date,
Title = article.Title,
Summary = article.Text,
IsEvent = false,
SortDate = article.DateCreated
};
var events =
from evt in entities
.Events
.OrderByDescending(e => e.DateCreated)
.Take(10)
.ToList()
select new NewsOrEventViewModel
{
Id = evt.EventId,
Date = evt.Date,
Location = evt.Location,
Title = evt.Name,
Summary = evt.Description,
IsEvent = true,
IsUpcoming =
evt.DateCreated.HasValue
&& evt.DateCreated > DateTime.Now,
SortDate = evt.DateCreated
};
return View(
events
.Concat(news)
.OrderByDescending(i => i.SortDate)
.Take(10));
}
public ActionResult Create(Content content)
{
ViewBag.exMsg = "";
try
{
if (!ModelState.IsValid) return View();
// we need to gen the primary key
content.ContentId = Guid.NewGuid();
// Add and Save
var _db = new DataEntities();
_db.Contents.AddObject(content);
_db.SaveChanges();
return RedirectToAction("Index");
}
catch (Exception ex)
{
ViewBag.exMsg = ex.Message;
return View();
}
}
//
// GET: /SpecialNeedsStories/Edit/5
public ActionResult Edit(Guid id)
{
ViewBag.FormType = "Edit";
var _db = new DataEntities();
var sns = _db.SpecialNeedsStories.FirstOrDefault(n => n.SpecialNeedsStoryId == id);
return View(sns);
}
public ActionResult Index()
{
var _db = new DataEntities();
var contents = _db.Contents;
return View(contents);
}
public ActionResult Edit(Guid id, FormCollection collection)
{
ViewBag.FormType = "Edit";
ViewBag.exMsg = "";
try
{
if (!ModelState.IsValid) return View();
var _db = new DataEntities();
var content = _db.Contents.FirstOrDefault(e => e.ContentId == id);
UpdateModel(content, collection);
_db.SaveChanges();
return RedirectToAction("Index");
}
catch (Exception ex)
{
ViewBag.exMsg = ex.Message;
return View();
}
}
//
// GET: /Events/
public ActionResult Index()
{
var _db = new DataEntities();
var events = _db.Events.OrderByDescending(e => e.DateCreated);
return View(events);
}
//
// GET: /NewsStory/Edit/5
public ActionResult Edit(Guid id)
{
ViewBag.FormType = "Edit";
var _db = new DataEntities();
var story = _db.NewsStories.FirstOrDefault(n => n.NewsStoryId == id);
return View(story);
}
public ActionResult Edit(Guid id, FormCollection collection)
{
ViewBag.FormType = "Edit";
ViewBag.exMsg = "";
try
{
if (!ModelState.IsValid) return View();
var _db = new DataEntities();
var story = _db.SpecialNeedsStories.FirstOrDefault(n => n.SpecialNeedsStoryId == id);
UpdateModel(story, collection);
if (Request.Files != null & Request.Files.Count > 0)
{
HttpPostedFileBase storyImageFile = Request.Files["dogImage"];
if (storyImageFile != null && storyImageFile.ContentLength > 0)
story.Image = ImageUtils.GetBytes(storyImageFile.InputStream);
}
_db.SaveChanges();
return RedirectToAction("Index");
}
catch (Exception ex)
{
ViewBag.exMsg = ex.Message;
return View();
}
}
//
// GET: /SpecialNeedsStories/Details/5
public ActionResult Details(Guid id)
{
var _db = new DataEntities();
var story = _db.SpecialNeedsStories.FirstOrDefault(n => n.SpecialNeedsStoryId == id);
return View(story);
}
public ActionResult Image(Guid id)
{
var _db = new DataEntities();
var story = _db.SpecialNeedsStories.FirstOrDefault(n => n.SpecialNeedsStoryId == id);
if (story == null || story.Image == null)
{
return null;
}
else
{
return File(story.Image, "image/jpeg");
}
}
//
// GET: /SpecialNeedsStories/
public ActionResult Index()
{
var _db = new DataEntities();
var stories = _db.SpecialNeedsStories;
return View(stories);
}
public ActionResult Edit(Guid id)
{
ViewBag.FormType = "Edit";
var _db = new DataEntities();
var content = _db.Contents.FirstOrDefault(e => e.ContentId == id);
return View(content);
}
public ActionResult Index()
{
var entities = new DataEntities();
var news =
from article in entities
.NewsStories
.OrderByDescending(s => s.DateCreated)
.Take(10)
.ToList()
select new NewsOrEventSummaryViewModel
{
Id = article.NewsStoryId,
Date = article.Date,
SortDate = article.DateCreated,
Title = article.Title,
Summary = article.Text.Summarize(200),
};
var events =
from evt in entities
.Events
.OrderByDescending(e => e.DateCreated)
.Take(10)
.ToList()
select new NewsOrEventSummaryViewModel
{
Id = evt.EventId,
Date = evt.Date,
SortDate = evt.DateCreated,
Title = evt.Name,
Summary = evt.Description.Summarize(200),
};
var viewData = new HomeIndexViewModel
{
NewsAndEvents = news
.Concat(events)
.OrderByDescending(i => i.SortDate)
.Take(10),
};
// Load the latest featured dog
var featuredDog = entities
.Dogs
.OrderByDescending(d => d.DateFeatured)
.Where(d => d.DateFeatured.HasValue)
.FirstOrDefault();
if (featuredDog != null)
{
viewData.FeaturedDogId = featuredDog.DogId;
viewData.FeaturedDogThumbnailUrl = Url.Action(
"Thumbnail", "Dog",
new { id = featuredDog.DogId });
viewData.FeaturedDogName = featuredDog.Name;
viewData.FeaturedDogProfile = featuredDog.Profile;
}
var featuredNeed = entities
.SpecialNeedsStories
.Where(s => s.IsFeatured)
.OrderByDescending(s => s.DateCreated)
.FirstOrDefault();
if (featuredNeed != null)
{
viewData.SpecialNeedThumbnailUrl = Url.Action(
"SpecialNeedsImage", "News",
new { id = featuredNeed.SpecialNeedsStoryId });
viewData.SpecialNeedDescription = featuredNeed.Text;
}
else
{
viewData.SpecialNeedDescription = string.Empty;
}
return View(viewData);
}
private static Content GetCurrentContent(string area)
{
var allSponsorContent = new DataEntities().Contents.Where(c => c.Area.ToLower() == area.ToLower()).OrderByDescending(c => c.PublishOn);
var defaultSponsor = allSponsorContent.FirstOrDefault<Content>(c => c.IsDefault == true);
Content content = defaultSponsor;
foreach (var contentItem in allSponsorContent)
{
if (contentItem.PublishOn <= DateTime.Now)
{
if (contentItem.PublishUntil.HasValue)
{
if (contentItem.PublishUntil.Value >= DateTime.Now)
{
// we are in the sweetspot
content = contentItem;
break;
}
else
{
// we are past the publish until date, keep looking
}
}
else
{
// there's a publish on without an end date, so use it
content = contentItem;
break; // take the first one
}
}
}
return content ?? new Content { Markup = "****Coming Soon" };
}
//
// GET: /NewsStory/
public ActionResult Index()
{
var _db = new DataEntities();
var stories = _db.NewsStories.OrderByDescending(n => n.DateCreated);
return View(stories);
}
