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