private void Delete_Monument_Load(object sender, EventArgs e)
{
DB_Images = new DB_Images("lol", "lol");
try
{
string dsource = "(DESCRIPTION="
+ "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)"
+ "(HOST=mercure.clg.qc.ca)(PORT=1521)))"
+ "(CONNECT_DATA=(SERVICE_NAME=ORCL.clg.qc.ca)))";
string chaineDeconnexion = "Data Source = " + dsource + "; User Id = lanthies; password = ORACLE1";
connection.ConnectionString = chaineDeconnexion;
connection.Open();
string sql2 = "select nom from circuit";
OracleCommand oraComm5 = new OracleCommand(sql2, connection);
OracleDataReader oraReader5 = oraComm5.ExecuteReader();
while (oraReader5.Read())
{
CB_circuit.Items.Add(oraReader5.GetString(0));
}
CB_circuit.SelectedIndex = 0;
}
catch (Exception sqlConnex)
{
MessageBox.Show(sqlConnex.Message.ToString());
}
}
private void SeConnecter()
{
try
{
string dsource = "(DESCRIPTION="
+ "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)"
+ "(HOST=mercure.clg.qc.ca)(PORT=1521)))"
+ "(CONNECT_DATA=(SERVICE_NAME=ORCL.clg.qc.ca)))";
// Déclaration de la chaine de connection //
string ChaineDeConnection = "Data Source = " + dsource + "; User Id = Bertrand; password = ORACLE1";
mOracleConnection.ConnectionString = ChaineDeConnection;
mOracleConnection.Open();
BTN_Connexion.Hide();
FBTN_Etoiles.Enabled = true;
DGV_Monuments.Enabled = true;
FBTN_Ville.Enabled = true;
CBB_Monument.Enabled = true;
FBTN_Prix.Enabled = true;
FBTN_AfficherMonument.Enabled = true;
FBTN_AfficherCircuit.Enabled = true;
FBTN_MeilleurCircuit.Enabled = true;
EstConnect = true;
mDB_Images = new DB_Images("BaboucheQc", "9952");
}
catch (Exception sqlmOracleConnection)
{
MessageBox.Show(sqlmOracleConnection.Message.ToString());
}
RemplirCBB_Monument();
}
// Constructeur //
public DLG_AjoutMonument(DB_Images image, List <string> list)
{
InitializeComponent();
mListeCircuit = new List <string>();
mListMonument = list;
InitialiserValidationProvider();
mDB_Images = image;
}
private void Main_Load(object sender, EventArgs e)
{
LoadSettings();
string DateMenu = DateTime.Today.ToLongDateString();
LBX_Date.Text = DateMenu;
mDB_Images = new DB_Images("BaboucheQc", "9952");
mDGV_MonumentActive = false;
mDGV_CircuitActive = false;
}
public InformationsCircuitForm(string nomCircuit = "", bool fixedMode = false)
{
InitializeComponent();
mConnexionDAL = ConnectionDAL.GetInstance();
DB_Images = new DB_Images("Emile", "Salut123");
InitCbxCircuits(nomCircuit);
if (fixedMode)
{
cbxCircuits.Enabled = false;
this.Text = "Meilleur circuit";
}
}
private void NouveauMonumentForm_Load(object sender, EventArgs e)
{
DB_Images = new DB_Images("Emile", "Salut123");
ValidationProvider = new ValidationProvider(this);
ValidationProvider.AddControlToValidate(TBX_Nom, ValiderNom);
ValidationProvider.AddControlToValidate(nudPrix, ValiderPrix);
ValidationProvider.AddControlToValidate(RTBX_Histoire, ValiderHistoire);
ValidationProvider.AddControlToValidate(DATE_Monument, ValiderDate);
ValidationProvider.AddControlToValidate(Control_Stars, ValiderStars);
ValidationProvider.AddControlToValidate(PBX_Monument, Valider_PBX_Monument);
if (!Properties.Settings.Default.LocationAjoutMonument.IsEmpty)
{
this.Location = Properties.Settings.Default.LocationAjoutMonument;
}
}
public AfficherImageMonument(string id, OracleConnection connection)
{
InitializeComponent();
DB_Images = new DB_Images("Emile", "Salut123");
try
{
string sql = "SELECT IMAGE FROM MONUMENTS WHERE IDMONUMENT = " + id;
OracleCommand cmd = new OracleCommand(sql, connection);
OracleDataReader oracleReader = cmd.ExecuteReader();
while (oracleReader.Read())
{
PBX_Image.BackgroundImage = DB_Images.Find(oracleReader.GetString(0));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
protected void btncreate_Click(object sender, EventArgs e)
{
try
{
DB_Images image = new DB_Images();
image.StrCon = axVarSes.Lee <string>("strCon");
image.UpdatedBy = Convert.ToInt32(axVarSes.Lee <string>("strUserID"));
body.StrCon = axVarSes.Lee <string>("strCon");
body.Name = tbName.Text;
body.UpdatedBy = Convert.ToInt32(axVarSes.Lee <string>("strUserID"));
image.ImageUrl = tbUrl.Text;
image.ImageTitle = tbTitle.Text;
if (image.Insert())
{
DataTable dt = image.SeeByParams();
body.ImageId = Convert.ToInt32(dt.Rows[0][0].ToString());
if (body.Insert())
{
pnOK.Visible = true;
pnBodyParts.Visible = true;
pnmodify.Visible = false;
lblOK.Text = "Datos actualizados satisfactoriamente.";
cargarGrid();
}
else
{
pnError.Visible = true;
lblError.Text = "Los datos se crearon parcialmente. " + body.Message;
}
}
else
{
pnError.Visible = true;
lblError.Text = "No se pudieron actualizar los datos. " + image.Message;
}
}
catch (Exception ex)
{
pnError.Visible = true;
lblError.Text = "No se pudieron actualizar los datos. " + e.ToString();
}
}
private void Ajouter_Monument_Shown(object sender, EventArgs e)
{
DB_Images = new DB_Images("lol", "lol");
Load_ImageGUIDs();
}
public DLG_ListeMonuments()
{
InitializeComponent();
DB_Images = new DB_Images("Gabriel", "MotDePasse");
}
public DLG_AfficherInformation(DB_Images image)
{
InitializeComponent();
mDB_Images = image;
}
