public bool AddSecondaryItem(string Name, int Quantity, decimal Cost, int NotificationLevel,
long SupplierID, bool ApplicationKit, bool Mailer)
{
DataClasses1DataContext dbContext = new DataClasses1DataContext();
SecondaryItem secondary = new SecondaryItem
{
Name = Name,
Quantity = Quantity,
Cost = Cost,
NotificationLevel = NotificationLevel,
SupplierID = SupplierID,
ApplicationKit = ApplicationKit,
Mailer = Mailer
};
dbContext.SecondaryItems.InsertOnSubmit(secondary);
try
{
dbContext.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
Console.WriteLine(e.Message, e.StackTrace);
}
return(true);
}
public static bool CheckNotify(Int64 ItemID)
{
DataClasses1DataContext dbContext = new DataClasses1DataContext();
SecondaryItem item = dbContext.SecondaryItems.Where(si => si.ID == ItemID).FirstOrDefault();
return(item.Quantity <= item.NotificationLevel);
}
private void button1_Click(object sender, EventArgs e)
{
//check values
if (!int.TryParse(QuantityTextBox.Text, out int Quantity))
{
MessageBox.Show("Item not added. Please enter a whole number for the quantity");
QuantityTextBox.Text = "0";
return;
}
decimal ItemCost;
if (!decimal.TryParse(CostTextBox.Text, out ItemCost))
{
MessageBox.Show("Item not added. Please enter a valid price as #.## or ##");
CostTextBox.Text = "0.00";
return;
}
if (TotalRadio.Checked)
{
ItemCost = ItemCost / Quantity;
}
Supplier supplier = new Supplier();
if (SupplierTextBox.Text != "")
{
supplier.ID = supplier.AddNewSupplier(SupplierTextBox.Text, OrderLinkTextBox.Text);
}
else
{
//TO DO! For testing only, fix type to be nullable
supplier.ID = 1;
}
SecondaryItem secondary = new SecondaryItem();
bool success = secondary.AddSecondaryItem(NameTextBox.Text, Quantity, ItemCost, Convert.ToInt16(NotificationUpDown.Value), supplier.ID, AppKitBox.Checked, MailerBox.Checked);
if (success)
{
Close();
}
else
{
MessageBox.Show("An error occurred. This item was not added");
}
}
public static bool GetOtherNotify(Int64 SecondaryID)
{
DataClasses1DataContext dbContext = new DataClasses1DataContext();
SecondaryItem secondary = dbContext.SecondaryItems.Where(s => s.ID == SecondaryID).First();
if (secondary.Quantity <= secondary.NotificationLevel)
{
return(true);
}
else
{
return(false);
}
}
public static bool Outgoing(SecondaryItem secondary)
{
DataClasses1DataContext dbContext = new DataClasses1DataContext();
SecondaryItem secondaryItem = dbContext.SecondaryItems.Where(si => si.ID == secondary.ID).FirstOrDefault();
secondaryItem.Quantity -= secondary.Quantity;
try
{
dbContext.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
Console.WriteLine(e.Message, e.StackTrace);
}
return(true);
}
private void Savebtn_Click(object sender, EventArgs e)
{
List <Product> productsInOrder = new List <Product>();
foreach (DataGridViewRow Row in VinylGridView.Rows)
{
if (Row.Cells[0].Value != null)
{
Product vinyl = new Product(Convert.ToInt64(Row.Cells[0].Value),
Convert.ToInt32(Row.Cells[1].Value), Convert.ToInt32(Row.Cells[2].Value),
Convert.ToInt32(Row.Cells[3].Value), Convert.ToInt32(Row.Cells[4].Value));
productsInOrder.Add(vinyl);
}
}
List <Sticker> stickersInOrder = new List <Sticker>();
foreach (DataGridViewRow Row in StickerGridView.Rows)
{
if (Row.Cells[0].Value != null)
{
Sticker sticker = new Sticker(Convert.ToInt64(Row.Cells[0].Value), Convert.ToInt32(Row.Cells[1].Value));
stickersInOrder.Add(sticker);
}
}
List <SecondaryItem> otherItemsInOrder = new List <SecondaryItem>();
foreach (DataGridViewRow Row in OtherGridView.Rows)
{
if (Row.Cells[0].Value != null)
{
SecondaryItem secondary = new SecondaryItem(Convert.ToInt64(Row.Cells[0].Value), Convert.ToInt32(Row.Cells[1].Value));
otherItemsInOrder.Add(secondary);
}
if (vinylAppKitCheckBox.Checked)
{
//make an add kit function
}
}
string message = "Vinyl in order = " + productsInOrder.Count.ToString() +
"\nStickers in order = " + stickersInOrder.Count.ToString() +
"\nOther grid row count = " + otherItemsInOrder.Count.ToString();
MessageBox.Show(message);
// Make an order
DateTime date = dateTimePicker1.Value;
if (!decimal.TryParse(PriceTBox.Text, out decimal price))
{
MessageBox.Show("Please enter a valid order price");
return;
}
Int64 orderID = Order.NewOrder(date, price);
if (productsInOrder.Any())
{
foreach (Product p in productsInOrder)
{
bool success = true;
double vinylQuantity = Product.GetProductTotal(p);
VinylOrderItem.AddToOrder(orderID, p.ID, vinylQuantity);
if (p.FullSheet < 1 && p.FullSheet > 0)
{
success = Product.Outgoing(p, orderID);
}
else
{
success = Product.Outgoing(p.ID, vinylQuantity);
}
if (!success)
{
MessageBox.Show("There was an error adjusting quantity of {0} vinyl, please double check your stock", p.Color.Name);
}
if (Product.CheckNotify(p.ID))
{
MessageBox.Show("You're getting low on {0}", p.Color.Name);
}
}
}
if (stickersInOrder.Any())
{
foreach (Sticker s in stickersInOrder)
{
StickerOrderItem.AddToOrder(orderID, s.ID, s.Quantity);
bool success = Sticker.Outgoing(s.ID, s.Quantity);
if (!success)
{
MessageBox.Show("There was an error adjusting quantity of {0} sticker, please double check your stock", s.Name);
}
if (Sticker.CheckNotify(s.ID))
{
MessageBox.Show("You're getting low on {0}", s.Name);
}
}
}
if (otherItemsInOrder.Any())
{
foreach (SecondaryItem si in otherItemsInOrder)
{
SecondaryOrderItem.AddToOrder(orderID, si.ID, si.Quantity);
bool success = SecondaryItem.Outgoing(si);
if (!success)
{
MessageBox.Show("There was an error adjusting quantity of {0} item, please double check your stock", si.Name);
}
if (SecondaryItem.CheckNotify(si.ID))
{
MessageBox.Show("You're getting low on {0}", si.Name);
}
}
}
if (vinylAppKitCheckBox.Checked == true)
{
SecondaryItem.ApplicationKitUsed(orderID, (int)VinylKitCountNumBox.Value);
}
}
