ATUL_v1.Atul_v1Data.UpdateProcess C# (CSharp) Method

UpdateProcess() public method

public UpdateProcess ( long ProcessID, string ProcessDescription, string ProcessSummary, int ModifiedBy, int OwnedBy, int AtulProcessStatusID, int DeadLineOffset, long SubjectServiceProviderID, string ScopeID ) : bool
ProcessID long
ProcessDescription string
ProcessSummary string
ModifiedBy int
OwnedBy int
AtulProcessStatusID int
DeadLineOffset int
SubjectServiceProviderID long
ScopeID string
return bool
        public bool UpdateProcess(long ProcessID, string ProcessDescription, string ProcessSummary, int ModifiedBy, int OwnedBy, int AtulProcessStatusID, int DeadLineOffset, long? SubjectServiceProviderID, string ScopeID)
        {
            SqlCommand cmd = new SqlCommand("exec dbo.Atul_ProcessUpdate_sp @AtulProcessID, @ProcessDescription, @ProcessSummary, @ModifiedBy, @OwnedBy, @AtulProcessStatusID, @DeadLineOffset, @SubjectServiceProviderID, @SubjectScopeIdentifier", this._connection);
            cmd.Parameters.Add(new SqlParameter("@AtulProcessID", ProcessID));
            cmd.Parameters.Add(new SqlParameter("@ProcessDescription", ProcessDescription));
            cmd.Parameters.Add(new SqlParameter("@ProcessSummary", ProcessSummary));
            cmd.Parameters.Add(new SqlParameter("@ModifiedBy", ModifiedBy));
            cmd.Parameters.Add(new SqlParameter("@OwnedBy", OwnedBy));
            cmd.Parameters.Add(new SqlParameter("@AtulProcessStatusID", AtulProcessStatusID));
            cmd.Parameters.Add(new SqlParameter("@DeadLineOffset", DeadLineOffset));
            cmd.Parameters.Add(new SqlParameter("@SubjectServiceProviderID", SubjectServiceProviderID));
            cmd.Parameters.Add(new SqlParameter("@SubjectScopeIdentifier", ScopeID));
            bool success = Convert.ToBoolean(cmd.ExecuteNonQuery());
            return success;
        }

Usage Example

Example #1
0
 public bool UpdateProcess(long ProcessID, string ProcessDescription, string ProcessSummary, int ModifiedBy, int OwnedBy, int AtulProcessStatusID, int DeadLineOffset, long? SubjectServiceProviderID, string ScopeID)
 {
     bool success = false;
     Atul_v1Data adb = new Atul_v1Data();
     success = adb.UpdateProcess(ProcessID, ProcessDescription, ProcessSummary, ModifiedBy, OwnedBy, AtulProcessStatusID, DeadLineOffset, SubjectServiceProviderID, ScopeID);
     return success;
 }
Atul_v1Data