public static void RecipientUpdateSent(int recipientId, int deliveryTypeId, bool sent)
{
DbHelper2.RunSp("SystemEventRecipientUpdateSent",
DbHelper2.mp("@RecipientId", SqlDbType.Int, recipientId),
DbHelper2.mp("@DeliveryTypeId", SqlDbType.Int, deliveryTypeId),
DbHelper2.mp("@Sent", SqlDbType.Bit, sent));
}
public static void UpdateUserException(int ExceptionId, DateTime FromDate, DateTime ToDate)
{
DbHelper2.RunSp("UserCalendarExceptionUpdate",
DbHelper2.mp("@ExceptionId", SqlDbType.Int, ExceptionId),
DbHelper2.mp("@FromDate", SqlDbType.DateTime, FromDate),
DbHelper2.mp("@ToDate", SqlDbType.DateTime, ToDate));
}
public virtual void Update()
{
if (_state == DataRowState.Modified)
{
DbHelper2.RunSp("mc_BusinessScoreUpdate"
, DbHelper2.mp("@BusinessScoreId", SqlDbType.Int, _BusinessScoreId)
, DbHelper2.mp("@Key", SqlDbType.NVarChar, 15, _Key)
, DbHelper2.mp("@Name", SqlDbType.NVarChar, 255, _Name)
);
}
else if (_state == DataRowState.Added)
{
SqlParameter outPutKey = new SqlParameter("@BusinessScoreId", SqlDbType.Int);
outPutKey.Direction = ParameterDirection.Output;
DbHelper2.RunSp("mc_BusinessScoreInsert", outPutKey
, DbHelper2.mp("@Key", SqlDbType.NVarChar, 15, _Key)
, DbHelper2.mp("@Name", SqlDbType.NVarChar, 255, _Name)
);
_BusinessScoreId = (int)outPutKey.Value;
}
}
public static void UpdateOutlineLevelAndNumber(int AccountId, int OutlineLevel, string OutlineNumber)
{
DbHelper2.RunSp("AccountUpdateOutlineLevelAndNumber",
DbHelper2.mp("@AccountId", SqlDbType.Int, AccountId),
DbHelper2.mp("@OutlineLevel", SqlDbType.Int, OutlineLevel),
DbHelper2.mp("@OutlineNumber", SqlDbType.VarChar, 255, OutlineNumber));
}
public static void Update(int CalendarId, string CalendarName, int TimeZoneId)
{
DbHelper2.RunSp("CalendarUpdate",
DbHelper2.mp("@CalendarId", SqlDbType.Int, CalendarId),
DbHelper2.mp("@CalendarName", SqlDbType.NVarChar, 250, CalendarName),
DbHelper2.mp("@TimeZoneId", SqlDbType.Int, TimeZoneId));
}
public static void DeleteReminderSubscriptionPersonalForObject(int DateTypeId, int UserId, int ObjectId)
{
DbHelper2.RunSp("ReminderSubscribtionDeletePersonalForObject",
DbHelper2.mp("@DateTypeId", SqlDbType.Int, DateTypeId),
DbHelper2.mp("@UserId", SqlDbType.Int, UserId),
DbHelper2.mp("@ObjectId", SqlDbType.Int, ObjectId));
}
public static void UpdateAccountECur(int AccountId, decimal Value, int LastEditorId)
{
DbHelper2.RunSp("AccountUpdateECur",
DbHelper2.mp("@AccountId", SqlDbType.Int, AccountId),
DbHelper2.mp("@Value", SqlDbType.Money, Value),
DbHelper2.mp("@LastEditorId", SqlDbType.Int, LastEditorId));
}
/// <summary>
/// Updates this instance.
/// </summary>
public virtual void Update()
{
if (_state == DataRowState.Modified)
{
DbHelper2.RunSp("mc_PendingEMailMessageUpdate"
, DbHelper2.mp("@PendingEMailMessageId", SqlDbType.Int, _PendingEMailMessageId)
, DbHelper2.mp("@EMailMessageId", SqlDbType.Int, _EMailMessageId)
);
}
else if (_state == DataRowState.Added)
{
SqlParameter outPutKey = new SqlParameter("@PendingEMailMessageId", SqlDbType.Int);
outPutKey.Direction = ParameterDirection.Output;
DbHelper2.RunSp("mc_PendingEMailMessageInsert", outPutKey
, DbHelper2.mp("@EMailMessageId", SqlDbType.Int, _EMailMessageId)
);
_PendingEMailMessageId = (int)outPutKey.Value;
}
}
public virtual void Update()
{
if (_state == DataRowState.Modified)
{
DbHelper2.RunSp("mc_BasePlanSlotUpdate"
, DbHelper2.mp("@BasePlanSlotId", SqlDbType.Int, _BasePlanSlotId)
, DbHelper2.mp("@Name", SqlDbType.NVarChar, 50, _Name)
, DbHelper2.mp("@IsDefault", SqlDbType.Bit, _IsDefault)
);
}
else if (_state == DataRowState.Added)
{
SqlParameter outPutKey = new SqlParameter("@BasePlanSlotId", SqlDbType.Int);
outPutKey.Direction = ParameterDirection.Output;
DbHelper2.RunSp("mc_BasePlanSlotInsert", outPutKey
, DbHelper2.mp("@Name", SqlDbType.NVarChar, 50, _Name)
, DbHelper2.mp("@IsDefault", SqlDbType.Bit, _IsDefault)
);
_BasePlanSlotId = (int)outPutKey.Value;
}
}
public static void TemplateUpdate(string key, string subject, string body)
{
DbHelper2.RunSp("Alert2TemplateUpdate",
DbHelper2.mp("@Key", SqlDbType.NVarChar, 100, key),
DbHelper2.mp("@Subject", SqlDbType.NVarChar, 1000, subject),
DbHelper2.mp("@Body", SqlDbType.NText, body));
}
public static void LogPortalLogin(int UserId, string IP)
{
DbHelper2.RunSp("PortalLoginAdd",
DbHelper2.mp("@UserId", SqlDbType.Int, UserId),
DbHelper2.mp("@LoginTime", SqlDbType.DateTime, DateTime.UtcNow),
DbHelper2.mp("@IP", SqlDbType.VarChar, 15, IP));
}
/// <summary>
/// Updates this instance.
/// </summary>
public virtual void Update()
{
if (_state == DataRowState.Modified)
{
DbHelper2.RunSp("mc_EMailMessageAntiSpamItemUpdate"
, DbHelper2.mp("@EMailMessageAntiSpamItemId", SqlDbType.Int, _EMailMessageAntiSpamItemId)
, DbHelper2.mp("@From", SqlDbType.NVarChar, 255, _From)
, DbHelper2.mp("@IsWhite", SqlDbType.Bit, _IsWhite)
);
}
else if (_state == DataRowState.Added)
{
SqlParameter outPutKey = new SqlParameter("@EMailMessageAntiSpamItemId", SqlDbType.Int);
outPutKey.Direction = ParameterDirection.Output;
DbHelper2.RunSp("mc_EMailMessageAntiSpamItemInsert", outPutKey
, DbHelper2.mp("@From", SqlDbType.NVarChar, 255, _From)
, DbHelper2.mp("@IsWhite", SqlDbType.Bit, _IsWhite)
);
_EMailMessageAntiSpamItemId = (int)outPutKey.Value;
}
}
public static void UpdateResolutionInfo(int issueId, string resolution, string workaround)
{
DbHelper2.RunSp("Act_IssueUpdateResolutionInfo",
DbHelper2.mp("@IssueId", SqlDbType.Int, issueId),
DbHelper2.mp("@Resolution", SqlDbType.NText, resolution),
DbHelper2.mp("@Workaround", SqlDbType.NText, workaround));
}
public static void UnsubscribePersonalForObject(int EventTypeId, int UserId, int ObjectId)
{
DbHelper2.RunSp("SubscribtionUnsubscribePersonalForObject",
DbHelper2.mp("@EventTypeId", SqlDbType.Int, EventTypeId),
DbHelper2.mp("@UserId", SqlDbType.Int, UserId),
DbHelper2.mp("@ObjectId", SqlDbType.Int, ObjectId));
}
public static void AddNewDateTypeValue(int DateTypeId, int ObjectId, DateTime DateValue)
{
DbHelper2.RunSp("DateTypeValueAddNew",
DbHelper2.mp("@DateTypeId", SqlDbType.Int, DateTypeId),
DbHelper2.mp("@ObjectId", SqlDbType.Int, ObjectId),
DbHelper2.mp("@DateValue", SqlDbType.DateTime, DateValue));
}
public static void UpdateClient(int GroupId, PrimaryKeyId contactUid, PrimaryKeyId orgUid)
{
DbHelper2.RunSp("GroupUpdateClient",
DbHelper2.mp("@PrincipalId", SqlDbType.Int, GroupId),
DbHelper2.mp("@ContactUid", SqlDbType.UniqueIdentifier, contactUid),
DbHelper2.mp("@OrgUid", SqlDbType.UniqueIdentifier, orgUid));
}
public static void DeleteDateTypeValue(int dateTypeId, int?objectId, Guid?objectUid)
{
DbHelper2.RunSp("DateTypeValueDelete",
DbHelper2.mp("@DateTypeId", SqlDbType.Int, dateTypeId),
DbHelper2.mp("@ObjectId", SqlDbType.Int, objectId),
DbHelper2.mp("@objectUid", SqlDbType.UniqueIdentifier, objectUid));
}
public static void UpdateGeneralInfo(int todoId, string title, string description)
{
DbHelper2.RunSp("Act_TodoUpdateGeneralInfo",
DbHelper2.mp("@TodoId", SqlDbType.Int, todoId),
DbHelper2.mp("@Title", SqlDbType.NVarChar, 255, title),
DbHelper2.mp("@Description", SqlDbType.NText, description));
}
public static void UpdateActualFinancesValue(int ActualId, decimal AValue, int LastEditorId)
{
DbHelper2.RunSp("ActualFinancesUpdateValue",
DbHelper2.mp("@ActualId", SqlDbType.Int, ActualId),
DbHelper2.mp("@AValue", SqlDbType.Money, AValue),
DbHelper2.mp("@LastEditorId", SqlDbType.Int, LastEditorId));
}
public virtual void Update()
{
if (_state == DataRowState.Modified)
{
DbHelper2.RunSp("mc_EMailIssueExternalRecipientUpdate"
, DbHelper2.mp("@EMailIssueExternalRecipientId", SqlDbType.Int, _EMailIssueExternalRecipientId)
, DbHelper2.mp("@IssueId", SqlDbType.Int, _IssueId)
, DbHelper2.mp("@EMail", SqlDbType.NVarChar, 255, _EMail)
);
}
else if (_state == DataRowState.Added)
{
SqlParameter outPutKey = new SqlParameter("@EMailIssueExternalRecipientId", SqlDbType.Int);
outPutKey.Direction = ParameterDirection.Output;
DbHelper2.RunSp("mc_EMailIssueExternalRecipientInsert", outPutKey
, DbHelper2.mp("@IssueId", SqlDbType.Int, _IssueId)
, DbHelper2.mp("@EMail", SqlDbType.NVarChar, 255, _EMail)
);
_EMailIssueExternalRecipientId = (int)outPutKey.Value;
}
}
public static void RenameAccount(int AccountId, string Title, int LastEditorId)
{
DbHelper2.RunSp("AccountRename",
DbHelper2.mp("@AccountId", SqlDbType.Int, AccountId),
DbHelper2.mp("@Title", SqlDbType.NVarChar, 255, Title),
DbHelper2.mp("@LastEditorId", SqlDbType.Int, LastEditorId));
}
public virtual void Update()
{
if (_state == DataRowState.Modified)
{
DbHelper2.RunSp("mc_ProjectBasePlanInfoUpdate"
, DbHelper2.mp("@ProjectBasePlanInfoId", SqlDbType.Int, _ProjectBasePlanInfoId)
, DbHelper2.mp("@ProjectId", SqlDbType.Int, _ProjectId)
, DbHelper2.mp("@BasePlanSlotId", SqlDbType.Int, _BasePlanSlotId)
, DbHelper2.mp("@Created", SqlDbType.DateTime, _Created)
);
}
else if (_state == DataRowState.Added)
{
SqlParameter outPutKey = new SqlParameter("@ProjectBasePlanInfoId", SqlDbType.Int);
outPutKey.Direction = ParameterDirection.Output;
DbHelper2.RunSp("mc_ProjectBasePlanInfoInsert", outPutKey
, DbHelper2.mp("@ProjectId", SqlDbType.Int, _ProjectId)
, DbHelper2.mp("@BasePlanSlotId", SqlDbType.Int, _BasePlanSlotId)
, DbHelper2.mp("@Created", SqlDbType.DateTime, _Created)
);
_ProjectBasePlanInfoId = (int)outPutKey.Value;
}
}
public virtual void Update()
{
if (_state == DataRowState.Modified)
{
DbHelper2.RunSp("mc_EMailIncidentMappingUpdate"
, DbHelper2.mp("@EMailIncidentMappingId", SqlDbType.Int, _EMailIncidentMappingId)
, DbHelper2.mp("@Name", SqlDbType.NVarChar, 255, _Name)
, DbHelper2.mp("@Type", SqlDbType.NVarChar, 1024, _Type)
, DbHelper2.mp("@UserControl", SqlDbType.NVarChar, 1024, _UserControl)
);
}
else if (_state == DataRowState.Added)
{
SqlParameter outPutKey = new SqlParameter("@EMailIncidentMappingId", SqlDbType.Int);
outPutKey.Direction = ParameterDirection.Output;
DbHelper2.RunSp("mc_EMailIncidentMappingInsert", outPutKey
, DbHelper2.mp("@Name", SqlDbType.NVarChar, 255, _Name)
, DbHelper2.mp("@Type", SqlDbType.NVarChar, 1024, _Type)
, DbHelper2.mp("@UserControl", SqlDbType.NVarChar, 1024, _UserControl)
);
_EMailIncidentMappingId = (int)outPutKey.Value;
}
}
public static void LocalAddressRangeUpdate(int rangeId, string startAddress, string endAddress)
{
DbHelper2.RunSp("LocalAddressRangeUpdate",
DbHelper2.mp("@RangeId", SqlDbType.Int, rangeId),
DbHelper2.mp("@StartAddress", SqlDbType.NVarChar, 32, startAddress),
DbHelper2.mp("@EndAddress", SqlDbType.NVarChar, 32, endAddress));
}
public static void AddUserCalendar(
int CalendarId, int UserId)
{
DbHelper2.RunSp("UserCalendarAdd",
DbHelper2.mp("@CalendarId", SqlDbType.Int, CalendarId),
DbHelper2.mp("@UserId", SqlDbType.Int, UserId));
}
public static void ResourceAdd(int objectId, int principalId, bool mustBeConfirmed)
{
DbHelper2.RunSp("Act_EventResourceAdd",
DbHelper2.mp("@ObjectId", SqlDbType.Int, objectId),
DbHelper2.mp("@PrincipalId", SqlDbType.Int, principalId),
DbHelper2.mp("@MustBeConfirmed", SqlDbType.Bit, mustBeConfirmed));
}
public static void AddResource(int EventId, int PrincipalId, bool MustBeConfirmed)
{
DbHelper2.RunSp("EventResourceAdd",
DbHelper2.mp("@EventId", SqlDbType.Int, EventId),
DbHelper2.mp("@PrincipalId", SqlDbType.Int, PrincipalId),
DbHelper2.mp("@MustBeConfirmed", SqlDbType.Bit, MustBeConfirmed));
}
public static void UpdateProjectAndManager(int eventId, int projectId, int managerId)
{
DbHelper2.RunSp("Act_EventUpdateProjectAndManager",
DbHelper2.mp("@EventId", SqlDbType.Int, eventId),
DbHelper2.mp("@ProjectId", SqlDbType.Int, projectId),
DbHelper2.mp("@ManagerId", SqlDbType.Int, managerId));
}
public static void SettingsUpdateLastSynchronization(int LdapId, DateTime LastSynchronization)
{
DbHelper2.RunSp("LdapSettingsUpdateLastSynchronization"
, DbHelper2.mp("@LdapId", SqlDbType.Int, LdapId)
, DbHelper2.mp("@LastSynchronization", SqlDbType.DateTime, LastSynchronization)
);
}
public virtual void Update()
{
if (_state == DataRowState.Modified)
{
DbHelper2.RunSp("mc_PortalConfigUpdate"
, DbHelper2.mp("@SettingId", SqlDbType.Int, _SettingId)
, DbHelper2.mp("@Key", SqlDbType.NVarChar, 100, _Key)
, DbHelper2.mp("@Value", SqlDbType.NText, _Value)
);
}
else if (_state == DataRowState.Added)
{
SqlParameter outPutKey = new SqlParameter("@SettingId", SqlDbType.Int);
outPutKey.Direction = ParameterDirection.Output;
DbHelper2.RunSp("mc_PortalConfigInsert", outPutKey
, DbHelper2.mp("@Key", SqlDbType.NVarChar, 100, _Key)
, DbHelper2.mp("@Value", SqlDbType.NText, _Value)
);
_SettingId = (int)outPutKey.Value;
}
}
