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