public void SaveWCFERESTmployee(WCFEmployee Employee)
{
WCFEmployee_CFEXDB_DBContext wcfctxt = new WCFEmployee_CFEXDB_DBContext();
wcfctxt.WCFEmployees.Add(Employee);
wcfctxt.SaveChanges();
//throw new NotImplementedException();
}
public string UpdateWCFRESTEmployee(WCFEmployee Employee)
{
WCFEmployee_CFEXDB_DBContext wcfctxt = new WCFEmployee_CFEXDB_DBContext();
WCFEmployee toupdt = wcfctxt.WCFEmployees.Find(Employee.Id);
toupdt.Name = Employee.Name;
toupdt.Gender = Employee.Gender;
toupdt.DateOfBirth = Employee.DateOfBirth;
toupdt.EmployeeType = Employee.EmployeeType;
toupdt.AnnualSalary = Employee.AnnualSalary;
toupdt.HourlyPay = Employee.HourlyPay;
toupdt.HoursWorked = Employee.HoursWorked;
wcfctxt.SaveChanges();
return(toupdt.Name + " details Updated successfully");
//throw new NotImplementedException();
}
public List <WCFEmployee> ALLWCFRESTEmployee()
{
WCFEmployee_CFEXDB_DBContext wcfctxt = new WCFEmployee_CFEXDB_DBContext();
List <WCFEmployee> empset = wcfctxt.WCFEmployees.ToList();
//IEnumerable<WCFEmployee> empset=from es in wcfctxt.WCFEmployees.AsEnumerable()
// orderby es.Id
// select new WCFEmployee
// {
// Id = es.Id,
// Name = es.Name,
// Gender = es.Gender,
// DateOfBirth = es.DateOfBirth,
// EmployeeType = es.EmployeeType,
// AnnualSalary = es.AnnualSalary,
// HourlyPay = es.HourlyPay,
// HoursWorked = es.HoursWorked
// };
return(empset);
//throw new NotImplementedException();
}
//WCF Restfull service implementations
public WCFEmployee GetWCFRESTEmployee(int Id)
{
WCFEmployee_CFEXDB_DBContext wcfctxt = new WCFEmployee_CFEXDB_DBContext();
//WCFEmployee singleemp = from s in wcfctxt.WCFEmployees.AsQueryable() .Where(s => s.Id == Id)
// select new WCFEmployee
// {
// Id = s.Id,
// Name = s.Name,
// Gender = s.Gender,
// DateOfBirth = s.DateOfBirth,
// EmployeeType = s.EmployeeType,
// AnnualSalary = s.AnnualSalary,
// HourlyPay = s.HourlyPay,
// HoursWorked = s.HoursWorked
// };
WCFEmployee singleemp = wcfctxt.WCFEmployees.Find(Id);
return(singleemp);
//throw new NotImplementedException();
}
