public ClientCreditCard GetClientCreditCardNumber(string creditCardNumber, string Attribute1, string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbCommand = db.GetStoredProcCommand(Resources.GetClientCreditCardNumberResources.SP_GetClientCreditCardNumber);
db.AddInParameter(dbCommand, Resources.GetClientCreditCardNumberResources.PARAM_QUERY1, DbType.String, creditCardNumber);
db.AddInParameter(dbCommand, Resources.GetClientCreditCardNumberResources.PARAM_QUERY2, DbType.String, Attribute1);
ClientCreditCard creditCard = new ClientCreditCard();
try
{
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
int _creditCard = dr.GetOrdinal(Resources.GetClientCreditCardNumberResources.PARAM_CREDIT_CARD_NUMBER);
int _client = dr.GetOrdinal(Resources.GetClientCreditCardNumberResources.PARAM_CLIENT);
int _type = dr.GetOrdinal(Resources.GetClientCreditCardNumberResources.PARAM_TYPE);
if (dr.Read())
{
creditCard.CreditCardNumber = dr.GetString(_creditCard);
creditCard.Client = dr.GetString(_client);
creditCard.Type = dr.GetString(_type);
}
}
}
catch { }
return(creditCard);
}
public static ClientCreditCard GetClientCreditCardNumber(string CreditCardNumber, string Attribute1)
{
ClientCreditCard creditCardNumber = new ClientCreditCard();
GetClientCreditCardNumberDAL objGetCreditCardNumber = new GetClientCreditCardNumberDAL();
try
{
try
{
creditCardNumber = objGetCreditCardNumber.GetClientCreditCardNumber(CreditCardNumber, Attribute1, CommonENT.MYCTSDB_CONNECTION);
}
catch (Exception ex)
{
new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos);
creditCardNumber = objGetCreditCardNumber.GetClientCreditCardNumber(CreditCardNumber, Attribute1, CommonENT.MYCTSDBBACKUP_CONNECTION);
}
}
catch
{ }
return(creditCardNumber);
}
