private void AddButton_Click(object sender, EventArgs e)
{
string categoryName1 = categoryNameTextBox.Text;
string description1 = descriptionTextBox.Text;
using (var db = new ProdContext())
{
var catID = from c in db.Categories
where c.Name == categoryName1
select c.CategoryID;
if (catID == null)
{
Category category = new Category
{
Name = categoryName1,
Description = description1
};
db.Categories.Add(category);
MessageBox.Show("Category added");
db.SaveChanges();
this.resetBoxes();
}
else
{
MessageBox.Show("Category exists");
}
}
}
private void buyButton_Click(object sender, EventArgs e)
{
if (this.customerNameTextBox.Text == null)
{
MessageBox.Show("Put your customer data");
}
quantity = int.Parse(this.quantityTextBox.Text);
if (quantity > this.available | quantity < 0)
{
MessageBox.Show("Invalid quantity");
}
companyName1 = customerNameTextBox.Text;
Customer company = prodContext.Customers.Where(c => c.CompanyName == companyName1).Select(c => c).FirstOrDefault();
if (company == null)
{
MessageBox.Show("Invalid company name");
return;
}
price = prodContext.Products.Where(p => p.ProductId == productID).Select(p => p.UnitPrice).FirstOrDefault();
string prodName = prodContext.Products.Where(p => p.ProductId == productID).Select(p => p.Name).FirstOrDefault();
decimal value = price * quantity;
this.sum += value;
sumLabel1.Text = "Sum: " + sum.ToString() + " zl ";
this.productsLabel.Text += prodName + " x" + quantity.ToString();
Product product2 = new Product();
product2.ProductId = productID;
product2.Name = prodName;
product2.UnitsInStock = quantity;
product2.UnitPrice = price;
products.Add(product2);
Product product = (from p in prodContext.Products
where p.ProductId == productID
select p).FirstOrDefault();
product.UnitsInStock = available - quantity;
prodContext.SaveChanges();
}
private void addProductButton_Click(object sender, EventArgs e)
{
String productName1 = nameTextBox.Text;
int unitsInStock1 = 0;
while (true)
{
if (!int.TryParse(unitsInStockTextBox.Text, out unitsInStock1))
{
Console.WriteLine("Invalid input units in stock - must be a number");
}
else
{
break;
}
}
decimal unitPrice1 = 0;
while (true)
{
if (!Decimal.TryParse(unitPriceTextBox.Text, out unitPrice1))
{
Console.WriteLine("Invalid input units in stock - must be a number");
}
else
{
break;
}
}
String categoryName1 = categoryNameTextBox.Text;
using (var db = new ProdContext())
{
var catID = from c in db.Categories
where c.Name == categoryName1
select c.CategoryID;
if (catID == null)
{
Console.WriteLine("Invalid category name");
this.resetBoxes();
}
else
{
Product product = new Product
{
Name = productName1,
UnitsInStock = unitsInStock1,
CategoryID = catID.First(),
UnitPrice = unitPrice1
};
db.Products.Add(product);
MessageBox.Show("Product added");
db.SaveChanges();
this.resetBoxes();
}
}
}
private void saveButton_Click(object sender, EventArgs e)
{
prodContext.SaveChanges();
prodContext.Categories.Load();
prodContext.Products.Load();
this.categoryDataGridView.Refresh();
this.productsDataGridView.Refresh();
}
private void addCustomerButton_Click(object sender, EventArgs e)
{
if (this.companyNameTextBox.Text == "" | this.cityTextBox.Text == "" | this.addressTextBox.Text == "" |
this.cityTextBox.Text == "" | this.postalCodeTextBox.Text == "")
{
MessageBox.Show("Fullfill all boxes");
}
Customer customer = (from c in prodContext.Customers
where c.CompanyName == companyNameTextBox.Text
select c).FirstOrDefault();
if (customer != null)
{
MessageBox.Show("This customer already exists");
}
Customer customer1 = new Customer
{
CompanyName = this.companyNameTextBox.Text,
Description = this.descriptionTextBox.Text,
Address = this.addressTextBox.Text,
PostalCode = this.postalCodeTextBox.Text,
City = this.cityTextBox.Text,
Mail = this.cityTextBox.Text,
Phone = this.cityTextBox.Text
};
prodContext.Customers.Add(customer1);
prodContext.SaveChanges();
this.customerDataGridView.Visible = true;
this.customerDataGridView.Update();
this.customerDataGridView.Refresh();
//prodContext.SaveChanges();
MessageBox.Show("Customer added");
}
