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