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));
}
