private void btnSave_Click(object sender, EventArgs e)
{
ValidarDatos();
bool valido;
Business.MedicinaGeneral Med = new Business.MedicinaGeneral();
valido = ValidarDatos();
if (valido == true)
{
Entities.MedicinaGeneral M = new Entities.MedicinaGeneral(IdConsultaGrl != 0);
M.Medico = new Entities.Medico();
M.Paciente = new Entities.Paciente();
M.ID = this.IdConsultaGrl;
M.Medico.ID = Framework.Utils.IsNull(cmbMedico.SelectedValue, 0);
M.Paciente.ID = Framework.Utils.IsNull(cmbPaciente.SelectedValue, 0);
M.MotivoConsulta = txtMotivo.Text;
M.ProblemasActuales = txtProblemas.Text;
M.Medicamentos = txtMed.Text;
M.Observaciones = txtObs.Text;
M.EnfermedadesCronicas = txtEC.Text;
M.EnfermedadesImportantes = txtEI.Text;
M.Diagnstico = txtDiag.Text;
Med.Save(M);
this.Close();
}
}
public override int Insert(Entity entity, DataTransaction tran)
{
DataEntities.SpMedicinaGeneralIns sp = new DataEntities.SpMedicinaGeneralIns();
Entities.MedicinaGeneral item = entity as Entities.MedicinaGeneral;
sp.IdConsultaMG = item.ID;
sp.IdMedico = item.Medico.ID;
sp.IdPaciente = item.Paciente.ID;
sp.MotivoConsulta = item.MotivoConsulta;
sp.ProblemasActuales = item.ProblemasActuales;
sp.Medicamentos = item.Medicamentos;
sp.Observaciones = item.Observaciones;
sp.EnfermedadesCronicas = item.EnfermedadesCronicas;
sp.EnfermedadesImportantes = item.EnfermedadesImportantes;
sp.Diagnstico = item.Diagnstico;
int rowsAffected = 0;
if (tran != null)
{
rowsAffected = sp.ExecuteNonQuery(tran);
}
else
{
rowsAffected = sp.ExecuteNonQuery(this.ConnectionString);
} return(rowsAffected);
}
public override int Delete(Entity entity, DataTransaction tran)
{
DataEntities.SpMedicinaGeneralDel sp = new DataEntities.SpMedicinaGeneralDel();
Entities.MedicinaGeneral item = entity as Entities.MedicinaGeneral;
sp.IdConsultaMG = item.ID;
int rowsAffected = 0;
if (tran != null)
{
rowsAffected = sp.ExecuteNonQuery(tran);
}
else
{
rowsAffected = sp.ExecuteNonQuery(this.ConnectionString);
} return(rowsAffected);
}
