/// <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);
}
