public bool AddChat(Chat chat)
{
try
{
db.AddChatmessage(chat);
return true;
}
catch
{
return false;
}
}
protected void btn_SendMessage_Click(object sender, EventArgs e)
{
if (tbox_Bericht.Text != string.Empty)
{
if (lbox_Volunteers.SelectedItem != null)
{
Client currentuser = (Client)Session["currentUser"];
Volunteer volun = volunteerhandler.GetVolunteer(Convert.ToInt32(lbox_Volunteers.SelectedValue));
Chat chat = new Chat(tbox_Bericht.Text, DateTime.Now, currentuser, volun, 1);
chats.AddChat(chat);
tbox_Bericht.Text = "";
RefreshMessages(currentuser, volun);
}
}
}
protected void btn_SendMessage_Click(object sender, EventArgs e)
{
if (tbox_Message.Text != string.Empty)
{
if (lbox_Clients.SelectedItem != null)
{
Volunteer currentuser = (Volunteer)Session["currentUser"];
Client client = volunteerhandler.GetClient(Convert.ToInt32(lbox_Clients.SelectedValue));
Chat chat = new Chat(tbox_Message.Text, DateTime.Now, client, currentuser, 0);
chats.AddChat(chat);
tbox_Message.Text = "";
RefreshMessages(client, currentuser);
}
}
}
public bool AddChatmessage(Chat message)
{
try
{
Connect();
cmd = new OracleCommand();
cmd.Connection = con;
cmd.CommandText =
"Insert into TCHAT(TIJDSTIP, BERICHT, HULPBEHOEVENDEID, VRIJWILLIGERID,VANHULPBEHOEVENDE) VALUES (:NewTIJDSTIP, :NewBERICHT, :NewHULPBEHOEVENDEID, :NewVRIJWILLIGERID,:NewVANHULPBEHOEVENDE)";
cmd.Parameters.Add("NewTIJDSTIP", OracleDbType.Date).Value = DateTime.Now;
cmd.Parameters.Add("NewBERICHT", OracleDbType.Varchar2).Value = message.Message;
cmd.Parameters.Add("NewHULPBEHOEVENDEID", OracleDbType.Int32).Value = message.Client.ClientID;
cmd.Parameters.Add("NewVRIJWILLIGERID", OracleDbType.Int32).Value = message.Volunteer.VolunteerID;
cmd.Parameters.Add("NewVANHULPBEHOEVENDE", OracleDbType.Int32).Value = message.Sender;
cmd.ExecuteNonQuery();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
finally
{
Disconnect();
}
}
public bool SendMessage(Chat message)
{
throw new NotImplementedException();
}