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 InsertRecord() { string username = Request.Cookies["Speedo"]["UserName"]; ThreadDataContext sdc = new ThreadDataContext(); try { Thread thread = new Thread { ThreadCategoryID = ddlCategory.SelectedValue.ToInt(), ThreadTypeID = ddlType.SelectedValue.ToInt(), Title = txtTitle.Text, Description = txtDescription.Text, Contents = ckeContents.Text, IsAllowedReply = chkIsAllowReply.Checked, IsPosted = chkPostAnnouncement.Checked, IsPrivate = chkIsPrivate.Checked, IsActive = true, IsSticky = false, PostedBy = username, PostedDate = DateTime.Now, LastPostBy = username, LastPostDate = DateTime.Now, TotalReply = 0 }; 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); } sdc.Threads.InsertOnSubmit(thread); sdc.SubmitChanges(); if (chkIsPrivate.Checked) { foreach (ListItem itm in cblThreadMembers.Items) { ThreadPrivateUser tpu = new ThreadPrivateUser() { ThreadID = thread.ThreadID, Username = itm.Value }; sdc.ThreadPrivateUsers.InsertOnSubmit(tpu); } } sdc.SubmitChanges(); } catch (Exception ex) { DALPortal.LogError(username, MethodBase.GetCurrentMethod().ReflectedType.ToString(), MethodBase.GetCurrentMethod().Name, ex.Message); } finally { sdc.Dispose(); } Response.Redirect("ThreadList.aspx?categoryid=" + Request.QueryString["categoryid"] + "&page=1"); }