private void SaveReply()
{
bool isSuccess = false;
string username = Request.Cookies["Speedo"]["UserName"];
int threadID = Request.QueryString["threadid"].ToInt();
ThreadDataContext sdc = new ThreadDataContext();
try
{
ThreadReply tr = new ThreadReply
{
ThreadID = threadID,
Username = username,
ReplyContents = ckeReply.Text,
DateReply = DateTime.Now
};
sdc.ThreadReplies.InsertOnSubmit(tr);
sdc.SubmitChanges();
isSuccess = true;
}
catch (Exception ex)
{
DALPortal.LogError(username, MethodBase.GetCurrentMethod().ReflectedType.ToString(), MethodBase.GetCurrentMethod().Name, ex.Message);
}
finally
{
sdc.Dispose();
}
if (isSuccess)
{
Response.Redirect("Thread.aspx?threadid=" + threadID.ToString() + "&page=1");
}
}
private void InitializeFields()
{
int replyID = Request.QueryString["threadreplyid"].ToInt();
string replyContents = "";
ckeContents.config.toolbar = new object[]
{
new object[] { "Cut", "Copy", "Paste", "PasteText", "-", "SpellChecker" },
new object[] { "Undo", "Redo", "-", "-" },
new object[] { "Bold", "Italic", "Underline", "Strike", "-", "Subscript", "Superscript" },
new object[] { "NumberedList", "BulletedList", "-", "Outdent", "Indent", "Blockquote", "CreateDiv" },
new object[] { "JustifyLeft", "JustifyCenter", "JustifyRight", "JustifyBlock" },
new object[] { "Link", "Unlink", "Anchor" },
new object[] { "Image", "Table", "HorizontalRule", "Smiley", "SpecialChar" },
new object[] { "Styles", "Format", "Font", "FontSize", "TextColor" }
};
using (ThreadDataContext tdc = new ThreadDataContext())
{
replyContents = (from tr in tdc.ThreadReplies
where tr.ThreadReplyID == replyID
select tr.ReplyContents).SingleOrDefault();
}
ckeContents.Text = replyContents;
}
private void InitializeFields()
{
using (PortalDataContext pdc = new PortalDataContext())
{
var qActivity = (from a in pdc.Activities
orderby a.ActivityID descending
select new
{
ActivityID = a.ActivityID,
Name = a.Name
}).ToList();
ddlActivity.DataSource = qActivity;
ddlActivity.DataValueField = "ActivityID";
ddlActivity.DataTextField = "Name";
ddlActivity.DataBind();
}
using (ThreadDataContext tdc = new ThreadDataContext())
{
var q = (from em in tdc.Employees
where em.pstatus == '1'
orderby em.lastname
select new
{
Usename = em.username,
Name = em.lastname + ", " + em.nickname
}).ToList();
ddlTeamMember.DataSource = q;
ddlTeamMember.DataValueField = "Usename";
ddlTeamMember.DataTextField = "Name";
ddlTeamMember.DataBind();
}
this.LoadAchievements();
}
protected int GetLastPage(int threadID)
{
int intPageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]);
int intTRows = 0;
int intTRowsTemp = 0;
int intPage = 1;
int intPageIndex = 0;
using (ThreadDataContext tdc = new ThreadDataContext())
{
intTRows = (from tr in tdc.ThreadReplies
where tr.ThreadID == threadID
select tr.ThreadReplyID).Count();
}
intTRowsTemp = intTRows;
while (intTRowsTemp > 0)
{
intPage += 1;
intPageIndex += intPageSize;
intTRowsTemp -= intPageSize;
}
return(intPage - 1);
}
public void LoadThreadDetails(int threadID)
{
Thread thread = new Thread();
using (ThreadDataContext tdc = new ThreadDataContext())
{
thread = (from t in tdc.Threads
where t.ThreadID == threadID
select t).SingleOrDefault();
}
if (thread == null)
{
Response.Redirect("Thread.aspx?threadid=" + threadID.ToString() + "&page=1");
}
else
{
lnkThreadList.NavigateUrl = "~/Threads/ThreadList.aspx?categoryid=" + thread.ThreadCategoryID.ToString();
lnkThreadList.Text = DALThread.GetCategoryName(thread.ThreadCategoryID.Value);
lnkThread.NavigateUrl = "~/Threads/Thread.aspx?threadid=" + threadID.ToString() + "&page=1";
lnkThread.Text = thread.Title;
lnkThreadEdit.NavigateUrl = "~/Threads/ThreadEdit.aspx?threadid=" + threadID.ToString();
txtTitle.Text = thread.Title;
txtDescription.Text = thread.Description;
ddlCategory.SelectedValue = thread.ThreadCategoryID.Value.ToString();
ddlType.SelectedValue = thread.ThreadTypeID.Value.ToString();
chkPostAnnouncement.Checked = thread.IsPosted.Value;
chkIsAllowReply.Checked = thread.IsAllowedReply.Value;
chkHideThread.Checked = !thread.IsActive.Value;
ckeContents.Text = thread.Contents;
chkIsPrivate.Checked = thread.IsPrivate.Value;
divPrivateList.Visible = chkIsPrivate.Checked;
}
}
protected void LoadPostHome()
{
string strWrite = "";
List <Thread> threadList = new List <Thread>();
using (ThreadDataContext tdc = new ThreadDataContext())
{
threadList = (from t in tdc.Threads
where t.IsPosted == true && t.IsActive == true
orderby t.PostedDate descending
select t).ToList();
}
foreach (Thread t in threadList)
{
strWrite += "<div class='ChildPagePanel'>" +
"<table>" +
"<tr>" +
"<td valign='top'>" +
"<h2><a href='Threads/Thread.aspx?threadid=" + t.ThreadID.ToString() + "&page=1'>" + t.Title + "</a></h2>" +
" by <a href='Userpage/Userpage.aspx?username="******"'>" + t.PostedBy + "</a> " + t.PostedDate.Value.ToString("ddd MMM, dd, yyyy") +
(t.Description.Length == 0 ? "" : "<br /><br />" + "<span style='font-size:small;'>" + t.Description + "<br><br><a href='Threads/Thread.aspx?threadid=" + t.ThreadID.ToString() + "&page=1'>Read More</a></span>") +
"</td>" +
"</tr>" +
"</table>" +
"</div>";
}
litPostHome.Text = strWrite;
}
protected void LoadPosts()
{
string strWrite = "";
List <Thread> threadList = new List <Thread>();
using (ThreadDataContext sdc = new ThreadDataContext())
{
threadList = (from t in sdc.Threads
where t.ThreadTypeID == SynergyAdminThreadTypeID &&
t.IsActive == true
orderby t.PostedDate descending
select t).ToList();
}
foreach (Thread t in threadList)
{
strWrite += "<div class='border' style='padding-top:10px;padding-left:10px;padding-right:10px;padding-bottom:10px; background-image: none; background-color: aliceblue; margin-bottom: 9px;'>" +
"<table>" +
"<tr>" +
"<td valign='top'>" +
"<h2><a href='../Threads/Thread.aspx?threadid=" + t.ThreadID + "&page=1'>" + t.Title + "</a></h2>" +
" Posted by <a href='Userpage/Userpage.aspx?username="******"'>" + t.PostedBy + "</a> " + t.PostedDate.Value.ToString("ddd MMM, dd, yyyy") +
"<br /><br />" +
"<span style='font-size:small;'>" + t.Description + "<br><br><a href='../Threads/Thread.aspx?threadid=" + t.ThreadID + "&page=1'>Read More</a></span>" +
"</td>" +
"</tr>" +
"</table>" +
"</div>";
}
litAnnouncements.Text = strWrite;
}
private void LoadPrivateUsers()
{
List <string> selectedEmployees = new List <string>();
foreach (ListItem itm in cblThreadMembers.Items)
{
selectedEmployees.Add(itm.Value);
}
using (ThreadDataContext tdc = new ThreadDataContext())
{
var q = (from em in tdc.Employees
where em.pstatus.Value == '1' &&
!(from se in selectedEmployees
select se).Contains(em.username)
orderby em.lastname
select new
{
Username = em.username,
Name = em.lastname + ", " + em.nickname
}).ToList();
cblEmployeeList.DataSource = q;
cblEmployeeList.DataValueField = "Username";
cblEmployeeList.DataTextField = "Name";
cblEmployeeList.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
clsSpeedo.Authenticate();
if (clsThreadCategoryUser.IsAllowedToAccess(Request.Cookies["Speedo"]["UserName"]))
{
btnNew.Visible = true;
}
else
{
btnNew.Visible = false;
}
if (!Page.IsPostBack)
{
string threadCategoryName = "";
int threadCategoryID = Request.QueryString["categoryid"].ToInt();
using (ThreadDataContext tdc = new ThreadDataContext())
{
threadCategoryName = (from tc in tdc.ThreadCategories
where tc.ThreadCategoryID == threadCategoryID
select tc.Name).SingleOrDefault();
}
litCategoryName.Text = threadCategoryName;
}
this.LoadThreads();
this.LoadPaging();
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (ThreadDataContext tdc = new ThreadDataContext())
{
Thread thread = tdc.Threads.Where(p => p.ThreadID == hdnThreadID.Value.ToInt()).Single();
if (thread != null)
{
thread.ThreadID = hdnThreadID.Value.ToInt();
thread.ThreadCategoryID = ddlCategory.SelectedValue.ToInt();
thread.ThreadTypeID = ddlType.SelectedValue.ToInt();
thread.Title = txtTitle.Text;
thread.Description = txtDescription.Text;
thread.Contents = ckeContents.Text;
thread.IsAllowedReply = chkIsAllowReply.Checked;
thread.IsPosted = chkPostAnnouncement.Checked;
thread.IsActive = !chkHideThread.Checked;
thread.IsSticky = false;
if (fuAttachment.HasFile)
{
string fileName = System.Guid.NewGuid().ToString() + "." + Path.GetExtension(fuAttachment.FileName);
fuAttachment.SaveAs(Server.MapPath(@"~\App_Attachments\" + fileName));
thread.AttachedFileName = fileName;
thread.AttachedFileDescription = (txtAttachment.Text.Length == 0 ? "Attached File" : txtAttachment.Text);
}
tdc.SubmitChanges();
}
}
Response.Redirect("Thread.aspx?threadid=" + hdnThreadID.Value + "&page=1");
}
protected void btnInclude_Click(object sender, EventArgs e)
{
List <ThreadPrivateUser> tpuList = new List <ThreadPrivateUser>();
foreach (ListItem itm in cblEmployeeList.Items)
{
if (itm.Selected)
{
ThreadPrivateUser tpu = new ThreadPrivateUser()
{
ThreadID = hdnThreadID.Value.ToInt(),
Username = itm.Value
};
tpuList.Add(tpu);
}
}
if (tpuList.Count > 0)
{
using (ThreadDataContext tdc = new ThreadDataContext())
{
tdc.ThreadPrivateUsers.InsertAllOnSubmit(tpuList);
tdc.SubmitChanges();
}
}
this.LoadPrivateUsers(hdnThreadID.Value.ToInt());
}
private void LoadThreadTypeUsers()
{
using (ThreadDataContext tdc = new ThreadDataContext())
{
var qIncluded = (from ttu in tdc.ThreadTypesUsers
where ttu.ThreadTypeID == ddlThreadType.SelectedValue.ToInt()
orderby ttu.Username
select new
{
ThreadTypeUserID = ttu.ThreadTypeUserID,
Username = ttu.Username
}).ToList();
cblThreadTypeUsers.DataSource = qIncluded;
cblThreadTypeUsers.DataValueField = "ThreadTypeUserID";
cblThreadTypeUsers.DataTextField = "Username";
cblThreadTypeUsers.DataBind();
var qExcluded = (from u in tdc.Users
where u.pstatus.Value == '1' &&
!(from ttu in tdc.ThreadTypesUsers
where ttu.ThreadTypeID == ddlThreadType.SelectedValue.ToInt()
select ttu.Username).Contains(u.username)
orderby u.username
select new { Username = u.username }).ToList();
cblEmployeeList.DataSource = qExcluded;
cblEmployeeList.DataValueField = "username";
cblEmployeeList.DataTextField = "username";
cblEmployeeList.DataBind();
}
}
protected void LoadForums()
{
string writeBuffer = "";
List <ThreadGroup> threadGroupList = new List <ThreadGroup>();
using (ThreadDataContext tdc = new ThreadDataContext())
{
threadGroupList = (from tg in tdc.ThreadGroups
orderby tg.SortOrder
select tg).ToList();
foreach (ThreadGroup tg in threadGroupList)
{
writeBuffer += "<div class='GridBorder'>" +
"<table width='100%' cellpadding='5' class='grid'>" +
"<tr>" +
"<td colspan='4' align='center' class='GridText' style='text-align:left;font-size:small;'>" +
"<table>" +
"<tr>" +
"<td><img src='../Support/AppHead.png' alt='' /></td>" +
"<td><b>" + tg.Name + "</b></td>" +
"<tr>" +
"</table>" +
"</td>" +
"</tr>";
List <ThreadCategory> threadCategoryList = new List <ThreadCategory>();
threadCategoryList = (from tc in tdc.ThreadCategories
where tc.ThreadGroupID == tg.ThreadGroupID
orderby tc.Name
select tc).ToList();
foreach (ThreadCategory tc in threadCategoryList)
{
writeBuffer += "<tr>" +
"<td class='GridRows'>" +
"<table cellpadding='0' cellspacing='0'>" +
"<tr>" +
"<td><img src='../Support/folderyellow32.png' /> </td>" +
"<td><a href='ThreadList.aspx?categoryid=" + tc.ThreadCategoryID.ToString() + "&page=1' style='font-size:small;'>" + tc.Name + "</a><br>" + tc.Description + "</td>" +
"</tr>" +
"</table>" +
"</td>" +
"</tr>";
}
writeBuffer += "</table></div><br>";
}
}
litForums.Text = writeBuffer;
}
protected void btnSaveChanges_Click(object sender, EventArgs e)
{
int replyID = Request.QueryString["threadreplyid"].ToInt();
using (ThreadDataContext tdc = new ThreadDataContext())
{
ThreadReply tr = tdc.ThreadReplies.Where(p => p.ThreadReplyID == replyID).SingleOrDefault();
tr.ReplyContents = ckeContents.Text;
tdc.SubmitChanges();
}
Response.Redirect("Thread.aspx?threadid=" + Request.QueryString["threadid"] + "&page=1");
}
private string GetPosition(string username)
{
string title = "";
using (ThreadDataContext tdc = new ThreadDataContext())
{
title = (from e in tdc.Employees
where e.username == username
select e.position).SingleOrDefault();
}
return(title);
}
private int CountReplies(int threadID)
{
int replyCount = 0;
using (ThreadDataContext tdc = new ThreadDataContext())
{
replyCount = (from tr in tdc.ThreadReplies
where tr.ThreadID == threadID
select tr.ThreadReplyID).Count();
}
return(replyCount);
}
private bool IsAllowedToView(int threadID, string username)
{
bool isAllowed = false;
using (ThreadDataContext tdc = new ThreadDataContext())
{
isAllowed = (from tpu in tdc.ThreadPrivateUsers
where tpu.ThreadID == threadID && tpu.Username == username
select tpu.ThreadUserID).ToList().Count() > 0;
}
return(isAllowed);
}
private string GetName(string username)
{
string name = "";
using (ThreadDataContext tdc = new ThreadDataContext())
{
name = (from e in tdc.Employees
where e.username == username
select e.nickname + " " + e.lastname).SingleOrDefault();
}
return(name);
}
private bool IsAllowedToEdit(int threadID, string username)
{
string postedBy = string.Empty;
using (ThreadDataContext tdc = new ThreadDataContext())
{
postedBy = (from t in tdc.Threads
where t.ThreadID == threadID
select t.PostedBy).SingleOrDefault();
}
return(username == postedBy);
}
public static string GetCategoryName(int threadCategoryID)
{
string categoryName = string.Empty;
using (ThreadDataContext tdc = new ThreadDataContext())
{
categoryName = (from tc in tdc.ThreadCategories
where tc.ThreadCategoryID == threadCategoryID
select tc.Name).SingleOrDefault();
}
return(categoryName);
}
private bool IsAuthorizedToEdit(string username, int replyID)
{
bool isAuthorized = false;
using (ThreadDataContext tdc = new ThreadDataContext())
{
isAuthorized = (from tr in tdc.ThreadReplies
where tr.Username == username && tr.ThreadReplyID == replyID
select tr.ThreadReplyID).Count() > 0;
}
return(isAuthorized);
}
private void InitializeFields()
{
int threadCategoryID = Request.QueryString["categoryid"].ToInt();
string username = Request.Cookies["Speedo"]["UserName"];
ckeContents.config.toolbar = new object[]
{
new object[] { "Cut", "Copy", "Paste", "PasteText", "-", "SpellChecker" },
new object[] { "Undo", "Redo", "-", "-" },
new object[] { "Bold", "Italic", "Underline", "Strike", "-", "Subscript", "Superscript" },
new object[] { "NumberedList", "BulletedList", "-", "Outdent", "Indent", "Blockquote", "CreateDiv" },
new object[] { "JustifyLeft", "JustifyCenter", "JustifyRight", "JustifyBlock" },
new object[] { "Link", "Unlink", "Anchor" },
new object[] { "Image", "Table", "HorizontalRule", "Smiley", "SpecialChar" },
new object[] { "Styles", "Format", "Font", "FontSize", "TextColor" }
};
trPostHome.Visible = DALThread.IsAllowedPostHome(username);
using (ThreadDataContext tdc = new ThreadDataContext())
{
//var qCategory = (from tc in tdc.ThreadCategories
// where tc.IsActive==true
// orderby tc.Name
// select new { ThreadCategoryID = tc.ThreadCategoryID, Name = tc.Name }).ToList();
//ddlCategory.DataSource = qCategory;
//ddlCategory.DataValueField = "ThreadCategoryID";
//ddlCategory.DataTextField = "Name";
//ddlCategory.DataBind();
//ddlCategory.SelectedValue = threadCategoryID.ToString();
ddlCategory.DataSource = clsThreadCategoryUser.GetDSLThreadCategoryPerUser(Request.Cookies["Speedo"]["UserName"]);
ddlCategory.DataValueField = "ThreadCategoryID";
ddlCategory.DataTextField = "Name";
ddlCategory.DataBind();
var qType = (from tt in tdc.ThreadTypes
where tt.IsPrivate == false ||
(from ttu in tdc.ThreadTypesUsers
where ttu.Username == username
select ttu.ThreadTypeUserID).Count() > 0
orderby tt.Title
select new { ThreadTypeID = tt.ThreadTypeID, Name = tt.Title }).ToList();
ddlType.DataSource = qType;
ddlType.DataValueField = "ThreadTypeID";
ddlType.DataTextField = "Name";
ddlType.DataBind();
}
}
private void LoadCategory()
{
using (ThreadDataContext tdc = new ThreadDataContext())
{
var q = (from tc in tdc.ThreadCategories
where tc.IsActive == true
orderby tc.Name
select new { ThreadCategoryID = tc.ThreadCategoryID, Name = tc.Name }).ToList();
ddlThreadCategory.DataSource = q;
ddlThreadCategory.DataValueField = "ThreadCategoryID";
ddlThreadCategory.DataTextField = "Name";
ddlThreadCategory.DataBind();
}
}
private void LoadThread(int threadCategoryID)
{
using (ThreadDataContext tdc = new ThreadDataContext())
{
var q = (from t in tdc.Threads
where t.ThreadCategoryID == threadCategoryID
orderby t.Title
select new { ThreadID = t.ThreadID, Title = t.Title }).ToList();
ddlThread.DataSource = q;
ddlThread.DataValueField = "ThreadID";
ddlThread.DataTextField = "Title";
ddlThread.DataBind();
}
}
private void InsertView(int threadID, string username)
{
using (ThreadDataContext pdc = new ThreadDataContext())
{
ThreadView tv = new ThreadView()
{
ThreadID = threadID,
Username = username,
DateViewed = DateTime.Now
};
pdc.ThreadViews.InsertOnSubmit(tv);
pdc.SubmitChanges();
}
}
private void InitializeFields()
{
using (ThreadDataContext tdc = new ThreadDataContext())
{
var q = (from tt in tdc.ThreadTypes
where tt.IsPrivate == true
orderby tt.Title
select new
{
ThreadTypeID = tt.ThreadTypeID,
Title = tt.Title
}).ToList();
ddlThreadType.DataSource = q;
ddlThreadType.DataValueField = "ThreadTypeID";
ddlThreadType.DataTextField = "Title";
ddlThreadType.DataBind();
}
}
protected void btnRemove_Click(object sender, EventArgs e)
{
using (ThreadDataContext tdc = new ThreadDataContext())
{
foreach (ListItem itm in cblThreadTypeUsers.Items)
{
if (itm.Selected)
{
ThreadTypesUser threadTypeUser = (from ttu in tdc.ThreadTypesUsers
where ttu.ThreadTypeUserID == itm.Value.ToInt()
select ttu).SingleOrDefault();
tdc.ThreadTypesUsers.DeleteOnSubmit(threadTypeUser);
}
}
tdc.SubmitChanges();
}
this.LoadThreadTypeUsers();
}
protected void btnInclude_Click(object sender, EventArgs e)
{
using (ThreadDataContext tdc = new ThreadDataContext())
{
foreach (ListItem itm in cblEmployeeList.Items)
{
if (itm.Selected)
{
ThreadTypesUser ttu = new ThreadTypesUser()
{
ThreadTypeID = ddlThreadType.SelectedValue.ToInt(),
Username = itm.Value
};
tdc.ThreadTypesUsers.InsertOnSubmit(ttu);
}
}
tdc.SubmitChanges();
}
this.LoadThreadTypeUsers();
}
private void LoadPrivateUsers(int threadID)
{
using (ThreadDataContext tdc = new ThreadDataContext())
{
var qIncluded = (from em in tdc.Employees
where (from tpu in tdc.ThreadPrivateUsers
where tpu.ThreadID == threadID
select tpu.Username).Contains(em.username) &&
em.pstatus.Value == '1'
orderby em.lastname
select new
{
Username = em.username,
Name = em.lastname + ", " + em.firname
}).ToList();
cblThreadMembers.DataSource = qIncluded;
cblThreadMembers.DataValueField = "Username";
cblThreadMembers.DataTextField = "Name";
cblThreadMembers.DataBind();
var qExcluded = (from em in tdc.Employees
where em.pstatus.Value == '1' &&
!(from tpu in tdc.ThreadPrivateUsers
where tpu.ThreadID == threadID
select tpu.Username).Contains(em.username)
orderby em.lastname
select new
{
Username = em.username,
Name = em.lastname + ", " + em.nickname
}).ToList();
cblEmployeeList.DataSource = qExcluded;
cblEmployeeList.DataValueField = "Username";
cblEmployeeList.DataTextField = "Name";
cblEmployeeList.DataBind();
}
}
public void LoadThreadDetails(int threadID)
{
Thread thread = new Thread();
using (ThreadDataContext tdc = new ThreadDataContext())
{
thread = (from t in tdc.Threads
where t.ThreadID == threadID
select t).SingleOrDefault();
}
if (thread == null)
{
Response.Redirect("Thread.aspx?threadid=" + threadID.ToString() + "&page=1");
}
else
{
txtTitle.Text = thread.Title;
txtDescription.Text = thread.Description;
ddlCategory.SelectedValue = thread.ThreadCategoryID.Value.ToString();
ddlType.SelectedValue = thread.ThreadTypeID.Value.ToString();
chkPostAnnouncement.Checked = thread.IsPosted.Value;
chkIsAllowReply.Checked = thread.IsAllowedReply.Value;
chkHideThread.Checked = !thread.IsActive.Value;
ckeContents.Text = thread.Contents;
chkIsPrivate.Checked = thread.IsPrivate.Value;
divPrivateList.Visible = chkIsPrivate.Checked;
try
{
if (thread.AttachedFileName.Length > 0 || thread.AttachedFileName != null)
{
txtAttachment.Text = thread.AttachedFileDescription;
litFileAttached.Text = " [<a runat='server' target='_blank' id='linkFileUploaded' href='../App_Attachments/" + thread.AttachedFileName + "' />" + thread.AttachedFileDescription + "</a>]";
}
}
catch { }
}
}
