ATUL_v1.Atul_v1Data.FlexFieldGetBySearch C# (CSharp) Method

        public DataTable FlexFieldGetBySearch(long? AtulProcessID, long? AtulSubProcessID, long? AtulActivityID)
        {
            if (AtulProcessID == 0)
            {
                AtulProcessID = null;
            }
            if (AtulSubProcessID == 0)
            {
                AtulSubProcessID = null;
            }
            if (AtulActivityID == 0)
            {
                AtulActivityID = null;
            }

            SqlCommand cmd = new SqlCommand("exec dbo.Atul_FlexFieldGetBySearch_sp @AtulProcessID, @AtulSubProcessID, @AtulActivityID", this._connection);
            cmd.Parameters.Add(new SqlParameter("@AtulProcessID", AtulProcessID));
            cmd.Parameters.Add(new SqlParameter("@AtulSubProcessID", AtulSubProcessID));
            cmd.Parameters.Add(new SqlParameter("@AtulActivityID", AtulActivityID));
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable returnTable = new DataTable(); returnTable.TableName = "FlexFields";
            da.Fill(returnTable);
            return returnTable;
        }

 //needs nullable
 /// <summary>
 /// get the Flexfield by search.
 /// </summary>
 /// <param name="AtulProcessID">The atul process ID.</param>
 /// <param name="AtulSubProcessID">The atul sub process ID.</param>
 /// <param name="AtulActivityID">The atul activity ID.</param>
 /// <returns></returns>
 public string FlexFieldGetBySearch(long? AtulProcessID, long? AtulSubProcessID, long? AtulActivityID)
 {
     DataTable returnTable = new DataTable();
     Atul_v1Data adb = new Atul_v1Data();
     returnTable = adb.FlexFieldGetBySearch(AtulProcessID, AtulSubProcessID, AtulActivityID);
     return JsonMethods.GetJSONString(returnTable);
 }