private static void showall()
{
customercontext ctx = new customercontext();
Console.WriteLine("customers......");
var customers = ctx.Customers;
foreach (var c in customers)
{
Console.WriteLine("{0}\t{1}\t", c.Cid, c.Cname);
}
Console.WriteLine("\nproducts.......\n");
var products = ctx.Products;
foreach (var prd in products)
{
Console.WriteLine("{0}\t{1}\t{2}", prd.Pid, prd.Pname, prd.Price);
}
Console.WriteLine("\npurchases.....\n");
var purchases = ctx.Purchases;
Console.WriteLine(" {0,-8}{1,-14}{2,-8}{3,-15}{4,10}{5,8}{6,15}", "PurchId", "orderdate", "pid", "prd_name", "price", "custid", "custname");
foreach (var pr in purchases)
{
Console.WriteLine("{0,-8}{1,-14}{2,-8}{3,-15}{4,10}{5,8}{6,15}", pr.Id, pr.OrderDate.ToShortDateString(), pr.Pid, pr.product.Pname, pr.product.Price, pr.Cid, pr.customer.Cid, pr.customer.Cname);
}
}
private static void Insertmethod()
{
customercontext ct = new customercontext();
var customers = new List <customer>
{
new customer {
Cname = "Ambica"
},
new customer {
Cname = "sreeshanth"
},
new customer {
Cname = "bharat"
},
new customer {
Cname = "satya"
},
new customer {
Cname = "vankat"
}
};
customers.ForEach(s => ct.Customers.Add(s));
ct.SaveChanges();
var products = new List <product>
{
new product {
Pname = "rice", Price = 76
},
new product {
Pname = "dal", Price = 176
},
new product {
Pname = "detergent", Price = 276
},
new product {
Pname = "soap", Price = 86
},
new product {
Pname = "snaks", Price = 276
},
};
products.ForEach(p => ct.Products.Add(p));
ct.SaveChanges();
var purchases = new List <purchase>
{
new purchase {
OrderDate = Convert.ToDateTime("09-02-2020"), Pid = 1, Cid = 2
},
new purchase {
OrderDate = Convert.ToDateTime("09-02-2020"), Pid = 2, Cid = 1
},
new purchase {
OrderDate = Convert.ToDateTime("09-02-2020"), Pid = 3, Cid = 2
},
new purchase {
OrderDate = Convert.ToDateTime("09-02-2020"), Pid = 3, Cid = 3
},
new purchase {
OrderDate = Convert.ToDateTime("09-02-2020"), Pid = 4, Cid = 4
},
};
purchases.ForEach(pr => ct.Purchases.Add(pr));
ct.SaveChanges();
Console.WriteLine();
}