public List <CraneHire> GetAllCraneHire()
{
List <CraneHire> craneHires = new List <CraneHire>();
SqlCommand spGetCraneHires = new SqlCommand("GetCraneHires", conn);
spGetCraneHires.CommandType = System.Data.CommandType.StoredProcedure;
try
{
conn.Open();
SqlDataAdapter sDa = new SqlDataAdapter(spGetCraneHires);
DataTable dtCranes = new DataTable();
sDa.Fill(dtCranes);
foreach (DataRow r in dtCranes.Rows)
{
CraneHire e = new CraneHire((int)r["ID"], r["CraneHire"].ToString());
craneHires.Add(e);
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return(craneHires);
}
//private void dgCraneHire_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
//{
// int id = Convert.ToInt32(dgCraneHire.Rows[e.RowIndex].Cells[0].Value.ToString());
// tbCrane.Text = dgCraneHire.Rows[e.RowIndex].Cells[1].Value.ToString();
// selectedCrane = new CraneHire(id, tbCrane.Text);
//}
private void Delete_Click(object sender, EventArgs e)
{
selectedCrane.Delete();
bindingSource1.DataSource = GetCraneHires();
selectedCrane = null;
tbCrane.Text = "";
}
private void SaveCraneHire_Click(object sender, EventArgs e)
{
if (tbCrane.Text != "")
{
if (selectedCrane != null)
{
selectedCrane.CraneName = tbCrane.Text;
selectedCrane.Save();
bindingSource1.DataSource = GetCraneHires();
}
else
{
CraneHire newCraneHire = new CraneHire();
newCraneHire.CraneName = tbCrane.Text;
if (!newCraneHire.Save())
{
MessageBox.Show("Error Saving Crane Hire", "ERROR", MessageBoxButtons.OK);
}
else
{
bindingSource1.DataSource = GetCraneHires();
}
}
}
else
{
MessageBox.Show("You must enter an Crane Hire", "ERROR", MessageBoxButtons.OK);
}
}
private void dgCraneHire_RowHeaderMouseClick_1(object sender, DataGridViewCellMouseEventArgs e)
{
int id = Convert.ToInt32(dgCraneHire.Rows[e.RowIndex].Cells[0].Value.ToString());
tbCrane.Text = dgCraneHire.Rows[e.RowIndex].Cells[1].Value.ToString();
selectedCrane = new CraneHire(id, tbCrane.Text);
}
