ATUL_v1.Atul_v1Data.UpdateActivity C# (CSharp) Method

UpdateActivity() public method

public UpdateActivity ( long AtulActivityID, long AtulSubProcessID, string ActivityDescription, string ActivitySummary, string ActivityProcedure, int AtulActivitySortOrder, int ModifiedBy, int OwnedBy ) : bool
AtulActivityID long
AtulSubProcessID long
ActivityDescription string
ActivitySummary string
ActivityProcedure string
AtulActivitySortOrder int
ModifiedBy int
OwnedBy int
return bool
        public bool UpdateActivity(long AtulActivityID, long AtulSubProcessID, string ActivityDescription, string ActivitySummary, string ActivityProcedure, int AtulActivitySortOrder, int ModifiedBy, int OwnedBy)
        {
            SqlCommand cmd = new SqlCommand("exec dbo.Atul_ActivityUpdate_sp @AtulActivityID, @AtulSubProcessID, @ActivityDescription, @ActivitySummary, @ActivityProcedure, @AtulActivitySortOrder, @ModifiedBy, @OwnedBy", this._connection);
            cmd.Parameters.Add(new SqlParameter("@AtulActivityID", AtulActivityID));
            cmd.Parameters.Add(new SqlParameter("@AtulSubProcessID", AtulSubProcessID));
            cmd.Parameters.Add(new SqlParameter("@ActivityDescription", ActivityDescription));
            cmd.Parameters.Add(new SqlParameter("@ActivitySummary", ActivitySummary));
            cmd.Parameters.Add(new SqlParameter("@ActivityProcedure", ActivityProcedure));
            cmd.Parameters.Add(new SqlParameter("@AtulActivitySortOrder", AtulActivitySortOrder));
            cmd.Parameters.Add(new SqlParameter("@ModifiedBy", ModifiedBy));
            cmd.Parameters.Add(new SqlParameter("@OwnedBy", OwnedBy));

            bool success = Convert.ToBoolean(cmd.ExecuteNonQuery());
            return success;
        }

Usage Example

コード例 #1
0
ファイル: AtulBusinessLogic.cs プロジェクト: godaddy/ATUL
 public bool UpdateActivity(long AtulActivityID, long AtulSubProcessID, string ActivityDescription, string ActivitySummary, string ActivityProcedure, int AtulActivitySortOrder, int ModifiedBy, int OwnedBy)
 {
     bool success = false;
     Atul_v1Data adb = new Atul_v1Data();
     success = adb.UpdateActivity(AtulActivityID, AtulSubProcessID, ActivityDescription, ActivitySummary, ActivityProcedure, AtulActivitySortOrder, ModifiedBy, OwnedBy);
     return success;
 }
Atul_v1Data