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