// POST: rest/upd_emp public ErrorResponse Post([FromBody] JSONEmployee json_employee) { if (!ModelState.IsValid || json_employee._id == null) { return(new ErrorResponse(ErrorNumber.CANNOT_INSERT_MISSING_FIELDS, "No records added")); } if (json_employee.ContainsExtra) { return(new ErrorResponse(ErrorNumber.CANNOT_INSERT_UNKNOWN_FIELDS, "Extra fields in json")); } //Employee employee = new Employee(json_employee); kenzanEntities ke = new kenzanEntities(); ke.Configuration.ProxyCreationEnabled = false; Employee emp = ke.Employees .Where(e => e.id == json_employee._id && e.bStatus == Status.ACTIVE) .FirstOrDefault <Employee>(); if (emp == null) { return(new ErrorResponse(ErrorNumber.CANNOT_UPDATE_NONEXISTENT_RECORD, "Nonexistant record")); } emp.dateOfBirth = json_employee.dateOfBirth.Value; emp.dateOfEmployment = json_employee.dateOfEmployment; emp.firstName = json_employee.firstName; emp.lastName = json_employee.lastName; emp.middleInitial = json_employee.middleInitial; emp.bStatus = json_employee.bStatus.Value; emp.username = json_employee.username; try { if (ke.SaveChanges() != 1) { return(new ErrorResponse(emp.id, ErrorNumber.UNKNOWN_ERROR, "Error updating record")); } else { return(new ErrorResponse()); } } catch (Exception e) { while (e.InnerException != null) { e = e.InnerException; } if (e.Message.Contains("Duplicate")) { return(new ErrorResponse(ErrorNumber.DUPLICATE_RECORD, e.Message)); } else { return(new ErrorResponse(ErrorNumber.CANNOT_INSERT_MISSING_FIELDS, e.Message)); } } }
// POST: rest/add_emp public ErrorResponse Post([FromBody] JSONEmployee json_employee) { ErrorResponse err; if (!ModelState.IsValid || json_employee._id != null) { return(new ErrorResponse(ErrorNumber.CANNOT_INSERT_MISSING_FIELDS, "No records added")); } if (json_employee.ContainsExtra) { return(new ErrorResponse(ErrorNumber.CANNOT_INSERT_UNKNOWN_FIELDS, "Extra fields in json")); } Employee employee = new Employee(json_employee); kenzanEntities ke = new kenzanEntities(); ke.Employees.Add(employee); try { if (ke.SaveChanges() == 0) { err = new ErrorResponse(ErrorNumber.UNKNOWN_ERROR, "No records added"); } else { err = new ErrorResponse(employee.id); } } catch (Exception e) { while (e.InnerException != null) { e = e.InnerException; } if (e.Message.Contains("Duplicate")) { err = new ErrorResponse(ErrorNumber.DUPLICATE_RECORD, e.Message); } else { err = new ErrorResponse(ErrorNumber.CANNOT_INSERT_MISSING_FIELDS, e.Message); } } return(err); }
public OkResult Add(JSONEmployee postedEmployee) { using (var context = new Ruby_EmergencyContext()) { Employee newEmployee = new Employee(); newEmployee.Fname = postedEmployee.fname; newEmployee.Lname = postedEmployee.lname; newEmployee.Email = postedEmployee.email; newEmployee.Building = postedEmployee.building; newEmployee.Floor = postedEmployee.floor; newEmployee.Room = postedEmployee.room; newEmployee.Phone = postedEmployee.phone; //status //warden? context.Add(newEmployee); context.SaveChangesAsync(); } return(Ok()); }
public JsonResult Get() { List <JSONEmployee> result = new List <JSONEmployee>(); using (var context = new Ruby_EmergencyContext()) { foreach (Employee person in context.Employee) { JSONEmployee newEmployee = new JSONEmployee(); newEmployee.fname = person.Fname; newEmployee.lname = person.Lname; newEmployee.email = person.Email; newEmployee.building = person.Building; newEmployee.floor = person.Floor; newEmployee.room = person.Room; newEmployee.phone = person.Phone; result.Add(newEmployee); } } return(Json(result)); }