public IHttpActionResult Record(int id)
{
rtn.status = 1;
try
{
rtn.data = db.tblEmployees.AsNoTracking()
.Where(w => w.EmployeeId == id)
.SingleOrDefault();
if (rtn.data == null)
{
rtn.status = 0;
rtn.error = new Errors
{
error_code = 404,
error = "Record Not Found."
};
return(Ok(rtn));
}
}
catch (Exception ex)
{
rtn.status = 0;
rtn.error = DemoFunctions.GetException(ex);
return(Ok(rtn));
}
return(Ok(rtn));
}
public IHttpActionResult Delete(int id)
{
rtn.status = 1;
try
{
tblEmployee tblEmployee = db.tblEmployees.Find(id);
if (tblEmployee == null)
{
rtn.status = 0;
rtn.error = new Errors
{
error_code = 404,
error = "Record Not Found."
};
return(Ok(rtn));
}
db.tblEmployees.Remove(tblEmployee);
db.SaveChanges();
}
catch (Exception ex)
{
rtn.status = 0;
rtn.error = DemoFunctions.GetException(ex);
return(Ok(rtn));
}
return(Ok(rtn));
}
public IHttpActionResult Post(tblEmployee tblEmployee)
{
rtn.status = 1;
if (!ModelState.IsValid)
{
rtn.status = 0;
rtn.error = new Errors
{
error_code = 400,
error = "Bad Request",
exception = ModelState
};
return(Ok(rtn));
}
try
{
db.tblEmployees.Add(tblEmployee);
db.SaveChanges();
rtn.data = tblEmployee;
}
catch (Exception ex)
{
rtn.status = 0;
rtn.error = DemoFunctions.GetException(ex);
return(Ok(rtn));
}
return(Ok(rtn));
}
public IHttpActionResult Put(int id, tblEmployee tblEmployee)
{
rtn.status = 1;
if (!ModelState.IsValid)
{
rtn.status = 0;
rtn.error = new Errors
{
error_code = 400,
error = "Bad Request",
exception = ModelState
};
return(Ok(rtn));
}
if (id != tblEmployee.EmployeeId)
{
rtn.status = 0;
rtn.error = new Errors
{
error_code = 400,
error = "Invalid Record",
};
return(Ok(rtn));
}
try
{
var old = db.tblEmployees
.Where(w => w.EmployeeId == id)
.SingleOrDefault();
if (old == null)
{
rtn.status = 0;
rtn.error = new Errors
{
error_code = 404,
error = "Record Not Found."
};
return(Ok(rtn));
}
db.Entry(old).CurrentValues.SetValues(tblEmployee);
db.SaveChanges();
}
catch (Exception ex)
{
rtn.status = 0;
rtn.error = DemoFunctions.GetException(ex);
return(Ok(rtn));
}
return(Ok(rtn));
}
public IHttpActionResult Records()
{
rtn.status = 1;
try
{
rtn.data = db.tblEmployees.AsNoTracking()
.ToList();
}
catch (Exception ex)
{
rtn.status = 0;
rtn.error = DemoFunctions.GetException(ex);
return(Ok(rtn));
}
return(Ok(rtn));
}