private void btnSave_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(SqlStatements.ConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO dbo.crm_activity (customer_acc_ref, date_created,correspondance_type,details_of,recipient,sender_id,reference) " +
"VALUES (@custAccRef,@date,@type,@details,@recipient,@sender,@ref)";
cmd.Parameters.AddWithValue("@custAccRef", _custAccRef);
cmd.Parameters.AddWithValue("@date", DateTime.Now);
cmd.Parameters.AddWithValue("@type", cmbType.Text);
cmd.Parameters.AddWithValue("@details", txtDetails.Text);
cmd.Parameters.AddWithValue("@ref", txtReference.Text);
cmd.Parameters.AddWithValue("@recipient", cmbRecipient.SelectedValue);
cmd.Parameters.AddWithValue("@sender", Login.globalUserID);
cmd.ExecuteNonQuery();
conn.Close();
//Prompts user to add task to ToDo System
DialogResult dr = MessageBox.Show("Do you want to create a task from this activity?", "Create Task?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
double maxID;
SqlConnection connr = new SqlConnection(SqlStatements.ConnectionString);
connr.Open();
SqlCommand cmdr = new SqlCommand("select max(id) as maxID from dbo.crm_activity", connr);
SqlDataReader rdr = cmdr.ExecuteReader();
if (rdr.Read())
{
maxID = Convert.ToDouble(rdr["maxID"]);
}
else
{
maxID = 0;
}
frmNewTask nt = new frmNewTask(maxID, cmbRecipient.Text, txtReference.Text, txtDetails.Text, lblCustomer.Text);
nt.ShowDialog();
}
this.Close();
}
private void addTaskToolStripMenuItem_Click(object sender, EventArgs e)
{
frmNewTask nt = new frmNewTask(null, null, null, null, null);
nt.ShowDialog();
}
