public List <Erector> GetAllErectors()
{
List <Erector> erectors = new List <Erector>();
SqlCommand spGetErectors = new SqlCommand("GetErectors", conn);
spGetErectors.CommandType = System.Data.CommandType.StoredProcedure;
try
{
conn.Open();
SqlDataAdapter sDa = new SqlDataAdapter(spGetErectors);
DataTable dtErectors = new DataTable();
sDa.Fill(dtErectors);
foreach (DataRow r in dtErectors.Rows)
{
Erector e = new Erector((int)r["ID"], r["ErectorName"].ToString());
erectors.Add(e);
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return(erectors);
}
private void Delete_Click(object sender, EventArgs e)
{
selectedErector.Delete();
bindingSource1.DataSource = GetErectors();
selectedErector = null;
tbErectorName.Text = "";
}
private void SaveErector_Click(object sender, EventArgs e)
{
if (tbErectorName.Text != "")
{
if (selectedErector != null)
{
selectedErector.ErectorName = tbErectorName.Text;
selectedErector.Save();
bindingSource1.DataSource = GetErectors();
}
else
{
Erector newErector = new Erector();
newErector.ErectorName = tbErectorName.Text;
if (!newErector.Save())
{
MessageBox.Show("Error Saving Erector", "ERROR", MessageBoxButtons.OK);
}
else
{
bindingSource1.DataSource = GetErectors();
}
}
}
else
{
MessageBox.Show("You must enter an Erector Name", "ERROR", MessageBoxButtons.OK);
}
}
private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
int id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
tbErectorName.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
selectedErector = new Erector(id, tbErectorName.Text);
}
