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