static void Main(string[] args)
{
decimal min = 0;
decimal max = 0;
char choice = '0';
DataClasses1DataContext db = new DataClasses1DataContext();
do
{
Console.WriteLine("Enter 1 to view a range of items, 2 to enter a new item, any other key to exit");
choice = Convert.ToChar(Console.ReadLine());
if (choice == '1')
{
try
{
Console.WriteLine("Please enter the minimum price you'd like to view:");
min = Convert.ToDecimal(Console.ReadLine());
Console.WriteLine("Please enter the maximum price you'd like to view:");
max = Convert.ToDecimal(Console.ReadLine());
db.PRODUCTs.Where(p => p.P_PRICE >= min && p.P_PRICE <= max).ToList().ForEach(
product => Console.WriteLine($"\nProduct: {product.P_CODE} \nDescription: {product.P_DESCRIPT}" +
$"\nPrice: {product.P_PRICE} \nQOH: {product.P_QOH} \nVendor Code: {product.V_CODE ?? null}" +
$" \nVendor Name: {product.VENDOR?.V_NAME ?? ""} \nVendor Contact: {product.VENDOR?.V_CONTACT ?? ""}"));
}
catch (FormatException)
{
Console.WriteLine("Invalid value");
}
}
else if (choice == '2')
{
try
{
Console.WriteLine("Enter the Product Code:");
string pCode = Console.ReadLine();
Console.WriteLine("Enter the Product Description:");
string desc = Console.ReadLine();
Console.WriteLine("Enter the Product Indate:");
DateTime indate = Convert.ToDateTime(Console.ReadLine());
Console.WriteLine("Enter the Product QOH:");
int qoh = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Enter the Product Min:");
int pMin = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Enter the Product Price:");
decimal price = Convert.ToDecimal(Console.ReadLine());
Console.WriteLine("Enter the Product Discount:");
decimal discount = Convert.ToDecimal(Console.ReadLine());
Console.WriteLine("Does the product's vendor already exist? Enter Y or N");
string vendorExist = Console.ReadLine().ToUpper();
VENDOR vndr;
if (vendorExist[0] == 'N')
{
vndr = addVendor();
Console.WriteLine("Vendor has been added");
}
else
{
Console.WriteLine("Enter the Vendor Code");
int code = Convert.ToInt32(Console.ReadLine());
if (db.VENDORs.Any(v => v.V_CODE == code))
{
vndr = db.VENDORs.Where(vend => vend.V_CODE == code).First();
}
else
{
Console.WriteLine("That vendor does not exist. Please enter the " +
"information to add it to the database");
vndr = addVendor();
Console.WriteLine("Vendor has been added");
}
}
PRODUCT p = new PRODUCT()
{
P_CODE = pCode,
P_DESCRIPT = desc,
P_INDATE = indate,
P_QOH = qoh,
P_MIN = pMin,
P_PRICE = price,
P_DISCOUNT = discount,
V_CODE = vndr.V_CODE
};
db.PRODUCTs.InsertOnSubmit(p);
db.SubmitChanges();
Console.WriteLine("Product has been added");
}
catch (FormatException)
{
Console.WriteLine("Invalid value\n");
}
}
else
{
Environment.Exit(0);
}
} while (true);
}
partial void DeletePRODUCT(PRODUCT instance);
partial void UpdatePRODUCT(PRODUCT instance);
partial void InsertPRODUCT(PRODUCT instance);
private void detach_PRODUCTs(PRODUCT entity)
{
this.SendPropertyChanging();
entity.VENDOR = null;
}
private void attach_PRODUCTs(PRODUCT entity)
{
this.SendPropertyChanging();
entity.VENDOR = this;
}
