public static void LoadOrders() {
var _orders = new Orders();
var _items = new OrderItems();
var _customers = new Customers();
var _productions = new Productions();
dynamic _channels = new Channels();
var orderID = 1001;
var rand = new Random(100);
Console.WriteLine("Blowing away dev data");
_items.Delete();
_orders.Delete();
_customers.Delete();
for (int i = 0; i < 1000; i++) {
var month = rand.Next(1, 12);
var day = rand.Next(1, 28);
var orderDate = new DateTime(2011, month, day);
Console.WriteLine("Adding " + i + " of 1000");
var productID = 1;
var price = 12.00;
if (i > 250 && i < 500) {
productID = 2;
price = 15.00;
} else if (i >= 500 && i < 750) {
productID = 3;
price = 18.00;
} else if (i >= 750) {
productID = 4;
price = 10.00;
}
var p = _productions.Single(productID);
var c = _channels.Single(p.ChannelID);
var name = p.Title;
var sku = p.Slug;
var vendor = p.Author;
var orderType = "single";
//do a monthly every 5th one
if (i % 5 == 0) {
name = "Monthly Subscription";
sku = "monthly";
vendor = "Tekpub";
price = 30.00;
orderType = "subscription";
}
//do an annual every 12th
if (i % 12 == 0) {
name = "Annual Subscription";
sku = "yearly";
vendor = "Tekpub";
price = 279.00;
orderType = "subscription";
}
var tax = price * 0.0825;
var newOrder = new {
OrderNumber = Guid.NewGuid().ToString(),
ShopifyID = orderID,
ShopifyName = "#" + orderID,
CreatedAt = orderDate,
Subtotal = price,
Token = Guid.NewGuid().ToString(),
Total = price + tax,
TaxIncluded = true,
LandingPage = "http://localhost",
ShopifyNumber = orderID,
Gateway = "bogus",
FulfillmentStatus = "fulfilled",
Currency = "USD",
ClosedAt = orderDate,
AcceptsMarketing = false,
Tax = tax,
IP = "127.0.0.1",
Weight = 1,
Email = i + "@example.com",
};
dynamic savedOrder = _orders.Insert(newOrder);
//line items...
for (int x = 1; x < 3; x++) {
var newItem = new {
OrderID = savedOrder.ID,
Name = name,
Price = price,
Quantity = x,
RequiresShipping = false,
Title = name,
Grams = 2,
SKU = sku,
Vendor = vendor,
OrderType = orderType,
Channel = c.Name
};
_items.Insert(newItem);
if (i % 5 == 0 || i % 12 == 0)
break;
}
Console.WriteLine("Creating Customer " + i);
var customer = new {
First = "First" + i,
Last = "Last" + i,
Email = savedOrder.Email
};
_customers.Insert(customer);
orderID++;
}
}
public dynamic CreateFromPing(dynamic order){
//this is sorta ugly... but whatever...
int newOrderID = 0;
var orderItems = new OrderItems();
var newOrder = new {
OrderNumber = order.order_number,
ShopifyID = order.id,
ShopifyName = order.name,
Discount = order.total_discounts,
CreatedAt = DateTime.Parse(order.created_at),
Subtotal = order.subtotal_price,
Token = order.token,
Total = order.total_price,
TaxIncluded = order.taxes_included,
LandingPage = order.landing_site,
ShopifyNumber = order.number,
ReferringSite = order.referring_site,
Note = order.note,
Gateway = order.gateway,
FulfillmentStatus = order.fulfillment_status,
FinancialStatus = order.financial_status,
Currency = order.currency,
ClosedAt = order.closed_at,
AcceptsMarketing = order.buyer_accepts_marketing,
Tax = order.total_tax,
ReferralID = order.landing_site_ref,
IP = order.browser_ip,
Weight = order.total_weight,
Email = order.email
};
try {
dynamic savedOrder = Insert(newOrder);
newOrderID = savedOrder.ID;
var items = new List<dynamic>();
//line items...
foreach (var item in order.line_items) {
var newItem = new {
OrderID = savedOrder.ID,
ProductID = item.productID,
Name = item.name,
Price = item.price,
Quantity = item.quantity,
RequiresShipping = item.requires_shipping,
Title = item.title,
Grams = item.grams,
SKU = item.SKU,
FulfillmentStatus = item.fulfillment_status,
Vendor = item.vendor,
FulfillmentService = item.fulfillment_service
};
items.Add(newItem);
}
//batch add the line items
orderItems.Save(items);
} catch (Exception x) {
//back it out
orderItems.Delete(where: "where orderID=@0");
Delete(newOrderID);
//rethrow and let bubble
throw x;
}
return newOrder;
}
public dynamic CreateFromPing(dynamic order)
{
//this is sorta ugly... but whatever...
int newOrderID = 0;
var orderItems = new OrderItems();
var newOrder = new {
OrderNumber = order.order_number,
ShopifyID = order.id,
ShopifyName = order.name,
Discount = order.total_discounts,
CreatedAt = DateTime.Parse(order.created_at),
Subtotal = order.subtotal_price,
Token = order.token,
Total = order.total_price,
TaxIncluded = order.taxes_included,
LandingPage = order.landing_site,
ShopifyNumber = order.number,
ReferringSite = order.referring_site,
Note = order.note,
Gateway = order.gateway,
FulfillmentStatus = order.fulfillment_status,
FinancialStatus = order.financial_status,
Currency = order.currency,
ClosedAt = order.closed_at,
AcceptsMarketing = order.buyer_accepts_marketing,
Tax = order.total_tax,
ReferralID = order.landing_site_ref,
IP = order.browser_ip,
Weight = order.total_weight,
Email = order.email
};
try {
dynamic savedOrder = Insert(newOrder);
newOrderID = savedOrder.ID;
var items = new List <dynamic>();
//line items...
foreach (var item in order.line_items)
{
var newItem = new {
OrderID = savedOrder.ID,
ProductID = item.productID,
Name = item.name,
Price = item.price,
Quantity = item.quantity,
RequiresShipping = item.requires_shipping,
Title = item.title,
Grams = item.grams,
SKU = item.SKU,
FulfillmentStatus = item.fulfillment_status,
Vendor = item.vendor,
FulfillmentService = item.fulfillment_service
};
items.Add(newItem);
}
//batch add the line items
orderItems.Save(items);
} catch (Exception x) {
//back it out
orderItems.Delete(where : "where orderID=@0");
Delete(newOrderID);
//rethrow and let bubble
throw x;
}
return(newOrder);
}
