private void Info_CloseFromNext(object sender, PageEventArgs e) { if (txtGeomFiled.Text == "") { MetroMessageBox.Show(this, Properties.Resources.FieldNameNeeded, Properties.Resources.Erreur, MessageBoxButtons.OK, MessageBoxIcon.Error); } var param = new string[] { _view.Nom, txtGeomFiled.Text, $"geometry({cmbType.SelectedItem},{txtSrid.Text})", _view.Schema }; WizardSQLHelper.ExecuteFromFile("addField.sql", param, Program.AppSet.ConnectionString, this); TabloidConfigGeoLoc.GeoLocType geoLocType; Enum.TryParse(cmbType.SelectedItem.ToString(), out geoLocType); _view.GeoLoc.Type = geoLocType; _view.GeoLoc.TitreCouche = _view.Titre; _view.GeoLoc.Geom = txtGeomFiled.Text; _view.GeoLoc.Srid = txtSrid.Text; _view.GeoLoc.ForcerSRID = true; if (chkAddMenu.Checked) { WizardSQLHelper.AddToMenu(this, _view, "Carte " + _view.Titre, TabloidConfigMenuItem.MenuType.Carte, null); } }
private void addToMenu(TabloidConfigView t) { if (!chkAjMenu.Checked) { return; } if (radMnMain.Checked) { WizardSQLHelper.AddToMenu(this, t); } else { WizardSQLHelper.AddToParamMenu(t, this); } }
private void Info_CloseFromNext(object sender, PageEventArgs e) { Program.AppSet.smsBoxPassword = txtPass.Text; Program.AppSet.smsBoxUser = txtUser.Text; Tabloid.Classes.Config.Helper.AutomaticViewBuilder.setTextes(Program.AppSet.Schema); if (chkAlert.Checked) { var alertMn = new TabloidConfigMenuItem { Titre = Properties.Resources.Alert, Type = TabloidConfigMenuItem.MenuType.Simple }; WizardSQLHelper.AddToMenu(this, alertMn, null, true); WizardSQLHelper.AddToMenu(this, new TabloidConfigMenuItem { Titre = Properties.Resources.SimpleSMS, Type = TabloidConfigMenuItem.MenuType.Sms }, alertMn, true); WizardSQLHelper.AddToMenu(this, new TabloidConfigMenuItem { Titre = Properties.Resources.MultiSMS, Type = TabloidConfigMenuItem.MenuType.Filtre, Table = _view.Nom }, alertMn, true); } if (chkText.Checked) { WizardSQLHelper.AddToParamMenu(this, new TabloidConfigMenuItem { Titre = Properties.Resources.PreDefineText, Type = TabloidConfigMenuItem.MenuType.TxtSms }, true); } }
private void Button_end(object sender, PageEventArgs e) { string sql = ""; var titre = buildField(chkCreaTitre, cmbTitre, txtTitre, ref sql); var deb = buildField(chkCreaDeb, cmbDeb, txtDebut, ref sql); var fin = buildField(chkCreaFin, cmbFin, txtFin, ref sql); if (sql != "") { sql += "commit;"; e.Cancel = !WizardSQLHelper.ExecuteSQLString(sql, this); if (e.Cancel) { return; } } var cal = new TabloidConfigCalendrier { Titre = titre, Debut = deb, Fin = fin }; var cTitre = new TabloidConfigColonne { Titre = "Titre", Champ = titre, Type = DbType.String }; var cDebut = new TabloidConfigColonne { Titre = "Début", Champ = deb, Type = DbType.DateTime }; var cFin = new TabloidConfigColonne { Titre = "Fin", Champ = fin, Type = DbType.DateTime }; if (chkCreaTitre.Checked) { Tools.AddWithUniqueName(_view.Colonnes, cTitre, "C"); } if (chkCreaDeb.Checked) { Tools.AddWithUniqueName(_view.Colonnes, cDebut, "C"); } if (chkCreaFin.Checked) { Tools.AddWithUniqueName(_view.Colonnes, cFin, "C"); } _view.Calendrier = cal; if (chkAddToMenu.Checked) { var mn = radMnParam.Checked ? WizardSQLHelper.getParamMenu() : null; WizardSQLHelper.AddToMenu(this, _view, null, TabloidConfigMenuItem.MenuType.Calendrier, mn); } }