Esempio n. 1
0
        public override IList <IVtRotefMovement> GetRotefList(int month, int year, VtRotefMovementType movementType)
        {
            //TODO: Get SqlQuery by movementType
            string sqlString = "";

            var dbc = _db.GetSqlStringCommand(sqlString);

            dbc.CommandType = CommandType.Text;

            var startDate = int.Parse($"{year}{month}01");
            var endDate   = int.Parse($"{year}{month}31");

            _db.AddInParameter(dbc, "@StartDate", DbType.Int32, startDate);
            _db.AddInParameter(dbc, "@EbdDate", DbType.Int32, endDate);

            var movementList = new List <IVtRotefMovement>();

            using (var dataReader = _db.ExecuteReader(dbc))
            {
                while (dataReader.Read())
                {
                    movementList.Add(PopulateMovementFromDataRecord(dataReader));
                }
            }

            return(movementList);
        }
Esempio n. 2
0
 public abstract IList <IVtRotefMovement> GetRotefMovementList(string month, string year, VtRotefMovementType movementType);
Esempio n. 3
0
        public override IList <IVtRotefMovement> GetRotefMovementList(string month, string year, VtRotefMovementType movementType)
        {
            var sqlQueryName = "";

            switch (movementType)
            {
            case VtRotefMovementType.FromAccounts:
                sqlQueryName = "GetRotefMovementsFromAccounts.sql";
                break;

            case VtRotefMovementType.FromCredits:
                sqlQueryName = "GetRotefMovementsFromCredits.sql";
                break;
            }

            var sqlString = ResourceHelper.GetEmbeddedResource(sqlQueryName);

            var dbc = _db.GetSqlStringCommand(sqlString);

            dbc.CommandType = CommandType.Text;

            var startDate = int.Parse($"{year}{month}01");
            var endDate   = int.Parse($"{year}{month}31");

            _db.AddInParameter(dbc, "@StartDate", DbType.Int32, startDate);
            _db.AddInParameter(dbc, "@EndDate", DbType.Int32, endDate);

            var movementList = new List <IVtRotefMovement>();

            using (var dataReader = _db.ExecuteReader(dbc))
            {
                while (dataReader.Read())
                {
                    movementList.Add(PopulateMovementFromDataRecord(dataReader));
                }

                dataReader.Close();
            }



            return(movementList);
        }
Esempio n. 4
0
 public abstract IList <IVtRotefMovement> GetRotefList(int month, int year, VtRotefMovementType movementType);