/// <summary> /// Create a new VirtualPageKeyword object. /// </summary> /// <param name="virtualPageKeywordID">Initial value of the VirtualPageKeywordID property.</param> /// <param name="virtualPage_VirtualPageID">Initial value of the VirtualPage_VirtualPageID property.</param> /// <param name="pageKeyword">Initial value of the PageKeyword property.</param> /// <param name="active">Initial value of the Active property.</param> /// <param name="createdBy_UserID">Initial value of the CreatedBy_UserID property.</param> /// <param name="createdOn">Initial value of the CreatedOn property.</param> /// <param name="modifiedBy_UserID">Initial value of the ModifiedBy_UserID property.</param> /// <param name="modifiedOn">Initial value of the ModifiedOn property.</param> public static VirtualPageKeyword CreateVirtualPageKeyword(global::System.Int32 virtualPageKeywordID, global::System.Int32 virtualPage_VirtualPageID, global::System.String pageKeyword, global::System.Boolean active, global::System.Int32 createdBy_UserID, global::System.DateTime createdOn, global::System.Int32 modifiedBy_UserID, global::System.DateTime modifiedOn) { VirtualPageKeyword virtualPageKeyword = new VirtualPageKeyword(); virtualPageKeyword.VirtualPageKeywordID = virtualPageKeywordID; virtualPageKeyword.VirtualPage_VirtualPageID = virtualPage_VirtualPageID; virtualPageKeyword.PageKeyword = pageKeyword; virtualPageKeyword.Active = active; virtualPageKeyword.CreatedBy_UserID = createdBy_UserID; virtualPageKeyword.CreatedOn = createdOn; virtualPageKeyword.ModifiedBy_UserID = modifiedBy_UserID; virtualPageKeyword.ModifiedOn = modifiedOn; return virtualPageKeyword; }
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; }
/// <summary> /// Deprecated Method for adding a new object to the VirtualPageKeywords EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToVirtualPageKeywords(VirtualPageKeyword virtualPageKeyword) { base.AddObject("VirtualPageKeywords", virtualPageKeyword); }