Esempio n. 1
0
        public QueryBinder TodayPicker(string _defaultDate)
        {
            //Cache5
            QueryBinder           binder          = new QueryBinder();
            RBOData               objData         = new RBOData();
            List <RBOEntity>      data            = objData.RBO(_defaultDate);
            List <CompanyDetails> todayPickerData = new List <CompanyDetails>();
            BulkData              objList         = new BulkData();
            List <CompanyDetails> data1           = objList.GetBasicData(new List <Weightage>(), "All", _masterDatapathBasic, _defaultDate).Where(x => x.BasicSavedTimeStamp.Date == DateTime.Now.Date).ToList();
            int qId = data1.Max(x => x.Id);
            List <CompanyDetails> newDataList = data1.Where(x => x.Id == qId).OrderByDescending(x => Convert.ToDecimal(x.CurrentPrevdayVolumePercentage)).Take(30).ToList();

            foreach (var newItem in newDataList)
            {
                foreach (var item in data.Where(x => Convert.ToDecimal(x.BOPercentage) > 95).OrderByDescending(x => Convert.ToDecimal(x.BOPercentage)))
                {
                    if (item.Code == newItem.Code)
                    {
                        todayPickerData.Add(newItem); break;
                    }
                }
            }
            binder.PosativeData = todayPickerData.ToList();
            return(binder);
        }
Esempio n. 2
0
        public QueryBinder RBO(string _defaultDate)
        {
            //Cache6
            QueryBinder      binder  = new QueryBinder();
            RBOData          objData = new RBOData();
            List <RBOEntity> data    = objData.RBO(_defaultDate);

            binder.RBOData = data.Where(x => Convert.ToDecimal(x.BOPercentage) > 95).OrderByDescending(x => Convert.ToDecimal(x.BOPercentage)).ToList();
            return(binder);
        }