public bool UpdateDvd(Dvd dvd) { try { using (SqlConnection cnn = new SqlConnection(ADOConnection.CnnString)) { dvd.Director = DirectorFactory.Create().GetDirectorbyId(dvd.DirectorId); dvd.Rating = RatingFactory.Create().GetRatingbyId(dvd.RatingId); SqlCommand cmd = new SqlCommand("DvdUpdate", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@DvdId", SqlDbType.Int).Value = dvd.DvdId; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = dvd.Title; cmd.Parameters.Add("@ReleaseYear", SqlDbType.Int).Value = dvd.ReleaseYear; cmd.Parameters.Add("@DirectorId", SqlDbType.Int).Value = dvd.DirectorId; cmd.Parameters.Add("@RatingId", SqlDbType.Int).Value = dvd.RatingId; cmd.Parameters.Add("@Note", SqlDbType.NVarChar).Value = dvd.Note; if (cnn.State != ConnectionState.Open) { cnn.Open(); } cmd.ExecuteNonQuery(); return(true); } } catch (Exception e) { return(false); } }
public bool UpdateDvd(Dvd dvd) { dvdList.RemoveAll(d => d.DvdId == dvd.DvdId); dvd.Director = DirectorFactory.Create().GetDirectorbyId(dvd.DirectorId); dvd.Rating = RatingFactory.Create().GetRatingbyId(dvd.RatingId); dvdList.Add(dvd); return(true); }
public int InsertDvd(Dvd dvd) { dvd.DvdId = dvdList.Count + 1; dvd.Director = DirectorFactory.Create().GetDirectorbyId(dvd.DirectorId); dvd.Rating = RatingFactory.Create().GetRatingbyId(dvd.RatingId); dvdList.Add(dvd); return(dvd.DvdId); }
public List <Dvd> GetDvdList() { List <Dvd> result = new List <Dvd>(); try { using (SqlConnection cnn = new SqlConnection(ADOConnection.CnnString)) { DataSet dataSet = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter("DvdSelect", cnn); adapter.SelectCommand.CommandType = CommandType.StoredProcedure; if (cnn.State != ConnectionState.Open) { cnn.Open(); } adapter.Fill(dataSet); if (dataSet.Tables.Count > 0) { for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { DataRow r = dataSet.Tables[0].Rows[i]; Rating rate = RatingFactory.Create().GetRatingbyId((int)r["RatingId"]); Director director = DirectorFactory.Create().GetDirectorbyId((int)r["DirectorId"]); result.Add(new Dvd { DvdId = (int)r["DvdId"], Title = r["Title"].ToString(), ReleaseYear = (int)r["ReleaseYear"], DirectorId = (int)r["DirectorId"], RatingId = (int)r["RatingId"], Note = r["Note"].ToString(), Rating = rate, Director = director }); } } } return(result); }catch (Exception e) { return(null); } }
public bool UpdateDvd(Dvd dvd) { try { using (var ctx = new DvdContext()) { //dvd.Director = DirectorRepositoryEF.GetDirectorbyId(dvd.DirectorId); //dvd.Rating = RateRepositoryEF.GetRatebyId(dvd.RatingId); ctx.Entry(dvd).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); dvd.Director = DirectorFactory.Create().GetDirectorbyId(dvd.DirectorId); dvd.Rating = RatingFactory.Create().GetRatingbyId(dvd.RatingId); return(true); } } catch (Exception e) { return(false); } }
public int InsertDvd(Dvd dvd) { try { using (var ctx = new DvdContext()) { //dvd.Director = DirectorRepositoryEF.GetDirectorbyId(dvd.DirectorId); //dvd.Rating = RateRepositoryEF.GetRatebyId(dvd.RatingId); ctx.Dvd.Add(dvd); ctx.SaveChanges(); //dvd.Director = DirectorRepositoryEF.GetDirectorbyId(dvd.DirectorId); //dvd.Rating = RateRepositoryEF.GetRatebyId(dvd.RatingId); dvd.Director = DirectorFactory.Create().GetDirectorbyId(dvd.DirectorId); dvd.Rating = RatingFactory.Create().GetRatingbyId(dvd.RatingId); return(ctx.Dvd.Max(d => d.DvdId)); } } catch (Exception e) { return(-1); } }
public int InsertDvd(Dvd dvd) { try { using (SqlConnection cnn = new SqlConnection(ADOConnection.CnnString)) { dvd.Director = DirectorFactory.Create().GetDirectorbyId(dvd.DirectorId); dvd.Rating = RatingFactory.Create().GetRatingbyId(dvd.RatingId); SqlCommand cmd = new SqlCommand("DvdInsert", cnn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter dvdIDParam = new SqlParameter("@DvdId", SqlDbType.Int) { Direction = ParameterDirection.Output }; cmd.Parameters.Add(dvdIDParam); cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = dvd.Title; cmd.Parameters.Add("@ReleaseYear", SqlDbType.Int).Value = dvd.ReleaseYear; cmd.Parameters.Add("@DirectorId", SqlDbType.Int).Value = dvd.DirectorId; cmd.Parameters.Add("@RatingId", SqlDbType.Int).Value = dvd.RatingId; cmd.Parameters.Add("@Note", SqlDbType.NVarChar).Value = dvd.Note; if (cnn.State != ConnectionState.Open) { cnn.Open(); } cmd.ExecuteNonQuery(); dvd.DvdId = (int)dvdIDParam.Value; return(dvd.DvdId); } } catch (Exception e) { return(-1); } }