public IEnumerable <TeamInfo> GetTeamUnderDefinition(string year, string reviewCode, string definitionCode, string misCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.TeamSet
join b in entityContext.TeamDefinitionSet on a.DefinitionCode equals b.Code into bparents
from bp in bparents.Where(bpt => (a.Year == bpt.Year && a.ReviewCode == bpt.ReviewCode)).DefaultIfEmpty()
join c in entityContext.TeamSet on a.ParentCode equals c.Code into cparents
from cp in cparents.Where(cpt => (a.Year == cpt.Year && a.ReviewCode == cpt.ReviewCode)).DefaultIfEmpty()
join d in entityContext.TeamDefinitionSet on cp.DefinitionCode equals d.Code into dparents
from dp in dparents.Where(dpt => (cp.Year == dpt.Year && cp.ReviewCode == dpt.ReviewCode)).DefaultIfEmpty()
where a.Year == year && a.ReviewCode == reviewCode && cp.DefinitionCode == definitionCode && cp.Code == misCode
select new TeamInfo()
{
Team = a,
TeamDefinition = bp,
Parent = cp,
ParentDefinition = dp
};
return(query.ToFullyLoaded());
}
}
public IEnumerable <OpexEntryInfo> GetOpexEntries(string year, string reviewCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.OpexEntrySet
join b in entityContext.OpexItemSet on a.ItemCode equals b.Code into bparents
from bp in bparents.Where(bpt => (a.Year == bpt.Year && a.ReviewCode == bpt.ReviewCode)).DefaultIfEmpty()
join c in entityContext.OpexCategorySet on bp.CategoryCode equals c.Code into cparents
from cp in cparents.Where(cpt => (bp.Year == cpt.Year && bp.ReviewCode == cpt.ReviewCode)).DefaultIfEmpty()
join d in entityContext.TeamSet on a.MisCode equals d.Code into dparents
from dp in dparents.Where(dpt => (a.Year == dpt.Year && a.ReviewCode == dpt.ReviewCode && a.DefintionCode == dpt.DefinitionCode)).DefaultIfEmpty()
join e in entityContext.TeamDefinitionSet on dp.DefinitionCode equals e.Code into eparents
from ep in eparents.Where(ept => (dp.Year == ept.Year && dp.ReviewCode == ept.ReviewCode)).DefaultIfEmpty()
where a.Year == year && a.ReviewCode == reviewCode
select new OpexEntryInfo()
{
OpexEntry = a,
OpexItem = bp,
OpexCategory = cp,
Team = dp,
TeamDefinition = ep
};
return(query.ToFullyLoaded());
}
}
public IEnumerable <StaffCostInfo> GetStaffCosts(string year, string reviewCode, string definitionCode, string misCode, CenterTypeEnum center)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.StaffCostSet
join b in entityContext.PayClassificationSet on a.ClassificationCode equals b.Code into bparents
from bp in bparents.Where(bpt => (a.Year == bpt.Year && a.ReviewCode == bpt.ReviewCode)).DefaultIfEmpty()
join c in entityContext.GradeSet on a.GradeCode equals c.Code into cparents
from cp in cparents.Where(cpt => (a.Year == cpt.Year && a.ReviewCode == cpt.ReviewCode)).DefaultIfEmpty()
join d in entityContext.TeamSet on a.MisCode equals d.Code into dparents
from dp in dparents.Where(dpt => (a.Year == dpt.Year && a.ReviewCode == dpt.ReviewCode)).DefaultIfEmpty()
join e in entityContext.TeamDefinitionSet on dp.DefinitionCode equals e.Code into eparents
from ep in eparents.Where(ept => (dp.Year == ept.Year && dp.ReviewCode == ept.ReviewCode)).DefaultIfEmpty()
where a.Year == year && a.ReviewCode == reviewCode && a.DefintionCode == definitionCode && a.MisCode == misCode && a.CenterType == center
select new StaffCostInfo()
{
StaffCost = a,
PayClassification = bp,
Grade = cp,
Team = dp,
TeamDefinition = ep
};
return(query.ToFullyLoaded());
}
}
public IEnumerable <FeeGroupEntryInfo> GetFeeGroupEntries(string year, string reviewCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.FeeGroupEntrySet
join b in entityContext.FeeGroupSet on a.GroupCode equals b.Code into bparents
from bp in bparents.Where(bpt => (a.Year == bpt.Year && a.ReviewCode == bpt.ReviewCode)).DefaultIfEmpty()
join d in entityContext.TeamSet on a.MisCode equals d.Code into dparents
from dp in dparents.Where(dpt => (a.Year == dpt.Year && a.ReviewCode == dpt.ReviewCode && a.DefintionCode == dpt.DefinitionCode)).DefaultIfEmpty()
join e in entityContext.TeamDefinitionSet on dp.DefinitionCode equals e.Code into eparents
from ep in eparents.Where(ept => (dp.Year == ept.Year && dp.ReviewCode == ept.ReviewCode)).DefaultIfEmpty()
where a.Year == year && a.ReviewCode == reviewCode
select new FeeGroupEntryInfo()
{
FeeGroupEntry = a,
FeeGroup = bp,
Team = dp,
TeamDefinition = ep
};
return(query.ToFullyLoaded());
}
}
public IEnumerable <OfficerDetailInfo> GetOfficerDetailUnderDefinition(string year, string reviewCode, string definitionCode, string misCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.OfficerDetailSet
join b in entityContext.TeamSet on a.MisCode equals b.Code into bparents
from bp in bparents.Where(bpt => (a.Year == bpt.Year && a.ReviewCode == bpt.ReviewCode)).DefaultIfEmpty()
join c in entityContext.TeamDefinitionSet on a.DefinitionCode equals c.Code into cparents
from cp in cparents.Where(cpt => (a.Year == cpt.Year && a.ReviewCode == cpt.ReviewCode)).DefaultIfEmpty()
join d in entityContext.TeamSet on bp.ParentCode equals d.Code into dparents
from dp in dparents.Where(dpt => (bp.Year == dpt.Year && bp.ReviewCode == dpt.ReviewCode)).DefaultIfEmpty()
join e in entityContext.TeamDefinitionSet on dp.DefinitionCode equals e.Code into eparents
from ep in eparents.Where(ept => (dp.Year == ept.Year && dp.ReviewCode == ept.ReviewCode)).DefaultIfEmpty()
where a.Year == year && a.ReviewCode == reviewCode && dp.DefinitionCode == definitionCode && dp.Code == misCode
select new OfficerDetailInfo()
{
OfficerDetail = a,
Team = bp,
TeamDefinition = cp
};
return(query.ToFullyLoaded());
}
}
public IEnumerable <ProductInfo> GetProducts(string year, string reviewCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.ProductSet
join b in entityContext.ProductGroupSet on a.GroupCode equals b.Code into bparents
from bp in bparents.Where(bpt => (a.Year == bpt.Year && a.ReviewCode == bpt.ReviewCode)).DefaultIfEmpty()
join c in entityContext.ProductCategorySet on a.CategoryCode equals c.Code into cparents
from cp in cparents.Where(cpt => (a.Year == cpt.Year && a.ReviewCode == cpt.ReviewCode)).DefaultIfEmpty()
join d in entityContext.ProductClassificationSet on a.ClassificationCode equals d.Code into dparents
from dp in dparents.Where(dpt => (a.Year == dpt.Year && a.ReviewCode == dpt.ReviewCode)).DefaultIfEmpty()
join e in entityContext.RevenueCaptionSet on a.ClassificationCode equals e.Code into eparents
from ep in eparents.Where(ept => (a.Year == ept.Year && a.ReviewCode == ept.ReviewCode)).DefaultIfEmpty()
where a.Year == year && a.ReviewCode == reviewCode
select new ProductInfo()
{
Product = a,
ProductGroup = bp,
ProductCategory = cp,
ProductClassification = dp,
RevenueCaption = ep
};
return(query.ToFullyLoaded());
}
}
protected override FeeVolumeBasedSetup GetEntity(BudgetContext entityContext, int id)
{
var query = (from e in entityContext.Set <FeeVolumeBasedSetup>()
where e.FeeVolumeBasedSetupId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override OpexEntry GetEntity(BudgetContext entityContext, int id)
{
var query = (from e in entityContext.Set <OpexEntry>()
where e.OpexEntryId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override TeamClassificationType GetEntity(BudgetContext entityContext, int id)
{
var query = (from e in entityContext.Set <TeamClassificationType>()
where e.TeamClassificationTypeId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override BudgetingLevel GetEntity(BudgetContext entityContext, int id)
{
var query = (from e in entityContext.Set <BudgetingLevel>()
where e.BudgetingLevelId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override FeeSharedExemption GetEntity(BudgetContext entityContext, int id)
{
var query = (from e in entityContext.Set <FeeSharedExemption>()
where e.FeeSharedExemptionId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override OfficerDetail GetEntity(BudgetContext entityContext, int id)
{
var query = (from e in entityContext.Set <OfficerDetail>()
where e.OfficerDetailId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override TeamSetting GetEntity(BudgetContext entityContext, int id)
{
var query = (from e in entityContext.Set <TeamSetting>()
where e.TeamSettingId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override ProductInterestRate GetEntity(BudgetContext entityContext, int id)
{
var query = (from e in entityContext.Set <ProductInterestRate>()
where e.ProductInterestRateId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override CapexCost GetEntity(BudgetContext entityContext, int id)
{
var query = (from e in entityContext.Set <CapexCost>()
where e.CapexCostId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override DepreciationRate GetEntity(BudgetContext entityContext, int id)
{
var query = (from e in entityContext.Set <DepreciationRate>()
where e.DepreciationRateId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override PrimaryLock GetEntity(BudgetContext entityContext, int id)
{
var query = (from e in entityContext.Set <PrimaryLock>()
where e.PrimaryLockId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
public CurrencyRate GetCurrencyRate(string year, string reviewCode, RateTypeEnum rateType, string currencyCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.CurrencyRateSet
where a.Year == year && a.ReviewCode == reviewCode && a.RateType == rateType && a.CurrencyCode == currencyCode
select a;
return(query.FirstOrDefault());
}
}
public IEnumerable <OperationReview> GetOperationReviews(string operationCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.OperationReviewSet
where a.OperationCode == operationCode
select a;
return(query.ToFullyLoaded());
}
}
public IEnumerable <FeeCaption> GetFeeCaptions(string year, string reviewCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.FeeCaptionSet
where a.Year == year && a.ReviewCode == reviewCode
select a;
return(query.ToFullyLoaded());
}
}
public IEnumerable <TeamClassificationType> GetTeamClassificationTypes(string year, string reviewCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.TeamClassificationTypeSet
where a.Year == year && a.ReviewCode == reviewCode
select a;
return(query.ToFullyLoaded());
}
}
public IEnumerable <CurrencyRate> GetCurrencyRates(string year, string reviewCode, RateTypeEnum rateType)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.CurrencyRateSet
where a.Year == year && a.ReviewCode == reviewCode && a.RateType == rateType
select a;
return(query.ToFullyLoaded());
}
}
public IEnumerable <ProductCategory> GetProductCategories(string year, string reviewCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.ProductCategorySet
where a.Year == year && a.ReviewCode == reviewCode
select a;
return(query.ToFullyLoaded());
}
}
public IEnumerable <PolicyInfo> GetPolicies()
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.PolicySet
join b in entityContext.ModuleSet on a.ModuleCode equals b.Code
select new PolicyInfo()
{
Policy = a,
Module = b
};
return(query.ToFullyLoaded());
}
}
public IEnumerable <CapexCategoryInfo> GetAllCapexCategories()
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.CapexCategorySet
join b in entityContext.CapexCategorySet on a.ParentCode equals b.Code into bparents
from bp in bparents.Where(bpt => (a.Year == bpt.Year && a.ReviewCode == bpt.ReviewCode)).DefaultIfEmpty()
select new CapexCategoryInfo()
{
CapexCategory = a,
Parent = bp
};
return(query.ToFullyLoaded());
}
}
public IEnumerable <OpexItemInfo> GetOpexItems(string year, string reviewCode, string categoryCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.OpexItemSet
join b in entityContext.OpexCategorySet on a.CategoryCode equals b.Code into bparents
from bp in bparents.Where(bpt => (a.Year == bpt.Year && a.ReviewCode == bpt.ReviewCode)).DefaultIfEmpty()
where a.Year == year && a.ReviewCode == reviewCode && bp.Code == categoryCode
select new OpexItemInfo()
{
OpexItem = a,
OpexCategory = bp
};
return(query.ToFullyLoaded());
}
}
public IEnumerable <ProductGroupInfo> GetProductGroups(string year, string reviewCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.ProductGroupSet
join b in entityContext.ProductGroupSet on a.ParentCode equals b.Code into bparents
from bp in bparents.Where(bpt => (a.Year == bpt.Year && a.ReviewCode == bpt.ReviewCode)).DefaultIfEmpty()
where a.Year == year && a.ReviewCode == reviewCode
select new ProductGroupInfo()
{
ProductGroup = a,
Parent = bp
};
return(query.ToFullyLoaded());
}
}
public IEnumerable <FeeSharedExemptionInfo> GetFeeSharedExemptions(string year, string reviewCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.FeeSharedExemptionSet
join b in entityContext.FeeItemSet on a.ItemCode equals b.Code into bparents
from bp in bparents.Where(bpt => (a.Year == bpt.Year && a.ReviewCode == bpt.ReviewCode)).DefaultIfEmpty()
where a.Year == year && a.ReviewCode == reviewCode
select new FeeSharedExemptionInfo()
{
FeeSharedExemption = a,
FeeItem = bp
};
return(query.ToFullyLoaded());
}
}
public IEnumerable <DepreciationRateInfo> GetDepreciationRates(string year, string reviewCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.DepreciationRateSet
join b in entityContext.CapexCategorySet on a.CategoryCode equals b.Code into bparents
from bp in bparents.Where(bpt => (a.Year == bpt.Year && a.ReviewCode == bpt.ReviewCode)).DefaultIfEmpty()
where a.Year == year && a.ReviewCode == reviewCode
select new DepreciationRateInfo()
{
DepreciationRate = a,
CapexCategory = bp
};
return(query.ToFullyLoaded());
}
}
public IEnumerable <BudgetingLevelInfo> GetBudgetingLevels(string year, string reviewCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.BudgetingLevelSet
join b in entityContext.ModuleSet on a.ModuleCode equals b.Code
join c in entityContext.TeamDefinitionSet on a.DefinitionCode equals c.Code into cparents
from cp in cparents.Where(cpt => (a.Year == cpt.Year && a.ReviewCode == cpt.ReviewCode)).DefaultIfEmpty()
where a.Year == year && a.ReviewCode == reviewCode
select new BudgetingLevelInfo()
{
BudgetingLevel = a,
Module = b,
TeamDefinition = cp
};
return(query.ToFullyLoaded());
}
}
