public List <TitleList> SearchTitles(string whrSQLquery)
{
var _context = new DeluxeOrderManagementEntities();
var titles = _context.usp_Search_Title(whrSQLquery).Select(x =>
new TitleList
{
TitleName = x.TitleName,
vendorID = x.VendorId,
VIDType = x.VIDStatus,
Territory = x.AppleTerritory,
ApplePOESTStartDate = x.POESTStartDate,
AppleESTStartDate = x.ESTStartDate,
AppleESTEndDate = x.ESTEndDate,
ESTHDLiveStatus = x.LiveESTHD,
ESTSDLiveStatus = x.LiveESTSD,
AppleVODStartDate = x.VODStartDate,
AppleVODEndDate = x.VODEndDate,
VODHDLiveStatus = x.LiveVODHD,
VODSDLiveStatus = x.LiveVODSD,
AnnouncementPOESTStartDate = x.AnnPOESTStartDate,
AnnouncementESTStartDate = x.AnnESTStartDate,
AnnouncementESTEndDate = x.AnnESTEndDate,
AnnouncementVODStartDate = x.AnnVODStartDate,
AnnouncementVODEndDate = x.AnnVODEndDate,
ComponentType = x.ComponentType,
ComponentQuality = x.ComponentQuality,
Language = x.LanguageName,
LanguageType = x.LanguageType,
LanguageStatus = x.LanguageStatus
}).Distinct().ToList();
return(titles);
}