private static void Delete(PhoneContext context) { Console.Clear(); Console.WriteLine("Enter id to delete"); int id = Convert.ToInt32(Console.ReadLine()); var phone = context.Phones.Where(p => p.PhoneID == id).First(); context.Phones.Remove(phone); context.SaveChanges(); }
private static void Insert(PhoneContext context) { Console.Clear(); Console.WriteLine("Insert in database"); Console.WriteLine("Phone manufacturer (enter ID)"); var manufacturers = (from m in context.Manufacturers select m).ToList(); foreach (var item in manufacturers) { Console.WriteLine(item.ManufacturerID + ": " + item.ManufacturerName); } int manufacturerID = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter phone model"); string phoneModel = Console.ReadLine(); Console.WriteLine("Phone operating system (enter ID)"); var oss = (from o in context.OperatingSystems select o); foreach (var item in oss) { Console.WriteLine(item.OperatingSystemID + ": " + item.OperatingSystemName); } int osID = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter phone release date"); string date = Console.ReadLine(); List <Models.OperatingSystem> operatingSystems = new List <Models.OperatingSystem>(); operatingSystems.Add(context.OperatingSystems .Where(o => o.OperatingSystemID == osID) .Select(o => o).First()); Models.Manufacturer manufacturer = context.Manufacturers .Where(m => m.ManufacturerID == manufacturerID) .Select(m => m).First(); var p = new Models.Phone { Manufacturer = manufacturer, PhoneModel = phoneModel, Date = date, OperatingSystems = operatingSystems }; context.Phones.Add(p); context.SaveChanges(); }
private static void Update(PhoneContext context) { Console.Clear(); Console.WriteLine("Enter id to update"); int id = Convert.ToInt32(Console.ReadLine()); var phone = context.Phones.Where(p => p.PhoneID == id).First(); var manufacturers = (from m in context.Manufacturers select m).ToList(); foreach (var item in manufacturers) { Console.WriteLine(item.ManufacturerID + ": " + item.ManufacturerName); } Console.WriteLine("Enter Manufacturer id (Press enter to skip)"); string manufacturerID = Console.ReadLine(); if (!string.IsNullOrEmpty(manufacturerID)) { int mId = Convert.ToInt32(manufacturerID); // modify manufacturer phone.Manufacturer = context.Manufacturers .Where(m => m.ManufacturerID == mId) .Select(m => m).First(); } Console.WriteLine("Enter phone model (Press enter to skip)"); string model = Console.ReadLine(); if (!string.IsNullOrEmpty(model)) { // modify model name phone.PhoneModel = model; } Console.WriteLine("Enter release date (Press enter to skip)"); string date = Console.ReadLine(); if (!string.IsNullOrEmpty(date)) { // modify model date phone.Date = date; } Console.WriteLine("Enter operating system id (Press enter to skip)"); var oss = (from o in context.OperatingSystems select o); foreach (var item in oss) { Console.WriteLine(item.OperatingSystemID + ": " + item.OperatingSystemName); } string osId = Console.ReadLine(); if (!string.IsNullOrEmpty(osId)) { int oid = Convert.ToInt32(osId); // modify os List <Models.OperatingSystem> operatingSystems = new List <Models.OperatingSystem>(); operatingSystems.Add(context.OperatingSystems .Where(o => o.OperatingSystemID == oid) .Select(o => o).First()); } context.SaveChanges(); }