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