public IHttpActionResult CreateProductionDateTime(int productionId, [FromBody] ProductionDateTime productionDateTime)
{
try
{
using (var dbcontext = new BroadwayBuilderContext())
{
var productionService = new ProductionService(dbcontext);
if (productionDateTime == null)
{
return(BadRequest("no production date time object provided"));
}
productionDateTime.ProductionID = productionId;
productionService.CreateProductionDateTime(productionId, productionDateTime);
dbcontext.SaveChanges();
return(Ok("Production Date and time have been added!"));
}
}
catch (DbUpdateException e)
{
return(Content((HttpStatusCode)500, e.Message));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public IHttpActionResult createProductionDateTime(int productionId, [FromBody] ProductionDateTime productionDateTime)
{
try
{
using (var dbcontext = new BroadwayBuilderContext())
{
var productionService = new ProductionService(dbcontext);
try
{
if (productionDateTime == null)
{
return(BadRequest("no production date time object provided"));
}
productionDateTime.ProductionID = productionId;
productionService.CreateProductionDateTime(productionDateTime);
dbcontext.SaveChanges();
// Todo: Change this to a 201 Created(insert url of resource) once get productiondate time route is created
return(Ok(productionDateTime));
}
catch (Exception e)
{
return(BadRequest());
}
}
}
catch (Exception e)
{
return(BadRequest("Something went wrong!"));
}
}
public void ProductionService_CreateProductionDateTime_Pass()
{
//Arrange
var dbcontext = new BroadwayBuilderContext();
var theaterService = new TheaterService(dbcontext);
var theater = new Theater("The Magicians", "Regal", "theater st", "LA", "CA", "US", "323323");
theaterService.CreateTheater(theater);
dbcontext.SaveChanges();
var productionService = new ProductionService(dbcontext);
var productionName = "The Lion King";
var directorFirstName = "Joan";
var directorLastName = "Doe";
var street = "123 Anahiem St";
var city = "Long Beach";
var stateProvince = "California";
var country = "United States";
var zipcode = "919293";
var production = new Production(theater.TheaterID, productionName, directorFirstName, directorLastName, street, city, stateProvince, country, zipcode);
productionService.CreateProduction(production);
dbcontext.SaveChanges();
var date = DateTime.Parse("3/23/2019 3:22:29 PM");
var time = TimeSpan.Parse("10:30:00");
/* Info: Had to cast to int because in production entity model int was made into a Nullable<int> or int? for data validation purposes
* If we make model in frontend then we can remove this cast to int and it will make things cleaner
*/
var productionDateTime = new ProductionDateTime((int)production.ProductionID, date, time);
var expected = true;
var actual = false;
// Act
productionService.CreateProductionDateTime(productionDateTime);
dbcontext.SaveChanges();
if (productionDateTime.ProductionDateTimeId > 0)
{
actual = true;
}
// Assert
productionService.DeleteProduction(production);
dbcontext.SaveChanges();
theaterService.DeleteTheater(theater);
dbcontext.SaveChanges();
Assert.AreEqual(expected, actual);
}
public void ProductionService_DeleteProductionDateTime_Pass()
{
// Arrange
var dbcontext = new BroadwayBuilderContext();
var theaterService = new TheaterService(dbcontext);
var theater = new Theater()
{
TheaterName = "The Magicians",
StreetAddress = "Pantene",
State = "CA",
City = "LA",
CompanyName = "123 Sesame St",
Country = "US",
PhoneNumber = "123456789"
};
theaterService.CreateTheater(theater);
dbcontext.SaveChanges();
var productionService = new ProductionService(dbcontext);
var production = new Production
{
ProductionName = "The Pajama Game 1",
DirectorFirstName = "Doris",
DirectorLastName = "Day",
City = "San Diego",
StateProvince = "California",
Country = "U.S",
TheaterID = theater.TheaterID,
Street = "1234 Sesame St",
Zipcode = "91911"
};
productionService.CreateProduction(production);
dbcontext.SaveChanges();
var date = DateTime.Parse("3/28/2019 3:22:29 PM");
var time = TimeSpan.Parse("11:30:00");
var productionDateTime = new ProductionDateTime(production.ProductionID, date, time);
productionService.CreateProductionDateTime(production.ProductionID, productionDateTime);
dbcontext.SaveChanges();
var expected = true;
var actual = false;
// Act
productionService.DeleteProductionDateTime(productionDateTime);
var affectedRows = dbcontext.SaveChanges();
if (affectedRows > 0)
{
actual = true;
}
// Assert
productionService.DeleteProduction(production.ProductionID);
dbcontext.SaveChanges();
theaterService.DeleteTheater(theater);
dbcontext.SaveChanges();
Assert.AreEqual(expected, actual);
}
public void ProductionService_GetProductionsByCurrentDate_Pass()
{
// Arrange
// Arrange
var dbcontext = new BroadwayBuilderContext();
var theaterService = new TheaterService(dbcontext);
var theater = new Theater()
{
TheaterName = "The Language",
StreetAddress = "Pantene",
State = "CA",
City = "LA",
CompanyName = "123 Sesame St",
Country = "US",
PhoneNumber = "123456789"
};
theaterService.CreateTheater(theater);
dbcontext.SaveChanges();
var productionService = new ProductionService(dbcontext);
var production1 = new Production()
{
ProductionName = "The Lion King 14",
DirectorFirstName = "Joan",
DirectorLastName = "Doe",
Street = "123 Anahiem St",
City = "Long Beach",
StateProvince = "California",
Country = "United States",
Zipcode = "919293",
TheaterID = theater.TheaterID
};
productionService.CreateProduction(production1);
dbcontext.SaveChanges();
var production2 = new Production()
{
ProductionName = "The Lion King 15",
DirectorFirstName = "Joan",
DirectorLastName = "Doe",
Street = "123 Anahiem St",
City = "Long Beach",
StateProvince = "California",
Country = "United States",
Zipcode = "919293",
TheaterID = theater.TheaterID
};
productionService.CreateProduction(production2);
dbcontext.SaveChanges();
var productionDateTime1 = new ProductionDateTime()
{
Date = DateTime.Parse("3/23/2019 3:22:29 PM"),
Time = TimeSpan.Parse("10:30:00"),
ProductionID = production1.ProductionID
};
productionService.CreateProductionDateTime(production1.ProductionID, productionDateTime1);
dbcontext.SaveChanges();
var productionDateTime2 = new ProductionDateTime()
{
Date = DateTime.Parse("3/29/2019 3:22:29 PM"),
Time = TimeSpan.Parse("5:30:00"),
ProductionID = production2.ProductionID
};
productionService.CreateProductionDateTime(production2.ProductionID, productionDateTime2);
dbcontext.SaveChanges();
var expected = true;
var actual = false;
// Act
var readProductionsList = productionService.GetProductionsByCurrentAndFutureDate(new DateTime(2019, 3, 1), null, 1, 10); // Theater id is meant to be null
if (readProductionsList != null)
{
actual = true;
}
// Assert
productionService.DeleteProductionDateTime(productionDateTime2);
dbcontext.SaveChanges();
productionService.DeleteProductionDateTime(productionDateTime1);
dbcontext.SaveChanges();
productionService.DeleteProduction(production1.ProductionID);
dbcontext.SaveChanges();
productionService.DeleteProduction(production2.ProductionID);
dbcontext.SaveChanges();
theaterService.DeleteTheater(theater);
dbcontext.SaveChanges();
Assert.AreEqual(expected, actual);
}
public void ProductionController_DeleteProductionDateTime_Pass()
{
// Arrange
var dbcontext = new BroadwayBuilderContext();
var theaterService = new TheaterService(dbcontext);
var theater = new Theater()
{
TheaterName = "The Magicians",
StreetAddress = "Pantene",
State = "CA",
City = "LA",
CompanyName = "123 Sesame St",
Country = "US",
PhoneNumber = "123456789"
};
theaterService.CreateTheater(theater);
dbcontext.SaveChanges();
var productionService = new ProductionService(dbcontext);
var production = new Production
{
ProductionName = "The Pajama Game 1",
DirectorFirstName = "Doris",
DirectorLastName = "Day",
City = "San Diego",
StateProvince = "California",
Country = "U.S",
TheaterID = theater.TheaterID,
Street = "1234 Sesame St",
Zipcode = "91911"
};
productionService.CreateProduction(production);
dbcontext.SaveChanges();
var date = DateTime.Parse("3/28/2019 3:22:29 PM");
var time = TimeSpan.Parse("11:30:00");
var productionDateTime = new ProductionDateTime(production.ProductionID, date, time);
productionService.CreateProductionDateTime(production.ProductionID, productionDateTime);
dbcontext.SaveChanges();
var productionController = new ProductionController();
// Act
var actionResult = productionController.deleteProductiondateTime(productionDateTime.ProductionDateTimeId, productionDateTime);
var response = actionResult as OkNegotiatedContentResult <string>;
var dbcontext_ = new BroadwayBuilderContext();
var theaterService_ = new TheaterService(dbcontext_);
var theater_ = theaterService.GetTheaterByID(theater.TheaterID);
theaterService_.DeleteTheater(theater_);
dbcontext_.SaveChanges();
// Assert
Assert.IsNotNull(response);
Assert.AreEqual("Production date time deleted succesfully!", response.Content);
}
public void ProductionController_UpdateProductionDateTime_Pass()
{
// Arrange
var dbcontext = new BroadwayBuilderContext();
var theaterService = new TheaterService(dbcontext);
var theater = new Theater()
{
TheaterName = "The Magicians",
StreetAddress = "Pantene",
State = "CA",
City = "LA",
CompanyName = "123 Sesame St",
Country = "US",
PhoneNumber = "123456789"
};
theaterService.CreateTheater(theater);
dbcontext.SaveChanges();
var productionService = new ProductionService(dbcontext);
var production = new Production
{
ProductionName = "The Pajama Game 1",
DirectorFirstName = "Doris",
DirectorLastName = "Day",
City = "San Diego",
StateProvince = "California",
Country = "U.S",
TheaterID = theater.TheaterID,
Street = "1234 Sesame St",
Zipcode = "91911"
};
productionService.CreateProduction(production);
dbcontext.SaveChanges();
var date = DateTime.Parse("3/28/2019 3:22:29 PM");
var time = TimeSpan.Parse("11:30:00");
var productionDateTime = new ProductionDateTime(production.ProductionID, date, time);
productionService.CreateProductionDateTime(production.ProductionID, productionDateTime);
dbcontext.SaveChanges();
productionDateTime.Date = DateTime.Parse("3/27/2019 3:22:29 PM");
productionDateTime.Time = TimeSpan.Parse("9:30:00");
var productionController = new ProductionController();
// Act
var actionResult = productionController.updateProductionDateTime(productionDateTime.ProductionDateTimeId, productionDateTime);
var response = actionResult as OkNegotiatedContentResult <ProductionDateTime>;
var updatedProductionDateTime = response.Content;
var expected = new
{
DateTime = DateTime.Parse("3/27/2019 3:22:29 PM"),
TimeSpan = TimeSpan.Parse("9:30:00")
};
var actual = updatedProductionDateTime;
productionService.DeleteProductionDateTime(productionDateTime);
dbcontext.SaveChanges();
productionService.DeleteProduction(response.Content.ProductionID);
dbcontext.SaveChanges();
theaterService.DeleteTheater(theater);
dbcontext.SaveChanges();
// Assert
Assert.IsNotNull(response);
Assert.AreEqual(productionDateTime.ProductionDateTimeId, updatedProductionDateTime.ProductionDateTimeId);
Assert.AreEqual(expected.DateTime, actual.Date);
Assert.AreEqual(expected.TimeSpan, actual.Time);
}
public void ProductionController_GetProductions_Pass()
{
// Arrange
var dbcontext = new BroadwayBuilderContext();
var theaterService = new TheaterService(dbcontext);
var theater = new Theater()
{
TheaterName = "Some Theater",
StreetAddress = "Theater St",
State = "CA",
City = "LA",
CompanyName = "Regal",
Country = "US",
PhoneNumber = "123456789"
};
theaterService.CreateTheater(theater);
dbcontext.SaveChanges();
var productionService = new ProductionService(dbcontext);
var production1 = new Production()
{
ProductionName = "The Lion King 14",
DirectorFirstName = "Joan",
DirectorLastName = "Doe",
Street = "123 Anahiem St",
City = "Long Beach",
StateProvince = "California",
Country = "United States",
Zipcode = "919293",
TheaterID = theater.TheaterID
};
productionService.CreateProduction(production1);
dbcontext.SaveChanges();
var production2 = new Production()
{
ProductionName = "The Lion King 15",
DirectorFirstName = "Joan",
DirectorLastName = "Doe",
Street = "123 Anahiem St",
City = "Long Beach",
StateProvince = "California",
Country = "United States",
Zipcode = "919293",
TheaterID = theater.TheaterID
};
productionService.CreateProduction(production2);
dbcontext.SaveChanges();
var productionDateTime1 = new ProductionDateTime()
{
Date = DateTime.Parse("3/23/2019 3:22:29 PM"),
Time = TimeSpan.Parse("10:30:00"),
ProductionID = production1.ProductionID
};
productionService.CreateProductionDateTime(production1.ProductionID, productionDateTime1);
dbcontext.SaveChanges();
var productionDateTime2 = new ProductionDateTime()
{
Date = DateTime.Parse("3/29/2019 3:22:29 PM"),
Time = TimeSpan.Parse("5:30:00"),
ProductionID = production2.ProductionID
};
productionService.CreateProductionDateTime(production2.ProductionID, productionDateTime2);
dbcontext.SaveChanges();
var productionController = new ProductionController();
// Act
var actionResult = productionController.GetProductions(currentDate: new DateTime(2019, 3, 1));
var response = actionResult as OkNegotiatedContentResult <List <ProductionResponseModel> >;
var productions = response.Content;
var expected = true;
var actual = false;
if (productions.Count > 0)
{
actual = true;
}
productionService.DeleteProductionDateTime(productionDateTime2);
dbcontext.SaveChanges();
productionService.DeleteProductionDateTime(productionDateTime1);
dbcontext.SaveChanges();
productionService.DeleteProduction(production1.ProductionID);
dbcontext.SaveChanges();
productionService.DeleteProduction(production2.ProductionID);
dbcontext.SaveChanges();
theaterService.DeleteTheater(theater);
dbcontext.SaveChanges();
// Assert
Assert.IsNotNull(response.Content);
Assert.AreEqual(expected, actual);
}