public object GetData(bool?IsNeg)
{
RedBloodDataContext db = new RedBloodDataContext();
var v =
//db.vw_ProductCounts
db.Packs
.Where(r => r.Status == Pack.StatusX.Product)
.Select(r => new
{
TestResultStatus = r.Donation.TestResultStatus,
r.ProductCode,
r.Status,
r.ExpirationDate,
BloodGroup = r.Donation.BloodGroup,
r.Volume,
})
.ToList()
.Where(r => !IsNeg.HasValue || (IsNeg.Value ? r.TestResultStatus == Donation.TestResultStatusX.Negative
: r.TestResultStatus != Donation.TestResultStatusX.Negative))
.GroupBy(r => new { r.ProductCode, r.Status }, (r, sub) => new
{
r.ProductCode,
ProductDesc = ProductBLL.GetDesc(r.ProductCode),
r.Status,
//Total = sub.Sum(r1 => r1.Count),
Total = sub.Count(),
TotalExpired = sub.Where(r1 => r1.ExpirationDate.Value.Expired())
.Count().ToStringRemoveZero(),
//.Sum(r1 => r1.Count).ToStringRemoveZero(),
TotalExpiredInDays = sub.Where(r1 => r1.ExpirationDate.Value.ExpiredInDays(ExpiredInDays))
.Count().ToStringRemoveZero(),
//.Sum(r1 => r1.Count).ToStringRemoveZero(),
TotalTRNA = sub.Where(r1 => r1.TestResultStatus == Donation.TestResultStatusX.Non)
.Count().ToStringRemoveZero(),
//.Sum(r1 => r1.Count).ToStringRemoveZero(),
TotalTRNeg = sub.Where(r1 => r1.TestResultStatus == Donation.TestResultStatusX.Negative)
.Count().ToStringRemoveZero(),
//.Sum(r1 => r1.Count).ToStringRemoveZero(),
TotalTRPos = sub.Where(r1 => r1.TestResultStatus == Donation.TestResultStatusX.Positive)
.Count().ToStringRemoveZero(),
//.Sum(r1 => r1.Count).ToStringRemoveZero(),
BloodGroupSumary = sub.GroupBy(r1 => BloodGroupBLL.GetLetter(r1.BloodGroup), (r1, BGSub) => new
{
//BloodGroupDesc = BloodGroupBLL.GetDescription(r1),
BloodGroupDesc = r1,
Total = BGSub.Count(), // BGSub.Sum(r3 => r3.Count),
VolumeSumary = BGSub.GroupBy(r2 => r2.Volume, (r2, VolSub) => new
{
Volume = r2.HasValue ? r2.Value.ToString() : "_",
Total = VolSub.Count(), // VolSub.Sum(r3 => r3.Count)
}).OrderBy(r2 => r2.Volume)
}).OrderBy(r1 => r1.BloodGroupDesc),
VolumeSumary = sub.GroupBy(r1 => r1.Volume, (r1, VolSub) => new
{
Volume = r1.HasValue ? r1.Value.ToString() : "_",
Total = VolSub.Count(), // VolSub.Sum(r3 => r3.Count)
}).OrderBy(r1 => r1.Volume)
})
.OrderBy(r => r.ProductDesc);
return(v);
}