private void btnDeleteCountry_Click(object sender, EventArgs e)
{
CloudStorageAccount storageAccount =
CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("StorageConnectionString"));
CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
CloudTable table = tableClient.GetTableReference("country");
try
{
var country = new CountryTableEntity
{
RowKey = txtBoxDeleteCountryName.Text,
PartitionKey = txtBoxDeleteRegion.Text,
ETag = "*"
};
TableOperation deleteOperation = TableOperation.Delete(country);
table.Execute(deleteOperation);
MessageBox.Show(txtBoxNewCountryName.Text + @" deleted.");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void btnAddCountry_Click(object sender, EventArgs e)
{
CloudStorageAccount storageAccount =
CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("StorageConnectionString"));
CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
CloudTable table = tableClient.GetTableReference("country");
try
{
var country = new CountryTableEntity
{
RowKey = txtBoxNewCountryName.Text,
PartitionKey = txtBoxNewRegion.Text,
NumberCode = int.Parse(txtBoxNewNumberCode.Text),
Alpha2Code = txtBoxNewAlpha2Code.Text,
Alpha3Code = txtBoxNewAlpha3Code.Text,
Capital = txtBoxNewCapital.Text,
CurrencyAlpha3Code = txtBoxNewCurrecyAlpha3Code.Text,
Flag = File.Exists(@"Resources\flags\" + txtBoxNewAlpha3Code.Text + ".png")
? File.ReadAllBytes(@"Resources\flags\" + txtBoxNewAlpha3Code.Text + ".png")
: null
};
// Create the TableOperation that inserts the customer entity.
TableOperation insertOperation = TableOperation.InsertOrMerge(country);
// Execute the insert operation.
table.Execute(insertOperation);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
MessageBox.Show(txtBoxNewCountryName.Text + @" added.");
}
private void GenerateCountries()
{
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("StorageConnectionString"));
CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
CloudTable table = tableClient.GetTableReference("country");
var countries = File.ReadAllLines(@"Resources\countries.txt", Encoding.UTF8);
var columns = new string[0];
foreach (var country in countries)
{
try
{
columns = country.Split('\t');
var countryEntity1 = new CountryTableEntity
{
RowKey = columns[3],
PartitionKey = columns[6],
NumberCode = int.Parse(columns[0]),
Alpha2Code = columns[1],
Alpha3Code = columns[2],
Capital = columns[4],
CurrencyAlpha3Code = columns[5],
Flag = File.Exists(@"Resources\flags\" + columns[2] + ".png")
? File.ReadAllBytes(@"Resources\flags\" + columns[2] + ".png")
: null
};
// Create the TableOperation that inserts the customer entity.
TableOperation insertOperation = TableOperation.InsertOrMerge(countryEntity1);
// Execute the insert operation.
table.Execute(insertOperation);
}
catch (Exception ex)
{
if (InvokeRequired)
{
BeginInvoke((MethodInvoker) (() => MessageBox.Show(string.Format("{0}:{1}", columns[0], ex.Message))));
return;
}
MessageBox.Show(string.Format("{0}:{1}", columns[0], ex.Message));
}
}
if (InvokeRequired)
{
BeginInvoke((MethodInvoker)(delegate { btnGenerateCountries.Enabled = true; MessageBox.Show(@"Completed."); }));
}
else
{
btnGenerateCountries.Enabled = true;
MessageBox.Show(@"Completed.");
}
}
