public static void Main()
{
Cook joe = new Cook();
Waiter suzy = new Waiter(joe);
Customer fred = new Customer(suzy);
fred.PlaceOrder();
}
private void SpawnFoodPrefab(Cook foodPrefab)
{
Vector3 center = this.dryingGrid.center;
Vector3 vector = this.dryingGrid.size * 0.5f;
Vector3 vector2 = center;
Vector3 vector3 = center;
vector2.x += vector.x;
vector2.z += vector.z;
vector3.x -= vector.x;
vector3.z -= vector.z;
Vector3 position = new Vector3(UnityEngine.Random.Range(vector3.x, vector2.x), center.y, UnityEngine.Random.Range(vector3.z, vector2.z));
position.x -= position.x % this.gridChunkSize.x;
position.z -= position.z % this.gridChunkSize.y;
if (BoltNetwork.isRunning)
{
PlaceConstruction placeConstruction = PlaceConstruction.Create(GlobalTargets.OnlyServer);
placeConstruction.PrefabId = foodPrefab.GetComponent<BoltEntity>().prefabId;
placeConstruction.Position = this.dryingGrid.transform.TransformPoint(position);
placeConstruction.Rotation = Quaternion.identity;
placeConstruction.Parent = base.transform.parent.GetComponent<BoltEntity>();
placeConstruction.Send();
}
else
{
Cook cook = (Cook)UnityEngine.Object.Instantiate(foodPrefab, this.dryingGrid.transform.TransformPoint(position), Quaternion.identity);
cook.transform.parent = base.transform.parent;
}
}
public void Contains_OnTopLevel ()
{
var cook = new Cook { ID = 23, FirstName = "Hugo", Name = "Heinrich" };
CheckQuery (
( () => (from s in Cooks select s).Contains(cook)),
"SELECT CONVERT(BIT, CASE WHEN @1 IN (SELECT [t0].[ID] FROM [CookTable] AS [t0]) THEN 1 ELSE 0 END) AS [value]",
row => (object) row.GetValue<bool> (new ColumnID ("value", 0)),
new CommandParameter("@1", 23) );
}
public void Contains_WithConstantAndDependentQuery ()
{
var cook = new Cook { ID = 23, FirstName = "Hugo", Name = "Heinrich" };
CheckQuery (
from s in Cooks where s.Assistants.Contains (cook) select s.ID,
"SELECT [t0].[ID] AS [value] "
+"FROM [CookTable] AS [t0] WHERE @1 IN (SELECT [t1].[ID] FROM [CookTable] AS [t1] WHERE ([t0].[ID] = [t1].[AssistedID]))",
new CommandParameter("@1", 23));
}
public void Contains_WithConstant ()
{
var cook = new Cook { ID = 23, FirstName = "Hugo", Name = "Heinrich" };
CheckQuery (
from s in Cooks where (from s2 in Cooks select s2).Contains (cook) select s.ID,
"SELECT [t0].[ID] AS [value] "
+ "FROM [CookTable] AS [t0] WHERE @1 IN (SELECT [t1].[ID] FROM [CookTable] AS [t1])",
new CommandParameter("@1", 23));
}
// GET: CookController/Create
public ActionResult Create()
{
Cook cook = new Cook();
{
cook.AllTags = GetTags();
}
return(View(cook));
}
public IHttpActionResult GetCook(int id)
{
Cook cook = db.Cooks.Find(id);
if (cook == null)
{
return(NotFound());
}
return(Ok(cook));
}
public ActionResult Create([Bind(Include = "ID,UID,PID")] Cook cook)
{
if (ModelState.IsValid)
{
db.Cooks.Add(cook);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cook));
}
public void TakeAndContains()
{
Cook cook = new Cook {
ID = 5, FirstName = "Hugo", Name = "Hanser"
};
CheckQuery(
() => Cooks.Take(1).Contains(cook),
"SELECT CONVERT(BIT, CASE WHEN @1 IN (SELECT TOP (1) [t0].[ID] FROM [CookTable] AS [t0]) THEN 1 ELSE 0 END) AS [value]",
new CommandParameter("@1", cook.ID));
}
public static Employee GetEmployee()
{
Employee waiter = new Waiter(Priority.Low);
Employee cook = new Cook(Priority.Medium);
Employee manager = new Manager(Priority.High);
waiter.SetSuccessor(cook);
cook.SetSuccessor(manager);
return(waiter);
}
public void Cook_Proces_3()
{
cook = new Cook(3);
cook.Process(npc.Object, null);
npc.Verify(e => e.EnqueueCommand("Wait"), Times.Exactly(20));
npc.Verify(e => e.EnqueueCommand("Say As the king wishes."), Times.Once);
npc.Verify(e => e.EnqueueCommand("Emote stokes the cooking fire."), Times.Once);
npc.Verify(e => e.EnqueueCommand("Emote stirs the pot."), Times.Exactly(4));
npc.Verify(e => e.EnqueueCommand("Say here you go. Hasenpfeffer for the king."), Times.Once);
}
public void Update(Cook cook, DateTime finishTime)
{
if (cook == null)
{
return;
}
cook.FinishTime = finishTime;
_db.CookRepository.Update(cook);
}
public Cook FindCook()
{
Cook cook =
_db.CookRepository
.GetAll()
.OrderBy(x => x.FinishTime)
.ThenByDescending(x => x.SkillCoefficient)
.FirstOrDefault()
?? throw new Exception("There is no cooks");
return(cook);
}
public async Task <int> Delete(AuthenticationToken user, long id = 0)
{
using ApplicationDbContext _context = new ApplicationDbContext();
Cook deleteMe = new Cook {
Id = id
};
_context.Cooks.Remove(deleteMe);
int numberDeleted = await _context.SaveChangesAsync();
return(numberDeleted);
}
//I want to find all of the tags for my cook **
// then, I want to find all recpies tagged with the same tags related to my cook**
// i.e., cook only wants vegan recipes ("TagId = 1"), we then query the RecipeTags table and find all recipes with a
// TagId == 1. I want to have a list of RecipeIds from this query**
// then, I want to query my recipes table for all of the recipes that match list of RecipeIds and add them to a list**
// Then, I want to pass six of those recipes to a view and display them as a grid that the cook can see
// Ideally, I want to randomly select the six recipes
private List <int> FindCookTags(Cook cook)
{
var selectedCook = _repo.Cook.FindByCondition(c => c.CookId == cook.CookId).SingleOrDefault();
var cookTags = _repo.CookTag.FindByCondition(c => c.CookId == selectedCook.CookId);
List <int> recipeTags = new List <int>();
foreach (CookTag cookTag in cookTags)
{
recipeTags.Add(cookTag.TagsId);
}
return(recipeTags);
}
public void T10_Cheap_Burger_Should_Cost_0()
{
// Given
var cook = new Cook();
var cheepBurger = cook.Create(null);
var cashRegister = new CashRegister();
// When
var price = cashRegister.HowMuch(cheepBurger);
// Then
Assert.AreEqual(price, 0);
}
public async Task <int> Update(AuthenticationToken user, long id = 0, string name = "")
{
using ApplicationDbContext _context = new ApplicationDbContext();
Cook updateMe = new Cook {
Id = id, Name = name
};
_context.Cooks.Update(updateMe);
int numberUpdated = await _context.SaveChangesAsync();
return(numberUpdated);
}
public async Task <int> Create(AuthenticationToken user, string name = "")
{
using ApplicationDbContext _context = new ApplicationDbContext();
Cook makeMe = new Cook {
Name = name
};
_context.Cooks.Add(makeMe);
int numberCreated = await _context.SaveChangesAsync();
return(numberCreated);
}
public void OnTouched()
{
if (!HasTray())
{
if (Cook.Get().IsHolding <Tray>())
{
Cook.Get().DropRightHand(m_trayPlaceholder);
}
return;
}
}
public void T11_Vege_Burger_Should_Cost_5()
{
// Given
var cook = new Cook();
var burger = cook.Create(new VegeBurgerMaker());
var cashRegister = new CashRegister();
// When
var price = cashRegister.HowMuch(burger);
// Then
Assert.AreEqual(price, 5);
}
public void T12_English_Burger_Should_Cost_25()
{
// Given
var cook = new Cook();
var burger = cook.Create(new EnglishBurgerMaker());
var cashRegister = new CashRegister();
// When
var price = cashRegister.HowMuch(burger);
// Then
Assert.AreEqual(price, 25);
}
public void Contains_WithConstant()
{
var cook = new Cook {
ID = 23, FirstName = "Hugo", Name = "Heinrich"
};
CheckQuery(
from s in Cooks where (from s2 in Cooks select s2).Contains(cook) select s.ID,
"SELECT [t0].[ID] AS [value] "
+ "FROM [CookTable] AS [t0] WHERE @1 IN (SELECT [t1].[ID] FROM [CookTable] AS [t1])",
new CommandParameter("@1", 23));
}
public void T10_Double_Cheese_Burger_Should_Cost_20()
{
// Given
var cook = new Cook();
var burger = cook.Create(new DoubleCheeseburgerMaker());
var cashRegister = new CashRegister();
// When
var price = cashRegister.HowMuch(burger);
// Then
Assert.AreEqual(price, 20);
}
public void Contains_OnTopLevel()
{
var cook = new Cook {
ID = 23, FirstName = "Hugo", Name = "Heinrich"
};
CheckQuery(
(() => (from s in Cooks select s).Contains(cook)),
"SELECT CONVERT(BIT, CASE WHEN @1 IN (SELECT [t0].[ID] FROM [CookTable] AS [t0]) THEN 1 ELSE 0 END) AS [value]",
row => (object)row.GetValue <bool> (new ColumnID("value", 0)),
new CommandParameter("@1", 23));
}
public void Contains_WithConstantAndDependentQuery()
{
var cook = new Cook {
ID = 23, FirstName = "Hugo", Name = "Heinrich"
};
CheckQuery(
from s in Cooks where s.Assistants.Contains(cook) select s.ID,
"SELECT [t0].[ID] AS [value] "
+ "FROM [CookTable] AS [t0] WHERE @1 IN (SELECT [t1].[ID] FROM [CookTable] AS [t1] WHERE ([t0].[ID] = [t1].[AssistedID]))",
new CommandParameter("@1", 23));
}
/// <summary>
///
/// </summary>
/// <param name="sender">kontrolka wywołująca zdarzenie</param>
/// <param name="e">argumenty zdarzenia</param>
private void buttonFillRightDataGridView_Click(object sender, EventArgs e)
{
switch (listBoxDatabaseTableChoosing.SelectedIndex)
{
case 0:
Deliverer.GetAllDeliverers(sqlConnection, sqlDataAdapter, dataGridViewSecondTable);
break;
case 1:
Supply.GetAllSupplies(sqlConnection, sqlDataAdapter, dataGridViewSecondTable);
break;
case 2:
Delivery.GetAllDeliveries(sqlConnection, sqlDataAdapter, dataGridViewSecondTable);
break;
case 3:
Waiter.GetAllWaiters(sqlConnection, sqlDataAdapter, dataGridViewSecondTable);
break;
case 4:
Client.GetAllClients(sqlConnection, sqlDataAdapter, dataGridViewSecondTable);
break;
case 5:
Cook.GetAllCooks(sqlConnection, sqlDataAdapter, dataGridViewSecondTable);
break;
case 6:
Manager.GetAllManagers(sqlConnection, sqlDataAdapter, dataGridViewSecondTable);
break;
case 7:
Meal.GetAllMeals(sqlConnection, sqlDataAdapter, dataGridViewSecondTable);
break;
case 8:
MealCategory.GetAllMealCategories(sqlConnection, sqlDataAdapter, dataGridViewSecondTable);
break;
case 9:
Car.GetAllCars(sqlConnection, sqlDataAdapter, dataGridViewSecondTable);
break;
case 10:
Shopping.GetAllShoppings(sqlConnection, sqlDataAdapter, dataGridViewSecondTable);
break;
case 11:
Transaction.GetAllTransactions(sqlConnection, sqlDataAdapter, dataGridViewSecondTable);
break;
}
}
public IHttpActionResult PostCook(Cook cook)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Cooks.Add(cook);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = cook.Id }, cook));
}
private void OnTriggerEnter(Collider other)
{
Cook cook = other.GetComponent <Cook>();
if (cook != null)
{
cook.inCabinetSlice = this;
//Debug.Log("cook.inCabinetSlice = this;");
}
// if (sliceFood != null) sliceFood.slicing();
}
public void EntityConstantExpression_WithReference()
{
var cook = new Cook {
ID = 5, Name = "Maier", FirstName = "Hugo"
};
CheckQuery(
from c in Cooks where c == cook select c.FirstName,
"SELECT [t0].[FirstName] AS [value] FROM [CookTable] AS [t0] WHERE ([t0].[ID] = @1)",
new CommandParameter("@1", cook.ID)
);
}
private void Update()
{
if (TheForest.Utils.Input.GetButtonAfterDelay("Take", 0.5f))
{
LocalPlayer.Sfx.PlayWhoosh();
if (!this.IsWater)
{
if (!this.Burnt)
{
Cook componentInParent = base.GetComponentInParent <Cook>();
switch ((!componentInParent) ? DecayingInventoryItemView.DecayStates.Fresh : componentInParent._decayState)
{
case DecayingInventoryItemView.DecayStates.None:
case DecayingInventoryItemView.DecayStates.Fresh:
LocalPlayer.Stats.AteFreshMeat(this.IsLimb, this.Size);
break;
case DecayingInventoryItemView.DecayStates.Edible:
LocalPlayer.Stats.AteEdibleMeat(this.IsLimb, this.Size);
break;
case DecayingInventoryItemView.DecayStates.Spoilt:
LocalPlayer.Stats.AteSpoiltMeat(this.IsLimb, this.Size);
break;
}
}
else
{
LocalPlayer.Stats.AteBurnt(this.IsLimb, this.Size);
}
if (this._remainsYield > 0)
{
LocalPlayer.Inventory.AddItem(this._remainsItemId, this._remainsYield, false, false, (WeaponStatUpgrade.Types)(-2));
}
}
else
{
LocalPlayer.Sfx.PlayDrink();
LocalPlayer.Stats.Thirst = 0f;
}
if (BoltNetwork.isRunning && this.entity && this.entity.isAttached)
{
RequestDestroy requestDestroy = RequestDestroy.Create(GlobalTargets.Everyone);
requestDestroy.Entity = this.entity;
requestDestroy.Send();
}
else
{
UnityEngine.Object.Destroy(base.transform.parent.gameObject);
}
}
}
/// <summary>
/// 生成二维码
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Cook(string id)
{
Cook cook = new Cook();
//必须先声明类型，默认是二维码
//cook.Type = Cook.CodeType.CODE39;
//要的图片的大小(默认200*200)
cook.Width = 200;
cook.Height = 200;
cook.Content = "http://localhost:49158/ReViewQRCode?Id=" + id;
return(File(cook.GetStream(), "image/png"));
}
/// <summary>
/// 生成二维码
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Cook(string id)
{
Cook cook = new Cook();
//必须先声明类型，默认是二维码
//cook.Type = Cook.CodeType.CODE39;
//要的图片的大小(默认200*200)
cook.Width = 200;
cook.Height = 200;
cook.Content = "http://xydx18.wcampaign.cn/Contents/Index/?Id=" + id;
return(File(cook.GetStream(), "image/png"));
}
public void SubQuery_SelectingEntityConstant()
{
var cook = new Cook {
ID = 1
};
CheckQuery(
from c in Cooks where (from k in Kitchens select cook).First() == c select c.ID,
"SELECT [t0].[ID] AS [value] "
+ "FROM [CookTable] AS [t0] "
+ "WHERE ((SELECT TOP (1) @1 AS [value] FROM [KitchenTable] AS [t1]) = [t0].[ID])",
new CommandParameter("@1", 1));
}
public void T05_None_BurgerMaker_ShouldReturn_None_Burger()
{
// Given
var cook = new Cook();
// When
var burger = cook.Create(null);
var burger2 = burger;
// Then
Assert.AreEqual(burger.Meet.Type, MeetType.None);
Assert.AreEqual(burger.Cheeseness, Cheeseness.None);
Assert.AreEqual(burger.Addons.Contains(AddonType.None), true);
}
public async Task <IActionResult> Create([Bind("CookID,DishID,IngredientID")] Cook cook)
{
if (ModelState.IsValid)
{
_context.Add(cook);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["DishID"] = new SelectList(_context.Dishes, "DishID", "DishID", cook.DishID);
ViewData["IngredientID"] = new SelectList(_context.Ingredients, "IngredientID", "IngredientID", cook.IngredientID);
return(View(cook));
}
static void Main(string[] args)
{
PizzaBuilder hawaiianPizzaBuilder = new HawaiianPizzaBuilder();
Cook cook = new Cook();
cook.SetPizzaBuilder(hawaiianPizzaBuilder);
cook.ConstructPizza();
// create the product
Pizza hawaiian = cook.GetPizza();
PizzaBuilder spicyPizzaBuilder = new SpicyPizzaBuilder();
cook.SetPizzaBuilder(spicyPizzaBuilder);
cook.ConstructPizza();
// create another product
Pizza spicy = cook.GetPizza();
}
public void ExecuteInMemory ()
{
var student1 = new Chef ();
var student2 = new Chef ();
IEnumerable items = new Cook[] { student1, student2 };
var itemExpression = Expression.Constant (student1, typeof (Cook));
var input = new StreamedSequence (items, new StreamedSequenceInfo (typeof (Cook[]), itemExpression));
var result = _resultOperator.ExecuteInMemory<Cook> (input);
var sequence = result.GetTypedSequence<Chef>();
Assert.That (sequence.ToArray (), Is.EquivalentTo (new[] { student1, student2 }));
Assert.That (result.DataInfo.ResultItemType, Is.EqualTo (typeof (Chef)));
Assert.That (((UnaryExpression) result.DataInfo.ItemExpression).Operand, Is.SameAs (itemExpression));
}
public void ExecuteQueryModel_NoDefaultWhenEmpty ()
{
var queryModel = ExpressionHelper.CreateQueryModel<Cook> ();
var student1 = new Cook ();
var executorMock = MockRepository.GenerateMock<IQueryExecutor> ();
executorMock.Expect (mock => mock.ExecuteSingle<Cook> (queryModel, false)).Return (student1);
var streamedData = _streamedSingleValueInfoNoDefault.ExecuteQueryModel (queryModel, executorMock);
executorMock.VerifyAllExpectations ();
Assert.That (streamedData, Is.InstanceOf (typeof (StreamedValue)));
Assert.That (streamedData.DataInfo, Is.SameAs (_streamedSingleValueInfoNoDefault));
Assert.That (streamedData.Value, Is.EqualTo (student1));
}
public void SubQuery_SelectingEntityConstant ()
{
var cook = new Cook { ID = 1 };
CheckQuery (
from c in Cooks where (from k in Kitchens select cook).First() == c select c.ID,
"SELECT [t0].[ID] AS [value] "
+ "FROM [CookTable] AS [t0] "
+ "WHERE ((SELECT TOP (1) @1 AS [value] FROM [KitchenTable] AS [t1]) = [t0].[ID])",
new CommandParameter ("@1", 1));
}
public void EntityConstantExpression_WithReference ()
{
var cook = new Cook { ID = 5, Name = "Maier", FirstName = "Hugo" };
CheckQuery (
from c in Cooks where c == cook select c.FirstName,
"SELECT [t0].[FirstName] AS [value] FROM [CookTable] AS [t0] WHERE ([t0].[ID] = @1)",
new CommandParameter ("@1", cook.ID)
);
}
public TypeForNewExpression (Cook d)
{
D = d;
}
public void DefaultIfEmpty ()
{
var student = new Cook ();
var query = (from s in ExpressionHelper.CreateQueryable<Cook> ()
select s).DefaultIfEmpty (student);
var queryModel = QueryParser.GetParsedQuery (query.Expression);
Assert.That (queryModel.GetOutputDataInfo ().DataType, Is.SameAs (typeof (IQueryable<Cook>)));
Assert.That (queryModel.ResultOperators.Count, Is.EqualTo (1));
Assert.That (queryModel.ResultOperators[0], Is.InstanceOf (typeof (DefaultIfEmptyResultOperator)));
Assert.That (((DefaultIfEmptyResultOperator) queryModel.ResultOperators[0]).GetConstantOptionalDefaultValue(), Is.SameAs (student));
}
public void Contains ()
{
var student = new Cook ();
var expression = ExpressionHelper.MakeExpression (() => (from s in QuerySource
select s).Contains (student));
var queryModel = QueryParser.GetParsedQuery (expression);
Assert.That (queryModel.GetOutputDataInfo ().DataType, Is.SameAs (typeof (bool)));
Assert.That (queryModel.ResultOperators.Count, Is.EqualTo (1));
Assert.That (queryModel.ResultOperators[0], Is.InstanceOf (typeof (ContainsResultOperator)));
Assert.That (((ContainsResultOperator) queryModel.ResultOperators[0]).GetConstantItem<Cook>(), Is.SameAs (student));
}
public void SubQuery_SelectingEntityConstant_FromAdditionalFromClause ()
{
var cook = new Cook { ID = 1 };
CheckQuery (
from c in Cooks
from x in (from k in Kitchens select cook)
where x == c select c.ID,
"SELECT [t0].[ID] AS [value] "
+ "FROM [CookTable] AS [t0] "
+ "CROSS JOIN (SELECT @1 AS [value] FROM [KitchenTable] AS [t2]) AS [q1] "
+ "WHERE ([q1].[value] = [c].[ID])",
new CommandParameter ("@1", 1));
}
public Command(Cook c)
{
cook = c;
}
public BarbecuerCommand(Cook c)
: base(c)
{
}
public Waiter(Cook c)
{
cook = c;
}
public void Execute ()
{
var expectedResult = new Cook[0];
Expression expression = (from s in _queryableWithDefaultParser select s).Expression;
_queryParserMock
.Expect (mock => mock.GetParsedQuery (expression))
.Return (_fakeQueryModel);
_queryParserMock.Replay ();
_executorMock
.Expect (mock => mock.ExecuteCollection<Cook> (_fakeQueryModel))
.Return (expectedResult);
_executorMock.Replay ();
var result = _queryProvider.Execute (expression);
_queryParserMock.VerifyAllExpectations ();
_executorMock.VerifyAllExpectations ();
Assert.That (result.Value, Is.EqualTo (expectedResult));
}
private static bool FakeEqualityOperator (Cook one, Cook two)
{
throw new NotImplementedException();
}
private static IEnumerable<object> GetSampleDataEntities ()
{
var company1 = new Company { ID = 1, MainRestaurant = null, MainKitchen = null, DateOfIncorporation = new DateTime (2001, 01, 13)};
var company2 = new Company { ID = 2, MainRestaurant = null, MainKitchen = null, DateOfIncorporation = new DateTime (1886, 02, 20) };
var restaurant1 = new Restaurant { ID = 1, CompanyIfAny = company1};
company1.MainRestaurant = restaurant1;
var restaurant2 = new Restaurant { ID = 2 };
company2.MainRestaurant = restaurant2;
var kitchen1 = new Kitchen
{
ID = 1,
Name = "Jamie's Kitchen",
Cook = null,
LastCleaningDay = new DateTime (2012, 5, 13),
LastInspectionScore = 80,
PassedLastInspection = true,
Restaurant = restaurant1,
RoomNumber = 17
};
company1.MainKitchen = kitchen1;
var kitchen2 = new Kitchen
{
ID = 2,
Name = "Perfumerie",
Cook = null,
LastCleaningDay = null,
LastInspectionScore = null,
PassedLastInspection = null,
Restaurant = restaurant1,
RoomNumber = 1
};
var kitchen3 = new Kitchen
{
ID = 3,
Name = "Bocuse's Kitchen",
Cook = null,
LastCleaningDay = DateTime.Today,
LastInspectionScore = 100,
PassedLastInspection = true,
Restaurant = restaurant2,
RoomNumber = 2
};
company2.MainKitchen = kitchen3;
var knife1 = new Knife { ID = new MetaID (1, "KnifeClass"), Sharpness = 10.0 };
var cook1 = new Cook
{
ID = 1,
FirstName = "Peter Paul",
Name = "Rubens",
IsStarredCook = false,
IsFullTimeCook = false,
Substitution = null,
Kitchen = null,
KnifeID = knife1.ID,
Knife = knife1
};
var knife2 = new Knife { ID = new MetaID (2, "DerivedKnifeClass"), Sharpness = 5.0 };
var cook2 = new Cook
{
ID = 2,
FirstName = "Jamie",
Name = "Oliver",
IsStarredCook = true,
IsFullTimeCook = false,
Substitution = null,
Kitchen = kitchen1,
KnifeID = knife2.ID,
Knife = knife2
};
kitchen1.Cook = cook2;
var cook3 = new Cook
{
ID = 3,
FirstName = "Hugo",
Name = "Boss",
IsStarredCook = false,
IsFullTimeCook = true,
Substitution = cook1,
Kitchen = kitchen2
};
cook1.Substituted = cook3;
kitchen2.Cook = cook3;
var chef1 = new Chef
{
ID = 4,
FirstName = "Paul",
Name = "Bocuse",
IsStarredCook = true,
IsFullTimeCook = false,
Substitution = cook1,
Kitchen = kitchen3,
LetterOfRecommendation = "A really great chef!"
};
cook1.Substituted = chef1;
kitchen3.Cook = chef1;
var chef2 = new Chef
{
ID = 5,
FirstName = "Caul",
Name = "Bopuse",
IsStarredCook = false,
IsFullTimeCook = true,
Substitution = cook2,
Kitchen = null,
LetterOfRecommendation = null
};
cook2.Substituted = chef2;
return new object[] { company1, company2, restaurant1, restaurant2, kitchen1, kitchen2, kitchen3, chef1, chef2, knife1, knife2, cook1, cook2, cook3 };
}
public void Execute_IntegrationWithSingle ()
{
var expectedResult = new Cook ();
_executorMock
.Expect (mock => mock.ExecuteSingle<Cook> (Arg<QueryModel>.Is.Anything, Arg<bool>.Is.Equal (false)))
.Return (expectedResult);
_executorMock.Replay ();
var result = (from s in _queryableWithDefaultParser select s).Single();
_executorMock.VerifyAllExpectations ();
Assert.That (result, Is.SameAs(expectedResult));
}
public void TakeAndContains ()
{
Cook cook = new Cook { ID = 5, FirstName = "Hugo", Name = "Hanser" };
CheckQuery (
() => Cooks.Take (1).Contains (cook),
"SELECT CONVERT(BIT, CASE WHEN @1 IN (SELECT TOP (1) [t0].[ID] FROM [CookTable] AS [t0]) THEN 1 ELSE 0 END) AS [value]",
new CommandParameter("@1", cook.ID));
}
public void Execute_Explicit_Generic ()
{
var expectedResult = new Cook[0];
Expression expression = (from s in _queryableWithDefaultParser select s).Expression;
_queryParserMock
.Expect (mock => mock.GetParsedQuery (expression))
.Return (_fakeQueryModel);
_queryParserMock.Replay();
_executorMock
.Expect (mock => mock.ExecuteCollection<Cook> (_fakeQueryModel))
.Return (expectedResult);
_executorMock.Replay ();
var result = ((IQueryProvider) _queryProvider).Execute<IEnumerable<Cook>> (expression);
_queryParserMock.VerifyAllExpectations();
_executorMock.VerifyAllExpectations ();
Assert.That (result.ToArray(), Is.EqualTo (expectedResult));
}
public static IQueryable<Cook> CreateSubQueryWithConstantInWhereClause (IQueryable<Cook> source)
{
Cook cook = new Cook {ID = 5};
return from s in source where (from s2 in source select s2).Contains (cook) select s;
}
public void Execute_Explicit_NonGeneric_WithExpressionTreeReturningSpecificQueryableType ()
{
var expectedResult = new Cook[0];
Expression expression = _queryableWithDefaultParser.Expression;
_queryParserMock
.Expect (mock => mock.GetParsedQuery (expression))
.Return (_fakeQueryModel);
_queryParserMock.Replay ();
_executorMock
.Expect (mock => mock.ExecuteCollection<Cook> (_fakeQueryModel))
.Return (new Cook[0]);
_executorMock.Replay ();
var result = ((IQueryProvider) _queryProvider).Execute (expression);
_queryParserMock.VerifyAllExpectations ();
_executorMock.VerifyAllExpectations ();
Assert.That (((IEnumerable<Cook>) result).ToArray (), Is.EqualTo (expectedResult));
}
public FryDishCommand(Cook c)
: base(c)
{
}
