Example #1
0
        public List <DropdownlistViewModels> GetDropDownListDeliveryMonth(string filtername)
        {
            List <DropdownlistViewModels> viewModel = new List <DropdownlistViewModels>();

            switch (filtername)
            {
            case "Matname":
                var ddlMatName = (from m in objBs.dOM_SAP_MATFRIGRPBs.GetAll()
                                  where !String.IsNullOrEmpty(m.MATNAME)
                                  select new
                {
                    Id = m.MATFRIGRP,
                    Name = m.MATNAME
                }).Distinct();
                foreach (var item in ddlMatName)
                {
                    DropdownlistViewModels model = new DropdownlistViewModels();
                    model.Id   = item.Id;
                    model.Name = item.Name;
                    viewModel.Add(model);
                }
                return(viewModel);

            case "Year":
                var ddlYear = (from y in objBs.ontimeDeliveryMonthBs.GetAll()
                               select new
                {
                    Id = y.Year,
                    Name = y.Year
                }).Distinct().OrderBy(x => x.Id);
                foreach (var item in ddlYear)
                {
                    DropdownlistViewModels model = new DropdownlistViewModels();
                    model.Id   = item.Id;
                    model.Name = item.Name;
                    viewModel.Add(model);
                }
                return(viewModel);

            case "Month":

                List <string> months = Enumerable.Range(1, 12).Select(m => DateTimeFormatInfo.InvariantInfo.GetAbbreviatedMonthName(m)).ToList();

                for (int i = 0; i < months.Count; i++)
                {
                    DropdownlistViewModels model = new DropdownlistViewModels();
                    model.Id   = Convert.ToString(i + 1);
                    model.Name = months[i];
                    viewModel.Add(model);
                }
                return(viewModel);

            default:
                break;
            }
            return(viewModel);
        }
Example #2
0
        public List <DropdownlistViewModels> GetDropDownListTenderUser()
        {
            List <DropdownlistViewModels> viewModel = new List <DropdownlistViewModels>();


            var ddlTnrdUsr = (from m in objBs.TenderUserBs.GetAll()
                              //where !String.IsNullOrEmpty(m.SHPPOINT)
                              select new
            {
                Id = m.UserName,
                Name = m.UserName
            }).Distinct().Where(x => !String.IsNullOrEmpty(x.Name)).OrderBy(x => x.Name);

            foreach (var item in ddlTnrdUsr)
            {
                DropdownlistViewModels model = new DropdownlistViewModels();
                model.Id   = item.Id;
                model.Name = item.Name;
                viewModel.Add(model);
            }
            return(viewModel);
        }
Example #3
0
        public List <DropdownlistViewModels> GetDropDownListShippingPoint(string month, string year)
        {
            List <DropdownlistViewModels> viewModel = new List <DropdownlistViewModels>();


            var ddlShpPnt = (from m in objBs.ShippingPointBs.GetByFilter(month, year)
                             //where !String.IsNullOrEmpty(m.SHPPOINT)
                             select new
            {
                Id = m.ShippingPointsId,
                Name = m.ShippingPointsName
            }).Distinct().Where(x => !String.IsNullOrEmpty(x.Name)).OrderBy(x => x.Name);

            foreach (var item in ddlShpPnt)
            {
                DropdownlistViewModels model = new DropdownlistViewModels();
                model.Id   = item.Id;
                model.Name = item.Name;
                viewModel.Add(model);
            }
            return(viewModel);
        }
