//TO EDIT public List <WorkflowApprover> getSortedWorkflowApprovers(string workflowID, string workflow_subID) { List <WorkflowApprover> toReturn = new List <WorkflowApprover>(); SqlConnection conn = new SqlConnection(); WorkflowApprover approver = null; UserDAO userDAO = new UserDAO(); try { conn = new SqlConnection(); string connstr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString(); conn.ConnectionString = connstr; conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; comm.CommandText = "select * from [Workflow_approvers] where wfid=@wfid and wfsid=@wfsid order by level asc"; comm.Parameters.AddWithValue("@wfid", workflowID); comm.Parameters.AddWithValue("@wfsid", workflow_subID); SqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) { approver = new WorkflowApprover(); string wfid = (string)dr["wfid"]; Workflow wf = wfDAO.getWorkflowByID(wfid); approver.setMainWF(wf); string wfsid = (string)dr["wf_sub_id"]; WorkflowSub wfs = wfsDAO.getWorkflowSubByID(wfsid); approver.setMainWFS(wfs); string userID = (string)dr["userID"]; User user = userDAO.getUserByID(userID); approver.setApprover(user); approver.setLevel((int)dr["levels"]); toReturn.Add(approver); } dr.Close(); } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(toReturn); }
public WorkflowApprover getWorkflowApproverByJobCategory(string jobCategory, int wfid, int wf_sub_id) { WorkflowApprover toReturn = new WorkflowApprover(); SqlConnection conn = new SqlConnection(); UserDAO userDAO = new UserDAO(); try { conn = new SqlConnection(); string connstr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString(); conn.ConnectionString = connstr; conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; comm.CommandText = "select * from [Workflow_approvers] where job_category=@job_category and wfid=@wfid and wf_sub_id=@wf_sub_id"; comm.Parameters.AddWithValue("@job_category", jobCategory); comm.Parameters.AddWithValue("@wfid", wfid); comm.Parameters.AddWithValue("@wf_sub_id", wf_sub_id); SqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) { int wf_id = (int)dr["wfid"]; Workflow wf = wfDAO.getWorkflowByID(wf_id); toReturn.setMainWF(wf); int wfsid = (int)dr["wf_sub_id"]; WorkflowSub wfs = wfsDAO.getWorkflowSubByID(wfsid); toReturn.setMainWFS(wfs); toReturn.setJobCategory((string)dr["job_category"]); toReturn.setLevel((int)dr["levels"]); } dr.Close(); } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(toReturn); }