public List <Basket> GetTraderBasketsPrice(int bigTraderId)
{
DateTime today = DateTime.Now.Date;
var data = (from q in _context.Basket
where q.BasketOwner == bigTraderId && q.IsDeleted == false
select q).ToList();
foreach (var v in data)
{
_context.Entry(v).Collection(b => b.BasketPrices).Query()
.Where(a => a.IsCurrent && a.PriceDate >= today)
.Load();
}
return(data);
}
public void ChangeActiveAssignment(Question question)
{
List <Question> lstQuestions = new List <Question>();
if (question.IsActive)
{
lstQuestions = _context.Set <Question>().Where(c => c.IsActive && c.ID != question.ID).ToList();
if (lstQuestions.Count() != 0)
{
foreach (Question b in lstQuestions)
{
b.IsActive = false;
_context.Entry(b).State = EntityState.Modified;
}
}
}
}
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 void Update(T obj)
{
db.Entry(obj).State = EntityState.Modified;
//table.Attach(obj);
}
public void UpdateQuestionGroup(QuestionGroup oldQuestionGroup)
{
_context.Entry(oldQuestionGroup).State = EntityState.Modified;
}
public void UpdateNewsCategory(NewsCategory oldNewsCategory)
{
_context.Entry(oldNewsCategory).State = EntityState.Modified;
}
