public static List <PackShipment> All()
{
BestradeContext btContext = new BestradeContext();
List <PackShipment> packShipment = btContext.PackShipment.ToList();
return(packShipment);
}
public static PackShipment Single(string purchase, string sku, string shipment)
{
BestradeContext btContext = new BestradeContext();
PackShipment packShipment = btContext.PackShipment.SingleOrDefault(p => p.purchase == purchase && p.sku == sku && p.shipment == shipment);
return(packShipment);
}
public static List <Mod> All()
{
BestradeContext btContext = new BestradeContext();
List <Mod> mods = btContext.Mods.ToList();
return(mods);
}
public static Mod Single(string mod_num)
{
BestradeContext btContext = new BestradeContext();
Mod mod = btContext.Mods.SingleOrDefault(m => m.mod_num == mod_num);
return(mod);
}
public static Purchase Single(string Purchase)
{
BestradeContext btContext = new BestradeContext();
Purchase purchase = btContext.Purchases.SingleOrDefault(p => p.purchase == Purchase);
return(purchase);
}
public static List <FBA> All()
{
BestradeContext btContext = new BestradeContext();
List <FBA> fba = btContext.FBA.ToList();
return(fba);
}
public static List <Purchase> All()
{
BestradeContext btContext = new BestradeContext();
List <Purchase> purchases = btContext.Purchases.ToList();
return(purchases);
}
public static FBA Single(string sku)
{
BestradeContext btContext = new BestradeContext();
FBA fba = btContext.FBA.SingleOrDefault(f => f.sku == sku);
return(fba);
}
public static Pack Single(string purchase, string sku)
{
BestradeContext btContext = new BestradeContext();
Pack pack = btContext.Packs.SingleOrDefault(p => p.sku == sku && p.purchase == purchase);
return(pack);
}
public static List <Pack> All()
{
BestradeContext btContext = new BestradeContext();
List <Pack> packs = btContext.Packs.ToList();
return(packs);
}
public static Shipment Single(string Shipment)
{
BestradeContext btContext = new BestradeContext();
Shipment shipment = btContext.Shipments.SingleOrDefault(p => p.shipment == Shipment);
return(shipment);
}
public static List <Shipment> All()
{
BestradeContext btContext = new BestradeContext();
List <Shipment> shipments = btContext.Shipments.ToList();
return(shipments);
}
public static List <Overview> All()
{
BestradeContext btContext = new BestradeContext();
return(btContext.Database.SqlQuery <Overview>("SELECT * FROM Overview").ToList());
}
public static List <PackPurchaseView> All()
{
BestradeContext btContext = new BestradeContext();
return(btContext.Database.SqlQuery <PackPurchaseView>("SELECT * FROM PackPurchaseView ORDER BY date DESC").ToList());
}
public static List <PackShipmentView> view()
{
BestradeContext btContext = new BestradeContext();
return(btContext.Database.SqlQuery <PackShipmentView>("SELECT * FROM PackShipmentView WHERE p_qty > s_qty").ToList());
}
