public async Task <IActionResult> IndicatorList(int id) { var indiTrack = _context.IncdicatorTracking.Where(a => a.SchoolID == id); var applicationDbContext = from Proj_Indicator in _context.Indicator join Proj_IncdicatorTracking in _context.IncdicatorTracking on Proj_Indicator.IndicatorID equals Proj_IncdicatorTracking.IndicatorID into Proj_IncdicatorTracking_join from Proj_IncdicatorTracking in Proj_IncdicatorTracking_join.DefaultIfEmpty() where Proj_Indicator.IndicatorID > 28 && Proj_Indicator.IndicatorID != 35 && Proj_Indicator.IndicatorID < 40 && (Proj_IncdicatorTracking.SchoolID == id) //Proj_IncdicatorTracking.SchoolID == null) orderby Proj_Indicator.SequenceNo select new IndicatorTracking { IndicatorID = Proj_Indicator.IndicatorID, Indicator = Proj_Indicator.IndicatorName, isEvidence = Proj_Indicator.IsEvidenceRequire, ImageURL = Proj_IncdicatorTracking.ImageURL, DateOfUpload = Proj_IncdicatorTracking.DateOfUpload, SchoolID = id, IsUpload = Proj_IncdicatorTracking.IsUpload, TotalFilesUploaded = Proj_IncdicatorTracking.TotalFilesUploaded, isPotential = Proj_Indicator.IsPotential, isFeeder = Proj_Indicator.IsFeeder, isNextLevel = Proj_Indicator.IsNextLevel, EvidanceType = Proj_Indicator.EvidanceType, ReUpload = Proj_IncdicatorTracking.ReUpload, Verified = Proj_IncdicatorTracking.Verified, ReVerified = Proj_IncdicatorTracking.ReVerified, DevVerified = Proj_IncdicatorTracking.DevVerified //SchoolID = Proj_IncdicatorTracking.SchoolID == id ? id : Proj_IncdicatorTracking.SchoolID == null ? (int?)null : 0, // Proj_Indicator.SequenceNo }; ViewBag.SchoolName = (await _context.Schools.FindAsync(id)).SName; return(View(await applicationDbContext.ToListAsync())); }
// GET: IncdicatorTrackings/Update public IActionResult Update(int id, int SecID) { int PId = SecID == 926982 ? 4 : 3; var applicationDbContext = from Proj_Indicator in _context.Indicator join Proj_IncdicatorTracking in _context.IncdicatorTracking on Proj_Indicator.IndicatorID equals Proj_IncdicatorTracking.IndicatorID into Proj_IncdicatorTracking_join from Proj_IncdicatorTracking in Proj_IncdicatorTracking_join.DefaultIfEmpty() where Proj_Indicator.PartnerID == PId orderby Proj_Indicator.SequenceNo select new IncdicatorTracking { IndicatorID = Proj_Indicator.IndicatorID, IndicatorName = Proj_Indicator.IndicatorName, isEvidence = Proj_Indicator.IsEvidenceRequire, ImageURL = Proj_IncdicatorTracking.ImageURL, DateOfUpload = Proj_IncdicatorTracking.DateOfUpload, SchoolID = id, // Proj_Indicator.SequenceNo }; return(View(applicationDbContext.ToList())); }
//public async Task<IActionResult> MneVerifyIndicators(short id, int SecID) public IActionResult MneVerifyIndicators(int id, int SecID) { int PId = SecID == 926982 ? 4 : 3; ViewBag.SecID = SecID; var sch = _context.Schools.Find(id); ViewBag.Sname = sch.SName; if (SecID == 926982) { ViewBag.Section = "Education Section"; } else if (SecID == 352769) { ViewBag.Section = "Development Section"; } var indiTrack = _context.IncdicatorTracking.Where(a => a.SchoolID == id); var applicationDbContext = from Proj_Indicator in _context.Indicator join Proj_IncdicatorTracking in indiTrack on Proj_Indicator.IndicatorID equals Proj_IncdicatorTracking.IndicatorID into Proj_IncdicatorTracking_join from Proj_IncdicatorTracking in Proj_IncdicatorTracking_join.DefaultIfEmpty() where Proj_Indicator.PartnerID == PId // && (Proj_IncdicatorTracking.SchoolID == id || //Proj_IncdicatorTracking.SchoolID == null) orderby Proj_Indicator.SequenceNo select new IndicatorTracking { IndicatorID = Proj_Indicator.IndicatorID, Indicator = Proj_Indicator.IndicatorName, isEvidence = Proj_Indicator.IsEvidenceRequire, ImageURL = Proj_IncdicatorTracking.ImageURL, DateOfUpload = Proj_IncdicatorTracking.DateOfUpload, SchoolID = id, IsUpload = Proj_IncdicatorTracking.IsUpload, TotalFilesUploaded = Proj_IncdicatorTracking.TotalFilesUploaded, isPotential = Proj_Indicator.IsPotential, isFeeder = Proj_Indicator.IsFeeder, isNextLevel = Proj_Indicator.IsNextLevel, EvidanceType = Proj_Indicator.EvidanceType, ReUpload = Proj_IncdicatorTracking.ReUpload, Verified = Proj_IncdicatorTracking.Verified, //SchoolID = Proj_IncdicatorTracking.SchoolID == id ? id : Proj_IncdicatorTracking.SchoolID == null ? (int?)null : 0, // Proj_Indicator.SequenceNo }; switch (sch.type) { case 1: applicationDbContext = applicationDbContext.Where(a => a.isPotential == true); break; case 2: applicationDbContext = applicationDbContext.Where(a => a.isFeeder == true); break; case 3: applicationDbContext = applicationDbContext.Where(a => a.isNextLevel == true); break; } //applicationDbContext = applicationDbContext.Where(a => a.SchoolID == id || a.SchoolID == null); //List<IndicatorTracking> indicatorTrackings = new List<IndicatorTracking>(); //foreach(var indi in applicationDbContext) //{ // if(indi.SchoolID!=id ||) //} ViewData["ids"] = applicationDbContext.Select(a => a.IndicatorID).ToArray(); return(View(applicationDbContext.ToList())); }