public static IEnumerable<Moneda> GetMonedas()
{
using (db_kissyEntities db = new db_kissyEntities())
{
return (from m in db.Moneda select m).ToList();
}
}
public static IEnumerable<TipoProducto> GetTipoProductos()
{
using (db_kissyEntities db = new db_kissyEntities())
{
return (from tp in db.TipoProducto select tp).ToList();
}
}
public static IEnumerable<Talles> GetTalles()
{
using (db_kissyEntities db = new db_kissyEntities())
{
return (from ta in db.Talles select ta).ToList();
}
}
public static IEnumerable<Temporada> GetTemporadas()
{
using (db_kissyEntities db = new db_kissyEntities())
{
return (from te in db.Temporada select te).ToList();
}
}
public static int Alta(Fotos foto)
{
try
{
using (db_kissyEntities db = new db_kissyEntities())
{
db.Fotos.Add(foto);
db.SaveChanges();
return foto.id_foto;
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Class: {0}, Property: {1}, Error: {2}",
validationErrors.Entry.Entity.GetType().FullName,
validationError.PropertyName,
validationError.ErrorMessage);
}
}
throw; // You can also choose to handle the exception here...
}
}
public static Talles GetTalle(int id)
{
using (db_kissyEntities db = new db_kissyEntities())
{
return db.Talles.Single(ta => ta.id_talle == id);
}
}
public static IEnumerable<Marcas> GetMarcas()
{
using (db_kissyEntities db = new db_kissyEntities())
{
return (from ma in db.Marcas select ma).ToList();
}
}
public static int ContarCantidadActivos(int idArticulo, string descripcion, int idTipoPrenda, int idTipoProducto, int idMarca, int idTemporada)
{
using (db_kissyEntities db = new db_kissyEntities())
{
return GetArticulosActivos(db, idArticulo, descripcion, idTipoPrenda, idTipoProducto, idMarca, idTemporada).Count();
}
}
public static Marcas GetMarca(int idMarca)
{
using (db_kissyEntities db = new db_kissyEntities())
{
return (from ma in db.Marcas select ma).Single(x => x.id_marca == idMarca);
}
}
public static IEnumerable<Colores> GetColores()
{
using (db_kissyEntities db = new db_kissyEntities())
{
return (from co in db.Colores select co).ToList();
}
}
public static IEnumerable<Categorias> GetCategorias()
{
using (db_kissyEntities db = new db_kissyEntities())
{
return (from ca in db.Categorias select ca).ToList();
}
}
public static Articulos GetArticuloById(int id)
{
using (db_kissyEntities db = new db_kissyEntities())
{
var q = db.Articulos.Include("Temporada").Include("Talles").Include("Marca").Include("TipoPrenda").Include("TipoProducto").Include("Moneda").Include("Fotos").Single(u => u.id_articulo == id);
return q;
}
}
public static Usuarios GetUsuarioByLogin(Usuarios usr)
{
using (db_kissyEntities db = new db_kissyEntities())
{
var u = from us in db.Usuarios
where us.email == usr.email
select us;
return u.ToList()[0];
}
}
public static IEnumerable<Articulos> ObtenerPagina(int paginaActual, int personasPorPagina, string sortColumns, int idArticulo, string descripcion, int idTipoPrenda, int idTipoProducto, int idMarca, int idTemporada)
{
using (db_kissyEntities db = new db_kissyEntities())
{
if (paginaActual < 1) paginaActual = 1;
IQueryable<Articulos> query = GetArticulos(db, idArticulo, descripcion, idTipoPrenda, idTipoProducto, idMarca, idTemporada);
return query.OrderUsingSortExpression(sortColumns)
.Skip((paginaActual - 1) * personasPorPagina)
.Take(personasPorPagina)
.ToList();
}
}
private static IQueryable<Articulos> GetArticulos(db_kissyEntities db, int idArticulo, string descripcion, int idTipoPrenda, int idTipoProducto, int idMarca, int idTemporada)
{
IQueryable<Articulos> query = from b in db.Articulos.Include("Temporada").Include("Talles").Include("Marca").Include("TipoPrenda").Include("TipoProducto").Include("Moneda").Include("Fotos")
where (idMarca == 0 || b.id_marca == idMarca)
&& b.descripcion.Contains(descripcion)
&& (idArticulo == 0 || b.id_articulo == idArticulo)
&& (idTemporada == 0 || b.id_temporada == idTemporada)
&& (idTipoPrenda == 0 || b.id_tipo_prenda == idTipoPrenda)
&& (idTipoProducto == 0 || b.id_tipo_producto == idTipoProducto)
select b;
return query;
}
