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