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(); } }