protected void Insert_Button_Click(object sender, EventArgs e)
{
MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring);
dbconn.Open();
string[] lRecords = CommonClass.FetchRecords("ADD_TEMPLATES",
new string[]
{
"P_TEMPLATE_TYPE",
"P_SMS_TEMPLATE_MESSAGE",
"P_EMAIL_TEMPLATE_MESSAGE",
"P_EMAIL_SUBJECT"
},
new string[]
{
Server.HtmlEncode((Detail_Form_View.FindControl("Template_Type") as TextBox).Text),
Server.HtmlEncode((Detail_Form_View.FindControl("Sms_Template_Message") as TextBox).Text),
Server.HtmlEncode((Detail_Form_View.FindControl("Email_Template_Message") as AjaxControlToolkit.HTMLEditor.Editor).Content),
Server.HtmlEncode((Detail_Form_View.FindControl("Email_Subject") as TextBox).Text)
},
new string[]
{
"P_ERROR_MESSAGE"
},
dbconn);
if (lRecords[0] != null && lRecords[0] != "")
{
(Detail_Form_View.FindControl("Message") as Label).Text = lRecords[0];
return;
}
MultiView1.SetActiveView(Templates_View);
Load_Templates(dbconn);
dbconn.Close();
}
protected void Update_Button_Click(object sender, EventArgs e)
{
MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring);
dbconn.Open();
CommonClass.ExecuteQuery("UPDATE_TEMPLATE",
new string[]
{
"P_TEMPLATE_ID",
"P_TEMPLATE_TYPE",
"P_SMS_TEMPLATE_MESSAGE",
"P_EMAIL_TEMPLATE_MESSAGE",
"P_EMAIL_SUBJECT"
},
new string[]
{
Detail_Form_View.DataKey.Value.ToString(),
Server.HtmlEncode((Detail_Form_View.FindControl("Template_Type") as TextBox).Text),
Server.HtmlEncode((Detail_Form_View.FindControl("Sms_Template_Message") as TextBox).Text),
Server.HtmlEncode((Detail_Form_View.FindControl("Email_Template_Message") as AjaxControlToolkit.HTMLEditor.Editor).Content),
Server.HtmlEncode((Detail_Form_View.FindControl("Email_Subject") as TextBox).Text)
},
dbconn);
MultiView1.SetActiveView(Templates_View);
Load_Templates(dbconn);
dbconn.Close();
}
protected void Add_New_Button_Click(object sender, EventArgs e)
{
MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring);
dbconn.Open();
MultiView1.SetActiveView(Detail_View);
Detail_Form_View.ChangeMode(FormViewMode.Insert);
Load_Template_By_Id(dbconn,
"");
dbconn.Close();
}
protected void Templates_ListView_ItemEditing(object sender, ListViewEditEventArgs e)
{
//Templates_ListView.EditIndex = e.NewEditIndex;
MultiView1.SetActiveView(Detail_View);
Detail_Form_View.ChangeMode(FormViewMode.Edit);
MySqlConnection dbconn = new MySqlConnection(CommonClass.connectionstring);
dbconn.Open();
Load_Template_By_Id(dbconn,
Templates_ListView.DataKeys[e.NewEditIndex].Value.ToString());
dbconn.Close();
}
