public EntityRefSell GetByOrder(int OrderID)
        {
            var data = base.DataContext.RefSell.Where(p => p.FK_OrderID == OrderID);

            if (data.Count() == 1)
            {
                return(FactoryRefSell.Get(data.Single()));
            }
            else
            {
                return(null);
            }
        }
        public EntityRefSell GetRefFolio(int OrderID, string Folio)
        {
            var data = base.DataContext.RefSell.Where(p => p.FK_OrderID == OrderID && p.IDRefSell == Folio);

            if (data.Count() > 0)
            {
                return(FactoryRefSell.Get(data.First()));
            }
            else
            {
                return(null);
            }
        }
        public EntityRefSell Get(int Id)
        {
            var data = base.DataContext.RefSell.Where(p => p.PK_RefSellID == Id);

            if (data.Count() == 1)
            {
                return(FactoryRefSell.Get(data.Single()));
            }
            else
            {
                return(null);
            }
        }
 public List <EntityRefSell> GetByEmpoyeeDate(int UserID, DateTime date)
 {
     return(FactoryRefSell.GetList(base.DataContext.RefSell.Where(p => p.FK_EmployeeID == UserID && DbFunctions.TruncateTime(p.CreateDate) == date).OrderByDescending(o => o.CreateDate).ToList()));
 }
 public List <EntityRefSell> GetActives()
 {
     return(FactoryRefSell.GetList(base.DataContext.RefSell.Where(p => p.Status == true).ToList()));
 }
 public List <EntityRefSell> GetAll()
 {
     return(FactoryRefSell.GetList(base.DataContext.RefSell.ToList()));
 }