public static bool AddNews(ViewModels.AddNewsViewModel news)
{
string conString = WebConfigurationManager.ConnectionStrings["FrozenCrittersDb"].ConnectionString;
SqlConnection con = new SqlConnection(conString);
SqlCommand addNews = new SqlCommand();
addNews.CommandText = "INSERT INTO News (NewsTitle, NewsDescription, NewsPostDate, NewsExpirationDate) VALUES (@NewsTitle, @NewsDescription, @NewsPostDate, @NewsExpirationDate)";
addNews.Connection = con;
addNews.Parameters.AddWithValue("@NewsTitle", news.NewsTitle);
addNews.Parameters.AddWithValue("@NewsDescription", news.NewsDescription);
addNews.Parameters.AddWithValue("@NewsPostDate", news.NewsPostDate);
addNews.Parameters.AddWithValue("@NewsExpirationDate", news.NewsExpirationDate);
try
{
con.Open();
int rows = addNews.ExecuteNonQuery();
if (rows == 1)
{
return(true);
}
else
{
return(false);
}
}
finally
{
con.Dispose();
}
}
public ActionResult AddNews(ViewModels.AddNewsViewModel news)
{
if (ModelState.IsValid)
{
if (Models.FrozenCrittersDb.AddNews(news))
{
return(RedirectToAction("Index", "Admin"));
}
}
return(View());
}
