private void button1_Click(object sender, EventArgs e)
{
using (EntityModel db = new EntityModel())
{
db.products.Add(new Prod()
{
Name = textBox1.Text, Price = textBox2.Text, Quantity = (int)numericUpDown1.Value, Description = richTextBox1.Text, User_id = Form1.user
});
db.SaveChanges();
Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
using (EntityModel db = new EntityModel())
{
db.customs.Add(new Custom()
{
Name = textBox1.Text, Surname = textBox2.Text, Email = textBox3.Text, Phone = maskedTextBox1.Text, Address = richTextBox1.Text, User_id = Form1.user
});
db.SaveChanges();
Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
using (EntityModel db = new EntityModel())
{
string[] vs = comboBox1.SelectedItem.ToString().Split(' ');
var prod = db.products.ToList().FirstOrDefault(x => x.Name == comboBox2.SelectedItem.ToString());
var clientId = db.customs.ToList().FirstOrDefault(x => x.Name == vs[0]);
db.orders.Add(new Orders()
{
Client_id = clientId, Product_id = prod, Quantity = (int)numericUpDown1.Value, Arrive = dateTimePicker1.Value, OrderTime = DateTime.Now, User_id = Form1.user
});
db.SaveChanges();
prod.Quantity -= (int)numericUpDown1.Value;
Close();
}
}
private void Button1_Click(object sender, EventArgs e)
{
using (EntityModel db = new EntityModel())
{
var y = db.Users.ToList().Where(x => (x.UserName == textBox1.Text)).ToList();
if (y.Count == 0)
{
User user1 = new User()
{
UserName = textBox1.Text, Password = textBox2.Text, Name = textBox4.Text, Surname = textBox5.Text
};
db.Users.Add(user1);
db.SaveChanges();
Close();
}
else
{
MessageBox.Show("The user already exists");
}
}
}