/// <summary>
/// Deletes all.
/// </summary>
/// <param name="BaseProductID">The base product ID.</param>
public void DeleteAll(Guid BaseProductID)
{
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_ProductComplectation WHERE BaseProductID = @BaseProductID",
new SqlParameter {
ParameterName = "BaseProductID", Value = BaseProductID
});
}
/// <summary>
/// Deletes all.
/// </summary>
/// <param name="taskId">The task id.</param>
public void DeleteAll(Guid taskId)
{
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_TaskDuration WHERE TaskID = @TaskID",
new SqlParameter {
ParameterName = "TaskID", Value = taskId
});
}
/// <summary>
/// Deletes all.
/// </summary>
/// <param name="workflowTemplateId">The workflow template id.</param>
public void DeleteAll(Guid workflowTemplateId)
{
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_WorkflowTemplateConditionEvent WHERE WorkflowTemplateID = @WorkflowTemplateID",
new SqlParameter {
ParameterName = "WorkflowTemplateID", Value = workflowTemplateId
});
}
/// <summary>
/// Deletes all.
/// </summary>
/// <param name="publicationID">The publication ID.</param>
public void DeleteAll(Guid publicationID)
{
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_RelatedPublication WHERE PublicationID = @PublicationID",
new SqlParameter {
ParameterName = "PublicationID", Value = publicationID
});
}
/// <summary>
/// Saves the specified contact list.
/// </summary>
/// <param name="contactList">The contact list.</param>
/// <param name="massWorkflowId">The mass workflow id.</param>
public void Save(List <Guid> contactList, Guid massWorkflowId)
{
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_MassWorkflowContact WHERE MassWorkflowID = @MassWorkflowID", new SqlParameter {
ParameterName = "MassWorkflowID", Value = massWorkflowId
});
if (contactList != null && contactList.Count > 0)
{
foreach (var contactId in contactList)
{
if (contactId == Guid.Empty)
{
continue;
}
_dataContext.tbl_MassWorkflowContact.AddObject(new tbl_MassWorkflowContact
{
ID = Guid.NewGuid(),
MassWorkflowID = massWorkflowId,
ContactID = contactId
});
}
}
_dataContext.SaveChanges();
}
/// <summary>
/// Deletes the specified contact id.
/// </summary>
/// <param name="contactId">The contact id.</param>
/// <param name="reminderIds">The reminder ids.</param>
public void Delete(Guid contactId, List <Guid> reminderIds)
{
var parameters = reminderIds.Select(reminderId => string.Format("ID = '{0}'", reminderId)).ToList();
var query = string.Format("DELETE FROM tbl_Reminder WHERE ContactID = '{0}' AND ({1})", contactId, string.Join(" OR ", parameters));
_dataContext.ExecuteStoreCommand(query);
}
/// <summary>
/// Deletes all.
/// </summary>
/// <param name="ProductID">The product ID.</param>
public void DeleteAll(Guid ProductID)
{
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_ProductPrice WHERE ProductID = @ProductID",
new SqlParameter {
ParameterName = "ProductID", Value = ProductID
});
}
/// <summary>
/// Deletes all.
/// </summary>
/// <param name="siteId">The site id.</param>
/// <param name="sourceMonitoringId">The source monitoring id.</param>
public void DeleteAll(Guid siteId, Guid sourceMonitoringId)
{
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_SourceMonitoringFilter WHERE SiteID = @SiteId AND SourceMonitoringID = @SourceMonitoringId",
new SqlParameter {
ParameterName = "SourceMonitoringId", Value = sourceMonitoringId
},
new SqlParameter {
ParameterName = "SiteId", Value = siteId
});
}
/// <summary>
/// Adds the specified site action template recipients.
/// </summary>
/// <param name="siteActionTemplateRecipients">The site action template recipients.</param>
/// <param name="siteActionTemplateId">The site action template id.</param>
public void Save(List <SiteActionTemplateRecipientMap> siteActionTemplateRecipients, Guid siteActionTemplateId)
{
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_SiteActionTemplateRecipient WHERE SiteActionTemplateID = @SiteActionTemplateID", new SqlParameter {
ParameterName = "SiteActionTemplateID", Value = siteActionTemplateId
});
foreach (var siteActionTemplateRecipient in siteActionTemplateRecipients)
{
_dataContext.tbl_SiteActionTemplateRecipient.AddObject(new tbl_SiteActionTemplateRecipient
{
ID = Guid.NewGuid(),
SiteActionTemplateID = siteActionTemplateId,
ContactID = siteActionTemplateRecipient.ContactID,
ContactRoleID = siteActionTemplateRecipient.ContactRoleID,
Email = siteActionTemplateRecipient.Email,
DisplayName = siteActionTemplateRecipient.DisplayName
});
}
_dataContext.SaveChanges();
}
/// <summary>
/// Saves the specified site id.
/// </summary>
/// <param name="siteId">The site id.</param>
/// <param name="contactToContactRoleList">The contact to contact role list.</param>
/// <param name="contactRoleId">The contact role id.</param>
public void Save(Guid siteId, List<Guid> contactToContactRoleList, Guid contactRoleId)
{
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_ContactToContactRole WHERE ContactRoleID = @ContactRoleID", new SqlParameter { ParameterName = "ContactRoleID", Value = contactRoleId });
if (contactToContactRoleList != null && contactToContactRoleList.Count > 0)
{
foreach (var contactId in contactToContactRoleList)
{
if (contactId == Guid.Empty)
continue;
_dataContext.tbl_ContactToContactRole.AddObject(new tbl_ContactToContactRole
{
ID = Guid.NewGuid(),
SiteID = siteId,
ContactRoleID = contactRoleId,
ContactID = contactId
});
}
}
_dataContext.SaveChanges();
}
/// <summary>
/// Deletes the specified site action id.
/// </summary>
/// <param name="siteActionId">The site action id.</param>
public void Delete(Guid siteActionId)
{
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_SiteActionTagValue WHERE SiteActionID = @SiteActionID", new SqlParameter {
ParameterName = "SiteActionID", Value = siteActionId
});
}
/// <summary>
/// Deletes all by access profile ID.
/// </summary>
/// <param name="accessProfileID">The access profile ID.</param>
public void DeleteAllByAccessProfileID(Guid accessProfileID)
{
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_Menu WHERE AccessProfileID = @AccessProfileID", new SqlParameter {
ParameterName = "AccessProfileID", Value = accessProfileID
});
}
/// <summary>
/// Deletes all by element id.
/// </summary>
/// <param name="workflowTemplateElementId">The workflow template element id.</param>
public void DeleteAllByElementId(Guid workflowTemplateElementId)
{
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_WorkflowTemplateElementParameter WHERE WorkflowTemplateElementID = @WorkflowTemplateElementID", new SqlParameter {
ParameterName = "WorkflowTemplateElementID", Value = workflowTemplateElementId
});
}
/// <summary>
/// Saves the specified workflow template element list.
/// </summary>
/// <param name="workflowTemplateElementList">The workflow template element list.</param>
/// <param name="workflowTemplateId">The workflow template id.</param>
public void Save(List <WorkflowTemplateElementMap> workflowTemplateElementList, Guid workflowTemplateId)
{
var existsElements = SelectAll(workflowTemplateId).ToList();
foreach (var element in workflowTemplateElementList)
{
var existElement = existsElements.Where(a => a.ID == element.ID).SingleOrDefault();
if (existElement == null)
{
_dataContext.tbl_WorkflowTemplateElement.AddObject(new tbl_WorkflowTemplateElement
{
ID = element.ID,
WorkflowTemplateID = workflowTemplateId,
Name = element.Name,
ElementType = element.ElementType,
Optional = element.Optional,
ResultName = element.ResultName,
AllowOptionalTransfer = element.AllowOptionalTransfer,
ShowCurrentUser = element.ShowCurrentUser,
Description = element.Description,
Order = element.Order,
StartAfter = element.StartAfter,
StartPeriod = element.StartPeriod,
DurationHours = element.DurationHours,
DurationMinutes = element.DurationMinutes,
ControlAfter = element.ControlAfter,
ControlPeriod = element.ControlPeriod,
ControlFromBeginProccess = element.ControlFromBeginProccess,
IsActive = element.IsActive
});
}
else
{
existElement.ID = element.ID;
existElement.WorkflowTemplateID = workflowTemplateId;
existElement.Name = element.Name;
existElement.ElementType = element.ElementType;
existElement.Optional = element.Optional;
existElement.ResultName = element.ResultName;
existElement.AllowOptionalTransfer = element.AllowOptionalTransfer;
existElement.ShowCurrentUser = element.ShowCurrentUser;
existElement.Description = element.Description;
existElement.Order = element.Order;
existElement.StartAfter = element.StartAfter;
existElement.StartPeriod = element.StartPeriod;
existElement.DurationHours = element.DurationHours;
existElement.DurationMinutes = element.DurationMinutes;
existElement.ControlAfter = element.ControlAfter;
existElement.ControlPeriod = element.ControlPeriod;
existElement.ControlFromBeginProccess = element.ControlFromBeginProccess;
existElement.IsActive = element.IsActive;
}
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_WorkflowTemplateElementParameter WHERE WorkflowTemplateElementID = @WorkflowTemplateElementID", new SqlParameter {
ParameterName = "WorkflowTemplateElementID", Value = element.ID
});
if (element.Parameters != null && element.Parameters.Count > 0)
{
foreach (var p in element.Parameters)
{
_dataContext.tbl_WorkflowTemplateElementParameter.AddObject(new tbl_WorkflowTemplateElementParameter
{
ID = Guid.NewGuid(),
WorkflowTemplateElementID = element.ID,
Name = p.Key,
Value = p.Value
});
Guid siteActionTemplateId;
if (element.ElementType == (int)WorkflowTemplateElementType.Message && Guid.TryParse(p.Value, out siteActionTemplateId))
{
var siteActionTemplate = _dataContext.tbl_SiteActionTemplate.SingleOrDefault(x => x.ID == siteActionTemplateId);
if (siteActionTemplate != null && siteActionTemplate.SiteActionTemplateCategoryID != (int)SiteActionTemplateCategory.BaseTemplate)
{
siteActionTemplate.UsageID = workflowTemplateId;
}
}
}
}
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_WorkflowTemplateElementEvent WHERE WorkflowTemplateElementID = @WorkflowTemplateElementID", new SqlParameter {
ParameterName = "WorkflowTemplateElementID", Value = element.ID
});
if ((WorkflowTemplateElementType)element.ElementType == WorkflowTemplateElementType.WaitingEvent)
{
var newId = Guid.NewGuid();
_dataContext.tbl_WorkflowTemplateElementEvent.AddObject(new tbl_WorkflowTemplateElementEvent
{
ID = newId,
WorkflowTemplateElementID = element.ID,
Condition = (int)element.Condition,
ActivityCount = element.ActivityCount
});
foreach (var conditionEvent in element.ConditionEvent)
{
_dataContext.tbl_WorkflowTemplateConditionEvent.AddObject(new tbl_WorkflowTemplateConditionEvent
{
ID = Guid.NewGuid(),
WorkflowTemplateElementEventID = newId,
Category = conditionEvent.Category,
ActivityType = conditionEvent.ActivityType,
Code = conditionEvent.Code,
ActualPeriod = conditionEvent.ActualPeriod,
Requisite = conditionEvent.Requisite,
Formula = conditionEvent.Formula,
Value = conditionEvent.Value
});
}
}
if ((WorkflowTemplateElementType)element.ElementType != WorkflowTemplateElementType.Task)
{
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_WorkflowTemplateElementRelation WHERE StartElementResult = @StartElementResult", new SqlParameter {
ParameterName = "StartElementResult", Value = element.ID.ToString()
});
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_WorkflowTemplateElementResult WHERE WorkflowTemplateElementID = @WorkflowTemplateElementID", new SqlParameter {
ParameterName = "WorkflowTemplateElementID", Value = element.ID
});
}
var workflowTemplateElementResultList = element.ElementResult;
if ((WorkflowTemplateElementType)element.ElementType == WorkflowTemplateElementType.Task)
{
var existsElementResults = _dataContext.tbl_WorkflowTemplateElementResult.Where(a => a.WorkflowTemplateElementID == element.ID).ToList();
foreach (var elementResult in workflowTemplateElementResultList)
{
var existElementResult = existsElementResults.Where(a => a.ID == elementResult.ID).SingleOrDefault();
if (existElementResult == null)
{
_dataContext.tbl_WorkflowTemplateElementResult.AddObject(new tbl_WorkflowTemplateElementResult
{
ID = elementResult.ID,
WorkflowTemplateElementID = element.ID,
Name = elementResult.Name,
IsSystem = elementResult.IsSystem
});
}
else
{
existElementResult.ID = elementResult.ID;
existElementResult.WorkflowTemplateElementID = element.ID;
existElementResult.Name = elementResult.Name;
existElementResult.IsSystem = elementResult.IsSystem;
}
}
foreach (var existsElementResult in existsElementResults)
{
if (workflowTemplateElementResultList.Where(op => op.ID == existsElementResult.ID).SingleOrDefault() == null)
{
_dataContext.tbl_WorkflowTemplateElementResult.DeleteObject(existsElementResult);
}
}
}
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_WorkflowTemplateElementTag WHERE WorkflowTemplateElementID = @WorkflowTemplateElementID", new SqlParameter {
ParameterName = "WorkflowTemplateElementID", Value = element.ID
});
if (element.Tag != null && element.Tag.Count > 0)
{
foreach (var t in element.Tag)
{
_dataContext.tbl_WorkflowTemplateElementTag.AddObject(new tbl_WorkflowTemplateElementTag
{
ID = Guid.NewGuid(),
WorkflowTemplateElementID = element.ID,
SiteTagID = t.SiteTagID,
Operation = t.Operation
});
}
}
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_WorkflowTemplateElementPeriod WHERE WorkflowTemplateElementID = @WorkflowTemplateElementID", new SqlParameter {
ParameterName = "WorkflowTemplateElementID", Value = element.ID
});
if (element.Period != null && element.Period.Count > 0)
{
foreach (var t in element.Period)
{
_dataContext.tbl_WorkflowTemplateElementPeriod.AddObject(new tbl_WorkflowTemplateElementPeriod
{
ID = Guid.NewGuid(),
WorkflowTemplateElementID = element.ID,
DayWeek = t.DayWeek,
FromTime = t.FromTime,
ToTime = t.ToTime
});
}
}
_dataContext.ExecuteStoreCommand("DELETE FROM tbl_WorkflowTemplateElementExternalRequest WHERE WorkflowTemplateElementID = @WorkflowTemplateElementID", new SqlParameter {
ParameterName = "WorkflowTemplateElementID", Value = element.ID
});
if (element.ExternalRequest != null && element.ExternalRequest.Count > 0)
{
foreach (var t in element.ExternalRequest)
{
_dataContext.tbl_WorkflowTemplateElementExternalRequest.AddObject(new tbl_WorkflowTemplateElementExternalRequest
{
ID = Guid.NewGuid(),
WorkflowTemplateElementID = element.ID,
Name = t.Name,
Value = t.Value
});
}
}
}
foreach (var existsElement in existsElements)
{
var deletedworkflowTemplateElement = workflowTemplateElementList.SingleOrDefault(op => op.ID == existsElement.ID);
if (deletedworkflowTemplateElement == null)
{
var countExistingElement = _dataContext.tbl_WorkflowElement.Count(a => a.WorkflowTemplateElementID == existsElement.ID);
if (countExistingElement == 0)
{
_dataContext.tbl_WorkflowTemplateElement.DeleteObject(existsElement);
}
else
{
existsElement.IsDeleted = true;
}
}
}
_dataContext.SaveChanges();
}