// <summary> /// Edit equipment price /// </summary> public void EditEquipment() { using (var db = new MyPurcaseContext()) { var allEquip = db.MyPurchases.ToList(); foreach (var equip in allEquip) { Console.WriteLine($"{equip.Id} - {equip.Name}"); } // Get Id of equipment for editing int equipId = Add.ParseInt("ID-number of equip for editing"); var equipForEdit = db.MyPurchases.FirstOrDefault(id => id.Id == equipId); if (equipForEdit != null) { int newEquipPrice = Add.ParseInt("new equip price"); equipForEdit.AproxPrice = newEquipPrice; db.MyPurchases.Update(equipForEdit); } else { Console.WriteLine("Your entered wrong value"); } db.SaveChanges(); } }
// <summary> /// Show all equipment /// </summary> public void ShowEquipment() { ShowActivityEquip(MyPurchase.KindOfActivity.Running); ShowActivityEquip(MyPurchase.KindOfActivity.Bike); ShowActivityEquip(MyPurchase.KindOfActivity.Swimming); ShowActivityEquip(MyPurchase.KindOfActivity.Tourism); void ShowActivityEquip(MyPurchase.KindOfActivity kindOfActivity) { using (var db = new MyPurcaseContext()) { var allEquip = db.MyPurchases .OrderBy(p => p.Priority) .Where(n => n.Activity == kindOfActivity) .ToList(); Console.WriteLine($"{kindOfActivity}"); Console.WriteLine("__________________"); foreach (var equip in allEquip) { Console.WriteLine($"{equip.Name} - {equip.AproxPrice}uah - {equip.Priority}"); } Console.WriteLine(); } } }
// <summary> /// Add new equipment /// </summary> public void AddEquipment(MyPurchase myPurchase) { // get equipment name Console.WriteLine("Enter new equipment:"); string name = Console.ReadLine(); if (string.IsNullOrEmpty(name)) { throw new ArgumentNullException("Name can't be empty", nameof(name)); } // get equipment approximate price int aproxPrice = ParseInt("approximate price"); // get equipment kind of activity for MyPurchase.KindOfActivity activity; Console.WriteLine("Enter kind of activity: 1) Running 2) Bike 3) Swimming 4) Tourism"); string kindOfActivity = Console.ReadLine(); if (!Enum.TryParse(kindOfActivity, out activity)) { Console.WriteLine("It is not correct data. Try again"); } else { activity = (MyPurchase.KindOfActivity)Enum.Parse(typeof(MyPurchase.KindOfActivity), kindOfActivity, ignoreCase: true); } // get equipment priority int priority = ParseInt("priority"); using (var db = new MyPurcaseContext()) { var newEquipment = new MyPurchase() { Name = name, AproxPrice = aproxPrice, Activity = activity, Priority = priority }; db.MyPurchases.Add(newEquipment); db.SaveChanges(); } }
// <summary> /// Remove equipment /// </summary> public void RemoveEquipment() { using (var db = new MyPurcaseContext()) { var allEquip = db.MyPurchases.ToList(); foreach (var equip in allEquip) { Console.WriteLine($"{equip.Id} - {equip.Name}"); } // Get Id of equipment for removing int equipId = Add.ParseInt("ID-number of equip for removing"); var equipForRemove = db.MyPurchases.FirstOrDefault(id => id.Id == equipId); if (equipForRemove != null) { db.MyPurchases.Remove(equipForRemove); } else { Console.WriteLine("Your entered wrong value"); } db.SaveChanges(); } }