protected override void fillControls()
{
try
{
parent.SetReadyLabel("Loading");
ProjectTrackingDataSetTableAdapters.TasksTableAdapter myAdapter = parent.GetTasksAdapter();
myAdapter.Fill(parent.MyDataSet.Tasks);
numRows = parent.MyDataSet.Tasks.Rows.Count;
//store the values at the row index into the controls
tbTaskID.Text = parent.MyDataSet.Tasks[rowIndex][0].ToString();
cbProjectID.SelectedValue = parent.MyDataSet.Tasks[rowIndex][1];
tbTaskName.Text = parent.MyDataSet.Tasks[rowIndex][2].ToString();
tbDescription.Text = parent.MyDataSet.Tasks[rowIndex][3].ToString();
dtpStartDate.Value = DateTime.Parse(parent.MyDataSet.Tasks[rowIndex][4].ToString());
//check if the enddate is valid
DateTime endDate = new DateTime();
if (DateTime.TryParse(parent.MyDataSet.Tasks[rowIndex][5].ToString(), out endDate))//if it is update the control
{
tbEndDate.Text = endDate.ToShortDateString();
}
else//otherwise ignore that field and make it blank
{
tbEndDate.Text = "";
}
cbStatus.SelectedValue = parent.MyDataSet.Tasks[rowIndex][6];
}
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);
}
}
public void InsertTasksTable(int project, string name, string desc, DateTime startDate, DateTime?endDate, int status)
{
ProjectTrackingDataSetTableAdapters.TasksTableAdapter myAdapter = GetTasksAdapter();
myAdapter.Insert(project, name, desc, startDate, endDate, status);
myDataSet.Tasks.AcceptChanges();
myAdapter.Update(myDataSet.Tasks);
}
public void DeleteTasksRow(int task)
{
ProjectTrackingDataSetTableAdapters.TasksTableAdapter myAdapter = GetTasksAdapter();
myAdapter.Delete(task);
myDataSet.AcceptChanges();
myAdapter.Update(myDataSet.Tasks);
}
private void frmEditTaskInfo_Load(object sender, EventArgs e)
{
ProjectTrackingDataSetTableAdapters.TasksTableAdapter myAdapter = new ProjectTrackingDataSetTableAdapters.TasksTableAdapter();
myAdapter.Fill(parent.MyDataSet.Tasks);
cbProjectID.DisplayMember = "ProjectName";
cbProjectID.ValueMember = "ProjectID";
cbStatus.ValueMember = "StatusID";
cbStatus.DisplayMember = "StatusName";
FillComboBoxes();
UpdateSelectedRow();
manageEditingEnables(true);
}
public void UpdateTasksRow(int rowIndex, int project, string name, string desc, DateTime startDate, DateTime?endDate, int status)
{
ProjectTrackingDataSetTableAdapters.TasksTableAdapter myAdapter = GetTasksAdapter();
myDataSet.Tasks[rowIndex][1] = project;
myDataSet.Tasks[rowIndex][2] = name;
myDataSet.Tasks[rowIndex][3] = desc;
myDataSet.Tasks[rowIndex][4] = startDate;
if (endDate == null)
{
myDataSet.Tasks[rowIndex][5] = DBNull.Value;
}
else
{
myDataSet.Tasks[rowIndex][5] = endDate;
}
myDataSet.Tasks[rowIndex][6] = status;
myAdapter.Update(myDataSet.Tasks);
}
// 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.TasksTableAdapter GetTasksAdapter()
{
ProjectTrackingDataSetTableAdapters.TasksTableAdapter tData = new ProjectTrackingDataSetTableAdapters.TasksTableAdapter();
tData.Fill(myDataSet.Tasks);
return(tData);
}
