Пример #1
0
 public void Configure(IServerRoutingTable serverRoutingTable)
 {
     using (var context = new IRunesContext())
     {
         context.Database.EnsureCreated();
     }
 }
Пример #2
0
 public bool CheckIfUserExists(string username)
 {
     using (var db = new IRunesContext())
     {
         return(db.Users.Any(u => u.Username == username));
     }
 }
Пример #3
0
        protected BaseController()
        {
            hasher = new HashingManager();

            db = new IRunesContext();

            ViewData = new Dictionary <string, object>();
        }
Пример #4
0
        public IEnumerable <Album> GetAllAlbums()
        {
            using (var db = new IRunesContext())
            {
                Album[] allAlbums = db.Albums.ToArray();

                return(allAlbums);
            }
        }
        public Track GetTrack(string trackId)
        {
            using (var db = new IRunesContext())
            {
                Track track = db.Tracks.Find(trackId);

                return(track);
            }
        }
Пример #6
0
        public Album GetAlbum(string albumId)
        {
            using (var db = new IRunesContext())
            {
                Album album = db.Albums.Find(albumId);

                return(album);
            }
        }
Пример #7
0
 public decimal GetPrice(string albumId)
 {
     using (var db = new IRunesContext())
     {
         return(db.Albums
                .FirstOrDefault(a => a.Id == albumId)
                .Tracks
                .Sum(t => t.Price) * 0.87M);
     }
 }
Пример #8
0
        public IEnumerable <Track> GetAlbumTracks(string albumId)
        {
            using (var db = new IRunesContext())
            {
                Track[] allTracks = db.Tracks
                                    .Where(t => t.AlbumId == albumId)
                                    .ToArray();

                return(allTracks);
            }
        }
Пример #9
0
        public User GetUser(LoginViewModel model)
        {
            using (var db = new IRunesContext())
            {
                User user = db.Users.FirstOrDefault(u =>
                                                    (u.Username == model.Username || u.Email == model.Username) &&
                                                    u.Password == model.Password);

                return(user);
            }
        }
Пример #10
0
        public static void Main(string[] args)
        {
            IServiceProvider provider = ConfigureService();

            IRunesContext context = provider.GetService <IRunesContext>();

            context.Database.Migrate();

            var controllerRouter = provider.GetService <IHandleable>();

            var server = new Server(8000, new ControllerRouter(provider), new ResourceRouter());

            MvcEngine.Run(server);
        }
Пример #11
0
        public void AddAlbum(AlbumViewModel model)
        {
            var album = new Album
            {
                Name  = model.Name,
                Cover = model.Cover
            };

            using (var db = new IRunesContext())
            {
                db.Albums.Add(album);
                db.SaveChanges();
            }
        }
Пример #12
0
        public void AddUser(RegisterViewModel model)
        {
            var user = new User
            {
                Username = model.Username,
                Password = model.Password,
                Email    = model.Email
            };

            using (var db = new IRunesContext())
            {
                db.Users.Add(user);
                db.SaveChanges();
            }
        }
        public void AddTrack(TrackViewModel model)
        {
            var track = new Track
            {
                Name    = model.Name,
                Link    = model.Link,
                Price   = decimal.Parse(model.Price),
                AlbumId = model.AlbumId
            };

            using (var db = new IRunesContext())
            {
                db.Tracks.Add(track);
                db.SaveChanges();
            }
        }
 public BaseController()
 {
     this.Context           = new IRunesContext();
     this.userCookieService = new UserCookieService();
     this.ViewBag           = new Dictionary <string, string>();
 }
Пример #15
0
 public TrackService(IRunesContext context)
 {
     this._context = context;
 }
Пример #16
0
 public BaseController()
     : base()
 {
     this.Context = new IRunesContext();
 }
Пример #17
0
 public AlbumService(IRunesContext context)
 {
     this._context = context;
 }
 public UsersService(IRunesContext context, IHashService hashService)
 {
     this.context     = context;
     this.hashService = hashService;
 }
Пример #19
0
 public UserService(IRunesContext context)
 {
     this._context = context;
 }