static void Main(string[] args)
{
var db = new TransactionEntities();
Console.WriteLine("DB Connection Established.");
Console.WriteLine("Clearing old recommendations.");
db.ProductRecommendations.ToList().Select(p => db.ProductRecommendations.Remove(p));
db.SaveChanges();
Console.WriteLine("Calculating new recommendations.");
var records = db.TransactionRecords.ToList();
var products = records.Select(t => t.productId).Distinct().OrderBy(t => t).ToList();
var results = new List <ProductRecommendation>();
products.ForEach(p =>
{
Console.WriteLine($"Calculating recommendations for {p}");
var rec = new ProductRecommendation();
rec.ProductId = int.Parse(p);
rec.RecomendedProductIdsJson = JsonConvert.SerializeObject(CommonlyPurchasedTogether(p, records));
});
Console.WriteLine("Saving results.");
db.ProductRecommendations.AddRange(results);
db.SaveChanges();
Console.WriteLine("All done. Press the anykey to exit!");
Console.ReadLine();
}
public bool InsertTransaction(TransactionModel.TransactionData TransactionDetail, string UserID)
{
transactionEntities = new TransactionEntities();
try
{
var config = new MapperConfiguration(
cfg =>
{
cfg.CreateMap <TransactionModel.TransactionData, Data.Transaction>()
.ForMember(x => x.TransStartDate, y => y.MapFrom(z => z.StartDate))
.ForMember(x => x.TransEndDate, y => y.MapFrom(z => z.EndDate));
}
);
var mapper = config.CreateMapper();
var transaction = mapper.Map <Data.Transaction>(TransactionDetail);
transactionEntities.Transactions.Add(transaction);
transactionEntities.SaveChanges();
result = true;
}
catch (Exception ex)
{
log = new Logger();
log.LogError(UserID, "DataSolutions.Data", "InsertUser", ex.Message);
}
return(result);
}
public void Add(List <TransactionRecord> records)
{
var db = new TransactionEntities();
db.TransactionRecords.AddRange(records);
db.SaveChanges();
}
public JsonResult UpdateStoreData(Store store)
{
using (TransactionEntities db = new TransactionEntities())
{
if (ModelState.IsValid)
{
try
{
db.Entry(store).State = EntityState.Modified;
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
var result = db.Stores.SingleOrDefault(a => a.Id == store.Id);
if (result == null)
{
return(Json(new { success = false, message = "Cannot find store to update" }, JsonRequestBehavior.AllowGet));
}
else
{
throw;
}
}
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { success = false, message = "Invalid store given" }, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveStoreData(Store store)
{
try
{
using (TransactionEntities db = new TransactionEntities())
{
db.Stores.Add(store);
db.SaveChanges();
return(Json(new { success = true, data = store }));
}
}
catch
{
return(Json(new { success = false, message = "Invalid store given" }));
}
}
public JsonResult SaveProductData(Product product)
{
try
{
using (TransactionEntities db = new TransactionEntities())
{
db.Products.Add(product);
db.SaveChanges();
return(Json(new { success = true, data = product }));
}
}
catch
{
return(Json(new { success = false, message = "Invalid" }));
}
}
public JsonResult SaveCustomerData(Customer customer)
{
try
{
using (TransactionEntities db = new TransactionEntities())
{
db.Customers.Add(customer);
db.SaveChanges();
return(Json(new { success = true, data = customer }, JsonRequestBehavior.AllowGet));
}
}
catch
{
return(Json(new { success = false, message = "Invalid customer given" }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult SaveSalesData(Sale sale)
{
try
{
using (TransactionEntities db = new TransactionEntities())
{
db.Sales.Add(sale);
db.SaveChanges();
return(Json(new { success = true, JsonRequestBehavior.AllowGet }));
}
}
catch
{
return(Json(new { success = false, message = "Invalid" }));
}
}
//Delete record from database
public JsonResult DeleteStoreData(int id)
{
try
{
using (TransactionEntities db = new TransactionEntities())
{
Store store = db.Stores.Find(id);
db.Stores.Remove(store);
db.SaveChanges();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
}
catch
{
return(Json(new { success = false, message = "Cannot delete Store" }, JsonRequestBehavior.AllowGet));
}
}
//Delete record from database
public JsonResult DeleteCustomerData(int id)
{
try
{
using (TransactionEntities db = new TransactionEntities())
{
Customer customer = db.Customers.Find(id);
db.Customers.Remove(customer);
db.SaveChanges();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
}
catch
{
return(Json(new { success = false, message = "Cannot delete customer" }, JsonRequestBehavior.AllowGet));
}
}
