private void Button3_Click(object sender, EventArgs e) { using (DBEntities2 db = new DBEntities2()) { karlitos_products edit = new karlitos_products(); int id; if (int.TryParse(textBox1.Text, out int x)) { id = int.Parse(textBox1.Text); if (db.karlitos_products.Where(a => a.ProductId == id).Count() == 1) { //Console.WriteLine(db.karlitos_products.Where(a => a.ProductId == id).Count()); edit = db.karlitos_products.Where(a => a.ProductId == id).First(); textBox5.Text = edit.ProductName; textBox2.Text = edit.SerialNumber; textBox3.Text = edit.Color; textBox4.Text = edit.Price.ToString(); comboBox1.Text = ""; comboBox1.SelectedText = edit.Type; numericUpDown1.Value = decimal.Parse(edit.QTY.ToString()); } else { id = int.Parse(textBox1.Text); MessageBox.Show("Product with id = " + id + " was not found"); } } else { MessageBox.Show("Id must be a number"); } } }
private void Button1_Click(object sender, EventArgs e) { using (DBEntities2 db = new DBEntities2()) { if (textBox1.Text != "") { karlitos_products edit = new karlitos_products(); int id = int.Parse(textBox1.Text); edit = db.karlitos_products.Where(a => a.ProductId == id).First(); if (double.TryParse(textBox4.Text, out double x) == false) { MessageBox.Show("Invalid price format"); } else { edit.ProductName = textBox5.Text; edit.SerialNumber = textBox2.Text; edit.Color = textBox3.Text; edit.Price = double.Parse(textBox4.Text); edit.Type = comboBox1.Text; edit.QTY = long.Parse(numericUpDown1.Value.ToString()); db.SaveChanges(); this.Close(); } } else { MessageBox.Show("First select id to edit"); } } }
private void Button4_Click(object sender, EventArgs e) { using (DBEntities2 db = new DBEntities2()) { if (textBox1.Text != "") { karlitos_products del = new karlitos_products(); int id = int.Parse(textBox1.Text); del = db.karlitos_products.Where(a => a.ProductId == id).First(); db.karlitos_products.Remove(del); db.SaveChanges(); MessageBox.Show("Product deleted"); this.Close(); } else { MessageBox.Show("First select id to delete"); } } }
private void Button1_Click(object sender, EventArgs e) { using (DBEntities2 db = new DBEntities2()) { karlitos_products addnew = new karlitos_products(); if (textBox1.Text != "" || textBox2.Text != "" || comboBox1.Text != "") { addnew.ProductName = textBox1.Text; addnew.SerialNumber = textBox2.Text; addnew.Color = textBox3.Text; if (float.TryParse(textBox4.Text, out float n)) { addnew.Price = float.Parse(textBox4.Text); } else { MessageBox.Show("Invalid price format." + "\nPrice was set to 0."); addnew.Price = 0; } addnew.Type = comboBox1.Text; addnew.QTY = long.Parse(numericUpDown1.Value.ToString()); db.karlitos_products.Add(addnew); db.SaveChanges(); MessageBox.Show("Product added successfully"); textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox4.Clear(); comboBox1.Text = ""; numericUpDown1.Value = 0; } else { MessageBox.Show("Product was not added please fix any errors and try again"); } } }