//TODO: Compound Linq statement in place of foreach loop public decimal CalculateTotal(PurchaseRequestLineItem prli) { db = new PRSDbContext(); // refresh the context var purchaseRequest = db.PurchaseRequests.Find(prli.PurchaseRequestId); purchaseRequest.Total = purchaseRequest.PurchaseRequestLineItems.Sum(p => p.Product.Price * p.Quantity); // Using the virtual List<PurchaseRequestLineItems> we don't need a .Where(linq expression) return(purchaseRequest.Total); }
public RequestsController(PRSDbContext context) { _context = context; }
public RequestLinesApiController(PRSDbContext context) { _context = context; }
public ProductsController(PRSDbContext context) { _context = context; }
public UsersController(PRSDbContext context) { _context = context; }
public VendorsController(PRSDbContext context) { _context = context; }
static void Main(string[] args) { var context = new PRSDbContext(); Console.WriteLine("Hello."); var update = new RequestLine() { Id = 7, RequestId = 1, ProductId = 7, Quantity = 5 }; RequestLinesController.Update(7, update); Console.WriteLine("Goodbye."); #region logins //// Login successful! //Console.WriteLine(UserController.Login("JollyRoger", "%*(#UDORCK")); //// Login successful! //Console.WriteLine(UserController.Login("BellyOop", "951620!@#$UEOA")); //// Reviewer //Console.WriteLine(UserController.Login("ManMan01", "password1")); //// Admin //Console.WriteLine(UserController.Login("CEO-guy-lol", "#TronLegacy2010")); #endregion #region added new Users //var user = new User() { // Username = "******", // Password = "******", // Firstname = "James", // Lastname = "Marshall", // Phone = "973-746-2518" //}; //var user2 = new User() { // Username = "******", // Password = "******", // Firstname = "Kameron", // Lastname = "Thames", // Email = "*****@*****.**" //}; //var useR = new User() { // Username = "******", // Password = "******", // Firstname = "Gregory", // Lastname = "Douglas", // Email = "*****@*****.**", // IsReviewer = true //}; //var usAr = new User() { // Username = "******", // Password = "******", // Firstname = "Bill", // Lastname = "Sizemore", // Email = "*****@*****.**", // //IsReviewer = true, // IsAdmin = true //}; //context.Users.AddRange(user, user2, useR, usAr); //context.SaveChanges(); #endregion #region added new Vendors //var vendor1 = new Vendor() { // Id = 0, // Code = "10", // Name = "Amazon", // Address = "410 Terry Ave N", // City = "Seattle", // State = "WA", // ZIP = "98109", // Phone = "206-266-1000" //}; //var vendor2 = new Vendor() { // Id = 0, // Code = "20", // Name ="Skyline Chili", // Address = "4180 Thunderbird Ln", // City = "Fairfield", // State = "OH", // ZIP = "45014", // Phone = "513-874-1188" //}; //context.AddRange(vendor1, vendor2); //context.SaveChanges(); #endregion #region added new Products //var prod1 = new Product() { // Id = 0, // PartNbr = "100", // Name = "3-way", // Price = 5.99m, // Unit = "each", // VendorId = 2 //}; //var prod2 = new Product() { // Id = 0, // PartNbr = "200", // Name = "4-way", // Price = 6.99m, // Unit = "each", // VendorId = 2 //}; //var prod3 = new Product() { // Id = 0, // PartNbr = "300", // Name = "5-way", // Price = 7.99m, // Unit = "each", // VendorId = 2 //}; //var prod4 = new Product() { // Id = 0, // PartNbr = "400", // Name = "basic tripod stand", // Price = 19.99m, // Unit = "each", // VendorId = 1 //}; //var prod5 = new Product() { // Id = 0, // PartNbr = "500", // Name = "Ring © doorbell", // Price = 27.99m, // Unit = "each", // VendorId = 1 //}; //var prod6 = new Product() { // Id = 0, // PartNbr = "600", // Name = "tortilla plush blanket", // Price = 34.49m, // Unit = "each", // VendorId = 1 //}; //context.AddRange(prod1, prod2, prod3, prod4, prod5, prod6); //context.SaveChanges(); #endregion #region added new Requests //var req1 = new Request() { // Id = 0, // Description = "Order 1", // Justification = "want", // UserId = 1 //}; //var req2 = new Request() { // Id = 0, // Description = "Order 2", // Justification = "want", // UserId = 2 //}; //context.Requests.AddRange(req1, req2); //context.SaveChanges(); #endregion #region added new RequestLines //var ln1 = new RequestLine() { // Id = 0, // RequestId = 1, // ProductId = 1, // Quantity = 2 //}; //var ln2 = new RequestLine() { // Id = 0, // RequestId = 1, // ProductId = 2, // Quantity = 3 //}; //var ln3 = new RequestLine() { // Id = 0, // RequestId = 1, // ProductId = 3, // Quantity = 2 //}; //var ln4 = new RequestLine() { // Id = 0, // RequestId = 2, // ProductId = 4, //}; //var ln5 = new RequestLine() { // Id = 0, // RequestId = 2, // ProductId = 5, //}; //var ln6 = new RequestLine() { // Id = 0, // RequestId = 2, // ProductId = 6, //}; //context.RequestLines.AddRange(ln1, ln2, ln3, ln4, ln5, ln6); //context.SaveChanges(); #endregion }