public HttpResponseMessage AddRestaurant( Restaurant restaurant ) {
CrudResult result = new CrudResult();
using ( Repo repo = new Repo() ) {
result = repo.SaveRestaurant( restaurant );
string json = JsonConvert.SerializeObject( result, jss );
HttpResponseMessage msg = Request.CreateResponse( HttpStatusCode.OK, json );
return msg;
}
}
public void ModelTest_AddRestaurant() {
// create a new restaurant
Restaurant r = new Restaurant() { Name = "Testaurant", Category = "Category", City = "Butler", State = "PA", Street = "100 Main Street", ZipCode = "16001" };
// test model
using ( Repo repo = new Repo() ) {
CrudResult result = repo.SaveRestaurant( r );
Assert.IsTrue( result.Success, "Add restaurant did not succeed." );
}
// delete test restaurant
using ( SuprContext ctx = new SuprContext() ) {
ctx.Restaurant.Attach( r );
ctx.Restaurant.Remove( r );
ctx.SaveChanges();
}
}
public CrudResult SaveRestaurant( Restaurant restaurant ) {
CrudResult result = new CrudResult();
if ( restaurant.Id > 0 )
ctx.Entry( restaurant ).State = EntityState.Modified;
else
ctx.Restaurant.Add( restaurant );
try {
ctx.SaveChanges();
result.Success = true;
}
catch ( DbEntityValidationException ex ) {
result.Errors = ex.EntityValidationErrors;
result.Success = false;
}
return result;
}
public ItemResult<Restaurant> GetRestaurantById( int id ) {
ItemResult<Restaurant> result = new ItemResult<Restaurant>();
Restaurant item = new Restaurant();
try {
item = ctx.Restaurant.Where( r => r.Id == id ).FirstOrDefault();
if ( item != null )
result.Item = item;
else {
result.Status = "No restaurants found with Id = " + id;
}
}
catch ( Exception except ) {
result.Status = except.InnerException != null ? except.InnerException.Message : except.Message;
}
return result;
}
public void ModelTest_GetRestaurantByCity() {
// add restaurant to guarantee a find
Restaurant r = new Restaurant() { Name = "Testaurant", City = "butLEr", State = "PA" };
using ( SuprContext ctx = new SuprContext() ) {
ctx.Restaurant.Add( r );
ctx.SaveChanges();
// test the repository
string city = "BUtler";
using ( Repo repo = new Repo() ) {
ListResult<Restaurant> restaurants = repo.GetRestaurantsByCity( city );
Assert.IsNotNull( restaurants, "No restaurants in " + city + " found." );
}
// delete the created restaurant
r = ctx.Restaurant.Where( d => d.Id == r.Id ).First();
ctx.Restaurant.Remove( r );
ctx.SaveChanges();
}
}
public void ModelTest_GetRestaurantById() {
// add restaurant to guarantee a find
Restaurant r = new Restaurant() { Name = "Testaurant", City = "butLEr", State = "PA" };
using ( SuprContext ctx = new SuprContext() ) {
ctx.Restaurant.Add( r );
ctx.SaveChanges();
int id = r.Id;
// test the repository
using ( Repo repo = new Repo() ) {
ItemResult<Restaurant> restaurant = repo.GetRestaurantById( id );
Assert.IsNotNull( restaurant, "No restaurant with Id = " + restaurant.Item.Id + " found." );
}
// delete the created restaurant
r = ctx.Restaurant.Where( d => d.Id == id ).First();
ctx.Restaurant.Remove( r );
ctx.SaveChanges();
}
}
public void ApiTest_GetRestaurantByCity() {
// add restaurant to guarantee a find
Restaurant r = new Restaurant() { Name = "Testaurant", City = "butLEr", State = "PA" };
using ( SuprContext ctx = new SuprContext() ) {
ctx.Restaurant.Add( r );
ctx.SaveChanges();
string city = "BUtler";
// test the api
var token = ApiClient.GetAPIToken( usr, pwd, uri ).Result;
var response = ApiClient.GetRequest( token, uri, "/api/v1/GetRestaurant?City=" + city ).Result;
ListResult<Restaurant> result = JsonConvert.DeserializeObject<ListResult<Restaurant>>( response.ToString() );
Assert.IsNotNull( result, "No restaurants were found in " + city + "." );
// delete the created restaurant
r = ctx.Restaurant.Where( d => d.Id == r.Id ).First();
ctx.Restaurant.Remove( r );
ctx.SaveChanges();
}
}
public void ApiTest_GetRestaurantById() {
// add restaurant to guarantee a find
Restaurant r = new Restaurant() { Name = "Testaurant", City = "butLEr", State = "PA" };
using ( SuprContext ctx = new SuprContext() ) {
ctx.Restaurant.Add( r );
ctx.SaveChanges();
int id = r.Id;
// test the api
var token = ApiClient.GetAPIToken( usr, pwd, uri ).Result;
var response = ApiClient.GetRequest( token, uri, "/api/v1/GetRestaurant?Id=" + id ).Result;
ItemResult<Restaurant> result = JsonConvert.DeserializeObject<ItemResult<Restaurant>>( response.ToString() );
Assert.IsNotNull( result, "No restaurant with Id = " + result.Item.Id + " found." );
// delete the created restaurant
r = ctx.Restaurant.Where( d => d.Id == id ).First();
ctx.Restaurant.Remove( r );
ctx.SaveChanges();
}
}