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