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