/// <summary> /// method to add a new firearm /// </summary> /// <param name="firearm"></param> public void Insert(Firearm firearm) { string connString = GetConnectionString(); // build out SQL command var sb = new StringBuilder("INSERT INTO Firearms"); sb.Append(" ([ID],[Name],[Manufacturer], [FirearmType], [AmmoType], [BarrelLength])"); sb.Append(" Values ("); sb.Append("'").Append(firearm.ID).Append("',"); sb.Append("'").Append(firearm.Name).Append("',"); sb.Append("'").Append(firearm.Manufacturer).Append("',"); sb.Append("'").Append(firearm.FirearmType).Append("',"); sb.Append("'").Append(firearm.AmmoType).Append("',"); sb.Append("'").Append(firearm.BarrelLength).Append("')"); string sqlCommandString = sb.ToString(); using (SqlConnection sqlConn = new SqlConnection(connString)) using (SqlDataAdapter sqlAdapter = new SqlDataAdapter()) { try { sqlConn.Open(); sqlAdapter.InsertCommand = new SqlCommand(sqlCommandString, sqlConn); sqlAdapter.InsertCommand.ExecuteNonQuery(); } catch (SqlException sqlEx) { Console.WriteLine("SQL Exception: {0}", sqlEx.Message); Console.WriteLine(sqlCommandString); } } }
/// <summary> /// method to update an existing ski run /// </summary> /// <param name="firearm">firearm object</param> public void Update(Firearm firearm) { string connString = GetConnectionString(); // build out SQL command var sb = new StringBuilder("UPDATE Firearms SET "); sb.Append("Name = '").Append(firearm.Name).Append("', "); sb.Append("Manufacturer = '").Append(firearm.Manufacturer).Append("', "); sb.Append("FirearmType = '").Append(firearm.FirearmType).Append("', "); sb.Append("AmmoType = '").Append(firearm.AmmoType).Append("', "); sb.Append("BarrelLength = ").Append(firearm.BarrelLength).Append(" "); sb.Append("WHERE "); sb.Append("ID = ").Append(firearm.ID); string sqlCommandString = sb.ToString(); using (SqlConnection sqlConn = new SqlConnection(connString)) using (SqlDataAdapter sqlAdapter = new SqlDataAdapter()) { try { sqlConn.Open(); sqlAdapter.UpdateCommand = new SqlCommand(sqlCommandString, sqlConn); sqlAdapter.UpdateCommand.ExecuteNonQuery(); } catch (SqlException sqlEx) { Console.WriteLine("SQL Exception: {0}", sqlEx.Message); Console.WriteLine(sqlCommandString); } } }
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(); }
/// <summary> /// method to display a firearm's info /// </summary> public static void DisplayFirearm(Firearm firearm) { DisplayReset(); DisplayMessage(""); Console.WriteLine(ConsoleUtil.Center("Firearm Detail", WINDOW_WIDTH)); DisplayMessage(""); DisplayMessage(String.Format("Firearm: {0}", firearm.Name)); DisplayMessage(""); DisplayMessage(String.Format("ID: {0}", firearm.ID.ToString())); DisplayMessage(String.Format("Manufacturer: {0}", firearm.Manufacturer.ToString())); DisplayMessage(String.Format("Type: {0}", firearm.FirearmType.ToString())); DisplayMessage(String.Format("Caliber/Guage: {0}", firearm.AmmoType.ToString())); DisplayMessage(""); }
private IEnumerable <Firearm> ReadAllFirearms() { IList <Firearm> firearms = new List <Firearm>(); string connString = GetConnectionString(); string sqlCommandString = "SELECT * from Firearms"; using (SqlConnection sqlConn = new SqlConnection(connString)) using (SqlCommand sqlCommand = new SqlCommand(sqlCommandString, sqlConn)) { try { sqlConn.Open(); using (SqlDataReader reader = sqlCommand.ExecuteReader()) { if (reader != null) { while (reader.Read()) { Firearm firearm = new Firearm(); firearm.ID = Convert.ToInt32(reader["ID"]); firearm.Name = reader["Name"].ToString(); firearm.Manufacturer = reader["Manufacturer"].ToString(); firearm.FirearmType = reader["FirearmType"].ToString(); firearm.AmmoType = reader["AmmoType"].ToString(); firearm.BarrelLength = Convert.ToInt32(reader["BarrelLength"]); firearms.Add(firearm); } } } } catch (SqlException sqlEx) { Console.WriteLine("SQL Exception: {0}", sqlEx.Message); Console.WriteLine(sqlCommandString); } } return(firearms); }
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(); }
/// <summary> /// method to add a firearm's info /// </summary> public static Firearm AddFirearm() { Firearm firearm = new Firearm(); DisplayReset(); DisplayMessage(""); Console.WriteLine(ConsoleUtil.Center("Add A Firearm", WINDOW_WIDTH)); DisplayMessage(""); DisplayPromptMessage("Enter the firearm ID: "); firearm.ID = ConsoleUtil.ValidateIntegerResponse("Please enter the firearm ID: ", Console.ReadLine()); Console.WriteLine(""); DisplayPromptMessage("Enter the firearm name: "); firearm.Name = Console.ReadLine(); Console.WriteLine(""); DisplayPromptMessage("Enter the manufacturer: "); firearm.Manufacturer = Console.ReadLine(); Console.WriteLine(""); DisplayPromptMessage("Enter the firearm type: "); firearm.FirearmType = Console.ReadLine(); Console.WriteLine(""); DisplayPromptMessage("Enter the caliber/guage: "); firearm.AmmoType = Console.ReadLine(); Console.WriteLine(""); DisplayPromptMessage("Enter the barrel length: "); firearm.BarrelLength = ConsoleUtil.ValidateIntegerResponse("Please enter the barrel length: ", Console.ReadLine()); Console.WriteLine(""); return(firearm); }
public static Firearm UpdateFirearm(Firearm firearm) { string userResponse = ""; DisplayReset(); DisplayMessage(""); Console.WriteLine(ConsoleUtil.Center("Edit A Firearm", WINDOW_WIDTH)); DisplayMessage(""); DisplayMessage(String.Format("Current Name: {0}", firearm.Name)); DisplayPromptMessage("Enter a new name or just press Enter to keep the current name: "); userResponse = Console.ReadLine(); if (userResponse != "") { firearm.Name = userResponse; } DisplayMessage(""); DisplayMessage(String.Format("Current Manufacturer: {0}", firearm.Manufacturer)); DisplayPromptMessage("Enter a new manufacturer or just press Enter to keep the current manufacturer: "); userResponse = Console.ReadLine(); if (userResponse != "") { firearm.Manufacturer = userResponse; } DisplayMessage(""); DisplayMessage(String.Format("Current Type: {0}", firearm.FirearmType)); DisplayPromptMessage("Enter a new type or just press Enter to keep the current type: "); userResponse = Console.ReadLine(); if (userResponse != "") { firearm.FirearmType = userResponse; } DisplayMessage(""); DisplayMessage(String.Format("Current Caliber/Guage: {0}", firearm.AmmoType)); DisplayPromptMessage("Enter a new caliber/guage or just press Enter to keep the current caliber/guage: "); userResponse = Console.ReadLine(); if (userResponse != "") { firearm.AmmoType = userResponse; } DisplayMessage(""); DisplayMessage(String.Format("Current Barrel Length in cm: {0}", firearm.BarrelLength)); DisplayPromptMessage("Enter a new barrel length or just press Enter to keep the current barrel length: "); userResponse = Console.ReadLine(); if (userResponse != "") { firearm.BarrelLength = ConsoleUtil.ValidateIntegerResponse("Please enter the barrel length in cm.", userResponse); } DisplayMessage(""); DisplayContinuePrompt(); return(firearm); }