public IEnumerable <string> GetFormBlogTags(int BlogID) { var tag = allFormBlogsTags.Where(x => x.BlogID == BlogID).Select(x => x.TagID).ToList(); var _tagContexts = new TagsContexts(); List <string> lst = new List <string>(); foreach (var t in tag) { lst.Add(_tagContexts.GetTags().Where(x => x.TagID == Convert.ToInt32(t)).Select(x => x.TagNameTxt).FirstOrDefault()); } return(lst); }
public void AddBlogs(BlogsModel _BlogsModel) { _BlogsModel.BlogID = (int)(from S in BlogsData.Descendants("Blog") orderby(short) S.Element("BlogID") descending select(short) S.Element("BlogID")).FirstOrDefault() + 1; BlogsData.Root.Add(new XElement("Blog", new XElement("BlogID", _BlogsModel.BlogID), new XElement("TitleTxt", !string.IsNullOrEmpty(_BlogsModel.TitleTxt) ? _BlogsModel.TitleTxt : ""), new XElement("AuthorNameTxt", !string.IsNullOrEmpty(_BlogsModel.AuthorNameID) ? _BlogsModel.AuthorNameID : ""), new XElement("BlogDescription", !string.IsNullOrEmpty(_BlogsModel.BlogDescription) ? _BlogsModel.BlogDescription : ""), new XElement("ImagePathTxt", !string.IsNullOrEmpty(_BlogsModel.ImagePathTxt) ? _BlogsModel.ImagePathTxt : ""), new XElement("PostedDate", !string.IsNullOrEmpty(Convert.ToString(_BlogsModel.PostedDate)) ? _BlogsModel.PostedDate : System.DateTime.Today), new XElement("SlagTxt", !string.IsNullOrEmpty(_BlogsModel.SlagTxt) ? _BlogsModel.SlagTxt : ""), new XElement("IsActiveInd", _BlogsModel.IsActiveInd), new XElement("MetaTitleTxt", !string.IsNullOrEmpty(_BlogsModel.MetaTitleTxt) ? _BlogsModel.MetaTitleTxt : ""), new XElement("MetaKeywordTxt", !string.IsNullOrEmpty(_BlogsModel.MetaKeywordTxt) ? _BlogsModel.MetaKeywordTxt : ""), new XElement("MetaDescriptionTxt", !string.IsNullOrEmpty(_BlogsModel.MetaDescriptionTxt) ? _BlogsModel.MetaDescriptionTxt : ""), new XElement("IsCommentEnabledInd", _BlogsModel.IsCommentEnabledInd), new XElement("SocialMediaTxt", !string.IsNullOrEmpty(_BlogsModel.SocialMediaTxt) ? _BlogsModel.SocialMediaTxt : ""), new XElement("CategoryID", !string.IsNullOrEmpty(_BlogsModel.strCategoryid) ? Convert.ToInt32(_BlogsModel.strCategoryid) : 0), new XElement("AbstractTxt", !string.IsNullOrEmpty(_BlogsModel.AbstractTxt) ? _BlogsModel.AbstractTxt : "") )); BlogsData.Save(HttpContext.Current.Server.MapPath("~/App_Data/blogs.xml")); #region Tag section FormBlogTags _FormBlogTags = new FormBlogTags(); TagsModel _TagsModel = new TagsModel(); var _BlogsContexts = new BlogsContexts(); _FormBlogTags.BlogID = _BlogsModel.BlogID; if (_BlogsModel.SelectedTagsID != null) { foreach (var item in _BlogsModel.SelectedTagsID) { foreach (var i in item.Split(',')) { var _TagContexts = new TagsContexts(); var id = 0; var tagName = string.Empty; int n; var flag = false; bool isNumeric = int.TryParse(i, out n); if (isNumeric) { var formBlogtag_count = _BlogsContexts.GetAllFormBlogTags().Where(x => x.BlogID == _BlogsModel.BlogID && x.TagID == i.ToString()).Count(); if (formBlogtag_count == 0) { id = _TagContexts.GetTags().Where(x => x.TagID == Convert.ToInt32(i)).Select(x => x.TagID).FirstOrDefault(); tagName = _TagContexts.GetTags().Where(x => x.TagID == Convert.ToInt32(i)).Select(x => x.TagNameTxt).FirstOrDefault(); flag = true; } } else { id = 0; tagName = i; } if (id == 0) { _TagsModel.TagNameTxt = tagName; var IsTagName_exist = _TagContexts.GetTags().Where(x => x.TagNameTxt.ToLower().Trim() == tagName.ToLower().Trim()).Count(); if (IsTagName_exist == 0) { _TagContexts.AddTags(_TagsModel);// Add tags in tag context id = _TagContexts.GetTags().Select(x => x.TagID).Count() > 0 ? _TagContexts.GetTags().Select(x => x.TagID).Max() + 1 : 1; flag = true; } else { var tagID_exist = _TagContexts.GetTags().Where(x => x.TagNameTxt.ToLower().Trim() == tagName.ToLower().Trim()).Select(x => x.TagID).FirstOrDefault(); var formBlogtag_count = _BlogsContexts.GetAllFormBlogTags().Where(x => x.BlogID == _BlogsModel.BlogID && x.TagID == tagID_exist.ToString()).Count(); if (formBlogtag_count == 0) { id = tagID_exist; flag = true; } } } if (flag == true) { _FormBlogTags.BlogTagID = (int)(from S in BlogsTagsData.Descendants("FormBlogTag") orderby(short) S.Element("BlogTagID") descending select(short) S.Element("BlogTagID")).FirstOrDefault() + 1; BlogsTagsData.Root.Add(new XElement("FormBlogTag", new XElement("BlogTagID", _FormBlogTags.BlogTagID), new XElement("BlogID", _FormBlogTags.BlogID), new XElement("TagID", id))); BlogsTagsData.Save(HttpContext.Current.Server.MapPath("~/App_Data/formblogstag.xml")); } } } } #endregion #region social media FormBlogSocialMedia _FormBlogSM = new FormBlogSocialMedia(); _FormBlogSM.BlogID = _BlogsModel.BlogID; if (_BlogsModel.SelectedSocialMedia != null) { foreach (var item in _BlogsModel.SelectedSocialMedia) { _FormBlogSM.BlogSocialMediaID = (int)(from S in BlogsSocialMediaData.Descendants("FormBlogSocialMedia") orderby(short) S.Element("BlogSocialMediaID") descending select(short) S.Element("BlogSocialMediaID")).FirstOrDefault() + 1; BlogsSocialMediaData.Root.Add(new XElement("FormBlogSocialMedia", new XElement("BlogSocialMediaID", _FormBlogSM.BlogSocialMediaID), new XElement("BlogID", _FormBlogSM.BlogID), new XElement("SocialMediaID", item))); } BlogsSocialMediaData.Save(HttpContext.Current.Server.MapPath("~/App_Data/formblogssocialmedia.xml")); } #endregion }