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); } }