public ActionResult InsertCreditCard(int cbxTypeCard, string number_card, string name_card, string date_expiration, int crv)
{
CreditCard_Entity credit_card = new CreditCard_Entity();
credit_card.number_card = number_card;
credit_card.name_card = name_card;
credit_card.date_expiration = date_expiration;
credit_card.crv = crv;
credit_card.typeCard_Entity.id_type_card = cbxTypeCard;
String script = "";
if (creditCard_Logic.addCreditCard(credit_card))
{
script = "<script languaje='javascript'>" +
"alert('Tarjeta agregada correctamente'); " +
"window.location.href = '/ClientBusiness/AddClientBusiness'; " +
"</script>";
}
else
{
script = "<script languaje='javascript'>" +
"alert('No se pudo agregar')" +
"window.location.href = '/ClientBusiness/AddClientBusiness'; " +
"</script>";
}
return(Content(script));
}
public List <CreditCard_Entity> listCreditCard()
{
List <CreditCard_Entity> list = new List <CreditCard_Entity>();
try
{
sqlConnection.Open();
sqlCommand = new SqlCommand("list_credit_card", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
CreditCard_Entity credit_card = new CreditCard_Entity();
credit_card.id_credit_card = Convert.ToInt32(sqlDataReader["Identificador"]);
credit_card.number_card = sqlDataReader["Numero Tarjeta"].ToString();
credit_card.name_card = sqlDataReader["Nombre Tarjeta"].ToString();
credit_card.date_expiration = sqlDataReader["Fecha Expiracion"].ToString();
list.Add(credit_card);
}
}
catch (Exception e)
{
throw;
}
return(list);
}
public bool addCreditCard(CreditCard_Entity credit_card)
{
bool response = false;
try
{
sqlConnection.Open();
sqlCommand = new SqlCommand("add_credit_card", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
SqlParameter p_idTypeCard = new SqlParameter();
p_idTypeCard.ParameterName = "@idTypeCard";
p_idTypeCard.SqlDbType = SqlDbType.Int;
p_idTypeCard.Value = credit_card.typeCard_Entity.id_type_card;
SqlParameter p_numberCard = new SqlParameter();
p_numberCard.ParameterName = "@numberCard";
p_numberCard.SqlDbType = SqlDbType.VarChar;
p_numberCard.Size = 25;
p_numberCard.Value = credit_card.number_card;
SqlParameter p_nameCard = new SqlParameter();
p_nameCard.ParameterName = "@nameCard";
p_nameCard.SqlDbType = SqlDbType.VarChar;
p_nameCard.Size = 30;
p_nameCard.Value = credit_card.name_card;
SqlParameter p_crv = new SqlParameter();
p_crv.ParameterName = "@crv";
p_crv.SqlDbType = SqlDbType.Int;
p_crv.Value = credit_card.crv;
SqlParameter p_dayExpiration = new SqlParameter();
p_dayExpiration.ParameterName = "@dateExpiration";
p_dayExpiration.SqlDbType = SqlDbType.VarChar;
p_dayExpiration.Size = 20;
p_dayExpiration.Value = credit_card.date_expiration;
sqlCommand.Parameters.Add(p_idTypeCard);
sqlCommand.Parameters.Add(p_numberCard);
sqlCommand.Parameters.Add(p_nameCard);
sqlCommand.Parameters.Add(p_crv);
sqlCommand.Parameters.Add(p_dayExpiration);
sqlCommand.ExecuteNonQuery();
response = true;
}
catch (Exception e)
{
throw;
}
return(response);
}
public bool addCreditCard(CreditCard_Entity credit_card)
{
return(creditCard_Data.addCreditCard(credit_card));
}
