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();
}
}
