public static void AdicionarExameParaDataBase(DataHelper datahelper, ClasseExames exames) { DataRow datarow = datahelper.TableExames.NewRow(); datarow[DataHelper.EXAME_NOME] = exames.Nome; datarow[DataHelper.EXAME_EXAME_MEDIA] = exames.MediaExame; datarow[DataHelper.EXAME_CLIENTE_ID] = exames.ClienteId; datahelper.TableExames.Rows.Add(datarow); datahelper.Guardar(); }
// Botao para gravar os dados acerca do exame private void buttonGravar_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("Tem a certeza que pretende adicionar um novo Cliente?", "Alerta:", MessageBoxButtons.OKCancel); if (result == DialogResult.OK) { ClasseExames exameParaAdicionar = new ClasseExames(textBoxTipoExame.Text, ClienteParaEditar.Id, textBoxMedia.Text); ClasseExames.AdicionarExameParaDataBase(datahelper, exameParaAdicionar); this.Close(); } }
public static List <ClasseExames> getExames(DataHelper datahelper, long id) { List <ClasseExames> exames = new List <ClasseExames>(); DataView dataView = datahelper.DataSet.Tables[DataHelper.DATATABLE_EXAMES].DefaultView; dataView.RowFilter = string.Format("{0} = '{1}'", DataHelper.EXAME_CLIENTE_ID, id); foreach (DataRowView drv in dataView) { DataRow row = drv.Row; string nome = (string)row[DataHelper.EXAME_NOME]; long clienteId = long.Parse((string)row[DataHelper.EXAME_CLIENTE_ID]); string exameMedia = (string)row[DataHelper.EXAME_EXAME_MEDIA]; ClasseExames exame = new ClasseExames(nome, clienteId, exameMedia); exames.Add(exame); } return(exames); }
// Com este botao é possivel remover um exame selecionado na dataGridViewExames private void buttonApagarExame_Click(object sender, EventArgs e) { int indexParaRemover = dataGridViewExames.CurrentCell.RowIndex; if (indexParaRemover >= 0) { DialogResult result = MessageBox.Show("Tem a certeza que pretende remover o Exame seleccionado?", "Alerta:", MessageBoxButtons.OKCancel); if (result == DialogResult.OK) { long id = long.Parse((string)dataGridViewExames.CurrentRow.Cells["Cliente_ID"].Value); ClasseExames.removerDaBaseDados(datahelper, id); } } else { MessageBox.Show("Alerta: Não selecionou nenhum exame. Tente novamente!"); } }