public ActionResult CreateNew(CreativeDetailsViewModel creativeDetailsViewModel) { System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/2012dev4good"); System.Configuration.ConnectionStringSettings connString = null; if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0) { connString = rootWebConfig.ConnectionStrings.ConnectionStrings["CMEntities"]; if (connString != null) Console.WriteLine("CMEntities connection string = \"{0}\"", connString.ConnectionString); else Console.WriteLine("No CMEntities connection string"); } CreativeDetail cd = new CreativeDetail(); cd.UserId = 1; cd.Title = creativeDetailsViewModel.Title; cd.Body = creativeDetailsViewModel.Body; cd.Footer = "Footer"; cd.AddedDate = DateTime.UtcNow; cd.UpdateDate = DateTime.UtcNow; CMEntities cm = new CMEntities(connString.ConnectionString); cm.AddToCreativeDetails(cd); cm.SaveChanges(); //send email to moderator SendModeratorEmail(cd); return RedirectToAction("Index", "Home"); }
public ActionResult DisplayArticle(int id) { CMEntities cm = new CMEntities(); var myCreativeDetails = cm.CreativeDetails.Where(c => c.CDId == id); var returnoitems = new List<CreativeDetailsViewModel>(); foreach (var item in myCreativeDetails) { var cdviewModel = new CreativeDetailsViewModel(); cdviewModel.CDId = item.CDId; cdviewModel.Title = item.Title; cdviewModel.Body = item.Body; cdviewModel.UpdateDate = item.UpdateDate; returnoitems.Add(cdviewModel); } return View("MyHistory", returnoitems); }
public ActionResult MyHistory() { CMEntities cm = new CMEntities(); var myCreativeDetails = cm.CreativeDetails.AsQueryable().OrderByDescending(c=>c.UpdateDate); var returnoitems = new List<CreativeDetailsViewModel>(); foreach (var item in myCreativeDetails) { var cdviewModel = new CreativeDetailsViewModel(); cdviewModel.Title = item.Title; cdviewModel.Body = item.Body; cdviewModel.UpdateDate = item.UpdateDate; returnoitems.Add(cdviewModel); } return View(returnoitems); }