public override DataTable GetExportDataSet() { DataSet dataset = null; string FromDate; string Todate; int RecorderBy = BaseCommonFunctions.ApplicationInfo.LoggedInUser.LoggedinUserId; int pageNumber = 0; int pageSize = 0; string sortExpression = ""; int StaffId = 0; int ProgramId = 0; int FormId = 0; int LOI = 0; int IncidentCategory = -1; int SecondaryCategory = 0; int Status = 0; int ClientId = -1; string IndividualName = string.Empty; int ResidentialUnit = 0; pageNumber = ParentPageListObject.CurrentPage; pageSize = ParentPageListObject.PageSize == 0 ? 1 : ParentPageListObject.PageSize; sortExpression = ParentPageListObject.SortExpression; char Recorder = GetSignedByRecorder(); char Nursing = GetSignedByNursing(); char Supervisior = GetSignedBySupervisior(); char Administrator = GetSignedByAdministrator(); char FromDashboard = 'N'; if (!String.IsNullOrEmpty(GetFilterValue("FromDashboard"))) { FromDashboard = GetFilterValue("FromDashboard") == "Y" ? 'Y' : 'N'; } if (sortExpression.Trim() == "" || sortExpression.Trim() == null || sortExpression == string.Empty) { sortExpression = ""; } LOI = BaseCommonFunctions.GetSelectedValueFromXML <int>("/PageFilters/", "GeneralLocationOfIncident", ParentPageObject.PageFiltersXML); IncidentCategory = BaseCommonFunctions.GetSelectedValueFromXML <int>("/PageFilters/", "GeneralIncidentCategory", ParentPageObject.PageFiltersXML); SecondaryCategory = BaseCommonFunctions.GetSelectedValueFromXML <int>("/PageFilters/", "GeneralSecondaryCategory", ParentPageObject.PageFiltersXML); StaffId = BaseCommonFunctions.GetSelectedValueFromXML <int>("/PageFilters/", "Staff", ParentPageObject.PageFiltersXML); FromDate = BaseCommonFunctions.GetSelectedValueFromXML <string>("/PageFilters/", "StartDate", ParentPageObject.PageFiltersXML); Todate = BaseCommonFunctions.GetSelectedValueFromXML <string>("/PageFilters/", "EndDate", ParentPageObject.PageFiltersXML); IndividualName = BaseCommonFunctions.GetSelectedValueFromXML <string>("/PageFilters/", "Individual", ParentPageObject.PageFiltersXML); RecorderBy = BaseCommonFunctions.GetSelectedValueFromXML <int>("/PageFilters/", "Staff", ParentPageObject.PageFiltersXML); Status = BaseCommonFunctions.GetSelectedValueFromXML <int>("/PageFilters/", "Status", ParentPageObject.PageFiltersXML); ProgramId = BaseCommonFunctions.GetSelectedValueFromXML <int>("/PageFilters/", "ProgramId", ParentPageObject.PageFiltersXML); FormId = BaseCommonFunctions.GetSelectedValueFromXML <int>("/PageFilters/", "Forms", ParentPageObject.PageFiltersXML); ResidentialUnit = BaseCommonFunctions.GetSelectedValueFromXML <int>("/PageFilters/", "ResidentialUnit", ParentPageObject.PageFiltersXML); dataset = GetIncidentRestrictive(pageNumber, pageSize, ClientId, sortExpression, FromDate, Todate, ProgramId, FormId, LOI, IncidentCategory, SecondaryCategory, IndividualName, RecorderBy, Status, Recorder, Nursing, Supervisior, Administrator, FromDashboard, ResidentialUnit); return(dataset.Tables["IncidentRestrictive"]); }
public override DataTable GetExportDataSet() { using (SHS.UserBusinessServices.ListPages listPagesObj = new SHS.UserBusinessServices.ListPages()) { int instanceId = 0; int pageNumber = ParentPageListObject.CurrentPage; int pageSize = ParentPageListObject.PageSize == 0 ? 1 : ParentPageListObject.PageSize; string sortExpression = ParentPageListObject.SortExpression; DataSet dataSet = null; // Begin custom code int recordedByStaffId = -1; int assignedToStaffId = 0; string memberLastName = ""; string memberFirstName = ""; int otherFilter = 0; int dispositions = 0; int inquiryStatus = 0; source = "GetExportDataSet"; DateTime InquiriesFrom; DateTime InquiriesTo; recordedByStaffId = BaseCommonFunctions.GetSelectedValueFromXML <int>("/PageFilters/", "RecordedByStaffId", ParentPageObject.PageFiltersXML); assignedToStaffId = BaseCommonFunctions.GetSelectedValueFromXML <int>("/PageFilters/", "AssignedToStaffId", ParentPageObject.PageFiltersXML); dispositions = BaseCommonFunctions.GetSelectedValueFromXML <int>("/PageFilters/", "Dispositions", ParentPageObject.PageFiltersXML); inquiryStatus = BaseCommonFunctions.GetSelectedValueFromXML <int>("/PageFilters/", "InquiryStatus", ParentPageObject.PageFiltersXML); InquiriesFrom = BaseCommonFunctions.GetSelectedValueFromXML <DateTime>("/PageFilters/", "InquiriesFrom", ParentPageObject.PageFiltersXML); InquiriesTo = BaseCommonFunctions.GetSelectedValueFromXML <DateTime>("/PageFilters/", "InquiriesTo", ParentPageObject.PageFiltersXML); otherFilter = BaseCommonFunctions.GetSelectedValueFromXML <int>("/PageFilters/", "CustomFilter", ParentPageObject.PageFiltersXML); memberLastName = BaseCommonFunctions.GetSelectedValueFromXML <string>("/PageFilters/", "MemberLatName", ParentPageObject.PageFiltersXML); memberFirstName = BaseCommonFunctions.GetSelectedValueFromXML <string>("/PageFilters/", "MemberFirstName", ParentPageObject.PageFiltersXML); dataSet = GetInquriesList(instanceId, pageNumber, pageSize, sortExpression, recordedByStaffId, assignedToStaffId, InquiriesFrom, InquiriesTo, memberLastName, memberFirstName, dispositions, inquiryStatus, otherFilter); dataSet.Tables["CustomInquiries"].Columns.Remove("RowNumber"); dataSet.Tables["CustomInquiries"].Columns.Remove("InquiryId"); dataSet.Tables["CustomInquiries"].Columns["MemberName"].ColumnName = "Client (Potential)"; dataSet.Tables["CustomInquiries"].Columns["MemberId"].ColumnName = "Client Id"; dataSet.Tables["CustomInquiries"].Columns["InquirerName"].ColumnName = "Inquirer"; dataSet.Tables["CustomInquiries"].Columns["InQuiryDateTime"].ColumnName = "Date/Time"; dataSet.Tables["CustomInquiries"].Columns["RecordedByName"].ColumnName = "Recorded By"; dataSet.Tables["CustomInquiries"].Columns["AssignedToName"].ColumnName = "Assigned To"; return(dataSet.Tables["CustomInquiries"]); } }