Ejemplo n.º 1
0
        public void Initialize(int customerID)
        {
            var weeklyVolumes = Exigo.GetCustomerVolumes(new GetCustomerVolumesRequest
            {
                CustomerID = customerID,
                PeriodTypeID = PeriodTypes.Weekly
            });

            this.WeeklyVolumes = weeklyVolumes;
        }
Ejemplo n.º 2
0
        public static bool IsAmbassadorActive(int customerId)
        {
            const int VOLUME_ID__IS_ACTIVE = 14;   // Month-to-date PRV greater than $500


            VolumeCollection volumes = GetCustomerVolumes3(

                new GetCustomerVolumesRequest
            {
                CustomerID   = customerId,
                PeriodTypeID = PeriodTypes.Monthly,
                VolumeIDs    = new[] { VOLUME_ID__IS_ACTIVE }
            }

                );


            return(volumes.Volume14 > 0.0M);
        }
Ejemplo n.º 3
0
        public static bool AmbassadorHas1500PRV(int customerId)
        {
            const int VOLUME_ID = 22;   // PRV greater than $1500


            VolumeCollection volumes = GetCustomerVolumes3(

                new GetCustomerVolumesRequest
            {
                CustomerID   = customerId,
                PeriodTypeID = PeriodTypes.Monthly,
                VolumeIDs    = new[] { VOLUME_ID }
            }

                );


            return(volumes.Volume22 >= 1500.0M);
        }
Ejemplo n.º 4
0
        //This is currently being used for the Dashboard Widget
        //public static VolumeCollection GetCustomerVolumes2(GetCustomerVolumesRequest request)
        //{
        //    // Establish the query
        //    var query = Exigo.OData().PeriodVolumes
        //        .Where(c => c.CustomerID == request.CustomerID)
        //        .Where(c => c.PeriodTypeID == PeriodTypes.Monthly)
        //        .Where(c => c.Period.IsCurrentPeriod);
        //        //.Where(c => c.Period.StartDate <= DateTime.Now);

        //    // Fetch the data
        //    var data = query.Select(c => new PeriodVolume()
        //    {
        //        CustomerID      = c.CustomerID,
        //        PeriodID        = c.PeriodID,
        //        Period          = c.Period,
        //        PeriodTypeID    = c.PeriodTypeID,
        //        Volume1         = c.Volume1,
        //        Volume2         = c.Volume2,
        //        Volume3         = c.Volume3,
        //        Volume9         = c.Volume9,
        //        Volume10        = c.Volume10,
        //        Volume12        = c.Volume12,
        //        Volume13        = c.Volume13,
        //        Volume14        = c.Volume14
        //    }).FirstOrDefault();

        //    return (VolumeCollection)data;
        //}

        //This uses an api call rather then OData
        public static VolumeCollection GetCustomerVolumes3(GetCustomerVolumesRequest request)
        {
            var vc = new VolumeCollection();
            //var api = Exigo.WebService();
            ////Create Request
            //var volumeRequest = new GetVolumesRequest
            //{
            //     CustomerID = request.CustomerID,
            //     PeriodType = request.PeriodTypeID
            //};
            ////Get Response
            //var response = api.GetVolumes(volumeRequest).Volumes.FirstOrDefault();

            //// here api call to SQl Server call

            VolumeResponse response = new VolumeResponse();

            using (var context = Exigo.Sql())
            {
                string sqlQuery = string.Format(@"GetCustomerVolumes3 {0},{1}", request.CustomerID, request.PeriodTypeID);
                response = context.Query <VolumeResponse>(sqlQuery).FirstOrDefault();
            }

            if (response != null)
            {
                vc.CustomerID               = response.CustomerID;
                vc.PayableAsRank.RankID     = response.RankID;
                vc.Period.PeriodDescription = response.PeriodDescription;
                vc.Volume1           = response.Volume1;
                vc.Volume2           = response.Volume2;
                vc.Volume3           = response.Volume3;
                vc.Volume9           = response.Volume9;
                vc.Volume10          = response.Volume10;
                vc.Volume12          = response.Volume12;
                vc.Volume13          = response.Volume13;
                vc.Volume14          = response.Volume14;
                vc.PaidAsRank.RankID = response.PaidRankID;
            }
            ;
            return(vc);
        }
