public HttpResponseMessage Put(int id, [FromBody] EMPLEADO user)
{
try
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
var entity = entities.EMPLEADOes.FirstOrDefault(e => e.idEmpleado == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Empleado con Cedula: " + id.ToString() + ", no encontrado."));
}
else
{
entity.Nombre = user.Nombre;
entity.idEmpleado = user.idEmpleado;
entity.Username = user.Username;
entity.Password = user.Password;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Put(int id, [FromBody] CLIENTE user)
{
try
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
var entity = entities.CLIENTEs.FirstOrDefault(e => e.Cedula == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Usuario con Cedula: " + id.ToString() + ", no encontrado."));
}
else
{
entity.Nombre = user.Nombre;
entity.pApellido = user.pApellido;
entity.sApellido = user.sApellido;
entity.Nacimiento = user.Nacimiento;
entity.Username = user.Username;
entity.Password = user.Password;
entity.Cedula = user.Cedula;
entity.Direccion = user.Direccion;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Delete(int id)
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
try
{
entities.Configuration.LazyLoadingEnabled = false;
var entity = entities.CLIENTEs.FirstOrDefault(e => e.Cedula == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Usuario con Cedula: " + id + " no encontrado."));
}
else
{
entities.CLIENTEs.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
}
public IEnumerable <PRODUCTOXSUCURSAL> ProductosxSucursal([FromUri] int id)
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
return(entities.PRODUCTOXSUCURSALs.ToList().Where(e => e.idSucursal == id));
}
}
public IEnumerable <EMPLEADO> getAll()
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
return(entities.EMPLEADOes.ToList());
}
}
public IEnumerable <DIRECCIONE> getAll()
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
return(entities.DIRECCIONES.ToList());
}
}
public IEnumerable <SUCURSAL> getDistritos([FromUri] int empresa)
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
return(entities.SUCURSALs.ToList().Where(e => e.idEmpresa == empresa));
}
}
public IEnumerable <PADECIMIENTO> getAll()
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
return(entities.PADECIMIENTOS.ToList());
}
}
public IEnumerable <DISTRITO> getDistritos([FromUri] int canton)
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
return(entities.DISTRITOes.ToList().Where(e => e.idCanton == canton));
}
}
public IEnumerable <PADECIMIENTO> getPadecimientosbyId([FromUri] int id)
{
try
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
var entity = entities.PADECIMIENTOS.ToList().Where(e => e.idUsuario == id);
return(entity);
}
}
catch (Exception ex)
{
return(null);
}
}
public HttpResponseMessage getUserByUsername([FromUri] string username)
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
var entity = entities.CLIENTEs.FirstOrDefault(e => e.Username == username);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Usuario con Username: "******" no encontrado."));
}
}
}
public HttpResponseMessage getUserById(int id)
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
var entity = entities.CLIENTEs.FirstOrDefault(e => e.Cedula == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Usuario con Cedula: " + id + " no encontrado."));
}
}
}
public IEnumerable <PEDIDO> getPedidosbyId([FromUri] int id)
{
try
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
var entity = entities.PEDIDOS.ToList().Where(e => e.idCliente == id);
return(entity);
}
}
catch (Exception ex)
{
return(null);
}
}
public HttpResponseMessage regPadecimiento([FromBody] PADECIMIENTO padecimiento)
{
try
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
entities.PADECIMIENTOS.Add(padecimiento);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, padecimiento);
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage regCliente([FromBody] CLIENTE cliente)
{
try
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
entities.CLIENTEs.Add(cliente);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, cliente);
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Post([FromBody] EMPLEADO empleado)
{
try
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
entities.EMPLEADOes.Add(empleado);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, empleado);
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage regDireccion([FromBody] DIRECCIONE direccion)
{
try
{
using (GasStationPharmacyDBEntities entities = new GasStationPharmacyDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
entities.DIRECCIONES.Add(direccion);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, direccion);
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
