/// <summary> /// Добавление записи в таблицу. /// </summary> /// <param name="task">Добавляемое задание.</param> /// <returns>Id добавленной записи.</returns> private int AddRecordToTable(Task task) { string query = "INSERT INTO [Tasks] ([BeginTime], [EndTime], [Name], [Description], [Place])" + "VALUES (@BeginTime, @EndTime, @Name, @Description, @Place);" + "SELECT SCOPE_IDENTITY();"; using (SqlConnection connection = new SqlConnection(_connectionString)) using (SqlCommand command = new SqlCommand(query, connection)) { connection.Open(); command.Parameters.AddWithValue("@BeginTime", task.BeginTime); command.Parameters.AddWithValue("@EndTime", task.EndTime); command.Parameters.AddWithValue("@Name", task.Name); command.Parameters.AddWithValue("@Description", task.Description); command.Parameters.AddWithValue("@Place", task.Place); return Convert.ToInt32(command.ExecuteScalar().ToString()); } }
/// <summary> /// Добавление записи в DataGridView. /// </summary> /// <param name="task">Добавляемая задача.</param> /// <param name="recordId">Id добавляемой записи.</param> private void AddRecordToDataGridView(Task task, int recordId) { DataTable dataTable = (DataTable) _dataGridView.DataSource; dataTable.Rows.Add(recordId, task.BeginTime, task.EndTime, task.Name, task.Description, task.Place); }