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