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();
}
