private void DeleteColourButton_Click(object sender, EventArgs e)
{
//get the currently selected colour id to delete
int colourId = int.Parse(ColourIDTextBox.Text);
//execute it using the ColoursManager
int rowsAffected = ColoursManager.DeleteColour(colourId);
//check for the result
if (rowsAffected == 1)
{
MessageBox.Show("Colour deleted",
"Deleted",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
MessageBox.Show(
"Unable to delete type.",
"Unable to delete.",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
//refresh the list box with the updated information
ColourListBox.DataSource = ColoursManager.GetColourList();
}
private void ColourForm_Load(object sender, EventArgs e)
{
//Getting a list of Colours from DAL (ColoursManager)
List <Colour> Colours = ColoursManager.GetColourList();
//Put the data into the list box
ColourListBox.DataSource = Colours;
ColourListBox.DisplayMember = "Name";
}
private void SaveColourButton_Click(object sender, EventArgs e)
{
if (ColourIDTextBox.Text == string.Empty)
{
//Create a new colour entry
Colour colours = new Colour();
colours.Name = ColourNameTextBox.Text;
//call the method in ColoursMaanger to save the data
Colour saveColour = ColoursManager.AddColour(colours);
//create a message to indicate it was successful
MessageBox.Show("New colour added.");
//refresh the list to display the new information
List <Colour> coloursList = ColoursManager.GetColourList();
ColourListBox.DataSource = coloursList;
//select the new colour from the list
SelectColourFromListBox(saveColour.Id);
}
else
{
//Update existing colour entry
int colourId = int.Parse(ColourIDTextBox.Text);
string colourName = ColourNameTextBox.Text;
if (ColoursManager.UpdateColour(colourId, colourName) == 1)
{
//update is successful
MessageBox.Show("Colour has been updated.");
//Get the list of types, and refresh the list box
//Re-select the value in the list box
List <Colour> colourList = ColoursManager.GetColourList();
ColourListBox.DataSource = colourList;
}
else
{
MessageBox.Show("Colour has NOT been updated.");
}
}
}
private void CurrencyForm_Load_1(object sender, EventArgs e)
{
//Getting a list of Currencies from DAL (TypesManager)
List <Colour> Colours = ColoursManager.GetColourList();
CurrencyColourIDComboBox.DataSource = Colours;
CurrencyColourIDComboBox.DisplayMember = "Name";
CurrencyColourIDComboBox.ValueMember = "Name";
List <Country> Countries = CountryManager.GetCountryList();
CountryCodeCurrencyComboBox.DataSource = Countries;
CountryCodeCurrencyComboBox.DisplayMember = "Country Code";
CountryCodeCurrencyComboBox.ValueMember = "CountryCode";
////Put the data into the list box
List <Currency> Currencies = CurrenciesDAL.CurrencyManager.GetCurrencyList();
CurrencyListBox.DataSource = Currencies;
CurrencyListBox.DisplayMember = "Name";
}
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
}
