private void BtnSelecionar_Click(object sender, EventArgs e) { MedicoHorario = DgvMedicoHorario.CurrentRow?.DataBoundItem as MedicoHorario; if (MedicoHorario != null) { DialogResult = DialogResult.OK; Close(); } }
public void Gravar(MedicoHorario medicohorario) { if (medicohorario.Id == 0) { Connection.Execute("insert into medicohorario(atende, datafinal, datainicial, horainicial, horafinal, medicoid, observacao) values (@atende, @datafinal, @datainicial, @horainicial, @horafinal, @medicoid, @observacao)", new { atende = medicohorario.atende, datafinal = medicohorario.datafinal, datainicial = medicohorario.datainicial, horainicial = medicohorario.horainicial, horafinal = medicohorario.horafinal, medicoid = medicohorario.MedicoId, observacao = medicohorario.Observacao }); medicohorario.Id = Convert.ToInt32(Connection.ExecuteScalar("select last_insert_id()")); } else { Connection.Execute("update medicohorario set atende = @atende, datafinal = @datafinal, datainicial = @dataincial, horainicial = @horainicial, horafinal = @horafinal, medicoid = @medicoid, observacao = @observacao where id = @id", new { atende = medicohorario.atende, datafinal = medicohorario.datafinal, datainicial = medicohorario.datainicial, horainicial = medicohorario.horainicial, horafinal = medicohorario.horafinal, medicoid = medicohorario.MedicoId, observacao = medicohorario.Observacao, id = medicohorario.Id }); } }
public void Gravar(MedicoHorario medicoHorario) { if (medicoHorario.Id == 0) { Connection.Execute("insert into medicoHorario(nome) values (@nome)", medicoHorario); medicoHorario.Id = Convert.ToInt32(Connection.ExecuteScalar("select last_insert_id()")); } else { Connection.Execute("update medicoHorario set nome = @nome where id = @id", medicoHorario); } }
private void BtnExcluir_Click(object sender, EventArgs e) { try { MedicoHorario mh = new MedicoHorario(); mh.Id = Convert.ToInt32(Id_medho.Text); MySqlMedicoHorarioRepository.Excluir(mh); MessageBox.Show("Excluido com sucesso"); } catch (Exception ex) { MessageBox.Show("Erro ao excluir o médico horario"); } }
private void BtnGravar_Click(object sender, EventArgs e) { int id; TimeSpan hora; MedicoHorario medho = new MedicoHorario(); int.TryParse(Id_medho.Text, out id); if (Chatende.Checked) { medho.atende = true; } else { medho.atende = false; } medho.datafinal = DtaFinal.Value; medho.datainicial = DtaInicial.Value; hora = HraInicial.Value.TimeOfDay; if (hora.Minutes < 30) { hora = new TimeSpan(hora.Hours, 30, 00); } else { hora = new TimeSpan(hora.Hours + 1, 00, 00); } medho.horainicial = hora; hora = HraFinal.Value.TimeOfDay; if (hora.Minutes < 30) { hora = new TimeSpan(hora.Hours, 30, 00); } else { hora = new TimeSpan(hora.Hours + 1, 00, 00); } medho.horafinal = hora; medho.Medico = CbbMedico.SelectedItem as Medico; medho.Observacao = Observacao.Text; MySqlMedicoHorarioRepository.Gravar(medho); }
public void Excluir(MedicoHorario medicoHorario) { Connection.Execute("delete from medicohorario where id = @id", medicoHorario); }