/// <summary>
/// Selects all records from the Tratamiento table by a foreign key.
/// </summary>
public string SelectAllByIdProductoJson(decimal idProducto)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdProducto", idProducto)
};
return(SqlClientUtility.ExecuteJson(connectionStringName, CommandType.StoredProcedure, "TratamientoSelectAllByIdProducto", parameters));
}
/// <summary>
/// Selects all records from the Transaccion table by a foreign key.
/// </summary>
public string SelectAllByIdDiagnosticoJson(decimal idDiagnostico)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdDiagnostico", idDiagnostico)
};
return(SqlClientUtility.ExecuteJson(connectionStringName, CommandType.StoredProcedure, "TransaccionSelectAllByIdDiagnostico", parameters));
}
/// <summary>
/// Selects a single record from the Encargado table.
/// </summary>
public string SelectJson(decimal numCedula)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@NumCedula", numCedula)
};
return(SqlClientUtility.ExecuteJson(connectionStringName, CommandType.StoredProcedure, "EncargadoSelect", parameters));
}
/// <summary>
/// Selects all records from the Paciente table by a foreign key.
/// </summary>
public string SelectAllByIdEncargadoJson(decimal idEncargado)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdEncargado", idEncargado)
};
return(SqlClientUtility.ExecuteJson(connectionStringName, CommandType.StoredProcedure, "PacienteSelectAllByIdEncargado", parameters));
}
/// <summary>
/// Selects a single record from the Usuario table.
/// </summary>
public string SelectJson(decimal idUsuario)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdUsuario", idUsuario)
};
return(SqlClientUtility.ExecuteJson(connectionStringName, CommandType.StoredProcedure, "UsuarioSelect", parameters));
}
/// <summary>
/// Selects all records from the Diagnostico table by a foreign key.
/// </summary>
public string SelectAllByIdUsuarioCreacionJson(decimal idUsuarioCreacion)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdUsuarioCreacion", idUsuarioCreacion)
};
return(SqlClientUtility.ExecuteJson(connectionStringName, CommandType.StoredProcedure, "DiagnosticoSelectAllByIdUsuarioCreacion", parameters));
}
/// <summary>
/// Selects all records from the Transaccion table.
/// </summary>
public string SelectAllJson()
{
return(SqlClientUtility.ExecuteJson(connectionStringName, CommandType.StoredProcedure, "TransaccionSelectAll"));
}