public List <WorkflowSub> getSortedWorflowSubByWorkflowIDandType(int workflowID, string type)
        {
            List <WorkflowSub> toReturn = new List <WorkflowSub>();
            SqlConnection      conn     = new SqlConnection();
            WorkflowSub        wfs      = null;

            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_Sub] where wfid=@wfid and type=@type order by criteria_lower_limit asc";
                comm.Parameters.AddWithValue("@wfid", workflowID);
                comm.Parameters.AddWithValue("@type", type);
                SqlDataReader dr = comm.ExecuteReader();
                while (dr.Read())
                {
                    wfs = new WorkflowSub();
                    wfs.setMainWF(wfDAO.getWorkflowByID(workflowID));
                    wfs.setAmount_low((double)(dr["criteria_lower_limit"]));
                    wfs.setAmount_high((double)(dr["criteria_upper_limit"]));
                    wfs.setWorkflowSubID((int)dr["wf_sub_id"]);
                    toReturn.Add(wfs);
                }
                dr.Close();
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                conn.Close();
            }
            return(toReturn);
        }
        public WorkflowSub getWorkflowSubByID(string wf_sub_ID)
        {
            SqlConnection conn     = new SqlConnection();
            WorkflowSub   toReturn = null;

            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_sub] where wf_sub_id=@wf_sub_id";
                comm.Parameters.AddWithValue("@wf_sub_id", wf_sub_ID);
                SqlDataReader dr = comm.ExecuteReader();
                while (dr.Read())
                {
                    toReturn = new WorkflowSub();
                    Workflow wf = wfDAO.getWorkflowByID((string)dr["wfid"]);
                    toReturn.setMainWF(wf);

                    toReturn.setWfSubName(((string)dr["wf_sub_name"]));
                    toReturn.setAmount_low(Convert.ToSingle(dr["criteria_lower_limit"]));
                    toReturn.setAmount_high(Convert.ToSingle(dr["criteria_upper_limit"]));
                    toReturn.setWorkflowSubID((string)dr["wf_sub_id"]);
                }
                dr.Close();
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                conn.Close();
            }
            return(toReturn);
        }