public void ValidateFilterModal(SearchModal searchModal, string SortBy) { if (string.IsNullOrEmpty(searchModal.SearchString)) { searchModal.SearchString = " 1=1 "; } if (string.IsNullOrEmpty(searchModal.SortBy)) { if (string.IsNullOrEmpty(SortBy)) { searchModal.SortBy = ""; } else { searchModal.SortBy = SortBy; } } if (searchModal.PageIndex <= 0) { searchModal.PageIndex = 1; } if (searchModal.PageSize <= 0) { searchModal.PageSize = 10; } }
public string UpdateRoomDetailService(RoomDetail roomDetail) { DbParam[] param = new DbParam[] { new DbParam(roomDetail.RoomUid, typeof(System.String), "_RoomUid"), new DbParam(roomDetail.RoomNo, typeof(System.Int64), "_RoomNo"), new DbParam(roomDetail.ClassDetailUid, typeof(System.String), "_ClassDetailUid"), new DbParam(roomDetail.RoomType, typeof(System.String), "_RoomType"), new DbParam(this.userDetail.UserId, typeof(System.String), "_AdminUid"), new DbParam(this.userDetail.schooltenentId, typeof(System.String), "_TanentUid") }; Result = this.db.ExecuteNonQuery("sp_Rooms_InsUpd", param, true); if (Result.IndexOf("successfully") != -1) { SearchModal searchModal = new SearchModal { PageIndex = 1, PageSize = 20, SearchString = "1=1", SortBy = "" }; Result = GetRoomService(searchModal); } return(Result); }
public string GetGradesService(SearchModal searchModal) { var Result = db.GetDataset("sp_Grade_filter", null); DataSet ds = UiMappedColumn.BuildColumn <GradeDetail>(Result); return(JsonConvert.SerializeObject(ds)); }
public IResponse <ApiResponse> AttendenceAllByFilter(SearchModal searchModal) { string ClassSectionFilter = " cd.Class = 1"; var Result = attendenceService.AttendenceAllByFilterService(searchModal, ClassSectionFilter); return(BuildResponse(Result, System.Net.HttpStatusCode.OK)); }
public ActionResult ViewClasses(SearchModal searchModal) { var result = GetClassDetail(searchModal); //ViewBag.Vehicles = result.Data; //ViewBag.Type = context.Stringify("vehicle"); return(null); }
public string GetAssignments(SearchModal searchModal) { 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"), new DbParam(userDetail.schooltenentId, typeof(System.String), "_tenentId") }; DataSet ds = db.GetDataset("sp_Assignment_SelByFilter", param); 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)); }
protected async Task SearchLocationAsync() { SearchModal.Show(); SearchResults.Clear(); if (!String.IsNullOrEmpty(SearchQuery)) { var results = await Interop.SearchAsync(SearchQuery); SearchResults.AddRange(results); Log.Debug($"Search, results: {SearchResults.Count}."); StateHasChanged(); } }
public string AllSubjectService(SearchModal searchModal) { 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"), new DbParam(userDetail.schooltenentId, typeof(System.String), "_TenentUid") }; DataSet ds = db.GetDataset("sp_Subject_SelFilter", param); OutParam = JsonConvert.SerializeObject(ds); return(OutParam); }
public string GetRoomService(SearchModal searchModal) { 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.String), "_pageIndex"), new DbParam(searchModal.PageSize, typeof(System.String), "_pageSize") }; ResultSet = this.db.GetDataset("sp_Rooms_SelByFilter", param); if (this.beanContext.IsValidDataSet(ResultSet)) { Result = JsonConvert.SerializeObject(ResultSet); } return(Result); }
public DataSet GetClassesService(SearchModal searchModal) { this.validateModalService.ValidateSeachModal(searchModal); 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_ListClassDetail_BySectionGroup", param); if (ds != null && ds.Tables.Count > 0) { return(ds); } return(null); }
public void ValidateSeachModal(SearchModal searchModal) { if (string.IsNullOrEmpty(searchModal.SearchString)) { searchModal.SearchString = "1=1"; } if (string.IsNullOrEmpty(searchModal.SortBy)) { searchModal.SortBy = "Class"; } if (searchModal.PageIndex <= 0) { searchModal.PageIndex = 1; } if (searchModal.PageSize <= 0) { searchModal.PageSize = 15; } }
public string FetchMarksService(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_Marks_SelFilter", param); if (ds != null && ds.Tables.Count > 0) { ResultSet = JsonConvert.SerializeObject(ds); } return(ResultSet); }
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 static List <EmployeeCommanModal> GetSalesDirector(SearchModal Obj) { using (var context = new SalesReturndbEntities()) { var list = context.SP_GetEmployeeForBU_Division_Country(Obj.BUName, Obj.DivisionName, Obj.CountryName).ToList(); List <EmployeeCommanModal> empList = null; if (list != null) { empList = list.Select(x => new EmployeeCommanModal() { EmployeeCode = x.EMP_CODE, EmployeeName = x.Emp_First_name, }).ToList(); return(empList); } return(empList); } }
public string AttendenceAllByFilterService(SearchModal searchModal, string ClassSectionFilter) { string Result = null; this.commonService.ValidateFilterModal(searchModal, "Rollno"); 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.String), "_pageIndex"), new DbParam(searchModal.PageSize, typeof(System.String), "_pageSize"), new DbParam(ClassSectionFilter, typeof(System.String), "_ClassSectionFilter"), new DbParam(userDetail.schooltenentId, typeof(System.String), "_tenentId") }; DataSet ds = db.GetDataset("sp_Attendence_FullReportFilter", param); if (ds.Tables.Count == 2) { Result = JsonConvert.SerializeObject(ds); } return(Result); }
public string GuardianReportService(SearchModal searchModal) { this.commonService.ValidateFilterModal(searchModal, "parentdetailid"); return(ExecuteReportGenericService <Faculty>(searchModal, "sp_parentdetail_SelByFilter")); }
public IResponse <ApiResponse> FetchNotice(SearchModal searchModal) { string result = this.noticeService.FetchNoticeService(searchModal); return(BuildResponse(result, System.Net.HttpStatusCode.OK)); }
protected async ValueTask SearchResultSelectedAsync(MapSearchModel selected) { this.selected = selected; SearchModal.Hide(); }
/// <summary> /// 高级查询按钮点击时调用此方法 /// </summary> protected void AdvancedSearchClick() { // 弹出高级查询弹窗 SearchModal?.Toggle(); }
public IResponse <ApiResponse> GetRoomDetail([FromBody] SearchModal searchModal) { string Result = applicationSettingService.GetRoomService(searchModal); return(BuildResponse(Result, System.Net.HttpStatusCode.OK)); }
public IResponse <ApiResponse> AllSubjects([FromBody] SearchModal searchModal) { string Result = eventService.AllSubjectService(searchModal); return(BuildResponse(Result, System.Net.HttpStatusCode.OK)); }
public List <EmployeeCommanModal> GetSalesDirector([FromBody] SearchModal Obj) { return(ApprovalMatrixDAL.GetSalesDirector(Obj)); }
public IResponse <ApiResponse> GetClassDetail(SearchModal searchModal) { var result = adminMasterService.GetClassesService(searchModal); return(BuildResponse(result, System.Net.HttpStatusCode.OK)); }
public string StudentReportService(SearchModal searchModal) { this.commonService.ValidateFilterModal(searchModal, "studentUid"); return(ExecuteReportGenericService <Student>(searchModal, "sp_StudentDetail_SelByFilter")); }
public IResponse <ApiResponse> FetchHolidays(SearchModal searchModal) { string result = this.holidayService.GetHolidayListService(searchModal); return(BuildResponse(result, System.Net.HttpStatusCode.OK)); }
public IResponse <ApiResponse> GetNotice(SearchModal searchModal) { string Result = this.assignmentService.GetAssignments(searchModal); return(BuildResponse(Result, System.Net.HttpStatusCode.OK)); }
public string FacultyReportService(SearchModal searchModal) { this.commonService.ValidateFilterModal(searchModal, "StaffMemberUid"); return(ExecuteReportGenericService <Faculty>(searchModal, "sp_Faculty_SelByFilter")); }
public IResponse <ApiResponse> StaffReport([FromBody] SearchModal searchModal) { var Result = reportService.StaffReportService(searchModal); return(BuildResponse(Result, System.Net.HttpStatusCode.OK)); }