public IList <TitleRateDto> CreateRating(UserTitleRate userTitleRate)
        {
            Raw11Context _db = new Raw11Context(_connectionString);

            var queery = _db.RatingTable.FromSqlInterpolated($"select * from rate({userTitleRate.UserId},{userTitleRate.TConst},{userTitleRate.TitleIndividRating})");

            _db.SaveChanges();

            return(queery
                   .ToList());
        }
 public BookmarkingDataService(string connStr)
 {
     _db = new Raw11Context(connStr);
 }
Esempio n. 3
0
 public RatingDataService(string connStr)
 {
     _db = new Raw11Context(connStr);
 }
Esempio n. 4
0
 public SearchDataService(string connStr)
 {
     _db = new Raw11Context(connStr);
 }
Esempio n. 5
0
 public UsersDataService(string connStr)
 {
     _db = new Raw11Context(connStr);
 }
        public IList <UserTitleRate> GetRating(int userId)
        {
            Raw11Context _db = new Raw11Context(_connectionString);

            return(_db.UserTitleRates.Where(x => x.UserId == userId).ToList());
        }