public ActionResult About()
{
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 = "title";
cd.Body = "Body";
cd.Footer = "Footer";
CMEntities cm = new CMEntities(connString.ConnectionString);
cm.AddToCreativeDetails(cd);
cm.SaveChanges();
return View();
}
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);
}
