static void ActnVendor()
{
//Returns all
VendorsController VendorCtrl = new VendorsController(@"STUDENT50\SQLEXPRESS", "prssql");
IEnumerable <Vendor> vendor = VendorCtrl.List();
foreach (Vendor Vendor1 in vendor)
{
Console.WriteLine($"{Vendor1.Code} {Vendor1.Name} {Vendor1.Address}");
}
Vendor Amzn = VendorCtrl.Get(1);
if (Amzn == null)
{
Console.WriteLine("Vendor not found");
}
else
{
Console.WriteLine($"{Amzn.Code} {Amzn.Name} {Amzn.Address}");
}
Amzn = VendorCtrl.Get(999);
if (Amzn == null)
{
Console.WriteLine("User not found");
}
else
{
Console.WriteLine($"{Amzn.Code} {Amzn.Name} {Amzn.Address}");
}
Vendor newVendor = new Vendor()
{
Code = "Walm",
Address = "564 Walmart way",
Name = "Walmart",
City = "Walmartville",
State = "GA",
Zip = "98123",
Email = "*****@*****.**",
Phone = "987-456-1203",
Active = true,
IsPreapproved = true
};
//bool success = VendorCtrl.Create(newVendor);
Vendor vendorWal = VendorCtrl.Get(5);
vendorWal.Code = "WAL";
//bool success = VendorCtrl.Change(vendorWal);
bool success = VendorCtrl.Remove(vendorWal);
VendorCtrl.CloseConnection();
}
static void Main(string[] args)
{
VendorsController VendorCtrl = new VendorsController(@"dsi-workstation\SQLEXPRESS", "prssql");
IEnumerable <Vendor> vendors = VendorCtrl.List();
Vendor v1 = VendorCtrl.Get(1);
int AmazonId = v1.Id;
v1.Name = "Amazon, Inc.";
VendorCtrl.Change(v1);
v1.Id = 0;
v1.Name = "Walmart";
v1.Code = "WALM";
VendorCtrl.Create(v1);
v1.Id = 3;
VendorCtrl.Remove(v1);
VendorCtrl.CloseConnection();
/*
* UsersController UserCtrl = new UsersController(@"dsi-workstation\SQLEXPRESS", "prssql");
*
* IEnumerable<User> users = UserCtrl.List();
* foreach(User user1 in users) {
* Console.WriteLine($"{user1.Firstname} {user1.Lastname}");
* }
*
* User user = UserCtrl.Get(6);
* if(user == null) {
* Console.WriteLine("User not found");
* } else {
* Console.WriteLine($"{user.Firstname} {user.Lastname}");
* }
*
* user = UserCtrl.Get(999);
* if (user == null) {
* Console.WriteLine("User not found");
* } else {
* Console.WriteLine($"{user.Firstname} {user.Lastname}");
* }
*
* User newUser = new User();
* newUser.Username = "******";
* newUser.Password = "******";
* newUser.Firstname = "New";
* newUser.Lastname = "User";
* newUser.Phone = "513-555-1212";
* newUser.Email = "*****@*****.**";
* newUser.IsReviewer = false;
* newUser.IsAdmin = true;
*
* //bool success = UserCtrl.Create(newUser);
*
* user = UserCtrl.Get(6);
* user.Firstname = "Kimmie";
* //bool success = UserCtrl.Change(user);
*
* user = UserCtrl.Get(19);
* if(user != null)
* UserCtrl.Remove(user);
*
* UserCtrl.CloseConnection();
*
*/
}