private void button1_Click(object sender, EventArgs e)
{
string companyName = textBox1.Text;
string productName = textBox2.Text;
if (textBox1.TextLength == 0 || textBox2.TextLength == 0)
{
MessageBox.Show("Musisz uzupelnic pola, aby zlozyc zamowienie");
return;
}
var companies = from c in _context.Customers
select c.CompanyName;
if (!isNameValid(companies, companyName))
{
MessageBox.Show("Niepoprawna nazwa klienta");
return;
}
var products = from p in _context.Products
select p.Name;
if (!isNameValid(products, productName))
{
MessageBox.Show("Niepoprawna nazwa produktu");
return;
}
Product product = _context.Products
.Where(p => p.Name.Equals(productName))
.First();
Order order = new Order();
order.CompanyName = companyName;
order.ProductID = product.ProductID;
order.OrderDate = DateTime.Now;
order.OrderDetails = textBox3.Text;
_context.Orders.Add(order);
_context.SaveChanges();
Hide();
DestroyHandle();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.TextLength == 0 || textBox2.TextLength == 0 || textBox3.TextLength == 0 ||
textBox4.TextLength == 0)
{
MessageBox.Show("Musisz uzupelnic pola, aby zapisac produkt");
return;
}
Product product = new Product();
product.Name = textBox1.Text;
product.UnitsInStock = parseToInt(textBox2.Text);
product.CategoryID = parseToInt(textBox3.Text);
product.Unitprice = parseToInt(textBox4.Text);
if (product.UnitsInStock == -1 || product.CategoryID == -1 || product.Unitprice == -1)
{
MessageBox.Show("Zly format danych");
return;
}
var query = from c in _context.Categories
select c.CategoryID;
bool categoryIdvalid = false;
foreach (var categoryID in query)
{
if (categoryID == product.CategoryID)
{
categoryIdvalid = true;
}
}
if (!categoryIdvalid)
{
MessageBox.Show("Nie mozna dodac produktu do nieistniejacej kategorii");
return;
}
_context.Products.Add(product);
_context.SaveChanges();
Hide();
DestroyHandle();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.TextLength == 0 || textBox2.TextLength == 0)
{
MessageBox.Show("Musisz uzupelnic pola, aby zapisac kategorie");
return;
}
Category category = new Category();
category.CategoryName = textBox1.Text;
category.Description = textBox2.Text;
_context.Categories.Add(category);
_context.SaveChanges();
Hide();
DestroyHandle();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox2.TextLength == 0 || textBox1.TextLength == 0)
{
MessageBox.Show("Musisz uzupelnic pola, aby zapisac kilenta");
return;
}
Customer customer = new Customer();
customer.CompanyName = textBox1.Text;
customer.Description = textBox2.Text;
_context.Customers.Add(customer);
_context.SaveChanges();
Hide();
DestroyHandle();
}
