protected void Application_Start() { AreaRegistration.RegisterAllAreas(); RegisterGlobalFilters(GlobalFilters.Filters); RegisterRoutes(RouteTable.Routes); Database.SetInitializer(new MigrateDatabaseToLatestVersion <YakinikuClubDbContext, YakinikuClubDbInitializer>()); using (var ctx = new YakinikuClubDbContext()) { ctx.Database.Initialize(true); } }
public static Member GetMemberInfo(this Controller controller) { if (!controller.Request.IsAuthenticated) { return(null); } using (var ctx = new YakinikuClubDbContext()) { var repos = new MemberRepository(ctx); var model = repos.Get(x => x.NickName == controller.User.Identity.Name); return(model); } }
public PlanViewModel() { using (var ctx = new YakinikuClubDbContext()) { var repos = new ClubActivityRepository(ctx); ClubActivities = repos.GetAll() .Include(x => x.Shop) .Where(x => x.StartDate >= DateTime.Now) .OrderByDescending(x => x.Times) .ToList(); } }
public MembershipCreateStatus Register(RegisterModel model) { MembershipCreateStatus createStatus; Membership.CreateUser(model.UserName, model.Password, model.Email, null, null, true, null, out createStatus); using (var ctx = new YakinikuClubDbContext()) { var memberRepository = new MemberRepository(ctx); memberRepository.AddMember(model); ctx.SaveChanges(); } return(createStatus); }
public ActionResult Register( [ModelBinder(typeof(ManagementViewModelBinder))] ClubActivityViewModel data) { if (ModelState.IsValid) { using (var ctx = new YakinikuClubDbContext()) { var repos = new ClubActivityRepository(ctx); repos.AddClubActivity(data); ctx.SaveChanges(); } return(RedirectToAction("Index", "Home")); } return(RedirectToAction("Index", "Management")); }
public MemberListViewModel() { using (var ctx = new YakinikuClubDbContext()) { var repos = new MemberRepository(ctx); var list = repos.GetAll().ToList(); var vmList = new List <MemberViewModel>(); for (int i = 0; i < list.Count; i++) { vmList.Add(new MemberViewModel()); } Mapper.CreateMap <Entity.Member, MemberViewModel>(); var result = Mapper.Map <IEnumerable <Entity.Member>, IEnumerable <MemberViewModel> >(list); Members = result; } }
public ClubActivityRegisterViewModel() { StartDate = DateTime.Today; EndDate = DateTime.Today; using (var ctx = new YakinikuClubDbContext()) { var reposShop = new ShopRepository(ctx); var shops = reposShop.GetAll().ToList(); var shopViewModels = new List <ShopViewModel>(); for (int i = 0; i < shops.Count; i++) { shopViewModels.Add(new ShopViewModel()); } ObjectUtil.CopyTo(shops, shopViewModels); Shops = shopViewModels; } }
public ClubActivityListViewModel() { using (var ctx = new YakinikuClubDbContext()) { var repos = new ClubActivityRepository(ctx); var list = repos.GetAll() .Include(x => x.Shop) .OrderByDescending(x => x.Times) .ToList(); var vmList = new List <ClubActivityViewModel>(); for (int i = 0; i < list.Count; i++) { vmList.Add(new ClubActivityViewModel()); } Mapper.CreateMap <Entity.ClubActivity, ClubActivityViewModel>(); Mapper.CreateMap <Entity.Shop, ShopViewModel>(); var result = Mapper.Map <IEnumerable <Entity.ClubActivity>, IEnumerable <ClubActivityViewModel> >(list); ClubActivities = result; } }
public HistoryListViewModel() { using (var ctx = new YakinikuClubDbContext()) { var reposClubActivity = new ClubActivityRepository(ctx); var reposParticipant = new ParticipantRepository(ctx); var reposMember = new MemberRepository(ctx); Mapper.CreateMap <Entity.Shop, ShopViewModel>(); var list = (from ca in reposClubActivity.GetAll().Include(x => x.Shop) join p in reposParticipant.GetAll() on ca.Times equals p.Times join m in reposMember.GetAll() on p.MemberId equals m.MemberId where ca.StartDate < DateTime.Now orderby ca.Times descending group new { p, m } by new { ca.Times, ca.StartDate, ca.EndDate, ca.Shop, ca.Memo } ).ToList(); var result = from item in list let memo = (item.Key.Memo + Environment.NewLine + string.Join(Environment.NewLine, item.Select(x => x.m.NickName)) ).Trim('\r', '\n') select new HistoryViewModel { Times = item.Key.Times, StartDate = item.Key.StartDate, EndDate = item.Key.EndDate, Shop = Mapper.Map <Entity.Shop, ShopViewModel>(item.Key.Shop), Memo = memo }; Histories = result; } }