private void EmployeeCudMenu()
{
int? choice = MenuUtils.GetIntChoice(MenuUtils.CudMenu(), 1, 4);
switch (choice)
{
case 1:
using (var db = new EmployeeContext())
{
db.Employees.Add(MenuUtils.BuildEmployeeWithService(db));
db.SaveChanges();
}
break;
case 2:
PrintFromDb<Employee>((EmployeeContext db) =>
{
return db.Employees.AsNoTracking().ToList();
});
using (var db = new EmployeeContext())
{
Employee empToUpdate = null;
do
{
empToUpdate = db.Employees.Find(MenuUtils.GetIntChoice("Select employee to update by id", 1, int.MaxValue));
} while (empToUpdate == null);
Employee newValues = MenuUtils.BuildEmployeeWithService(db);
newValues.EmployeeId = empToUpdate.EmployeeId;
db.Entry(empToUpdate).CurrentValues.SetValues(newValues);
db.SaveChanges();
}
break;
case 3:
PrintFromDb<Employee>((EmployeeContext db) =>
{
return db.Employees.AsNoTracking().ToList();
});
using (var db = new EmployeeContext())
{
Employee empToDelete = null;
do
{
empToDelete = db.Employees.Find(MenuUtils.GetIntChoice("Select employee to delete by id", 1, int.MaxValue));
} while (empToDelete == null);
db.Entry(empToDelete).State = EntityState.Deleted;
db.SaveChanges();
}
break;
case 4:
EmployeeMenu();
break;
default:
break;
}
}
public void MainMenu()
{
int?subChoice = null;
do
{
int?choice = MenuUtils.GetIntChoice(MenuUtils.BaseChoiceMenu(), 1, 2);
switch (choice)
{
case 1:
subChoice = MenuUtils.GetIntChoice(MenuUtils.CrudMenuFor("employee"), 1, 5);
switch (subChoice)
{
case 1:
using (var db = new EmployeeContext())
{
Employee employee = MenuUtils.BuildEmployeeWithService();
db.Employees.Add(employee);
db.SaveChanges();
}
break;
case 2:
using (var db = new EmployeeContext())
{
foreach (var item in db.Employees.Include(x => x.Department).ToList())
{
Console.WriteLine(item);
}
}
break;
case 3:
using (var db = new EmployeeContext())
{
string firstname = MenuUtils.GetString("Firstname");
string lastname = MenuUtils.GetString("Lastname");
foreach (var item in db.Employees.Where(x => x.Firstname.Contains(firstname) && x.Lastname.Contains(lastname)).Include(x => x.Department).ToList())
{
Console.WriteLine(item);
}
}
break;
case 4:
int id = MenuUtils.GetIntChoice("Choose an id", 0, int.MaxValue).Value;
using (var db = new EmployeeContext())
{
Employee employee = new Employee()
{
EmployeeId = id
};
db.Employees.Attach(employee);
db.Employees.Remove(employee);
db.SaveChanges();
}
break;
case 5:
int idUpdate = MenuUtils.GetIntChoice("Choose an id", 0, int.MaxValue).Value;
Employee empToUpdate = MenuUtils.BuildEmployee();
using (var db = new EmployeeContext())
{
Employee empUpdate = db.Employees.Find(idUpdate);
db.Employees.Attach(empUpdate);
empUpdate.City = empToUpdate.City;
empUpdate.DateOfBirth = empToUpdate.DateOfBirth;
empUpdate.Firstname = empToUpdate.Firstname;
empUpdate.Lastname = empToUpdate.Lastname;
empUpdate.Salary = empToUpdate.Salary;
empUpdate.Function = empToUpdate.Function;
db.Entry(empUpdate).State = EntityState.Modified;
db.SaveChanges();
}
break;
default:
break;
}
break;
case 2:
subChoice = MenuUtils.GetIntChoice(MenuUtils.CrudMenuFor("service"), 1, 5);
switch (subChoice)
{
case 1:
using (var db = new EmployeeContext())
{
db.Services.Add(MenuUtils.BuildService());
db.SaveChanges();
}
break;
case 2:
using (var db = new EmployeeContext())
{
foreach (var item in db.Services.ToList())
{
Console.WriteLine(item);
}
}
break;
case 3:
string name = MenuUtils.GetString("Name");
using (var db = new EmployeeContext())
{
foreach (var item in db.Services.Where(x => x.Name.Contains(name)).ToList())
{
Console.WriteLine(item);
}
}
break;
case 4:
int id = MenuUtils.GetIntChoice("Choose an id", 0, int.MaxValue).Value;
using (var db = new EmployeeContext())
{
Service service = new Service()
{
ServiceId = id
};
db.Services.Attach(service);
db.Services.Remove(service);
foreach (var item in db.Employees.Include(x => x.Department).Where(x => x.Department.ServiceId == id))
{
db.Employees.Attach(item);
item.Department = new Service()
{
Name = "changed"
};
db.Entry(item).State = EntityState.Modified;
}
try
{
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
Console.WriteLine(e);
}
}
break;
case 5:
int idUpdate = MenuUtils.GetIntChoice("Choose an id", 0, int.MaxValue).Value;
Service servToUpdate = MenuUtils.BuildService();
using (var db = new EmployeeContext())
{
Service servUpdate = db.Services.Find(idUpdate);
db.Services.Attach(servUpdate);
servUpdate.Name = servToUpdate.Name;
db.Entry(servUpdate).State = EntityState.Modified;
db.SaveChanges();
}
break;
default:
break;
}
break;
default:
break;
}
} while (!MenuUtils.GetStringChoice("y to quit else n", "y", "n").Equals("y"));
}