public UnitOfWork(ApplicationDbContext context) { _context = context; Restaurants = new RestaurantRepository(context); Dishes = new DishRepository(context); Basket = new BasketItemRepository(context); }
public DataManager() { cont = new ModelContainer(); branchRepository = new BranchRepository(cont); categoryRepository = new CategoryRepository(cont); checkDishRepository = new CheckDishRepository(cont); checkMerchandiseRepository = new CheckMerchandiseRepository(cont); clientRepository = new ClientRepository(cont); companyOwnerRepository = new CompanyOwnerRepository(cont); companyRepository = new CompanyRepository(cont); contactPersonRepository = new ContactPersonRepository(cont); dishRepository = new DishRepository(cont); documentRepository = new DocumentRepository(cont); ejectionRepository = new EjectionRepository(cont); employeeRepository = new EmployeeRepository(cont); encashmentRepository = new EncashmentRepository(cont); landlordRepository = new LandlordRepository(cont); orderRepository = new OrderRepository(cont); personRepository = new PersonRepository(cont); positionRepository = new PositionRepository(cont); prepackRepository = new PrepackRepository(cont); productRepository = new ProductRepository(cont); purchaseRepository = new PurchaseRepository(cont); recipeDishIngrRepository = new RecipeDishIngrRepository(cont); recipeDishPrepRepository = new RecipeDishPrepRepository(cont); recipePrepIngrRepository = new RecipePrepIngrRepository(cont); recipePrepPrepRepository = new RecipePrepPrepRepository(cont); roomRepository = new RoomRepository(cont); shiftRepository = new ShiftRepository(cont); tableRepository = new TableRepository(cont); warehouseRepository = new WarehouseRepository(cont); }
public void TestCanGetSteak() { DishRepository repo = new DishRepository(); string name = repo.GetDishName("evening", 1); Assert.AreEqual("steak", name); }
public void Add_To_Datebase(string data) { IDishRepository repoDish = new DishRepository(); IOrderRepository repository = new OrderRepository(); Order order; Dish dish; int tableID = Int32.Parse(char.ToString(data[0])); data = data.Remove(0, 2); Console.WriteLine(data); Console.WriteLine(tableID); string[] Dish_Price = data.Split(";"); foreach (var x in Dish_Price) { order = new Order(); dish = new Dish(); string[] element = x.Split(","); Console.WriteLine(element[1]); dish.Name = element[0]; dish.DishPrice = Double.Parse(element[1], CultureInfo.InvariantCulture.NumberFormat); var ID = repoDish.CheckDish(dish); if (ID == 0) { order.DishID = repoDish.CreateDish(dish); } else { order.DishID = ID; } order.TableID = tableID; order.TimeStamp = DateTime.Now.ToString("HH:mm:ss"); repository.CreateOrder(order); } }
public async void GetDishById(int dishId) { try { using (var dbCon = PostgresConn.GetConn()) { var dishAsDBEntity = new DishRepository().GetById(dbCon, dishId); var serializerSettings = new JsonSerializerSettings(); serializerSettings.ContractResolver = new CamelCasePropertyNamesContractResolver(); var json = JsonConvert.SerializeObject(dishAsDBEntity, serializerSettings); Response.StatusCode = 200; if (!(dishAsDBEntity == null || json.Contains("[null]"))) await Response.Body.WriteAsync(Encoding.UTF8.GetBytes(json)); var dish = dishAsDBEntity as Dish; var filePath = Path.GetFullPath(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "..\\..\\..\\")) + $"Images\\DISH{dish.RestaurantId + dish.Name}.jpg"; await Response.SendFileAsync(filePath); } } catch (Exception e) { Response.StatusCode = 400; await Response.Body.WriteAsync(Encoding.UTF8.GetBytes(e.Message)); } }
public Order_DishController(Order_DishRepository repository, OrderRepository orderRepository, TransactionRepository transactionRepository, DishRepository dishRepository) { _repository = repository ?? throw new ArgumentNullException(nameof(repository)); _orderRepository = orderRepository ?? throw new ArgumentNullException(nameof(orderRepository)); _transationRepository = transactionRepository ?? throw new ArgumentNullException(nameof(transactionRepository)); _dishRepository = dishRepository ?? throw new ArgumentNullException(nameof(dishRepository)); }
public void TestCanGetToast() { DishRepository repo = new DishRepository(); string name = repo.GetDishName("morning", 2); Assert.AreEqual("toast", name); }
public Dish_IngredientController(Dish_IngredientRepository repository, DishRepository dishRepository, DishController dishController, IngredientRepository ingredientRepository) { _repository = repository ?? throw new ArgumentNullException(nameof(repository)); _dishRepository = dishRepository ?? throw new ArgumentNullException(nameof(dishRepository)); _dishController = dishController ?? throw new ArgumentNullException(nameof(dishController)); _ingredientRepository = ingredientRepository ?? throw new ArgumentNullException(nameof(ingredientRepository)); }
public async void GetDishes(Guid restaurantId) { try { using (var dbCon = PostgresConn.GetConn()) { var dishes = new DishRepository().GetInRestaurant(dbCon, restaurantId); var serializerSettings = new JsonSerializerSettings(); serializerSettings.ContractResolver = new CamelCasePropertyNamesContractResolver(); var json = JsonConvert.SerializeObject(dishes, serializerSettings); if (!Response.HasStarted) { Response.StatusCode = 200; } if (json.Contains("[null]")) { await Response.Body.WriteAsync(new byte[] { }); } else { await Response.Body.WriteAsync(Encoding.UTF8.GetBytes(json)); } } } catch (Exception e) { if (!Response.HasStarted) { Response.StatusCode = 400; } await Response.Body.WriteAsync(Encoding.UTF8.GetBytes(e.Message)); } }
private void FillOrRefreshTreeOfRecipes() { recipesTreeView.Nodes.Clear(); var recipes = new RecipeRepository(_connectionString).GetAll(); foreach (var recipe in recipes) { TreeNode dishNode = new TreeNode(); if (recipesTreeView.Nodes.ContainsKey(recipe.DishID.ToString())) { dishNode = recipesTreeView.Nodes.Find(recipe.DishID.ToString(), false).First(); } else { var dishName = new DishRepository(_connectionString).GetById(recipe.DishID)?.DishName; dishNode = recipesTreeView.Nodes.Add(recipe.DishID.ToString(), dishName); } foreach (var pair in recipe.IngredientIdsAndQuantities) { var ingr = new IngredientRepository(_connectionString).GetById(pair.Key); var unitName = new UnitRepository(_connectionString).GetAll().FirstOrDefault(x => x.UnitID == ingr.UnitID).UnitName; dishNode.Nodes.Add(ingr.IngredientName + " " + pair.Value + " " + unitName); } } }
public decimal getDishUnitPrice(int itemId) { DishRepository objDishRepository = new DishRepository(); List <Dish> dishes = objDishRepository.GetAllDish(); decimal UnitPrice = dishes[itemId - 1].DishPrice; return(UnitPrice); }
public async Task <DishListDTO> Get() { var dishes = await DishRepository.GetDisplayDataAsync(); return(new DishListDTO { dishList = dishes }); }
public void Setup() { var mongoDBContext = new MongoDBContext("mongodb://127.0.0.1:27017", "DigitalMenu"); var dishRepository = new DishRepository(mongoDBContext); var workTimeSheetRpository = new WorkTimeSheetRepository(mongoDBContext); _dishService = new DishService(dishRepository, workTimeSheetRpository); }
public DishController(DishRepository repository, Order_DishRepository orderDishRepository, OrderRepository orderRepository, TransactionRepository transactionRepository, IngredientRepository ingredientRepository, Dish_IngredientRepository dishIngredientRepository) { _repository = repository ?? throw new ArgumentNullException(nameof(repository)); _orderDishRepository = orderDishRepository ?? throw new ArgumentNullException(nameof(orderDishRepository)); _orderRepository = orderRepository ?? throw new ArgumentNullException(nameof(orderRepository)); _transactionRepository = transactionRepository ?? throw new ArgumentNullException(nameof(transactionRepository)); _ingredientRepository = ingredientRepository ?? throw new ArgumentNullException(nameof(ingredientRepository)); _dishIngredientRepository = dishIngredientRepository ?? throw new ArgumentException(nameof(dishIngredientRepository)); }
private void FillOrRefreshGridOfDishes() { var dishes = new DishRepository(_connectionString).GetAll(); dataGridViewDishes.DataSource = dishes; dataGridViewDishes.Columns[0].Visible = false; dataGridViewDishes.Columns[1].HeaderText = "Наименование"; }
public MainLogic() { db = new CartPartRepository(); cr = new CustomerRepository(); mr = new MenuRepository(); dr = new DishRepository(); ir = new IngredientRepository(); pr = new ProductRepository(); rr = new RestaurantRepository(); }
private void Add_Dish_Click(object sender, RoutedEventArgs e) { Dish dish = new Dish() { Name = DishNameBox.Text, DishPrice = Convert.ToInt32(DishPriceBox.Text) }; IDishRepository repository = new DishRepository(); repository.CreateDish(dish); }
public async Task <IHttpActionResult> Get(int id) { var dish = await DishRepository.FindOneByAsync(elem => elem.Id == id); if (dish == null) { return(NotFound()); } return(Ok(dish)); }
public static (IDishApplication, IRestaurantApplication) CreateDishApplication() { var(connection, mapper) = LoadDependencies(); var repository = new DishRepository(connection); var repositoryRestaurant = new RestaurantRepository(connection); return (new DishApplication(connection, mapper, repository, new DishValidationBeforePersist(repository)), new RestaurantApplication(connection, mapper, repositoryRestaurant, new RestaurantValidationBeforePersist(repositoryRestaurant))); }
private void Add_Order_Click(object sender, RoutedEventArgs e) { IDishRepository dishRepo = new DishRepository(); Order order = new Order() { DishID = Convert.ToInt32(dishRepo.GetDish(dishSelect.Text).DishID), TableID = Convert.ToInt32(tableSelect.Text), TimeStamp = DateTime.Now.ToString("HH:mm:ss") }; IOrderRepository repository = new OrderRepository(); repository.CreateOrder(order); }
public OrderController(OrderRepository repository, In_Store_OrderRepository in_store_orderRepository, Online_OrderRepository online_orderRepository, TransactionRepository transactionRepository, Customer_TransactionRepository customer_TransactionRepository, TableRepository tableRepository, Order_DishRepository orderDishRepository, DishRepository dishRepository, CustomerRepository customerRepository) { _repository = repository ?? throw new ArgumentNullException(nameof(repository)); _in_store_orderRepository = in_store_orderRepository ?? throw new ArgumentNullException(nameof(in_store_orderRepository)); _online_orderRepository = online_orderRepository ?? throw new ArgumentNullException(nameof(online_orderRepository)); _transactionRepository = transactionRepository ?? throw new ArgumentNullException(nameof(transactionRepository)); _customer_TransactionRepository = customer_TransactionRepository ?? throw new ArgumentNullException(nameof(customer_TransactionRepository)); _tableRepository = tableRepository ?? throw new ArgumentNullException(nameof(tableRepository)); _orderDishRepository = orderDishRepository ?? throw new ArgumentNullException(nameof(orderDishRepository)); _dishRepository = dishRepository ?? throw new ArgumentException(nameof(dishRepository)); _customerRepository = customerRepository ?? throw new ArgumentNullException(nameof(customerRepository)); }
public UnitOfWork(RestaurantContext context) { _context = context; User = new UserRepository(_context); Category = new CategoryRepository(_context); Dish = new DishRepository(_context); Wallet = new WalletRepository(_context); Transaction = new TransactionRepository(_context); Cart = new CartRepository(_context); Order = new OrderRepository(_context); Role = new RoleRepository(_context); }
public UnitOfWork(DataDbContext context) { _context = context; _repositories = new ConcurrentDictionary <Type, object>(); Dish = new DishRepository(context); Organization = new OrganizationRepository(context); Basket = new BasketRepository(context); BasketInventory = new BasketInventoryRepository(context); Ratings = new RatingRepository(context); Comments = new CommentRepository(context); }
public void Database_NotFound() { var mongoDBContext = new MongoDBContext("mongodb://127.0.0.1:27017", "_DigitalMenu2"); var dishRepository = new DishRepository(mongoDBContext); var workTimeSheetRpository = new WorkTimeSheetRepository(mongoDBContext); var dishService = new DishService(dishRepository, workTimeSheetRpository); var actual = dishService.GetMenu().Result; Assert.IsFalse(actual.Success); Assert.AreEqual(actual.Message, ErrorMessage.DatabaseEmpty); }
private void btnExportToExcel_Click(object sender, EventArgs e) { if (fromDatePicker.Value.Date > toDatePicker.Value.Date) { MessageBox.Show("\"Дата от\" должна быть раньше чем \"Дата до\"", "", MessageBoxButtons.OK); } else { var xlApp = new Microsoft.Office.Interop.Excel.Application(); object misValue = System.Reflection.Missing.Value; Workbook xlWorkBook = xlApp.Workbooks.Add(misValue); Worksheet xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.Item[1]; xlWorkSheet.Cells[1, 1] = "ID заказа"; xlWorkSheet.Cells[1, 2] = "Дата заказа"; xlWorkSheet.Cells[1, 3] = "Сумма заказа"; xlWorkSheet.Cells[1, 4] = "Содержимое заказа"; var orders = new OrderRepository(_connectionString).GetReport(fromDatePicker.Value, toDatePicker.Value); var dishesRepo = new DishRepository(_connectionString); for (int i = 0; i < orders.Count; i++) { xlWorkSheet.Cells[2 + i, 1] = orders[i].OrderID; xlWorkSheet.Cells[2 + i, 2] = orders[i].OrderDate.ToString("dd-MM-yyyy"); xlWorkSheet.Cells[2 + i, 3] = orders[i].Total; var orderDetailsString = string.Empty; foreach (var pair in orders[i].DishesAndCounts) { orderDetailsString += dishesRepo.GetById(pair.Key).DishName + " " + pair.Value + " порции(-й) , "; } xlWorkSheet.Cells[2 + i, 4] = orderDetailsString; } xlWorkBook.SaveAs($"{AppDomain.CurrentDomain.BaseDirectory}Отчет-с-{fromDatePicker.Value:dd-MM-yyyy}-по-{toDatePicker.Value:dd-MM-yyyy}.xlsx", XlFileFormat.xlOpenXMLWorkbook, misValue, misValue, misValue, misValue, XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); xlWorkBook.Close(); xlApp.Quit(); Marshal.ReleaseComObject(xlWorkSheet); Marshal.ReleaseComObject(xlWorkBook); Marshal.ReleaseComObject(xlApp); MessageBox.Show("Отчет успешно экспортирован", "", MessageBoxButtons.OK); Close(); } }
public ActionResult Index() { TableRepository objTableRepository = new TableRepository(); DishRepository objDishRepository = new DishRepository(); objDishRepository.GetAllDish(); objTableRepository.GetAllTable(); // var objMultipleModels = new Tuple<IEnumerable<SelectListItem>, IEnumerable<SelectListItem>> // (objTableRepository.GetAllTable(), objDishRepository.GetAllDish()); return(View()); }
public IntelligentCookingUnitOfWork(IntelligentCookingContext context) { _context = context; Categories = new CategoryRepository(_context); Ingredients = new IngredientRepository(_context); Dishes = new DishRepository(_context); DishCategories = new DishCategoryRepository(_context); DishIngredients = new DishIngredientRepository(_context); Favourites = new FavouriteRepository(_context); Ratings = new RatingRepository(_context); Users = new UserRepository(_context); RefreshTokens = new RefreshTokenRespository(_context); }
public UnitOfWork() { _context = new FBruContext(); Advertisements = new AdvertisementRepository(_context); Blogs = new BlogRepository(_context); Categories = new CategoryRepository(_context); Dishes = new DishRepository(_context); Images = new ImageRepository(_context); Keywords = new KeywordRepository(_context); Restaurants = new RestaurantRepository(_context); Users = new UserRepository(_context); UserGroups = new UserGroupRepository(_context); }
public async Task <IHttpActionResult> Delete(int id) { var dish = await DishRepository.FindOneByAsync(elem => elem.Id == id); if (dish == null) { return(NotFound()); } DishRepository.Delete(dish); await UnitOfWork.CommitAsync(); return(Ok(dish)); }
private void deleteRecipe_Click(object sender, EventArgs e) { var dishName = recipesTreeView.SelectedNode.Text; var dishID = new DishRepository(_connectionString).GetAll().First(x => x.DishName == dishName).DishID; var dialogResult = MessageBox.Show($"Вы действительно хотите удалить рецепт : {dishName} ?", "Предупреждение", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { new RecipeRepository(_connectionString).Delete(dishID); FillOrRefreshTreeOfRecipes(); } }
public void AddDish(Dish dish) { DishRepository dishRepository = new DishRepository(); dishRepository.Add(dish); }