public async Task ProductContrAdd() { using (var contex = new ProdContext(options)) { var control = new ProductController(contex); Product newUom = new Product { Title = "Яблоки", UomId = 2 }; var result = await control.Post(newUom); var okResult = result.Result as OkObjectResult; Assert.Equal(newUom, okResult.Value); Assert.Equal(200, okResult.StatusCode); } }
public async Task MovementsContrAdd() { using (var contex = new ProdContext(options)) { var control = new MovementsController(contex); ProductMovements newUom = new ProductMovements { ProductId = 2, Quantity = -50 }; var result = await control.Post(newUom); var okResult = result.Result as OkObjectResult; Assert.Equal(newUom, okResult.Value); Assert.Equal(200, okResult.StatusCode); } }
public ProductControllerTest() { options = new DbContextOptionsBuilder <ProdContext>() .UseInMemoryDatabase(databaseName: "productsdb") .Options; var context = new ProdContext(options); if (!context.Prod.Any()) { using (context) { context.Prod.Add(new Product { Title = "Бананы", UomId = 2 }); context.Prod.Add(new Product { Title = "Специи", UomId = 1 }); context.Prod.Add(new Product { Title = "Мандарины", UomId = 2 }); context.Prod.Add(new Product { Title = "Авокадо", UomId = 3 }); context.Prod.Add(new Product { Title = "Апельсины", UomId = 2 }); context.Prod.Add(new Product { Title = "Груши", UomId = 2 }); context.SaveChanges(); } } }
public UomController(ProdContext context) { db = context; if (!db.ProductUoms.Any()) { db.ProductUoms.Add(new ProductUom { Title = "шт" }); db.ProductUoms.Add(new ProductUom { Title = "г" }); db.ProductUoms.Add(new ProductUom { Title = "кг" }); db.SaveChanges(); } }
public async Task UomContrPageSizeTest() { using (var context = new ProdContext(options)) { UomController control = new UomController(context); var result = await control.Get(2, 3); var actualResult = result.Result; var productUoms = new ProductUom { Id = 4, Title = "т" }; foreach (var x in result.Value) { Assert.Equal(productUoms.Id, x.Id); Assert.Equal(productUoms.Title, x.Title); } } }
public ProductController(ProdContext context) { db = context; if (!db.Prod.Any()) { db.Prod.Add(new Product { Title = "Бананы", UomId = 3 }); db.Prod.Add(new Product { Title = "Специи", UomId = 2 }); db.Prod.Add(new Product { Title = "Мандарины", UomId = 3 }); db.Prod.Add(new Product { Title = "Авокадо", UomId = 1 }); db.SaveChanges(); } }
public MovementsControllerTest() { options = new DbContextOptionsBuilder <ProdContext>() .UseInMemoryDatabase(databaseName: "productsdb") .Options; var context = new ProdContext(options); if (!context.Movements.Any()) { using (context) { context.Movements.Add(new ProductMovements { ProductId = 1, Quantity = 10 }); context.Movements.Add(new ProductMovements { ProductId = 2, Quantity = 100 }); context.Movements.Add(new ProductMovements { ProductId = 3, Quantity = 145 }); context.Movements.Add(new ProductMovements { ProductId = 4, Quantity = 134 }); context.Movements.Add(new ProductMovements { ProductId = 1, Quantity = -2 }); context.SaveChanges(); } } }
public MovementsController(ProdContext context) { db = context; if (!db.Movements.Any()) { db.Movements.Add(new ProductMovements { ProductId = 1, Quantity = 10 }); db.Movements.Add(new ProductMovements { ProductId = 2, Quantity = 100 }); db.Movements.Add(new ProductMovements { ProductId = 3, Quantity = 145 }); db.Movements.Add(new ProductMovements { ProductId = 4, Quantity = 134 }); db.Movements.Add(new ProductMovements { ProductId = 1, Quantity = -2 }); db.SaveChanges(); } }
public AddCustomerForm() { this.db = new ProdContext(); InitializeComponent(); }
private ExprContext expr(int _p) { ParserRuleContext _parentctx = Context; int _parentState = State; ExprContext _localctx = new ExprContext(Context, _parentState); ExprContext _prevctx = _localctx; int _startState = 0; EnterRecursionRule(_localctx, 0, RULE_expr, _p); int _la; try { int _alt; EnterOuterAlt(_localctx, 1); { State = 9; ErrorHandler.Sync(this); switch (TokenStream.LA(1)) { case OP: { _localctx = new ParenExpContext(_localctx); Context = _localctx; _prevctx = _localctx; State = 3; Match(OP); State = 4; expr(0); State = 5; Match(CP); } break; case VAR: { _localctx = new VarContext(_localctx); Context = _localctx; _prevctx = _localctx; State = 7; Match(VAR); } break; case NUM: { _localctx = new ConstContext(_localctx); Context = _localctx; _prevctx = _localctx; State = 8; Match(NUM); } break; default: throw new NoViableAltException(this); } Context.Stop = TokenStream.LT(-1); State = 24; ErrorHandler.Sync(this); _alt = Interpreter.AdaptivePredict(TokenStream, 3, Context); while (_alt != 2 && _alt != global::Antlr4.Runtime.Atn.ATN.INVALID_ALT_NUMBER) { if (_alt == 1) { if (ParseListeners != null) { TriggerExitRuleEvent(); } _prevctx = _localctx; { State = 22; ErrorHandler.Sync(this); switch (Interpreter.AdaptivePredict(TokenStream, 2, Context)) { case 1: { _localctx = new PowerContext(new ExprContext(_parentctx, _parentState)); PushNewRecursionContext(_localctx, _startState, RULE_expr); State = 11; if (!(Precpred(Context, 5))) { throw new FailedPredicateException(this, "Precpred(Context, 5)"); } State = 12; Match(POWER); State = 13; expr(5); } break; case 2: { _localctx = new ProdContext(new ExprContext(_parentctx, _parentState)); PushNewRecursionContext(_localctx, _startState, RULE_expr); State = 14; if (!(Precpred(Context, 4))) { throw new FailedPredicateException(this, "Precpred(Context, 4)"); } State = 16; ErrorHandler.Sync(this); _la = TokenStream.LA(1); if (_la == PROD) { { State = 15; Match(PROD); } } State = 18; expr(5); } break; case 3: { _localctx = new PlusminusContext(new ExprContext(_parentctx, _parentState)); PushNewRecursionContext(_localctx, _startState, RULE_expr); State = 19; if (!(Precpred(Context, 3))) { throw new FailedPredicateException(this, "Precpred(Context, 3)"); } State = 20; _la = TokenStream.LA(1); if (!(_la == PLUS || _la == MINUS)) { ErrorHandler.RecoverInline(this); } else { ErrorHandler.ReportMatch(this); Consume(); } State = 21; expr(4); } break; } } } State = 26; ErrorHandler.Sync(this); _alt = Interpreter.AdaptivePredict(TokenStream, 3, Context); } } } catch (RecognitionException re) { _localctx.exception = re; ErrorHandler.ReportError(this, re); ErrorHandler.Recover(this, re); } finally { UnrollRecursionContexts(_parentctx); } return(_localctx); }
public AddOrder() { this.db = new ProdContext(); InitializeComponent(); }
public CustomersController() { ProdContext = new ProdContext(); }
public CategoriesController() { ProdContext = new ProdContext(); }
public ProductsController() { ProdContext = new ProdContext(); }
public CategoriesController(ProdContext context) { _context = context; }
public ProdutoesController(ProdContext context) { _context = context; }
public OrdersController() { ProdContext = new ProdContext(); }
static void Main(string[] args) { Application.EnableVisualStyles(); Form categoryForm = new CategoryForm(); Form orderForm = new OrderForm(); using (var db = new ProdContext()) { //Console.Write("Enter a name for a new Category:"); //var name = Console.ReadLine(); //var category = new Category { Name = name }; // db.Categories.Add(category); //db.SaveChanges(); // Display all Categories from the database //var query = from c in db.Categories // orderby c.Name // descending // select c; //Method based lazy: // IEnumerable<Category> query2 = db.Categories.OrderByDescending(c => c.Name); //Method based eager: //IEnumerable<Category> query3 = db.Categories.OrderByDescending(c => c.Name).ToList(); // Console.WriteLine("All categories in the database:"); // foreach (var item in query2) // { // Console.WriteLine("{0}", item.Name ); // } //Console.WriteLine("All categories in the database:"); //foreach (var item in query3) //{ // Console.WriteLine("{0}", item.Name); //} // Console.WriteLine("Press any key to exit..."); //Console.ReadKey(); //----------------------------------------------------------------------------------------------- //METODY, KAŻDA W DWOCH WERSJACH //Pobiorą i wyświetlą wszystkie kategorie i produkty wykorzystujac: //1. Join ----------------- //Query var join_query = from c in db.Categories join p in db.Products on c.CategoryID equals p.CategoryID into products select new { CatName = c.Name, Products = products }; //Method var method_join_query = db.Categories .GroupJoin(db.Products, c => c.CategoryID, p => p.CategoryID, (c, p) => new { CatID = c.CategoryID, CatName = c.Name, Products = db.Products.Where(x => x.CategoryID == c.CategoryID).ToList() }); // Console.WriteLine("All categories and products in the database:"); // foreach (var item in method_join_query) // { // Console.WriteLine("{0}:", item.CatName); // foreach (var prod in item.Products) // { // Console.WriteLine("{0}", prod.Name); // } // Console.WriteLine("\n"); // } // Console.WriteLine("Press any key to exit..."); // Console.ReadKey(); //Navigation Properties--------------------------------------- var navigationQuery1 = from c in db.Categories select new { CatName = c.Name, Prods = c.Products }; //Lazy vs Eager----------------------------------------------- //Lazy: //Query var join_query2 = (from c in db.Categories join p in db.Products on c.CategoryID equals p.CategoryID into products select new { CatName = c.Name, Products = products }); //method var method_join_query2 = db.Categories .GroupJoin(db.Products, c => c.CategoryID, p => p.CategoryID, (c, p) => new { CatName = c.Name, Products = db.Products.Where(x => x.CategoryID == c.CategoryID).ToList() }); //Eager: //Query var join_query3 = (from c in db.Categories.Include("Products") join p in db.Products on c.CategoryID equals p.CategoryID into products select new { CatName = c.Name, Products = products }).ToList(); //method var method_join_query3 = db.Categories.Include(c => c.Products) .GroupJoin(db.Products, c => c.CategoryID, p => p.CategoryID, (c, p) => new { CatName = c.Name, Products = db.Products.Where(x => x.CategoryID == c.CategoryID).ToList() }).ToList(); //2. Dla każdej kategorii pokaza ilość produktów--------------------------- //a) Query var count_join_query = from c in db.Categories join p in db.Products on c.CategoryID equals p.CategoryID into res select new { CatName = c.Name, Count = res.Count() }; //b) Method var count_method_join_query = db.Categories .GroupJoin(db.Products, c => c.CategoryID, p => p.CategoryID, (c, p) => new { CatName = c.Name, Count = c.Products.Count() }).Distinct().OrderByDescending(x => x.Count); Console.WriteLine("All categories in the database:"); foreach (var item in count_join_query) { Console.WriteLine("{0}\t{1}", item.CatName, item.Count); } //categoryForm.ShowDialog(); orderForm.ShowDialog(); Console.WriteLine("Press any key to exit..."); Console.ReadKey(); //Console.WriteLine("Press any key to exit..."); //Console.ReadKey(); } }