public ActionResult Add()
{
TitlesModels titles = new TitlesModels();
titles.Publishers = GetCategories();
titles.Authors = GetCategories1();
return(View(titles));
}
public ActionResult Add()
{
TitlesModels title = new TitlesModels();
title.Publishers = GetPublishers();
title.Authors = GetAuthors();
return(View(title));
}
public ActionResult Add(TitlesModels titles)
{
using (SqlConnection con = new SqlConnection(Helper.GetCon()))
{
con.Open();
string query = @"INSERT INTO Titles VALUES
(@pubID, @authorID, @titleName, @titlePrice, @titlePubDate, @titleNotes)";
using (SqlCommand cmd = new SqlCommand(query, con))
{
cmd.Parameters.AddWithValue("@pubID", titles.PubID);
cmd.Parameters.AddWithValue("@authorID", titles.AuthorID);
cmd.Parameters.AddWithValue("@titleName", titles.Name);
cmd.Parameters.AddWithValue("@titlePrice", titles.Price);
cmd.Parameters.AddWithValue("@titlePubDate", titles.PubDate);
cmd.Parameters.AddWithValue("@titleNotes", titles.Notes);
cmd.ExecuteNonQuery();
return(RedirectToAction("Index"));
}
}
}
