public List <Trader> GetAssignedUnAssignedUsers(int favOwner)
{
var traderFav = _context.Set <TraderFavorites>().FirstOrDefault(tf => tf.FavOwnerId == favOwner);
var res = (from t in _context.Traders
where t.TypeFlag == 1 && t.IsActive && t.ID != favOwner
select t).ToList();
if (traderFav != null)
{
foreach (var v in res)
{
_context.Entry(v).Collection(fl => fl.FavoriteList).Query()
.Where(a => a.TraderFavoriteId == traderFav.Id)
.Load();
}
}
return(res);
}
public List <TraderPrices> FindByTrader(int traderId)
{
DateTime today = DateTime.Now.Date;
return
(context.Set <TraderPrices>()
.Where(p => p.TraderID == traderId && p.priceDate >= today)
.Select(p => p)
.ToList());
}
public BaseRepo()
{
db = new GoldStreamerContext();
table = db.Set <T>();
}
public BasketPrices FindByBasketId(int basketId)
{
var basketPrices = _context.Set <BasketPrices>()
.SingleOrDefault(x => x.BasketID == basketId &&
x.IsCurrent &&
x.PriceDate.Year == DateTime.Now.Year &&
x.PriceDate.Month == DateTime.Now.Month &&
x.PriceDate.Day == DateTime.Now.Day);
return(basketPrices);
}
public List <RolePermission> GetAllRolePermisions()
{
return(_context.Set <RolePermission>().ToList());
}
public IEnumerable <Prices> GetAllPrices(int traderId, bool fromFavScreen = false)
{
List <Trader> traderList;
if (fromFavScreen == false)
{
traderList = _context.Set <Trader>().Where(x => x.TypeFlag == 1 && x.IsActive).OrderBy(x => x.SortOrder).ToList();
}
else
{
TraderFavorites traderFav = _context.Set <TraderFavorites>().FirstOrDefault(tf => tf.FavOwnerId == traderId);
traderList = (_context.Traders.Join(_context.FavorateList, trd => trd.ID, fav => fav.SuperTraderId,
(trd, fav) => new { trd, fav })
.Where(@t => @t.fav.TraderFavoriteId == traderFav.Id && @t.trd.IsActive)
.Select(@t => @t.trd)).ToList();
}
return(GetTraderAllPrice(traderId, traderList));
}
public List <NewsMainCategory> GetNewsMainCatetoryList(string searchText)
{
return(_context.Set <NewsMainCategory>()
.Where(b => b.MainCategoryName.Contains(searchText) || (b.MainCategoryOrder.ToString().Contains(searchText)) || string.IsNullOrEmpty(searchText)).ToList());
}
public List <Feedback> GetAll()
{
return(_context.Set <Feedback>().ToList());
}
public List <Basket> GetAllBaskerts()
{
return(_context.Set <Basket>().Where(b => b.IsDeleted == false).ToList());
}
public List <News> GetBySubCategory(int?subCategoryId)
{
if (subCategoryId == null)
{
return(_context.Set <News>().OrderByDescending(n => n.Date).ToList());
}
return(_context.Set <News>().Where(n => n.CategoryId == subCategoryId).OrderByDescending(n => n.Date).ToList());
}
public Trader FindTraderById(int id)
{
return(_context.Set <Trader>().AsNoTracking().SingleOrDefault(x => x.ID == id));
}
//public void DeleteAll()
//{
// _context.Set<Question>().RemoveRange(GetAll());
//}
public List <Question> GetAll()
{
// return _context.Set<QuestionGroup>().Select(q => q.Questions).Any().ToList();
return(_context.Set <Question>().ToList());
}
public bool HasFavorite(int favoriteOwner)
{
var fav = _context.Set <TraderFavorites>().FirstOrDefault(tf => tf.FavOwnerId == favoriteOwner);
return(fav != null);
}
public void DeleteBasketUsers(int basketId)
{
_context.Set <BasketTraders>().RemoveRange(GetBasketUsers(basketId));
}
public BaseRepo(GoldStreamerContext db)
{
this.db = db;
table = db.Set <T>();
}
public virtual IEnumerable <T> Search(Expression <Func <T, bool> > predicate)
{
return(db.Set <T>().Where(predicate));
}
public List <NewsCategory> GetByMainCategory(int mainCategory)
{
return(_context.Set <NewsCategory>().Where(c => c.MainCategoryId == mainCategory).ToList());
}
public List <Users> GetByTraderId(int TraderId)
{
return(_context.Set <Users>().Where(x => x.TraderId == TraderId).ToList());
}
public List <QuestionGroup> GetQuestionGroupList(string searchText)
{
return(_context.Set <QuestionGroup>()
.Where(b => b.GroupName.Contains(searchText) || (b.GroupOrder.ToString().Contains(searchText)) || string.IsNullOrEmpty(searchText)).ToList());
}
public List <TraderPricesChart> getALLPrices()
{
return(_context.Set <TraderPricesChart>().Include("Trader").ToList());
}
public List <Subscribe> GetAllSubscribes()
{
return(_context.Set <Subscribe>().Where(b => b.IsSubscribe == true).ToList());
}
