public IHttpActionResult GetById(int id)
{
employeeEntities db = new employeeEntities();
var result = db.employeedetails.Find(id);
return(Ok(result));
}
public IHttpActionResult Display()
{
employeeEntities db = new employeeEntities();
var result = db.employeedetails.ToList();
return(Ok(result));
}
public IHttpActionResult Create(employeedetail emp)
{
employeeEntities db = new employeeEntities();
var result = db.employeedetails.Add(emp);
db.SaveChanges();
return(Ok());
}
public List <EMPLOYEE> GetAll()
{
List <EMPLOYEE> lst = null;
using (employeeEntities DB = new employeeEntities())
{
lst = (from u in DB.EMPLOYEEs select u).ToList();
}
return(lst);
}
public ActionResult getEmployeeById()
{
var id = Int32.Parse(this.Request.QueryString["id"]);
using (var db = new employeeEntities())
{
var query = (from st in db.empleado
where st.id.Equals(id)
select st).ToList();
var employess = query;
return(Json(employess, JsonRequestBehavior.AllowGet));
}
}
public IHttpActionResult Get(int id)
{
employeedetail ed = new employeedetail();
using (var context = new employeeEntities())
{
ed = context.employeedetails.Where(s => s.id == id).FirstOrDefault();
}
if (ed == null)
{
return(new Custommsg("hh", Request, HttpStatusCode.NotFound));
// return Request.CreateResponse(HttpStatusCode.NotFound, id);
}
return(new Custommsg(ed.name, Request, HttpStatusCode.NotFound));
}
public ActionResult RegisterEmployee(RegisterEmployeeViewModel model)
{
if (!ModelState.IsValid)
{
var modelErrors = ModelState.AllErrors();
return(Json(modelErrors));
}
using (var db = new employeeEntities())
{
var row = db.Set <empleado>();
var emp = new empleado();
emp.nombres = model.nombres;
emp.apellidos = model.apellidos;
emp.cedula = model.cedula;
emp.telefono = model.telefono;
if (model.id.Equals(0))
{
row.Add(emp);
db.SaveChanges();
}
else
{
emp.id = model.id;
var cemp = db.empleado.Find(emp.id);
if (cemp != null)
{
db.Entry(cemp).CurrentValues.SetValues(emp);
db.SaveChanges();
}
}
}
return(Json(new {}));
}
public ActionResult FindEmployee()
{
var nombres = this.Request.QueryString["nombres"];
var apellidos = this.Request.QueryString["apellidos"];
var cedula = this.Request.QueryString["cedula"];
var telefono = this.Request.QueryString["telefono"];
using (var db = new employeeEntities())
{
var query = (from st in db.empleado
where ((st.nombres.Contains(nombres) || nombres == "") &&
(st.apellidos.Contains(apellidos) || apellidos == "") &&
(st.cedula.Equals(cedula) || cedula == "") &&
(st.telefono.Contains(telefono) || telefono == ""))
select st).ToList();
var employess = query;
var jsonObject = new
{
data = employess
};
return(Json(jsonObject, JsonRequestBehavior.AllowGet));
}
}