Ejemplo n.º 5
0
        public static VolumeCollection GetCustomerVolumes(GetCustomerVolumesRequest request)
        {
            #region OData
            //var requestedSpecificVolumes = (request.VolumeIDs != null && request.VolumeIDs.Length > 0);

            //    var baseQuery = Exigo.OData().PeriodVolumes;
            //    var query = baseQuery
            //        .Where(c => c.CustomerID == request.CustomerID)
            //        .Where(c => c.PeriodTypeID == request.PeriodTypeID);

            //// Allows for a request for monthly volumes without knowing the exact period id for the month
            //if (request.ReportForMonth.HasValue)
            //{
            //    DateTime reportStart = new DateTime(request.ReportForMonth.Value.Year, request.ReportForMonth.Value.Month, 1);

            //    query = query.Where(c => c.Period.StartDate >= reportStart && c.Period.StartDate <= reportStart.AddDays(1));

            //    // Validation
            //    if (request.PeriodID != null)
            //    {
            //        throw new Exception("PeriodID and ReportForMonth parameters cannot be specified at the same time.");
            //    }
            //    if (request.PeriodTypeID != PeriodTypes.Monthly)
            //    {
            //        throw new Exception("PeriodType must be Monthly when ReportForMonth parameter is specified.");
            //    }
            //}
            //// Determine which period ID to use
            //else if (request.PeriodID != null)
            //{
            //    query = query.Where(c => c.PeriodID == (int)request.PeriodID);
            //}
            //else
            //{
            //    query = query.Where(c => c.Period.IsCurrentPeriod);
            //}

            //PeriodVolume data;

            //if (!requestedSpecificVolumes)
            //{
            //    data = query.Select(c => new Common.Api.ExigoOData.PeriodVolume()
            //    {
            //        CustomerID   = c.CustomerID,
            //        ModifiedDate = c.ModifiedDate,
            //        PaidRankID   = c.PaidRankID,
            //        PaidRank     = c.PaidRank,
            //        RankID       = c.RankID,
            //        Rank         = c.Rank,
            //        PeriodID     = c.PeriodID,
            //        Period       = c.Period,
            //        PeriodTypeID = c.PeriodTypeID
            //    }).FirstOrDefault();
            //}
            //else
            //{
            //    var volumes = new List<string>();
            //    foreach (var id in request.VolumeIDs)
            //    {
            //        volumes.Add("Volume" + id);
            //    }
            //    var select = string.Format("new({0},Period,Rank,PaidRank)", string.Join(",", volumes));
            //    var finalQuery = query;

            //    var url = finalQuery.ToString();
            //    data = Exigo.OData().Execute<Common.Api.ExigoOData.PeriodVolume>(new Uri(url)).FirstOrDefault();
            //}

            //return (VolumeCollection)data;
            #endregion

            #region SQL Procedure Call
            bool IsCurrentPeriod = false;
            if (request.ReportForMonth.HasValue)
            {
                // Validation
                if (request.PeriodID != null)
                {
                    throw new Exception("PeriodID and ReportForMonth parameters cannot be specified at the same time.");
                }
                if (request.PeriodTypeID != PeriodTypes.Monthly)
                {
                    throw new Exception("PeriodType must be Monthly when ReportForMonth parameter is specified.");
                }
            }

            if (!request.ReportForMonth.HasValue && request.PeriodID == null)
            {
                IsCurrentPeriod = true;
            }

            var finalResult = new VolumeCollection();
            using (var Context = Exigo.Sql())
            {
                string sqlProcedure = string.Format(@"GetCustomerPeriodVolumes {0},{1},{2},'{3}',{4}", request.CustomerID, request.PeriodTypeID, request.PeriodID != null ? request.PeriodID : 0, request.ReportForMonth.HasValue ? new DateTime(request.ReportForMonth.Value.Year, request.ReportForMonth.Value.Month, 1).ToString() : new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToString(), IsCurrentPeriod == false ? 0 : 1);
                var    result       = Context.Query <VolumeCollection>(sqlProcedure).ToList();
                //Selecting Final result
                if (result == null)
                {
                    finalResult.HighestAchievedRankThisPeriod.RankDescription = string.Empty;
                    return(finalResult);
                }

                finalResult = result.Select(s => new VolumeCollection()
                {
                    Rank = s.Rank,
                    HighestAchievedRankThisPeriod = s.Rank,
                    PaidAsRank          = s.PaidAsRank1,
                    PayableAsRank       = s.PaidAsRank1,
                    Period              = s.Period1,
                    CustomerID          = s.CustomerID,
                    RankID              = s.RankID,
                    RankDescription     = s.RankDescription,
                    PaidRankID          = s.PaidRankID,
                    PaidRankDescription = s.PaidRankDescription,
                    ModifiedDate        = s.ModifiedDate,
                    PeriodID            = s.PeriodID,
                    Volume1             = s.Volume1,
                    Volume2             = s.Volume2,
                    Volume3             = s.Volume3,
                    Volume9             = s.Volume9,
                    Volume10            = s.Volume10,
                    Volume12            = s.Volume12,
                    Volume13            = s.Volume13,
                    Volume14            = s.Volume14,
                    Volume16            = s.Volume16,
                    Volume17            = s.Volume17,
                    Volume18            = s.Volume18,
                    Volume22            = s.Volume22,
                    PeriodTypeID        = s.PeriodTypeID,
                    PeriodDescription   = s.PeriodDescription,
                    StartDate           = s.StartDate,
                    EndDate             = s.EndDate,
                }).FirstOrDefault();
            }
            if (finalResult == null)
            {
                finalResult = new VolumeCollection();
                finalResult.HighestAchievedRankThisPeriod.RankID          = 0;
                finalResult.HighestAchievedRankThisPeriod.RankDescription = string.Empty;
                return(finalResult);
            }
            return(finalResult);

            #endregion
        }
