private void SaveTask()
{
try
{
foreach (DataGridViewRow row in dgvTask.Rows)
{
bool IsChecked = Convert.ToBoolean(row.Cells[5].Value);
if (row.Cells[1].Value == DBNull.Value)
{
row.Cells[1].Value = string.Empty;
}
}
taskAdapter = new tasksTableAdapter();
taskAdapter.Update((tasksDataTable)dgvTask.DataSource);
taskAdapter.Dispose();
dgvTask.DataSource = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void populateTaskListbox()
{
try
{
taskAdapter = new tasksTableAdapter();
tTable = taskAdapter.GetTaskOnActivityIDOrderByInvoiceCode(_passingActivityID);
taskAdapter.Dispose();
DataGridViewCellStyle headerStyle = new DataGridViewCellStyle();
headerStyle.Font = new Font(headFont, FontStyle.Bold);
dgvTask.RowHeadersVisible = false;
dgvTask.AutoGenerateColumns = false;
dgvTask.ColumnCount = 5;
dgvTask.Columns[0].HeaderText = "Fakturakod";
dgvTask.Columns[0].DataPropertyName = "invoiceCode";
dgvTask.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgvTask.Columns[0].HeaderCell.Style = headerStyle;
dgvTask.Columns[0].Name = "InvoiceCode";
dgvTask.Columns[1].HeaderText = "Beskrivning";
dgvTask.Columns[1].DataPropertyName = "description";
dgvTask.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgvTask.Columns[1].HeaderCell.Style = headerStyle;
dgvTask.Columns[2].HeaderText = "Budgettimmar";
dgvTask.Columns[2].DataPropertyName = "budgethours";
dgvTask.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgvTask.Columns[2].HeaderCell.Style = headerStyle;
dgvTask.Columns[3].HeaderText = "Beräknade_timmar";
dgvTask.Columns[3].DataPropertyName = "estimatedHours";
dgvTask.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgvTask.Columns[3].HeaderCell.Style = headerStyle;
dgvTask.Columns[4].HeaderText = "ActivityID";
dgvTask.Columns[4].DataPropertyName = "activityID";
dgvTask.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgvTask.Columns[4].HeaderCell.Style = headerStyle;
dgvTask.Columns[4].Visible = false;
DataGridViewCheckBoxColumn chkCol = new DataGridViewCheckBoxColumn();
chkCol.HeaderText = "Rubrik";
chkCol.TrueValue = 1;
chkCol.FalseValue = 0;
chkCol.Name = "chkCol";
chkCol.DataPropertyName = "status";
chkCol.HeaderCell.Style = headerStyle;
dgvTask.Columns.Add(chkCol);
dgvTask.DataSource = tTable;
if (dgvTask.Rows.Count - 1 >= 0)
{
BeginInvoke((Action)(() => { LoopDgvAndSetStyle(); }));
}
this.dgvTask.Sort(this.dgvTask.Columns[0], ListSortDirection.Ascending);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
