public string AddEmployee(Employee Emp)
 {
     if (Emp != null)
     {
         using (EMPDatabaseEntities dataContext = new EMPDatabaseEntities())
         {
             dataContext.Employees.Add(Emp);
             dataContext.SaveChanges();
             return("Employee Updated");
         }
     }
     else
     {
         return("Invalid Employee");
     }
 }
 public string DeleteEmployee(Employee emp)
 {
     if (emp != null)
     {
         using (EMPDatabaseEntities dataContext = new EMPDatabaseEntities())
         {
             int no           = Convert.ToInt32(emp.Id);
             var employeeList = dataContext.Employees.Where(x => x.Id == no).FirstOrDefault();
             dataContext.Employees.Remove(employeeList);
             dataContext.SaveChanges();
             return("Employee Deleted");
         }
     }
     else
     {
         return("Invalid Employee");
     }
 }
 public string UpdateEmployee(Employee emp)
 {
     if (emp != null)
     {
         using (EMPDatabaseEntities dataContext = new EMPDatabaseEntities())
         {
             int no           = Convert.ToInt32(emp.Id);
             var employeeList = dataContext.Employees.Where(x => x.Id == no).FirstOrDefault();
             employeeList.name      = emp.name;
             employeeList.mobile_no = emp.mobile_no;
             employeeList.email     = emp.email;
             dataContext.SaveChanges();
             return("Employee Updated");
         }
     }
     else
     {
         return("Invalid Employee");
     }
 }