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