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 static SystemConstantResponse GetSystemConstantByName(SystemConstantRequest request)
{
SystemConstantResponse response = new SystemConstantResponse();
using (var context = new hamptondwellEntities())
{
var systemConstant = context.SystemConstants.
Where(u => u.Active == true && u.Name == request.Name).FirstOrDefault();
if (systemConstant != null)
{
response.SystemConstant = new SystemConstantObject()
{
SystemConstantId = systemConstant.SystemConstantID,
Active = systemConstant.Active,
ConstantValue = systemConstant.ConstantValue,
CreatedByUserId = systemConstant.CreatedBy_UserID,
ModifiedByUserId = systemConstant.ModifiedBy_UserID,
Name = systemConstant.Name,
ModifiedOn = systemConstant.ModifiedOn,
CreatedOn = systemConstant.CreatedOn
};
}
response.SystemConstant = response.SystemConstant ?? new SystemConstantObject();
}
return response;
}
public UserResponse GetUser(UserRequest request)
{
UserResponse response = new UserResponse();
using (var context = new hamptondwellEntities())
{
var user = context.Users.
Where(u =>
(string.IsNullOrEmpty(request.Email) == false && u.Email == request.Email) && u.Active == true).FirstOrDefault();
if (user == null)
return response;
response.User = new UserObject()
{
UserId = user.UserID,
Active = user.Active,
Email = user.Email,
FirstName = user.FirstName,
LastName = user.LastName,
Password = user.Password,
CreatedByUserId = user.CreatedBy_UserID ?? 0,
ModifiedByUserId = user.ModifiedBy_UserID ?? 0,
CreatedOn = user.CreatedOn ?? DateTime.MinValue,
ModifiedOn = user.ModifiedOn ?? DateTime.MinValue
}
;
}
return response;
}
public SystemConstantResponse GetSystemConstantList(SystemConstantRequest request)
{
SystemConstantResponse response = new SystemConstantResponse();
using (var context = new hamptondwellEntities())
{
var SystemConstant = (from a in context.SystemConstants.
Where(
a =>
a.Active == request.Active &&
(string.IsNullOrEmpty(request.FirstLetter) ||
a.Name.StartsWith(request.FirstLetter)))
select a);
SystemConstant = GetListSort(SystemConstant, request);
SystemConstant = SystemConstant.Skip(request.StartRowIndex).Take(request.MaximumRows);
response.SystemConstantList = SystemConstant.Select(a => new SystemConstantObject
{
SystemConstantId = a.SystemConstantID,
Name = a.Name,
ConstantValue = a.ConstantValue,
CreatedBy = (a.User1 != null ? a.User1.Email : string.Empty),
Active = a.Active,
ModifiedBy = (a.User != null ? a.User.Email : string.Empty),
ModifiedByUserId = a.ModifiedBy_UserID,
CreatedByUserId = a.CreatedBy_UserID,
ModifiedOn = a.ModifiedOn,
CreatedOn = a.CreatedOn
}).ToList();
response.ResultSetCount = GetSystemConstantListCount(request);
}
return response;
}
public RewriteRuleResponse GetRewriteRuleByUrl(RewriteRuleRequest request)
{
RewriteRuleResponse response = new RewriteRuleResponse();
using (var context = new hamptondwellEntities())
{
var rewrite = context.RewriteRules.
Where(u => u.URL == request.Url && u.Active == true).FirstOrDefault();
if (rewrite != null)
{
response.RewriteRule = new RewriteRuleObject()
{
RewriteRuleId = rewrite.RewriteRuleID,
Active = rewrite.Active ?? true,
CreatedByUserId = rewrite.CreatedBy_UserID ?? 0,
ModifiedByUserId = rewrite.ModifiedBy_UserID ?? 0,
ModifiedOn = rewrite.ModifiedOn ?? DateTime.MinValue,
CreatedOn = rewrite.CreatedOn ?? DateTime.MinValue,
Rewrite = rewrite.Rewrite,
Url = rewrite.URL
}
;
}
}
return response;
}
public UserResponse GetUserById(UserRequest request)
{
UserResponse response = new UserResponse();
using (var context = new hamptondwellEntities())
{
var user = context.Users.
Where(u => u.UserID == request.UserId).FirstOrDefault();
response.User = new UserObject()
{
UserId = user.UserID,
Active = user.Active,
Email = user.Email,
FirstName = user.FirstName,
LastName = user.LastName,
Password = user.Password,
CreatedByUserId = user.CreatedBy_UserID ?? 0,
ModifiedByUserId = user.ModifiedBy_UserID ?? 0,
CreatedOn = user.CreatedOn ?? DateTime.MinValue,
ModifiedOn = user.ModifiedOn ?? DateTime.MinValue
}
;
}
return response;
}
public UserResponse GetUserList(UserRequest request)
{
UserResponse response = new UserResponse();
using (var context = new hamptondwellEntities())
{
var User = (from a in context.Users.
Where(
a =>
a.Active == request.Active &&
(string.IsNullOrEmpty(request.FirstLetter) ||
a.LastName.StartsWith(request.FirstLetter)) &&
(string.IsNullOrEmpty(request.Email) || a.Email == request.Email))
select a);
User = GetListSort(User, request);
User = User.Skip(request.StartRowIndex).Take(request.MaximumRows);
response.UserList = User.Select(a => new UserObject
{
UserId = a.UserID,
FirstName = a.FirstName,
LastName = a.LastName,
Email = a.Email,
Active = a.Active,
Password = a.Password,
CreatedByUserId = a.CreatedBy_UserID ?? 0,
ModifiedByUserId = a.ModifiedBy_UserID ?? 0,
CreatedOn = a.CreatedOn ?? DateTime.MinValue,
ModifiedOn = a.ModifiedOn ?? DateTime.MinValue
}).ToList();
response.ResultSetCount = GetUserListCount(request);
}
return response;
}
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 GetVirtualPageByPath(VirtualPageRequest request)
{
VirtualPageResponse response = new VirtualPageResponse();
using (var context = new hamptondwellEntities())
{
var virtualPage = context.VirtualPages.
Where(u => u.Path == request.Path && u.Active == true).FirstOrDefault();
if (virtualPage != null)
{
response.VirtualPage = new VirtualPageObject()
{
VirtualPageId = virtualPage.VirtualPageID,
PageName = virtualPage.PageName,
Path = virtualPage.Path,
CreatedByUserId = virtualPage.CreatedBy_UserID ?? 0,
ModifiedByUserId = virtualPage.ModifiedBy_UserID ?? 0,
CreatedOn = virtualPage.CreatedOn ?? DateTime.MinValue,
ModifiedOn = virtualPage.ModifiedOn ?? DateTime.MinValue,
IsTemplate = virtualPage.IsTemplate ?? false,
MemberOf = virtualPage.MemberOf_VirtualPageID ?? 0,
PageTemplate = virtualPage.Template_VirtualPageID ?? 0,
PageContent = virtualPage.PageContent,
Active = virtualPage.Active ?? true,
MetaDescription = virtualPage.MetaDescription,
PageTitle = virtualPage.PageTitle,
}
;
if (virtualPage.VirtualPageKeywords.Count() > 0)
{
foreach (VirtualPageKeyword keyword in virtualPage.VirtualPageKeywords
.Where(a => a.Active == true))
{
response.VirtualPage.Keywords += keyword.PageKeyword.Trim() + ";";
}
}
if (string.IsNullOrEmpty(response.VirtualPage.Keywords) == false)
response.VirtualPage.Keywords = response.VirtualPage.Keywords.Trim(';');
}
}
return response;
}
public MessageQueueResponse GetPendingMessageQueue(MessageQueueRequest request)
{
MessageQueueResponse response = new MessageQueueResponse();
using (var context = new hamptondwellEntities())
{
List<MessageQueue> messageQueue = context.MessageQueues.
Where(u => u.Status_MessageQueueStatusID == request.Status_MessageQueueStatusID &&
u.Type_MessageQueueTypeID == request.Type_MessageQueueTypeID && u.Active == true).ToList();
response.MessageQueueList = messageQueue.Select(a => new MessageQueueObject()
{
MessageQueueId = a.MessageQueueID,
MessageBody = a.MessageBody,
Type_MessageQueueTypeID = a.Type_MessageQueueTypeID,
ModifiedByUserId = a.ModifiedBy_UserID,
CreatedByUserId = a.CreatedBy_UserID,
ModifiedOn = a.ModifiedOn,
CreatedOn = a.CreatedOn
}).ToList();
response.ResultSetCount = messageQueue.Count;
}
return response;
}
public static VirtualPageResponse VirtualPage(this string fileName)
{
VirtualPageResponse response = new VirtualPageResponse();
fileName = fileName.Replace("_", "?");
using (var context = new hamptondwellEntities())
{
var virtualPage = context.VirtualPages.
Where(u => fileName.Contains(u.Path) && u.Active == true).FirstOrDefault();
if (virtualPage != null)
{
response.VirtualPage = new VirtualPageObject()
{
VirtualPageId = virtualPage.VirtualPageID,
PageName = virtualPage.PageName,
Path = virtualPage.Path,
CreatedByUserId = virtualPage.CreatedBy_UserID ?? 0,
ModifiedByUserId = virtualPage.ModifiedBy_UserID ?? 0,
CreatedOn = virtualPage.CreatedOn ?? DateTime.MinValue,
ModifiedOn = virtualPage.ModifiedOn ?? DateTime.MinValue,
IsTemplate = virtualPage.IsTemplate ?? false,
MemberOf = virtualPage.MemberOf_VirtualPageID ?? 0,
PageTemplate = virtualPage.Template_VirtualPageID ?? 0,
PageContent = virtualPage.PageContent,
Active = virtualPage.Active ?? true,
MetaDescription = virtualPage.MetaDescription,
PageTitle = virtualPage.PageTitle,
}
;
}
response.VirtualPage = response.VirtualPage ?? new VirtualPageObject() { PageName = fileName, Path = fileName, PageTitle = fileName };
}
return response;
}
private int GetVirtualPageListCount(VirtualPageRequest request)
{
using (var context = new hamptondwellEntities())
{
var virtualPage = (from a in context.VirtualPages.
Where(
a =>
a.Active == request.Active &&
(string.IsNullOrEmpty(request.FirstLetter) ||
a.PageName.StartsWith(request.FirstLetter)))
select a);
return virtualPage.Count();
}
}
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 VirtualPageResponse GetVirtualPageTemplates(VirtualPageRequest request)
{
VirtualPageResponse response = new VirtualPageResponse();
using (var context = new hamptondwellEntities())
{
var VirtualPage = (from a in context.VirtualPages.
Where(
a =>
a.Active == request.Active &&
a.IsTemplate == true)
select a);
VirtualPage = GetListSort(VirtualPage, request);
VirtualPage = VirtualPage.Skip(request.StartRowIndex).Take(request.MaximumRows);
response.VirtualPageList = VirtualPage.Select(a => new VirtualPageObject
{
VirtualPageId = a.VirtualPageID,
PageName = a.PageName,
Path = a.Path,
CreatedByUserId = a.CreatedBy_UserID ?? 0,
ModifiedByUserId = a.ModifiedBy_UserID ?? 0,
CreatedOn = a.CreatedOn ?? DateTime.MinValue,
ModifiedOn =
a.ModifiedOn ?? DateTime.MinValue,
IsTemplate = a.IsTemplate ?? false,
MemberOf = a.MemberOf_VirtualPageID ?? 0,
PageTemplate = a.Template_VirtualPageID ?? 0,
PageContent = a.PageContent,
Active = a.Active.Value
}).ToList();
response.VirtualPageList.Add(new VirtualPageObject() {VirtualPageId = 0, PageName = string.Empty});
response.ResultSetCount = GetVirtualPageListCount(request);
}
return response;
}
public SystemConstantResponse SaveSystemConstantByName(SystemConstantRequest request)
{
SystemConstantResponse response = new SystemConstantResponse();
using (var context = new hamptondwellEntities())
{
var systemConstant = context.SystemConstants.
Where(u => u.Active == true && u.Name == request.Name).FirstOrDefault();
systemConstant = systemConstant ?? new SystemConstant();
systemConstant.ConstantValue = request.ConstantValue;
systemConstant.ModifiedBy_UserID = request.ModifiedByUserId;
systemConstant.ModifiedOn = DateTime.UtcNow;
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;
}
private int GetSystemConstantListCount(SystemConstantRequest request)
{
using (var context = new hamptondwellEntities())
{
var systemConstant = (from a in context.SystemConstants.
Where(
a =>
a.Active == request.Active &&
(string.IsNullOrEmpty(request.FirstLetter) ||
a.Name.StartsWith(request.FirstLetter)))
select a);
return systemConstant.Count();
}
}
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;
}
private int GetUserListCount(UserRequest request)
{
using (var context = new hamptondwellEntities())
{
var user = (from a in context.Users.
Where(
a =>
a.Active == request.Active &&
(string.IsNullOrEmpty(request.FirstLetter) ||
a.LastName.StartsWith(request.FirstLetter)) &&
(string.IsNullOrEmpty(request.Email) || a.Email == request.Email))
select a);
return user.Count();
}
}
