private static void Create() { try { using (var context = new AlifAcademyContext()) { Console.Write("Enter new comapny name:"); var companyName = Console.ReadLine(); Company comp = new Company() { CompanyName = companyName }; context.Company.Add(comp); var result = context.SaveChanges(); if (result > 0) { SuccessMessage("Add company"); } } } catch (Exception ex) { FailMessage(ex.Message); } finally { ConsoleReadWithPressKeyMessage(); } }
private static void Delete() { try { using (var context = new AlifAcademyContext()) { Read("update"); Console.WriteLine("Please select"); Console.Write("ID:"); var companyId = Convert.ToInt32(Console.ReadLine()); var company = context.Company.Find(companyId); if (company != null) { Console.Write("Are you sure? Y(yes)/N(no):"); var confirm = Console.ReadLine(); if (confirm.ToUpper() == "Y") { context.Company.Remove(company); } if (context.SaveChanges() > 0) { SuccessMessage("Company deleted!"); } else { FailMessage("Company not deleted!"); } } } } catch (Exception ex) { FailMessage(ex.Message); } finally { ConsoleReadWithPressKeyMessage(); } }
private static void Update() { try { using (var context = new AlifAcademyContext()) { Read("update"); Console.WriteLine("Please select"); Console.Write("ID:"); var companyId = Convert.ToInt32(Console.ReadLine()); var company = context.Company.Find(companyId); //SELECT * FROM COMPANY WHERE ID = companyId if (company != null) { Console.Write("New company name:"); var newCompanyName = Console.ReadLine(); company.CompanyName = newCompanyName; if (context.SaveChanges() > 0) { SuccessMessage("Company changed!"); } else { FailMessage("Company not changed!"); } } } } catch (Exception ex) { FailMessage(ex.Message); } finally { ConsoleReadWithPressKeyMessage(); } }