/// <summary> /// Get sub-campaign records for a specific campaign, customer, and user only /// </summary> //public static ObjectQuery GetActiveSubCampaigns(int CampaignId, int CustomerId, int UserId) public static List<CTScSubCampaignList> GetActiveSubCampaigns(int UserId, List<string> Statuses) { using (BrightPlatformEntities objDbModel = new BrightPlatformEntities(UserSession.EntityConnection)) { if (Statuses.Count < 1) return objDbModel.FIScGetSubCampaignList(UserId, "").ToList(); else return objDbModel.FIScGetSubCampaignList(UserId, string.Join(",", Statuses.ToArray())).ToList(); } //var objSubCampaigns = //( // from objSubCampaign in m_objBrightPlatformEntity.subcampaigns // join objCampaign in m_objBrightPlatformEntity.campaigns on objSubCampaign.campaign_id equals objCampaign.id // join objEntitySubCampaignUser in m_objBrightPlatformEntity.subcampaign_users on objSubCampaign.id equals objEntitySubCampaignUser.subcampaign_id into objEntitySubCampaignUser // from objSubCampaignUser in objEntitySubCampaignUser.DefaultIfEmpty() // join objUserRole in m_objBrightPlatformEntity.sub_campaign_user_roles on objSubCampaignUser.id equals objUserRole.sub_campaign_user_id // where // objSubCampaign.status != "Deleted" && // objSubCampaign.campaign_id == CampaignId && // objCampaign.customer_id == CustomerId && // objUserRole.sub_campaign_role_id == 3 && // 3 = Sub Campaign Sales User // objSubCampaignUser.user_id == UserId // //(objSubCampaign.campaign_manager_user_id == UserId || objSubCampaignUser.user_id == UserId) // orderby objSubCampaign.priority descending, objSubCampaign.title // select new // { // id = objSubCampaign.id, // title = objSubCampaign.title // } //).Distinct(); //return (ObjectQuery)objSubCampaigns; }