private void GetData() { string SaveTheDateConnection = ConfigurationManager.ConnectionStrings["iMascotConnectionString"].ConnectionString; using (iMascotModelDataContext SaveTheDateDB = new iMascotModelDataContext(SaveTheDateConnection)) { GridView1.DataSource = SaveTheDateDB.PageContents; GridView1.DataBind(); } }
private void GetPageContents() { string iMascotConnection = ConfigurationManager.ConnectionStrings["iMascotConnectionString"].ConnectionString; using (iMascotModelDataContext SaveTheDateDB = new iMascotModelDataContext(iMascotConnection)) { var content = SaveTheDateDB.PageContents.FirstOrDefault(something => something.PageName == Page.Title); if (content != null) this.PageContents.Text = content.Content; } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string ItemID = GridView1.DataKeys[e.RowIndex].Values["ContentID"].ToString(); string SaveTheDateConnection = ConfigurationManager.ConnectionStrings["iMascotConnectionString"].ConnectionString; using (iMascotModelDataContext SaveTheDateDB = new iMascotModelDataContext(SaveTheDateConnection)) { var Item = SaveTheDateDB.PageContents.FirstOrDefault(ab => ab.ContentID.ToString() == ItemID); SaveTheDateDB.PageContents.DeleteOnSubmit(Item); SaveTheDateDB.SubmitChanges(); GridView1.DataSource = SaveTheDateDB.PageContents; GridView1.DataBind(); } }
private void GetData(int TemplateID) { using (iMascotModelDataContext SaveTheDateDB = new iMascotModelDataContext(SaveTheDateConnection)) { SaveTheDateDB.ObjectTrackingEnabled = false; var Item = SaveTheDateDB.EmailTemplates.FirstOrDefault(ab => ab.TemplateID == TemplateID); if (Item != null) { DropDownList1.Items.FindByValue(TemplateID.ToString()).Selected = true; txtMailSubject.Text = Item.MailSubject; CKEditor1.Text = Item.MailBody; } else { txtMailSubject.Text = string.Empty; CKEditor1.Text = string.Empty; } } }
protected void Page_Load(object sender, EventArgs e) { ItemID = Request.QueryString["ItemId"]; if (!Page.IsPostBack) { if (!string.IsNullOrEmpty(ItemID)) { using (iMascotModelDataContext SaveTheDateDB = new iMascotModelDataContext(SaveTheDateConnection)) { SaveTheDateDB.ObjectTrackingEnabled = false; var Item = SaveTheDateDB.PageContents.FirstOrDefault(ab => ab.ContentID.ToString() == ItemID); if (Item != null) { txtPageTitle.Text = Item.PageName; CKEditor1.Text = Item.Content; } } } } }
protected void btnSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(ItemID)) return; using (iMascotModelDataContext SaveTheDateDB = new iMascotModelDataContext(SaveTheDateConnection)) { var Item = SaveTheDateDB.PageContents.FirstOrDefault(ab => ab.ContentID.ToString() == ItemID); if (Item == null) { PageContent pageCont = new PageContent { ContentID = Guid.NewGuid(), PageName = txtPageTitle.Text, Content = CKEditor1.Text }; SaveTheDateDB.PageContents.InsertOnSubmit(pageCont); } else { Item.Content = CKEditor1.Text; Item.PageName = txtPageTitle.Text; } SaveTheDateDB.SubmitChanges(); } Response.Redirect("PageList.aspx"); }
protected void btnSave_Click(object sender, EventArgs e) { using (iMascotModelDataContext SaveTheDateDB = new iMascotModelDataContext(SaveTheDateConnection)) { var Item = SaveTheDateDB.EmailTemplates.FirstOrDefault(ab => ab.TemplateID == int.Parse(DropDownList1.SelectedValue)); if (Item == null) { Model.EmailTemplate emailTemplate = new Model.EmailTemplate { TemplateID = int.Parse(DropDownList1.SelectedValue), MailSubject = txtMailSubject.Text, MailBody = CKEditor1.Text }; SaveTheDateDB.EmailTemplates.InsertOnSubmit(emailTemplate); } else { Item.MailBody = CKEditor1.Text; Item.MailSubject = txtMailSubject.Text; } SaveTheDateDB.SubmitChanges(); } }
private void DeleteGuest(string[] UserIDs) { string SaveTheDateConnection = ConfigurationManager.ConnectionStrings["iMascotConnectionString"].ConnectionString; using (iMascotModelDataContext SaveTheDateDB = new iMascotModelDataContext(SaveTheDateConnection)) { foreach (string UserId in UserIDs) { if (!string.IsNullOrEmpty(UserId)) { var Item = SaveTheDateDB.Guests.FirstOrDefault(ab => ab.UserId.ToString() == UserId); var MemberData = SaveTheDateDB.aspnet_Users.FirstOrDefault(ab => ab.UserId.ToString() == UserId); SaveTheDateDB.Guests.DeleteOnSubmit(Item); SaveTheDateDB.SubmitChanges(); Membership.DeleteUser(MemberData.UserName, true); } } } GetData(); }
private void SendMail(string[] UserIDs) { string SaveTheDateConnection = ConfigurationManager.ConnectionStrings["iMascotConnectionString"].ConnectionString; using (iMascotModelDataContext SaveTheDateDB = new iMascotModelDataContext(SaveTheDateConnection)) { var templateInfo = SaveTheDateDB.EmailTemplates.FirstOrDefault(ab => ab.TemplateID == 1); if (templateInfo == null) { return; } string MailSubject = templateInfo.MailSubject ; foreach (string UserId in UserIDs) { if (!string.IsNullOrEmpty(UserId)) { Guid providerUserKey = new Guid(UserId); MembershipUser user = Membership.GetUser(providerUserKey); var usersToken = from ab in SaveTheDateDB.MailTokens where ab.UserId == providerUserKey select ab; SaveTheDateDB.MailTokens.DeleteAllOnSubmit(usersToken); SaveTheDateDB.SubmitChanges(); MailToken mtoken = new MailToken(); mtoken.UserId = providerUserKey; mtoken.UserName = user.UserName; mtoken.EmailToken = Guid.NewGuid(); SaveTheDateDB.MailTokens.InsertOnSubmit(mtoken); SaveTheDateDB.SubmitChanges(); MailMessage msg = new MailMessage(); string MailBody = templateInfo.MailBody.Replace("[!UserName]", user.UserName).Replace("[!Url]" , "<a href=\"" + BaseVirtualAppPath + "/ResetPassword.aspx?MailToken=" + mtoken.EmailToken.ToString() + "\">here</a>"); msg.To.Add(user.Email); msg.Subject = MailSubject.Trim(); msg.IsBodyHtml = true; msg.Body = MailBody; SmtpClient smtp = new SmtpClient(); smtp.EnableSsl = true; smtp.Send(msg); var userInfo = SaveTheDateDB.Guests.First(ab => ab.UserId.ToString() == UserId); userInfo.InvitationMail = DateTime.Now; SaveTheDateDB.SubmitChanges(); } } } }