public void PlaceNewOrderDB(int customerId, int filmProductId, int filmLocationId, int filmQuantityId, decimal orderTotal)
{
string connectionString = SecretConfiguration.ConnectionString;
DbContextOptions <TopTenMoviesContext> options = new DbContextOptionsBuilder <TopTenMoviesContext>()
.UseSqlServer(connectionString)
.Options;
using var context = new TopTenMoviesContext(options);
DateTime dateTime = new DateTime(2019, 10, 16);
Orders newOrder = new Orders();
newOrder.CustomerId = customerId;
newOrder.ProductId = filmProductId;
newOrder.LocationId = filmLocationId;
newOrder.Quantity = filmQuantityId;
newOrder.OrderTotal = orderTotal;
newOrder.OrderTime = dateTime;
context.Orders.Add(newOrder);
context.SaveChanges();
}
public void AddNewInventoryDB(string filmTitle, string filmPrice)
{
string connectionString = SecretConfiguration.ConnectionString;
DbContextOptions <TopTenMoviesContext> options = new DbContextOptionsBuilder <TopTenMoviesContext>()
.UseSqlServer(connectionString)
.Options;
using var context = new TopTenMoviesContext(options);
var product = new Product();
product.Title = filmTitle;
product.Price = decimal.Parse(filmPrice);
context.Product.Add(product);
context.SaveChanges();
Console.Clear();
Console.WriteLine("Top Ten Video Store\n");
Console.WriteLine($"{product.Title} ${product.Price} Added.\n");
Console.WriteLine("Hit any Key to Continue: ");
Console.ReadKey();
}
public void GetOrdersByLocationDB(int locationID)
{
string connectionString = SecretConfiguration.ConnectionString;
DbContextOptions <TopTenMoviesContext> options = new DbContextOptionsBuilder <TopTenMoviesContext>()
.UseSqlServer(connectionString)
.Options;
using var context = new TopTenMoviesContext(options);
using var context2 = new TopTenMoviesContext(options);
using var context3 = new TopTenMoviesContext(options);
int count = 0;
foreach (Orders order in context.Orders)
{
var title = context2.Product.FirstOrDefault(p => p.ProductId == order.ProductId);
var location = context3.Location.FirstOrDefault(p => p.LocationId == order.LocationId);
if (order.LocationId == locationID)
{
count++;
Console.WriteLine($"[LocationID] {order.LocationId} [Location] {location.City} [Title] {title.Title} " +
$"[Quantity] {order.Quantity}");
}
}
if (count == 0)
{
Console.WriteLine("\nNo Orders at this Location");
Console.WriteLine("\nHit any Key to Continue");
Console.ReadKey();
}
}
public void AddNewCustomerDB()
{
string connectionString = SecretConfiguration.ConnectionString;
DbContextOptions <TopTenMoviesContext> options = new DbContextOptionsBuilder <TopTenMoviesContext>()
.UseSqlServer(connectionString)
.Options;
using var context = new TopTenMoviesContext(options);
Customer newCustomer = new Customer();
while (true)
{
Console.Clear();
Console.WriteLine("Top Ten Video Store\n");
Console.WriteLine("Enter Customer First and Last Name:");
Console.WriteLine("(or Exit to Return to Menu)\n");
string customerName = Console.ReadLine();
string[] fullName = customerName.Split(' ');
if (fullName[0].ToLower() == "exit")
{
return;
}
else if (string.IsNullOrEmpty(customerName) || fullName.Length != 2)
{
Console.WriteLine("Invalid Name\n");
Console.WriteLine("Hit any Key to Continue.");
Console.ReadKey();
}
else
{
newCustomer.FirstName = fullName[0];
newCustomer.LastName = fullName[1];
break;
}
}
context.Customer.Add(newCustomer);
context.SaveChanges();
Console.Clear();
Console.WriteLine("Top Ten Video Store\n");
Console.WriteLine($"{newCustomer.FirstName} {newCustomer.LastName} Added.\n");
Console.WriteLine("Hit any Key to Continue: ");
Console.ReadKey();
}
public void GetAllLocationsDB()
{
string connectionString = SecretConfiguration.ConnectionString;
DbContextOptions <TopTenMoviesContext> options = new DbContextOptionsBuilder <TopTenMoviesContext>()
.UseSqlServer(connectionString)
.Options;
using var context = new TopTenMoviesContext(options);
foreach (Location location in context.Location)
{
Console.WriteLine($"[LocationId] {location.LocationId} [City] {location.City}");
}
}
public void GetAllProducts()
{
string connectionString = SecretConfiguration.ConnectionString;
DbContextOptions <TopTenMoviesContext> options = new DbContextOptionsBuilder <TopTenMoviesContext>()
.UseSqlServer(connectionString)
.Options;
using var context = new TopTenMoviesContext(options);
foreach (Product product in context.Product)
{
Console.WriteLine($"[ProductId] {product.ProductId} [Title] {product.Title}");
}
}
public void GetAllCustomersDB()
{
string connectionString = SecretConfiguration.ConnectionString;
DbContextOptions <TopTenMoviesContext> options = new DbContextOptionsBuilder <TopTenMoviesContext>()
.UseSqlServer(connectionString)
.Options;
using var context = new TopTenMoviesContext(options);
Console.Clear();
foreach (Customer customer in context.Customer)
{
Console.WriteLine($"[CustomerId] {customer.CustomerId} [Customer Name] {customer.FirstName} {customer.LastName}");
}
}
public void SearchForCustomerDB(string firstName, string lastName)
{
string connectionString = SecretConfiguration.ConnectionString;
DbContextOptions <TopTenMoviesContext> options = new DbContextOptionsBuilder <TopTenMoviesContext>()
.UseSqlServer(connectionString)
.Options;
using var context = new TopTenMoviesContext(options);
var foundName = context.Customer.FirstOrDefault(p => p.FirstName == firstName && p.LastName == lastName);
if (foundName is null)
{
Console.WriteLine("No Record Found");
return;
}
Console.WriteLine($"\n[CustomerId] {foundName.CustomerId} [Customer Name] {foundName.FirstName} {foundName.LastName}");
}
public int GetCustomerIdDB(string firstName, string lastName)
{
string connectionString = SecretConfiguration.ConnectionString;
DbContextOptions <TopTenMoviesContext> options = new DbContextOptionsBuilder <TopTenMoviesContext>()
.UseSqlServer(connectionString)
.Options;
using var context = new TopTenMoviesContext(options);
var foundName = context.Customer.FirstOrDefault(p => p.FirstName == firstName && p.LastName == lastName);
if (foundName is null)
{
Console.WriteLine("No Record Found");
return(0);
}
else
{
return(foundName.CustomerId);
}
}
public void GetOrdersByCustomerDB(int customerID)
{
string connectionString = SecretConfiguration.ConnectionString;
DbContextOptions <TopTenMoviesContext> options = new DbContextOptionsBuilder <TopTenMoviesContext>()
.UseSqlServer(connectionString)
.Options;
using var context = new TopTenMoviesContext(options);
using var context2 = new TopTenMoviesContext(options);
using var context3 = new TopTenMoviesContext(options);
foreach (Orders order in context.Orders)
{
var title = context2.Product.FirstOrDefault(p => p.ProductId == order.ProductId);
var location = context3.Location.FirstOrDefault(p => p.LocationId == order.LocationId);
if (order.CustomerId == customerID)
{
Console.WriteLine($"[CustomerId] {order.CustomerId} [Location] {location.City} [Title] {title.Title} " +
$"[Quantity] {order.Quantity}");
}
}
}