Example #4
0
        public List <DropdownlistViewModels> GetDropDownListTenderedMonth(string filtername)
        {
            List <DropdownlistViewModels> viewModel = new List <DropdownlistViewModels>();

            switch (filtername)
            {
            case "Matname":
                var ddlMatName = (from m in objBs.dWH_ONTIME_DNBs.GetAll()
                                  where !String.IsNullOrEmpty(m.MATNAME)
                                  select new
                {
                    Id = m.MATFRIGRP,
                    Name = m.MATNAME
                }).Distinct();
                foreach (var item in ddlMatName)
                {
                    DropdownlistViewModels model = new DropdownlistViewModels();
                    model.Id   = item.Id;
                    model.Name = item.Name;
                    viewModel.Add(model);
                }
                return(viewModel);

            case "Year":
                var ddlYear = (from y in objBs.ontimeTenderMonthBs.GetAll()
                               select new
                {
                    Id = y.Year,
                    Name = y.Year
                }).Distinct().OrderBy(x => x.Id);
                foreach (var item in ddlYear)
                {
                    DropdownlistViewModels model = new DropdownlistViewModels();
                    model.Id   = item.Id;
                    model.Name = item.Name;
                    viewModel.Add(model);
                }
                return(viewModel);

            case "Month":

                List <string> months = Enumerable.Range(1, 12).Select(m => DateTimeFormatInfo.InvariantInfo.GetAbbreviatedMonthName(m)).ToList();

                for (int i = 0; i < months.Count; i++)
                {
                    DropdownlistViewModels model = new DropdownlistViewModels();
                    model.Id   = Convert.ToString(i + 1);
                    model.Name = months[i];
                    viewModel.Add(model);
                }
                return(viewModel);

            case "TruckType":
                var ddlTruckType = (from m in objBs.EquipmentTypesBs.GetAll()
                                    //where !String.IsNullOrEmpty(m.TRUCK_TYPE)
                                    select new
                {
                    Id = m.Eqmt_Code,
                    Name = m.Eqmt_Description
                }).Where(x => !String.IsNullOrEmpty(x.Name)).OrderBy(x => x.Name);
                foreach (var item in ddlTruckType)
                {
                    DropdownlistViewModels model = new DropdownlistViewModels();
                    model.Id   = item.Id;
                    model.Name = item.Name;
                    viewModel.Add(model);
                }
                return(viewModel);

            default:
                break;
            }
            return(viewModel);
        }
Example #5
0
        public List <DropdownlistViewModels> GetDropDownList(string filtername)
        {
            List <DropdownlistViewModels> viewModel = new List <DropdownlistViewModels>();

            switch (filtername)
            {
            case "Customer":
                var ddlCust = (from d in objBs.ontimeDeliveryBs.GetAll()
                               select new
                {
                    Id = d.SoldToId ?? "0",
                    Name = d.SoldToName ?? "No Master"
                }).Take(50000).Distinct().Where(x => !String.IsNullOrEmpty(x.Name)).OrderBy(x => x.Name);
                foreach (var item in ddlCust)
                {
                    DropdownlistViewModels model = new DropdownlistViewModels();
                    model.Id   = item.Id;
                    model.Name = item.Name;
                    viewModel.Add(model);
                }
                return(viewModel);

            case "Carrier":
                var ddlCarr = (from d in objBs.ontimeDeliveryBs.GetAll()
                               select new
                {
                    Id = d.CarrierId ?? "0",
                    Name = d.CarrierName ?? "No Master"
                }).Take(50000).Distinct().Where(x => !String.IsNullOrEmpty(x.Name)).OrderBy(x => x.Name);
                foreach (var item in ddlCarr)
                {
                    DropdownlistViewModels model = new DropdownlistViewModels();
                    model.Id   = item.Id;
                    model.Name = item.Name;
                    viewModel.Add(model);
                }
                return(viewModel);

            case "Department":
                var ddlDept = (from d in objBs.ontimeDeliveryBs.GetAll()
                               select new
                {
                    Id = d.DepartmentId ?? "0",
                    Name = d.DepartmentName ?? "No Master"
                }).Take(50000).Distinct().Where(x => !String.IsNullOrEmpty(x.Name)).OrderBy(x => x.Name);
                foreach (var item in ddlDept)
                {
                    DropdownlistViewModels model = new DropdownlistViewModels();
                    model.Id   = item.Id;
                    model.Name = item.Name;
                    viewModel.Add(model);
                }
                return(viewModel);

            case "Section":
                var ddlSec = (from d in objBs.ontimeDeliveryBs.GetAll()
                              //where !String.IsNullOrEmpty(d.SECTION_NAME)
                              select new
                {
                    Id = d.SectionId ?? "0",
                    Name = d.SectionName ?? "No Master"
                }).Take(50000).Distinct().Where(x => !String.IsNullOrEmpty(x.Name)).OrderBy(x => x.Name);
                foreach (var item in ddlSec)
                {
                    DropdownlistViewModels model = new DropdownlistViewModels();
                    model.Id   = item.Id;
                    model.Name = item.Name;
                    viewModel.Add(model);
                }
                return(viewModel);

            default:
                break;
            }
            return(viewModel);
        }
