static void EfAssignment2()
{
#if EfAssignment2
void UpdateVendor()
{
using (var db = new PurchaserEntities())
{
var vend = new Vendor()
{
Name = "Fairy Dust"
};
db.Vendors.Add(vend);
db.SaveChanges();
vend = db.Vendors.Find(28);
db.Vendors.Remove(vend);
db.SaveChanges();
}
}
UpdateVendor();
#endif
}
static void EfAssignment3()
{
#if EfAssignment3
using (var db = new PurchaserEntities())
{
try
{
ViewsSprocsFunctions(db);
}
catch (Exception ex)
{
Console.WriteLine($"{ex.Message}");
}
}
}
private static void ViewsSprocsFunctions(PurchaserEntities db)
{
#if ViewSprocFunction
string seperator = new string ('=', 40);
// View //
Console.WriteLine("View:");
var summaries = db.PoSummaries.ToList();
foreach (var sum in summaries)
{
Console.WriteLine($"{sum.PurchaseOrderId}\t{sum.PODate}\t{sum.Vendor}\t{sum.TotalAmount:c}");
}
Console.WriteLine($"{seperator}");
// Table-Valued Functions //
Console.WriteLine("Table-Valued Function:");
var poDetails = db.PoDetail(1).ToList();
foreach (var poDetail in poDetails)
{
Console.WriteLine($"{poDetail.PurchaseOrderId}\t{poDetail.PODate}\t{poDetail.Vendor}\t{poDetail.Part}\t{poDetail.Quantity}\t{poDetail.Value}");
}
Console.WriteLine($"{seperator}");
// Stored Procedures //
Console.WriteLine("Stored Procedure");
var amount = new System.Data.Entity.Core.Objects.ObjectParameter("amount", typeof(decimal));
var pop = db.POP(1, amount);
Console.WriteLine($"{amount.Value:c}");
#endif
#endif
}
static void Linq2()
{
#if Linq2
string seperator = new string ('=', 40);
using (var db = new PurchaserEntities())
{
Console.WriteLine($"Sum of Total Purchases:");
double totalPurchases = Convert.ToDouble(db.PurchaseOrders.Sum(pu => pu.Amount));
Console.WriteLine($"Method: {totalPurchases:c}");
totalPurchases = Convert.ToDouble((from pu in db.PurchaseOrders select pu.Amount).Sum());
Console.WriteLine($"Query: {totalPurchases:c}");
Console.WriteLine(seperator);
Console.WriteLine($"Sorted Purchase Orders:");
var sortedPOs = db.PurchaseOrders.OrderByDescending(pu => pu.Amount).ToList();
Console.WriteLine($"Method: ");
Console.WriteLine($"ID#:\tDate:\t\t\tVendorID:");
foreach (var po in sortedPOs)
{
Console.WriteLine($"{po.PurchaseOrderId}\t{po.PODate}\t{po.Amount:c}");
}
Console.WriteLine();
Console.WriteLine($"Query:");
Console.WriteLine($"ID#:\tDate:\t\t\tVendorID:");
sortedPOs = (from pu in db.PurchaseOrders orderby pu.Amount descending select pu).ToList();
foreach (var po in sortedPOs)
{
Console.WriteLine($"{po.PurchaseOrderId}\t{po.PODate}\t{po.Amount:c}");
}
Console.WriteLine(seperator);
Console.WriteLine($"Anonymous Objects:");
Console.WriteLine($"Method:");
var anonyPOs = db.PurchaseOrders.Select(
pu => new
{
pu.PurchaseOrderId,
vendor = pu.Vendor.Name,
pu.Amount,
pu.PurchaseOrderStatusID
}
).ToList();
Console.WriteLine($"ID#:\tVendor:\t\tAmount:\t\tStatus:");
foreach (var pu in anonyPOs)
{
Console.WriteLine($"{pu.PurchaseOrderId}\t{pu.vendor}\t{pu.Amount:c}\t{pu.PurchaseOrderStatusID}");
}
Console.WriteLine($"Query:");
anonyPOs = (from pu in db.PurchaseOrders let Vendor = pu.Vendor.Name select new
{
pu.PurchaseOrderId,
vendor = pu.Vendor.Name,
pu.Amount,
pu.PurchaseOrderStatusID
}
).ToList();
Console.WriteLine($"ID#:\tVendor:\t\tAmount:\t\tStatus:");
foreach (var pu in anonyPOs)
{
Console.WriteLine($"{pu.PurchaseOrderId}\t{pu.vendor}\t{pu.Amount:c}\t{pu.PurchaseOrderStatusID}");
}
}
//WriteLine($"\n<----- Purchase Orders by Vendor ----->");
//var pos = PurchaseOrder.ByVendor(21);
//foreach (var po in pos)
// Display(po);
//WriteLine($"\n<----- Parts > $70 ----->");
//var parts = Part.PartsAbove(70m);
//foreach (var p in parts)
// Display(p);
//WriteLine($"\n<----- Parts With Highest QoH ----->");
//var part = Part.HighestQoH();
//Display(part);
//WriteLine($"\n<----- Receipts Descending by Cost ----->");
//var receipts = Receipt.ByCost();
//foreach (var receipt in receipts)
// Display(receipt);
#endif
}