protected void Button1_Click(object sender, EventArgs e) { string regin, fpi; if (drlistRegionCounty.Text != "") { regin = drlistRegionCounty.Text; } else { regin = txtregion.Text; } BAL.inmemorial objInmorial = new BAL.inmemorial(); objInmorial.name = txtname.Text; objInmorial.email = txtemail.Text; objInmorial.country = DropDownList1.Text; objInmorial.townCity = txtcitytown.Text; objInmorial.regionCounty = regin; string kk = DAL.htmlromve.StripTagsRegexCompiled(CKEditorControl1.Text); objInmorial.pmess = kk; objInmorial.mess = CKEditorControl1.Text; objInmorial.dessurname = txtdecsurname.Text; objInmorial.desname = txtdecname.Text; objInmorial.desemail = txtemaildes.Text; objInmorial.active = 1; if (FileUpload1.HasFile) { string path = Path.GetFileName(FileUpload1.FileName); string mm = DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString(); fpi = mm + path; FileUpload1.SaveAs(Server.MapPath("~/remembrance-garden-book/images/immemimg/") + fpi); } else { fpi = Request["flower"]; } objInmorial.img = fpi; DAL.general bjGen = new DAL.general(); bool f = bjGen.insertinmemorial(objInmorial); if (f) { ScriptManager.RegisterClientScriptBlock(this, GetType(), "Worng", "sucess();", true); } else { ScriptManager.RegisterClientScriptBlock(this, GetType(), "Worng", "worn();", true); } }
public void insert() { string regin; if (drlistRegionCounty.Text != "") { regin = drlistRegionCounty.Text; } else { regin = txtregion.Text; } BAL.inmemorial objInmorial = new BAL.inmemorial(); objInmorial.name = txtname.Text; objInmorial.email = txtemail.Text; objInmorial.country = DropDownList1.Text; objInmorial.townCity = txtcitytown.Text; objInmorial.regionCounty = regin; objInmorial.mess = CKEditorControl1.Text; string kk = DAL.htmlromve.StripTagsRegexCompiled(CKEditorControl1.Text); objInmorial.pmess = kk; objInmorial.dessurname = txtdecsurname.Text; objInmorial.desname = txtdecname.Text; objInmorial.desemail = txtemaildes.Text; objInmorial.active = 0; objInmorial.img = fpi; DAL.general bjGen = new DAL.general(); bool f = bjGen.insertinmemorial(objInmorial); if (f) { string body = infoBody1(txtname.Text, "", txtdecname.Text, txtdecsurname.Text, CKEditorControl1.Text, fpi); DAL.general objGen = new DAL.general(); string mbody = "<p align='left'>Dear Sir/Madam,<br><br>Thank you for creating an In Memoriam Notice. It will be reviewed within 24 hours.<br>You will receive an email notification once the In Memoriam is published.<br><br><br> Thank You, <br>BMDnotices Team<p/>"; objGen.Send_Mail(txtemail.Text, "BMDnotices In Memoriam", mbody, ""); string bodym = "<p align='left'>A new In Memoriam Notice has been created on bmdnotices.com.<br> <a href='http://bmdnotices.com/AdminBMD/login.aspx' target='_blank'>Approve here</a></p>"; // string bodym = "<p align='left'>one more message added on In Memory Card. page.</p>"; DAL.general objGener = new DAL.general(); objGener.Send_Mail("*****@*****.**", "New In Memoriam For Approval", bodym, ""); Response.Redirect("thankyoupostin.aspx"); } else { ScriptManager.RegisterClientScriptBlock(this, GetType(), "Worng", "worn();", true); } }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Approved") { BAL.inmemorial objrem = new BAL.inmemorial(); objrem.cid =Convert.ToInt32( e.CommandArgument); objrem.active = 0; DAL.general objGen = new DAL.general(); objGen.updateinmomoriyamstatus(objrem); } else if (e.CommandName == "Pending") { BAL.inmemorial objrem = new BAL.inmemorial(); objrem.cid = Convert.ToInt32(e.CommandArgument); objrem.active = 1; DAL.general objGen = new DAL.general(); bool f= objGen.updateinmomoriyamstatus(objrem); DataSet ds = objGen.getdataset("select * from inmemorialcardtdl where cid=" + Convert.ToInt32(e.CommandArgument) + ""); if(f) { try { string link= "http://bmdnotices.com/remembrance-garden-book/viewinmemoriam.aspx?cid=" + Convert.ToString(e.CommandArgument); string postNewInMemoriumLink = " <a href='http://www.bmdnotices.com/remembrance-garden-book/Post-inmemorial-card.aspx'>click here</a>."; string mail = "<p align='left'>Dear Sir/Madam,<br><br>The In Memoriam Notice you created has now been approved and is ready for you to view on bmdnotices.com website.<br>You are welcome to send as many In Memoriams as you like.<br>Please note that you can also add your messages, tributes and in memoriams to existing Pages in our Remembrance Garden Book. <br>If you would like to create such a Page, please"+postNewInMemoriumLink +"<br>You can view your In Memoriam Notice here: " + link + "<br><br><br> Thank You, <br>BMDnotices Team</p>"; // string mail = "<p align='left'>Dear Sir / Madam,<br><br>Your Card has now been approved and is ready for you to view on bmdnotices.com website.<br>You are welcome to send as many Cards as you like.<br>Please note that you can also add your messages, tributes and in memorials to existing Pages in our Remembrance Garden Book. <br>If you would like to create such a Page, please clik here.<br> You can view your Card here:" + link + "<br><br><br> Thank You, <br>BMDnotices Team"; objGen.Send_Mail(Convert.ToString(ds.Tables[0].Rows[0]["email"]), "BMDnotices In Memoriam Approved", mail, ""); string body = infoBody1(Convert.ToString(ds.Tables[0].Rows[0]["name"]), "", Convert.ToString(ds.Tables[0].Rows[0]["desname"]), Convert.ToString(ds.Tables[0].Rows[0]["dessurname"]), Convert.ToString(ds.Tables[0].Rows[0]["mess"]), Convert.ToString(ds.Tables[0].Rows[0]["img"])); string[] words = Convert.ToString(ds.Tables[0].Rows[0]["desemail"]).Split(','); foreach (string word in words) { objGen.Send_Mail(word, "BMDnotices In Memoriam Notice has been shared with you", body, ""); } } catch (Exception) { } } } else if (e.CommandName == "Delete") { BAL.inmemorial objrem = new BAL.inmemorial(); objrem.cid = Convert.ToInt32(e.CommandArgument); DAL.general objGen = new DAL.general(); objGen.deleteinmomoriyamstatus(objrem); } else { if (e.CommandName == ViewState["Column"].ToString()) { if (ViewState["Sortorder"].ToString() == "ASC") ViewState["Sortorder"] = "DESC"; else ViewState["Sortorder"] = "ASC"; } else { ViewState["Column"] = e.CommandName; ViewState["Sortorder"] = "ASC"; } } bindData1(); }