public List <string> GetCEWKList()
{
CEDataModel cedam = new CEDataModel();
using (var ctx = new TODEntities())
{
var result = (from ta in ctx.FW_CALENDAR select ta.Fiscal_Week).Distinct();
cedam.CeWkDataList = result.ToList();
/*List<FW_CALENDAR> fwdataList = ctx.FW_CALENDAR.Distinct().ToList();
* foreach(var cedata in fwdataList)
* {
* cedam.CeWkDataList.Add(cedata.Fiscal_Week);
* }
* /*var result = (from ta in ctx.CE_DATA select ta.FW_ID).Distinct();
*
* cedam.ceWkDataList = result.ToList();*/
}
return(cedam.CeWkDataList);
}
public IEnumerable <SelectListItem> GetEnumFWKList()
{
CEDataModel cedam = new CEDataModel();
using (var ctx = new TODEntities())
{
/*var result = (from ta in ctx.FW_CALENDAR select ta.Fiscal_Week).Distinct();
* cedam.CeWkDataList = result.ToList();
*
* List<CE_DATA> cedatalist = ctx.CE_DATA.Distinct().ToList();
* cedam.CeDATAList = cedatalist;
* cedam.CeFwList = cedatalist.Select(m =>
* new SelectListItem()
* {
* Text = m.FW_ID,
* Value = m.FW_ID
* });*/
}
return(cedam.CeFwList);
}
