public static void Main(string[] args)
{
var context = new ProductsSystemDbContext();
// Test retrive data from mysql
//var db = new ProductsSystemDbContextForMySql();
//var measures = db.Measures.ToList().First();
//Console.WriteLine(measures.Name);
// Execute the following method if do not have the
// database in sql server
// It will add sample data automatically
// Firstly ensure that in the App.config file
// you have the name of your sql server in the
// connection string
// Configuration.InitializeDatabase(context);
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
var data = ProductsSystemData.GetInstance(context);
var userInterface = new ConsoleUserInterface();
var engine = Engine.GetInstance(userInterface, data);
engine.Run();
//var product = data.Sales.All()
// .GroupBy(s => s.Product)
// .Select(sp => new SalesByProduct
// {
// ProductId = sp.Key.Id,
// ProductName = sp.Key.Name,
// VendorName = sp.Key.Vendor.Name,
// TotalQuantitySold = sp.Sum(s => s.Quantity),
// TotalIncomes = sp.Sum(s => s.Quantity * s.Product.Price),
// }).ToList();
//Product product = new Product();
//product.ExpiryDate = new DateTime(2008, 12, 28);
//var defaultFileFolderPath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
//var filePath = defaultFileFolderPath + "\\json.txt";
//var serializer = new JsonSerializer();
//serializer.Converters.Add(new JavaScriptDateTimeConverter());
//serializer.NullValueHandling = NullValueHandling.Ignore;
//using (var sw = new StreamWriter(filePath))
//using (JsonWriter writer = new JsonTextWriter(sw))
//{
// serializer.Serialize(writer, product);
// // {"ExpiryDate":new Date(1230375600000),"Price":0}
//}
//var json = JsonExporter.JsonExporter.ToJson(product);
//Console.WriteLine(json);
}
public static void Main(string[] args)
{
var context = new ProductsSystemDbContext();
// Execute the following method if do not have the
// database in sql server
// It will add sample data automatically
// Firstly ensure that in the App.config file
// you have the name of your sql server in the
// connection string
//Configuration.InitializeDatabase(context);
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
var data = ProductsSystemData.GetInstance(context);
//var userInterface = new ConsoleUserInterface();
//var engine = Engine.GetInstance(userInterface, data);
//engine.Run();
var product = data.Products.All().Select(
p => new { ProductName = p.Name, VendorName = p.Vendor.Name, QuantitySold = p.Sales.Sum(s => s.Quantity * p.Price) });
//Product product = new Product();
//product.ExpiryDate = new DateTime(2008, 12, 28);
var defaultFileFolderPath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
var filePath = defaultFileFolderPath + "\\json.txt";
var serializer = new JsonSerializer();
serializer.Converters.Add(new JavaScriptDateTimeConverter());
serializer.NullValueHandling = NullValueHandling.Ignore;
using (var sw = new StreamWriter(filePath))
using (JsonWriter writer = new JsonTextWriter(sw))
{
serializer.Serialize(writer, product);
// {"ExpiryDate":new Date(1230375600000),"Price":0}
}
//var json = JsonExporter.JsonExporter.ToJson(product);
//Console.WriteLine(json);
}
public static void Main(string[] args)
{
var context = new ProductsSystemDbContext();
// Execute the following method if do not have the
// database in sql server
// It will add sample data automatically
// Firstly ensure that in the App.config file
// you have the name of your sql server in the
// connection string
Configuration.InitializeDatabase(context);
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
var data = ProductsSystemData.GetInstance(context);
var userInterface = new ConsoleUserInterface();
var engine = Engine.GetInstance(userInterface, data);
engine.Run();
//var product = data.Products.All().Select(
// p => new {ProductName = p.Name, VendorName = p.Vendor.Name, QuantitySold = p.Sales.Sum(s => s.Quantity * p.Price)});
//var json = JsonExporter.JsonExporter.ToJson(product);
//Console.WriteLine(json);
}
