public static CardModel GetCurrentCard(string cardId) { var card = new CardModel(); cnn = SqlConnectionData.getConnection(); try { string query = "Select * From Cards Where " + "Cards.ID=" + cardId; //var command = new SqlCommand(query, cnn); var adapter = new SqlDataAdapter(query, cnn); var da = new DataTable(); adapter.Fill(da); if (da.Rows.Count > 0) { card.ID = da.Rows[0]["ID"].ToString(); card.pin = da.Rows[0]["Pin"].ToString(); card.status = da.Rows[0]["Status"].ToString(); card.AccID = da.Rows[0]["AccID"].ToString(); card.CreateDate = da.Rows[0]["CreateDate"].ToString(); card.ExpiredDate = da.Rows[0]["ExpiredDate"].ToString(); } } catch (Exception e) { return null; } finally { SqlConnectionData.CloseConnection(); } return card; }
public static CardModel ValidateCard(string ID) { CardModel cardModel=null; try{ cardModel= new CardModel(); cnn = SqlConnectionData.getConnection(); string queryCommand = "Select * from Cards where Cards.ID=" + ID; SqlDataAdapter adapter = new SqlDataAdapter(queryCommand, cnn); DataTable da = new DataTable(); adapter.Fill(da); if (da.Rows.Count > 0) { cardModel.ID = da.Rows[0]["ID"].ToString(); cardModel.pin = da.Rows[0]["pin"].ToString(); cardModel.status = da.Rows[0]["Status"].ToString(); cardModel.AccID = da.Rows[0]["AccID"].ToString(); cardModel.CreateDate = da.Rows[0]["CreateDate"].ToString(); cardModel.ExpiredDate = da.Rows[0]["ExpiredDate"].ToString(); } }catch { cnn.Close(); } finally { cnn.Close(); } return cardModel; }
public static int Authentication(CardModel card, string pass, int count) { if (card.pin != pass) { if (count < 3) { return 2; } else { AuthenticateUserbll.UpdateStatus(card.ID); return 1; } } return 0; }
/// <summary> /// /// </summary> /// <param name="money"></param> /// <returns> /// 0: Can Withdraw and navigate to WaitForMoneyView. /// 1: Can not withdraw and navigate to Thankyou. /// </returns> public static int Withdraw(float money, CardModel Card, AccountModel Acc) { if (CanWithdraw(money, Acc.Balance, Acc.OverDraft)) { UpdateAllData(Card.ID, money); return 0; } return 1; }
public static void UpdateCurrentCard(string cardID) { Card = CardDAO.GetCurrentCard(cardID); }