private void FillEMailTemplates()
{
string emailTemp = Request.Form["selEmailTemplate"]??"";
StringBuilder opts = new StringBuilder();
opts.Append("<option value=\"\"></option>");
BestEMailTemplate bem = new BestEMailTemplate();
bem.LoadRows();
for (int row = 0; row < bem.TableRows.Count; row++)
{
bem.currentRowId = row;
opts.Append("<option value=\"" + HttpUtility.HtmlEncode(bem.emialTemplateName) + "\"");
if (bem.emialTemplateName.Equals(emailTemp))
{
opts.Append(" selected=\"selected\" ");
}
opts.Append(">" + HttpUtility.HtmlEncode(bem.emialTemplateName) + "</option>");
}
ltrEMailTempOpts.Text = opts.ToString();
}
private string getEMailBody()
{
string result = "";
string emailTemp = Request.Form["selEmailTemplate"];
string emailDesc = Request.Form["emailDesc"];
if (!string.IsNullOrEmpty(emailTemp))
{
BestField bsf = new BestField() { fieldName = "emailtemp", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 50 };
bsf.fieldValue = emailTemp;
List<BestField> bparam = new List<BestField>();
bparam.Add(bsf);
BestEMailTemplate bet = new BestEMailTemplate();
bet.LoadRows("emialTemplateName = ?", bparam);
if (bet.HasRows)
{
result = bet.TableRows[0].Fields["templateDescription"].fieldValue;
}
}
else if (!string.IsNullOrEmpty(emailDesc))
{
result = emailDesc;
}
return result;
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (HttpContext.Current.Session["CurrentUser"] == null)
{
Response.Redirect("Logout.aspx");
}
ltrSubMenu.Text = UtilMenu.SetupSubMenu("emailtemplate");
if (!Utils.User.UserRoleByName("Setup - EMail Template").allowView)
{
ltrGrid.Text = "You do not have rights to view.";
return;
}
string ms = Request.QueryString["ms"];
this.ltrMScript.Text = Utils.MenuSelectScript(ms);
if (IsPostBack)
{
BestEMailTemplate bs = new BestEMailTemplate();
string isnew = Request.Form["isnew"];
bool cansave = true;
if (string.IsNullOrEmpty(isnew))
{
List<BestField> bparams = new List<BestField>();
BestField guid = new BestField() { fieldName = "guidfield", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false };
guid.fieldValue = Request.Form["guidfield"];
bparams.Add(guid);
if (!string.IsNullOrEmpty(guid.fieldValue))
{
bs.LoadRows("guidfield=?", bparams);
}
else
{
string delguid = Request.Form["deleteguid"];
if (!string.IsNullOrEmpty(delguid))
{
bparams[0].fieldValue = delguid;
bs.LoadRows("guidfield=?", bparams);
bs.CurrentRow.IsDelete = true;
bs.CurrentRow.Save();
}
cansave = false;
}
}
if (cansave)
{
if (!string.IsNullOrEmpty(isnew)) { bs.emialTemplateName = Request.Form["g_emialTemplateName"]; }
if (string.IsNullOrEmpty(bs.emialTemplateName))
{
ltrValidateMsg.Text = Utils.WarningMessage("EMial Template Name is Required.");
cansave = false;
}
if (cansave)
{
bs.templateDescription = Request.Form["g_templateDescription"];
if (!bs.CurrentRow.Save())
{
ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError);
}
}
}
}
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "EMail Templates Information";
bsGrid.GridTable = new BestEMailTemplate();
bsGrid.securityPage = "Setup - EMail Template";
ltrGrid.Text = bsGrid.ToHTML();
}