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