public void transferingDataFromFirstTableToSecond(string fromWhichTable, string toWhichTable) { SqlConnection con = new SqlConnection(connectionString); con.Open(); try { SqlCommand cmd = new SqlCommand("SELECT * FROM " + fromWhichTable + " WHERE taskId = @id", con); cmd.Parameters.AddWithValue("@id", columnId); SqlDataReader dataReader = cmd.ExecuteReader(); string taskName = ""; string taskDescription = ""; string status = ""; string recurring = ""; string timeSpentOnTask = ""; if (dataReader.Read()) { taskName = (dataReader["taskName"].ToString()); taskDescription = (dataReader["taskDescription"].ToString()); status = (dataReader["status"].ToString()); recurring = (dataReader["recurring"].ToString()); timeSpentOnTask = (dataReader["timeSpentOnTask"].ToString()); } bool success = addingDataToTable(columnId, taskName, taskDescription, status, recurring, timeSpentOnTask, toWhichTable); if (success.Equals(true)) { deletingDataFromTable(columnId, taskName, fromWhichTable); } if (recurring.Trim().Equals("true") && toWhichTable.Equals("[ManagementToolDatabase].[dbo].[ClosedTasks]")) { TaskCreateForm taskCreateForm = new TaskCreateForm(userId); string id = taskCreateForm.searchingForMaxId(); id = (Int16.Parse(id) + 1).ToString(); addingDataToTable(id, taskName, taskDescription, "open", "true", "0", "[ManagementToolDatabase].[dbo].[OpenTasks]"); } } catch (Exception) { MessageBox.Show("Cannot transfer data"); } con.Close(); }
private void addTaskButton_Click(object sender, EventArgs e) { TaskCreateForm taskCreation = new TaskCreateForm(userId); taskCreation.Show(); }