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(); }