public static void WriteJSON(NewEntitiesModel context)
{
var productItemsCollection = new MongoHelper<ProductItem>("Products");
productItemsCollection.MongoCollection.Drop();
foreach (var product in context.Products.Include("Vendor").Include("Reports"))
{
int productId = product.Id;
string vendorName = product.Vendor.VendorName;
string productName = product.ProductName;
decimal quantity = 0;
decimal sum = 0;
foreach (var report in product.Reports)
{
quantity += report.Quantity.Value;
sum += report.Sum.Value;
}
// Console.WriteLine(productId + " : " + vendorName + " : " + productName + " : " + quantity + " : " + sum);
var tempObject = new ProductItem()
{
ProductId = productId,
ProductName = productName,
VendorName = vendorName,
Quantity = quantity,
Sum = sum
};
productItemsCollection.InsertData(tempObject);
}
var productList = productItemsCollection.LoadData<ProductItem>().ToJson();
var removeId = Regex.Replace(productList, "\"_id\".*?\\,", "", RegexOptions.IgnoreCase);
var formatedList = Regex.Replace(removeId, ",", ",\n", RegexOptions.IgnoreCase);
var removedBracesRight = Regex.Replace(formatedList, "},", "\n},", RegexOptions.IgnoreCase);
var removedBracesLeft = Regex.Replace(removedBracesRight, "{", "{\n", RegexOptions.IgnoreCase);
File.Delete(@"../../../GeneratedReports/report.json");
File.WriteAllText(@"../../../GeneratedReports/report.json", removedBracesLeft);
Console.WriteLine("JSON report created.");
}
public static void LoadMongoProducts()
{
var productItemsCollection = new MongoHelper<ProductItem>("Products");
var products = productItemsCollection.LoadData<ProductItem>().ToList();
//"ProductId" : 1,
// "ProductName" : "BeerZagorka",
// "VendorName" : "Zagorka",
// "Quantity" : "673.00",
// "Sum" : "609.24"
using (var dbConnection = new SQLiteConnection("Data Source=SQLiteSupermarketDB.sqlite;Version=3;"))
{
dbConnection.Open();
//create table
//string sqlStatement = "create table Products(" +
// "Id integer not null," +
// "ProductId integer," +
// "ProductName nvarchar(50)," +
// "VendorName nvarchar(50)," +
// "Quantity numeric(10,5)," +
// "Sum numeric(10,5)," +
// "primary key (Id)" +
// ");";
//SQLiteCommand createTable = new SQLiteCommand(sqlStatement, dbConnection);
//createTable.ExecuteNonQuery();
//insert data
StringBuilder sb = new StringBuilder();
sb.Append("insert into Products(ProductId, ProductName, VendorName, Quantity, Sum) values");
foreach (var prod in products)
{
sb.AppendFormat("('{0}','{1}','{2}','{3}','{4}'),", prod.ProductId
, prod.ProductName, prod.VendorName, prod.Quantity, prod.Sum);
}
sb.Length--;
sb.Append(";");
//Console.WriteLine(sb.ToString());
SQLiteCommand populateProducts = new SQLiteCommand(sb.ToString(), dbConnection);
populateProducts.ExecuteNonQuery();
}
}