Ejemplo n.º 6
0
        public static VolumeCollection GetCustomerVolumes(GetCustomerVolumesRequest request)
        {
            var periodID     = request.PeriodID;
            var periodTypeID = request.PeriodTypeID;

            if (periodID == null)
            {
                periodID = ExigoDAL.GetCurrentPeriod(periodTypeID).PeriodID;
            }
            VolumeCollection volumes = new VolumeCollection();

            // Determine if we need to pull all Period Volumes or if we are passing in our own list of Volumes to fetch
            int    totalVolumeBuckets = 200;
            string volumeSelectQuery  = "";

            if (request.VolumesToFetch == null || request.VolumesToFetch.Count() == 0)
            {
                request.VolumesToFetch = new List <int>();
                for (int i = 1; i <= totalVolumeBuckets; i++)
                {
                    request.VolumesToFetch.Add(i);
                }
            }

            for (int i = 0, length = request.VolumesToFetch.Count(); i < length; i++)
            {
                var volumeBucket = request.VolumesToFetch[i];
                volumeSelectQuery = volumeSelectQuery + " , Volume{0} = isnull(pv.Volume{0}, 0)".FormatWith(volumeBucket);
            }


            using (var context = ExigoDAL.Sql())
            {
                volumes = context.Query <VolumeCollection, Period, Rank, Rank, VolumeCollection>(@"
                            Select 
                                c.CustomerID			                        
			                    , ModifiedDate = isnull(pv.ModifiedDate, '01/01/1900')
                                " + volumeSelectQuery + @"
		                        , PeriodID = p.PeriodID
			                    , PeriodTypeID = p.PeriodTypeID
		                        , PeriodDescription = p.PeriodDescription
		                        , StartDate = p.StartDate
		                        , EndDate = p.EndDate
		                        , RankID = isnull(pv.RankID,0)
		                        , RankDescription = isnull(r.RankDescription, '')
		                        , RankID = isnull(pv.PaidRankID,0)
		                        , RankDescription = isnull(pr.RankDescription, '')                                
	                        FROM Customers c
		                        LEFT JOIN PeriodVolumes pv
		                            ON pv.CustomerID = c.CustomerID
	                            LEFT JOIN Periods p
		                            ON pv.PeriodID = p.PeriodID
		                            AND pv.PeriodTypeID = p.PeriodTypeID
	                            LEFT JOIN Ranks r
		                            ON r.RankID = c.RankID
	                            LEFT JOIN Ranks pr
		                            ON pr.RankID = pv.PaidRankID
	                        WHERE pv.CustomerID = @CustomerID
		                        AND p.PeriodTypeID = @PeriodTypeID
                                AND p.PeriodID = @PeriodID
                    ", (vc, p, hr, pr) =>
                {
                    vc.Period = p;
                    vc.HighestAchievedRankThisPeriod = hr;
                    vc.PayableAsRank = pr;
                    return(vc);
                }
                                                                                                 , param: new
                {
                    CustomerID   = request.CustomerID,
                    PeriodTypeID = request.PeriodTypeID,
                    PeriodID     = periodID
                }
                                                                                                 , splitOn: "PeriodID, RankID, RankID"
                                                                                                 ).FirstOrDefault();
            }

            return((volumes != null) ? volumes : new VolumeCollection());
        }