public IHttpActionResult PutMember(int id, Member member) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != member.MemberId) { return(BadRequest()); } db.Entry(member).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!MemberExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutProduct(int id, Product product) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != product.ID) { return(BadRequest()); } db.Entry(product).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ProductExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutVehicle(int id, Vehicle vehicle) { if (id != vehicle.Id) { return(BadRequest()); } db.Entry(vehicle).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!VehicleExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutEmployee(int id, Employee employee) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != employee.EID) { return(BadRequest()); } db.Entry(employee).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!EmployeeExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public JsonResult Postdata(Crud ob_c) { if (ob_c.id > 0) { Crud crud = ob.Cruds.Where(model => model.id == ob_c.id).FirstOrDefault <Crud>(); crud.name = ob_c.name; crud.email = ob_c.email; crud.address = ob_c.address; crud.country = ob_c.country; crud.pin = ob_c.pin; ob.SaveChanges(); return(Json(new { result = true, message = "Data Updated Successfully" }, JsonRequestBehavior.AllowGet)); } else { Crud obb = new Crud(); obb.name = ob_c.name; obb.email = ob_c.email; obb.address = ob_c.address; obb.country = ob_c.country; obb.pin = ob_c.pin; ob.Cruds.Add(ob_c); ob.SaveChanges(); return(Json(new { result = true, message = "Data Saved Successfully" }, JsonRequestBehavior.AllowGet)); } }
//insert customer public HttpResponseMessage Post(Customer customer) { if (ModelState.IsValid) { db.Customers.Add(customer); db.SaveChanges(); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, customer); response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = customer.Id })); return(response); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } }
public ActionResult Save(MVCCRUD.Models.Empployee emp) { bool status = false; if (ModelState.IsValid) { using (CRUDEntities dc = new CRUDEntities()) { if (emp.EmployeeID > 0) { //Edit var v = dc.Empployees.Where(a => a.EmployeeID == emp.EmployeeID).FirstOrDefault(); if (v != null) { v.FirstName = emp.FirstName; v.LastName = emp.LastName; v.EmailID = emp.EmailID; v.City = emp.City; v.Country = emp.Country; } } else { //save dc.Empployees.Add(emp); } dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult Nuevo(Tabla tabla) { try { if (ModelState.IsValid) { db.Tabla.Add(tabla); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tabla)); } catch (Exception e) { throw new Exception(e.Message); } }
public ActionResult DeleteEmployee(int id) { bool status = false; using (CRUDEntities dc = new CRUDEntities()) { var v = dc.Empployees.Where(a => a.EmployeeID == id).FirstOrDefault(); if (v != null) { dc.Empployees.Remove(v); dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult Agregar(Registro r) { if (!ModelState.IsValid) { return(View()); } try { using (var db = new CRUDEntities()) //para que no quede una conexion abrierta y consuma recursos { db.Registro.Add(r); db.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception ex) { ModelState.AddModelError("Error al agregar usuario", ex); return(View()); } }