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); }
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); }
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); }
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); }
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); }
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; }
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; }
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; }