public async Task <IActionResult> EditAsync(int id, Matoleo matoleo) { if (id != matoleo.MatoleoId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(matoleo); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MatoleoExists(matoleo.MatoleoId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["ChurchMembersId"] = new SelectList(_context.ChurchMembers, "ChurchMembersId", "ChurchMembersId", matoleo.ChurchMembersId); ViewData["MatoleoId"] = new SelectList(_context.Matoleo, "MatoleoId", "MatoleoId", matoleo.MatoleoId); return(View(matoleo)); }
public async Task <IActionResult> DeleteConfirmedAsync(Matoleo mato) { var matoleo = await _context.Matoleo.SingleOrDefaultAsync(m => m.MatoleoId == mato.MatoleoId); _context.Matoleo.Remove(matoleo); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); }
// GET: Matoleos/Create public IActionResult Create() { Matoleo matoleo = new Matoleo(); //ViewData["Savetime"] = SessionKeyDate; return(View(matoleo)); }
public IViewComponentResult Invoke() { var listed = _context.Matoleo.GroupBy(x => x.Savetime).Select(x => x.FirstOrDefault()).ToList(); ViewBag.Timed = new SelectList(listed.Select(n => n.Savetime)); Matoleo matoleo = new Matoleo(); return(View(matoleo)); }
public IActionResult Index(Matoleo matoleo) { var listed = _context.Matoleo.Include(m => m.ChurchMembers).Include(n => n.mengineyo).Where(n => n.Savetime == matoleo.Savetime).ToList(); ViewBag.sum1 = listed.Sum(n => n.sadakaBk); ViewBag.sum2 = listed.Sum(n => n.sadakaConf); ViewBag.sum3 = listed.Sum(n => n.Zaka); ViewBag.sum4 = listed.Sum(n => n.Total); ViewBag.sum5 = listed.Sum(n => n.MpangoKanisa); ViewBag.sum6 = listed.Sum(n => n.sadakaMakambi); ViewBag.sum7 = listed.Sum(n => n.sadakaMajengo); ViewBag.mengineyo = listed.Select(n => n.mengineyo).ToList(); return(View(listed)); }
public async Task NudiaAsync(Matoleo matoleo, IList <Mengineyo> mengineyo) { foreach (var m in mengineyo) { Mengineyo mengi = new Mengineyo() { descr = m.descr, Amount = m.Amount }; mengi.MatoleoId = matoleo.MatoleoId; _context.Add(mengi); await _context.SaveChangesAsync(); } }
// GET: Matoleos public IActionResult Index() { Matoleo matoleo = new Matoleo(); var listed = _context.Matoleo.Include(m => m.ChurchMembers).Include(m => m.mengineyo).GroupBy(x => x.Savetime).First().ToList(); ViewBag.Mengineyo = listed.Select(n => n.mengineyo).ToList(); ViewBag.sum1 = listed.Sum(n => n.sadakaBk); ViewBag.sum2 = listed.Sum(n => n.sadakaConf); ViewBag.sum3 = listed.Sum(n => n.Zaka); ViewBag.sum4 = listed.Sum(n => n.Total); ViewBag.sum5 = listed.Sum(n => n.MpangoKanisa); ViewBag.sum6 = listed.Sum(n => n.sadakaMakambi); ViewBag.sum7 = listed.Sum(n => n.sadakaMajengo); return(View(listed)); }
public IActionResult SummaryAsync(Matoleo matoleo, int Page = 1) { var listed = _context.Matoleo.AsNoTracking().Where(n => n.Savetime == matoleo.Savetime).Include(b => b.ChurchMembers); //.Skip((productPage - 1) * PageSize) //.Take(PageSize); var vai = ReflectionIT.Mvc.Paging.PaginList <Matoleo> .CreateAsync(listed, PageSize, Page, matoleo.Savetime.ToString(), matoleo.Savetime.ToString()); vai.RouteValue = new Microsoft.AspNetCore.Routing.RouteValueDictionary { { matoleo.Savetime.ToString(), matoleo.Savetime } }; ViewBag.sum1 = vai.Sum(n => n.sadakaBk); ViewBag.sum2 = vai.Sum(n => n.sadakaConf); ViewBag.sum3 = vai.Sum(n => n.Zaka); ViewBag.sum4 = vai.Sum(n => n.Total); ViewBag.sum5 = vai.Sum(n => n.MpangoKanisa); ViewBag.sum6 = vai.Sum(n => n.sadakaMakambi); ViewBag.sum7 = vai.Sum(n => n.sadakaMajengo); return(View(vai)); }
public async Task <IActionResult> CreateAsync(Matoleo matoleo, IList <Mengineyo> mengineyo) { //HttpContext.Session.Set<DateTime>(SessionKeyDate, matoleo.Savetime); //var meng = formCollectiom.Contains("Name") if (ModelState.IsValid) { var exists = _context.Matoleo.Include(v => v.ChurchMembers).AsNoTracking().Any(x => x.ChurchMembers.Name == matoleo.ChurchMembers.Name); if (exists) { _context.Update(matoleo); } _context.Add(matoleo); await _context.SaveChangesAsync(); await NudiaAsync(matoleo, mengineyo); return(RedirectToAction(nameof(Index))); } ViewData["ChurchMembersId"] = new SelectList(_context.ChurchMembers, "ChurchMembersId", "ChurchMembersId", matoleo.ChurchMembersId); return(View(matoleo)); }
internal static object CreateAsync(List <Matoleo> listed, int pageSize, int page, Matoleo matoleo, string sortExpression, string v) { throw new NotImplementedException(); }