private static void DisplayAllEmployees()
{
using (var db = new SofturaCFContext())
{
foreach (var item in db.Employees)
{
Console.WriteLine(item.Eid + " " + item.Ename + " " + item.Dob + " " + item.Phone + " " + item.Salary + " " + item.Department);
}
}
}
public static void AddEmployeeDetails(Employee employee)
{
using (var db = new SofturaCFContext())
{
AcceptDetails();
db.Employees.Add(employee);
db.SaveChanges();
Console.WriteLine("Records added successfully");
}
}
public static Employee GetEmployeeId()
{
using (var db = new SofturaCFContext())
{
Console.WriteLine("Enter employee Id ");
int id = Convert.ToInt32(Console.ReadLine());
employee = db.Employees.Find(id);
return(employee);
}
}
private static void UpdateEmployeeDetails()
{
using (var db = new SofturaCFContext())
{
employee = GetEmployeeId();
Console.WriteLine(employee.ToString());
employee = AcceptDetails();
db.Entry(employee).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
Console.WriteLine("Records of this employee is updated sucessfullyy");
}
}
private static void DisplayEmployeeById()
{
using (var db = new SofturaCFContext())
{
employee = GetEmployeeId();
if (employee == null)
{
Console.WriteLine("No such Employees");
}
else
{
Console.WriteLine(employee);
}
}
}
private static void DeleteEmployeeById()
{
using (var db = new SofturaCFContext())
{
employee = GetEmployeeId();
if (employee == null)
{
Console.WriteLine("No such Employees");
}
else
{
db.Employees.Remove(employee);
db.SaveChanges();
Console.WriteLine("Employee Records Deleted successfullyy");
}
}
}
