ATUL_v1.Atul_v1Data.UpdateInstanceProcessActivity C# (CSharp) Method

        public DataTable UpdateInstanceProcessActivity(int AtulInstanceProcessActivityID, int AtulInstanceProcessID, int AtulProcessActivityID, int ProcessActivityCompleted, int ProcessActivityDidNotApply, int ProcessActivityDeadlineMissed, int InstanceProcessActivityCompletedBy, int ModifiedBy)
        {
            SqlCommand cmd = new SqlCommand("exec dbo.Atul_InstanceProcessActivityUpdate_sp @AtulInstanceProcessActivityID, @AtulInstanceProcessID, @AtulProcessActivityID, @ProcessActivityCompleted, @ProcessActivityDidNotApply, @ProcessActivityDeadlineMissed, @InstanceProcessActivityCompletedBy, @ModifiedBy", this._connection);
            cmd.Parameters.Add(new SqlParameter("@AtulInstanceProcessActivityID", AtulInstanceProcessActivityID));
            cmd.Parameters.Add(new SqlParameter("@AtulInstanceProcessID", AtulInstanceProcessID));
            cmd.Parameters.Add(new SqlParameter("@AtulProcessActivityID", AtulProcessActivityID));
            cmd.Parameters.Add(new SqlParameter("@ProcessActivityCompleted", ProcessActivityCompleted));
            cmd.Parameters.Add(new SqlParameter("@ProcessActivityDidNotApply", ProcessActivityDidNotApply));
            cmd.Parameters.Add(new SqlParameter("@ProcessActivityDeadlineMissed", ProcessActivityDeadlineMissed));
            cmd.Parameters.Add(new SqlParameter("@InstanceProcessActivityCompletedBy", InstanceProcessActivityCompletedBy));
            cmd.Parameters.Add(new SqlParameter("@ModifiedBy", ModifiedBy));
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable returnTable = new DataTable(); returnTable.TableName = "atultbl";
            da.Fill(returnTable);
            return returnTable;
        }

 /// <summary>
 /// Updates the instance process activity.
 /// </summary>
 /// <param name="AtulInstanceProcessActivityID">The atul instance process activity ID.</param>
 /// <param name="AtulInstanceProcessID">The atul instance process ID.</param>
 /// <param name="AtulProcessActivityID">The atul process activity ID.</param>
 /// <param name="ProcessActivityCompleted">The process activity completed.</param>
 /// <param name="ProcessActivityDidNotApply">The process activity did not apply.</param>
 /// <param name="ProcessActivityDeadlineMissed">The process activity deadline missed.</param>
 /// <param name="InstanceProcessActivityCompletedBy">The instance process activity completed by.</param>
 /// <param name="ModifiedBy">The modified by.</param>
 /// <returns></returns>
 public string UpdateInstanceProcessActivity(string AtulInstanceProcessActivityID, string AtulInstanceProcessID, string AtulProcessActivityID, string ProcessActivityCompleted, string ProcessActivityDidNotApply, string ProcessActivityDeadlineMissed, string InstanceProcessActivityCompletedBy, string ModifiedBy)
 {
     DataTable returnTable = new DataTable();
     Atul_v1Data adb = new Atul_v1Data();
     returnTable = adb.UpdateInstanceProcessActivity(Convert.ToInt32(AtulInstanceProcessActivityID), Convert.ToInt32(AtulInstanceProcessID), Convert.ToInt32(AtulProcessActivityID), Convert.ToInt32(ProcessActivityCompleted), Convert.ToInt32(ProcessActivityDidNotApply), Convert.ToInt32(ProcessActivityDeadlineMissed), Convert.ToInt32(InstanceProcessActivityCompletedBy), Convert.ToInt32(ModifiedBy));
     return JsonMethods.GetJSONString(returnTable);
 }