public IHttpActionResult deleteProductiondateTime(int productionDateTimeid, ProductionDateTime productionDateTimeToDelete)
{
try
{
using (var dbcontext = new BroadwayBuilderContext())
{
var productionService = new ProductionService(dbcontext);
if (productionDateTimeToDelete == null)
{
return(BadRequest("no production date time object provided"));
}
productionService.DeleteProductionDateTime(productionDateTimeToDelete);
dbcontext.SaveChanges();
return(Ok("Production date time deleted succesfully!"));
}
}
catch (DbUpdateException e)
{
return(Content((HttpStatusCode)500, e.Message));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public IHttpActionResult deleteProductiondateTime(int productionDateTimeid, ProductionDateTime productionDateTimeToDelete)
{
try
{
using (var dbcontext = new BroadwayBuilderContext())
{
var productionService = new ProductionService(dbcontext);
try
{
if (productionDateTimeToDelete == null)
{
return(BadRequest("no production date time object provided"));
}
productionService.DeleteProductionDateTime(productionDateTimeToDelete);
dbcontext.SaveChanges();
return(Ok("Production date time deleted succesfully!"));
}
catch (Exception e)
{
// Todo: Catch a specific error so you can tell send a specific response model stating why a production date time was not able to be deleted
return(BadRequest("Was not able to delete production date time because....."));
}
}
}
catch (Exception e)
{
// Todo: User proper error handling responses catch a more specific error
return(BadRequest("Major error happened!"));
}
}
public void ProductionController_CreateProductionDateTime_Pass()
{
// Arrange
var dbcontext = new BroadwayBuilderContext();
var theaterService = new TheaterService(dbcontext);
var theater = new Theater()
{
TheaterName = "Some Theater 1",
StreetAddress = "Theater St",
State = "CA",
City = "LA",
CompanyName = "Regal",
Country = "US",
PhoneNumber = "123456789"
};
theaterService.CreateTheater(theater);
dbcontext.SaveChanges();
var production = new Production()
{
ProductionName = "The Lion King 2",
DirectorFirstName = "Jane",
DirectorLastName = "Doe",
Street = "Anahiem",
City = "Long Beach",
StateProvince = "California",
Country = "United States",
Zipcode = "919293",
TheaterID = theater.TheaterID
};
var productionService = new ProductionService(dbcontext);
productionService.CreateProduction(production);
dbcontext.SaveChanges();
var date = DateTime.Parse("3/23/2019 3:22:29 PM");
var time = TimeSpan.Parse("10:30:00");
var productionDateTime = new ProductionDateTime(production.ProductionID, date, time);
var productionController = new ProductionController();
// Act
var actionResult = productionController.CreateProductionDateTime(production.ProductionID, productionDateTime);
var response = actionResult as OkNegotiatedContentResult <string>;
productionService.DeleteProductionDateTime(productionDateTime);
dbcontext.SaveChanges();
productionService.DeleteProduction(production.ProductionID);
dbcontext.SaveChanges();
theaterService.DeleteTheater(theater);
dbcontext.SaveChanges();
// Assert
Assert.IsNotNull(response);
Assert.AreEqual("Production Date and time have been added!", response.Content);
}
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_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);
}