/// <summary>
/// Send the message
/// </summary>
private void SendButton_Click(object sender, System.EventArgs e)
{
if (!Page.IsValid)
{
return;
}
//string from = user.Name;
ArrayList toList = new ArrayList();
foreach (ListItem item in ToListBox.Items)
{
toList.Add(item.Value);
}
//Message msg = new Message(from, toList, message);
string time = DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss");
// insert into database
DBDriver myDB = new DBDriver();
myDB.Query =
"insert into messages (SenderID, Subject, Body, timestamp)\n"
+ "values (@sender, @subject, @body, @time);";
myDB.addParam("@sender", Request.Cookies["user"]["id"]);
myDB.addParam("@subject", this.SubjectTextBox.Text);
myDB.addParam("@body", this.MessageTextBox.InnerText);
myDB.addParam("@time", time);
myDB.nonQuery();
myDB.Query = "select id from messages where timestamp=@time;";
myDB.addParam("@time", time);
int mID = Convert.ToInt32(myDB.scalar());
//insert into the recipients table as well
for (int i = 0; i < this.ToListBox.Items.Count; i++)
{
myDB.Query = "insert into recipients (MessageID, RecipientID, Timestamp) values (@id, @recipient, @time);";
myDB.addParam("@id", mID);
myDB.addParam("@recipient", this.ToListBox.Items[i].Value);
myDB.addParam("@time", time);
myDB.nonQuery();
}
Server.Transfer(Request.Url.AbsolutePath);
}
/// <summary>
/// Send the message
/// </summary>
private void SendButton_Click(object sender, System.EventArgs e)
{
if (!Page.IsValid)
return;
//string from = user.Name;
ArrayList toList = new ArrayList();
foreach (ListItem item in ToListBox.Items)
{
toList.Add(item.Value);
}
//Message msg = new Message(from, toList, message);
string time=DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss");
// insert into database
DBDriver myDB=new DBDriver();
myDB.Query=
"insert into messages (SenderID, Subject, Body, timestamp)\n"
+ "values (@sender, @subject, @body, @time);";
myDB.addParam("@sender", Request.Cookies["user"]["id"]);
myDB.addParam("@subject", this.SubjectTextBox.Text);
myDB.addParam("@body", this.MessageTextBox.InnerText);
myDB.addParam("@time", time);
myDB.nonQuery();
myDB.Query="select id from messages where timestamp=@time;";
myDB.addParam("@time", time);
int mID=Convert.ToInt32(myDB.scalar());
//insert into the recipients table as well
for(int i=0;i<this.ToListBox.Items.Count;i++)
{
myDB.Query="insert into recipients (MessageID, RecipientID, Timestamp) values (@id, @recipient, @time);";
myDB.addParam("@id", mID);
myDB.addParam("@recipient", this.ToListBox.Items[i].Value);
myDB.addParam("@time", time);
myDB.nonQuery();
}
Server.Transfer(Request.Url.AbsolutePath);
}
