public void List()
{
var dbContext = new ToyManufacturerDbEntities();
Console.WriteLine("Toy Id \tName \t Price \t Detail \t PlantId");
foreach (var toy in dbContext.Toys)
{
Console.WriteLine(toy.ToyId + toy.ToyName + toy.ToyPrice + toy.ToyDetail + toy.PlantId);
}
}
static void Main(string[] args)
{
int choice = 0;
var dbContext = new ToyManufacturerDbEntities();
Console.WriteLine("1. Add offers");
Console.WriteLine("2. Add Customer");
Console.WriteLine("3. Login Customer");
Console.WriteLine("4. Add Plants");
Console.WriteLine("5. Add Toy");
Console.WriteLine("Enter Your Choice : ");
choice = Convert.ToInt32(Console.ReadLine());
do
{
switch (choice)
{
case 1:
Offer offer = new Offer();
offer.GetData();
dbContext.Offers.Add(offer);
dbContext.SaveChanges();
Console.WriteLine("Offer Added Successfully");
break;
case 2:
Customer customer = new Customer();
customer.GetData();
var check = dbContext.Customers.SingleOrDefault(t => t.CustomerEmail == customer.CustomerEmail);
if (check == null)
{
try
{
dbContext.Customers.Add(customer);
dbContext.SaveChanges();
Console.WriteLine("Customer Added Successfully");
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
else
{
Console.WriteLine("Customer Already Exists");
}
break;
case 3:
login();
break;
case 4:
Plant plant = new Plant();
plant.GetData();
dbContext.Plants.Add(plant);
break;
case 5:
Toy toy = new Toy();
toy.GetData();
dbContext.Toys.Add(toy);
dbContext.SaveChanges();
break;
}
Console.WriteLine("Enter Your Choice : ");
choice = Convert.ToInt32(Console.ReadLine());
} while (choice != 0);
void login()
{
using (dbContext)
{
var customer = new Customer();
Console.WriteLine("Enter Your Email Id : ");
customer.CustomerEmail = Console.ReadLine();
var check = dbContext.Customers.SingleOrDefault(t => t.CustomerEmail == customer.CustomerEmail);
if (check == null)
{
Console.WriteLine("Please Enter Valid Credentials");
}
else
{
Console.WriteLine("You have logged in successfully");
AddOrder(check.CustomerId);
}
}
}
void AddOrder(int customerid)
{
using (dbContext) {
var order = new Order();
var toy = new Toy();
toy.List();
Console.WriteLine("Enter you want to Buy Toy Id :");
order.CustomerId = customerid;
ShowAddress(customerid);
Console.WriteLine("Enter Address id where you want delivery: ");
order.AddressId = Convert.ToInt32(Console.ReadLine());
try
{
dbContext.Orders.Add(order);
dbContext.SaveChanges();
var orderInvoice = dbContext.Orders.Where(t => t.CustomerId == customerid).FirstOrDefault();
var orderId = orderInvoice.OrderId;
Console.WriteLine("Enter ToyId you want Buy :");
var toyid = Convert.ToInt32(Console.ReadLine());
AddOrderInvoiceDetail(orderId, toyid);
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
}
void AddOrderInvoiceDetail(int orderid, int toyid)
{
using (dbContext)
{
var orderInvoice = new OrderInvoice();
orderInvoice.OrderId = orderid;
orderInvoice.ToyId = toyid;
try
{
dbContext.OrderInvoices.Add(orderInvoice);
dbContext.SaveChanges();
Console.WriteLine("Your Invoice is Generated");
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
}
void ShowAddress(int customerid)
{
var addressList = dbContext.Addresses.Where(t => t.CustomerId == customerid);
if (addressList != null)
{
Console.WriteLine("AddressId \t Location \t City \tPincode");
}
foreach (var address in addressList)
{
Console.WriteLine(address.AddressId + address.AddressLocation + address.City + address.Pincode);
}
}
}
