private void EditSchoolClass() { try { var SC = olvKlasa.SelectedObject as SchoolClass; using (var dlg = new dlgSchoolClass(false)) { FillDialog(dlg, SC); if (dlg.ShowDialog() == DialogResult.OK) { if (UpdateData(dlg, SC).Result > 0) { NewRecord(SC.ID); return; } throw new Exception("Aktualizacja danych nie powiodła się!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private async Task <int> UpdateData(dlgSchoolClass dlg, SchoolClass SC) { using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); return(await dbs.UpdateRecordAsync(SchoolClassSQL.UpdateSchoolClass(), CreateUpdateParams(dlg, SC.ID))); } }
private void cmdAddNew_Click(object sender, EventArgs e) { using (var dlg = new dlgSchoolClass(true)) { dlg.NewRecordAdded += NewRecord; dlg.ShowDialog(); dlg.NewRecordAdded -= NewRecord; } }
private void FillDialog(dlgSchoolClass dlg, SchoolClass SC) { dlg.Text = "Edycja danych"; dlg.cbKlasa.Enabled = false; dlg.cbKlasa.Items.Add(SC.ClassCode); dlg.cbKlasa.SelectedIndex = 0; dlg.chkVirtual.Checked = SC.IsVirtual > 0; dlg.cmdOK.Enabled = true; }
IDictionary <string, Object> CreateUpdateParams(dlgSchoolClass dlg, int id) { var sqlParamWithValue = new Dictionary <string, object>(); sqlParamWithValue.Add("@ID", id); sqlParamWithValue.Add("@NazwaKlasy", dlg.txtNazwa.Text.Trim()); sqlParamWithValue.Add("@IsVirtual", dlg.chkVirtual.Checked); sqlParamWithValue.Add("@User", UserSession.User.Login); sqlParamWithValue.Add("@IP", AppSession.HostIP); return(sqlParamWithValue); }