public void Cells_Workbook_Tests() { try { storageService.File.CopyFile(Utils.CloudStorage_Input_Folder + "/cells-sample.xlsx", Utils.CloudStorage_Output_Folder + "/cells-sample.xlsx"); WorkbookResponse WorkbookResponse = cellsService.Workbook.ReadWorkbookInfo(name, string.Empty, true, Utils.CloudStorage_Output_Folder); cellsService.Workbook.ExportWorkbook(name, WorkbookExportFormat.Pdf, string.Empty, false, Utils.CloudStorage_Output_Folder, Utils.Local_Output_Path + "cells-workbook-pdf.pdf"); cellsService.Workbook.ExportWorkbook(name, WorkbookExportFormat.Pdf, string.Empty, false, Utils.CloudStorage_Output_Folder, Utils.CloudStorage_Output_Folder + "/cells-workbook-pdf.pdf"); //To test //WorkbookResponse WorkbookResponse2 = cellsService.Workbook.CreateNewWorkbookUsingDeferentMethods(name, "templateFile", "dataFile", Utils.CloudStorage_Output_Folder); cellsService.Workbook.ConvertWorkbookToSomeFormat(WorkbookExportFormat.Pdf, string.Empty, Utils.CloudStorage_Output_Folder + "/cells-workbook-pdf2.pdf", Utils.Local_Input_Path + name); WorkbookEncryptionRequest workbookEncryptionRequest = new WorkbookEncryptionRequest(WorkbookEncryptionType.XOR, 128, "Aspose"); cellsService.Workbook.EncriptDocument(name, Utils.CloudStorage_Output_Folder, workbookEncryptionRequest); cellsService.Workbook.DecryptDocument(name, Utils.CloudStorage_Output_Folder, workbookEncryptionRequest); WorkbookStyleResponse WorkbookStyleResponse = cellsService.Workbook.ReadWorkbookDefaultStyleInfo(name, Utils.CloudStorage_Output_Folder); WorkbookTextItemsResponse WorkbookTextItemsResponse = cellsService.Workbook.ReadWorkbooksTextItems(name, Utils.CloudStorage_Output_Folder); WorkbookNamesResponse WorkbookNamesResponse = cellsService.Workbook.ReadWorkbooksNames(name, Utils.CloudStorage_Output_Folder); WorkbookNameResponse WorkbookNameResponse = cellsService.Workbook.ReadWorkbooksName(name, "TestName", Utils.CloudStorage_Output_Folder); ProtectDocumentRequest protectDocumentRequest = new ProtectDocumentRequest(); protectDocumentRequest.Password = "******"; cellsService.Workbook.ProtectDocumentFromChanges(name, Utils.CloudStorage_Output_Folder, protectDocumentRequest); cellsService.Workbook.UnprotectDocumentFromChanges(name, Utils.CloudStorage_Output_Folder, protectDocumentRequest); storageService.File.CopyFile(Utils.CloudStorage_Input_Folder + "/cells-sample.xlsx", Utils.CloudStorage_Output_Folder + "/cells-sample2.xlsx"); WorkbookResponse WorkbookResponse4 = cellsService.Workbook.MergeWorkbooks(name, Utils.CloudStorage_Output_Folder + "/cells-sample2.xlsx", Utils.CloudStorage_Output_Folder); CellsTextItemsResponse CellsTextItemsResponse = cellsService.Workbook.SearchText(name, "Student1", Utils.CloudStorage_Output_Folder); WorkbookReplaceTextResponse WorkbookReplaceTextResponse = cellsService.Workbook.ReplaceText(name, "Student", "Employee", Utils.CloudStorage_Output_Folder); //To test //WorkbookResponse WorkbookResponse5 = cellsService.Workbook.SmartMarkerProcessingResult(name, "xmlFile", Utils.CloudStorage_Output_Folder, "outPath"); WorkbookSplitResponse WorkbookSplitResponse = cellsService.Workbook.SplitWorkbook(name, CellsSplitFormat.Gif, 1, 2, 0, 0, Utils.CloudStorage_Output_Folder); //To test //cellsService.Workbook.ImportDataToWorkbook(name, Utils.CloudStorage_Output_Folder, WorkbookImportOption); cellsService.Workbook.CalculateAllFormulasInWorkbook(name, Utils.CloudStorage_Output_Folder); CellsAutoFitterOptionsRequest autoFitterOptions = new CellsAutoFitterOptionsRequest(); autoFitterOptions.AutoFitMergedCells = true; autoFitterOptions.IgnoreHidden = true; autoFitterOptions.OnlyAuto = false; cellsService.Workbook.AutofitWorkbookRows(name, 1, 50, false, autoFitterOptions, Utils.CloudStorage_Output_Folder); //storageService.File.DownloadFile(Utils.CloudStorage_Output_Folder + "/cells-sample.xlsx", Utils.Local_Output_Path + "/cells-sample.xlsx"); } catch (Exception ex) { Assert.Fail(ex.Message); } }
public void RequestWithoutColumnList() { List <EmployeeModel> wbList = new List <EmployeeModel>(); Function function = new Function(); QueryBuilderRequest wbRequest = new QueryBuilderRequest { CompanyId = 6, UserId = 6, Payload = new QueryBuilderRequest { Fields = wbList, EntityName = "Workbook", AppType = Constants.QUERY_BUILDER } }; EmployeeModel wbFilter1 = new EmployeeModel { Name = Constants.DAYS_TO_COMPLETE, Value = "20", Operator = "<=" }; wbList.Add(wbFilter1); WorkbookResponse wbResponse = function.GetWorkbookQueryBuilder(wbRequest, null); ErrorResponse workbookResponse = wbResponse.Error; Assert.AreEqual(500, workbookResponse.Status); Assert.AreEqual(33, workbookResponse.Code); StringAssert.Contains(workbookResponse.Message, TestConstants.SYSTEM_ERROR); }
/// <summary> /// [QueryBuilder] Function to get list of workbook(s) filtered with some condition(s) /// </summary> /// <param name="queryBuilderRequest"></param> /// <param name="context"></param> /// <returns>WorkbookResponse</returns> public WorkbookResponse GetWorkbookQueryBuilder(QueryBuilderRequest queryBuilderRequest, ILambdaContext context) { WorkbookRepository workbookRepository = new WorkbookRepository(); WorkbookResponse workbookResponse = new WorkbookResponse(); Authorizer authorizer = new Authorizer(); try { //Validating the student details string studentDetails = queryBuilderRequest.Payload.Fields.Where(x => x.Name.ToUpper() == Constants.STUDENT_DETAILS).Select(x => x.Value).FirstOrDefault(); if (authorizer.ValidateUser(queryBuilderRequest.UserId, queryBuilderRequest.CompanyId, queryBuilderRequest.Payload.AppType, studentDetails)) { return(workbookRepository.GetWorkbookDetails(queryBuilderRequest)); } else { workbookResponse.Error = ResponseBuilder.Forbidden(); return(workbookResponse); } } catch (Exception getWorkbookQueryBuilderException) { LambdaLogger.Log(getWorkbookQueryBuilderException.ToString()); workbookResponse.Error = ResponseBuilder.InternalError(); return(workbookResponse); } }
public static void Run() { // ExStart:1 CellsApi cellsApi = new CellsApi(Common.APP_KEY, Common.APP_SID, Common.BASEPATH); StorageApi storageApi = new StorageApi(Common.APP_KEY, Common.APP_SID, Common.BASEPATH); String fileName = "Sample_Test_Book" + new Random().Next(100) + ".xls"; String templateFile = "Sample_Test_Book.xls"; String dataFile = null; byte[] file = null; String storage = null; String folder = null; try { // Upload source file to aspose cloud storage storageApi.PutCreate(templateFile, "", "", System.IO.File.ReadAllBytes(Common.GetDataDir() + templateFile)); // Invoke Aspose.Cells Cloud SDK API to create workbook from template WorkbookResponse apiResponse = cellsApi.PutWorkbookCreate(fileName, templateFile, dataFile, storage, folder, file); if (apiResponse != null && apiResponse.Status.Equals("OK")) { String outPutFileName = apiResponse.Workbook.FileName; Console.WriteLine("File name:" + outPutFileName); Console.ReadKey(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("error:" + ex.Message + "\n" + ex.StackTrace); } // ExEnd:1 }
public static void Run() { // ExStart:1 CellsApi cellsApi = new CellsApi(Common.APP_KEY, Common.APP_SID, Common.BASEPATH); StorageApi storageApi = new StorageApi(Common.APP_KEY, Common.APP_SID, Common.BASEPATH); String fileName = "Sample_Book1.xlsx"; String mergeWith = "Sample_Book2.xls"; String storage = ""; String folder = ""; try { // Upload file to aspose cloud storage storageApi.PutCreate(fileName, "", "", System.IO.File.ReadAllBytes(Common.GetDataDir() + fileName)); // Upload merge file to aspose cloud storage storageApi.PutCreate(mergeWith, "", "", System.IO.File.ReadAllBytes(Common.GetDataDir() + mergeWith)); // Invoke Aspose.Cells Cloud SDK API to merge excel workbooks WorkbookResponse apiResponse = cellsApi.PostWorkbooksMerge(fileName, mergeWith, storage, folder); if (apiResponse != null && apiResponse.Status.Equals("OK")) { String destFileName = apiResponse.Workbook.FileName; Console.WriteLine("File name:" + destFileName); Console.ReadKey(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("error:" + ex.Message + "\n" + ex.StackTrace); } // ExEnd:1 }
static void Main() { string dataDir = Common.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); string output = "output.xlsx"; WorkbookResponse apiResponse = Common.CellsService.Workbook.CreateNewWorkbookUsingDeferentMethods(output, string.Empty, string.Empty, Common.FOLDER, storage: Common.STORAGE); Common.StorageService.File.DownloadFile(output, dataDir + output, storage: Common.STORAGE); }
public void GetWorkbooksWithSingleField() { List <EmployeeModel> wbList = new List <EmployeeModel>(); Function function = new Function(); QueryBuilderRequest wbRequest = new QueryBuilderRequest { CompanyId = 6, UserId = 6, Payload = new QueryBuilderRequest { ColumnList = new string[] { Constants.WORKBOOK_ID, Constants.WORKBOOK_NAME, Constants.DESCRIPTION, Constants.WORKBOOK_CREATED_BY, Constants.DAYS_TO_COMPLETE }, Fields = wbList, EntityName = "Workbook", AppType = Constants.QUERY_BUILDER } }; EmployeeModel wbFilter1 = new EmployeeModel { Name = Constants.DAYS_TO_COMPLETE, Value = "20", Operator = "<=" }; EmployeeModel wbFilter2 = new EmployeeModel { Name = Constants.WORKBOOK_CREATED, Value = "01/01/1787 and 04/03/2019", //"08 /06/1977, 08/08/1975", Operator = "BETWEEN" }; EmployeeModel wbFilter3 = new EmployeeModel { Name = Constants.WORKBOOK_ID, Value = "14", Operator = "<" }; EmployeeModel wbFilter4 = new EmployeeModel { Name = Constants.SUPERVISOR_ID, Value = "6", Operator = "!=" }; wbList.Add(wbFilter3); //wbList.Add(wbFilter4); WorkbookResponse wbResponse = function.GetWorkbookQueryBuilder(wbRequest, null); List <WorkbookModel> workbookList = wbResponse.Workbooks; Assert.AreNotEqual(0, workbookList.Count); Assert.IsTrue(workbookList[workbookList.Count - 1].WorkBookId < 14); }
public void GetWorkbooksWithMultipleField() { List <EmployeeModel> wbList = new List <EmployeeModel>(); Function function = new Function(); QueryBuilderRequest wbRequest = new QueryBuilderRequest { CompanyId = 6, UserId = 6, Payload = new QueryBuilderRequest { ColumnList = new string[] { Constants.WORKBOOK_ID, Constants.WORKBOOK_NAME, Constants.DESCRIPTION, Constants.WORKBOOK_CREATED_BY, Constants.DAYS_TO_COMPLETE }, Fields = wbList, EntityName = "Workbook", AppType = Constants.QUERY_BUILDER } }; EmployeeModel wbFilter1 = new EmployeeModel { Name = Constants.WORKBOOK_ID, Value = "40", Operator = ">=" }; EmployeeModel wbFilter2 = new EmployeeModel { Name = Constants.WORKBOOK_CREATED, Value = "01/21/2001", Operator = "<=", Bitwise = "and" }; EmployeeModel wbFilter3 = new EmployeeModel { Name = Constants.WORKBOOK_NAME, Value = "e", Operator = "contains", Bitwise = "and" }; wbList.Add(wbFilter1); wbList.Add(wbFilter2); wbList.Add(wbFilter3); WorkbookResponse wbResponse = function.GetWorkbookQueryBuilder(wbRequest, null); List <WorkbookModel> workbookList = wbResponse.Workbooks; Assert.AreNotEqual(0, workbookList.Count); Assert.AreNotEqual("", workbookList[0].WorkBookId); Assert.IsTrue(workbookList[0].WorkBookId >= 40); StringAssert.Matches(workbookList[0].WorkBookName, new Regex(@"(?i)\b(.*?)e(.*?)\b")); }
public void GetWorkbooksForInvalidCompany() { List <EmployeeModel> wbList = new List <EmployeeModel>(); Function function = new Function(); QueryBuilderRequest wbRequest = new QueryBuilderRequest { CompanyId = 8, // Valid one is 6 UserId = 6, Payload = new QueryBuilderRequest { ColumnList = new string[] { Constants.WORKBOOK_ID, Constants.WORKBOOK_NAME, Constants.DESCRIPTION, Constants.WORKBOOK_CREATED_BY, Constants.DAYS_TO_COMPLETE }, Fields = wbList, EntityName = "Workbook", AppType = Constants.QUERY_BUILDER } }; EmployeeModel wbFilter1 = new EmployeeModel { Name = Constants.WORKBOOK_ID, Value = "40", Operator = ">=" }; EmployeeModel wbFilter2 = new EmployeeModel { Name = Constants.WORKBOOK_CREATED, Value = "01/21/2001", Operator = "<=", Bitwise = "and" }; EmployeeModel wbFilter3 = new EmployeeModel { Name = Constants.WORKBOOK_NAME, Value = "e", Operator = "contains", Bitwise = "and" }; wbList.Add(wbFilter1); wbList.Add(wbFilter2); wbList.Add(wbFilter3); WorkbookResponse wbResponse = function.GetWorkbookQueryBuilder(wbRequest, null); ErrorResponse workbookList = wbResponse.Error; Assert.AreEqual(403, workbookList.Status); Assert.AreEqual(14, workbookList.Code); StringAssert.Contains(workbookList.Message, TestConstants.PERMISSION_DENIED); }
public void GetDashboardForAUser() { List <EmployeeModel> wbList = new List <EmployeeModel>(); TestExecution testExecute = new TestExecution(); string[] ColumnList = new string[] { Constants.USERID, Constants.SUPERVISOR_ID, Constants.EMPLOYEE_NAME, Constants.ROLE, Constants.ASSIGNED_WORKBOOK, Constants.WORKBOOK_DUE, Constants.PAST_DUE_WORKBOOK, Constants.COMPLETED_WORKBOOK, Constants.TOTAL_EMPLOYEES }; EmployeeModel wbFilter1 = testExecute.CreateFields(Constants.SUPERVISOR_ID, "331535", "=", ""); EmployeeModel wbFilter2 = testExecute.CreateFields(Constants.CURRENT_USER, "331535", "=", "AND"); wbList.Add(wbFilter1); wbList.Add(wbFilter2); WorkbookResponse wbResponse = testExecute.ExecuteTests(2288, 331535, ColumnList, Constants.WORKBOOK_DASHBOARD, wbList); List <WorkbookModel> workbookList = wbResponse.Workbooks; Assert.IsTrue(workbookList.Count > 0); }
public void GetTasksProgressForAWorkbook() { List <EmployeeModel> wbList = new List <EmployeeModel>(); TestExecution testExecute = new TestExecution(); string[] ColumnList = new string[] { Constants.USERID, Constants.WORKBOOK_ID, Constants.TASK_ID, Constants.TASK_CODE, Constants.TASK_NAME, Constants.COMPLETED_TASK, Constants.INCOMPLETE_TASK, Constants.TOTAL_TASK }; EmployeeModel wbFilter1 = testExecute.CreateFields(Constants.USERID, "384666", "=", ""); EmployeeModel wbFilter2 = testExecute.CreateFields(Constants.WORKBOOK_ID, "22", "=", "AND"); wbList.Add(wbFilter1); wbList.Add(wbFilter2); WorkbookResponse wbResponse = testExecute.ExecuteTests(2288, 331535, ColumnList, Constants.WORKBOOK_DASHBOARD, wbList); List <WorkbookModel> workbookList = wbResponse.Workbooks; Assert.IsTrue(workbookList.Count > 0); }
public void GetWorkbooksForSpecificUserId() { List <EmployeeModel> wbList = new List <EmployeeModel>(); Function function = new Function(); QueryBuilderRequest wbRequest = new QueryBuilderRequest { CompanyId = 6, //1, //6, UserId = 6, //335216, //6, Payload = new QueryBuilderRequest { ColumnList = new string[] { Constants.USERID, Constants.WORKBOOK_ID, Constants.WORKBOOK_NAME, Constants.DESCRIPTION, Constants.WORKBOOK_CREATED_BY, Constants.DAYS_TO_COMPLETE }, Fields = wbList, EntityName = "Workbook", AppType = Constants.QUERY_BUILDER } }; EmployeeModel wbFilter1 = new EmployeeModel { Name = Constants.USERID, Value = "10", Operator = ">=" }; EmployeeModel wbFilter2 = new EmployeeModel { Name = Constants.STUDENT_DETAILS, Value = "10", Operator = "=", Bitwise = "AND" }; wbList.Add(wbFilter1); //wbList.Add(wbFilter2); WorkbookResponse wbResponse = function.GetWorkbookQueryBuilder(wbRequest, null); List <WorkbookModel> workbookList = wbResponse.Workbooks; Assert.AreNotEqual(0, workbookList.Count); Assert.IsTrue(workbookList[workbookList.Count - 1].UserId >= 10); }
public void GetWorkbooksForInvalidInputs() { List <EmployeeModel> wbList = new List <EmployeeModel>(); Function function = new Function(); QueryBuilderRequest wbRequest = new QueryBuilderRequest { CompanyId = 6, UserId = 6, Payload = new QueryBuilderRequest { ColumnList = new string[] { Constants.WORKBOOK_ID, Constants.WORKBOOK_NAME, Constants.DESCRIPTION, Constants.WORKBOOK_CREATED_BY, Constants.DAYS_TO_COMPLETE }, Fields = wbList, EntityName = "Workbook", AppType = Constants.QUERY_BUILDER } }; EmployeeModel wbFilter1 = new EmployeeModel { Name = Constants.WORKBOOK_ID, Value = "40", Operator = ">=" }; EmployeeModel wbFilter2 = new EmployeeModel { Name = Constants.WORKBOOK_CREATED, Value = "ITS-LMS", Operator = "<=", Bitwise = "and" }; wbList.Add(wbFilter1); wbList.Add(wbFilter2); WorkbookResponse wbResponse = function.GetWorkbookQueryBuilder(wbRequest, null); List <WorkbookModel> workbookList = wbResponse.Workbooks; Assert.AreEqual(0, workbookList.Count); Assert.ThrowsException <ArgumentOutOfRangeException>(() => workbookList[0]); }
public void RepititionsDetailForUnattemptedTask() { List <EmployeeModel> wbList = new List <EmployeeModel>(); TestExecution testExecute = new TestExecution(); string[] ColumnList = new string[] { Constants.NUMBER_OF_ATTEMPTS, Constants.STATUS, Constants.LAST_ATTEMPT_DATE, Constants.LOCATION, Constants.EVALUATOR_NAME, Constants.COMMENTS }; EmployeeModel wbFilter1 = testExecute.CreateFields(Constants.USERID, "384666", "=", ""); EmployeeModel wbFilter2 = testExecute.CreateFields(Constants.STATUS, Constants.COMPLETED, "=", "AND"); EmployeeModel wbFilter4 = testExecute.CreateFields(Constants.WORKBOOK_ID, "22", "=", "AND"); EmployeeModel wbFilter3 = testExecute.CreateFields(Constants.TASK_ID, "32934", "=", "AND"); wbList.Add(wbFilter1); wbList.Add(wbFilter2); wbList.Add(wbFilter3); wbList.Add(wbFilter4); WorkbookResponse wbResponse = testExecute.ExecuteTests(2288, 331535, ColumnList, Constants.WORKBOOK_DASHBOARD, wbList); List <WorkbookModel> workbookList = wbResponse.Workbooks; Assert.IsTrue(workbookList.Count == 0); }
public void GetWorkbooksWithAdditionalColumns() { List <EmployeeModel> wbList = new List <EmployeeModel>(); Function function = new Function(); QueryBuilderRequest wbRequest = new QueryBuilderRequest { CompanyId = 6, UserId = 6, Payload = new QueryBuilderRequest { ColumnList = new string[] { Constants.WORKBOOK_ID, Constants.WORKBOOK_NAME, Constants.DESCRIPTION, Constants.WORKBOOK_CREATED_BY, Constants.DAYS_TO_COMPLETE, Constants.WORKBOOK_ASSIGNED_DATE, Constants.REPETITIONS, Constants.LAST_ATTEMPT_DATE }, Fields = wbList, EntityName = "Workbook", AppType = Constants.QUERY_BUILDER } }; EmployeeModel wbFilter1 = new EmployeeModel { Name = Constants.WORKBOOK_ID, Value = "40", Operator = ">=" }; EmployeeModel wbFilter2 = new EmployeeModel { Name = Constants.WORKBOOK_CREATED, Value = "01/21/2001", Operator = "<=", Bitwise = "and" }; EmployeeModel wbFilter3 = new EmployeeModel { Name = Constants.WORKBOOK_NAME, Value = "e", Operator = "contains", Bitwise = "and" }; wbList.Add(wbFilter1); wbList.Add(wbFilter2); wbList.Add(wbFilter3); Dictionary <string, string> pathValues = new Dictionary <string, string> { { "companyId", "6" } }; APIGatewayProxyRequest aPIGatewayProxyRequest = new APIGatewayProxyRequest { Body = JsonConvert.SerializeObject(wbRequest), PathParameters = pathValues }; WorkbookResponse wbResponse = function.GetWorkbookQueryBuilder(wbRequest, null); List <WorkbookModel> workbookList = wbResponse.Workbooks; Assert.AreNotEqual(0, workbookList.Count); Assert.AreNotEqual(null, workbookList[0].WorkBookId); Assert.IsTrue(workbookList[0].WorkBookId >= 40); Assert.AreNotEqual(null, workbookList[0].WorkbookAssignedDate); Assert.AreNotEqual(null, workbookList[0].Repetitions); Assert.AreNotEqual(null, workbookList[0].LastAttemptDate); StringAssert.Matches(workbookList[0].WorkBookName, new Regex(@"(?i)\b(.*?)e(.*?)\b")); }
/// <summary> /// Get list of workbook(s) based on input field and column(s) for specific company [QueryBuilder] /// </summary> /// <param name="queryBuilderRequest"></param> /// <returns>WorkbookResponse</returns> public WorkbookResponse GetWorkbookDetails(QueryBuilderRequest queryBuilderRequest) { string query = string.Empty; int companyId = 0; Dictionary <string, string> parameterList; WorkbookResponse workbookResponse = new WorkbookResponse(); string userId = string.Empty; string status = string.Empty; string workbookID = string.Empty; string taskId = string.Empty, role = string.Empty; try { if (queryBuilderRequest.CompanyId == 0) { throw new ArgumentException("CompanyId"); } if (queryBuilderRequest.UserId == 0) { throw new ArgumentException("UserId"); } if (queryBuilderRequest.Payload == null) { throw new ArgumentException("Fields and ColumnList"); } if (queryBuilderRequest.Payload.Fields == null) { throw new ArgumentException("Fields "); } if (queryBuilderRequest.Payload.ColumnList == null) { throw new ArgumentException("Columns"); } //Assign the request details to corresponding objects companyId = Convert.ToInt32(queryBuilderRequest.CompanyId); queryBuilderRequest = queryBuilderRequest.Payload; //Assign the companyId to the new object queryBuilderRequest.CompanyId = companyId; parameterList = ParameterHelper.Getparameters(queryBuilderRequest); role = Convert.ToString(parameterList["roles"]); if (queryBuilderRequest.AppType == Constants.WORKBOOK_DASHBOARD) { if (queryBuilderRequest.Fields.Where(x => x.Name == Constants.WORKBOOK_DETAILS).Select(y => y.Name).FirstOrDefault() == Constants.WORKBOOK_DETAILS) { userId = parameterList["userId"].ToString(); query = "EXEC dbo.Training_OJT_Dashboard_GetDashboardSummary @companyId =" + companyId + " , @supervisorId = " + userId + " , @showTopLevel = " + CheckSupervisor(companyId, Convert.ToInt32(userId)); } else if (queryBuilderRequest.Fields.Where(x => x.Name == Constants.WORKBOOK_IN_DUE).Select(y => y.Name).FirstOrDefault() == Constants.WORKBOOK_IN_DUE) { userId = parameterList["userId"].ToString(); query = "EXEC dbo.Training_OJT_Dashboard_GetAssignedOJTs @companyId =" + companyId + " , @supervisorId = " + userId + ", @dueInDays = " + parameterList["duedays"].ToString() + ",@status = 0"; } else if (queryBuilderRequest.Fields.Where(x => x.Name == Constants.PAST_DUE).Select(y => y.Name).FirstOrDefault() == Constants.PAST_DUE) { userId = parameterList["userId"].ToString(); query = "EXEC dbo.Training_OJT_Dashboard_GetAssignedOJTs @companyId =" + companyId + " , @supervisorId = " + userId + ", @dueInDays = " + parameterList["duedays"].ToString() + " ,@status = 1"; } else if (queryBuilderRequest.Fields.Where(x => x.Name == Constants.COMPLETED).Select(y => y.Name).FirstOrDefault() == Constants.COMPLETED) { userId = parameterList["userId"].ToString(); query = "EXEC dbo.Training_OJT_Dashboard_GetAssignedOJTs @companyId =" + companyId + " , @supervisorId = " + userId + " , @status = " + 2; } else if (queryBuilderRequest.Fields.Where(x => x.Name == Constants.ASSIGNED_WORKBOOK).Select(y => y.Name).FirstOrDefault() == Constants.ASSIGNED_WORKBOOK) { userId = parameterList["userId"].ToString(); query = "EXEC dbo.Training_OJT_Dashboard_GetAssignedOJTs @companyId =" + companyId + " , @supervisorId = " + userId; } else if (queryBuilderRequest.Fields.Where(x => x.Name == Constants.TASK_PROGRESS).Select(y => y.Name).FirstOrDefault() == Constants.TASK_PROGRESS) { userId = parameterList["userId"].ToString(); workbookID = parameterList["workbookId"].ToString(); query = "EXEC dbo.Training_OJT_Dashboard_GetTaskProgress @companyId =" + companyId + " , @studentId = " + userId + ", @OJTId =" + workbookID; } else if (queryBuilderRequest.Fields.Where(x => x.Name == Constants.REP_PROGRESS).Select(y => y.Name).FirstOrDefault() == Constants.REP_PROGRESS) { userId = parameterList["userId"].ToString(); workbookID = parameterList["workbookId"].ToString(); taskId = parameterList["taskId"].ToString(); string tag = queryBuilderRequest.Fields.Where(x => x.Name == Constants.STATUS).Select(y => y.Value).FirstOrDefault(); status = tag == Constants.COMPLETED ? "1" : tag == Constants.FAILED ? "0" : "null"; query = "EXEC dbo.Training_OJT_Dashboard_GetRepProgress @companyId =" + companyId + " , @studentId = " + userId + ", @OJTId =" + workbookID + ", @taskId=" + taskId + ", @completionStatus=" + status; } if (!string.IsNullOrEmpty(query) && !string.IsNullOrEmpty(role)) { query += " , @roleId = " + role; } } else { query = CreateWorkbookQuery(queryBuilderRequest); } //Read the SQL Parameters value //Create the dictionary to pass the parameter value workbookResponse.Workbooks = ReadWorkBookDetails(query, parameterList); //Send the response depends upon the workboook details if (workbookResponse.Workbooks != null) { return(workbookResponse); } else { workbookResponse.Error = ResponseBuilder.InternalError(); return(workbookResponse); } } catch (Exception getEmployeeDetails) { LambdaLogger.Log(getEmployeeDetails.ToString()); workbookResponse.Error = new ExceptionHandler(getEmployeeDetails).ExceptionResponse(); return(workbookResponse); } }