private static void ListAllFirearms()
{
FirearmRepositorySQL firearmRepository = new FirearmRepositorySQL();
List <Firearm> firearm;
using (firearmRepository)
{
firearm = firearmRepository.SelectAll();
ConsoleView.DisplayAllFirearms(firearm);
ConsoleView.DisplayContinuePrompt();
}
}
private static void AddFirearm()
{
FirearmRepositorySQL firearmRepository = new FirearmRepositorySQL();
Firearm firearm = new Firearm();
firearm = ConsoleView.AddFirearm();
using (firearmRepository)
{
firearmRepository.Insert(firearm);
}
ConsoleView.DisplayContinuePrompt();
}
private static void UpdateSkiRun()
{
FirearmRepositorySQL firearmRepository = new FirearmRepositorySQL();
List <Firearm> firearms = firearmRepository.SelectAll();
Firearm firearm = new Firearm();
int firearmID;
using (firearmRepository)
{
firearms = firearmRepository.SelectAll();
firearmID = ConsoleView.GetFirearmID(firearms);
firearm = firearmRepository.SelectById(firearmID);
firearm = ConsoleView.UpdateFirearm(firearm);
firearmRepository.Update(firearm);
}
}
private static void DisplayFirearmDetail()
{
FirearmRepositorySQL firearmRepository = new FirearmRepositorySQL();
List <Firearm> firearms;
Firearm firearm = new Firearm();
int firearmID;
using (firearmRepository)
{
firearms = firearmRepository.SelectAll();
firearmID = ConsoleView.GetFirearmID(firearms);
firearm = firearmRepository.SelectById(firearmID);
}
ConsoleView.DisplayFirearm(firearm);
ConsoleView.DisplayContinuePrompt();
}
private static void QueryFirearmsById()
{
FirearmRepositorySQL firearmRepository = new FirearmRepositorySQL();
IEnumerable <Firearm> matchingFirearms = new List <Firearm>();
int lowerId;
int higherId;
ConsoleView.GetIdQueryLowHiValues(out lowerId, out higherId);
using (firearmRepository)
{
matchingFirearms = firearmRepository.QueryById(lowerId, higherId);
}
ConsoleView.DisplayQueryResults(matchingFirearms);
ConsoleView.DisplayContinuePrompt();
}
private static void DeleteFirearm()
{
FirearmRepositorySQL firearmRepository = new FirearmRepositorySQL();
List <Firearm> firearms = firearmRepository.SelectAll();
Firearm firearm = new Firearm();
int firearmID;
string message;
firearmID = ConsoleView.GetFirearmID(firearms);
using (firearmRepository)
{
firearmRepository.Delete(firearmID);
}
ConsoleView.DisplayReset();
message = String.Format("Firearm ID: {0} had been deleted.", firearmID);
ConsoleView.DisplayMessage(message);
ConsoleView.DisplayContinuePrompt();
}