public List <PedidoW> get()
{
using (gapharmaEntities1 db = new gapharmaEntities1())
{
var list = (from cd in db.CABECERA_DOCUMENTO
join c in db.CLIENTE
on cd.CLIENTE_ID equals c.CLIENTE_ID
join d in db.DESTINATARIO
on cd.DESTINATARIO_ID equals d.DESTINATARIO_ID
join est in db.ESTADO on cd.ESTADO_ID equals est.ESTADO_ID
join s in db.SERVICIO on cd.SERVICIO_ID equals s.SERVICIO_ID
select new gapharma_models.ViewModels.PedidoW
{
Cabecera_id = cd.CABECERA_DOCUMENTO_ID,
Fecha_emision = cd.FECHA_EMISION,
Fecha_envio = cd.FECHA_RETIRO,
Fecha_retiro = cd.FECHA_RETIRO,
Cliente = c.RAZONSOCIAL,
Destinatario = d.RAZON_SOCIAL,
Estado = est.TIPO_ESTADO,
Servicio = s.DESCRIPCION,
Empresa = d.RAZON_SOCIAL,
Cliente_id = cd.CLIENTE_ID,
Codigo_postal = d.CODIGO_POSTAL
}).AsQueryable();
return(list.ToList <PedidoW>());
}
}
public void save(PERSONA obj)
{
using (gapharmaEntities1 db = new gapharmaEntities1())
{
try
{
db.PERSONA.Add(obj);
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
}
public void save(DESTINATARIO obj)
{
using (gapharmaEntities1 db = new gapharmaEntities1()) {
db.DESTINATARIO.Add(obj);
db.SaveChanges();
}
}
public List <ZONAS> getByIdAll(long id)
{
using (gapharmaEntities1 db = new gapharmaEntities1()) {
return((from d in db.ZONAS
where d.CODIGO_POSTAL == id
select d).ToList <gapharma_models.ZONAS>());
}
}
public List <VEHICULO> getByIdAll(long id)
{
using (gapharmaEntities1 db = new gapharmaEntities1()) {
return((from d in db.VEHICULO
where d.ZONAS_ID == id
select d).ToList <gapharma_models.VEHICULO>());
}
}
public List <DESTINATARIO> getByIdAll(long id)
{
using (gapharmaEntities1 bd = new gapharmaEntities1()) {
return((from d in bd.DESTINATARIO
where d.CLIENTE_ID == id
select d).ToList <gapharma_models.DESTINATARIO>());
}
}
public void save(CABECERA_DOCUMENTO obj)
{
using (gapharmaEntities1 db = new gapharmaEntities1()) {
db.CABECERA_DOCUMENTO.Add(obj);
db.SaveChanges();
int id = obj.CABECERA_DOCUMENTO_ID;
foreach (var item in obj.detalle)
{
item.CABECERA_DOCUMENTO_ID = id;
db.DETALLE_DOCUMENTO.Add(item);
db.SaveChanges();
}
}
}
public List <ClienteW> get()
{
using (gapharmaEntities1 db = new gapharmaEntities1()) {
var list = (from c in db.CLIENTE
join e in db.ESTADO
on c.ESTADO_ID equals e.ESTADO_ID
join p in db.PERSONA
on c.PERSONA_ID equals p.PERSONA_ID
select new gapharma_models.ViewModels.ClienteW
{
Cliente_id = c.CLIENTE_ID,
Razon_social = c.RAZONSOCIAL,
Tipo_estado = e.TIPO_ESTADO,
Nombre = p.NOMBRE,
Apellido = p.APELLIDO,
Email = p.EMAIL,
Telefono_1 = p.TELEFONO_1
}
).AsQueryable();
return(list.ToList <gapharma_models.ViewModels.ClienteW>());
}
}
public List <TRANSPORTISTA> getByIdAll(long id)
{
using (gapharmaEntities1 db = new gapharmaEntities1()) {
return((List <gapharma_models.TRANSPORTISTA>)db.TRANSPORTISTA.ToList <gapharma_models.TRANSPORTISTA>().Where(p => p.VEHICULO_ID == id));
}
}
public List <PAQUETE> getAll()
{
using (gapharmaEntities1 db = new gapharmaEntities1()) {
return(db.PAQUETE.ToList());
}
}
public PERSONA getByid(long id)
{
using (gapharmaEntities1 db = new gapharmaEntities1()) {
return(db.PERSONA.Find(id));
}
}
public List <PERSONA> getAll()
{
using (gapharmaEntities1 db = new gapharmaEntities1()) {
return(db.PERSONA.ToList());
}
}
public List <SERVICIO> getAll()
{
using (gapharmaEntities1 db = new gapharmaEntities1()) {
return(db.SERVICIO.ToList <SERVICIO>());
}
}
