public int CreateEmailQueue(string inputData)
{
MessageQueueResponse response = new MessageQueueResponse();
using (var context = new hamptondwellEntities())
{
MessageQueue messageQueue = new MessageQueue();
messageQueue.ModifiedBy_UserID = -1;
messageQueue.Active = true;
messageQueue.Status_MessageQueueStatusID = -1;
messageQueue.MessageResponse = string.Empty;
if (messageQueue.MessageQueueID == 0)
{
messageQueue.CreatedOn = DateTime.UtcNow;
messageQueue.CreatedBy_UserID = -1;
messageQueue.OccurredOn = DateTime.UtcNow;
messageQueue.Type_MessageQueueTypeID = -1;
messageQueue.MessageBody = inputData;
}
messageQueue.ModifiedOn = DateTime.UtcNow;
if (messageQueue.MessageQueueID == 0)
context.AddObject("MessageQueues", messageQueue);
context.SaveChanges();
}
return 1;
}
public MessageQueueResponse Save(MessageQueueRequest request)
{
MessageQueueResponse response = new MessageQueueResponse();
using (var context = new hamptondwellEntities())
{
var messageQueue = context.MessageQueues.
Where(u => u.MessageQueueID == request.MessageQueueId).FirstOrDefault();
messageQueue = messageQueue ?? new MessageQueue();
messageQueue.ModifiedBy_UserID = request.ModifiedByUserId.Value;
messageQueue.Active = request.Active ?? true;
messageQueue.Status_MessageQueueStatusID = request.Status_MessageQueueStatusID;
messageQueue.MessageResponse = request.MessageResponse;
if (messageQueue.MessageQueueID == 0)
{
messageQueue.CreatedOn = DateTime.UtcNow;
messageQueue.CreatedBy_UserID = request.CreatedByUserId ?? messageQueue.CreatedBy_UserID;
messageQueue.OccurredOn = request.OccurredOn;
messageQueue.Type_MessageQueueTypeID = request.Type_MessageQueueTypeID;
messageQueue.MessageBody = request.MessageBody;
}
messageQueue.ModifiedOn = DateTime.UtcNow;
if (messageQueue.MessageQueueID == 0)
context.AddObject("MessageQueues", messageQueue);
context.SaveChanges();
response.MessageQueue = new MessageQueueObject()
{
MessageQueueId = messageQueue.MessageQueueID,
Active = messageQueue.Active,
MessageResponse = messageQueue.MessageResponse,
CreatedByUserId = messageQueue.CreatedBy_UserID,
MessageBody = messageQueue.MessageBody,
CreatedOn = messageQueue.CreatedOn,
ModifiedByUserId = messageQueue.ModifiedBy_UserID,
ModifiedOn = messageQueue.ModifiedOn,
Status_MessageQueueStatusID = messageQueue.Status_MessageQueueStatusID,
Type_MessageQueueTypeID = messageQueue.Type_MessageQueueTypeID
}
;
}
return response;
}
public VirtualPageResponse SaveKeywords(VirtualPageRequest request)
{
VirtualPageResponse response = new VirtualPageResponse();
response.VirtualPage = new VirtualPageObject();
response.VirtualPage.VirtualPageId = request.VirtualPageId;
response.VirtualPage.Keywords = request.Keywords;
using (var context = new hamptondwellEntities())
{
if (request.VirtualPageId > 0 && string.IsNullOrEmpty(request.Keywords))
{
foreach (
VirtualPageKeyword keyword in
context.VirtualPageKeywords.Where(
k => k.VirtualPage_VirtualPageID == request.VirtualPageId
&& k.Active == true))
{
keyword.Active = false;
keyword.ModifiedBy_UserID = request.ModifiedByUserId.Value;
keyword.ModifiedOn = DateTime.UtcNow;
}
}
else
{
List<VirtualPageKeyword> keywordList =
(from VirtualPageKeyword keyword in context.VirtualPageKeywords.Where(
k => k.VirtualPage_VirtualPageID == request.VirtualPageId
&& k.Active == true)
select keyword).ToList();
foreach (string item in request.Keywords.Split(';'))
{
if (keywordList.Find(k => k.PageKeyword.ToLower() == item.ToLower()) == null)
{
if (string.IsNullOrEmpty(item) || item == ";")
continue;
VirtualPageKeyword newKeyword = new VirtualPageKeyword()
{
Active = true,
CreatedOn = DateTime.UtcNow,
ModifiedOn = DateTime.UtcNow,
CreatedBy_UserID = request.CreatedByUserId.Value,
ModifiedBy_UserID =
request.ModifiedByUserId.Value,
PageKeyword = item.Trim(),
VirtualPage_VirtualPageID =
request.VirtualPageId
};
context.AddObject("VirtualPageKeywords", newKeyword);
}
}
foreach (
VirtualPageKeyword keyword in
context.VirtualPageKeywords.Where(
k => k.VirtualPage_VirtualPageID == request.VirtualPageId
&& k.Active == true))
{
if (request.Keywords.Split(';').Contains(keyword.PageKeyword) == false)
{
keyword.Active = false;
keyword.ModifiedBy_UserID = request.ModifiedByUserId.Value;
keyword.ModifiedOn = DateTime.UtcNow;
}
}
}
context.SaveChanges();
}
return response;
}
public VirtualPageResponse Save(VirtualPageRequest request)
{
VirtualPageResponse response = new VirtualPageResponse();
using (var context = new hamptondwellEntities())
{
var virtualPage = context.VirtualPages.
Where(u => u.VirtualPageID == request.VirtualPageId).FirstOrDefault();
virtualPage = virtualPage ?? new VirtualPage();
virtualPage.Path = request.Path;
virtualPage.PageName = request.PageName;
virtualPage.Active = request.Active;
virtualPage.ModifiedBy_UserID = request.ModifiedByUserId;
virtualPage.PageContent = request.PageContent;
virtualPage.MemberOf_VirtualPageID = request.MemberOf;
virtualPage.Template_VirtualPageID = request.PageTemplate;
virtualPage.ModifiedOn = DateTime.UtcNow;
virtualPage.MetaDescription = request.MetaDescription;
virtualPage.PageTitle = request.PageTitle;
virtualPage.IsTemplate = request.IsTemplate;
if (virtualPage.VirtualPageID == 0)
{
virtualPage.CreatedBy_UserID = request.CreatedByUserId;
virtualPage.CreatedOn = DateTime.UtcNow;
context.AddObject("VirtualPages", virtualPage);
}
if (virtualPage.IsTemplate == false)
{
var rewriteRule = context.RewriteRules.Where(r => r.Active == true &&
r.VirtualPage_VirtualPageID ==
virtualPage.VirtualPageID).FirstOrDefault();
rewriteRule = rewriteRule ?? new RewriteRule()
{
Active = true,
CreatedOn = DateTime.UtcNow,
CreatedBy_UserID = request.CreatedByUserId,
ModifiedOn = DateTime.UtcNow,
ModifiedBy_UserID = request.ModifiedByUserId,
VirtualPage_VirtualPageID = virtualPage.VirtualPageID,
Rewrite = request.Path,
URL = virtualPage.PageName
};
if (rewriteRule.RewriteRuleID > 0)
{
rewriteRule.ModifiedBy_UserID = request.ModifiedByUserId;
rewriteRule.ModifiedOn = DateTime.UtcNow;
rewriteRule.URL = virtualPage.PageName;
rewriteRule.Rewrite = request.Path;
rewriteRule.Active = request.Active;
}
else
{
context.AddObject("RewriteRules", rewriteRule);
}
}
context.SaveChanges();
response.VirtualPage = new VirtualPageObject()
{
VirtualPageId = virtualPage.VirtualPageID,
PageName = virtualPage.PageName,
Active = virtualPage.Active.Value,
CreatedByUserId = virtualPage.CreatedBy_UserID.Value,
CreatedOn = virtualPage.CreatedOn.Value,
MetaDescription = virtualPage.MetaDescription,
PageTitle = virtualPage.PageTitle,
Path = virtualPage.Path,
PageContent = virtualPage.PageContent,
IsTemplate = virtualPage.IsTemplate ?? false,
MemberOf = virtualPage.MemberOf_VirtualPageID ?? 0,
ModifiedByUserId = virtualPage.ModifiedBy_UserID.Value,
Keywords = request.Keywords
}
;
}
return response;
}
public UserResponse Save(UserRequest request)
{
UserResponse response = new UserResponse();
using (var context = new hamptondwellEntities())
{
var user = context.Users.
Where(u => u.UserID == request.UserId).FirstOrDefault();
user = user ?? new User();
user.Email = request.Email;
user.Active = request.Active;
user.FirstName = request.FirstName;
user.LastName = request.LastName;
user.ModifiedBy_UserID = request.ModifiedBy;
user.ModifiedOn = DateTime.UtcNow;
if (user.UserID == 0 || string.IsNullOrEmpty(request.Password) == false)
{
user.Password = request.Password;
}
if (user.UserID == 0)
{
user.CreatedBy_UserID = request.CreatedBy;
user.CreatedOn = DateTime.UtcNow;
context.AddObject("Users", user);
}
context.SaveChanges();
response.User = new UserObject()
{
UserId = user.UserID,
Active = user.Active,
Email = user.Email,
FirstName = user.FirstName,
LastName = user.LastName,
Password = user.Password,
CreatedOn = user.CreatedOn.Value,
ModifiedOn = user.ModifiedOn.Value
}
;
}
return response;
}
public SystemConstantResponse Save(SystemConstantRequest request)
{
SystemConstantResponse response = new SystemConstantResponse();
using (var context = new hamptondwellEntities())
{
var systemConstant = context.SystemConstants.
Where(u => u.SystemConstantID == request.SystemConstantId).FirstOrDefault();
systemConstant = systemConstant ?? new SystemConstant();
systemConstant.Name = request.Name;
systemConstant.ConstantValue = request.ConstantValue;
systemConstant.Active = request.Active;
systemConstant.ModifiedBy_UserID = request.ModifiedByUserId;
if (systemConstant.SystemConstantID == 0)
{
systemConstant.CreatedOn = DateTime.UtcNow;
systemConstant.CreatedBy_UserID = request.CreateByUserId ?? systemConstant.CreatedBy_UserID;
}
systemConstant.ModifiedOn = DateTime.UtcNow;
if (systemConstant.SystemConstantID == 0)
context.AddObject("SystemConstants", systemConstant);
context.SaveChanges();
response.SystemConstant = new SystemConstantObject()
{
SystemConstantId = systemConstant.SystemConstantID,
Active = systemConstant.Active,
ConstantValue = systemConstant.ConstantValue,
CreatedByUserId = systemConstant.CreatedBy_UserID,
Name = systemConstant.Name,
CreatedOn = systemConstant.CreatedOn,
ModifiedByUserId = systemConstant.ModifiedBy_UserID,
ModifiedOn = systemConstant.ModifiedOn
}
;
}
return response;
}
