public ActionResult CheckIn(DVDInfo id)
{
var manager = new DVDManager();
var response = manager.ReturnDVD(id);
return View("CheckIn", response.Data);
}
public ActionResult CheckOut(DVDInfo id)
{
var manager = new DVDManager();
var response = manager.AddBorrower(id);
var dvd = manager.GetDVDInfo(id.dvdID);
return View("CheckOut", response.Data);
}
public ActionResult CreateDVD(DVDInfo dvd)
{
if (ModelState.IsValid)
{
var manager = new DVDManager();
var response = manager.CreateDVD(dvd);
return View("CreateDVD", response.Data);
}
return View("Create");
}
public void AddBorrower(DVDInfo borrowerInfo)
{
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["DVDLibrary"].ConnectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "AddBorrower";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@dvdID", borrowerInfo.dvdID);
cmd.Parameters.AddWithValue("@BorrowerName", borrowerInfo.BorrowerInfo.Borrower);
cmd.Parameters.AddWithValue("@DateBorrowed", borrowerInfo.BorrowerInfo.DateBorrowed);
cmd.Connection = cn;
cn.Open();
cmd.ExecuteNonQuery();
}
}
public void CreateDVD(DVDInfo DVD)
{
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["DVDLibrary"].ConnectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "CreateDVD";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn;
cmd.Parameters.AddWithValue("@Title", DVD.Title);
cmd.Parameters.AddWithValue("@ReleaseDate", DVD.ReleaseDate);
cmd.Parameters.AddWithValue("@MPAARating", DVD.MPAARating);
cmd.Parameters.AddWithValue("@DirectorsName", DVD.DirectorsName);
cmd.Parameters.AddWithValue("@Studio", DVD.Studio);
cmd.Parameters.AddWithValue("@UserRating", DVD.UserRating);
cmd.Parameters.AddWithValue("@UserNotes", DVD.UserNotes);
cmd.Parameters.AddWithValue("@ActorsInMovie", DVD.ActorsInMovies);
cn.Open();
cmd.ExecuteNonQuery();
}
}
public DVDInfo LoadDVD(int dvdID)
{
List<DVDInfo> dvds = GetAllDVDs();
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["DVDLibrary"].ConnectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "LatestBorrower";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn;
cmd.Parameters.AddWithValue("@dvdID", dvdID);
cn.Open();
DVDInfo dvd = new DVDInfo()
{
BorrowerInfo = new BorrowerInformation()
};
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
dvd = PopulateFromDataReaderBorrowerInfo(dr);
}
}
return dvd;
}
}
private DVDInfo PopulateFromDataReaderBorrowerInfo(SqlDataReader dr)
{
DVDInfo dvd = new DVDInfo()
{
BorrowerInfo = new BorrowerInformation()
};
dvd.dvdID = (int)dr["dvdID"];
dvd.Title = dr["Title"].ToString();
dvd.ReleaseDate = dr["ReleaseDate"].ToString();
dvd.MPAARating = dr["MPAARating"].ToString();
dvd.DirectorsName = dr["DirectorsName"].ToString();
dvd.Studio = dr["Studio"].ToString();
dvd.UserRating = dr["UserRating"].ToString();
dvd.ActorsInMovies = dr["ActorsInMovie"].ToString();
if (dr["UserNotes"] != DBNull.Value)
dvd.UserNotes = dr["UserNotes"].ToString();
if (dr["DateReturned"] == DBNull.Value)
{
dvd.BorrowerInfo.dvdID = dvd.dvdID;
if (dr["BorrowerName"] != DBNull.Value)
dvd.BorrowerInfo.Borrower = dr["BorrowerName"].ToString();
if (dr["DateBorrowed"] != DBNull.Value)
dvd.BorrowerInfo.DateBorrowed = (DateTime)dr["DateBorrowed"];
}
return dvd;
}
private DVDInfo PopulateFromDataReader(SqlDataReader dr)
{
DVDInfo dvd = new DVDInfo();
dvd.dvdID = (int) dr["dvdID"];
dvd.Title = dr["Title"].ToString();
dvd.ReleaseDate = dr["ReleaseDate"].ToString();
dvd.MPAARating = dr["MPAARating"].ToString();
dvd.DirectorsName = dr["DirectorsName"].ToString();
dvd.Studio = dr["Studio"].ToString();
dvd.UserRating = dr["UserRating"].ToString();
dvd.ActorsInMovies = dr["ActorsInMovie"].ToString();
if (dr["UserNotes"] != DBNull.Value)
dvd.UserNotes = dr["UserNotes"].ToString();
return dvd;
}
public ActionResult Create()
{
var models = new DVDInfo();
return View(models);
}