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