public string GetGradesService(SearchModal searchModal) { var Result = db.GetDataset("sp_Grade_filter", null); DataSet ds = UiMappedColumn.BuildColumn <GradeDetail>(Result); return(JsonConvert.SerializeObject(ds)); }
public string ExecuteReportGenericService <T>(SearchModal searchModal, string ProcedureName) { DbParam[] param = new DbParam[] { new DbParam(searchModal.SearchString, typeof(System.String), "_searchString"), new DbParam(searchModal.SortBy, typeof(System.String), "_sortBy"), new DbParam(searchModal.PageIndex, typeof(System.Int32), "_pageIndex"), new DbParam(searchModal.PageSize, typeof(System.Int32), "_pageSize") }; DataSet ds = db.GetDataset(ProcedureName, param); ds = UiMappedColumn.BuildColumn <T>(ds); return(JsonConvert.SerializeObject(ds)); }
public string FetchNoticeService(SearchModal searchModal) { string ResultSet = null; DbParam[] param = new DbParam[] { new DbParam(searchModal.SearchString, typeof(System.String), "_searchString"), new DbParam(searchModal.SortBy, typeof(System.String), "_sortBy"), new DbParam(searchModal.PageIndex, typeof(System.Int32), "_pageIndex"), new DbParam(searchModal.PageSize, typeof(System.Int32), "_pageSize") }; DataSet ds = db.GetDataset("sp_SchoolNotification_SelFilter", param); if (ds != null && ds.Tables.Count > 0) { ds = UiMappedColumn.BuildColumn <NoticeBoard>(ds); ResultSet = JsonConvert.SerializeObject(ds); } return(ResultSet); }
public string GetAllAnnouncementService(FetchAnnouncement fetchAnnouncement) { string ResultSet = null; DbParam[] param = new DbParam[] { new DbParam(fetchAnnouncement.searchModal.SearchString, typeof(System.String), "_searchString"), new DbParam(fetchAnnouncement.searchModal.SortBy, typeof(System.String), "_sortBy"), new DbParam(fetchAnnouncement.searchModal.PageIndex, typeof(System.Int32), "_pageIndex"), new DbParam(fetchAnnouncement.searchModal.PageSize, typeof(System.Int32), "_pageSize"), new DbParam(fetchAnnouncement.StudentUid, typeof(System.String), "_studentUid"), new DbParam(fetchAnnouncement.ClassDetailUid, typeof(System.String), "_classDetailUid"), new DbParam(this.userDetail.schooltenentId, typeof(System.String), "_tenentId") }; DataSet ds = db.GetDataset("sp_Announcement_SelFilter", param); if (ds != null && ds.Tables.Count > 0) { ds = UiMappedColumn.BuildColumn <Announcement>(ds); ResultSet = JsonConvert.SerializeObject(ds); } return(ResultSet); }