public RevenueApprovalStatus?MoveWorkflowAll(DateTime month, string propertyCode, RevenueApprovalStatus state, int direction)
        {
            try
            {
                // Stored procedure for bulk update is a lot faster
                var user      = ClaimProvider.GetFriendlyName(_context);
                var nextState = direction >= 0 ? NextState(state) : PrevState(state);

                DateTime startDate = new DateTime(month.Year, month.Month, 1);
                DateTime endDate   = new DateTime(month.Year, month.Month, DateTime.DaysInMonth(month.Year, month.Month));

                SqlParameter[] sqlParams = new SqlParameter[5];
                sqlParams[0]       = new SqlParameter("@StartDate", SqlDbType.DateTime);
                sqlParams[0].Value = startDate;
                sqlParams[1]       = new SqlParameter("@EndDate", SqlDbType.DateTime);
                sqlParams[1].Value = endDate;
                sqlParams[2]       = new SqlParameter("@PropertyCode", SqlDbType.NVarChar);
                sqlParams[2].Value = propertyCode;
                sqlParams[3]       = new SqlParameter("@State", SqlDbType.Int);
                sqlParams[3].Value = direction >= 0 ? state : nextState;
                sqlParams[4]       = new SqlParameter("@User", SqlDbType.NVarChar);
                sqlParams[4].Value = user;
                var result = _context.Database.SqlQuery <SqlResult>("UpdateAllReservationWorkflowStates @StartDate, @EndDate, @PropertyCode, @State, @User", sqlParams).FirstOrDefault();

                return(result.Count > 0 ? nextState : null);
            }
            catch
            {
                throw;
            }
        }
        private void RetrackWorkflowSignature(Reservation reservation, RevenueApprovalStatus state)
        {
            var userName = ClaimProvider.GetFriendlyName(_context);

            switch (state)
            {
            case RevenueApprovalStatus.Reviewed:
                reservation.ReviewedBy   = null;
                reservation.ReviewedDate = null;
                break;

            case RevenueApprovalStatus.Approved:
                reservation.ApprovedBy   = null;
                reservation.ApprovedDate = null;
                break;
            }
        }
        private void SetWorkflowSignature(Reservation reservation, RevenueApprovalStatus state)
        {
            var userName = ClaimProvider.GetFriendlyName(_context);

            switch (state)
            {
            case RevenueApprovalStatus.Reviewed:
                reservation.ReviewedBy   = userName;
                reservation.ReviewedDate = DateTime.Now.ToUniversalTime();
                break;

            case RevenueApprovalStatus.Approved:
                reservation.ApprovedBy   = userName;
                reservation.ApprovedDate = DateTime.Now.ToUniversalTime();
                break;
            }
        }
示例#4
0
        private void RetrackWorkflowSignature(Expense entity, RevenueApprovalStatus state)
        {
            var userName = ClaimProvider.GetFriendlyName(_context);

            switch (state)
            {
            case RevenueApprovalStatus.Reviewed:
                entity.ReviewedBy   = null;
                entity.ReviewedDate = null;
                break;

            case RevenueApprovalStatus.Approved:
                entity.ApprovedBy   = null;
                entity.ApprovedDate = null;
                break;
            }
        }
示例#5
0
        private void SetWorkflowSignature(ref OtherRevenue entity, RevenueApprovalStatus state)
        {
            var userName = ClaimProvider.GetFriendlyName(_context);

            switch (state)
            {
            case RevenueApprovalStatus.Reviewed:
                entity.ReviewedBy   = userName;
                entity.ReviewedDate = DateTime.Now.ToUniversalTime();
                break;

            case RevenueApprovalStatus.Approved:
                entity.ApprovedBy   = userName;
                entity.ApprovedDate = DateTime.Now.ToUniversalTime();
                break;
            }
        }