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