public void SaveOrder(Order2 order)
{
lock (fileStore)
{
fileStore[order.OrderNumber] = order;
}
}
public void Put(int id, [FromBody] Order2 value, int Qty, int price)
{
Order2 update = dc.Order2.Single(m => m.Bid == id);
update.Bid = value.Bid;
update.Pname = value.Pname;
update.Quantity = value.Quantity;
update.Price = value.Price;
dc.SaveChanges();
}
public RedeemResponse Redeem(string orderNumber, string email)
{
OrderDB db = new OrderDB();
Order2 order = db.GetOrder(orderNumber);
if (order == null)
{
return(new RedeemResponse
{
Message = "",
Success = false
});
}
else if (String.IsNullOrWhiteSpace(email) || !Regex.IsMatch(email, "[a-zA-Z0-9]*@[a-zA-Z0-9]*\\.{1}[a-zA-Z]{1,}"))
{
return(new RedeemResponse
{
Success = false,
Message = "Email required to redeem password."
});
}
else if (order.EMail != null && !order.EMail.Equals(email))
{
return(new RedeemResponse
{
Success = false,
Message = "An email has already been set."
});
}
order.EMail = email;
if (order.PasswordClaimed == null)
{
order.PasswordClaimed = DateTime.Now;
db.SaveOrder(order);
}
RedeemResponse resp = new RedeemResponse();
resp.OrderInfoText = "Addr: " + order.Address + "\n" +
"Mail: " + order.EMail + "\n" +
"Name: " + order.Name + "\n" +
"Password: "******"\n" +
(order.PasswordClaimed != null ? "REDEEMED" : "");
resp.Success = true;
resp.Message = "";
return(resp);
}
public void LastLoadedOrderPaidAndSent()
{
OrderDB db = new OrderDB();
Order2 lastOrder = SimpleRandomLoader.GetLastLoadedOrder();
Order2 paidWebOrder = db.GetNextPaidOrder();
paidWebOrder.OrderSent = true;
paidWebOrder.Address = lastOrder.Address;
paidWebOrder.Password = lastOrder.Password;
db.SaveOrder(paidWebOrder);
db.DeleteOrder(lastOrder.OrderNumber);
waitingPaidOrder = db.GetNextPaidOrder();
}
private void SynchWithWebsite()
{
//Get latest web order in database:
lock (fileStore)
{
int lastWebOrder = 0;
int holeIndex = 0;
bool go = true;
List <string> keys = fileStore.Keys;
//Will not work.
while (go)
{
if (knownHoleStarts.Contains(lastWebOrder))
{
lastWebOrder = knownHoleEnds[holeIndex];
holeIndex++;
}
Order2 order = fileStore[OrderConverters.GetWebOrderNumber(lastWebOrder + 1)];
if (order == null)
{
break;
}
if (order.WebOrder) //Should always be true... TODO: Better error handling...
{
lastWebOrder = Math.Max(order.WebId ?? 0, lastWebOrder);
}
}
WebOrder webOrder = WebApiConnector.GetWebOrderByNumber(lastWebOrder + 1);
Order2 newOrder;
while (webOrder != null)
{
if (webOrder == null)
{
break;
}
newOrder = OrderConverters.ConvertWebOrderToDbOrder(webOrder);
fileStore[newOrder.OrderNumber] = newOrder;
webOrder = WebApiConnector.GetWebOrderByNumber(webOrder.Id + 1);
}
}
isSynchedWithWeb = true;
}
public void MapFieldTest2()
{
SourceObject2 source = new SourceObject2();
Order2 order = Map.ObjectToObject <Order2>(source);
Assert.AreEqual("1 Main", order.BillingAddress.Street);
Assert.AreEqual("Bigtown", order.BillingAddress.City);
Assert.AreEqual("XX", order.BillingAddress.State);
Assert.AreEqual("00000", order.BillingAddress.Zip);
Assert.AreEqual("2 Main", order.ShippingAddress.Street);
Assert.AreEqual("Bigtown", order.ShippingAddress.City);
Assert.AreEqual("XX", order.ShippingAddress.State);
Assert.AreEqual("00000", order.ShippingAddress.Zip);
}
static void Main(string[] args)
{
////////////////////////// Objects //////////////////////
Location2 P1 = new Location2();
ConsoleMenu menus = new ConsoleMenu();
Order2 orderRepository = new Order2();
var repo = new OrderRepository(new PizzaPalacedbContext());
/////////////////////////////////////////////////////////
//var repo = new OrderRepository(new PizzaPalacedbContext());
bool a = true;
while (a)
{
///////////////// call first menu [ WELCOME ] //////////////////////
//Console.WriteLine("Enter Name: ");
//string user = Console.ReadLine();
//Console.WriteLine("Enter LastName: ");
//string last = Console.ReadLine();
//repo.GetUserOrder(user, last);
//menus.WellcomeMenu();
//repo.GetUserOrder("Kevin", "Ramos");
//int location_id = 1;
//var locations = repo.GetLocationOrders(location_id);
//foreach (var item in locations)
//{
// Console.WriteLine("Location: 1 " + " Order No. " + item.OrderId + " \n Order Date & time: " + item.DateTimeOrder);
//}
//Console.ReadLine();
repo.SugestedOrder("Angel", "Guzman");
/////////////////////////////////////////////////////////////////
Console.WriteLine("");
Console.WriteLine("");
Console.WriteLine("DONE!!");
Console.WriteLine("");
Console.WriteLine();
Console.ReadLine();
a = false;
////////////////////////////////////////////////////////////////////
}
}
public void CleanRedeemedPasswords()
{
lock (fileStore)
{
List <string> keys = fileStore.Keys;
foreach (string key in keys)
{
Order2 order = fileStore[key];
if (DateTime.Now - order.PasswordClaimed > TimeSpan.FromDays(30))
{
order.Password = "";
}
fileStore[key] = order;
}
}
}
private void LoadData()
{
Stream stream = System.Reflection.Assembly.GetAssembly(this.GetType()).GetManifestResourceStream("Telerik.Examples.WinControls.PivotGrid.Settings.PivotData.txt");
using (StreamReader streamReader = new StreamReader(stream))
{
while (streamReader.Peek() != -1)
{
string[] items = streamReader.ReadLine().Split('\t');
Order2 o = new Order2()
{
Date = DateTime.Parse(items[0], System.Globalization.CultureInfo.InvariantCulture),
Product = items[1],
Quantity = int.Parse(items[2], System.Globalization.CultureInfo.InvariantCulture),
Net = double.Parse(items[3], System.Globalization.CultureInfo.InvariantCulture),
Promotion = items[4],
Advertisement = items[5]
};
orders.Add(o);
}
}
}
public string SearchOrder(string orderNumber)
{
if (orderNumber == null || orderNumber.Length != 8)
{
return("Type an order number above...");
}
OrderDB db = new OrderDB();
Order2 order = db.GetOrder(orderNumber);
if (order == null)
{
return("Type an order number above...");
}
db.CleanRedeemedPasswords();
return("Addr: " + order.Address + "\n" +
"Mail: " + order.EMail + "\n" +
"Name: " + order.Name + "\n" +
"Password: "******"\n" +
(order.PasswordClaimed != null ? "REDEEMED" : ""));
}
public Order2 GetNextPaidOrder()
{
if (!isSynchedWithWeb)
{
SynchWithWebsite();
}
lock (fileStore)
{
Order2 order = null; //= fileStore[OrderConverters.GetWebOrderNumber(4)];
int lastWebOrder = 0;
int holeIndex = 0;
while (true)
{
if (knownHoleStarts.Contains(lastWebOrder))
{
lastWebOrder = knownHoleEnds[holeIndex];
holeIndex++;
}
order = fileStore[OrderConverters.GetWebOrderNumber(lastWebOrder + 1)];
lastWebOrder++;
if (order == null)
{
break;
}
if (order.OrderPaid != null && order.OrderSent == false)
{
return(order);
}
}
}
return(null);
}
/// <summary>
/// Returns null at success otherwise errormessage.
/// </summary>
public static string ModifyHtmlFile(CardSettings settings, Order2 waitingPaidOrder)
{
byte[] file = System.IO.File.ReadAllBytes(originalPath);
string fileString = Encoding.UTF8.GetString(file);
string errorMsg = InsertString(out fileString, fileString, settings.AddressString, "address");
if (errorMsg != null || fileString == null)
{
return(errorMsg ?? "No insert result error.");
}
errorMsg = UpdateQRImage(settings.AddressString);
if (errorMsg != null)
{
return(errorMsg);
}
errorMsg = InsertString(out fileString, fileString, settings.AESEncryptedPrivateKey, "privatekey");
if (errorMsg != null || fileString == null)
{
return(errorMsg ?? "No insert result error.");
}
errorMsg = InsertString(out fileString, fileString, settings.displayKeyString, "vignerekey");
if (errorMsg != null || fileString == null)
{
return(errorMsg ?? "No insert result error.");
}
errorMsg = InsertString(out fileString, fileString,
waitingPaidOrder != null ? waitingPaidOrder.OrderNumber : settings.OrderNumber,
"ordernumber");
if (errorMsg != null || fileString == null)
{
return(errorMsg ?? "No insert result error.");
}
errorMsg = InsertString(out fileString, fileString, settings.PinValue.ToString(), "pin");
if (errorMsg != null || fileString == null)
{
return(errorMsg ?? "No insert result error.");
}
errorMsg = InsertString(out fileString, fileString, settings.PukValue.ToString(), "puk");
if (errorMsg != null || fileString == null)
{
return(errorMsg ?? "No insert result error.");
}
errorMsg = InsertString(out fileString, fileString, DateTime.Now.ToString("dd-MM-yyyy"), "date");
if (errorMsg != null || fileString == null)
{
return(errorMsg ?? "No insert result error.");
}
for (int y = 0; y < settings.VignereTable.Length; y++)
{
for (int x = 0; x < settings.VignereTable[y].Length; x++)
{
errorMsg = InsertString(out fileString, fileString, settings.VignereTable[y][x].ToString(), "x" + x + "y" + y);
if (errorMsg != null || fileString == null)
{
return(errorMsg ?? "No insert result error.");
}
}
}
string testString = null;
while (testString == null || testString.Contains(">>"))
{
FileStream fs = new FileStream(outputPath, FileMode.OpenOrCreate);
file = Encoding.UTF8.GetBytes(fileString);
fs.Write(file, 0, file.Length);
fs.SetLength(file.Length);
fs.Flush(true);
fs.Close();
file = File.ReadAllBytes(outputPath);
testString = Encoding.UTF8.GetString(file);
}
return(null);
}
public void CheckoutDateNowTest()
{
Assert.IsNull(Order2.Date);
Order2.CheckoutDateNow();
Assert.IsNotNull(Order2.Date);
}
public static SimpleLoadResponse ExecuteLoad(LoadSettings loadSettings, Order2 waitingPaidOrder)
{
//1. Generate crypto values:
CardSettings settings = CryptoHelper.GetRandomSettings();
//2. Fill letter:
string errorMessage = HtmlDocumentCreator.ModifyHtmlFile(settings, waitingPaidOrder);
if (errorMessage != null)
{
lastLoaded = null;
return(new SimpleLoadResponse {
ErrorMessage = errorMessage
});
}
//3. Send to printer:
//Happens automatically in main window on ExecuteLoad success.
//4. Email requires pre-known address... type-able to begin with? Will consider... it IS a lot to insert bits and send an email.
//TODO
//5. Insert variables into card image file:
errorMessage = CardFileCreator.ModifyCardFile(settings, loadSettings);
if (errorMessage != null)
{
lastLoaded = null;
return(new SimpleLoadResponse {
ErrorMessage = errorMessage
});
}
//6. Load card:
errorMessage = CardLoader.LoadCard(loadSettings);
if (errorMessage != null)
{
lastLoaded = null;
return(new SimpleLoadResponse {
ErrorMessage = errorMessage
});
}
//7 Delete the generated card settings file containing the private key:
errorMessage = CardLoader.DeleteCardFile(CardFileCreator.outputPath);
if (errorMessage != null)
{
lastLoaded = null;
return(new SimpleLoadResponse {
ErrorMessage = errorMessage
});
}
//8. Save order to simple database.
if (!loadSettings.TestSettings)
{
OrderDB db = new OrderDB();
Order2 order = new Order2
{
OrderNumber = settings.OrderNumber,
Password = settings.aesPassword,
Address = settings.AddressString,
WebOrder = false
};
db.SaveOrder(order);
lastLoaded = order;
}
return(new SimpleLoadResponse
{
Success = true,
ErrorMessage = null
});
}
private async void BookNewOrder()
{
try
{
var streetaddress = txtAdress.Text;
var postalcode = txtPostalCode.Text;
int convertedpostalcode = int.Parse(postalcode);
var city = txtCity.Text;
string[] subs = streetaddress.Split(' ');
foreach (var sub in subs)
{
Console.WriteLine($"Substring: {sub}");
}
string streetname = subs[0];
string streetNumber = subs[1];
var additionalServiceCodeStandard = new List <string>
{
"A1"
};
var itemList = new List <long>
{
373500489530470000
};
List <PickupService> newist = new List <PickupService>();
newist.Add(new PickupService()
{
typeOfItem = "parcel", noUnits = 1
});
Service Servicebody = new Service
{
basicServiceCode = "19",
additionalServiceCode = new List <string>
{
"A1"
}
};
Service2 service2 = new Service2
{
service = Servicebody
};
Shipment2 shipment2 = new Shipment2
{
shipment = service2
};
var Shipmentbody = new Shipment
{
items = itemList
};
var LocationBody = new Location
{
place = "Company name or information about pickup place e.g.garage",
streetName = streetname,
streetNumber = streetNumber,
postalCode = convertedpostalcode,
city = city,
countryCode = "SE"
};
Location2 location2 = new Location2
{
location = LocationBody
};
var OrderBody = new Order
{
customerNumber = "1234567891",
orderReference = "Ref-1212122A",
contactName = "Nils Andersson",
contactEmail = "*****@*****.**",
phoneNumber = "+4670788888",
smsNumber = "+4670788888",
entryCode = "8216"
};
var Order2 = new Order2
{
order = OrderBody
};
var PickUpBody = new PickupService
{
typeOfItem = "parcel",
noUnits = 1
};
var PickUp2 = new PickUp2
{
pickups = newist
};
var datesandtimesBody = new DateAndTimes
{
readyPickupDate = new DateTime(2021, 5, 13),
latestPickupDate = new DateTime(2021, 5, 13),
earliestPickupDate = new DateTime(2021, 5, 13)
};
var datesandtimes2 = new DateAndTimes2
{
DateAndTimes = datesandtimesBody
};
var client = new RestClient("https://api2.postnord.com/rest/order/v1/pickup/SE?apikey=0ba91457361a67d1495aefa8519ba3cb");
client.Timeout = -1;
var request = new RestRequest(Method.POST);
// request.AddParameter("text/plain", "{\r\n \"shipment\": {\r\n \"service\": {\r\n \"basicServiceCode\": \"19\",\r\n \"additionalServiceCode\": [\r\n \"A1\"\r\n ]\r\n },\r\n \"items\": [\r\n 373500489530470000\r\n ]\r\n },\r\n \"location\": {\r\n \"place\": \"Company name or information about pickup place e.g. garage\",\r\n \"streetName\": \"streetname\",\r\n \"streetNumber\": \"streetNumber\",\r\n \"postalCode\": postalcode,\r\n \"city\": \"txtCity\",\r\n \"countryCode\": \"SE\"\r\n },\r\n \"order\": {\r\n \"customerNumber\": \"1234567891\",\r\n \"orderReference\": \"Ref-1212122A\",\r\n \"contactName\": \"Nils Andersson\",\r\n \"contactEmail\": \"[email protected]\",\r\n \"phoneNumber\": \"+4670788888\",\r\n \"smsNumber\": \"+4670788888\",\r\n \"entryCode\": \"8216\"\r\n },\r\n \"pickup\": [\r\n {\r\n \"typeOfItem\": \"parcel\",\r\n \"noUnits\": 1\r\n }\r\n ],\r\n \"dateAndTimes\": {\r\n \"readyPickupDate\": \"2020-11-17T09:52:07.929Z\",\r\n \"latestPickupDate\": \"2020-11-17T09:52:07.929Z\",\r\n \"earliestPickupDate\": \"2020-11-17T09:52:07.929Z\"\r\n }\r\n}", ParameterType.RequestBody);
request.AddHeader("Accept", "application/json");
request.Parameters.Clear();
string json = JsonConvert.SerializeObject(shipment2, Formatting.Indented);
string json2 = JsonConvert.SerializeObject(Shipmentbody, Formatting.Indented);
string json3 = JsonConvert.SerializeObject(location2, Formatting.Indented);
string json4 = JsonConvert.SerializeObject(Order2, Formatting.Indented);
string json5 = JsonConvert.SerializeObject(PickUp2, Formatting.Indented);
string json6 = JsonConvert.SerializeObject(datesandtimes2, Formatting.Indented);
await DisplayAlert("Alert", json + json2 + json3 + json4 + json5 + json6, "OK");
Console.WriteLine(json + json2 + json3 + json4 + json5 + json6);
request.RequestFormat = DataFormat.Json;
request.AddJsonBody(shipment2);
request.AddJsonBody(Shipmentbody);
request.AddJsonBody(location2);
request.AddJsonBody(Order2);
request.AddJsonBody(PickUp2);
request.AddJsonBody(datesandtimes2);
IRestResponse response = client.Execute(request);
await DisplayAlert("Alert", response.Content.ToString(), "OK");
}
catch (Exception ex)
{
Console.WriteLine(ex);
await DisplayAlert("Alert!", "Incorrect adress, try again", "OK");
}
}
public void Post([FromBody] Order2 value)
{
dc.Order2.Add(value);
dc.SaveChanges();
}
public void Includes()
{
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_1_0
Order order = session
.Include <Order>(x => x.CustomerId)
.Load("orders/1234");
// this will not require querying the server!
Customer customer = session
.Load <Customer>(order.CustomerId);
#endregion
}
}
using (var store = new DocumentStore())
{
#region includes_1_1
MultiLoadResult result = store
.DatabaseCommands
.Get(ids: new[] { "orders/1234" }, includes: new[] { "CustomerId" });
RavenJObject order = result.Results[0];
RavenJObject customer = result.Includes[0];
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_2_0
Order[] orders = session
.Include <Order>(x => x.CustomerId)
.Load("orders/1234", "orders/4321");
foreach (Order order in orders)
{
// this will not require querying the server!
Customer customer = session.Load <Customer>(order.CustomerId);
}
#endregion
}
}
using (var store = new DocumentStore())
{
#region includes_2_1
MultiLoadResult result = store
.DatabaseCommands
.Get(ids: new[] { "orders/1234", "orders/4321" }, includes: new[] { "CustomerId" });
List <RavenJObject> orders = result.Results;
List <RavenJObject> customers = result.Includes;
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_3_0
IList <Order> orders = session
.Query <Order, Orders_ByTotalPrice>()
.Customize(x => x.Include <Order>(o => o.CustomerId))
.Where(x => x.TotalPrice > 100)
.ToList();
foreach (Order order in orders)
{
// this will not require querying the server!
Customer customer = session
.Load <Customer>(order.CustomerId);
}
#endregion
}
using (var session = store.OpenSession())
{
#region includes_3_1
IList <Order> orders = session
.Advanced
.DocumentQuery <Order, Orders_ByTotalPrice>()
.Include(x => x.CustomerId)
.WhereGreaterThan(x => x.TotalPrice, 100)
.ToList();
foreach (Order order in orders)
{
// this will not require querying the server!
Customer customer = session
.Load <Customer>(order.CustomerId);
}
#endregion
}
}
using (var store = new DocumentStore())
{
#region includes_3_2
QueryResult result = store
.DatabaseCommands
.Query(
"Orders/ByTotalPrice",
new IndexQuery
{
Query = "TotalPrice_Range:{Ix100 TO NULL}"
},
includes: new[] { "CustomerId" });
List <RavenJObject> orders = result.Results;
List <RavenJObject> customers = result.Includes;
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_4_0
Order order = session
.Include <Order>(x => x.SupplierIds)
.Load("orders/1234");
foreach (Guid supplierId in order.SupplierIds)
{
// this will not require querying the server!
Supplier supplier = session.Load <Supplier>(supplierId);
}
#endregion
}
}
using (var store = new DocumentStore())
{
#region includes_4_1
MultiLoadResult result = store
.DatabaseCommands
.Get(ids: new[] { "orders/1234" }, includes: new[] { "SupplierIds" });
RavenJObject order = result.Results[0];
RavenJObject customer = result.Includes[0];
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_5_0
Order[] orders = session
.Include <Order>(x => x.SupplierIds)
.Load("orders/1234", "orders/4321");
foreach (Order order in orders)
{
foreach (Guid supplierId in order.SupplierIds)
{
// this will not require querying the server!
Supplier supplier = session.Load <Supplier>(supplierId);
}
}
#endregion
}
}
using (var store = new DocumentStore())
{
#region includes_5_1
MultiLoadResult result = store
.DatabaseCommands
.Get(ids: new[] { "orders/1234", "orders/4321" }, includes: new[] { "SupplierIds" });
List <RavenJObject> orders = result.Results;
List <RavenJObject> customers = result.Includes;
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_6_0
Order order = session
.Include <Order>(x => x.Referral.CustomerId)
.Load("orders/1234");
// this will not require querying the server!
Customer customer = session.Load <Customer>(order.Referral.CustomerId);
#endregion
}
using (var session = store.OpenSession())
{
#region includes_6_2
Order order = session.Include("Referral.CustomerId")
.Load <Order>("orders/1234");
// this will not require querying the server!
Customer customer = session.Load <Customer>(order.Referral.CustomerId);
#endregion
}
}
using (var store = new DocumentStore())
{
#region includes_6_1
MultiLoadResult result = store
.DatabaseCommands
.Get(ids: new[] { "orders/1234" }, includes: new[] { "Referral.CustomerId" });
RavenJObject order = result.Results[0];
RavenJObject customer = result.Includes[0];
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_7_0
Order order = session
.Include <Order>(x => x.LineItems.Select(li => li.ProductId))
.Load("orders/1234");
foreach (LineItem lineItem in order.LineItems)
{
// this will not require querying the server!
Product product = session.Load <Product>(lineItem.ProductId);
}
#endregion
}
}
using (var store = new DocumentStore())
{
#region includes_7_1
MultiLoadResult result = store
.DatabaseCommands
.Get(ids: new[] { "orders/1234" }, includes: new[] { "LineItems.,ProductId" });
RavenJObject order = result.Results[0];
RavenJObject product = result.Includes[0];
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_8_0
Order2 order = session
.Include <Order2, Customer2>(x => x.CustomerId)
.Load("order2s/1234");
// this will not require querying the server!
Customer2 customer = session.Load <Customer2>(order.CustomerId);
#endregion
}
}
using (var store = new DocumentStore())
{
#region includes_8_1
MultiLoadResult result = store
.DatabaseCommands
.Get(ids: new[] { "order2s/1234" }, includes: new[] { "CustomerId" });
RavenJObject order = result.Results[0];
RavenJObject customer = result.Includes[0];
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_8_2
IList <Order2> orders = session
.Query <Order2, Order2s_ByTotalPrice>()
.Customize(x => x.Include <Order2, Customer2>(o => o.CustomerId))
.Where(x => x.TotalPrice > 100)
.ToList();
foreach (Order2 order in orders)
{
// this will not require querying the server!
Customer2 customer = session.Load <Customer2>(order.CustomerId);
}
#endregion
}
using (var session = store.OpenSession())
{
#region includes_8_3
IList <Order2> orders = session
.Advanced
.DocumentQuery <Order2, Order2s_ByTotalPrice>()
.Include("CustomerId")
.WhereGreaterThan(x => x.TotalPrice, 100)
.ToList();
foreach (Order2 order in orders)
{
// this will not require querying the server!
Customer2 customer = session.Load <Customer2>(order.CustomerId);
}
#endregion
}
}
using (var store = new DocumentStore())
{
#region includes_8_4
QueryResult result = store
.DatabaseCommands
.Query(
"Order2s/ByTotalPrice",
new IndexQuery
{
Query = "TotalPrice_Range:{Ix100 TO NULL}"
},
includes: new[] { "CustomerId" });
List <RavenJObject> orders = result.Results;
List <RavenJObject> customers = result.Includes;
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_8_6
Order2 order = session
.Include <Order2, Supplier>(x => x.SupplierIds)
.Load("order2s/1234");
foreach (Guid supplierId in order.SupplierIds)
{
// this will not require querying the server!
Supplier supplier = session.Load <Supplier>(supplierId);
}
#endregion
}
}
using (var store = new DocumentStore())
{
#region includes_8_7
MultiLoadResult result = store
.DatabaseCommands
.Get(ids: new[] { "order2s/1234" }, includes: new[] { "SupplierIds" });
RavenJObject order = result.Results[0];
List <RavenJObject> suppliers = result.Includes;
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_8_8
Order2 order = session
.Include <Order2, Customer2>(x => x.Referral.CustomerId)
.Load("order2s/1234");
// this will not require querying the server!
Customer2 customer = session.Load <Customer2>(order.Referral.CustomerId);
#endregion
}
}
using (var store = new DocumentStore())
{
#region includes_8_9
MultiLoadResult result = store
.DatabaseCommands
.Get(ids: new[] { "order2s/1234" }, includes: new[] { "Referral.CustomerId" });
RavenJObject order = result.Results[0];
RavenJObject customer = result.Includes[0];
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_8_10
Order2 order = session
.Include <Order2, Product>(x => x.LineItems.Select(li => li.ProductId))
.Load("orders/1234");
foreach (LineItem lineItem in order.LineItems)
{
// this will not require querying the server!
Product product = session.Load <Product>(lineItem.ProductId);
}
#endregion
}
}
using (var store = new DocumentStore())
{
#region includes_8_11
MultiLoadResult result = store
.DatabaseCommands
.Get(ids: new[] { "order2s/1234" }, includes: new[] { "LineItems.,ProductId" });
RavenJObject order = result.Results[0];
List <RavenJObject> products = result.Includes;
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_9_0
Order3 order = session
.Include <Order3, Customer>(x => x.Customer.Id)
.Load("orders/1234");
// this will not require querying the server!
Customer customer = session.Load <Customer>(order.Customer.Id);
#endregion
}
}
using (var store = new DocumentStore())
{
#region includes_9_1
MultiLoadResult result = store
.DatabaseCommands
.Get(ids: new[] { "orders/1234" }, includes: new[] { "Customer.Id" });
RavenJObject order = result.Results[0];
RavenJObject customer = result.Includes[0];
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_10_0
session.Store(
new Person
{
Id = "people/1",
Name = "John Doe",
Attributes = new Dictionary <string, string>
{
{ "Mother", "people/2" },
{ "Father", "people/3" }
}
});
session.Store(
new Person
{
Id = "people/2",
Name = "Helen Doe",
Attributes = new Dictionary <string, string>()
});
session.Store(
new Person
{
Id = "people/3",
Name = "George Doe",
Attributes = new Dictionary <string, string>()
});
#endregion
}
using (var session = store.OpenSession())
{
#region includes_10_1
var person = session
.Include <Person>(x => x.Attributes.Values)
.Load("people/1");
var mother = session
.Load <Person>(person.Attributes["Mother"]);
var father = session
.Load <Person>(person.Attributes["Father"]);
Assert.Equal(1, session.Advanced.NumberOfRequests);
#endregion
}
#region includes_10_2
var result = store
.DatabaseCommands
.Get(new[] { "people/1" }, new[] { "Attributes.$Values" });
var include1 = result.Includes[0];
var include2 = result.Includes[1];
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_10_3
var person = session
.Include <Person>(x => x.Attributes.Keys)
.Load("people/1");
#endregion
}
#region includes_10_4
var result = store
.DatabaseCommands
.Get(new[] { "people/1" }, new[] { "Attributes.$Keys" });
#endregion
}
using (var store = new DocumentStore())
{
using (var session = store.OpenSession())
{
#region includes_11_0
session.Store(
new PersonWithAttribute
{
Id = "people/1",
Name = "John Doe",
Attributes = new Dictionary <string, Attribute>
{
{ "Mother", new Attribute {
Ref = "people/2"
} },
{ "Father", new Attribute {
Ref = "people/3"
} }
}
});
session.Store(
new Person
{
Id = "people/2",
Name = "Helen Doe",
Attributes = new Dictionary <string, string>()
});
session.Store(
new Person
{
Id = "people/3",
Name = "George Doe",
Attributes = new Dictionary <string, string>()
});
#endregion
}
using (var session = store.OpenSession())
{
#region includes_11_1
var person = session
.Include <PersonWithAttribute>(x => x.Attributes.Values.Select(v => v.Ref))
.Load("people/1");
var mother = session
.Load <Person>(person.Attributes["Mother"].Ref);
var father = session
.Load <Person>(person.Attributes["Father"].Ref);
Assert.Equal(1, session.Advanced.NumberOfRequests);
#endregion
}
#region includes_11_2
var result = store
.DatabaseCommands
.Get(new[] { "people/1" }, new[] { "Attributes.$Values,Ref" });
var include1 = result.Includes[0];
var include2 = result.Includes[1];
#endregion
}
}
private void UpdateNextUnsentPaidOrder()
{
OrderDB db = new OrderDB();
waitingPaidOrder = db.GetNextPaidOrder();
}
