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);
}
