protected override void fillControls()
{
try
{
parent.SetReadyLabel("Loading");
ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter myEmpAdapter = parent.GetEmployeesAdapter();
numRows = parent.MyDataSet.Employees.Count;
tbEmployeeID.Text = parent.MyDataSet.Employees.Rows[rowIndex][0].ToString();
tbFirstName.Text = parent.MyDataSet.Employees.Rows[rowIndex][1].ToString();
tbLastName.Text = parent.MyDataSet.Employees.Rows[rowIndex][2].ToString();
tbTitle.Text = parent.MyDataSet.Employees.Rows[rowIndex][3].ToString();
ProjectTrackingDataSetTableAdapters.getTasksByEmployeeTableAdapter myAdapter = new ProjectTrackingDataSetTableAdapters.getTasksByEmployeeTableAdapter();
myAdapter.Fill(parent.MyDataSet.getTasksByEmployee, Int32.Parse(tbEmployeeID.Text));
dgvWork.DataSource = parent.MyDataSet.getTasksByEmployee.Copy();
ProjectTrackingDataSetTableAdapters.getTotalWorkHoursByEmployeeTableAdapter myTotal = new ProjectTrackingDataSetTableAdapters.getTotalWorkHoursByEmployeeTableAdapter();
myTotal.Fill(parent.MyDataSet.getTotalWorkHoursByEmployee, Int32.Parse(parent.MyDataSet.Employees.Rows[rowIndex][0].ToString()));
lblTotalHours.Text = parent.MyDataSet.getTotalWorkHoursByEmployee[0][0].ToString();
parent.SetReadyLabel("Load Success");
}
catch
{
parent.SetReadyLabel("Load Failed");
}
}
// method to read data from dataset
public void Read()
{
// create table adapters for each table in the dataset
ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter taEmployees =
new ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter();
ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter taProjects =
new ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter();
ProjectTrackingDataSetTableAdapters.StatusTableAdapter taStatus =
new ProjectTrackingDataSetTableAdapters.StatusTableAdapter();
ProjectTrackingDataSetTableAdapters.TasksTableAdapter taTasks =
new ProjectTrackingDataSetTableAdapters.TasksTableAdapter();
ProjectTrackingDataSetTableAdapters.WorkTableAdapter taWork =
new ProjectTrackingDataSetTableAdapters.WorkTableAdapter();
try
{
// load the data into the tables
taEmployees.Fill(myProjects.Employees);
taProjects.Fill(myProjects.Projects);
taStatus.Fill(myProjects.Status);
taTasks.Fill(myProjects.Tasks);
taWork.Fill(myProjects.Work);
}
catch (Exception ex)
{
SetReadyLabel("Error loading data from database");
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// method used to calculate Employee hours worked by EmployeeID
private void GetEmployeeHoursWorkedByID(int employeeID)
{
ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter taEmployees =
new ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter();
// using query, calculate Employee hours worked
decimal?hoursWorked = taEmployees.GetEmployeeHoursWorked(employeeID);
txtHoursWorked.Text = hoursWorked.ToString();
}
/*public void InsertStatusTable()
* {
* ProjectTrackingDataSetTableAdapters.LuStatusTableAdapter myAdapter = GetStatusAdapter();
* myAdapter.Insert();
* }*/
public void InsertEmployeesTable(string first, string last, string title)
{
ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter myAdapter = GetEmployeesAdapter();
myAdapter.Insert(first, last, title);
myDataSet.AcceptChanges();
myAdapter.Update(myDataSet.Employees);
}
private void frmEditEmployees_Load(object sender, EventArgs e)
{
ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter myAdapter = new ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter();
myAdapter.Fill(parent.MyDataSet.Employees);
UpdateSelectedRow();
manageEditingEnables(true);
tbFirst.Focus();
}
public void DeleteEmployeeRow(int emp)
{
ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter myAdapter = GetEmployeesAdapter();
myAdapter.Delete(emp);
myDataSet.AcceptChanges();
myAdapter.Update(myDataSet.Employees);
}
public void UpdateEmployeeRow(int rowIndex, string first, string last, string title)
{
ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter myAdapter = GetEmployeesAdapter();
myDataSet.Employees[rowIndex][1] = first;
myDataSet.Employees[rowIndex][2] = last;
myDataSet.Employees[rowIndex][3] = title;
myAdapter.Update(myDataSet.Employees);
}
protected override void fillControls()
{
try
{
parent.SetReadyLabel("Loading");
ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter myAdapter = parent.GetEmployeesAdapter();
numRows = parent.MyDataSet.Employees.Count;
//set the controls display to the values in the Table at the selected row
setTextboxText(parent.MyDataSet.Employees[rowIndex][0].ToString(),
parent.MyDataSet.Employees[rowIndex][1].ToString(),
parent.MyDataSet.Employees[rowIndex][2].ToString(),
parent.MyDataSet.Employees[rowIndex][3].ToString());
parent.SetReadyLabel("Load Success");
}
catch
{
parent.SetReadyLabel("Load Failed");
}
}
// method to save data to dataset
public void Save()
{
// create table adapters for each table in the dataset
ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter taEmployees =
new ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter();
ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter taProjects =
new ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter();
ProjectTrackingDataSetTableAdapters.StatusTableAdapter taStatus =
new ProjectTrackingDataSetTableAdapters.StatusTableAdapter();
ProjectTrackingDataSetTableAdapters.TasksTableAdapter taTasks =
new ProjectTrackingDataSetTableAdapters.TasksTableAdapter();
ProjectTrackingDataSetTableAdapters.WorkTableAdapter taWork =
new ProjectTrackingDataSetTableAdapters.WorkTableAdapter();
// create instance of table adapter manager to manage all tables
ProjectTrackingDataSetTableAdapters.TableAdapterManager taManager =
new ProjectTrackingDataSetTableAdapters.TableAdapterManager();
// assign each table table adapter to the table adapter manager
taManager.EmployeesTableAdapter = taEmployees;
taManager.ProjectsTableAdapter = taProjects;
taManager.StatusTableAdapter = taStatus;
taManager.TasksTableAdapter = taTasks;
taManager.WorkTableAdapter = taWork;
try
{
// using manager, update all of the tables
taManager.UpdateAll(myProjects);
}
catch (Exception ex)
{
SetReadyLabel("Error saving to database");
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter GetEmployeesAdapter()
{
ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter empData = new ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter();
empData.Fill(myDataSet.Employees);
return(empData);
}
