public MainWindow() { InitializeComponent(); GettingSettings.SettingValuesFromConfig(); if (GettingSettings._sServer != null && GettingSettings._sServer != "") { try { string sqlConn = DatabaseProcedure.BuildingConnectionString(); if (sqlConn != "") { DatabaseProcedure.BuildingDatabase(sqlConn); DatabaseProcedure.BuildingTable(sqlConn); DatabaseProcedure.BuildingColumns(sqlConn); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } } dgComponent.CanUserAddRows = false; dataGrid.CanUserAddRows = false; dtShipDate.Text = DateTime.Now.ToString(); AddingItemsToDropDownList(); AddingComponentsToGrid(); FillingMainDataGrid(false); //StartingTimertoRefresh(); }
public static string BuildingConnectionString() { string sqlConn = string.Empty; if ((GettingSettings._sServer != "" && GettingSettings._sServer != null) && (GettingSettings._sDatabaseName != "" && GettingSettings._sDatabaseName != null) && (GettingSettings._sUserName != "" && GettingSettings._sUserName != null) && (GettingSettings._sPassword != null)) { GettingSettings Settings = new GettingSettings(); GettingSettings.SettingValuesFromConfig(); string sDecryptedPword = Password.ToInsecureString(GettingSettings._sPassword); sqlConn = $"Server = {GettingSettings._sServer}; Database = {GettingSettings._sDatabaseName}; User Id = {GettingSettings._sUserName}; Password = {sDecryptedPword};"; } return(sqlConn); }
public void FillingOutTxtBox() { GettingSettings.SettingValuesFromConfig(); if (GettingSettings._sServer != "" && GettingSettings._sServer != null) { txtServer.Text = GettingSettings._sServer.ToString(); } if (GettingSettings._sDatabaseName != "" && GettingSettings._sUserName != null) { txtDatabase.Text = GettingSettings._sDatabaseName.ToString(); } if (GettingSettings._sUserName != "" && GettingSettings._sUserName != null) { txtUsername.Text = GettingSettings._sUserName.ToString(); } if (GettingSettings._sPassword != null) { passwordBox.Password = Password.ToInsecureString(GettingSettings._sPassword); } }
private void button_Click(object sender, RoutedEventArgs e) { SavingSettings(); GettingSettings.SettingValuesFromConfig(); this.Close(); }
public Window1() { InitializeComponent(); GettingSettings.SettingValuesFromConfig(); FillingOutTxtBox(); }