public int ingresarSolicitudMedica(SolicitudMedica solMed, int residente, int dtSM)
{
configuraConexion();
conectar.CadenaSQL = String.Format("INSERT INTO {0}(id_solic_med, id_det_solic_med, id_fic_residente) VALUES({1},{2},{3})",
conectar.NombreTabla, Seq_solic_med, residente, dtSM);
conectar.EsSelect = false;
return(conectar.conecta());
}
public int actualizarSolicitudMedica(SolicitudMedica slMed)
{
this.configuraConexion();
this.conectar.CadenaSQL = String.Format("UPDATE SOLIC_MED SET ID_DET_SOLIC_MED={0},"
+ " ID_FIC_RESIDENTE ={1}"
+ " WHERE id_solic_med ={2}"
, slMed.Id_det_solic_med, slMed.Id_fic_residente, slMed.Id_solic_med);
this.conectar.EsSelect = false;
return(this.conectar.conecta());
}
public SolicitudMedica consultarPorId(int id)
{
configuraConexion();
SolicitudMedica auxSMed = new SolicitudMedica();
conectar.CadenaSQL = String.Format("SELECT * FROM {0} WHERE id_solic_med = {1} order by id_solic_med",
conectar.NombreTabla, id);
conectar.EsSelect = true;
conectar.conecta();
if (conectar.conecta() != 0)
{
System.Data.DataTable dt = new System.Data.DataTable();
if (conectar.DbDataSet.Tables[0].Rows.Count >= 1)
{
dt = conectar.DbDataSet.Tables[0];
try
{
auxSMed.Id_solic_med = int.Parse(dt.Rows[0]["id_solic_med"].ToString());
auxSMed.Id_det_solic_med = int.Parse(dt.Rows[0]["id_det_solic_med"].ToString());
auxSMed.Id_fic_residente = int.Parse(dt.Rows[0]["id_fic_residente"].ToString());
}
catch (Exception)
{
auxSMed.Id_solic_med = 0;
auxSMed.Id_det_solic_med = 0;
auxSMed.Id_fic_residente = 0;
}
}
}
else
{
auxSMed = null;
}
return(auxSMed);
}
