private void copiaEventoToolStripMenuItem_Click(object sender, EventArgs e) { if (dbDataGridView_teste.SelectedRows.Count != 1) { MessageBox.Show(Properties.MessageLocalization.event_copy_too_many_rows); return; } try { using (System.Transactions.TransactionScope scp = new TransactionScope()) { DataSet.dsEvents.EventiTestaRow row = (dbDataGridView_teste.SelectedRows[0].DataBoundItem as DataRowView).Row as DataSet.dsEvents.EventiTestaRow; int new_event_key = (int)eventiTestaTableAdapter.CloneEvent(row.EventKey); eventiRigheTableAdapter.CloneEventRows(new_event_key, row.EventKey); scp.Complete(); } PerformSearch(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void button_aggiungi_righe_Click(object sender, EventArgs e) { if (dbDataGridView_teste.SelectedRows.Count > 0) { DataRowView drv = dbDataGridView_teste.SelectedRows[0].DataBoundItem as DataRowView; if (drv != null) { try { DataSet.dsEvents.EventiTestaRow row = drv.Row as DataSet.dsEvents.EventiTestaRow; if (int.Parse(textBox_remaining.Text) < int.Parse(textBox_driver.Text)) { MessageBox.Show(Properties.MessageLocalization.events_driver_perc_exceeds); return; } eventiRigheTableAdapter.InsertQuery( row.EventKey, (int)ctrlPlantSelector.SelectedImpianto(), (int)ctrlPlantSelector.SelectedMacchina(), ctrlPlantSelector.SelectedComponente(), ctrlPlantSelector.SelectedSCM_1(), ctrlPlantSelector.SelectedSCM_2(), ctrlPlantSelector.SelectedSCM_3(), int.Parse(textBox_driver.Text) ); RefreshDatagridRighe(row.EventKey); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } } }
private void SelectEvent(int event_key) { for (int i = 0; i < dbDataGridView_teste.Rows.Count; i++) { DataSet.dsEvents.EventiTestaRow row = (dbDataGridView_teste.Rows[i].DataBoundItem as DataRowView).Row as DataSet.dsEvents.EventiTestaRow; if (row.EventKey == event_key) { dbDataGridView_teste.Rows[i].Selected = true; } else { dbDataGridView_teste.Rows[i].Selected = false; } } }
private void dbDataGridView_teste_SelectionChanged(object sender, EventArgs e) { if (dbDataGridView_teste.SelectedRows.Count > 0) { DataRowView drv = dbDataGridView_teste.SelectedRows[0].DataBoundItem as DataRowView; if (drv != null) { DataSet.dsEvents.EventiTestaRow row = drv.Row as DataSet.dsEvents.EventiTestaRow; RefreshDatagridRighe(row.EventKey); comboBox_man.SelectedValue = row.TipoManKey; comboBox_rep.SelectedValue = row.TipoRepKey; textBox_contratto.Text = row.EventContractNumber; comboBox_ute.SelectedValue = row.UTEKey; comboBox_stato_rec.SelectedValue = row.StatoRecKey; textBox_descr.Text = row.EventDescription; textBox_note.Text = row.EventRemark; DateTime start = new DateTime( row.dt_start_date.Year, row.dt_start_date.Month, row.dt_start_date.Day, row.start_hour, row.start_minute, 0); DateTime end = new DateTime( row.dt_end_date.Year, row.dt_end_date.Month, row.dt_end_date.Day, row.end_hour, row.end_minute, 0); ctrlDateTimePicker_start.WriteTs(start); ctrlDateTimePicker_end.WriteTs(end); ChangeMode(Mode.UPDATE); } } }
private void cancellaRecordSelezionatiToolStripMenuItem_Click(object sender, EventArgs e) { try { using (TransactionScope scp = new TransactionScope()) { foreach (DataGridViewRow r in dbDataGridView_teste.SelectedRows) { DataSet.dsEvents.EventiTestaRow row = (r.DataBoundItem as DataRowView).Row as DataSet.dsEvents.EventiTestaRow; new DataSet.dsActivitiesTableAdapters.Man_Act_EveTableAdapter().DeleteByEvent(row.EventKey); eventiRigheTableAdapter.DeleteByEventKey(row.EventKey); eventiTestaTableAdapter.DeleteQuery(row.EventKey); } scp.Complete(); } PerformSearch(); } catch (Exception ex) { MessageBox.Show(Properties.MessageLocalization.event_cannot_cancel);//ex.ToString()); } }
private void button_save_Click(object sender, EventArgs e) { string err = ""; if (ctrlDateTimePicker_start.ReadTs() >= ctrlDateTimePicker_end.ReadTs()) { err += Properties.MessageLocalization.activity_ts_mismatch + System.Environment.NewLine; } DataSet.dsActivities.OverlappingActivitiesDataTable d_overlap = new DataSet.dsActivities.OverlappingActivitiesDataTable(); //new DataSet.dsActivitiesTableAdapters.OverlappingActivitiesTableAdapter().Fill( // d_overlap, // (int)comboBox_utente_.SelectedValue, -1, // Program.DateToInt(ctrlDateTimePicker_start.ReadTs()), // Program.HmsToInt(ctrlDateTimePicker_start.ReadTs()), // Program.DateToInt(ctrlDateTimePicker_end.ReadTs()), // Program.HmsToInt(ctrlDateTimePicker_end.ReadTs())); new DataSet.dsActivitiesTableAdapters.OverlappingActivitiesTableAdapter().Fill( d_overlap, (int)comboBox_utente_.SelectedValue, -1, ctrlDateTimePicker_start.ReadTs(), ctrlDateTimePicker_end.ReadTs()); if (d_overlap.Count > 0) { err += Properties.MessageLocalization.activity_overlap + System.Environment.NewLine; } if (ctrlDateTimePicker_start.ReadTs().Minute % 15 != 0 || ctrlDateTimePicker_end.ReadTs().Minute % 15 != 0) { err += Properties.MessageLocalization.activity_wrong_min_range + System.Environment.NewLine; } if (!string.IsNullOrEmpty(err)) { MessageBox.Show(err); return; } else { try { if (dbDataGridView_events.SelectedRows.Count > 0) { DataSet.dsEvents.EventiTestaRow ev_testa_row = (dbDataGridView_events.SelectedRows[0].DataBoundItem as DataRowView).Row as DataSet.dsEvents.EventiTestaRow; DataSet.dsEvents.EventiRigheDataTable eventi_righe = new DataSet.dsEvents.EventiRigheDataTable(); new DataSet.dsEventsTableAdapters.EventiRigheTableAdapter().Fill(eventi_righe, ev_testa_row.EventKey, Program.language_); DataSet.dsActivitiesTableAdapters.ActivitiesTableAdapter act_adapter = new DataSet.dsActivitiesTableAdapters.ActivitiesTableAdapter(); DataSet.dsActivitiesTableAdapters.Man_Act_EveTableAdapter act_evt_adapter = new DataSet.dsActivitiesTableAdapters.Man_Act_EveTableAdapter(); long tot_sec = (long)(ctrlDateTimePicker_end.ReadTs() - ctrlDateTimePicker_start.ReadTs()).TotalSeconds; DateTime dt_prg = ctrlDateTimePicker_start.ReadTs(); DataSet.dsActivities.MaxActEveGroupDataTable d_max = new DataSet.dsActivities.MaxActEveGroupDataTable(); new DataSet.dsActivitiesTableAdapters.MaxActEveGroupTableAdapter().Fill(d_max); int act_event_group_id = (d_max[0].IsMaxActEveGroupIdNull() ? 0 : d_max[0].MaxActEveGroupId) + 1; using (TransactionScope scp = new TransactionScope()) { foreach (DataSet.dsEvents.EventiRigheRow ev_righe_row in eventi_righe.Rows) { int?COMKey = null; int?SCM_1_Key = null; int?SCM_2_Key = null; int?SCM_3_Key = null; if (!ev_righe_row.IsCOMKeyNull()) { COMKey = ev_righe_row.COMKey; } if (!ev_righe_row.IsSCM_1KeyNull()) { SCM_1_Key = ev_righe_row.SCM_1Key; } if (!ev_righe_row.IsSCM_2KeyNull()) { SCM_2_Key = ev_righe_row.SCM_2Key; } if (!ev_righe_row.IsSCM_3KeyNull()) { SCM_3_Key = ev_righe_row.SCM_3Key; } DateTime dt_next = dt_prg.AddSeconds(tot_sec * ev_righe_row.DriverPerc / 100); int ActivityKey = (int)act_adapter.InsertActivity( Program.DateToInt(dt_prg), Program.DateToInt(dt_next), Program.HmsToInt(dt_prg), Program.HmsToInt(dt_next), (int)(dt_next - dt_prg).TotalSeconds, string.Empty, (int)comboBox_utente_.SelectedValue, ev_testa_row.TipoManKey, (int)comboBox_tipo_reparto_.SelectedValue, null, ev_righe_row.IMPKey, ev_righe_row.MACKey, COMKey, SCM_1_Key, SCM_2_Key, SCM_3_Key, Program.CurrentUser.Login, dt_prg, dt_next, (int)comboBox_tipo_ore.SelectedValue, null); dt_prg = dt_next; int ActEveKey = (int)act_evt_adapter.InsertQuery(ActivityKey, ev_testa_row.EventKey, act_event_group_id); act_adapter.UpdateActEveKey(ActEveKey, ActivityKey); } scp.Complete(); } } ActivitySubmitEventArgs ev = new ActivitySubmitEventArgs(ctrlDateTimePicker_start.ReadTs(), ctrlDateTimePicker_end.ReadTs()); InitializeMask(); Program.RefreshActNoReport(); SubmitEvent(this, ev); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } }
private void button_save_Click(object sender, EventArgs e) { int event_key = -1; try { if (mode == Mode.INSERT) { event_key = (int)eventiTestaTableAdapter.InsertQuery( textBox_descr.Text, (int)comboBox_rep.SelectedValue, (int)comboBox_man.SelectedValue, Program.DateToInt(ctrlDateTimePicker_start.ReadTs()), Program.HmsToInt(ctrlDateTimePicker_start.ReadTs()), Program.DateToInt(ctrlDateTimePicker_end.ReadTs()), Program.HmsToInt(ctrlDateTimePicker_end.ReadTs()), textBox_contratto.Text, textBox_note.Text, (int)comboBox_ute.SelectedValue, (int)comboBox_stato_rec.SelectedValue, ctrlDateTimePicker_start.ReadTs(), ctrlDateTimePicker_end.ReadTs()); ChangeMode(Mode.UPDATE); } else if (mode == Mode.UPDATE) { int eventkey = -1; if (dbDataGridView_teste.SelectedRows.Count > 0) { DataRowView drv = dbDataGridView_teste.SelectedRows[0].DataBoundItem as DataRowView; if (drv != null) { DataSet.dsEvents.EventiTestaRow row = drv.Row as DataSet.dsEvents.EventiTestaRow; eventkey = row.EventKey; } } eventiTestaTableAdapter.UpdateQuery( textBox_descr.Text, (int)comboBox_rep.SelectedValue, (int)comboBox_man.SelectedValue, Program.DateToInt(ctrlDateTimePicker_start.ReadTs()), Program.HmsToInt(ctrlDateTimePicker_start.ReadTs()), Program.DateToInt(ctrlDateTimePicker_end.ReadTs()), Program.HmsToInt(ctrlDateTimePicker_end.ReadTs()), textBox_contratto.Text, textBox_note.Text, (int)comboBox_ute.SelectedValue, (int)comboBox_stato_rec.SelectedValue, ctrlDateTimePicker_start.ReadTs(), ctrlDateTimePicker_end.ReadTs(), eventkey); } if (ctrlDateTimePicker_start.ReadTs() < dateTimePicker_start.Value) { dateTimePicker_start.Value = ctrlDateTimePicker_start.ReadTs(); } if (ctrlDateTimePicker_end.ReadTs() > dateTimePicker_end.Value) { dateTimePicker_end.Value = ctrlDateTimePicker_end.ReadTs(); } PerformSearch(); if (event_key != -1) { SelectEvent(event_key); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }