public void AddToonOfDay(CartoonOfTheDay toonToAdd)
{
var repo = ToonOfDayFactory.CreateToonOfDayRepository();
toonToAdd.WhenPosted = DateTime.Today;
repo.AddToonOfDay(toonToAdd);
}
public void AddToonOfDay(CartoonOfTheDay toonToAdd)
{
using (var cn = new SqlConnection(_connectiionString))
{
var cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText =
@"INSERT INTO CartoonOfTheDay(Author, ShowName, Season, Episode, Approved, DateCreated, ImgUrl, WhenPosted, HasNotBeenPosted)
VALUES (@Author, @ShowName, @Season, @Episode, @Approved, @DateCreated, @ImgUrl, @WhenPosted, @HasNotBeenPosted)";
cmd.Parameters.AddWithValue("@Author", toonToAdd.Author);
cmd.Parameters.AddWithValue("@ShowName", toonToAdd.ShowName);
cmd.Parameters.AddWithValue("@Season", toonToAdd.Season);
cmd.Parameters.AddWithValue("@Episode", toonToAdd.Episode);
cmd.Parameters.AddWithValue("@Approved", toonToAdd.Approved);
cmd.Parameters.AddWithValue("@DateCreated", toonToAdd.DateCreated);
cmd.Parameters.AddWithValue("@ImgUrl", toonToAdd.ImgUrl);
cmd.Parameters.AddWithValue("@WhenPosted", toonToAdd.WhenPosted);
cmd.Parameters.AddWithValue("@HasNotBeenPosted", toonToAdd.HasNotBeenPosted);
cn.Open();
cmd.ExecuteNonQuery();
}
}
public void EditToonOfDay(CartoonOfTheDay toonToEdit)
{
using (var cn = new SqlConnection(_connectiionString))
{
var cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText =
@"UPDATE CartoonOfTheDay
SET Author = @Author, ShowName = @ShowName, Season = @Season, Episode = @Episode, Approved = @Approved, DateCreated = @DateCreated, ImgUrl = @ImgUrl, WhenPosted = @WhenPosted, HasNotBeenPosted = @HasNotBeenPosted
WHERE CotDId = @CotDId";
cmd.Parameters.AddWithValue("@CotDId", toonToEdit.Id);
cmd.Parameters.AddWithValue("@Author", toonToEdit.Author);
cmd.Parameters.AddWithValue("@ShowName", toonToEdit.ShowName);
cmd.Parameters.AddWithValue("@Season", toonToEdit.Season);
cmd.Parameters.AddWithValue("@Episode", toonToEdit.Episode);
cmd.Parameters.AddWithValue("@Approved", toonToEdit.Approved);
cmd.Parameters.AddWithValue("@DateCreated", toonToEdit.DateCreated);
cmd.Parameters.AddWithValue("@ImgUrl", toonToEdit.ImgUrl);
cmd.Parameters.AddWithValue("@WhenPosted", toonToEdit.WhenPosted);
cmd.Parameters.AddWithValue("@HasNotBeenPosted", toonToEdit.HasNotBeenPosted);
cn.Open();
cmd.ExecuteNonQuery();
}
}
public ActionResult AdminApproveToon(CartoonOfTheDay toon)
{
var manager = new ToonOfTheDayManager();
manager.EditToonOfDay(toon);
return(RedirectToAction("AdminViewToonOfTheDaySubmissions"));
}
public ActionResult AdminDeleteToon(CartoonOfTheDay toon)
{
var manager = new ToonOfTheDayManager();
manager.RemoveToonOfDay(toon);
return(RedirectToAction("ManageToonOfTheDay"));
}
public void addToonCheckTheDelete()
{
var repo = ToonOfDayFactory.CreateToonOfDayRepository();
CartoonOfTheDay toon = new CartoonOfTheDay();
var filename = "img.png";
toon.ShowName = "That show";
toon.Season = 1;
toon.Episode = 1;
toon.DateCreated = DateTime.Today;
toon.Author = "Derrek";
toon.Approved = Approved.Yes;
toon.ImgUrl = "" + filename;
toon.WhenPosted = DateTime.Today;
toon.HasNotBeenPosted = false;
repo.AddToonOfDay(toon);
List <CartoonOfTheDay> toons = repo.GetAllToons();
CartoonOfTheDay check = toons.Last();
Assert.AreEqual("Derrek", check.Author);
Assert.AreEqual("That show", check.ShowName);
repo.RemoveToonOfDay(toon);
// check that this toon is no longer in database
Assert.IsNull(repo.GetPostByID(toon.Id));
}
public void EditToonOfDay(CartoonOfTheDay toonToEdit)
{
var post = _toons.FirstOrDefault(p => p.Id == toonToEdit.Id);
_toons.Remove(post);
post = toonToEdit;
_toons.Add(post);
}
public ActionResult EmployeeEditToon(CartoonOfTheDay toon)
{
if (ModelState.IsValid)
{
var manager = new ToonOfTheDayManager();
manager.RemoveToonOfDay(toon);
return(RedirectToAction("ManageToonOfTheDay", "Employee"));
}
return(View("EmployeeEditToon"));
}
public ActionResult AdminEditToon(CartoonOfTheDay toon)
{
if (ModelState.IsValid)
{
var manager = new ToonOfTheDayManager();
manager.EditToonOfDay(toon);
return(RedirectToAction("ManageToonOfTheDay"));
}
return(View("AdminEditToon"));
}
public void RemoveToonOfDay(CartoonOfTheDay toonToRemove)
{
using (var cn = new SqlConnection(_connectiionString))
{
var cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText =
@"DELETE FROM CartoonOfTheDay
WHERE CotDId = @CotDId";
cmd.Parameters.AddWithValue("@CotDId", toonToRemove.Id);
cn.Open();
cmd.ExecuteNonQuery();
}
}
private CartoonOfTheDay ConvertReaderToToon(SqlDataReader dr)
{
ToonSaloon.Models.CartoonOfTheDay newToon = new CartoonOfTheDay
{
Id = (int)dr["CotDId"],
Author = dr["Author"].ToString(),
ShowName = dr["ShowName"].ToString(),
Season = (int)dr["Season"],
Episode = (int)dr["Episode"],
Approved = (Approved)dr["Approved"],
DateCreated = (DateTime)dr["DateCreated"],
WhenPosted = (DateTime)dr["WhenPosted"],
HasNotBeenPosted = (bool)dr["HasNotBeenPosted"],
ImgUrl = dr["ImgUrl"].ToString()
};
return(newToon);
}
public ActionResult AdminAddToon(CartoonOfTheDay toon, HttpPostedFileBase file)
{
if (ModelState.IsValid)
{
var filename = System.IO.Path.GetFileName(file.FileName);
var path = System.IO.Path.Combine(Server.MapPath("../Images/appimages"), filename);
file.SaveAs(path);
toon.ImgUrl = "../../Images/appimages/" + filename;
toon.Approved = Approved.Yes;
toon.DateCreated = DateTime.Today;
var manager = new ToonOfTheDayManager();
manager.AddToonOfDay(toon);
return(RedirectToAction("ManageToonOfTheDay"));
}
return(View("AdminAddToon"));
}
public void EditToonOfDay(CartoonOfTheDay toonToEdit)
{
var repo = ToonOfDayFactory.CreateToonOfDayRepository();
repo.EditToonOfDay(toonToEdit);
}
public void RemoveToonOfDay(CartoonOfTheDay toonToRemove)
{
var repo = ToonOfDayFactory.CreateToonOfDayRepository();
repo.RemoveToonOfDay(toonToRemove);
}
public void RemoveToonOfDay(CartoonOfTheDay toonToRemove)
{
var result = _toons.FirstOrDefault(p => p.Id == toonToRemove.Id);
_toons.Remove(result);
}
public void AddToonOfDay(CartoonOfTheDay toonToAdd)
{
_toons.Add(toonToAdd);
}
