public IEnumerable <DVDDetailView> FindByTitle(string title)
{
List <DVDDetailView> FinalResult = new List <DVDDetailView>();
DVDLibraryEntities Libris = new DVDLibraryEntities();
var results = from d in Libris.DVDs
where d.Title.Contains(title)
select d;
foreach (DVD r in results)
{
DVDDetailView current = new DVDDetailView();
current.DVDID = r.DVDID;
current.Title = r.Title;
current.Director = r.Director;
current.RatingID = r.RatingID;
current.RatingName = r.Rating.RatingName;
current.realeaseYear = r.realeaseYear;
current.realeaseYear = r.realeaseYear;
if (Libris.Notes.Where(n => n.DVDID == r.DVDID).FirstOrDefault().Notes != null)
{
current.Note = Libris.Notes.Where(n => n.DVDID == r.DVDID).FirstOrDefault().Notes;
}
FinalResult.Add(current);
}
return(FinalResult);
}
public DVDDetailView GetByID(int ID) //works
{
DVDLibraryEntities Libris = new DVDLibraryEntities();
DVD result = Libris.DVDs.Where(d => d.DVDID == ID).FirstOrDefault();
if (Libris.Notes.Where(n => n.DVDID == ID).FirstOrDefault().Notes == null)
{
result.Note = "no note";
}
else
{
result.Note = Libris.Notes.Where(n => n.DVDID == ID).FirstOrDefault().Notes;
}
DVDDetailView Selected = new DVDDetailView
{
DVDID = result.DVDID,
Director = result.Director,
RatingName = result.Rating.RatingName,
RatingID = result.RatingID,
realeaseYear = result.realeaseYear,
Title = result.Title,
Note = result.Note
};
return(Selected);
}
public IEnumerable <DVDDetailView> FindbyYear(int year)
{
List <DVDDetailView> FinalResult = new List <DVDDetailView>();
DVDLibraryEntities Libris = new DVDLibraryEntities();
var results = from d in Libris.DVDs
where d.realeaseYear == year
select d;
foreach (DVD r in results)
{
DVDDetailView current = new DVDDetailView();
current.DVDID = r.DVDID;
current.Title = r.Title;
current.Director = r.Director;
current.RatingID = r.RatingID;
current.RatingName = r.Rating.RatingName;
current.realeaseYear = r.realeaseYear;
if (!string.IsNullOrEmpty(Libris.Notes.Where(n => n.DVDID == r.DVDID).FirstOrDefault().Notes))
{
current.Note = Libris.Notes.Where(n => n.DVDID == r.DVDID).FirstOrDefault().Notes;
}
FinalResult.Add(current);
}
return(FinalResult);
}
public IEnumerable <DVDDetailView> FindByTitle(string title)
{
List <DVDDetailView> results = new List <DVDDetailView>();
using (SqlConnection cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("GetDVDsByTitle", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", title);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
DVDDetailView current = new DVDDetailView();
current.DVDID = (int)dr["DVDID"];
current.Title = dr["Title"].ToString();
current.Director = dr["Director"].ToString();
current.RatingID = (int)dr["RatingID"];
current.RatingName = dr["RatingName"].ToString();
current.realeaseYear = (int)dr["realeaseYear"];
current.Note = dr["Note"].ToString();
results.Add(current);
}
}
}
return(results);
}
public DVDDetailView GetByID(int ID)
{
DVDDetailView Selected = null;
using (SqlConnection cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("SelectByDVDID", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DVDID", ID);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
Selected = new DVDDetailView();
Selected.DVDID = (int)dr["DVDID"];
Selected.Title = dr["Title"].ToString();
Selected.Director = dr["Director"].ToString();
Selected.RatingID = (int)dr["RatingID"];
Selected.RatingName = dr["RatingName"].ToString();
Selected.realeaseYear = (int)dr["realeaseYear"];
Selected.Note = dr["Note"].ToString();
}
}
}
return(Selected);
}
public DVDDetailView GetByID(int id)
{
DVD result = _DVDs.Where(d => d.DVDID == id).FirstOrDefault();
DVDDetailView Selected = new DVDDetailView
{
DVDID = result.DVDID,
Director = result.Director,
RatingName = result.Rating.RatingName,
RatingID = result.RatingID,
realeaseYear = result.realeaseYear,
Title = result.Title,
Note = result.Note
};
return(Selected);
}
