/// <summary> /// Populate dropdown values on create order page /// </summary> /// <returns></returns> public TerritoryLanguage GetDropDownValue() { var _context = new DeluxeOrderManagementEntities(); TerritoryLanguage territoryLanguage = new TerritoryLanguage(); var orderCategory = (from og in _context.OrderGrids where !string.IsNullOrEmpty(og.Category) select og.Category.ToString() ).Distinct().ToList(); var territory = _context.Territories.Select(x => new DeluxeOM.Models.Territory() { TerritoryID = x.Id, TerritoryName = x.WBTerritory }).Distinct().OrderBy(x => x.TerritoryName).ToList(); var language = _context.Languages.Select(x => new DeluxeOM.Models.Language() { LanguageID = x.Id, LanguageName = x.Name }).Distinct().OrderBy(x => x.LanguageName).ToList(); var title = _context.VIDs.Select(x => new DeluxeOM.Models.Title() { VideoVersion = x.VideoVersion, Name = x.TitleName }).GroupBy(x => x.VideoVersion).Select(g => g.FirstOrDefault()).OrderBy(x => x.Name).ToList(); var orderTypes = _context.OrderGrids.Where(x => x.FileType != null).Select(x => x.FileType.ToString()).Distinct().ToList(); territoryLanguage.Territory = territory; territoryLanguage.Language = language; territoryLanguage.Title = title; territoryLanguage.orderCategory = orderCategory; territoryLanguage.OrderTypes = orderTypes; return(territoryLanguage); }
public TerritoryLanguage GetDropDownValue() { var _context = new DeluxeOrderManagementEntities(); TerritoryLanguage territoryLanguage = new TerritoryLanguage(); var orderCategory = (from og in _context.OrderGrids where !string.IsNullOrEmpty(og.Category) select og.Category.ToString() ).Distinct().ToList(); var territory = _context.Territories.Select(x => new DeluxeOM.Models.Territory() { TerritoryID = x.Id, TerritoryName = x.WBTerritory }).Distinct().OrderBy(x => x.TerritoryName).ToList(); var language = _context.Languages.Select(x => new DeluxeOM.Models.Language() { LanguageID = x.Id, LanguageName = x.Name }).Distinct().OrderBy(x => x.LanguageName).ToList(); var title = _context.AnnouncementGrids.Select(x => new DeluxeOM.Models.Title() { //TitleID = x.Id, Name = x.Title }).Distinct().OrderBy(x => x.Name).ToList(); territoryLanguage.Territory = territory; territoryLanguage.Language = language; territoryLanguage.Title = title; territoryLanguage.orderCategory = orderCategory; return(territoryLanguage); }