public static Restaurant ConvertRestaurantFromDB(DataProject.Restaurant rest)
{
Restaurant result;
if (rest != null)
{
result = new Restaurant
{
Address = rest.Address,
AvgRating = rest.AvgRating,
City = rest.City,
ID = rest.ID,
Name = rest.Name,
PhoneNum = rest.PhoneNum,
State = rest.State,
ZIP = rest.ZIP
};
}
else
{
result = null;
}
return(result);
}
public void TestConvertRestaurantListFromDB()
{
ICollection <DataProject.Restaurant> dbList = new List <DataProject.Restaurant>();
dbRest = new DataProject.Restaurant
{
Name = name,
ID = restId,
Address = address,
City = city,
AvgRating = 5f,
PhoneNum = phoneNum,
Reviews = new List <DataProject.Review>(),
State = state,
ZIP = zip
};
dbRev = new DataProject.Review
{
ID = revId,
Rating = rating,
Description = desc,
RestaurantID = restId
};
dbRest.Reviews.Add(dbRev);
dbList.Add(dbRest);
ICollection <LibraryProject.Restaurant> blList = Converter.ConvertRestaurantListFromDB(dbList);
if (dbList.Count != blList.Count)
{
Assert.Fail("lists not equal");
}
else
{
for (int i = 0; i < dbList.Count; i++)
{
dbRest = ((List <DataProject.Restaurant>)dbList)[i];
blRest = ((List <LibraryProject.Restaurant>)blList)[i];
for (int y = 0; y < dbRest.Reviews.Count; y++)
{
dbRev = ((List <DataProject.Review>)dbRest.Reviews)[0];
blRev = ((List <LibraryProject.Review>)blRest.Reviews)[0];
Assert.AreEqual(dbRest.Address, blRest.Address, "Address: \"" + dbRest.Address + "\" \"" + blRest.Address + '"');
Assert.AreEqual(dbRest.AvgRating, blRest.AvgRating, "AvgRating: \"" + dbRest.AvgRating + "\" \"" + blRest.AvgRating + '"');
Assert.AreEqual(dbRest.City, blRest.City, "City: \"" + dbRest.City + "\" \"" + blRest.City + '"');
Assert.AreEqual(dbRest.ID, blRest.ID, "ID: \"" + dbRest.ID + "\" \"" + blRest.ID + '"');
Assert.AreEqual(dbRest.Name, blRest.Name, "Name: \"" + dbRest.Name + "\" \"" + blRest.Name + '"');
Assert.AreEqual(dbRest.PhoneNum, blRest.PhoneNum, "PhoneNum: \"" + dbRest.PhoneNum + "\" \"" + blRest.PhoneNum + '"');
Assert.AreEqual(dbRest.State, blRest.State, "State: \"" + dbRest.State + "\" \"" + blRest.Address + '"');
Assert.AreEqual(dbRest.ZIP, blRest.ZIP, "ZIP: \"" + dbRest.ZIP + "\" \"" + blRest.ZIP + '"');
Assert.AreEqual(dbRev.Description, blRev.Description, "Description: \"" + dbRev.Description + "\" \"" + blRev.Description + '"');
Assert.AreEqual(dbRev.Rating, blRev.Rating, "Rating: \"" + dbRev.Rating + "\" \"" + blRev.Rating + '"');
Assert.AreEqual(dbRev.RestaurantID, blRev.RestaurantID, "RestaurantID: \"" + dbRev.RestaurantID + "\" \"" + blRev.RestaurantID + '"');
Assert.AreEqual(dbRev.ID, blRev.ID, "ID: \"" + dbRev.ID + "\" \"" + blRev.ID + '"');
}
}
}
}
public static DataProject.Restaurant ConvertRestaurantToDB(Restaurant restaurant)
{
DataProject.Restaurant result = new DataProject.Restaurant
{
ID = restaurant.ID,
Address = restaurant.Address,
PhoneNum = restaurant.PhoneNum,
City = restaurant.City,
State = restaurant.State,
ZIP = restaurant.ZIP,
Name = restaurant.Name,
AvgRating = restaurant.AvgRating
};
return(result);
}
public static DataProject.Restaurant ConvertRestaurantToDB(Restaurant restaurant)
{
DataProject.Restaurant result = new DataProject.Restaurant
{
ID = restaurant.ID,
Address = restaurant.Address,
PhoneNum = restaurant.PhoneNum,
City = restaurant.City,
State = restaurant.State,
ZIP = restaurant.ZIP,
Name = restaurant.Name,
AvgRating = restaurant.AvgRating,
Reviews = new List <DataProject.Review>()
};
foreach (Review rev in restaurant.Reviews)
{
result.Reviews.Add(ConvertReviewToDB(rev));
}
return(result);
}
public static Restaurant ConvertRestaurantFromDB(DataProject.Restaurant dbRestaurant)
{
Restaurant result = new Restaurant
{
ID = dbRestaurant.ID,
Address = dbRestaurant.Address,
PhoneNum = dbRestaurant.PhoneNum,
City = dbRestaurant.City,
State = dbRestaurant.State,
ZIP = dbRestaurant.ZIP,
Name = dbRestaurant.Name,
Reviews = new List <Review>()
};
ICollection <DataProject.Review> reviews = dbRestaurant.Reviews;
foreach (DataProject.Review rev in reviews)
{
result.AddReview(ConvertReviewFromDB(rev));
}
return(result);
}
public void TestConvertRestaurantFromDB()
{
dbRest = new DataProject.Restaurant
{
Name = name,
ID = restId,
Address = address,
City = city,
AvgRating = 5f,
PhoneNum = phoneNum,
Reviews = new List <DataProject.Review>(),
State = state,
ZIP = zip
};
dbRev = new DataProject.Review
{
ID = revId,
Rating = rating,
Description = desc,
RestaurantID = restId
};
dbRest.Reviews.Add(dbRev);
blRest = Converter.ConvertRestaurantFromDB(dbRest);
blRev = ((List <LibraryProject.Review>)blRest.Reviews)[0];
Assert.AreEqual(dbRest.Address, blRest.Address, "Address: \"" + dbRest.Address + "\" \"" + blRest.Address + '"');
Assert.AreEqual(dbRest.AvgRating, blRest.AvgRating, "AvgRating: \"" + dbRest.AvgRating + "\" \"" + blRest.AvgRating + '"');
Assert.AreEqual(dbRest.City, blRest.City, "City: \"" + dbRest.City + "\" \"" + blRest.City + '"');
Assert.AreEqual(dbRest.ID, blRest.ID, "ID: \"" + dbRest.ID + "\" \"" + blRest.ID + '"');
Assert.AreEqual(dbRest.Name, blRest.Name, "Name: \"" + dbRest.Name + "\" \"" + blRest.Name + '"');
Assert.AreEqual(dbRest.PhoneNum, blRest.PhoneNum, "PhoneNum: \"" + dbRest.PhoneNum + "\" \"" + blRest.PhoneNum + '"');
Assert.AreEqual(dbRest.State, blRest.State, "State: \"" + dbRest.State + "\" \"" + blRest.Address + '"');
Assert.AreEqual(dbRest.ZIP, blRest.ZIP, "ZIP: \"" + dbRest.ZIP + "\" \"" + blRest.ZIP + '"');
Assert.AreEqual(dbRev.Description, blRev.Description, "Description: \"" + dbRev.Description + "\" \"" + blRev.Description + '"');
Assert.AreEqual(dbRev.Rating, blRev.Rating, "Rating: \"" + dbRev.Rating + "\" \"" + blRev.Rating + '"');
Assert.AreEqual(dbRev.RestaurantID, blRev.RestaurantID, "RestaurantID: \"" + dbRev.RestaurantID + "\" \"" + blRev.RestaurantID + '"');
Assert.AreEqual(dbRev.ID, blRev.ID, "ID: \"" + dbRev.ID + "\" \"" + blRev.ID + '"');
}
public static Restaurant ConvertRestaurantFromDB(DataProject.Restaurant dbRestaurant)
{
Restaurant result;
if (dbRestaurant == null)
{
result = null;
}
else
{
result = new Restaurant
{
ID = dbRestaurant.ID,
Address = dbRestaurant.Address,
PhoneNum = dbRestaurant.PhoneNum,
City = dbRestaurant.City,
State = dbRestaurant.State,
ZIP = dbRestaurant.ZIP,
Name = dbRestaurant.Name,
AvgRating = (float)dbRestaurant.AvgRating
};
}
return(result);
}
