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