public void insertOrder_BC_R_ToDBTest()
{
WebOrderDBBaseItem order = createBasicOrderFromTPCCode(WebMateTestSettings.ThirdPartyCodeKey);
order.TabContainerName = getGuidFromWebOrderKey(WebMateTestSettings.WebOrderKey);
order.TabKey = getTabKeyForWebOrder(
WebMateTestSettings.WebOrderKey,
WebMateTestSettings.WebOrderTabName);
order.TimeKey = setTimeKey();
order.SecurityRef = getNextSecurityRef();
order.Categories.PrimaryArcCategoryKey = getArcCategoryKeyFromCategory(order.Categories.FinancialCategory);
bool result = target.insertOrderBaseDataToDB(
target.connection_,
target.transaction_,
ref order);
result = target.insertOrderBreakdownCategoriesToDB(
target.connection_,
target.transaction_,
order.OrderKey,
order.Categories);
WebOrderDBItem dbItem = (WebOrderDBItem)order;
result = target.insertOrderRecipesToDB(
target.connection_,
target.transaction_,
dbItem.OrderKey,
dbItem.ItemRecipes);
Assert.AreEqual(true, result);
}
private void setSidesInformation(ref WebOrderDBItem dbItem)
{
dbItem.ItemSides.Add(
new WebOrderDBItemSide()
{
ThirdPartyCodeKey = WebMateTestSettings.SideThirdPartyCode1,
Price = WebMateTestSettings.SideItem1Price,
PriceLevel0 = WebMateTestSettings.SideItem1PriceL0,
PriceLevel1 = WebMateTestSettings.SideItem1PriceL1,
Qty = WebMateTestSettings.Side1Qty
});
dbItem.ItemSides.Add(
new WebOrderDBItemSide()
{
ThirdPartyCodeKey = WebMateTestSettings.SideThirdPartyCode2,
Price = WebMateTestSettings.SideItem2Price,
PriceLevel0 = WebMateTestSettings.SideItem2PriceL0,
PriceLevel1 = WebMateTestSettings.SideItem2PriceL1,
Qty = WebMateTestSettings.Side3Qty
});
dbItem.ItemSides.Add(
new WebOrderDBItemSide()
{
ThirdPartyCodeKey = WebMateTestSettings.SideThirdPartyCode3,
Price = WebMateTestSettings.SideItem3Price,
PriceLevel0 = WebMateTestSettings.SideItem3PriceL0,
PriceLevel1 = WebMateTestSettings.SideItem3PriceL1,
Qty = WebMateTestSettings.Side3Qty
});
}
private WebOrderDBBaseItem createBasicOrderFromTPCCode(int p)
{
int itemSizeKey = target.getItemSizeKeyFromThirdPartyCodeKey(p);
WebOrderDBBaseItem item = new WebOrderDBItem();
item.TabName = "Mobi2Go";
target.loadBaseOrderData(
itemSizeKey,
ref item);
target.loadBaseOrderBreakdownCategories(
itemSizeKey,
ref item);
WebOrderDBItem dbItem = (WebOrderDBItem)item;
target.loadRecipes(
itemSizeKey,
ref dbItem);
setSidesInformation(ref dbItem);
target.loadSides(
ref dbItem);
return(item);
}
public void LoadBreakdownCategoriesTest()
{
int itemSizeKey = getItemSizeKeyFromTPC(1);
WebOrderDBBaseItem item = new WebOrderDBItem();
target.loadBaseOrderBreakdownCategories(itemSizeKey, ref item);
Assert.IsTrue(item.Categories.Count > 0);
}
public void loadBasicOrderDataTest()
{
int itemSizeKey = getItemSizeKeyFromTPC(WebMateTestSettings.ThirdPartyCodeKey);
WebOrderDBBaseItem item = new WebOrderDBItem();
target.loadBaseOrderData(itemSizeKey, ref item);
Assert.IsTrue(item.ItemId > 0);
}
public void LoadSidesTest()
{
int itemSizeKey = getItemSizeKeyFromTPC(WebMateTestSettings.ThirdPartyCodeKey);
WebOrderDBItem item = createWebOrderDBItem();
target.loadSides(ref item);
Assert.IsTrue(allItemSidesLoaded(item));
}
/// <summary>
///
/// </summary>
/// <param name="inOrder"></param>
/// <returns></returns>
WebOrderDBItem[] createWebOrderDBItems(WebOrder inOrder, WebOrderDB inWebOrderDB, int inMenuKey) //changes for menu_key
{
List <WebOrderDBItem> result = new List <WebOrderDBItem>();
//....................................................
DTO_WebOrderAccount accountSection = inOrder.GetCompleteAccountSection();
DTO_WebOrderHeader headerSection = inOrder.GetCompleteHeaderSection();
foreach (DTO_WebOrderItem orderItem in accountSection.OrderItems)
{
WebOrderDBItem item = new WebOrderDBItem();
item.ThirdPartyCodeKey = dbGetThirdPartyCodeKey(orderItem.UID, inWebOrderDB, inMenuKey); //changes for menu_key
item.Qty = orderItem.Qty;
item.Price = orderItem.BasePrice;
item.PriceLevel0 = orderItem.BasePrice;
item.PriceLevel1 = orderItem.BasePrice;
item.TabName = accountSection.Name;
item.TimeStamp = headerSection.OrderDate;
item.Note = orderItem.Note;
//--------------------------------------------------------
// Options are ignored in this version of Webmate
//--------------------------------------------------------
/*
* foreach (DTO_WebOrderItemOption orderItemOption in orderItem.ItemOptions)
* {
* WebOrderDBItemOption option = new WebOrderDBItemOption();
* option.OptionKey = Convert.ToInt32(orderItemOption.UID);
* item.ItemOptions.Add(option);
* }
*/
foreach (DTO_WebOrderItemSide orderItemSide in orderItem.ItemSides)
{
WebOrderDBItemSide side = new WebOrderDBItemSide();
side.ThirdPartyCodeKey = dbGetThirdPartyCodeKey(orderItemSide.UID, inWebOrderDB, inMenuKey); //changes for menu_key
side.Qty = orderItemSide.Qty;
side.Price = orderItemSide.BasePrice;
side.PriceLevel0 = orderItemSide.BasePrice;
side.PriceLevel1 = orderItemSide.BasePrice;
side.TimeStamp = headerSection.OrderDate;
side.TransactionNumber = orderItemSide.UID;
side.TabName = accountSection.Name;
side.Note = orderItem.Note;
item.ItemSides.Add(side);
}
result.Add(item);
}
//....................................................
return(result.ToArray());
}
private WebOrderDBBaseItem createOrderFromTPCCode(int p)
{
int itemSizeKey = target.getItemSizeKeyFromThirdPartyCodeKey(p);
WebOrderDBBaseItem item = new WebOrderDBItem();
target.loadBaseOrderData(
itemSizeKey,
ref item);
return(item);
}
private WebOrderDBBaseItem createOrderDbItem(int tpcCode)
{
WebOrderDBBaseItem item = new WebOrderDBItem();
int itemSizeKey = target.getItemSizeKeyFromThirdPartyCodeKey(tpcCode);
target.loadBaseOrderData(itemSizeKey, ref item);
item.TabName = "Mobi2Go";
item.TransactionNumber = Convert.ToString(tpcCode);
return(item);
}
private bool allItemSidesLoaded(WebOrderDBItem item)
{
foreach (WebOrderDBItemSide s in item.ItemSides)
{
if (s.ItemKey == 0)
{
return(false);
}
}
return(true);
}
private bool allOptionsLoaded(WebOrderDBItem item)
{
foreach (WebOrderDBItemOption o in item.ItemOptions)
{
if (o.OptionID == 0)
{
return(false);
}
}
return(true);
}
private void setOptionsInformation(ref WebOrderDBItem dbItem)
{
dbItem.ItemOptions.Add(
new WebOrderDBItemOption()
{
OptionKey = WebMateTestSettings.OptionKey1
});
dbItem.ItemOptions.Add(
new WebOrderDBItemOption()
{
OptionKey = WebMateTestSettings.OptionKey2
});
dbItem.ItemOptions.Add(
new WebOrderDBItemOption()
{
OptionKey = WebMateTestSettings.OptionKey3
});
}
private void setSidesInformation(ref WebOrderDBItem dbItem)
{
dbItem.ItemSides.Add(
new WebOrderDBItemSide()
{
ThirdPartyCodeKey = WebMateTestSettings.SideThirdPartyCode1
});
dbItem.ItemSides.Add(
new WebOrderDBItemSide()
{
ThirdPartyCodeKey = WebMateTestSettings.SideThirdPartyCode2
});
dbItem.ItemSides.Add(
new WebOrderDBItemSide()
{
ThirdPartyCodeKey = WebMateTestSettings.SideThirdPartyCode3
});
}
private WebOrderDBItem createWebOrderDBItem()
{
WebOrderDBItem item = new WebOrderDBItem();
item.ThirdPartyCodeKey = WebMateTestSettings.ThirdPartyCodeKey;
item.ItemSides.Add(
new WebOrderDBItemSide()
{
ThirdPartyCodeKey = WebMateTestSettings.SideThirdPartyCode1
});
item.ItemSides.Add(
new WebOrderDBItemSide()
{
ThirdPartyCodeKey = WebMateTestSettings.SideThirdPartyCode2
});
item.ItemSides.Add(
new WebOrderDBItemSide()
{
ThirdPartyCodeKey = WebMateTestSettings.SideThirdPartyCode3
});
item.ItemOptions.Add(
new WebOrderDBItemOption()
{
OptionKey = WebMateTestSettings.OptionKey1
});
item.ItemOptions.Add(
new WebOrderDBItemOption()
{
OptionKey = WebMateTestSettings.OptionKey2
});
item.ItemOptions.Add(
new WebOrderDBItemOption()
{
OptionKey = WebMateTestSettings.OptionKey3
});
return(item);
}
private WebOrderDBBaseItem createBasicOrderFromTPCCode(int p)
{
int itemSizeKey = target.getItemSizeKeyFromThirdPartyCodeKey(p);
WebOrderDBBaseItem item = new WebOrderDBItem();
item.TabName = "Mobi2Go";
item.Price = WebMateTestSettings.MainItemPrice;
item.PriceLevel0 = WebMateTestSettings.MainItemPriceL0;
item.PriceLevel1 = WebMateTestSettings.MainItemPriceL1;
item.Qty = WebMateTestSettings.MainItemQty;
target.loadBaseOrderData(
itemSizeKey,
ref item);
target.loadBaseOrderBreakdownCategories(
itemSizeKey,
ref item);
WebOrderDBItem dbItem = (WebOrderDBItem)item;
target.loadRecipes(
itemSizeKey,
ref dbItem);
setSidesInformation(ref dbItem);
target.loadSides(
ref dbItem);
setOptionsInformation(ref dbItem);
target.loadOptions(
ref dbItem);
return(item);
}
