public void InsertEmpWorkTable(int task, int emp, DateTime date, decimal hours) { ProjectTrackingDataSetTableAdapters.EmployeeWorkTableAdapter myAdapter = GetEmpWorkAdapter(); myAdapter.Insert(task, emp, date, hours); myDataSet.EmployeeWork.AcceptChanges(); myAdapter.Update(myDataSet.EmployeeWork); }
public void DeleteEmpWorkRow(int task, int emp, DateTime work) { ProjectTrackingDataSetTableAdapters.EmployeeWorkTableAdapter myAdapter = GetEmpWorkAdapter(); myAdapter.Delete(task, emp, work.ToShortDateString()); myDataSet.EmployeeWork.AcceptChanges(); myAdapter.Update(myDataSet.EmployeeWork); }
public void UpdateEmpWorkRow(int rowIndex, int task, int emp, DateTime date, decimal hours) { ProjectTrackingDataSetTableAdapters.EmployeeWorkTableAdapter myAdapter = GetEmpWorkAdapter(); myDataSet.EmployeeWork[rowIndex][1] = emp; myDataSet.EmployeeWork[rowIndex][2] = date; myDataSet.EmployeeWork[rowIndex][3] = hours; myAdapter.Update(myDataSet.EmployeeWork); }
private void frmInputWork_Load(object sender, EventArgs e) { ProjectTrackingDataSetTableAdapters.EmployeeWorkTableAdapter myAdapter = new ProjectTrackingDataSetTableAdapters.EmployeeWorkTableAdapter(); myAdapter.Fill(parent.MyDataSet.EmployeeWork); cbEmployeeID.DisplayMember = "FullName"; cbEmployeeID.ValueMember = "EmployeeID"; cbTaskID.ValueMember = "TaskID"; cbTaskID.DisplayMember = "TaskName"; FillComboBoxes(); UpdateSelectedRow(); manageEditingEnables(true); }
protected override void fillControls() { try { //gather the data about employee work ProjectTrackingDataSetTableAdapters.EmployeeWorkTableAdapter myAdapter = new ProjectTrackingDataSetTableAdapters.EmployeeWorkTableAdapter(); myAdapter.Fill(parent.MyDataSet.EmployeeWork); numRows = parent.MyDataSet.EmployeeWork.Rows.Count; //store the data at the selected row in the controls cbTaskID.SelectedValue = parent.MyDataSet.EmployeeWork[rowIndex][0]; cbEmployeeID.SelectedValue = parent.MyDataSet.EmployeeWork[rowIndex][1]; dtpWorkDate.Value = DateTime.Parse(parent.MyDataSet.EmployeeWork[rowIndex][2].ToString()); workHoursNumericUpDown.Value = Decimal.Parse(parent.MyDataSet.EmployeeWork[rowIndex][3].ToString()); } catch { parent.SetReadyLabel("Load Failed"); } }
public ProjectTrackingDataSetTableAdapters.EmployeeWorkTableAdapter GetEmpWorkAdapter() { ProjectTrackingDataSetTableAdapters.EmployeeWorkTableAdapter ewData = new ProjectTrackingDataSetTableAdapters.EmployeeWorkTableAdapter(); ewData.Fill(myDataSet.EmployeeWork); return(ewData); }