Example #6
0
        public List<DropdownlistViewModels> GetDropDownListTenderedMonth(string filtername)
        {
            List<DropdownlistViewModels> viewModel = new List<DropdownlistViewModels>();
            switch (filtername)
            {
                case "Matname":
                    var ddlMatName = (from m in objBs.dWH_ONTIME_DNBs.GetAll()
                                      where !String.IsNullOrEmpty(m.MATNAME)
                                      select new
                                      {
                                          Id = m.MATFRIGRP,
                                          Name = m.MATNAME
                                      }).Distinct();
                    foreach (var item in ddlMatName)
                    {
                        DropdownlistViewModels model = new DropdownlistViewModels();
                        model.Id = item.Id;
                        model.Name = item.Name;
                        viewModel.Add(model);
                    }
                    return viewModel;

                case "Year":
                    var ddlYear = (from y in objBs.ontimeTenderMonthBs.GetAll()
                                   select new
                                   {
                                       Id = y.Year,
                                       Name = y.Year
                                   }).Distinct().OrderBy(x => x.Id);
                    foreach (var item in ddlYear)
                    {
                        DropdownlistViewModels model = new DropdownlistViewModels();
                        model.Id = item.Id;
                        model.Name = item.Name;
                        viewModel.Add(model);
                    }
                    return viewModel;

                case "Month":

                    List<string> months = Enumerable.Range(1, 12).Select(m => DateTimeFormatInfo.InvariantInfo.GetAbbreviatedMonthName(m)).ToList();

                    for (int i = 0; i < months.Count; i++)
                    {
                        DropdownlistViewModels model = new DropdownlistViewModels();
                        model.Id = Convert.ToString(i + 1);
                        model.Name = months[i];
                        viewModel.Add(model);
                    }
                    return viewModel;

                case "ShippingPoint":
                    var ddlShpPnt = (from m in objBs.dWH_ONTIME_DNBs.GetAll()
                                     //where !String.IsNullOrEmpty(m.SHPPOINT)
                                      select new
                                      {
                                          Id = m.SHPPOINT,
                                          Name = m.SHPPOINT
                                      }).Take(50000).Distinct().Where(x => !String.IsNullOrEmpty(x.Name)).OrderBy(x => x.Name);
                    foreach (var item in ddlShpPnt)
                    {
                        DropdownlistViewModels model = new DropdownlistViewModels();
                        model.Id = item.Id;
                        model.Name = item.Name;
                        viewModel.Add(model);
                    }
                    return viewModel;

                case "ShipTo":
                    var ddlShpTo = (from m in objBs.dWH_ONTIME_SHIPMENTBs.GetAll()
                                    //where !String.IsNullOrEmpty(m.LAST_SHPG_LOC_NAME)
                                     select new
                                     {
                                         Id = m.LAST_SHPG_LOC_NAME,
                                         Name = m.LAST_SHPG_LOC_NAME
                                     }).Take(50000).Distinct().Where(x => !String.IsNullOrEmpty(x.Name)).OrderBy(x => x.Name);
                    foreach (var item in ddlShpTo)
                    {
                        DropdownlistViewModels model = new DropdownlistViewModels();
                        model.Id = item.Id;
                        model.Name = item.Name;
                        viewModel.Add(model);
                    }
                    return viewModel;

                case "TruckType":
                    var ddlTruckType = (from m in objBs.dWH_ONTIME_SHIPMENTBs.GetAll()
                                        //where !String.IsNullOrEmpty(m.TRUCK_TYPE)
                                    select new
                                    {
                                        Id = m.TRUCK_TYPE,
                                        Name = m.TRUCK_TYPE
                                    }).Take(50000).Distinct().Where(x => !String.IsNullOrEmpty(x.Name)).OrderBy(x => x.Name);
                    foreach (var item in ddlTruckType)
                    {
                        DropdownlistViewModels model = new DropdownlistViewModels();
                        model.Id = item.Id;
                        model.Name = item.Name;
                        viewModel.Add(model);
                    }
                    return viewModel;

                default:
                    break;
            }
            return viewModel;
        }
