private void uxButtonInsertProduction_Click(object sender, EventArgs e) { repo = new SqlProductionRepository("Data Source=mssql.cs.ksu.edu;" + "Initial Catalog=phyo;" + "User id=username;" + "Password=password;"); if (uxButtonInsertProduction.Text == "Insert") { var name = uxProductionName.Text; var location = uxProductionLocation.Text; try { var createdPH = repo.AddProductionHouse(name, location); MessageBox.Show("Production house succesfully added."); } catch (Exception exception) { MessageBox.Show("Sorry, the production company already exists."); } dataGridView1.DataSource = null; dataGridView1.DataSource = repo.RetrieveProduction2(); } else { var name = uxProductionName.Text; var location = uxProductionLocation.Text; //Should be modify stored procedure var createdPH = repo.UpdateProduction(name, location, ProductionId); dataGridView1.DataSource = null; dataGridView1.DataSource = repo.RetrieveProduction2(); } }
private void uxViewButton_Click(object sender, EventArgs e) { repo = new SqlProductionRepository("Data Source=mssql.cs.ksu.edu;" + "Initial Catalog=phyo;" + "User id=username;" + "Password=password;"); dataGridView1.DataSource = null; dataGridView1.Rows.Clear(); dataGridView1.DataSource = repo.RetrieveProduction2(); dataGridView1.Refresh(); }
private void uxDeleteProduction_Click(object sender, EventArgs e) { repo = new SqlProductionRepository("Data Source=mssql.cs.ksu.edu;" + "Initial Catalog=phyo;" + "User id=username;" + "Password=password;"); var id = repo.GetProductionHouse(uxProductionName.Text); var createdPH = repo.DeleteProduction(uxProductionName.Text, uxProductionLocation.Text, id.ProductionId); MessageBox.Show("Production sucessfully deleted."); dataGridView1.DataSource = null; dataGridView1.DataSource = repo.RetrieveProduction2(); }