public ActionResult Add() { TitlesModel title = new TitlesModel(); title.pubNames = GetpubNames(); title.authorNames = GetauthorNames(); return(View(title)); }
public ActionResult Index(TitlesModel titleMode) { if (ModelState.IsValid) { ViewBag.Titles = repository.GetTitlesByName(titleMode.TitleName); } return View("Index"); }
public ActionResult Add(TitlesModel title) { 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", title.pubID); cmd.Parameters.AddWithValue("@authorID", title.authorID); cmd.Parameters.AddWithValue("@titleName", title.titleName); cmd.Parameters.AddWithValue("@titlePrice", title.titlePrice); cmd.Parameters.AddWithValue("@titlePubDate", DateTime.Now); cmd.Parameters.AddWithValue("@titleNotes", title.titleNotes); cmd.ExecuteNonQuery(); return(RedirectToAction("Index")); } } }
// // GET: /Titles/ public ActionResult Index() { List <TitlesModel> list = new List <TitlesModel>(); using (SqlConnection con = new SqlConnection(Helper.GetCon())) { con.Open(); string query = @"SELECT t.titleID, p.pubName, a.authorFN, a.authorLN, t.titleName, t.titlePrice, t.titlePubDate, t.titleNotes FROM titles t INNER JOIN publishers p ON t.pubID = p.pubID INNER JOIN authors a ON t.authorID = a.authorID"; using (SqlCommand cmd = new SqlCommand(query, con)) { using (SqlDataReader data = cmd.ExecuteReader()) { DataTable dt = new DataTable(); dt.Load(data); foreach (DataRow dr in dt.Rows) { var title = new TitlesModel(); title.titleID = Convert.ToInt32(dr["titleID"].ToString()); title.pubName = dr["pubName"].ToString(); title.authorFN = dr["authorFN"].ToString(); title.authorLN = dr["authorLN"].ToString(); title.titleName = dr["titleName"].ToString(); title.titlePrice = dr["titlePrice"].ToString(); title.titlePubDate = DateTime.Parse(dr["titlePubDate"].ToString()); title.titleNotes = dr["titleNotes"].ToString(); list.Add(title); } } } } return(View(list)); }