private void SeedInventoryItems(PizzaContext context)
{
if (context.InventoryItems.Any())
{
return;
}
InventoryItem[] inventoryItems = new InventoryItem[]
{
new InventoryItem {
Name = "Pepperoni", Type = InventoryItemType.Topping, QuantityRemaining = 1000, PricePerUnit = .01M
},
new InventoryItem {
Name = "Sausage", Type = InventoryItemType.Topping, QuantityRemaining = 1000, PricePerUnit = .01M
},
new InventoryItem {
Name = "Mozerella", Type = InventoryItemType.Cheese, QuantityRemaining = 1000, PricePerUnit = .01M
},
new InventoryItem {
Name = "Surge", Type = InventoryItemType.Flavor, QuantityRemaining = 50, PricePerUnit = .50M
},
};
context.InventoryItems.AddRange(inventoryItems);
context.SaveChanges();
}
public PokretanjeProcesa()
{
_pocetnoKreiranje = new KreiranjePizze();
if (_pocetnoKreiranje.PotvrdaKreiranja() == false)
{
return;
}
prikaziPizze();
if (potvrdaPorudzbine() == false)
{
return;
}
PizzaContext db = new PizzaContext();
KreirajPorudzbinu(_pocetnoKreiranje.GotovePizze());
db.Porudzbine.Add(_porudzbina);
db.SaveChanges();
Console.Clear();
prikaz.Prikaz(_porudzbina.PorudzbinaId);
Console.WriteLine("\nPritisnite enter za povratak na pocetnu stranu...");
Console.ReadLine();
}
private void SeedEmployees(PizzaContext context)
{
if (context.Employees.Any())
{
return;
}
Employee[] employees = new Employee[]
{
new Employee {
FirstName = "Donell", LastName = "Banks", PhoneNumber = "205-555-5557", Role = Roles.Manager, Salary = 97000m
},
new Employee {
FirstName = "Jax", LastName = "Cassidy", PhoneNumber = "124-555-7849", Role = Roles.AssistantManager, Salary = 60000m
},
new Employee {
FirstName = "Dilara", LastName = "Gardiner", PhoneNumber = "896-555-9565", Role = Roles.Driver, Salary = 30000m
},
new Employee {
FirstName = "Hammad", LastName = "Goff", PhoneNumber = "322-555-5463", Role = Roles.Insider, Salary = 26000m
},
new Employee {
FirstName = "Ayah", LastName = "Hodges", PhoneNumber = "895-555-7894", Role = Roles.Cashier, Salary = 24000m
}
};
context.Employees.AddRange(employees);
context.SaveChanges();
}
public async Task <IActionResult> Create(string nome, string data_Nascimento, string telefone, string cpf, string logradouro, int numero, string complemento, string bairro, string cep)
{
Endereco endereco = new Endereco();
endereco.Logradouro = logradouro;
endereco.Numero = numero;
endereco.Complemento = complemento;
endereco.Bairro = bairro;
endereco.CEP = cep;
endereco.IdCidade = Convert.ToInt32(Request.Form["IdCidade"]);
Cliente cliente = new Cliente();
cliente.Nome = nome;
cliente.Data_Nascimento = data_Nascimento;
cliente.Telefone = telefone;
cliente.CPF = cpf;
using (var repo = new PizzaContext())
{
repo.Add(cliente);
repo.Add(endereco);
repo.SaveChanges();
}
Cliente_Has_Endereco clienteE = new Cliente_Has_Endereco();
clienteE.CPF = cpf;
clienteE.IdEndereco = endereco.IdEndereco;
using (var repo = new PizzaContext())
{
repo.Add(clienteE);
repo.SaveChanges();
}
return(View(RetornaCidades()));
}
public void GetStatus_ReturnsStatus()
{
//Arrange
var options = new DbContextOptionsBuilder <PizzaContext>()
.UseInMemoryDatabase(databaseName: "PizzaDataBase")
.Options;
//Mocked DB entry
using (var context = new PizzaContext(options))
{
context.Orders.Add(new Order
{
OrderId = 1,
OrderStatus = "Pending"
});
context.SaveChanges();
}
using (var context = new PizzaContext(options))
{
OrdersController controller = new(context);
var result = controller.GetStatus(1).Result.Value;
var actualResult = result.ToString();
Assert.Equal("Pending", actualResult);
}
}
static void Main(string[] args)
{
using (var db = new PizzaContext())
{
// Obtener nombre de la pizza
Console.Write("Nombre pizza: ");
var name = Console.ReadLine();
Console.Write("Precio: ");
var price = decimal.Parse(Console.ReadLine());
// Asignarlo a una pizza
var pizza = new Pizza {
Nombre = name, Precio = price
};
db.Pizzas.Add(pizza);
db.SaveChanges();
// Mostrar pizzas
var query = from b in db.Pizzas
orderby b.Nombre
select b;
Console.WriteLine("Todas las pizzas: ");
foreach (var item in query)
{
Console.WriteLine(item.Nombre);
}
Console.WriteLine("Exit");
Console.ReadLine();
}
}
public bool ProceedOrder(Guid guid, List <OrderedPizza> pizzas)
{
if (SessionManager.Instance.ValidateUser(guid))
{
bool orderProceedSucceeded = false;
using (PizzaContext ctx = new PizzaContext(PizzaContext.ConnectionString))
{
string userName = SessionManager.Instance.GetUserNameByGuid(guid);
User user = (from u in ctx.Users
where u.UserName == userName
select u).FirstOrDefault();
ctx.Orders.Add(new Order
{
Pizzas = pizzas,
Status = Order.StatusCreated,
User = user
});
orderProceedSucceeded = true;
ctx.SaveChanges();
}
return(orderProceedSucceeded);
}
else
{
return(false);
}
}
public ShowBasket()
{
db = new PizzaContext();
AllProduct = new ObservableCollection <Product>();
ProductID = new List <int>();
Sum = 0;
}
public AccountController(UserManager <User> userManager, SignInManager <User> signInManager, RoleManager <IdentityRole> roleManager, PizzaContext context)
{
this.userManager = userManager;
this.signInManager = signInManager;
this.roleManager = roleManager;
db = context;
}
public List <Ingredient> GetAll()
{
using (var db = new PizzaContext())
{
return(db.Ingredients.ToList());
}
}
private void SeedCustomers(PizzaContext context)
{
if (context.Customers.Any())
{
return;
}
Customer[] customers = new Customer[]
{
new Customer {
FirstName = "John", LastName = "Fleet", PhoneNumber = "215-555-5527", StreetAddress = "9570 Broken Dawn Dr", City = "Huntsville", State = "Va", Zip = 35809
},
new Customer {
FirstName = "Jamie", LastName = "Beggar", PhoneNumber = "123-555-7349", StreetAddress = "9890 Half Circle Av", City = "Chicago", State = "Il", Zip = 46809
},
new Customer {
FirstName = "Karen", LastName = "Bassk", PhoneNumber = "846-555-9465", StreetAddress = "6470 Twisted Square Rd", City = "New York City", State = "NY", Zip = 65879
},
new Customer {
FirstName = "Dave", LastName = "Gnome", PhoneNumber = "352-555-5453", StreetAddress = "9552 Upside Monkey Av", City = "St. Louis", State = "Mo", Zip = 89189
},
new Customer {
FirstName = "Sammy", LastName = "Aboleth", PhoneNumber = "896-555-7694", StreetAddress = "1594 Delta Prime Cr", City = "San Diego", State = "Ca", Zip = 70026
}
};
context.Customers.AddRange(customers);
context.SaveChanges();
}
public ActionResult Read()
{
using (var repo = new PizzaContext())
{
var data = repo.Produtos.ToList();
return(View(data));
}
}
public PizzaManager()
{
var builder = new DbContextOptionsBuilder();
builder.UseInMemoryDatabase("Pizza_Db");
_context = new PizzaContext(builder.Options);
}
public List <Pizza> GetAll()
{
using (var db = new PizzaContext())
{
return(db.Pizzas
.Include(nameof(Pizza.Ingredients))
.ToList());
}
}
public void Remove(int ingredientId)
{
using (var db = new PizzaContext())
{
var ingredient = db.Ingredients.Find(ingredientId);
db.Ingredients.Remove(ingredient ?? throw new InvalidOperationException());
db.SaveChanges();
}
}
static void Main(string[] args)
{
using (var db = new PizzaContext())
{
db.Database.EnsureCreated();
db.SaveChanges();
Pokreni pokreni = new Pokreni();
}
}
public PizzaContext Provide()
{
var connection = Effort.DbConnectionFactory.CreatePersistent(_databaseName);
var context = new PizzaContext(connection, true);
context.Database.CreateIfNotExists();
return(context);
}
public void Remove(int pizzaId)
{
using (var db = new PizzaContext())
{
var pizza = db.Pizzas.Find(pizzaId);
db.Pizzas.Remove(pizza ?? throw new InvalidOperationException());
db.SaveChanges();
}
}
public Option <Ingredient> Get(int id)
{
using (var db = new PizzaContext())
{
return(db.Ingredients
.AsNoTracking()
.FirstOrDefault(x => x.IngredientId == id)
.AsOption <Ingredient>());
}
}
public List <Pizza> GetAllByIngredient(int ingredientId)
{
using (var db = new PizzaContext())
{
return(db.Pizzas
.Include(nameof(Pizza.Ingredients))
.AsNoTracking()
.Where(p => p.Ingredients.Any(i => i.IngredientId == ingredientId))
.ToList());
}
}
public void Add(string name)
{
using (var db = new PizzaContext())
{
db.Ingredients.Add(new Ingredient
{
Name = name
});
db.SaveChanges();
}
}
public ProdutosParaPedido RetornaCidades()
{
ProdutosParaPedido listaCidade = new ProdutosParaPedido();
using (var repo = new PizzaContext())
{
var cidade = repo.Cidade.ToList();
listaCidade.ListaCidade = cidade;
}
return(listaCidade);
}
public void GetOrder()
{
var options = new DbContextOptionsBuilder <PizzaContext>()
.UseSqlServer("Server=localhost;Database=PizzaOrderingSystem;Trusted_Connection=True;MultipleActiveResultSets=true")
.Options;
var context = new PizzaContext(options);
OrdersController ordersController = new OrdersController(context);
var order = ordersController.GetOrder(4).Result.Value;
int actualCustomerId = 11;
Assert.Equal(actualCustomerId, order.CustomerId);
}
public Option <Pizza> Get(int id)
{
using (var db = new PizzaContext())
{
return(db.Pizzas
.Include(nameof(Pizza.Ingredients))
.Include("Ingredients.Ingredient")
.AsNoTracking()
.FirstOrDefault(x => x.PizzaId == id)
.AsOption <Pizza>());
}
}
public async Task OneTimeSetup()
{
var environmentBuilder = new DockerEnvironmentBuilder();
_dockerEnvironment = PrepareDockerEnvironment(environmentBuilder);
await _dockerEnvironment.Up();
var connectionString = _dockerEnvironment.GetContainer <MssqlContainer>("testDb").GetConnectionString();
DbContext = new PizzaContext(connectionString);
await DbContext.Database.EnsureCreatedAsync();
}
// GET: pedidoes/Create
public ActionResult Create()
{
ProdutosParaPedido lista = new ProdutosParaPedido();
using (var repo = new PizzaContext())
{
var clientes = repo.Cliente.ToList();
var produtos = repo.Produtos.ToList();
lista.ListaCliente = clientes;
lista.ListaProduto = produtos;
return(View(lista));
}
}
private LoginScreen loginScreen; //Окно с авторизацией
public MainViewModel()
{
db = new PizzaContext();
basket = new ShowBasket();
menu = new Katalog(basket);
build = new Konstruktor(basket);
kor = new Korzina(basket);
report = new Page_Report();
order = new Page_Order();
SourcePage = menu; //Текущая страница
}
public void Rename(int ingredientId, string ingredientName)
{
using (var db = new PizzaContext())
{
var ingredient = db.Ingredients.Find(ingredientId);
if (ingredient != null)
{
ingredient.Name = ingredientName;
}
db.SaveChanges();
}
}
private int sous_id = 0; //Выбранный соус
public BuildingPizza(ShowBasket sb)
{
db = new PizzaContext();
basket = sb;
Images = new ObservableCollection <ImageViewModel>();
IngredientID = new List <int>();
ing = db.Ingredient.ToList().Select(i => new IngredientViewModel(i)).ToList();
AllIngredient = new List <IngredientViewModel>();
selectedingredient = ing.Where(i => i.IngredientID == 1).SingleOrDefault();
sum = selectedingredient.Price;
massa = selectedingredient.Massa;
IngredientID.Add(selectedingredient.IngredientID);
}
public ReportViewModel()
{
product = new Page_Product(this); //Страница продуктов
ing = new Page_Ing(this); //Страница ингредиентов
otchet = new Page_Otchet(this); //Страница с отчётом
SourcePage = otchet; //Текущая страница
db = new PizzaContext();
report = new ReportModel(); //Отчёт
Products = new ObservableCollection <Product>(db.Product);
Ingredients = new ObservableCollection <Ingredient>(db.Ingredient);
Kategori = db.Kategori.ToList(); //Заполнение комбобокса в ингредиентах
Data = new List <Result>(); //Результат отчёта
}
