protected void Page_Init(object sender, EventArgs e)
{
filesubPath = Request.QueryString["filesubPath"];
//System.Diagnostics.Process.Start(filePath);
string query = "select * from [tiger].[dbo].[Sales_Call_Report_Recipients]";
ExcoODBC database = ExcoODBC.Instance;
database.Open(Database.DECADE_MARKHAM);
OdbcDataReader reader = database.RunQuery(query);
var emaillist = new Dictionary <string, string>();
while (reader.HasRows)
{
while (reader.Read())
{
emaillist.Add(reader[0].ToString(), reader[1].ToString());
}
reader.NextResult();
}
reader.Close();
DropDownEmailList.DataSource = emaillist;
DropDownEmailList.DataTextField = "Key";
DropDownEmailList.DataValueField = "Value";
DropDownEmailList.DataBind();
//Get ContentPlaceHolder
ContentPlaceHolder content = (ContentPlaceHolder)this.Master.FindControl("MainContent");
Literal lt;
Label lb;
//Dynamic TextBox Panel
pnlEmailBox = new Panel();
pnlEmailBox.ID = "pnlEmailBox";
//pnlEmailBox.BorderWidth = 1;
pnlEmailBox.Width = 500;
content.Controls.Add(pnlEmailBox);
lt = new Literal();
lt.Text = "<br />";
content.Controls.Add(lt);
lb = new Label();
lb.Text = "Recipients List<br />";
lb.Font.Size = FontUnit.Point(20);
lb.ForeColor = Color.Black;
pnlEmailBox.Controls.Add(lb);
if (IsPostBack)
{
RecreateControls("RecipientList", "TextBox");
}
//Button To add TextBoxes
Button btnAddTxt = new Button();
btnAddTxt.ID = "btnAddTxt";
btnAddTxt.Text = "Add Recipient";
btnAddTxt.Click += new System.EventHandler(btnAdd_Click);
content.Controls.Add(btnAddTxt);
lt = new Literal();
lt.Text = "<br /><br /><br /><br />";
content.Controls.Add(lt);
lb = new Label();
lb.Text = "Email Message<br />";
lb.Font.Size = FontUnit.Point(20);
lb.ForeColor = Color.Black;
content.Controls.Add(lb);
TextBox txt = new TextBox();
txt.ID = "EmailBody";
txt.Width = 750;
txt.Height = 300;
txt.Wrap = true;
txt.TextMode = TextBoxMode.MultiLine;
if (IsPostBack)
{
string[] ctrls = Request.Form.ToString().Split('&');
int cnt = FindOccurence("EmailBody");
if (cnt > 0)
{
for (int i = 0; i < ctrls.Length; i++)
{
if (ctrls[i].Contains("EmailBody"))
{
string ctrlName = ctrls[i].Split('=')[0];
string ctrlValue = ctrls[i].Split('=')[1];
ctrlValue = Server.UrlDecode(ctrlValue);
txt.Text = ctrlValue;
emailmsg = ctrlValue;
}
}
}
}
content.Controls.Add(txt);
lt = new Literal();
lt.Text = "<br />";
content.Controls.Add(lt);
//Dummy Button To do PostBack
Button Send = new Button();
Send.ID = "btnSend";
Send.Text = "Send";
Send.Click += new System.EventHandler(btnSend_Click);
content.Controls.Add(Send);
}
