public void BuildApprovers() { System.Data.SqlClient.SqlConnection cn = new System.Data.SqlClient.SqlConnection(db); System.Data.SqlClient.SqlCommand cmd; StringBuilder sb = new StringBuilder(); dApprover da = null; List <dApprover> listDa = new List <dApprover>(); try { cn.Open(); cmd = new System.Data.SqlClient.SqlCommand("BuildApprovers", cn); cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; System.Data.SqlClient.SqlDataReader dr; cmd.Parameters.AddWithValue("@pir_id", this.PIRID); cmd.Parameters.AddWithValue("@reqEmail", this.Email); dr = cmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); do { da = new dApprover(); da.PIRID = dr["pir_id"].ToString(); da.GUID = dr["GUID"].ToString(); da.ApproveDate = dr["approve_date"].ToString(); da.DenyDate = dr["deny_date"].ToString(); da.ProcessID = dr["step_id"].ToString(); da.StepName = dr["step_name"].ToString(); da.StepOrder = dr["step_order"].ToString(); sb.Append("<div class=\"row\"><div class=\"col-sm-4\"><b>" + da.StepName + "</b></div><div class=\"col-sm-4\">" + da.StepStatus + "</div><div class=\"col-sm-4\"> </div></div>"); listDa.Add(da); }while (dr.Read()); } this.Approvers = listDa; this.RollUp = sb.ToString(); SaveRollUp(); } catch (System.Data.SqlClient.SqlException ex) { this.Error = ex.Message; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } }
private List <dApprover> GetApprovers() { List <dApprover> rtn = new List <dApprover>(); System.Data.SqlClient.SqlConnection cn = new System.Data.SqlClient.SqlConnection(db); System.Data.SqlClient.SqlCommand cmd; System.Data.SqlClient.SqlDataReader dr; dApprover da = null; try { cn.Open(); cmd = new System.Data.SqlClient.SqlCommand("GetApprovers", cn); cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pir_id", this.PIRID); dr = cmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); do { da = new dApprover(); da.PIRID = dr["pir_id"].ToString(); da.GUID = dr["GUID"].ToString(); da.ApproveDate = dr["approve_date"].ToString(); da.DenyDate = dr["deny_date"].ToString(); da.ProcessID = dr["step_id"].ToString(); da.StepName = dr["step_name"].ToString(); da.StepOrder = dr["step_order"].ToString(); rtn.Add(da); } while (dr.Read()); } } catch (System.Data.SqlClient.SqlException ex) { this.Error = ex.Message; return(null); } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } return(rtn); }