Пример #1
0
 private void ApplyPopupFilter()
 {
     try
     {
         ExecuteUpdateActivities();
         //if (PopupFilterDictContains(Constants.MainviewPopupList, DictFilterPopup))
         //{
         UserProjects = DynamicFilter.FilterDataTable(masterprojectlist, Constants.MainviewPopupList, DictFilterPopup);
         //}
         //else
         //    UserProjects = masterprojectlist;
     }
     catch
     {
     }
     GetSumSales();
 }
Пример #2
0
        private void ApplyPopupFilter()
        {
            try
            {
                //if (PopupFilterDictContains(Constants.MasterProjectsPopupList, DictFilterPopup))
                //{
                //    Dictionary<string, List<string>> locdictFilterPopup = new Dictionary<string, List<string>>();
                //    foreach(string s in Constants.MasterProjectsPopupList)
                //        locdictFilterPopup.Add(s, DictFilterPopup[s].FilterData.Where(y => y.IsChecked == true).Select(x => x.Description).ToList<string>());

                //    var c1 = tempsalesfunnel.AsEnumerable()
                //    .Where(row => locdictFilterPopup["SalesDivision"].Contains(row["SalesDivision"].ToString())
                //        && locdictFilterPopup["IndustrySegment"].Contains(row["IndustrySegment"].ToString())
                //        && locdictFilterPopup["KPM"].Contains(row["KPM"].ToString())
                //        && locdictFilterPopup["Customer"].Contains(row["Customer"].ToString())
                //        && locdictFilterPopup["UserName"].Contains(row["UserName"].ToString())
                //        && locdictFilterPopup["DifferentiatedTechnology"].Contains(row["DifferentiatedTechnology"].ToString())
                //        && locdictFilterPopup["Application"].Contains(row["Application"].ToString())
                //        && locdictFilterPopup["ProjectStatus"].Contains(row["ProjectStatus"].ToString())
                //        && locdictFilterPopup["ProjectType"].Contains(row["ProjectType"].ToString())
                //        && locdictFilterPopup["SMCode"].Contains(row["SMCode"].ToString())
                //        && locdictFilterPopup["SalesFunnelStage"].Contains(row["SalesFunnelStage"].ToString())
                //    );

                //    if (c1.Count() > 0)
                //    {
                //        DataTable tblFiltered = c1.CopyToDataTable();
                //        ReFormatColumns(ref tempsalesfunnel, ref tblFiltered);
                //        SalesFunnel = tblFiltered;
                //    }
                //    else
                //        SalesFunnel = tempsalesfunnel.Clone();
                //}
                //else
                //    SalesFunnel = tempsalesfunnel;

                SalesFunnel = DynamicFilter.FilterDataTable(tempsalesfunnel, Constants.MasterProjectsPopupList, DictFilterPopup);
            }
            catch
            {
            }
        }
        private void ApplyPopupFilter()
        {
            try
            {
                //if (PopupFilterDictContains(Constants.StatusReportPopupList, DictFilterPopup))
                //{
                //    Dictionary<string, List<string>> locdictFilterPopup = new Dictionary<string, List<string>>();
                //    foreach (string s in Constants.StatusReportPopupList)
                //        locdictFilterPopup.Add(s, DictFilterPopup[s].FilterData.Where(y => y.IsChecked == true).Select(x => x.Description).ToList<string>());

                //    var c1 = masterdatatable.AsEnumerable()
                //    .Where(row => locdictFilterPopup["SalesDivision"].Contains(row["SalesDivision"].ToString())
                //        && locdictFilterPopup["KPM"].Contains(row["KPM"].ToString())
                //        && locdictFilterPopup["Customer"].Contains(row["Customer"].ToString())
                //        && locdictFilterPopup["UserName"].Contains(row["UserName"].ToString())
                //        && locdictFilterPopup["ProjectStatus"].Contains(row["ProjectStatus"].ToString())
                //        && locdictFilterPopup["ProjectType"].Contains(row["ProjectType"].ToString())
                //        && locdictFilterPopup["SalesFunnelStage"].Contains(row["SalesFunnelStage"].ToString())
                //    );

                //    if (c1.Count() > 0)
                //    {
                //        DataTable tblFiltered = c1.CopyToDataTable();
                //        ReFormatColumns(ref masterdatatable, ref tblFiltered);
                //        Data = tblFiltered;
                //    }
                //    else
                //        Data = masterdatatable.Clone();
                //}
                //else
                //    Data = masterdatatable;

                Data = DynamicFilter.FilterDataTable(masterdatatable, Constants.StatusReportPopupList, DictFilterPopup);
            }
            catch
            {
            }
        }