public void AddEmpty(string userId) { using (var db = new DatabaseModel.ReceiptReaderDatabaseContext()) { var databaseReceipt = new DatabaseModel.Receipt(); databaseReceipt.Id = GenerateReceiptIdForUser(db, userId); databaseReceipt.UserId = userId; databaseReceipt.AddDate = DateTime.Now; db.Receipt.Add(databaseReceipt); var firstProduct = new DatabaseModel.Product(); firstProduct.Id = 1; firstProduct.UserId = userId; firstProduct.ReceiptId = databaseReceipt.Id; firstProduct.Name = "Update me"; firstProduct.Price = 0m; firstProduct.Quantity = 0; firstProduct.CategoryId = 12; db.Product.Add(firstProduct); db.SaveChanges(); } }
public void Delete(string userId, int receiptId, int productId) { var product = new DatabaseModel.Product() { Id = productId, UserId = userId, ReceiptId = receiptId }; using (var db = new DatabaseModel.ReceiptReaderDatabaseContext()) { var productCount = db.Product.Count(p => p.UserId == userId && p.ReceiptId == receiptId); db.Product.Attach(product); db.Product.Remove(product); if (productCount == 1) { var receipt = new DatabaseModel.Receipt() { Id = receiptId, UserId = userId }; db.Receipt.Attach(receipt); db.Receipt.Remove(receipt); } UpdateReceiptControlSum(receiptId, userId, db); db.SaveChanges(); } }
public void Delete(string userId, int receiptId) { var receipt = new DatabaseModel.Receipt() { Id = receiptId, UserId = userId }; using (var db = new DatabaseModel.ReceiptReaderDatabaseContext()) { db.Product.RemoveRange(db.Product.Where(p => p.UserId == userId && p.ReceiptId == receiptId)); db.Receipt.Attach(receipt); db.Receipt.Remove(receipt); db.SaveChanges(); } }