private void btnSelect_Click(object sender, EventArgs e)
{
if (cboReport.SelectedItem == "Report 1")
{
ReportDataSet.Clear();
string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=1";
ReportDataSet.ReadXml(filePath);
}
else if (cboReport.SelectedItem == "Report 2")
{
ReportDataSet.Clear();
string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=2";
ReportDataSet.ReadXml(filePath);
}
else if (cboReport.SelectedItem == "Report 3")
{
ReportDataSet.Clear();
string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=3";
ReportDataSet.ReadXml(filePath);
}
else if (cboReport.SelectedItem == "Report 4")
{
ReportDataSet.Clear();
string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=4";
ReportDataSet.ReadXml(filePath);
}
}
private void Form1_Load(object sender, EventArgs e)
{
btnSelect.TabStop = false;
btnSelect.FlatStyle = FlatStyle.Flat;
btnSelect.FlatAppearance.BorderSize = 0;
btnViewComment.TabStop = false;
btnViewComment.FlatStyle = FlatStyle.Flat;
btnViewComment.FlatAppearance.BorderSize = 0;
btnAddComment.TabStop = false;
btnAddComment.FlatStyle = FlatStyle.Flat;
btnAddComment.FlatAppearance.BorderSize = 0;
btnCancel.TabStop = false;
btnCancel.FlatStyle = FlatStyle.Flat;
btnCancel.FlatAppearance.BorderSize = 0;
btnSearch.TabStop = false;
btnSearch.FlatStyle = FlatStyle.Flat;
btnSearch.FlatAppearance.BorderSize = 0;
//using (StreamReader sr = new StreamReader("Settings.txt"))
//{
// while (sr.Peek() != -1)
// {
// this.BackColor = (sr.Read);
// }
//}
// combo box
cboReport.Items.Add("Report 1");
cboReport.Items.Add("Report 2");
cboReport.Items.Add("Report 3");
cboReport.Items.Add("Report 4");
//fill datagrid
string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=1";
ReportDataSet.ReadXml(filePath);
dgvAll.DataSource = ReportDataSet;
ReportDataSet.Clear();
dgvAll.DataMember = "course";
dgvAll.Columns[0].HeaderText = "Course";
dgvAll.Columns[1].HeaderText = "Quater";
dgvAll.Columns[2].HeaderText = "Course Cost";
dgvAll.Columns[3].HeaderText = "Hours";
dgvAll.Columns[4].HeaderText = "Cost With Travel";
dgvAll.Columns[5].HeaderText = "Location";
dgvAll.Columns[6].HeaderText = "Number of Enrolements";
dgvAll.Columns[7].HeaderText = "Raw Total Cost";
dgvAll.Columns[8].HeaderText = "Total Cost With Travel";
dgvAll.Columns[9].HeaderText = "Total Hours";
}
private void btnSearch_Click(object sender, EventArgs e)
{
ReportDataSet.Clear();
string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=search&query=" + txtSearch.Text;
ReportDataSet.ReadXml(filePath);
dgvAll.DataSource = ReportDataSet;
}
public virtual int Fill(ReportDataSet.LineLaborHourReportSourceDataTable dataTable, System.DateTime 日期, System.DateTime 日期1) {
this.Adapter.SelectCommand = this.CommandCollection[0];
this.Adapter.SelectCommand.Parameters[0].Value = ((System.DateTime)(日期));
this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(日期1));
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Fill(ReportDataSet.UnitPriceReportDataTable dataTable, global::System.Nullable<global::System.DateTime> 實際完成日, global::System.Nullable<global::System.DateTime> 實際完成日1) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((實際完成日.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[0].Value = ((System.DateTime)(實際完成日.Value));
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
}
if ((實際完成日1.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(實際完成日1.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Fill(ReportDataSet.UnfinishedWorksheetReportSourceDataTable dataTable, System.DateTime 開始日期, System.DateTime 結束日期, bool 輸出全部) {
this.Adapter.SelectCommand = this.CommandCollection[0];
this.Adapter.SelectCommand.Parameters[0].Value = ((System.DateTime)(開始日期));
this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(結束日期));
this.Adapter.SelectCommand.Parameters[2].Value = ((bool)(輸出全部));
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Fill(ReportDataSet.FinishedWorksheetReportSourceDataTable dataTable, global::System.Nullable<global::System.DateTime> 開始日期, global::System.Nullable<global::System.DateTime> 結束日期) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((開始日期.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[0].Value = ((System.DateTime)(開始日期.Value));
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
}
if ((結束日期.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(結束日期.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}