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