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