public IHttpActionResult PutEmployeedb([FromBody] int id, Employeedb employeedb)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Entry(employeedb).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeedbExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostEmployeedb(Employeedb employeedb)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Employeedbs.Add(employeedb);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = employeedb.Id }, employeedb));
}
public IHttpActionResult GetEmployeedb(int id)
{
Employeedb employeedb = db.Employeedbs.Find(id);
if (employeedb == null)
{
return(NotFound());
}
User user = db.Users.First();
return(Ok(user));
}
public IHttpActionResult DeleteEmployeedb(int id)
{
Employeedb employeedb = db.Employeedbs.Find(id);
if (employeedb == null)
{
return(NotFound());
}
db.Employeedbs.Remove(employeedb);
db.SaveChanges();
return(Ok(employeedb));
}
public async Task <int> UpdateInsertEmployeeDetails(Employee employee)
{
Employeedb empDBObj = new Employeedb();
int exeResult = 0;
try
{
exeResult = await empDBObj.Execute(employee);
}
catch (Exception sqlException)
{
throw sqlException;
}
return(exeResult);
}
public IList <Employee> GetAllEmployees()
{
Employeedb empDBObj = new Employeedb();
IList <Employee> lstofEmployees = null;
try
{
lstofEmployees = empDBObj.GetEmployees();
}
catch (Exception sqlException)
{
throw sqlException;
}
return(lstofEmployees);
}
