// 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);
}
}
public void InsertProjectsTable(string name, int manager, int status, string desc, DateTime startDate, DateTime?endDate)
{
ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter myAdapter = GetProjectsAdapter();
myAdapter.Insert(name, manager, status, desc, startDate, endDate);
myDataSet.Projects.AcceptChanges();
myAdapter.Update(myDataSet.Projects);
}
// method used to calculate Project hours worked by ProjectID
private void GetProjectHoursWorkedByID(int projectID)
{
ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter taProjects =
new ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter();
// using query, calculate Project hours worked
decimal?hoursWorked = (decimal?)taProjects.GetProjectHoursWorked(projectID);
txtHoursWorked.Text = hoursWorked.ToString();
}
public void DeleteProjectRow(int project)
{
ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter myAdapter = GetProjectsAdapter();
myAdapter.Delete(project);
myDataSet.Projects.AcceptChanges();
myAdapter.Update(myDataSet.Projects);
}
private void FillComboBoxes()
{
//gather all table information
ProjectTrackingDataSetTableAdapters.LuStatusTableAdapter myStatusAdapter = new ProjectTrackingDataSetTableAdapters.LuStatusTableAdapter();
myStatusAdapter.Fill(parent.MyDataSet.LuStatus);
ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter myProjectAdapter = new ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter();
myProjectAdapter.Fill(parent.MyDataSet.Projects);
//add the list of managers to the manager combobox using thier EmpID as the value member
cbProjectID.DataSource = parent.MyDataSet.Projects.Copy();//use copy so that a change in one form doesn't affect this
//add the list of status to the status combobox using the StatusID as the value member
cbStatus.DataSource = parent.MyDataSet.LuStatus.Copy();
}
private void frmEditProjectInfo_Load(object sender, EventArgs e)
{
ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter myAdapter = new ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter();
myAdapter.Fill(parent.MyDataSet.Projects);
UpdateSelectedRow();
manageEditingEnables(true);
FillComboBoxes();
cbProjectManager.DisplayMember = "FullName";
cbProjectManager.ValueMember = "EmployeeID";
cbProjectStatus.ValueMember = "StatusID";
cbProjectStatus.DisplayMember = "StatusName";
}
public void UpdateProjectRow(int rowIndex, string name, int manager, int status, string desc, DateTime startDate, DateTime?endDate)
{
ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter myAdapter = GetProjectsAdapter();
myDataSet.Projects[rowIndex][1] = name;
myDataSet.Projects[rowIndex][2] = manager;
myDataSet.Projects[rowIndex][3] = status;
myDataSet.Projects[rowIndex][4] = desc;
myDataSet.Projects[rowIndex][5] = startDate;
if (endDate == null)
{
myDataSet.Projects[rowIndex][6] = DBNull.Value;
}
else
{
myDataSet.Projects[rowIndex][6] = endDate;
}
myAdapter.Update(myDataSet.Projects);
}
protected override void fillControls()
{
try
{
parent.SetReadyLabel("Loading");
//Get the index of the row being newly selected
ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter myProj = parent.GetProjectsAdapter();
numRows = parent.MyDataSet.Projects.Count;
//save that index
int rowID = Int32.Parse(parent.MyDataSet.Projects.Rows[rowIndex][0].ToString());
//get the fields of the project by the names rather than primary keys
ProjectTrackingDataSetTableAdapters.getProjectInfoNamesTableAdapter myProjAdapter = new ProjectTrackingDataSetTableAdapters.getProjectInfoNamesTableAdapter();
myProjAdapter.Fill(parent.MyDataSet.getProjectInfoNames, rowID);
//put those valuse in the textboxrs
tbProjectName.Text = parent.MyDataSet.getProjectInfoNames.Rows[0][0].ToString();
tbProjectStatus.Text = parent.MyDataSet.getProjectInfoNames.Rows[0][1].ToString();
tbProjectDescription.Text = parent.MyDataSet.getProjectInfoNames.Rows[0][2].ToString();
//get all the work all employees have done based on what project they worked on
ProjectTrackingDataSetTableAdapters.getEmployeeWorkByProjectTableAdapter myAdapter = new ProjectTrackingDataSetTableAdapters.getEmployeeWorkByProjectTableAdapter();
myAdapter.Fill(parent.MyDataSet.getEmployeeWorkByProject, Int32.Parse(parent.MyDataSet.Projects.Rows[rowIndex][0].ToString()));
//display those employee works
dgvWork.DataSource = parent.MyDataSet.getEmployeeWorkByProject.Copy();
ProjectTrackingDataSetTableAdapters.getTotalWorkHoursByProjectTableAdapter myTotal = new ProjectTrackingDataSetTableAdapters.getTotalWorkHoursByProjectTableAdapter();
myTotal.Fill(parent.MyDataSet.getTotalWorkHoursByProject, Int32.Parse(parent.MyDataSet.Projects.Rows[rowIndex][0].ToString()));
//set the label to the total hours use [0][0] since the procedure returns a table with one field
lblTotalHours.Text = parent.MyDataSet.getTotalWorkHoursByProject[0][0].ToString();
parent.SetReadyLabel("Load Success");
}
catch
{
parent.SetReadyLabel("Load Failed");
}
}
protected override void fillControls()
{
try
{
parent.SetReadyLabel("Loading");
ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter myAdapter = new ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter();
myAdapter.Fill(parent.MyDataSet.Projects);
numRows = parent.MyDataSet.Projects.Count;
//put the stored values into the conrols
tbProjectID.Text = parent.MyDataSet.Projects[rowIndex][0].ToString();
tbProjectName.Text = parent.MyDataSet.Projects[rowIndex][1].ToString();
cbProjectManager.SelectedValue = parent.MyDataSet.Projects[rowIndex][2];
cbProjectStatus.SelectedValue = parent.MyDataSet.Projects[rowIndex][3];
tbDescription.Text = parent.MyDataSet.Projects[rowIndex][4].ToString();
dtpStartDate.Value = DateTime.Parse(parent.MyDataSet.Projects[rowIndex][5].ToString());
DateTime endDate = new DateTime();//if the end date is valid
if (DateTime.TryParse(parent.MyDataSet.Projects[rowIndex][6].ToString(), out endDate))
{
mtbEndDate.Text = endDate.ToShortDateString();//include it
}
else
{
mtbEndDate.Text = "";
}
}
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.ProjectsTableAdapter GetProjectsAdapter()
{
ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter pData = new ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter();
pData.Fill(myDataSet.Projects);
return(pData);
}
