ATUL_v1.Atul_v1Data.ProcessInstanceGetDeleted C# (CSharp) Method

        public List<ProcessInstance> ProcessInstanceGetDeleted(DateTime startDate)
        {
            List<ProcessInstance> InstanceList = new List<ProcessInstance>();

            ProcessInstance p = new ProcessInstance();
            SqlCommand cmd = new SqlCommand("exec dbo.Atul_InstanceProcessGetDeleted_sp @startdate", this._connection);
            cmd.Parameters.Add(new SqlParameter("@startdate", startDate));
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable returnTable = new DataTable(); returnTable.TableName = "processinstance";
            da.Fill(returnTable);
            foreach (DataRow r in returnTable.Rows)
            {
                if (r != null)
                {
                    p.AtulInstanceProcessID = Convert.ToInt64(r["AtulInstanceProcessID"]);
                    p.AtulProcessID = Convert.ToInt64(r["AtulProcessID"]);
                    p.AtulProcessStatusID = (int)r["AtulProcessStatusID"];
                    p.CreatedBy = Convert.ToInt64(r["CreatedBy"]);
                    p.CreatedByName = r["CreatedByName"].ToString();
                    p.CreatedDate = Convert.ToDateTime(r["CreatedDate"]);
                    p.IsActive = Convert.ToBoolean(r["IsActive"]);
                    p.ModifiedBy = Convert.ToInt64(r["ModifiedBy"]);
                    p.ModifiedByName = r["ModifiedByName"].ToString();
                    if (r["ModifiedDate"] != DBNull.Value)
                    {
                        p.ModifiedDate = Convert.ToDateTime(r["ModifiedDate"]);
                    }
                    p.OwnedBy = Convert.ToInt64(r["OwnedBy"]);
                    p.OwnedByName = r["OwnedByName"].ToString();
                    p.ProcessStatus = r["ProcessStatus"].ToString();
                    p.ProcessStatus = r["ProcessStatus"].ToString();
                    p.ProcessSummary = r["ProcessSummary"].ToString();
                    long providerid;
                    if (Int64.TryParse(r["SubjectServiceProviderID"].ToString(), out providerid))
                    {
                        p.SubjectServiceProviderID = providerid;
                    }
                    p.SubjectSummary = r["SubjectSummary"].ToString();
                    InstanceList.Add(p);
                }
            }
            return InstanceList;
        }

 public List<ProcessInstance> ProcessInstanceGetDeleted(int daysBack)
 {
     List<ProcessInstance> InstanceList = new List<ProcessInstance>();
     DateTime d = DateTime.Now.AddDays(-(double)daysBack);
     Atul_v1Data adb = new Atul_v1Data();
     InstanceList = adb.ProcessInstanceGetDeleted(d);
     return InstanceList;
 }