// 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));
}
