예제 #1
0
        public void InserCardNumber(string CardNumber)
        {
            DataTable dtAdmin = new DataTable();

            // bool LoginStatus = true;
            SqlParameter[] sqlParams = new SqlParameter[]
            {
                new SqlParameter("CardNumber", CardNumber)
            };
            dtAdmin = DataConnectionExcess.ExecuteReader(CommandType.StoredProcedure, "InserCardNumber", con, sqlParams);
        }
예제 #2
0
        internal DataTable GetCardDetails(string CardNumber)
        {
            DataTable dt = new DataTable();

            SqlParameter[] sqlParams = new SqlParameter[]
            {
                new SqlParameter("CardNumber", CardNumber)
            };
            dt = DataConnectionExcess.ExecuteReader(CommandType.StoredProcedure, "GetCardDetails", con, sqlParams);
            return(dt);
        }
예제 #3
0
        public IList <POSProperties> IssuedCards()
        {
            IList <POSProperties> AllIssuedCards;
            DataTable             dtAdmin = new DataTable();

            dtAdmin        = DataConnectionExcess.ExecuteReader(CommandType.StoredProcedure, "GetNewAndIssuedCard", con, null);
            AllIssuedCards = (from DataRow row in dtAdmin.Rows
                              select new POSProperties
            {
                CardNumber = (!dtAdmin.Columns.Contains("CardNumber") || row["CardNumber"] == null || row["CardNumber"] == DBNull.Value ? string.Empty : row["CardNumber"].ToString()),
                IssuedDate = Convert.ToString((!dtAdmin.Columns.Contains("CardNumber") || row["CardNumber"] == null || row["CardNumber"] == DBNull.Value ? string.Empty : row["CardNumber"].ToString()))
            }).ToList();
            return(AllIssuedCards);
        }