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