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) {
//opens the connection to SQL via the UsersController constructor
UsersController UserCtrl = new UsersController(@"STUDENT03\SQLEXPRESS", "prssql");
VendorsController VendorCtrl =new VendorsController(@"STUDENT03\SQLEXPRESS", "prssql");
//VENDOR CODE STARTS HERE
//returns the list of all vendors in the Vendor table in prssql database
Console.WriteLine("List of all vendors:");
IEnumerable<Vendor> vendors = VendorCtrl.List();
foreach (Vendor vendor1 in vendors) {
Console.WriteLine($"{vendor1.Code} {vendor1.Name}");
}
//get the vendor with id number in "VendorCtrl.Get(#)
Console.WriteLine("-----------------------------------------------");
Vendor vendor = VendorCtrl.Get(3);
if (vendor == null) {
Console.WriteLine("Vendor not found");
} else {
Console.WriteLine($"Id {vendor.Id} is {vendor.Code} {vendor.Name}");
Console.WriteLine("-----------------------------------------------");
}
//Begin adding a vendor code here
Console.WriteLine("-----------------------------------------------");
//Vendor newVendor = new Vendor("NOVN", "Novan", "4105 Hopson Road", "Morrisville", "NC", "27560", "919-485-8080", "*****@*****.**", true, true);
//add newVendor to the database
//bool vendorAddSuccess = VendorCtrl.Create(newVendor); //commented out so this won't keep adding to the DB
//END adding a vendor code here
//changing/updating the data in the vendor table
vendor = VendorCtrl.Get(6);
vendor.Email = "*****@*****.**";
bool VendorChangeSuccess = VendorCtrl.Change(vendor);
//delete a vendor
//vendor = VendorCtrl.Get(6);
//bool VendorDeleteSuccess = VendorCtrl.Remove(vendor);
//VENDOR CODE ENDS HERE
/////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////
//USER CODE BELOW HERE
//returns the list of all users in the [User] table in prssql database
Console.WriteLine("List of all users:");
IEnumerable<User> users = UserCtrl.List();
foreach (User user1 in users) {
Console.WriteLine($"{user1.Firstname} {user1.Lastname}");
}
//get the user with id number in "UserCtrl.Get(#)
Console.WriteLine("-----------------------------------------------");
User user = UserCtrl.Get(11);
if (user == null) {
Console.WriteLine("User not found");
} else {
Console.WriteLine($"Id {user.Id} is {user.Firstname} {user.Lastname}");
}
//intentionally putting in bad user id to see if it returns User not found
Console.WriteLine("-----------------------------------------------");
//get the user with id number in "UserCtrl.Get(#)
User user2 = UserCtrl.Get(99);
if (user2 == null) {
Console.WriteLine("User not found");
} else {
Console.WriteLine($"Id {user2.Id} is {user2.Firstname} {user2.Lastname}");
}
//CREATE NEW USER//
//User newUser = new User();
//newUser.Username = "******";
//newUser.Password = "******";
//newUser.Firstname = "New";
//newUser.Lastname = "User";
//newUser.Phone = "555-1234";
//newUser.Email = "*****@*****.**";
//newUser.IsReviewer = true;
//newUser.IsAdmin = false;
//newUser.Active = false;
//add new user to the database//
//bool success = UserCtrl.Create(newUser);
//END CREATE NEW USER//
//changing/updating the data in the user table
user = UserCtrl.Get(3);
user.Firstname= "user3";
bool success = UserCtrl.Change(user);
//delete a user
//user = UserCtrl.Get(13);
//success = UserCtrl.Remove(user);
//closes the active connection to SQL
UserCtrl.CloseConnection();
}
static void Main(string[] args)
{
UsersController UserCtrl = new SqlLibrary.UsersController(@"STUDENT12\SQLEXPRESS", "PRSDatabase");
// IEnumerable<User> users = UserCtrl.List();
// foreach (User user1 in users) {
// Console.WriteLine($"{user1.FirstName} {user1.LastName}");
//}
//User user = UserCtrl.Get(5);
//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 = "Last";
//newUser.LastName = "first";
//newUser.Phone = "513-555-0000";
//newUser.Email = "newuser@gmail";
//newUser.IsReviewer = true;
//newUser.IsAdmin = true;
//newUser.Active = true;
//bool success = UserCtrl.Create(newUser);
//User user = UserCtrl.Get(5);
//user.FirstName = "Harvy";
//bool success = UserCtrl.Change(user);
//user = UserCtrl.Get(10);
//success = UserCtrl.Remove(user);
//UserCtrl.CloseConection();
VendorsController vendorctrl = new VendorsController(@"STUDENT12\SQLEXPRESS", "PRSDatabase");
IEnumerable <Vendor> Vendors = vendorctrl.List();
foreach (Vendor vendors in Vendors)
{
Console.WriteLine($"{vendors.Code} {vendors.Name}");
}
//Vendor newVendor = new Vendor();
//newVendor.Code = "EGG"; //Must be a unique value
//newVendor.Name = "New Egg";
//newVendor.Address = "123 Main Street";
//newVendor.City = "Cincinnati";
//newVendor.State = "OH";
//newVendor.Zip = "45002";
//newVendor.Phone = "nani";
//newVendor.Email = "nano";
//newVendor.IsPreApproved = true;
//bool success = vendorctrl.Create(newVendor);
//Console.WriteLine($"New vendor successfully added = {success}");
//Vendor vendor = vendorctrl.Get(2);
//vendor.Code = "TAR";
//success = vendorctrl.Change(vendor);
Vendor vendordlt = vendorctrl.Get(12);
bool deleted = vendorctrl.Remove(vendordlt);
Console.WriteLine($"Vendor Successfully removed = {deleted}");
}
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();
*
*/
}