public void Gravar(MedicoConvenio medicoConvenio)
{
if (medicoConvenio.Convenio.Id == 0 || medicoConvenio.Medico.Id == 0)
{
Connection.Execute("insert into medicoconvenio(nome) values (@nome)", medicoConvenio);
medicoConvenio.Medico.Id = Convert.ToInt32(Connection.ExecuteScalar("select last_insert_id()"));
}
else
{
Connection.Execute("update medicoconvenio set nome = @nome where id = @id", medicoConvenio);
}
}
public void Gravar(MedicoConvenio medicoConvenio)
{
if (medicoConvenio.Convenio.Id != 0 || medicoConvenio.Medico.Id != 0)
{
Connection.Execute("insert into medicoconvenio(convenioid,medicoid) values (@convenioid, @medicoid)", new { convenioid = medicoConvenio.ConvenioId, medicoid = medicoConvenio.MedicoId });
medicoConvenio.Medico.Id = Convert.ToInt32(Connection.ExecuteScalar("select last_insert_id()"));
}
else
{
Connection.Execute("update medicoconvenio set convenioid = @convenioid where medicoid = @medicoid", new { convenioid = medicoConvenio.ConvenioId, medicoid = medicoConvenio.MedicoId });
}
}
private void BtnGravar_Click(object sender, EventArgs e)
{
try
{
if (listacon.Count > 0)
{
int id;
int.TryParse(ID_medico.Text, out id);
Medico medico = new Medico();
medico.Crm = CRM_medico.Text;
medico.Fonecel1 = Fone1_medico.Text;
medico.Fonecel2 = Fone2_medico.Text;
medico.Id = id;
medico.Nome = Nome_medico.Text;///verificar como passar o id 0 ou id do medico a alterar
medico.Id = MySqlMedicoRepository.Gravar(medico);
for (int i = 0; i < listacon.Count; i++)
{
MedicoConvenio mc = new MedicoConvenio();
mc.Medico = medico;
mc.Convenio = listacon.ElementAt(i);
MedicoConvenio m = MySqlMedicoConvenioRepository.GetByMedicoConvenio(mc);
if (m == null)
{
MySqlMedicoConvenioRepository.Gravar(mc);
}
}
MessageBox.Show("Gravado com sucesso");
}
else
{
MessageBox.Show("Selecione um convenio");
}
}
catch (Exception ex)
{
MessageBox.Show("Erro ao gravar médico: " + ex.ToString());
}
}
public void Excluir(MedicoConvenio medicoConvenio)
{
Connection.Execute("delete from medicoconvenio where id = @id", medicoConvenio);
}
public MedicoConvenio GetByMedicoConvenio(MedicoConvenio medicoconvenio)
{
return(Connection.Query <MedicoConvenio>("select * from medicoconvenio where medicoid = @medicoid and convenioid = @convenioid", new { medicoid = medicoconvenio.MedicoId, convenioid = medicoconvenio.ConvenioId }).FirstOrDefault());
}
