public void CargarAlergia(Alergia nuevo) { SqlConnection cn = new SqlConnection(); SqlCommand cm = new SqlCommand(); try { cn.ConnectionString = "Data Source=LOCAL\\SQLEXPRESS;Initial Catalog=CLINICA_TOLOZA;Integrated Security=True"; cm.CommandType = System.Data.CommandType.StoredProcedure; cm.Connection = cn; cm.CommandText = "SP_CARGAR_ALERGIA"; cm.Parameters.Clear(); cm.Parameters.AddWithValue("@NOMBRE", nuevo.Nombre1); cn.Open(); cm.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { cn.Close(); cn.Dispose(); cm.Dispose(); } }
public IList <Alergia> TraerAlergias() { SqlConnection cn = new SqlConnection(); SqlCommand cm = new SqlCommand(); SqlDataReader lector; IList <Alergia> Lista = new List <Alergia>(); try { cn.ConnectionString = "Data Source=LOCAL\\SQLEXPRESS;Initial Catalog=CLINICA_TOLOZA;Integrated Security=True"; cm.CommandType = System.Data.CommandType.Text; cm.CommandText = "SELECT ID_ALERGIA,NOMBRE FROM ALERGIA"; cm.Connection = cn; cn.Open(); lector = cm.ExecuteReader(); while (lector.Read()) { Alergia aux = new Alergia(); aux.ID_Alergia1 = lector.GetInt32(0); aux.Nombre1 = lector.GetString(1); Lista.Add(aux); } return(Lista); } catch (Exception ex) { throw ex; } finally { cn.Close(); cn.Dispose(); cm.Dispose(); } }
public List <Alergia> TraerAlergias_P(Int32 id_Paciente) { List <Alergia> Lista = new List <Alergia>(); SqlConnection cn = new SqlConnection(); SqlCommand cm = new SqlCommand(); SqlDataReader lector; try { cn.ConnectionString = "Data Source=LOCAL\\SQLEXPRESS;Initial Catalog=CLINICA_TOLOZA;Integrated Security=True"; cm.CommandType = System.Data.CommandType.Text; cm.CommandText = "SELECT P.ID_ALERGIA,A.NOMBRE,P.ELIMINADO FROM ALERGIA AS A INNER JOIN ALERGIA_X_PACIENTE AS P ON A.ID_ALERGIA=P.ID_ALERGIA WHERE ELIMINADO=0 AND P.ID_PACIENTE= " + id_Paciente; cm.Connection = cn; cn.Open(); lector = cm.ExecuteReader(); while (lector.Read()) { Alergia aux = new Alergia(); aux.ID_Alergia1 = lector.GetInt32(0); aux.Nombre1 = lector.GetString(1); aux.Eliminado = lector.GetBoolean(2); Lista.Add(aux); } return(Lista); } catch (Exception ex) { throw ex; } }