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