public async Task <IEnumerable <ShowDTO> > GetShows(int offset, int limit) { IList <ShowDTO> showsDTO = new List <ShowDTO>(); var shows = await this.showDomainService.GetShows(offset, limit); foreach (var show in shows) { var showDTO = new ShowDTO { Id = show.ExternalId, Name = show.Name }; foreach (var actor in show.Actors) { showDTO.Cast.Add(new ShowCastDTO { Id = actor.Id, Name = actor.Name, BirthDay = actor.BirthDay }); } showsDTO.Add(showDTO); } return(showsDTO); }
public void ShowsService_Create_calls_Create_method() { var showDto = new ShowDTO { Id = 100, Description = "sdf", Name = "dfg", Episodes = 5, Seasons = 2 }; var mock = new Mock <IUnitOfWork>(); bool isCreateCalled = false; mock.Setup(a => a.Shows.Create(It.Is <Show>(s => (s.Id == showDto.Id) && (s.Name == showDto.Name) && (s.Seasons == showDto.Seasons) && (s.Episodes == showDto.Episodes) && (s.Description == showDto.Description)))).Callback(() => isCreateCalled = true); service = new ShowsService(mock.Object); service.Create(showDto); Assert.IsTrue(isCreateCalled); }
public void Execute(ShowDTO request) { if (Context.Shows.Any(t => t.ShowTitle == request.ShowTitle)) { throw new DataAlreadyExistsException(); } var show = new Show { ShowPicturePath = request.ShowPicturePath, ShowText = request.ShowText, ShowTitle = request.ShowTitle, ShowYear = request.ShowYear, CategoryId = request.CategoryId }; var relationships = request.ActorIds.Select(id => new ActorShow { ActorId = id, ShowId = show.Id }); show.ActorShows = relationships.ToList(); Context.Shows.Add(show); Context.SaveChanges(); //kako ubaciti i glumce //edit serije //delete serije }
public void Setup() { _showDto = new ShowDTO { ID = "1234" }; _showSubDto = new ShowSubscriptionDTO { Id = _showDto.ID, Title = "Test" }; _showService = new Mock <IShowService>(); _showService.Setup(s => s.GetMostPopularShows()).Returns(Task.FromResult(new List <ShowPopularityDTO>())); _showService.Setup(s => s.GetShowByIdAsync(1234)).Returns(Task.FromResult(_showDto)); _subService = new Mock <ISubscriptionService>(); _subService.Setup(s => s.SubscribeToShow(_showSubDto, "123")).Returns(Task.FromResult(true)); _contextMock = new Mock <HttpContext>(); var user = new ClaimsPrincipal(new ClaimsIdentity(new Claim[] { new Claim(ClaimTypes.NameIdentifier, _userId), }, "mock")); _contextMock.Setup(x => x.User).Returns(user); _showController = new ShowsController(_showService.Object, _subService.Object); _showController.ControllerContext.HttpContext = _contextMock.Object; }
private async void GetDirectShowInfo(int id) { try { BusyIndicatorValue = true; var show = await _dataService.GetDirectShowData(id); List <MediaCrew> crews = (show.Credits.Crew).Take(10).ToList(); List <MediaCast> casts = (show.Credits.Cast).Take(10).ToList(); DirectShow = show; Crew = new ObservableCollection <MediaCrew>(crews); Cast = new ObservableCollection <MediaCast>(casts); ShowDTO showFromDb = _showService.GetShow(DirectShow.Id); if (showFromDb == null) { CanDelFromDb = false; CanAddToDb = true; } else { CanDelFromDb = true; CanAddToDb = false; } BusyIndicatorValue = false; } catch (ServiceRequestException) { RaiseNotification(); } catch (Exception e) { _logger.ErrorException(ForExceptions, e); } }
public ActionResult Create(InsertShowDTO value) { var extension = Path.GetExtension(value.ShowPicturePath.FileName); if (!AllowedExtensions.Extensions.Contains(extension)) { return(UnprocessableEntity("Extension is not allowed!")); } try { var newPictureName = Guid.NewGuid().ToString() + "_" + value.ShowPicturePath.FileName; var filePath = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "images", newPictureName); value.ShowPicturePath.CopyTo(new FileStream(filePath, FileMode.Create)); var show = new ShowDTO { ShowPicturePath = newPictureName, ShowTitle = value.ShowTitle, ShowText = value.ShowText, ShowYear = value.ShowYear, CategoryId = value.CategoryId, ActorIds = value.ActorIds }; addShowCommand.Execute(show); return(RedirectToAction(nameof(Index))); } catch (Exception e) { return(View()); } }
public Show ticketsSold(Show show, Ticket t) { ShowDTO showDTO = DTOUtils.getDTO(show); TicketDTO ticketDTO = DTOUtils.getDTO(t); Object[] sendData = new Object[2]; sendData[0] = showDTO; sendData[1] = ticketDTO; Request req = new Request.Builder().Type(RequestType.TICKETS_SOLD).Data(sendData).Build(); sendRequest(req); logger.Debug("PROXY CLIENT: ticketsSold SENT REQUEST WARNING: THIS FUNCTION HAS NO RESPONSE!!!"); Response response = readResponse(); if (response.Type() == ResponseType.UPDATED_SHOWS) { logger.Debug("PROXY CLIENT: SUCCESSFUL update"); return(null); } if (response.Type() == ResponseType.ERROR) { String err = response.Data().ToString(); throw new ServicesException(err); } logger.Debug("PROXY CLIENT: SUCCESSFUL ticketsSold WARNING: THIS FUNCTION HAS NO RESPONSE!!!"); return(null); }
public void TakeShow(ShowDTO showDto) { Mapper.Initialize(cfg => cfg.CreateMap <ShowDTO, Show>()); Show show = Mapper.Map <ShowDTO, Show>(showDto); _database.Shows.Create(show); _database.Save(); }
private void AddToDb() { ShowDTO show = new ShowDTO { Name = DirectShow.Name, ExternalId = DirectShow.Id }; _showService.TakeShow(show); CanDelFromDb = true; CanAddToDb = false; RefreshFavoriteView(); }
public bool createShow(ShowDTO show) { SqlCommand cmd = buildCmd(show); cmd = connectToDB(cmd); cmd.CommandText = "insert into Shows (Title, Genre, Distr, Date, NumberOfTickets) values (@Title, @Genre, @Distribution, @Date, @NrTickets)"; cmd.ExecuteNonQuery(); cmd.Connection.Close(); showsList.Add(show); return(true); }
private SqlCommand buildCmd(ShowDTO show) { SqlCommand cmd = new SqlCommand(); cmd.Parameters.AddWithValue("ID", show.getID()); cmd.Parameters.AddWithValue("NrTickets", show.getNumberOfTickets()); cmd.Parameters.AddWithValue("Genre", show.getGenre()); cmd.Parameters.AddWithValue("Date", show.getDate().ToString()); cmd.Parameters.AddWithValue("Distribution", show.getDistribution()); cmd.Parameters.AddWithValue("Title", show.getTitle()); return(cmd); }
public ShowDTO map(ShowModel showmodel) { ShowDTO dto = new ShowDTO(); dto.setID(showmodel.getID()); dto.setGenre(showmodel.getGenre()); dto.setDistribution(showmodel.getDistribution()); dto.setDate(showmodel.getDate()); dto.setNumberOfTickets(showmodel.getNumberOfTickets()); dto.setTitle(showmodel.getTitle()); return(dto); }
public bool deleteShowByID(int ID) { SqlCommand cmd = connectToDB(); cmd.Parameters.AddWithValue("ID", ID); cmd.CommandText = "delete from Shows where ID=@ID"; cmd.ExecuteNonQuery(); cmd.Connection.Close(); ShowDTO oldShow = showsList.Find(show => show.getID() == ID); showsList.Remove(oldShow); return(true); }
public ShowModel map(ShowDTO showdto) { ShowModel model = new ShowModel(); model.setID(showdto.getID()); model.setGenre(showdto.getGenre()); model.setDistribution(showdto.getDistribution()); model.setDate(showdto.getDate()); model.setNumberOfTickets(showdto.getNumberOfTickets()); model.setTitle(showdto.getTitle()); return(model); }
public bool CreateShow(ShowDTO showDTO) { bool creationSuccessful = true; using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["gravyliveconnection"].ConnectionString)) { connection.Open(); string sql = @"INSERT INTO [Show] (Show_Date, Product_ID, Product_Units, Start_Price, Total_COGS, Unit_Cost) VALUES (@Show_Date, @Product_ID, @Product_Units, @Start_Price, @Total_COGS, @Unit_Cost);"; connection.ExecuteScalar(sql, showDTO); } return(creationSuccessful); }
public bool updateShow(ShowDTO show) { SqlCommand cmd = buildCmd(show); cmd = connectToDB(cmd); cmd.CommandText = "update Shows set Title = @Title, Genre = @Genre, Distr = @Distribution, Date = @Date, NumberOfTickets = @NrTickets where ID=@ID"; cmd.ExecuteNonQuery(); cmd.Connection.Close(); ShowDTO oldShow = showsList.Find(shw => shw.getID() == show.getID()); showsList.Remove(oldShow); showsList.Add(show); return(true); }
public ActionResult CreateShow(GravyLiveWebApp.WebApp.Models.NewShowModel formdata) { ShowDTO dto = new ShowDTO(); dto.Show_Date = formdata.Show_Date; dto.Product_ID = formdata.Product_ID; dto.Product_Units = formdata.Product_Units; dto.Start_Price = formdata.Start_Price; dto.Total_COGS = formdata.Unit_Cost * formdata.Product_Units; dto.Unit_Cost = formdata.Unit_Cost; ShowDAO dao = new ShowDAO(); bool success = dao.CreateShow(dto); return(RedirectToAction("AfterAddShow", new { r = success, s = formdata.Show_Date })); }
private void button1_Click(object sender, EventArgs e) { if (numeCBox.Text != null && locuriCBox.Text != null && listaShow.SelectedItems.Count == 1) { try { int nrLocuri = int.Parse(locuriCBox.Text); int idShow = int.Parse(listaShow.SelectedItems[0].SubItems[0].Text); int locuriDisp = int.Parse(listaShow.SelectedItems[0].SubItems[4].Text); if (locuriDisp >= nrLocuri) { //Show s = new Show() { Id = idShow }; string numeC = numeCBox.Text; //Ticket t = new Ticket() { IdShow = idShow, NrSeatsWanted = nrLocuri, BuyerName = numeC }; ShowDTO showDTO = new ShowDTO(); showDTO.Id = idShow; TicketDTO ticketDTO = new TicketDTO(); ticketDTO.IdShow = idShow; ticketDTO.NrWantedSeats = nrLocuri; ticketDTO.BuyerName = numeC; TTransport transport = new TSocket("localhost", 9091); TProtocol protocol = new TBinaryProtocol(transport); transport.Open(); AppService.Client client = new AppService.Client(protocol); client.ticketsSold(showDTO, ticketDTO); transport.Close(); CallPopulateTable(); //this.ctrl.ticketsSold(s, t); } else { MessageBox.Show("Nu avem suficiente locuri libere!"); } numeCBox.Clear(); locuriCBox.Clear(); } catch (Exception ex) { MessageBox.Show("Ati introdus gresit datele in campul de locuri dorite!"); } } else { MessageBox.Show("Va rugam completati toate campurile si selectati un spectacol din lista"); } }
public void Execute(ShowDTO request) { var one = Context.Shows.Find(request.Id); if (one == null || one.Deleted) { throw new DataNotFoundException(); } if (one.ShowPicturePath != request.ShowPicturePath) { one.ShowPicturePath = request.ShowPicturePath; one.UpdatedAt = DateTime.Now; } if (one.ShowTitle != request.ShowTitle) { if (Context.Shows.Any(s => s.ShowTitle == request.ShowTitle)) { throw new DataAlreadyExistsException(); } one.ShowTitle = request.ShowTitle; one.UpdatedAt = DateTime.Now; } if (one.ShowYear != request.ShowYear) { one.ShowYear = request.ShowYear; one.UpdatedAt = DateTime.Now; } if (one.ShowText != request.ShowText) { one.ShowText = request.ShowText; one.UpdatedAt = DateTime.Now; } else { throw new DataNotAlteredException(); } }
public ActionResult Put(int id, [FromForm] InsertShow value) { if (value.ShowPicturePath != null) { var extension = Path.GetExtension(value.ShowPicturePath.FileName); if (!AllowedExtensions.Extensions.Contains(extension)) { return(UnprocessableEntity("Extension is not allowed!")); } try { var newPictureName = Guid.NewGuid().ToString() + "_" + value.ShowPicturePath.FileName; var filePath = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "images", newPictureName); value.ShowPicturePath.CopyTo(new FileStream(filePath, FileMode.Create)); var show = new ShowDTO { ShowPicturePath = newPictureName }; editShowCommand.Execute(show); return(NoContent()); } catch (Exception e) { return(StatusCode(500)); } } else { return(null); //?? } }
private void getAllShows() { showsList = new List <ShowDTO>(); SqlCommand cmd = connectToDB(); cmd.CommandText = "select * from Shows"; SqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { ShowDTO show = new ShowDTO(); show.setID((Int32)dataReader["ID"]); show.setTitle(dataReader["Title"].ToString()); show.setGenre(dataReader["Genre"].ToString()); show.setDistribution(dataReader["Distr"].ToString()); DateTime dt; DateTime.TryParse(dataReader["Date"].ToString(), out dt); show.setDate(dt); show.setNumberOfTickets((Int32)dataReader["NumberOfTickets"]); showsList.Add(show); } cmd.Connection.Close(); }
public List <ShowDTO> getShowsByTitle(string Title) { List <ShowDTO> showsByTitle = new List <ShowDTO>(); SqlCommand cmd = connectToDB(); cmd.Parameters.AddWithValue("Title", Title); cmd.CommandText = "select * from Shows where Title = @Title"; SqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { ShowDTO show = new ShowDTO(); show.setID((Int32)dataReader["ID"]); show.setTitle(dataReader["Title"].ToString()); show.setGenre(dataReader["Genre"].ToString()); show.setDistribution(dataReader["Distr"].ToString()); show.setDate(DateTime.Parse(dataReader["Date"].ToString())); show.setNumberOfTickets((Int32)dataReader["NumberOfTickets"]); showsByTitle.Add(show); } cmd.Connection.Close(); return(showsByTitle); }
public void Update(ShowDTO show) { Mapper.Initialize(cfg => cfg.CreateMap <ShowDTO, Show>()); db.Shows.Update(Mapper.Map <Show>(show)); }