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)); } }