private void DeleteCountryButton_Click(object sender, EventArgs e)
{
string countryCode = CountryCodeTextBox.Text;
int rowsAffected = Convert.ToInt32(CountryManager.DeleteCountry(countryCode));
if (rowsAffected == 1)
{
MessageBox.Show(
"Country deleted.",
"Deleted",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
MessageBox.Show(
"Unable to delete country.",
"Unable to delete.",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
//refresh the list with the updated information
CountryListBox.DataSource = CountryManager.GetCountryList();
}
}
public async Task Task_DeleteCountry_OkResult()
{
var country = new CountryModel
{
CountryId = 5,
Name = "Nigeria",
Continent = "Africa",
//DateCreated = DateTime.Now
};
//Arrange
var options = new DbContextOptionsBuilder <CountryData>()
.UseInMemoryDatabase(databaseName: "Get_Countries")
.Options;
// Run the test against one instance of the context
using (var context = new CountryData(options))
{
var repository = new CountryRepository(context);
var modelmanager = new CountryManager(repository);
//Act
await modelmanager.DeleteCountry(country.CountryId);
var result = await modelmanager.GetAllCountries();
//Assert
Assert.AreEqual(country.Name, result[0].Name);
}
}
protected void lbDelete_Click(object sender, EventArgs e)
{
LinkButton linkButton = new LinkButton();
linkButton = (LinkButton)sender;
bool result = CountryManager.DeleteCountry(Convert.ToInt32(linkButton.CommandArgument));
showCountryGrid();
}
protected void DeleteButton_Click(object sender, EventArgs e)
{
try
{
CountryManager.DeleteCountry(this.CountryID);
Response.Redirect("Countries.aspx");
}
catch (Exception exc)
{
ProcessException(exc);
}
}
public long DeleteCountry(long countryId)
{
try
{
return(_countryManager.DeleteCountry(countryId));
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public IActionResult DeleteCountry(int?id)
{
var country = countryManager.FindById((int)id);
if (country == null)
{
return(NotFound());
}
countryManager.DeleteCountry((int)id);
TempData["message"] = "Se ha eliminado país correctamente";
return(RedirectToAction("Index"));
}
static void Main(string[] args)
{
#region "GET ALL"
#region "GET ALL Currencies TEST"
List <Currency> currenciesList = CurrencyManager.GetCurrencyList();
Console.WriteLine("List of currencies: " + "\n");
foreach (Currency currency in currenciesList)
{
Console.WriteLine(currency.Name);
}
#endregion
#region "GET ALL Colours TEST"
List <Colour> coloursList = ColoursManager.GetColourList();
Console.WriteLine("\nList of colours: ");
foreach (Colour colour in coloursList)
{
Console.WriteLine(colour.Name);
}
#endregion
#region "GET ALL Country TEST"
List <Country> countriesList = CountryManager.GetCountryList();
Console.WriteLine("\nList of countries: ");
foreach (Country country in countriesList)
{
Console.WriteLine(country.Name);
}
#endregion
#region "GET ALL Types TEST"
List <Type> typesList = TypesManager.GetTypeList();
Console.WriteLine("\nList of types: ");
foreach (Type type in typesList)
{
Console.WriteLine(type.Name);
}
#endregion
#endregion
#region "GET ONE"
#region "GET ONE Currency by ID TEST"
Console.Write("\nEnter a currency ID: ");
string getCurrencyId = Console.ReadLine();
Currency getCurrencyById = CurrencyManager.GetCurrency(int.Parse(getCurrencyId));
if (getCurrencyById != null)
{
Console.WriteLine(getCurrencyById.Name);
}
else
{
Console.WriteLine("Sorry, currency ID cannot be found.");
}
#endregion
#region "GET ONE Colours by ID TEST"
Console.Write("\nEnter a Colour ID: ");
string getColourId = Console.ReadLine();
Colour getColourById = ColoursManager.GetColour(int.Parse((getColourId)));
if (getColourById != null)
{
Console.WriteLine(getColourById.Name);
}
else
{
Console.WriteLine("Sorry, the colour ID cannot be found.");
}
#endregion
#region "GET ONE Country by ID TEST"
Console.Write("\nEnter a country Code: ");
string getCountryCode = Console.ReadLine();
Country getCountryByCode = CountryManager.GetCountry(getCountryCode);
if (getCountryByCode != null)
{
Console.WriteLine(getCountryByCode.Name);
}
else
{
Console.WriteLine("Sorry, the country code cannot be found.");
}
#endregion
#region "GET ONE Type by ID TEST"
Console.Write("\nEnter a type ID: ");
string getTypeId = Console.ReadLine();
Type getTypeById = TypesManager.GetTypes(int.Parse((getTypeId)));
if (getTypeById != null)
{
Console.WriteLine(getTypeById.Name);
}
else
{
Console.WriteLine("Sorry, the type ID cannot be found.");
}
#endregion
#endregion
#region "ADD"
/*
#region "ADD Currency TEST"
* Currency addCurrency = new Currency();
* addCurrency.Name = "Japanese Yen";
*
* Currency addCurrencyTwo = CurrencyManager.AddCurrency(addCurrency);
* Console.WriteLine(string.Format("The new Currency ID is {0}", addCurrency.Id));
*/
#region "ADD Colour TEST"
Colour addColour = new Colour();
addColour.Id = 20;
addColour.Name = "Blue";
Colour addColourTwo = ColoursManager.AddColour(addColour);
Console.WriteLine(string.Format("The new Colour Id is {0}", addColourTwo.Id));
#endregion
#region "ADD Country TEST"
#endregion
#region "ADD Type TEST"
#endregion
#endregion
#region "UPDATE"
/*
#region "UPDATE Currency TEST"
* Currency updateCurrency = new Currency();
* updateCurrency.Id = 3;
* updateCurrency.Name = "Japanese Yen";
* updateCurrency.ColourId = 4;
* updateCurrency.CountryCode = "JPN";
*
* int rowsAffected = CurrencyManager.UpdateCurrency(updateCurrency);
* Console.WriteLine("Update successful! {0} rows affected", rowsAffected);
*
#endregion
*/
#region "UPDATE Colours TEST"
Colour updateColours = new Colour();
updateColours.Id = 2;
updateColours.Name = "Blue";
//int colourRowsAffected = ColoursManager.UpdateColour(updateColours);
//Console.WriteLine("Update successful! {0} rows affected", colourRowsAffected);
#endregion
#region "UPDATE Countries TEST"
Country updateCountries = new Country();
updateCountries.CountryCode = "GRE";
updateCountries.Name = "Greece Updated";
//string countryRowsAffected = CountryManager.UpdateCountry(updateCountries);
//Console.WriteLine("Update successful! {0} rows affected", countryRowsAffected);
#endregion
#region "UPDATE Types TEST"
Type updateTypes = new Type();
updateTypes.Id = 2;
updateTypes.Name = "Crypto";
//int typeRowsAffected = TypesManager.UpdateType(updateTypes);
//Console.WriteLine("Update successful! {0} rows affected", typeRowsAffected);
#endregion
#endregion
#region "DELETE"
#region "DELETE Currency TEST"
Console.Write("\nPlease enter the Currency Id you wish to delete: ");
string deleteCurrencyId = Console.ReadLine();
CurrencyManager.DeleteCurrency(Int32.Parse(deleteCurrencyId));
if (deleteCurrencyId != null)
{
Console.WriteLine(string.Format("\nCurrency Id {0} has been deleted.", deleteCurrencyId));
}
else
{
Console.WriteLine("Sorry, the currency ID cannot be deleted.");
}
#endregion
#region "DELETE Colours TEST"
Console.Write("\nPlease enter the Colour Id you wish to delete: ");
string deleteColourId = Console.ReadLine();
ColoursManager.DeleteColour(Int32.Parse(deleteColourId));
if (deleteColourId != null)
{
Console.WriteLine(string.Format("\nColour Id {0} has been deleted.", deleteColourId));
}
else
{
Console.WriteLine("Sorry, the colour ID cannot be deleted.");
}
#endregion
#region "DELETE Countries TEST"
Console.Write("\nPlease enter the Country Code you wish to delete: ");
string deleteCountryCode = Console.ReadLine();
CountryManager.DeleteCountry(deleteCountryCode);
if (deleteCountryCode != null)
{
Console.WriteLine("\nCountry Code {0} has been deleted.", deleteCountryCode);
}
else
{
Console.WriteLine("Sorry, the country code cannot be deleted.");
}
#endregion
#region "DELETE Types TEST"
Console.Write("\nPlease enter the Type Id you wish to delete: ");
string deleteTypeId = Console.ReadLine();
TypesManager.DeleteType(Int32.Parse(deleteTypeId));
if (deleteTypeId != null)
{
Console.WriteLine(string.Format("\n Type Id {0} has been deleted.", deleteTypeId));
}
else
{
Console.WriteLine("Sorry, the type ID cannot be deleted.");
}
Console.WriteLine("");
Console.WriteLine("Press any key to close...");
Console.Read(); //keep console window open
#endregion
#endregion
}