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); }