/// <summary> /// Obter cartão de crédito por número /// </summary> /// <param name="creditCard"></param> /// <returns></returns> public Boolean GetCreditCard(String cardNumber) { using (var bd = new BDEngine()) { sql.Append(@" SELECT card_number FROM CreditCard c(nolock) WHERE c.card_number = '{0}' "); object CreditCard = bd.ExecuteScalar(string.Format(sql.ToString(), cardNumber)); if (CreditCard != null) { return(true); } } return(false); }
/// <summary> /// Retorna um produto por id /// </summary> /// <param name="productId"></param> /// <returns></returns> public bool ProdutoPorId(String productId) { using (var bd = new BDEngine()) { sql.Clear(); sql.Append(@" SELECT product_id FROM Product WHERE product_id = '{0}' "); var obj = bd.ExecuteScalar(string.Format(sql.ToString(), productId)); if (obj != null) { return(true); } } return(false); }