private void AddNullMonthEntries(string[] berthwindows,
string[] remarks,
string[] lines,
int[] years,
Throughput_Volume_Update.ThroughputVolumeDatabase tempDB)
{
foreach (string remark in remarks)
{
foreach (string berth in berthwindows)
{
foreach (string line in lines)
{
foreach (string vessel in lines)
{
foreach (int year in years)
{
for (int i = 1; i <= 12; i++)
{
DataRow tempRow = tempDB.AllVesselThroughputVolumeData.NewRow();
tempRow["VesselVolume"] = vessel;
tempRow["Line"] = line;
tempRow["Month"] = i;
tempRow["Year"] = year;
tempRow["BerthWindow"] = berth;
tempRow["Remarks"] = remark;
tempDB.AllVesselThroughputVolumeData.Rows.Add(tempRow);
}
}
}
}
}
}
}
private void GenerateReport(object sender, KeyEventArgs e)
{
if (e.Control == true && e.KeyCode == Keys.L)
{
Throughput_Volume_Update.ThroughputVolumeDatabase tempDB = new Throughput_Volume_Update.ThroughputVolumeDatabase();
SelectedRowsToDB(tempDB);
int[] years = tempDB.AllVesselThroughputVolumeData.AsEnumerable()
.Select(row => Convert.ToInt32(row["Year"])).Distinct().ToArray();
string[] lines = tempDB.AllVesselThroughputVolumeData.AsEnumerable()
.Select(row => row["VesselVolume"].ToString()).Distinct().ToArray();
string[] remarks = tempDB.AllVesselThroughputVolumeData.AsEnumerable()
.Select(row => row["Remarks"].ToString()).Distinct().ToArray();
string[] berthwindows = tempDB.AllVesselThroughputVolumeData.AsEnumerable()
.Select(row => row["BerthWindow"].ToString()).Distinct().ToArray();
AddNullMonthEntries(berthwindows, remarks, lines, years, tempDB);
Form_CummulativeReport reportForm = new Form_CummulativeReport();
reportForm.StartPosition = FormStartPosition.CenterParent;
cumReport.SetDataSource(tempDB);
reportForm.cummulativeReportViewer.ReportSource = cumReport;
reportForm.Show();
}
}
private void SelectedRowsToDB(Throughput_Volume_Update.ThroughputVolumeDatabase tempDB)
{
foreach (DataGridViewRow Row in throughput_Viewer1.SelectedRows)
{
var boundedRow = (Throughput_Volume_Update.ThroughputVolumeDatabase.AllVesselThroughputVolumeDataRow)((DataRowView)Row.DataBoundItem).Row;
DataRow tempRow = tempDB.AllVesselThroughputVolumeData.NewRow();
tempRow.ItemArray = boundedRow.ItemArray;
tempDB.AllVesselThroughputVolumeData.Rows.Add(tempRow);
}
}
