public static qPtl_Announcement GetAnnouncementByContentTypeReferenceID(int content_type_id, int reference_id)
{
var message = new qPtl_Announcement();
message.container.Select(
new DbQuery
{
Where = string.Format("Available = 'Yes' AND MarkAsDelete = 0 AND ContentTypeID = {0} AND ReferenceID = {1}", content_type_id, reference_id)
});
return(message);
}
public static qPtl_Announcement GetAnnouncementByCampaignID(int campaign_id)
{
var message = new qPtl_Announcement();
message.container.Select(
new DbQuery
{
Where = string.Format("AnnouncementForCampaignID = '{0}'", campaign_id)
});
return(message);
}
public static qPtl_Announcement GetAnnouncementByContentTypeReferenceID(int content_type_id, int reference_id)
{
var message = new qPtl_Announcement();
message.container.Select(
new DbQuery
{
Where = string.Format("Available = 'Yes' AND MarkAsDelete = 0 AND ContentTypeID = {0} AND ReferenceID = {1}", content_type_id, reference_id)
});
return message;
}
public static qPtl_Announcement GetAnnouncementByCampaignID(int campaign_id)
{
var message = new qPtl_Announcement();
message.container.Select(
new DbQuery
{
Where = string.Format("AnnouncementForCampaignID = '{0}'", campaign_id)
});
return message;
}