public UpdateProcessSubProcess ( long ProcessSubProcessID, long ProcessID, long SubProcessID, int sort, int responsibilityOf, int DeadlineOffset, int ModifiedBy, long NotificationServiceProviderID ) : bool | ||
ProcessSubProcessID | long | The process sub process ID. |
ProcessID | long | The process ID. |
SubProcessID | long | The sub process ID. |
sort | int | The sort. |
responsibilityOf | int | The responsibility of. |
DeadlineOffset | int | The deadline offset. |
ModifiedBy | int | The modified by. |
NotificationServiceProviderID | long | The notification service provider ID. |
return | bool |
public bool UpdateProcessSubProcess(long ProcessSubProcessID, long ProcessID, long SubProcessID, int sort, int responsibilityOf, int DeadlineOffset, int ModifiedBy, long? NotificationServiceProviderID)
{
SqlCommand cmd = new SqlCommand("exec dbo.Atul_ProcessSubprocessUpdate_sp @AtulProcessSubprocessID, @AtulProcessID, @AtulSubProcessID, @ProcessSubprocessSortOrder, @ResponsibilityOf, @DeadlineOffset, @ModifiedBy, @NotificationServiceProviderID", this._connection);
cmd.Parameters.Add(new SqlParameter("@AtulProcessSubprocessID", ProcessSubProcessID));
cmd.Parameters.Add(new SqlParameter("@AtulProcessID", ProcessID));
cmd.Parameters.Add(new SqlParameter("@AtulSubProcessID", SubProcessID));
cmd.Parameters.Add(new SqlParameter("@ProcessSubprocessSortOrder", sort));
cmd.Parameters.Add(new SqlParameter("@ResponsibilityOf", responsibilityOf));
cmd.Parameters.Add(new SqlParameter("@DeadlineOffset", DeadlineOffset));
cmd.Parameters.Add(new SqlParameter("@ModifiedBy", ModifiedBy));
cmd.Parameters.Add(new SqlParameter("@NotificationServiceProviderID", NotificationServiceProviderID));
bool success = Convert.ToBoolean(cmd.ExecuteNonQuery());
return success;
}
/// <summary> /// Updates the process sub process. /// </summary> /// <param name="ProcessSubProcessID">The process sub process ID.</param> /// <param name="ProcessID">The process ID.</param> /// <param name="SubProcessID">The sub process ID.</param> /// <param name="sort">The sort.</param> /// <param name="responsibilityOf">The responsibility of.</param> /// <param name="DeadlineOffset">The deadline offset.</param> /// <param name="ModifiedBy">The modified by.</param> /// <param name="NotificationServiceProviderID">The notification service provider ID.</param> /// <returns></returns> public bool UpdateProcessSubProcess(long ProcessSubProcessID, long ProcessID, long SubProcessID, int sort, int responsibilityOf, int DeadlineOffset, int ModifiedBy, long? NotificationServiceProviderID) { bool success = false; if (NotificationServiceProviderID == 0) { NotificationServiceProviderID = null; } Atul_v1Data adb = new Atul_v1Data(); success = adb.UpdateProcessSubProcess(ProcessSubProcessID, ProcessID, SubProcessID, sort, responsibilityOf, DeadlineOffset, ModifiedBy, NotificationServiceProviderID); if (success && NotificationServiceProviderID != null) { // this.AddSubProcessProviderParameters(Convert.ToInt64(NotificationServiceProviderID), SubProcessID); } return success; }