public IHttpActionResult PutEmployee(int id, Employee employee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != employee.Id)
{
return(BadRequest());
}
db.Entry(employee).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public HttpResponseMessage DeleteUser(String email)
{
try
{
using (employeeDBEntities entities = new employeeDBEntities())
{
var entity = entities.tblEmployees.FirstOrDefault(e => e.Email == email);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Employee with Id = " + email + " not found to delete"));
}
else
{
var entityInfo = entity.tblEmployeeInfoes.FirstOrDefault(u => u.Id == entity.Id);
entities.tblEmployeeInfoes.Remove(entityInfo);
entities.tblEmployees.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage UpdateUser([FromBody] Employee employee)
{
try
{
using (var entities = new employeeDBEntities())
{
var entity = entities.tblEmployees.FirstOrDefault(u => u.Email == employee.Email);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest,
"User with email" + employee.Email.ToString() + " not present."));
}
else
{
var entityInfo = entity.tblEmployeeInfoes.FirstOrDefault(u => u.Id == entity.Id);
entityInfo.FirstName = employee.FirstName;
entityInfo.LastName = employee.LastName;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, employee));
}
}
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e));
}
}
public ActionResult SaveData(EmployeeInfo employeeInfo)
{
if (ModelState.IsValid)
{
db.EmployeeInfoes.Add(employeeInfo);
db.SaveChanges();
return(Json(new { data = employeeInfo }, JsonRequestBehavior.AllowGet));
}
return(View(employeeInfo));
}
public HttpResponseMessage AddNewUser([FromBody] Employee employee)
{
try
{
using (var entities = new employeeDBEntities())
{
var entity = entities.tblEmployees.FirstOrDefault(u => u.Email == employee.Email);
if (entity != null)
{
return(Request.CreateErrorResponse(HttpStatusCode.Forbidden,
"User with email" + employee.Email.ToString() + " already present."));
}
else
{
tblEmployee employeeObj = new tblEmployee
{
Email = employee.Email
};
tblEmployeeInfo employeeInfo = new tblEmployeeInfo
{
FirstName = employee.FirstName,
LastName = employee.LastName,
};
employeeInfo.tblEmployee = employeeObj;
entities.tblEmployees.Add(employeeObj);
entities.tblEmployeeInfoes.Add(employeeInfo);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, employee));
}
}
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e));
}
}
