static void Main(string[] args) { Floppy diskette = new Floppy(); diskette.Type = "Floppy"; diskette.Size = 1.44; diskette.SaveData(); diskette.Color = "Green"; Console.WriteLine(diskette.ToString()); Cd Roadrunner = new Cd(); Roadrunner.Artist = "Hurriganes"; Roadrunner.Type = "Audio cd"; Roadrunner.Size = 800; Roadrunner.TrackNumber = 11; Roadrunner.TrackNumber = 30; Console.WriteLine(Roadrunner.ToString()); Dvd Movie = new Dvd(); Movie.Type = "Movie DVD"; Movie.MovieName = "The Revenant"; Movie.Size = 50000; Movie.DualLayer = true; Movie.SaveData(); Movie.SaveData(); Console.WriteLine(Movie.ToString()); Console.ReadLine(); }
static void Main(string[] args) { Kirja kirja = new Kirja("Matematic 1", "Top of the bookcase", "No", "No idea"); Console.WriteLine("Kirja = " + kirja.ToString()); Dvd dvd = new Dvd("Titanic", "404 not found", "Yes", "James Cameron"); Console.WriteLine("Dvd = " + dvd.ToString()); }
public void CanAddDvd() { var repo = new DvdRepositoryADO(); Dvd dvdAdd = new Dvd(); dvdAdd.Title = "A Player Hater's Ball"; dvdAdd.ReleaseYear = 1977; dvdAdd.DirectorName = "Silky Johnson"; dvdAdd.RatingType = "G"; dvdAdd.Notes = "The most diabolical haters this side of the Mississippi!"; repo.AddDvd(dvdAdd); var newDvd = repo.GetDvdById(4); Assert.AreEqual("A Player Hater's Ball", newDvd.Title); Assert.AreEqual(1977, newDvd.ReleaseYear); Assert.AreEqual("Silky Johnson", newDvd.DirectorName); Assert.AreEqual("G", newDvd.RatingType); }
public void Create(Dvd dvd) { DvdEF d = new DvdEF { Notes = dvd.Notes, Title = dvd.Title, ReleaseYear = dvd.ReleaseYear, DvdId = dvd.DvdId }; d.Director = new Director { DirectorName = dvd.DirectorName }; d.Rating = new Rating { RatingValue = dvd.RatingValue }; context.Dvd.Add(d); context.SaveChanges(); }
public IHttpActionResult Add(AddDvdRequest request) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Dvd dvd = new Dvd() { title = request.title, realeaseYear = request.realeaseYear, rating = request.rating, director = request.director, notes = request.notes }; repo.Add(dvd); return(Created($"dvds/get/{dvd.dvdId}", dvd)); }
public void Edit(Dvd dvd) { using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("DvdUpdate", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DvdID", dvd.DvdID); cmd.Parameters.AddWithValue("@Title", dvd.Title); cmd.Parameters.AddWithValue("@ReleaseYear", dvd.ReleaseYear); cmd.Parameters.AddWithValue("@Director", dvd.Director); cmd.Parameters.AddWithValue("@Rating", dvd.Rating); cmd.Parameters.AddWithValue("@Notes", dvd.Notes); cn.Open(); cmd.ExecuteNonQuery(); } }
private void checkInDvdButton_Click(object sender, EventArgs e) { if (idTextBox.Text != "") { int dvdId = Convert.ToInt32(idTextBox.Text); foreach (Media d in mediaItems) { if (d is Dvd) { Dvd itemAsDvd = (Dvd)d; if (itemAsDvd.Id == dvdId) { if (itemAsDvd.IsCheckedOut()) { itemAsDvd.CheckIn(); } } } } bool success = true; if (success) { MessageBox.Show(successString); ClearDvdFields(); mediaListView.Clear(); populateListView(); MediaController.PopulateMainDvdsViewList(mediaListView, mediaItems); } else { MessageBox.Show(noSuccessString + "1"); } } else { MessageBox.Show(noSuccessString); } }
public void UpdateDvd(int id, Dvd dvd) { var commandText = "sp_updateDvd"; using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { using (var command = new SqlCommand(commandText, connection)) { connection.Open(); command.Parameters.Add(new SqlParameter("title", dvd.Title)); command.Parameters.Add(new SqlParameter("releasedate", dvd.ReleaseYear)); command.Parameters.Add(new SqlParameter("director", dvd.Director)); command.Parameters.Add(new SqlParameter("rating", dvd.Rating)); command.Parameters.Add(new SqlParameter("notes", dvd.Notes)); command.CommandType = CommandType.StoredProcedure; command.ExecuteNonQuery(); } } }
private static void SearchForDvd() { Console.WriteLine("#####################################"); Console.WriteLine("# Search for dvd #"); Console.WriteLine("#####################################"); //Request search information from user Console.Write("Title: "); string title = Console.ReadLine(); Console.Write("Director: "); string director = Console.ReadLine(); Console.Write("Asin: "); string asin = Console.ReadLine(); //Create dvd with information to search Dvd dvd = new Dvd(); dvd.title = title; dvd.director = director; dvd.asin = asin; //Request to the webservice Dvd[] dvds = _controller.SearchForDvd(dvd); //Check if there are any matches if (dvds == null || dvds.Length == 0) { Console.WriteLine("########### No matches found! ###########"); } else { Console.WriteLine("########### Results ###########\n"); foreach (Dvd resultDvd in dvds) { Console.WriteLine(resultDvd.ToString()); Console.Write("Press [Enter] to view next dvd."); Console.ReadLine(); Console.WriteLine(); } } }
public IHttpActionResult AddDvd(AddDvdRequest request) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var dvd = new Dvd() { Title = request.Title, ReleaseYear = request.ReleaseYear, Director = request.Director, Rating = request.Rating, Notes = request.Notes }; _dvdRepository.AddDvd(dvd); return(Created($"dvd/{dvd.Id}", dvd)); }
public IHttpActionResult Add(Dvd request) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Dvd dvd = new Dvd() { Title = request.Title, ReleaseYear = request.ReleaseYear, Director = request.Director, Rating = request.Rating, Notes = request.Notes }; Repo.CreateDvd(dvd); return(Created($"dvd/get/{dvd.DvdId}", dvd)); }
public void CanGetById(int id, bool expected) { DvdRepositoryEF repo = new DvdRepositoryEF(); Dvd result = repo.GetById(id); bool actual; if (result == null) { actual = false; } else { actual = (result.DvdId == id); } Assert.AreEqual(expected, actual); }
public void Create(Dvd dvd) { if (dvd.Title == " " || string.IsNullOrEmpty(dvd.Title)) { return; } //Empty or invalid release year else if (dvd.ReleaseYear < 1000 || dvd.ReleaseYear > 9999) { return; } //Empty director name else if (dvd.Director == " " || string.IsNullOrEmpty(dvd.Director)) { return; } //Empty rating else if (dvd.Rating == " " || string.IsNullOrEmpty(dvd.Rating)) { return; } using (var conn = new SqlConnection()) { conn.ConnectionString = connectionString; var parameters = new DynamicParameters(); parameters.Add("@DvdID", dbType: DbType.Int32, direction: ParameterDirection.Output); parameters.Add("@Title", dvd.Title); parameters.Add("@ReleaseYear", dvd.ReleaseYear); parameters.Add("@Director", dvd.Director); parameters.Add("@Rating", dvd.Rating); parameters.Add("@Notes", dvd.Notes); conn.Execute("CreateDvd", param: parameters, commandType: CommandType.StoredProcedure); dvd.DvdId = parameters.Get <int>("@DvdID"); } }
public void AddDvd(Dvd dvd) { if (DvdLibrary.Count == 0) { dvd.DvdId = 1; } else { dvd.DvdId = DvdLibrary.Max(d => d.DvdId) + 1; } if (dvd.Title != null || dvd.RealeaseYear > 0 || dvd.Director != null || dvd.Rating != null) { DvdLibrary.Add(dvd); } }
public void EditDvd() { var repo = new MockDvdRepository(); Dvd editDvd = new Dvd(); editDvd.DvdId = 4; editDvd.Title = "When Keeping It Real Goes Wrong"; editDvd.ReleaseYear = 2013; editDvd.DirectorName = "Tyrone Biggums"; editDvd.RatingType = "G"; editDvd.Notes = "It always goes wrong."; repo.EditDvd(editDvd); var dvdToEdit = repo.GetDvdById(4); Assert.AreEqual("Tyrone Biggums", dvdToEdit.DirectorName); }
public IHttpActionResult CreateDvd(Dvd info) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Dvd newDvd = new Dvd() { Title = info.Title, ReleaseYear = info.ReleaseYear, Director = info.Director, Rating = info.Rating, Notes = info.Notes }; DvdRepositoryFactory.Create().CreateDvd(info); return(Created($"dvd/{info.DvdId}", info)); }
private void FetchFromDvdLib(Video item, IIsoMount mount) { var path = mount == null ? item.Path : mount.MountedPath; var dvd = new Dvd(path); var primaryTitle = dvd.Titles.OrderByDescending(GetRuntime).FirstOrDefault(); byte?titleNumber = null; if (primaryTitle != null) { titleNumber = primaryTitle.VideoTitleSetNumber; item.RunTimeTicks = GetRuntime(primaryTitle); } item.PlayableStreamFileNames = GetPrimaryPlaylistVobFiles(item, mount, titleNumber) .Select(Path.GetFileName) .ToList(); }
public void EditDvd(Dvd dvd) { using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("EditDvd", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DvdId", dvd.DvdId); cmd.Parameters.AddWithValue("@Title", dvd.Title); cmd.Parameters.AddWithValue("@ReleaseYear", dvd.ReleaseYear); cmd.Parameters.AddWithValue("@DirectorName", dvd.DirectorName); cmd.Parameters.AddWithValue("@RatingType", dvd.RatingType); cmd.Parameters.AddWithValue("@Notes", dvd.Notes); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); } }
private string[] FetchFromDvdLib(Video item) { var path = item.Path; var dvd = new Dvd(path, _fileSystem); var primaryTitle = dvd.Titles.OrderByDescending(GetRuntime).FirstOrDefault(); byte?titleNumber = null; if (primaryTitle != null) { titleNumber = primaryTitle.VideoTitleSetNumber; item.RunTimeTicks = GetRuntime(primaryTitle); } return(_mediaEncoder.GetPrimaryPlaylistVobFiles(item.Path, null, titleNumber) .Select(Path.GetFileName) .ToArray()); }
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 string WatchMovie(string movie) { StringBuilder sb = new StringBuilder(); sb.AppendLine("Get ready to watch a movie ..."); sb.AppendLine(Popper.On()); sb.AppendLine(Popper.Pop()); sb.AppendLine(Lights.Dim(10)); sb.AppendLine(Screen.Down()); sb.AppendLine(Projector.On()); sb.AppendLine(Projector.WideScreenMode()); sb.AppendLine(Amp.On()); sb.AppendLine(Amp.SetDvd()); sb.AppendLine(Amp.SetSurroundSound()); sb.AppendLine(Amp.SetVolume(5)); sb.AppendLine(Dvd.On()); sb.AppendLine(Dvd.Play(movie)); return(sb.ToString()); }
public void CanAddDvdToAdo() { IDvdRepository repo = new ADORepo(); Dvd dvdToAdd = new Dvd(); dvdToAdd.DvdId = 7; dvdToAdd.Title = "Good Will Hunting"; dvdToAdd.ReleaseYear = 2018; dvdToAdd.Rating = "PG-13"; dvdToAdd.DirectorName = "Milaho Wehelie"; repo.Add(dvdToAdd); var addedDvd = repo.GetOne(8); Assert.AreEqual("Good Will Hunting", addedDvd.Title); Assert.AreEqual(2018, addedDvd.ReleaseYear); Assert.AreEqual("PG-13", addedDvd.Rating); Assert.AreEqual("Milaho Wehelie", addedDvd.DirectorName); }
public void CanInsertDvdMock() { Dvd dvdToAdd = new Dvd(); var repo = new DvdRepositoryMock(); dvdToAdd.Title = "New Dvd"; dvdToAdd.ReleaseYear = 2020; dvdToAdd.DirectorName = "Me"; dvdToAdd.RatingName = "G"; dvdToAdd.Notes = "This is my new dvd"; repo.Insert(dvdToAdd); Assert.AreEqual(7, dvdToAdd.DvdId); Assert.AreEqual("New Dvd", dvdToAdd.Title); Assert.AreEqual(2020, dvdToAdd.ReleaseYear); Assert.AreEqual("Me", dvdToAdd.DirectorName); Assert.AreEqual("G", dvdToAdd.RatingName); Assert.AreEqual("This is my new dvd", dvdToAdd.Notes); }
public void Add(Dvd dvd) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = ConfigurationManager.ConnectionStrings["DvdLibraryDatabase"].ConnectionString; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "AddDvd"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@title", dvd.title); cmd.Parameters.AddWithValue("@releasedYear", dvd.releasedYear); cmd.Parameters.AddWithValue("@director", dvd.director); cmd.Parameters.AddWithValue("@rating", dvd.rating); cmd.Parameters.AddWithValue("@notes", dvd.notes); conn.Open(); cmd.ExecuteNonQuery(); } }
public void CreateDvd(Dvd dvd) { using (SqlConnection conn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand(insertDvd, conn); cmd.Parameters.AddWithValue("@Title", dvd.Title); cmd.Parameters.AddWithValue("@RatingId", dvd.RatingId); cmd.Parameters.AddWithValue("@Director", dvd.Director); cmd.Parameters.AddWithValue("@ReleaseYear", dvd.ReleaseYear); try { conn.Open(); cmd.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine(e); } } }
public void Update(Dvd dvd) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = conn.ConnectionString = ConfigurationManager.ConnectionStrings["DvdADO"].ConnectionString; conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "UpdateDvd"; cmd.Parameters.AddWithValue("@DvdId", dvd.DvdId); cmd.Parameters.AddWithValue("@Title", dvd.Title); cmd.Parameters.AddWithValue("@Notes", dvd.Notes); cmd.Parameters.AddWithValue("@ReleaseYear", dvd.ReleaseYear); cmd.Parameters.AddWithValue("@DirectorName", dvd.DirectorName); cmd.Parameters.AddWithValue("@RatingValue", dvd.RatingValue); cmd.ExecuteNonQuery(); conn.Close(); } }
public IServiceResult CadastrarDvd(string descricao, string titulo, string nomeDaGravadora, string idioma) { if (string.IsNullOrEmpty(descricao) || string.IsNullOrEmpty(nomeDaGravadora) || string.IsNullOrEmpty(titulo) || string.IsNullOrEmpty(idioma)) { return(ServiceResult.CriarFormularioInvalido(new List <string>() { "Preencha todos os campos" })); } var dvd = new Dvd() { Descricao = descricao, Titulo = titulo, NomeDaGravadora = nomeDaGravadora, Idioma = idioma }; ObterNovoMidiaId(); Salvar(dvd); return(ServiceResult.CreateResultOk()); }
public void AddDvd(Dvd dvd) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = ConfigurationManager.ConnectionStrings["DVDLibrary2"].ConnectionString; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "AddDvd"; cmd.Parameters.AddWithValue("@ReleaseYear", dvd.realeaseYear); cmd.Parameters.AddWithValue("@Rating", dvd.rating); cmd.Parameters.AddWithValue("@Notes", dvd.notes); cmd.Parameters.AddWithValue("@Title", dvd.title); cmd.Parameters.AddWithValue("@Director", dvd.director); conn.Open(); cmd.ExecuteNonQuery(); } }
public void SaveNew(string title, int releaseYear, string directorName, string ratingName, string notes) { Dvd dvd = new Dvd(); using (DvdCatalogEntities data = new DvdCatalogEntities()) { dvd.Director = (from x in data.Directors select x).FirstOrDefault(y => y.DirectorName == directorName); if (dvd.Director == null) { Director director = new Director(); director.DirectorName = directorName; data.Directors.Add(director); } dvd.Rating = (from r in data.Ratings select r).First(x => x.RatingName == ratingName); dvd.ReleaseYear = releaseYear; dvd.Title = title; dvd.Notes = notes; data.Dvds.Add(dvd); data.SaveChanges(); } }
public void DeleteDvdWorks() { //mockRepo = new Mock<InMemoryRepository>(); //IDvdRepository repository = new InMemoryRepository(); Dvd dvd = new Dvd { Id = 5, Director = "MovieMachine6", Notes = "too much acting", Rating = "R", ReleaseYear = 2005, Title = "Batman 15 Return of batman" }; sut.CreateDvd(dvd); sut.DeleteDvd(5); List <Dvd> dvds = sut.GetAllDvds(); Assert.IsFalse(dvds.Contains(dvd)); }
public void AddDvd(Dvd dvd) { using (var cn = new SqlConnection()) { cn.ConnectionString = Settings.GetConnectionString(); var parameters = new DynamicParameters(); parameters.Add("@Id", dbType: DbType.Int32 , direction: ParameterDirection.Output); parameters.Add("@Title", dvd.Title); parameters.Add("@ReleaseYear", dvd.ReleaseYear); parameters.Add("@Director", dvd.Director); parameters.Add("@Rating", dvd.Rating); parameters.Add("@Notes", dvd.Notes); cn.Execute("DvdInsert", parameters, commandType: CommandType.StoredProcedure); dvd.Id = parameters.Get <int>("@Id"); } }
public void EFCanDelete(int id, bool expected) { bool actual = false; var repo = new DvdRepositoryEF(); Dvd dvd = repo.Get(id); if (dvd != null) { repo.Delete(id); dvd = repo.Get(id); if (dvd == null) { actual = true; } } Assert.AreEqual(expected, actual); }