private void TypeForm_Load(object sender, EventArgs e)
{
//Getting a list of Types from DAL (TypesManager)
List <Type> Types = TypesManager.GetTypeList();
//List<Country> Countries = CountryManager.GetCountryList();
//List<Currency> Currencies = CurrenciesDAL.CurrencyManager.GetCurrencyList();
////Put the data into the list box
TypeListBox.DataSource = Types;
TypeListBox.DisplayMember = "Name";
}
private void SaveTypeButton_Click(object sender, EventArgs e)
{
if (TypeIDTextBox.Text == string.Empty)
{
Type t = new Type();
t.Name = NameTextBox.Text;
Type savedType = TypesManager.AddType(t);
MessageBox.Show("A new Type has been added.");
//refresh the value in the list
List <Type> typeList = TypesManager.GetTypeList();
TypeListBox.DataSource = typeList;
//re-select the chosen type
SelectTypeFromListBox(savedType.Id);
}
else
{
//Update existing type entry
int typeId = int.Parse(TypeIDTextBox.Text);
string typeName = NameTextBox.Text;
if (TypesManager.UpdateType(typeId, typeName) == 1)
{
//update is successful
MessageBox.Show("Type has been updated.");
//Get the list of types, and refresh the list box
//Re-select the value in the list box
List <Type> typeList = TypesManager.GetTypeList();
TypeListBox.DataSource = typeList;
}
else
{
MessageBox.Show("Type has NOT been updated.");
}
}
}
private void DeleteTypeButton_Click(object sender, EventArgs e)
{
int typeId = int.Parse(TypeIDTextBox.Text); //parse from int to string
int rowsAffected = TypesManager.DeleteType(typeId); //check for # rows affected
if (rowsAffected == 1)
{
MessageBox.Show(
"Type deleted.",
"Deleted",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
MessageBox.Show(
"Unable to delete type.",
"Unable to delete.",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
//refresh the list with the updated information
TypeListBox.DataSource = TypesManager.GetTypeList();
}
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
}