public void CreateMsg(string text,
Guid?chatID,
Guid userID,
string username)
{
DateTime datetimenow = TimeZoneManager.DateTimeNow;
using (Searchwar_netEntities db = new Searchwar_netEntities())
{
SW_chat chate = null;
if (!chatID.HasValue)
{
chate = new SW_chat();
chate.ChatId = Guid.NewGuid();
chate.ChatDateAdded = datetimenow;
chate.ChatDateEdit = datetimenow;
chate.ChatIsClosed = false;
db.SW_chat.AddObject(chate);
db.SaveChanges();
}
else
{
chate = db.SW_chat.SingleOrDefault(c => c.ChatId == chatID);
chate.ChatDateEdit = datetimenow;
chate.ChatIsClosed = false;
}
if (chate != null)
{
SW_ChatPerson createPerson = db.SW_ChatPersons.SingleOrDefault(p => p.ChatPersonId == userID);
if (createPerson == null)
{
createPerson = new SW_ChatPerson();
createPerson.ChatPersonId = userID;
createPerson.ChatPersonName = Membership.GetUser(userID) != null?Membership.GetUser(userID).UserName : username;
createPerson.ChatPersonDateAdded = datetimenow;
createPerson.ChatPersonDateEdit = datetimenow;
db.SW_ChatPersons.AddObject(createPerson);
db.SaveChanges();
}
SW_ChatMessage createText = new SW_ChatMessage();
createText.ChatId = chatID.Value;
createText.ChatMsgId = Guid.NewGuid();
createText.ChatPersonId = createPerson.ChatPersonId;
createText.ChatMsgText = text;
createText.ChatMsgDateAdded = datetimenow;
db.SW_ChatMessages.AddObject(createText);
db.SaveChanges();
}
}
}
/// <summary>
/// Insert SiteMapNodeRoles to cSiteMapNode
/// (Insert RoleIds with AddRoleId) (Remove RoleIds with RemoveRoleId)
///
/// Needed to know what cSiteMapNode you want to Insert SiteMapNodeRoles to!
/// (Insert SiteMapNodeIdsToList with AddSiteMapNodeId) (Remove SiteMapNodeIds with RemoveSiteMapNodeIdFromList)
/// </summary>
/// <param name="userId">Insert UserId</param>
/// <param name="siteMapNodeId">Insert siteMapNodeId</param>
public void AddAllSiteMapNodeRoles(Guid userId, int siteMapNodeId)
{
DateTime dateTimeNow = TimeZoneManager.DateTimeNow;
List <SW_SiteMapNodeRole> listOfAddedSiteMapNodeRoles;
// using statement free the memory after metode is done
using (Searchwar_netEntities db = new Searchwar_netEntities())
{
// Check Added RoleIds for empty
if (_roleIds.Count() != 0)
{
listOfAddedSiteMapNodeRoles = new List <SW_SiteMapNodeRole>();
foreach (Guid roleId in _roleIds)
{
aspnet_Role getRoleId = (db.aspnet_Roles.Where(r => r.RoleId.Equals(roleId))).SingleOrDefault();
// Check roleid in database
if (getRoleId != null)
{
SW_SiteMapNode getCurrentSiteMapNode = (db.SW_SiteMapNode.Where(
s => s.SiteMapNodeId.Equals(siteMapNodeId))).SingleOrDefault();
// Check roleid in database
if (getCurrentSiteMapNode != null)
{
SW_SiteMapNodeRole createRoleToSiteMapNode = new SW_SiteMapNodeRole
{
SiteMapNodeRoleAddedDate =
dateTimeNow,
SiteMapNodeRoleAddedUserId =
userId,
RoleId = roleId,
SiteMapNodeId = siteMapNodeId
};
listOfAddedSiteMapNodeRoles.Add(createRoleToSiteMapNode);
}
else
{
throw (new ArgumentNullException("siteMapNodeId", "Cant find siteMapNodeId '" + siteMapNodeId + "' in database"));
}
}
else
{
throw (new ArgumentNullException("roleId", "Cant find RoleId '" + roleId + "' in database"));
}
}
foreach (var item in listOfAddedSiteMapNodeRoles)
{
db.SW_SiteMapNodeRoles.AddObject(item);
}
}
db.SaveChanges();
}
}
public void OpenChat(Guid chatID)
{
DateTime datetimenow = TimeZoneManager.DateTimeNow;
Searchwar_netEntities db = new Searchwar_netEntities();
SW_chat chatobj = db.SW_chat.SingleOrDefault(c => c.ChatId == chatID);
if (chatobj != null)
{
chatobj.ChatIsClosed = false;
chatobj.ChatDateEdit = datetimenow;
}
db.SaveChanges();
}
/// <summary>
/// Update MetaTags to a cSiteMapNode
/// </summary>
/// <param name="metaTagsId">Insert SiteMapNodeId</param>
/// <param name="langId">Insert LangId</param>
/// <param name="metaTagTitle">Insert Title</param>
/// <param name="metaTagDescription">Insert Desc</param>
/// <param name="metaTagKeywords">Insert keywords like "word, word, word"</param>
/// <param name="metaTagLanguage">Insert lang like "da" or "en"</param>
/// <param name="metaTagAuthor">Insert author</param>
/// <param name="metaTagPublisher">Insert publisher</param>
/// <param name="metaTagCopyright">Insert Copyright</param>
/// <param name="metaTagRevisitAfter">Insert Revisitafter like "7 days"</param>
/// <param name="metaTagRobots">Insert Robots like "index,follow"</param>
/// <param name="metaTagCache">Insert cache like "no-cache"</param>
/// <param name="metaTagCacheControl">Insert cachecontrol like "no-cache"</param>
/// <param name="newLangId">Insert newLangId</param>
/// <param name="userId">Insert UserId</param>
public void UpdateMetaTags(int metaTagsId,
int langId,
string metaTagTitle,
string metaTagDescription,
string metaTagKeywords,
string metaTagLanguage,
string metaTagAuthor,
string metaTagPublisher,
string metaTagCopyright,
string metaTagRevisitAfter,
string metaTagRobots,
string metaTagCache,
string metaTagCacheControl,
int?newLangId,
Guid userId)
{
DateTime dateTimeNow = TimeZoneManager.DateTimeNow;
// using statement free the memory after metode is done
using (Searchwar_netEntities db = new Searchwar_netEntities())
{
SW_SiteMapNodeMetaTag updateMeta = db.SW_SiteMapNodeMetaTags.Single <SW_SiteMapNodeMetaTag>(m => m.MetaTagsId.Equals(metaTagsId));
updateMeta.MetaTagsEditUserId = userId;
updateMeta.MetaTagsEditDate = dateTimeNow;
SW_SiteMapNodeMetaTagsData updateMetaData = updateMeta.SW_SiteMapNodeMetaTagsData.Single <SW_SiteMapNodeMetaTagsData>(d => d.MetaTagsId.Equals(metaTagsId) && d.LangId.Equals(langId));
updateMetaData.MetaTagsTitle = metaTagTitle;
updateMetaData.MetaTagsDescription = metaTagDescription;
updateMetaData.MetaTagsKeywords = metaTagKeywords;
updateMetaData.MetaTagsLanguage = metaTagLanguage;
updateMetaData.MetaTagsAuthor = metaTagAuthor;
updateMetaData.MetaTagsPublisher = metaTagPublisher;
updateMetaData.MetaTagsCopyright = metaTagCopyright;
updateMetaData.MetaTagsRevisitAfter = metaTagRevisitAfter;
updateMetaData.MetaTagsRobots = metaTagRobots;
updateMetaData.MetaTagsCache = metaTagCache;
updateMetaData.MetaTagsCacheControl = metaTagCacheControl;
if (newLangId.HasValue)
{
updateMetaData.LangId = newLangId.Value;
}
db.SaveChanges();
}
}
public void CloseChat(Guid chatID, int minutes)
{
DateTime datetimenow = TimeZoneManager.DateTimeNow;
Searchwar_netEntities db = new Searchwar_netEntities();
SW_chat chatobj = db.SW_chat.SingleOrDefault(c => c.ChatId == chatID);
if (chatobj != null)
{
if (chatobj.ChatDateEdit < datetimenow.AddMinutes(-minutes))
{
chatobj.ChatIsClosed = true;
chatobj.ChatDateEdit = datetimenow;
}
}
db.SaveChanges();
}
/// <summary>
/// Remove SiteMapNodeRoles from cSiteMapNode
/// (Insert RoleIds with AddRoleId) (Remove RoleIds with RemoveRoleId)
///
/// Needed to know what cSiteMapNode you want to delete SiteMapNodeRoles from!
/// (Insert SiteMapNodeIds with AddSiteMapNodeIdToList) (Remove SiteMapNodeIds with RemoveSiteMapNodeIdFromList)
/// </summary>
public void RemoveAllSiteMapNodeRoles()
{
// using statement free the memory after metode is done
using (Searchwar_netEntities db = new Searchwar_netEntities()) {
// Check RemoveRoleIds for empty
if (_roleIds.Count() != 0)
{
// Select all SiteMapNodeRoles
IQueryable <SW_SiteMapNodeRole> getSiteMapNodeRoles = (from r in db.SW_SiteMapNodeRoles
where _roleIds.Contains(r.RoleId)
select r).AsQueryable <SW_SiteMapNodeRole>();
// Convert to List and Remove all SiteMapNodeRoles
foreach (var item in getSiteMapNodeRoles)
{
db.SW_SiteMapNodeRoles.DeleteObject(item);
}
}
db.SaveChanges();
}
}
public void CreateBolig(string title,
string text,
int langid,
Guid UserID)
{
using (Searchwar_netEntities db = new Searchwar_netEntities())
{
SW_Blog createblog = new SW_Blog();
createblog.BlogAddedByUserId = UserID;
createblog.BlogEditByUserId = UserID;
createblog.BlogAddedDate = TimeZoneManager.DateTimeNow;
createblog.BlogEditDate = TimeZoneManager.DateTimeNow;
db.SaveChanges();
SW_BlogData createBlogData = new SW_BlogData();
createBlogData.BlogId = createblog.BlogId;
createBlogData.BlogText = text;
createBlogData.LangId = langid;
createBlogData.BlogTitle = title;
db.SW_Blog.AddObject(createblog);
}
}
/// <summary>
/// Insert a path in cSiteMapNode (Insert RoleIds with AddRoleId)
/// </summary>
/// <param name="path">Insert URL (Ex. ~/default.aspx)</param>
/// <param name="userId">Insert UserId</param>
/// <param name="showSiteMapNode">Show URL in menu or not? (true)Show - (false)Dont show in menu</param>
/// <param name="siteMapNodeSubId">If you want this URL like a sub for a URL, then insert ID of the URL</param>
/// <param name="title">Inser title of URL</param>
/// <param name="langaugeId">Insert ID of that langauge it write in</param>
/// <param name="metatagsObject">to add metatags to sitemap (just left it null if you dont want metatags with)</param>
protected void CreateSiteMapNode_Single(string path,
Guid userId,
bool showSiteMapNode,
int?siteMapNodeSubId,
string title,
int langaugeId,
int sort,
SiteMapNodeMetatagsObject m)
{
DateTime dateTimeNow = TimeZoneManager.DateTimeNow;
// using statement free the memory after metode is done
using (Searchwar_netEntities db = new Searchwar_netEntities())
{
SW_SiteMapNode createSiteMapNode = new SW_SiteMapNode
{
SiteMapNodePath = path,
SiteMapNodeAddedUserId = userId,
SiteMapNodeEditUserId = userId,
SiteMapNodeShow = showSiteMapNode,
SiteMapNodeEditDate = dateTimeNow,
SiteMapNodeAddedDate = dateTimeNow,
SiteMapNodeSort = sort
};
SW_SiteMapNodeData createSiteMapNodeData = new SW_SiteMapNodeData
{
LangId = langaugeId
};
// Check title for empty
if (!string.IsNullOrEmpty(title))
{
createSiteMapNodeData.SiteMapNodeTitle = title;
}
// Check SubId for empty
if (siteMapNodeSubId.HasValue)
{
SW_SiteMapNode siteMapNodeSub = (from s in db.SW_SiteMapNode
where s.SiteMapNodeId.Equals(siteMapNodeSubId)
select s).SingleOrDefault();
// Check path is in database
if (siteMapNodeSub != null)
{
createSiteMapNode.SiteMapNodeSubId = siteMapNodeSubId;
}
else
{
throw (new ArgumentNullException("siteMapNodeSubId", "Cant find SiteMapId '" + siteMapNodeSubId + "' in database"));
}
}
db.SW_SiteMapNode.AddObject(createSiteMapNode);
db.SaveChanges();
// Insert SiteMapId
createSiteMapNodeData.SiteMapNodeId = createSiteMapNode.SiteMapNodeId;
db.SW_SiteMapNodeData.AddObject(createSiteMapNodeData);
db.SaveChanges();
if (m != null)
{
new SearchWar.SiteMap.MetaTags.SiteMapNodeMetaTags().CreateMetaTags(createSiteMapNode.SiteMapNodeId,
m.MetaTagTitle,
m.MetaTagDescription,
m.MetaTagKeywords,
m.MetaTagLanguage,
m.MetaTagAuthor,
m.MetaTagPublisher,
m.MetaTagCopyright,
m.MetaTagRevisitAfter,
m.MetaTagRobots,
m.MetaTagCache,
m.MetaTagCacheControl,
userId,
langaugeId);
}
}
}
/// <summary>
/// Update a path in cSiteMapNode
/// (Insert RoleIds with AddRoleId and Remove RoleIds with RemoveRoleId)
/// </summary>
/// <param name="siteMapNodeId">Insert SiteMapId</param>
/// <param name="path">Insert URL (Ex. ~/default.aspx)</param>
/// <param name="userId">Insert UserId</param>
/// <param name="showSiteMapNode">Show URL in menu or not? (true)Show - (false)Dont show in menu</param>
/// <param name="siteMapNodeSubId">If you want this URL like a sub for a URL, then insert ID of the URL</param>
/// <param name="title">Inser title of URL</param>
/// <param name="langaugeId">Insert ID of that langauge it write in</param>
/// <param name="newLangId">Insert newLangId</param>
protected void UpdateSiteMap(int siteMapNodeId,
int langaugeId,
string path,
Guid userId,
bool showSiteMapNode,
int?siteMapNodeSubId,
string title,
int?newLangId,
int sort,
SiteMapNodeMetatagsObject m)
{
DateTime dateTimeNow = TimeZoneManager.DateTimeNow;
// using statement free the memory after metode is done
using (Searchwar_netEntities db = new Searchwar_netEntities())
{
SW_SiteMapNode siteMapNode = (from s in db.SW_SiteMapNode
where s.SiteMapNodeId.Equals(siteMapNodeId)
select s).SingleOrDefault();
// Check SiteMapId in database
if (siteMapNode != null)
{
siteMapNode.SiteMapNodePath = path;
siteMapNode.SiteMapNodeShow = showSiteMapNode;
siteMapNode.SiteMapNodeSubId = siteMapNodeSubId;
siteMapNode.SiteMapNodeEditUserId = userId;
siteMapNode.SiteMapNodeEditDate = dateTimeNow;
siteMapNode.SiteMapNodeSort = sort;
SW_SiteMapNodeData siteMapNodeData = siteMapNode.SW_SiteMapNodeData.Single <SW_SiteMapNodeData>(d => d.SiteMapNodeId.Equals(siteMapNodeId) && d.LangId.Equals(langaugeId));
siteMapNodeData.SiteMapNodeTitle = title;
if (newLangId.HasValue)
{
siteMapNodeData.LangId = newLangId.Value;
}
db.SaveChanges();
object checkMetaTags =
db.SW_SiteMapNodeMetaTags.Where(mt => mt.MetaTagsId == siteMapNodeId).SingleOrDefault();
if (m != null && checkMetaTags != null)
{
new SearchWar.SiteMap.MetaTags.SiteMapNodeMetaTags().UpdateMetaTags(siteMapNodeId,
langaugeId,
m.MetaTagTitle,
m.MetaTagDescription,
m.MetaTagKeywords,
m.MetaTagLanguage,
m.MetaTagAuthor,
m.MetaTagPublisher,
m.MetaTagCopyright,
m.MetaTagRevisitAfter,
m.MetaTagRobots,
m.MetaTagCache,
m.MetaTagCacheControl,
null,
userId);
}
}
else
{
throw (new ArgumentNullException("siteMapNodeId", "Cant find SiteMap '" + siteMapNodeId + "' in database"));
}
}
}
/// <summary>
/// Delete paths in SiteMapNodes
/// </summary>
protected void DeleteSiteMapNodes()
{
// using statement free the memory after metode is done
using (Searchwar_netEntities db = new Searchwar_netEntities()) {
// Check RemoveRoleIds for empty
if (_siteMapNodeIds.Count() > 0)
{
IQueryable <SW_SiteMapNode> deleteSiteMapNodes = (from s in db.SW_SiteMapNode
where _siteMapNodeIds.Contains(s.SiteMapNodeId)
select s).AsQueryable <SW_SiteMapNode>();
IQueryable <SW_SiteMapNodeData> deleteSiteMapNodesData = (from sd in db.SW_SiteMapNodeData
where _siteMapNodeIds.Contains(sd.SiteMapNodeId)
select sd).AsQueryable <SW_SiteMapNodeData>();
IQueryable <SW_SiteMapNodeRole> DeleteSiteMapNodesRoles = (from r in db.SW_SiteMapNodeRoles
where _siteMapNodeIds.Contains(r.SiteMapNodeId)
select r).AsQueryable <SW_SiteMapNodeRole>();
IQueryable <SW_SiteMapNodeMetaTag> deleteSiteMapNodesMetaTags = (from m in db.SW_SiteMapNodeMetaTags
where _siteMapNodeIds.Contains(m.MetaTagsId)
select m).AsQueryable <SW_SiteMapNodeMetaTag>();
IQueryable <SW_SiteMapNodeMetaTagsData> deleteSiteMapNodesMetaTagsData = (from md in db.SW_SiteMapNodeMetaTagsData
where _siteMapNodeIds.Contains(md.MetaTagsId)
select md).AsQueryable <SW_SiteMapNodeMetaTagsData>();
// Delete all SiteMapNodesMetaTagsData
foreach (var item in deleteSiteMapNodesMetaTagsData)
{
db.SW_SiteMapNodeMetaTagsData.DeleteObject(item);
}
// Delete all SiteMapNodesMetaTags
foreach (var item in deleteSiteMapNodesMetaTags)
{
db.SW_SiteMapNodeMetaTags.DeleteObject(item);
}
// Delete all SiteMapNodesRoles
foreach (var item in DeleteSiteMapNodesRoles)
{
db.SW_SiteMapNodeRoles.DeleteObject(item);
}
// Delete all SiteMapNodesData
foreach (var item in deleteSiteMapNodesData)
{
db.SW_SiteMapNodeData.DeleteObject(item);
}
// Delete all SiteMapNodes
foreach (var item in deleteSiteMapNodes)
{
db.SW_SiteMapNode.DeleteObject(item);
}
db.SaveChanges();
}
}
}
/// <summary>
/// Create MetaTags to a cSiteMapNode
/// </summary>
/// <param name="siteMapNodeId">Insert SiteMapNodeId</param>
/// <param name="metaTagTitle">Insert Title</param>
/// <param name="metaTagDescription">Insert Desc</param>
/// <param name="metaTagKeywords">Insert keywords like "word, word, word"</param>
/// <param name="metaTagLanguage">Insert lang like "da" or "en"</param>
/// <param name="metaTagAuthor">Insert author</param>
/// <param name="metaTagPublisher">Insert publisher</param>
/// <param name="metaTagCopyright">Insert Copyright</param>
/// <param name="metaTagRevisitAfter">Insert Revisitafter like "7 days"</param>
/// <param name="metaTagRobots">Insert Robots like "index,follow"</param>
/// <param name="metaTagCache">Insert cache like "no-cache"</param>
/// <param name="metaTagCacheControl">Insert cachecontrol like "no-cache"</param>
/// <param name="langaugeId">Insert ID of that langauge this metatags is write in</param>
/// <param name="userId">Insert UserId</param>
public void CreateMetaTags(int siteMapNodeId,
string metaTagTitle,
string metaTagDescription,
string metaTagKeywords,
string metaTagLanguage,
string metaTagAuthor,
string metaTagPublisher,
string metaTagCopyright,
string metaTagRevisitAfter,
string metaTagRobots,
string metaTagCache,
string metaTagCacheControl,
Guid userId,
int langaugeId)
{
DateTime dateTimeNow = TimeZoneManager.DateTimeNow;
// using statement free the memory after metode is done
using (Searchwar_netEntities db = new Searchwar_netEntities())
{
SW_SiteMapNode getCurrentSiteMapNode = (from s in db.SW_SiteMapNode
where s.SiteMapNodeId.Equals(siteMapNodeId)
select s).SingleOrDefault();
// Check cSiteMapNode
if (getCurrentSiteMapNode != null)
{
SW_SiteMapNodeMetaTag createMeta = new SW_SiteMapNodeMetaTag
{
MetaTagsId = siteMapNodeId,
MetaTagsAddedUserId = userId,
MetaTagsEditUserId = userId,
MetaTagsAddedDate = dateTimeNow,
MetaTagsEditDate = dateTimeNow
};
SW_SiteMapNodeMetaTagsData createMetaData = new SW_SiteMapNodeMetaTagsData
{
MetaTagsTitle = metaTagTitle,
MetaTagsDescription = metaTagDescription,
MetaTagsKeywords = metaTagKeywords,
MetaTagsLanguage = metaTagLanguage,
MetaTagsAuthor = metaTagAuthor,
MetaTagsPublisher = metaTagPublisher,
MetaTagsCopyright = metaTagCopyright,
MetaTagsRevisitAfter = metaTagRevisitAfter,
MetaTagsRobots = metaTagRobots,
MetaTagsCache = metaTagCache,
MetaTagsCacheControl = metaTagCacheControl,
LangId = langaugeId,
MetaTagsId = siteMapNodeId
};
db.SW_SiteMapNodeMetaTags.AddObject(createMeta);
db.SW_SiteMapNodeMetaTagsData.AddObject(createMetaData);
db.SaveChanges();
}
else
{
throw (new ArgumentNullException("siteMapNodeId", "Cant find siteMapNodeId '" + siteMapNodeId + "' in database"));
}
}
}