public IActionResult Index() { // TODO: add cookies usage. if (launchCounter < 3) { return(Content("Update page, please")); } _cookiesManager = new CookiesManager(Request, Response); long uid = _cookiesManager.GetUid(); UserSettings userSettings = _currencyXplorer.RequestUserSettings(uid); ICollection <CurrencyCodeEntry> currencyCodesList = _currencyXplorer.GetAllCurrencyCodes(); CurrencyExplorerLanguage language = _currencyXplorer.CurrencyExplorerLanguage; //CurrencyExplorerLanguage language = CurrencyExplorerLanguage.Ukrainian; ILocalization localization = null; switch (language) { case CurrencyExplorerLanguage.Russian: localization = new RussianLocalization(_applicationEnvironment); break; case CurrencyExplorerLanguage.Ukrainian: localization = new UkrainianLocalization(_applicationEnvironment); break; case CurrencyExplorerLanguage.English: localization = new EnglishLocalization(_applicationEnvironment); break; default: throw new ArgumentOutOfRangeException(); } ViewBag.Localization = localization; ViewBag.UiLanguage = language; ViewBag.CurrencyCodesList = currencyCodesList; ViewBag.UserSettings = userSettings; return(View()); }
public Form1() { InitializeComponent(); random = new Random(); panelEdit.Visible = false; englishLocalization = new EnglishLocalization(); russianLocalization = new RussianLocalization(); dir = Directory.GetParent(Directory.GetParent(Directory.GetParent(AppDomain.CurrentDomain.BaseDirectory).FullName).FullName).FullName; resource = dir + @"\Properties\Resources\"; defaultImage = Image.FromFile(resource + "giphy.gif"); fromLanguage = "Russian"; intoLanguage = "English"; string attachDBFilename = dir + @"\App_Data\TrainingTranslate.mdf"; SqlConnectionStringBuilder sqlConnectionString = new SqlConnectionStringBuilder { DataSource = @"(localdb)\mssqllocaldb", InitialCatalog = "TrainingTranslate", AttachDBFilename = attachDBFilename, IntegratedSecurity = true }; connection = new SqlConnection(sqlConnectionString.ConnectionString); connection.Open(); adapter = new SqlDataAdapter("select * from RussianWords", connection); // SqlCommand delete #region delete SqlCommand delete = new SqlCommand(); delete.CommandText = "delete from RussianWords where (Id=@p)"; delete.Parameters.Add("@p", SqlDbType.Int); delete.Parameters["@p"].SourceColumn = "Id"; delete.Connection = adapter.SelectCommand.Connection; adapter.DeleteCommand = delete; #endregion delete // SqlCommand insert #region insert SqlCommand insert = new SqlCommand(); insert.CommandText = "insert into RussianWords (Russian, English, Picture) values (@p1, @p2, @p3)"; insert.Parameters.Add("@p1", SqlDbType.NVarChar); insert.Parameters["@p1"].SourceColumn = "Russian"; insert.Parameters.Add("@p2", SqlDbType.NVarChar); insert.Parameters["@p2"].SourceColumn = "English"; insert.Parameters.Add("@p3", SqlDbType.Image); insert.Parameters["@p3"].SourceColumn = "Picture"; insert.Connection = adapter.SelectCommand.Connection; adapter.InsertCommand = insert; #endregion insert // SqlCommand update #region update SqlCommand update = new SqlCommand(); update.CommandText = "update RussianWords set Russian=@p1, English=@p2, Picture=@p3 where (Id=@pp1) AND (Russian=@pp2) AND (English=@pp3)"; update.Parameters.Add("@p1", SqlDbType.NVarChar); update.Parameters["@p1"].SourceColumn = "Russian"; update.Parameters.Add("@p2", SqlDbType.NVarChar); update.Parameters["@p2"].SourceColumn = "English"; update.Parameters.Add("@p3", SqlDbType.Image); update.Parameters["@p3"].SourceColumn = "Picture"; update.Parameters.Add("@pp1", SqlDbType.Int); update.Parameters["@pp1"].SourceColumn = "Id"; update.Parameters["@pp1"].SourceVersion = DataRowVersion.Original; update.Parameters.Add("@pp2", SqlDbType.NVarChar); update.Parameters["@pp2"].SourceColumn = "Russian"; update.Parameters["@pp2"].SourceVersion = DataRowVersion.Original; update.Parameters.Add("@pp3", SqlDbType.NVarChar); update.Parameters["@pp3"].SourceColumn = "English"; update.Parameters["@pp3"].SourceVersion = DataRowVersion.Original; update.Connection = adapter.SelectCommand.Connection; adapter.UpdateCommand = update; #endregion update dataSet = new DataSet(); adapter.Fill(dataSet); if (dataSet.Tables[0].Rows.Count == 0) { InitializeDB(); adapter.Fill(dataSet); } dataGridView1.DataSource = dataSet.Tables[0]; dataGridView1.Columns["Id"].Visible = false; SelectWord(); }