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