void RunProductsTest()
{
var conn = new Connection(@"localhost\sqlexpress", "PrsDB");
conn.Open();
Products.Connection = conn;
Vendors.Connection = conn;
var product = new Products()
{
PartNbr = "IE54W", Name = "Cup", Price = 6, Unit = "Each", PhotoPath = null,
VendorID = Vendors.GetByCode("Max Train").ID
};
try {
var success = Products.Insert(product);
//var p = Products.GetByPartNbr("IE54W");
//p.Name = "Cup";
//p.VendorID = Vendors.GetByCode("Max Train").ID;
//success = Products.Update(p);
////////delete
//////var success = Products.Delete(6);
//p = Products.GetByPartNbr("IE54W");
//Console.WriteLine(p);
}
catch (Exception ex) {
Console.WriteLine($"Exception Occured: {ex.Message}");
}
}
void RunVendorsTest()
{
Connection conn = new Connection(@"localhost\sqlexpress", "PrsDb");
conn.Open();
Vendors.Connection = conn;
//GETALL
var vendors = Vendors.GetAll();
foreach (var ven in vendors)
{
Console.WriteLine(ven);
}
//GetByPk
Vendors vendor = Vendors.GetByPk(2); //assignment AND method call
Console.WriteLine($"Vendor line deleted? {Vendors.Delete(3)}");
//UPDATE
Vendors vendorV = Vendors.GetByPk(4);
vendorV.Name = "Doggie Bone";
vendorV.State = "SD";
bool success = Vendors.Update(vendorV);
Console.WriteLine($" {(success ? "Update successful" : "Update failed")}");
//INSERT
Vendors vendorA = new Vendors(); // accesses default constructor in Vendors
vendorA.Code = "MAGC";
vendorA.Name = "Magic R Us";
vendorA.Address = "111 Elm";
vendorA.City = "Columbus";
vendorA.State = "OH";
vendorA.Zip = "33321";
vendorA.Phone = "555-444-3333";
vendorA.Email = "*****@*****.**";
Console.WriteLine($"Vendor insertion successful? {Vendors.Insert(vendorA)}");
//GETBYCODE
Vendors vendster = Vendors.GetByCode("WOOF");
Console.WriteLine(vendster);
conn.Close();
}
void RunProductTest()
{
var conn = new Connection(@"localhost\sqlexpress", "PRSdb");
conn.Open();
Products.Connection = conn;
Vendors.Connection = conn;
var PRODUCT = Products.GetByPartNbr("30372");
//VendorId = Vendors.GetByCode("DNRUS").Id;
Console.WriteLine(PRODUCT);
//var product = new Products() {
// PartNbr = "38462", Name = "Refrosted Flakes", Price = 382, Unit = "40032", PhotoPath = null, VendorId = 1
//};
//try {
// //insert
// var success = Products.Insert(product);
// //update product.id
// var p = Products.GetByPK(1);
// p.Name = "Dino Bones";
// success = Products.Update(p);
//}
//catch (Exception ex) {
// Console.WriteLine($"Exception occured {ex.Message}");
//}
//var lemons = Products.GetByPK(7);
//Console.WriteLine(lemons);
//var products = Products.GetAll();
//foreach(var p in products) {
// Console.WriteLine($"Product {p.Name} from Vendor {p.Vendor.Name} is priced at ${p.Price}");
//}
var VENDOR = Vendors.GetByCode("BGHTS");
Console.WriteLine(VENDOR);
var prodlist = Vendors.GetProducts("DNRUS");
Console.WriteLine(prodlist);
conn.Close();
}
void RunProductsTest()
{
var conn = new Connection(@"localhost\sqlexpress", "PrsDb7");
conn.Open();
Products.Connection = conn;
Vendors.Connection = conn;
var product = new Products()
{
PartNbr = "XYZ001", Name = "XYZ Part", Price = 10, Unit = "Each", PhotoPath = null,
VendorId = Vendors.GetByCode("AMAZ").Id
};
try {
Console.WriteLine("Product list for Vendor Amazon:");
var productList = Vendors.GetProducts("AMAZ");
foreach (var prod in productList)
{
Console.WriteLine(prod);
}
// insert
//var success = Products.Insert(product);
// update product.id = 3
//var p = Products.GetByPartNbr("XYZ001");
//p.Name = "Greg New Part XYZ";
//p.VendorId = Vendors.GetByCode("XXX").Id;
//success = Products.Update(p);
//p = Products.GetByPartNbr("XYZ001");
//Console.WriteLine(p);
//success = Products.Delete(p.Id);
} catch (Exception ex) {
Console.WriteLine($"Exception occurred: {ex.Message}");
}
var products = Products.GetAll();
foreach (var p in products)
{
Console.WriteLine($"Product {p.Name} from Vendor {p.Vendor.Name} is priced at {p.Price}");
}
conn.Close();
}
// INSTANCE METHODS, WITHIN DRIVER CLASS, CALLED ON INSTANCE OF PROGRAM CLASS (CALLED FROM MAIN)
void RunProductsTest()
{
var conn = new Connection(@"localhost\sqlexpress", "PrsDb"); // instantiate/construct an object, and...
conn.Open(); // ...and call a method on this new object
Products.Connection = conn;
Vendors.Connection = conn; // these two lines appear here together because of GetProducts()
// ***** ***** New, popular, alternate syntax for constructor. Note semicolon AFTER the curly braces. Good esp for testing.
// ***** ***** Can choose to initialize with any properties you want without constructing multiple constructors to do so.
// ***** ***** Note semicolon AFTER the curly braces. Good esp for testing.
var product = new Products()
{
PartNbr = "XYZ001", Name = "XYKZ Part", Price = 10, Unit = "EACH", PhotoPath = null, //note LACK of semicolon on this line
VendorId = Vendors.GetByCode("PSFX").Id //The Id of Vendor Pustefix, which is 1
};
try { // Here's a nice try-catch block. It tells the caller what's wrong.
Console.WriteLine("Product list for Vendor NYC Clown Studio:");
var productList = Vendors.GetProducts("NYCC");
foreach (var prod in productList)
{
Console.WriteLine(prod);
}
// INSERT
var success = Products.Insert(product);
// UPDATE
Products p = Products.GetByPartNbr("XYZ001"); // formerly: Products p = Products.GetByPk(4);
p.Name = "GregPartXYZff";
p.VendorId = Vendors.GetByCode("NYCC").Id; // is this working???
success = Products.Update(p); // Result: The product named "GregPartXKYZff" is now vended/sold by NYCC (New York City Clown Studio).
//DELETE
success = Products.Delete(1); //Is THIS one working?????
Console.WriteLine("\nProduct with Id=1 deleted? " + success);
////This is a much better query when you need an id. Query by Part Number, don't need to knokw the id. I just know it's STEPLADD.
var prd = Products.GetByPartNbr("STEPLADD");
Console.WriteLine();
Console.WriteLine(prd);
}
catch (Exception ex) {
Console.WriteLine($"Exception occurred: {ex.Message}");
}
// GetByPk
Products unicycle = Products.GetByPk(2);
Console.WriteLine($"Product {unicycle.Name} from Vendor {unicycle.Vendor.Name} is priced at {unicycle.Price}"); // not sure this line is right */
// featuring fancier print stmt than the ToString override below in GetAll()
// GETALL
var products = Products.GetAll(); // List<T>
foreach (var prod in products)
{
Console.WriteLine(prod); // ToString override
}
conn.Close();
}