public XmlDocument AddTemplate(string UserID, string Password, string TemplateName, string HtmlContent)
{
XmlDocument doc = new XmlDocument();
StringBuilder str = new StringBuilder();
str.Append("<TemplateInfo>");
string Con = GetConnectionString(UserID, Password);
if (TemplateName.Trim().Length != 0 && Con.Trim().Length != 0 && HtmlContent.Trim().Length != 0)
{
TemplateMaster templateMaster = new TemplateMaster(Con);
templateMaster.TemplateName = TemplateName;
TemplateMasters tempMasters = TemplateMaster.SelectByField("TemplateName", TemplateName, Con);
if (tempMasters.Count > 0)
{
str.Append("<Message>Template Name Already Existed</Message>");
}
else
{
if (HtmlContent != "" && TemplateName != "")
{
templateMaster.HTMLContent = HtmlContent;
templateMaster.CreatedDate = DateTime.Now;
templateMaster.Insert();
str.Append("<Message>Template Added Successfully</Message>");
str.Append("</TemplateInfo>");
doc.LoadXml(str.ToString());
}
else
{
str.Append("<Message>Please Enter Valid Inputs</Message>");
}
}
}
else
{
str.Append("<Message>Please Enter Valid Inputs</Message>");
}
str.Append("</TemplateInfo>");
doc.LoadXml(str.ToString());
return doc;
}
//This method is modified by swaraj on 27 jan 2010
public void Save()
{
try
{
bool status;
TemplateMaster templateMaster = new TemplateMaster(ConnectionString);
string templatename = txtTemplateName.Text.Trim();
templateMaster.TemplateName = templatename; // txtTemplateName.Text;
templateMaster.TemplateDescription = txtDescription.Text;
//templateMaster.HTMLContent = RadEditor1.Content;//hdHtmlContent.Value.ToString();
if (RadEditor1.Content.Contains(verify))//(RadEditor1.Content.Contains("[!RPLINK:"))
{
htmlContent = ExtractLinks(RadEditor1.Content.ToString());
templateMaster.HTMLContent = htmlContent;
}
else
{
templateMaster.HTMLContent = RadEditor1.Content;
}
if (textRadEditor.Content.Contains(verify))
{
textContent = ExtractLinks(textRadEditor.Content.ToString());
templateMaster.TextContent = textContent;
}
else
{
templateMaster.TextContent = textRadEditor.Content;
}
lblMessage.Visible = true;
TemplateMasters tempMasters = TemplateMaster.SelectByField("TemplateName", templatename, ConnectionString); //txtTemplateName.Text);
if (templateID == 0)
{
if (tempMasters.Count > 0)
{
templateMaster.TemplateId = templateID;
lblMessage.Visible = true;
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "Template Name: " + txtTemplateName.Text + " exists already.";
stat = false;
return;
}
else
{
templateMaster.CreatedDate = System.DateTime.Now;
//templateMaster.ModifiedDate = System.DateTime.Now;
status = templateMaster.Insert();
if (status == true)
{
lblMessage.ForeColor = System.Drawing.Color.Green;
lblMessage.Text = "Template Name: " + txtTemplateName.Text + " has been Created Successfully";
stat = true;
insert = true;
}
}
}
else
{
templateMaster.TemplateId = Convert.ToInt64(templateID);//tempMasters[0].TemplateId;
if (tempMasters.Count > 0 && tempMasters[0].TemplateId != Convert.ToInt64(templateID))
{
lblMessage.Visible = true;
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "Template Name: " + txtTemplateName.Text + " exists already please select another Name.";
stat = false;
}
else
{
TemplateMasters template = TemplateMaster.SelectByField("TemplateId", templateID, ConnectionString);
templateMaster.CreatedDate = template[0].CreatedDate;
templateMaster.ModifiedDate = System.DateTime.Now;
status = templateMaster.Update();
if (status == true)
{
lblMessage.ForeColor = System.Drawing.Color.Green;
lblMessage.Text = "Template Name: " + txtTemplateName.Text + " Updated Successfully.";
stat = true;
insert = false;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}