public static qPtl_UserAnnouncement_View GetUserAnnouncementByContentTypeID(int content_type_id, int user_id)
{
var message = new qPtl_UserAnnouncement_View();
message.container.Select(
new DbQuery
{
Where = string.Format("Available = 'Yes' AND MarkAsDelete = 0 AND UserViewed Is null AND (RemindAfter Is null OR RemindAfter < GetDate()) AND ContentTypeID = {0} AND UserID = {1}", content_type_id, user_id)
});
return(message);
}
public static qPtl_UserAnnouncement_View GetUserAnnouncementByContentTypeReferenceID(int content_type_id, int reference_id, int user_id)
{
var message = new qPtl_UserAnnouncement_View();
string sql_where = string.Empty;
sql_where = "Available = 'Yes' AND MarkAsDelete = 0 AND UserViewed Is null AND (RemindAfter Is null OR RemindAfter < GetDate())";
if (content_type_id == 0)
{
sql_where += " AND (ContentTypeID = " + content_type_id + " OR ContentTypeID Is null)";
}
else
{
sql_where += " AND ContentTypeID = " + content_type_id;
}
if (reference_id == 0)
{
sql_where += " AND (ReferenceID = " + reference_id + " OR ReferenceID Is null)";
}
else
{
sql_where += " AND ReferenceID = " + reference_id;
}
sql_where += " AND UserID = " + user_id;
message.container.Select(
new DbQuery
{
Where = sql_where
});
return(message);
}
public static qPtl_UserAnnouncement_View GetUserAnnouncementByContentTypeReferenceID(int content_type_id, int reference_id, int user_id)
{
var message = new qPtl_UserAnnouncement_View();
string sql_where = string.Empty;
sql_where = "Available = 'Yes' AND MarkAsDelete = 0 AND UserViewed Is null AND (RemindAfter Is null OR RemindAfter < GetDate())";
if (content_type_id == 0)
sql_where += " AND (ContentTypeID = " + content_type_id + " OR ContentTypeID Is null)";
else
sql_where += " AND ContentTypeID = " + content_type_id;
if (reference_id == 0)
sql_where += " AND (ReferenceID = " + reference_id + " OR ReferenceID Is null)";
else
sql_where += " AND ReferenceID = " + reference_id;
sql_where += " AND UserID = " + user_id;
message.container.Select(
new DbQuery
{
Where = sql_where
});
return message;
}
public static qPtl_UserAnnouncement_View GetUserAnnouncementByContentTypeID(int content_type_id, int user_id)
{
var message = new qPtl_UserAnnouncement_View();
message.container.Select(
new DbQuery
{
Where = string.Format("Available = 'Yes' AND MarkAsDelete = 0 AND UserViewed Is null AND (RemindAfter Is null OR RemindAfter < GetDate()) AND ContentTypeID = {0} AND UserID = {1}", content_type_id, user_id)
});
return message;
}