Esempio n. 1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="Count"></param>
        /// <param name="Name"></param>
        /// <param name="BPType"></param>
        /// <returns></returns>
        private BOTReply GetBusinessPartner(int?Count, string Name = null, string BPType = "Cust")
        {
            BOTReply reply = new BOTReply();
            Reply    rp    = new Reply();

            rp.type = "list";
            using (SBODemoSGEntities data = new SBODemoSGEntities())
            {
                var Bps = data.OCRDs.Where(x => x.frozenFor == SAP_YesNo.No);;

                int max = 5;
                if ((Count ?? 0) > 0)
                {
                    max = Count.Value;
                }

                if (BPType == "Cust")
                {
                    Bps = Bps.Where(x => x.CardType == "C");
                }
                else
                {
                    Bps = Bps.Where(x => x.CardType == "S");
                }

                if (!string.IsNullOrWhiteSpace(Name))
                {
                    Bps = Bps.Where(x => x.CardName.Contains(Name));
                }

                Bps = Bps.Take(max);

                foreach (var item in Bps)
                {
                    rp.content.elements.Add(new Element()
                    {
                        title    = $"{item.CardCode}: {item.CardName}",
                        subtitle = $"Balance S$: {item.BalanceSys} - Email: {item.E_Mail}"
                    });
                }
                reply.replies.Add(rp);
            }
            return(reply);
        }
Esempio n. 2
0
        /// <summary>
        /// Gets the N number of products sorted descending on 'On Hand'.
        /// </summary>
        /// <param name="Count">Number of products</param>
        /// <param name="Descr">Description to search</param>
        /// <returns></returns>
        public BOTReply GetProducts(int?Count, string Descr = null)
        {
            BOTReply reply = new BOTReply();
            Reply    rp    = new Reply();

            rp.type = "list";
            using (SBODemoSGEntities data = new SBODemoSGEntities())
            {
                var prods = data.OITMs
                            .Join(data.ITM1s,
                                  oitm => new { icode = oitm.ItemCode, pricel = 1 },
                                  itm1 => new { icode = itm1.ItemCode, pricel = (int)itm1.PriceList },
                                  (oitm, itm1) => new { oitm, itm1 })
                            .Where(rec => rec.oitm.InvntItem == SAP_YesNo.Yes && rec.oitm.frozenFor == SAP_YesNo.No);

                int max = 5;
                if ((Count ?? 0) > 0)
                {
                    max = Count.Value;
                }

                if (!string.IsNullOrWhiteSpace(Descr))
                {
                    prods = prods.Where(x => x.oitm.ItemName.Contains(Descr));
                }

                prods = prods.OrderByDescending(x => x.oitm.OnHand).Take(max);

                foreach (var item in prods)
                {
                    rp.content.elements.Add(new Element()
                    {
                        title    = $"{item.oitm.ItemCode}: {item.oitm.ItemName}",
                        subtitle = $"In Stock: {item.oitm.OnHand} - Price: S$ {item.itm1.Price}"
                    });
                }
                reply.replies.Add(rp);
            }

            return(reply);
        }
Esempio n. 3
0
        /// <summary>
        /// Gets the top N opportunities sorted ascending/descending on percentage of profit
        /// </summary>
        /// <param name="Count">Number of opportunities to return</param>
        /// <param name="Sort">Sort order (Asc/Desc. Default is Desc)</param>
        /// <returns></returns>
        public BOTReply GetOpportunities(int?Count, string Sort = "DESC")
        {
            BOTReply reply = new BOTReply();
            Reply    rp    = new Reply();

            rp.type = "list";
            using (SBODemoSGEntities data = new SBODemoSGEntities())
            {
                var oops = data.OOPRs.Where(x => x.Status == "O");

                int max = 5;
                if ((Count ?? 0) > 0)
                {
                    max = Count.Value;
                }

                if (Sort.ToUpper() == "ASC")
                {
                    oops = oops.OrderBy(x => x.PrcnProf).ThenBy(y => y.CloPrcnt).Take(max);
                }
                else
                {
                    oops = oops.OrderByDescending(x => x.PrcnProf).ThenBy(y => y.CloPrcnt).Take(max);
                }

                foreach (var item in oops)
                {
                    rp.content.elements.Add(new Element()
                    {
                        title    = $"#{item.OpprId} - ({item.CloPrcnt}%) / {item.WtSumLoc} SGD (Weighed Amount)",
                        subtitle = $"{item.CardCode} - {item.CardName} {Environment.NewLine} {item.SumProfL} SGD (Total profit) {Environment.NewLine} Final Negotiation"
                    });
                }
                reply.replies.Add(rp);
            }

            return(reply);
        }