public AnnouncementQueryResult GetAdminAnnouncementsOrderedByTitle(AdminAnnouncementsQuery query) { var ps = new Dictionary <string, object>() { ["pFrom"] = query.FromTitle, ["pTo"] = query.ToTitle }; return(InternalGetAnnouncements("spGetAdminAnnouncementsOrderedByTitle", query, ps)); }
protected AnnouncementQueryResult InternalGetAnnouncements(string procedureName, AdminAnnouncementsQuery query, IDictionary <string, object> additionalParams) { additionalParams = additionalParams ?? new Dictionary <string, object>(); additionalParams.Add(STUDENT_ID, query.StudentId); additionalParams.Add(GRADE_LEVELS_IDS_PARAM, query.GradeLevelsIds ?? new List <int>()); additionalParams.Add(NOW_PARAM, query.Now); return(InternalGetAnnouncements <AnnouncementsQuery>(procedureName, query, additionalParams)); }
//public override AnnouncementQueryResult GetAnnouncements(AnnouncementsQuery query) //{ // var parameters = new Dictionary<string, object> // { // {ID_PARAM, query.Id }, // {ROLE_ID_PARAM, query.RoleId }, // {OWNED_ONLY_PARAM, query.OwnedOnly }, // {FROM_DATE_PARAM, query.FromDate }, // {TO_DATE_PARAM, query.ToDate }, // {START_PARAM, query.Start }, // {COUNT_PARAM, query.Count }, // {NOW_PARAM, query.Now }, // {PERSON_ID_PARAM, query.PersonId}, // {GRADE_LEVELS_IDS_PARAM, query.GradeLevelsIds ?? new List<int>()}, // {COMPLETE, query.Complete}, // {STUDENT_ID, query.StudentId} // }; // using (var reader = ExecuteStoredProcedureReader(GET_ADMIN_ANNOUNCEMENT_PROCEDURE, parameters)) // { // return ReadAnnouncementsQueryResult(reader, query); // } //} public AnnouncementQueryResult GetAdminAnnouncementsOrderedByDate(AdminAnnouncementsQuery query) { return(InternalGetAnnouncements("spGetAdminAnnouncementsOrderedByDate", query, null)); }