Example #7
0
        public List<DropdownlistViewModels> GetDropDownListOutboundMonth(string filtername)
        {
            List<DropdownlistViewModels> viewModel = new List<DropdownlistViewModels>();
            switch (filtername)
            {
                case "Matname":
                    var ddlMatName = (from m in objBs.ontimeOutboundMonthBs.GetAll()
                                      where !String.IsNullOrEmpty(m.MatName)
                                      select new
                                      {
                                          Id = m.MatFriGrp,
                                          Name = m.MatName
                                      }).Distinct();
                    foreach (var item in ddlMatName)
                    {
                        DropdownlistViewModels model = new DropdownlistViewModels();
                        model.Id = item.Id;
                        model.Name = item.Name;
                        viewModel.Add(model);
                    }
                    return viewModel;

                case "Year":
                    var ddlYear = (from y in objBs.ontimeOutboundMonthBs.GetAll()
                                   select new
                                   {
                                       Id = y.Year,
                                       Name = y.Year
                                   }).Distinct().OrderBy(x => x.Id);
                    foreach (var item in ddlYear)
                    {
                        DropdownlistViewModels model = new DropdownlistViewModels();
                        model.Id = item.Id;
                        model.Name = item.Name;
                        viewModel.Add(model);
                    }
                    return viewModel;

                case "Month":

                    List<string> months = Enumerable.Range(1, 12).Select(m => DateTimeFormatInfo.InvariantInfo.GetAbbreviatedMonthName(m)).ToList();

                    for (int i = 0; i < months.Count; i++)
                    {
                        DropdownlistViewModels model = new DropdownlistViewModels();
                        model.Id = Convert.ToString(i + 1);
                        model.Name = months[i];
                        viewModel.Add(model);
                    }
                    return viewModel;

                default:
                    break;
            }
            return viewModel;
        }
Example #8
0
 public List<DropdownlistViewModels> GetDropDownList(string filtername)
 {
     List<DropdownlistViewModels> viewModel = new List<DropdownlistViewModels>();
     switch (filtername)
     {
         case "Customer":
             var ddlCust = (from d in objBs.ontimeDeliveryBs.GetAll()
                            select new
                            {
                                Id = d.SoldToId ?? "0",
                                Name = d.SoldToName ?? "No Master"
                            }).Take(50000).Distinct().Where(x => !String.IsNullOrEmpty(x.Name)).OrderBy(x => x.Name);
             foreach (var item in ddlCust)
             {
                 DropdownlistViewModels model = new DropdownlistViewModels();
                 model.Id = item.Id;
                 model.Name = item.Name;
                 viewModel.Add(model);
             }
             return viewModel;
         case "Carrier":
             var ddlCarr = (from d in objBs.ontimeDeliveryBs.GetAll()
                            select new
                            {
                                Id = d.CarrierId ?? "0",
                                Name = d.CarrierName ?? "No Master"
                            }).Take(50000).Distinct().Where(x => !String.IsNullOrEmpty(x.Name)).OrderBy(x => x.Name);
             foreach (var item in ddlCarr)
             {
                 DropdownlistViewModels model = new DropdownlistViewModels();
                 model.Id = item.Id;
                 model.Name = item.Name;
                 viewModel.Add(model);
             }
             return viewModel;
         case "Department":
             var ddlDept = (from d in objBs.ontimeDeliveryBs.GetAll()
                            select new
                            {
                                Id = d.DepartmentId ?? "0",
                                Name = d.DepartmentName ?? "No Master"
                            }).Take(50000).Distinct().Where(x => !String.IsNullOrEmpty(x.Name)).OrderBy(x => x.Name);
             foreach (var item in ddlDept)
             {
                 DropdownlistViewModels model = new DropdownlistViewModels();
                 model.Id = item.Id;
                 model.Name = item.Name;
                 viewModel.Add(model);
             }
             return viewModel;
         case "Section":
             var ddlSec = (from d in objBs.ontimeDeliveryBs.GetAll()
                           //where !String.IsNullOrEmpty(d.SECTION_NAME)
                           select new
                           {
                               Id = d.SectionId ?? "0",
                               Name = d.SectionName ?? "No Master"
                           }).Take(50000).Distinct().Where(x => !String.IsNullOrEmpty(x.Name)).OrderBy(x => x.Name);
             foreach (var item in ddlSec)
             {
                 DropdownlistViewModels model = new DropdownlistViewModels();
                 model.Id = item.Id;
                 model.Name = item.Name;
                 viewModel.Add(model);
             }
             return viewModel;
         default:
             break;
     }
     return viewModel;
 }