public static string getJobStatus(string request) { SatyamJobSubmissionsTableAccess dbaccess = new SatyamJobSubmissionsTableAccess(); List <SatyamJobSubmissionsTableAccessEntry> entries = dbaccess.getAllEntriesByUserID(request); string JsonString = JSonUtils.ConvertObjectToJSon(entries); dbaccess.close(); return(JsonString); }
private void populateRows() { SatyamJobSubmissionsTableAccess dbaccess = new SatyamJobSubmissionsTableAccess(); List <SatyamJobSubmissionsTableAccessEntry> entries = dbaccess.getAllEntriesByUserID(UserId); dbaccess.close(); List <TableRow> rows = new List <TableRow>(); int maxShow = 10; for (int i = entries.Count - 1; i >= Math.Max(0, entries.Count - 1 - maxShow); i--) { TableRow row = new TableRow(); row.JobGUID = entries[i].JobGUID; row.JobTemplateType = entries[i].JobTemplateType; row.JobSubmitTime = entries[i].JobSubmitTime.ToLocalTime().ToString(); row.JobStatus = entries[i].JobStatus; SatyamTaskTableAccess taskDB = new SatyamTaskTableAccess(); int remainingTasks = taskDB.getTasksCountByGUID(row.JobGUID); taskDB.close(); row.TaskPending = remainingTasks.ToString(); if (entries[i].JobProgress == "") { row.JobProgress = "1"; } else { row.JobProgress = (1 - (double)remainingTasks / Convert.ToDouble(entries[i].JobProgress)).ToString("0.000"); } int totalResults, totalAggregated; row.ApprovalRate = SatyamResultsAnalysis.getPaymentRateByGUID(row.JobGUID, out totalResults, out totalAggregated).ToString("0.000"); row.TotalResults = totalResults.ToString(); row.TotalAggregated = totalAggregated.ToString(); rows.Add(row); } rpt.DataSource = rows; rpt.DataBind(); }