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