ATUL_v1.Atul_v1Data.GetProcessBySummary C# (CSharp) Метод

        public Process GetProcessBySummary(string ProcessSummary)
        {
            Process p = new Process();
            SqlCommand cmd = new SqlCommand("exec dbo.Atul_ProcessGetByProcessSummary_sp @ProcessSummary", this._connection);
            cmd.Parameters.Add(new SqlParameter("@ProcessSummary", ProcessSummary));
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable returnTable = new DataTable(); returnTable.TableName = "process";
            da.Fill(returnTable);
            DataRow r = returnTable.Rows[0];
            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.DeadLineOffset = (int)r["DeadLineOffset"];
            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.ProcessDescription = r["ProcessDescription"].ToString();
            p.ProcessStatus = r["ProcessStatus"].ToString();
            p.ProcessSummary = r["ProcessSummary"].ToString();
            long providerid;
            if (Int64.TryParse(r["SubjectServiceProviderID"].ToString(), out providerid))
            {
                p.SubjectServiceProviderID = providerid;
            }
            return p;
        }

 public Process GetProcessBySummary(string ProcessSummary)
 {
     Process p;
     Atul_v1Data adb = new Atul_v1Data();
     p = adb.GetProcessBySummary(ProcessSummary);
     return p;
 }