public List <creditCardDAL> getCards()
{
DataBase db = new DataBase();
creditCardDAL cardItem;
List <creditCardDAL> cardsList = new List <creditCardDAL>();
DataTable dt = new DataTable();
string sql = "select id,Number,month,year,DigitNo,OwnerId,CustomerId from CreditCardsTable where CustomerId = " + this.customerId;
dt = db.ExecuteReader(sql);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
cardsList.Add(cardItem = new creditCardDAL()
{
id = dt.Rows[i]["id"].ToString(),
number = GlobFuncs.decription(dt.Rows[i]["Number"].ToString(), ConfigurationManager.AppSettings["encriptionKey"]),
month = dt.Rows[i]["month"].ToString(),
year = dt.Rows[i]["year"].ToString(),
digitNo = dt.Rows[i]["DigitNo"].ToString(),
ownerId = dt.Rows[i]["OwnerId"].ToString(),
});
}
return(cardsList);
}
return(cardsList);
}
public void getCardDetails()
{
string sql = "select * from CreditCardsTable where id = '" + this.id + "'";
DataBase dataBase = new DataBase();
DataTable dataTable = dataBase.ExecuteReader(sql);
if (dataTable.Rows.Count == 0)
{
this.id = "-1";
return;
}
else
{
DataRow row = dataTable.Rows[0];
this.id = row["id"].ToString();
this.number = GlobFuncs.decription(row["number"].ToString(), ConfigurationManager.AppSettings["encriptionKey"]);
this.month = row["month"].ToString();
this.year = row["year"].ToString();
this.digitNo = row["digitNo"].ToString();
this.ownerId = row["ownerId"].ToString();
return;
}
}
