public IEnumerable <SCDTarget> GetCaptions() { //var connectionString = ConfigurationManager.ConnectionStrings["FintrakDBConnection"].ConnectionString; var connectionString = ScorecardContext.GetDataConnection(); var scdactuals = new List <SCDTarget>(); using (var con = new SqlConnection(connectionString)) { var cmd = new SqlCommand("spp_mpr_getDistinctSCDTargetCaption", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandTimeout = 0; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var scdactual = new SCDTarget(); if (reader["Caption"] != DBNull.Value) { scdactual.Caption = reader["Caption"].ToString(); } scdactuals.Add(scdactual); } con.Close(); } return(scdactuals); }
protected override SCDTeamClassification GetEntity(ScorecardContext entityContext, int id) { var query = (from e in entityContext.Set <SCDTeamClassification>() where e.TeamClassificationId == id select e); var results = query.FirstOrDefault(); return(results); }
protected override SCDKPI GetEntity(ScorecardContext entityContext, int id) { var query = (from e in entityContext.Set <SCDKPI>() where e.KPIId == id select e); var results = query.FirstOrDefault(); return(results); }
public IEnumerable <SCDConfigurationInfo> GetSCDConfigurations() { using (ScorecardContext entityContext = new ScorecardContext()) { var query = from a in entityContext.SCDConfigurationSet select new SCDConfigurationInfo() { SCDConfiguration = a }; return(query.ToFullyLoaded()); } }
public IEnumerable <SCDKPITargetMapInfo> GetSCDKPITargetMaps() { using (ScorecardContext entityContext = new ScorecardContext()) { var query = from a in entityContext.SCDKPITargetMapSet join b in entityContext.SCDKPISet on a.KPICode equals b.Code select new SCDKPITargetMapInfo() { scdkpitargetmap = a, scdkpi = b }; return(query.ToFullyLoaded()); } }
public IEnumerable <SCDKPIInfo> GetSCDKPIs() { using (ScorecardContext entityContext = new ScorecardContext()) { var query = from a in entityContext.SCDKPISet join b in entityContext.SCDCategorySet on a.CategoryCode equals b.Code into ab from abi in ab.DefaultIfEmpty() select new SCDKPIInfo() { SCDKPI = a, SCDCategory = abi }; return(query.ToFullyLoaded()); } }
public IEnumerable <SCDCategoryInfo> GetSCDCategorys() { using (ScorecardContext entityContext = new ScorecardContext()) { var query = from a in entityContext.SCDCategorySet join b in entityContext.SCDCategorySet on a.ParentCode equals b.Code into parents from pt in parents.DefaultIfEmpty() select new SCDCategoryInfo() { SCDCategory = a, Parent = pt }; return(query.ToFullyLoaded()); } }
public IEnumerable <SCDTeamMapInfo> GetSCDTeamMaps() { using (ScorecardContext entityContext = new ScorecardContext()) { var query = from a in entityContext.SCDTeamMapSet join c in entityContext.StaffSet on a.StaffCode equals c.StaffCode join d in entityContext.SCDTeamClassificationSet on a.TeamClassificationCode equals d.Code select new SCDTeamMapInfo() { SCDTeamMap = a, Staff = c, TeamClassification = d }; return(query.ToFullyLoaded()); } }
public IEnumerable <SCDConfigurationInfo> GetSCDConfigurations() { using (ScorecardContext entityContext = new ScorecardContext()) { var query = from a in entityContext.SCDConfigurationSet join b in entityContext.CompanySet on a.CompanyCode equals b.Code join c in entityContext.TeamClassificationTypeSet on a.TeamClassificationCode equals c.Code select new SCDConfigurationInfo() { SCDConfiguration = a, Company = b, TeamClassificationType = c }; return(query.ToFullyLoaded()); } }
public IEnumerable <SCDKPIEntryInfo> GetSCDKPIEntrys() { using (ScorecardContext entityContext = new ScorecardContext()) { var query = from a in entityContext.SCDKPIEntrySet join b in entityContext.StaffSet on a.StaffCode equals b.StaffCode join c in entityContext.SCDTeamMapSet on a.MISCode equals c.MISCode join d in entityContext.SCDKPISet on a.KPICode equals d.Code select new SCDKPIEntryInfo() { SCDKPIEntry = a, Staff = b, SCDTeamMap = c, SCDKPI = d }; return(query.ToFullyLoaded()); } }
public IEnumerable <SCDKPIClassificationInfo> GetSCDKPIClassifications() { using (ScorecardContext entityContext = new ScorecardContext()) { var query = from a in entityContext.SCDKPIClassificationSet join b in entityContext.SCDKPISet on a.KPICode equals b.Code join c in entityContext.SCDTeamClassificationSet on a.TeamClassificationCode equals c.Code join d in entityContext.SCDCategorySet on a.CategoryCode equals d.Code select new SCDKPIClassificationInfo() { SCDKPIClassification = a, SCDKPI = b, SCDTeamClassification = c, SCDCategory = d }; return(query.ToFullyLoaded()); } }
public IEnumerable <SCDThresholdInfo> GetSCDThresholds() { using (ScorecardContext entityContext = new ScorecardContext()) { var query = from a in entityContext.SCDThresholdSet join b in entityContext.SCDTeamClassificationSet on a.TeamClassificationCode equals b.Code join c in entityContext.SCDKPISet on a.KPICode equals c.Code join d in entityContext.StaffSet on a.StaffCode equals d.StaffCode into staffs from st in staffs.DefaultIfEmpty() select new SCDThresholdInfo() { SCDThreshold = a, SCDTeamClassification = b, SCDKPI = c, Staff = st }; return(query.ToFullyLoaded()); } }
protected override SCDKPI AddEntity(ScorecardContext entityContext, SCDKPI entity) { return(entityContext.Set <SCDKPI>().Add(entity)); }
protected override SCDKPIClassification UpdateEntity(ScorecardContext entityContext, SCDKPIClassification entity) { return((from e in entityContext.Set <SCDKPIClassification>() where e.ClassificationId == entity.ClassificationId select e).FirstOrDefault()); }
protected override SCDKPIClassification AddEntity(ScorecardContext entityContext, SCDKPIClassification entity) { return(entityContext.Set <SCDKPIClassification>().Add(entity)); }
protected override SCDConfiguration AddEntity(ScorecardContext entityContext, SCDConfiguration entity) { return(entityContext.Set <SCDConfiguration>().Add(entity)); }
protected override SCDActual UpdateEntity(ScorecardContext entityContext, SCDActual entity) { return((from e in entityContext.Set <SCDActual>() where e.ActualId == entity.ActualId select e).FirstOrDefault()); }
protected override SCDParticipant AddEntity(ScorecardContext entityContext, SCDParticipant entity) { return(entityContext.Set <SCDParticipant>().Add(entity)); }
protected override IEnumerable <SCDTeamClassification> GetEntities(ScorecardContext entityContext) { return(from e in entityContext.Set <SCDTeamClassification>() select e); }
protected override SCDCategory UpdateEntity(ScorecardContext entityContext, SCDCategory entity) { return((from e in entityContext.Set <SCDCategory>() where e.CategoryId == entity.CategoryId select e).FirstOrDefault()); }
protected override SCDCategory AddEntity(ScorecardContext entityContext, SCDCategory entity) { return(entityContext.Set <SCDCategory>().Add(entity)); }
protected override SCDThreshold AddEntity(ScorecardContext entityContext, SCDThreshold entity) { return(entityContext.Set <SCDThreshold>().Add(entity)); }
protected override SCDKPITargetMap UpdateEntity(ScorecardContext entityContext, SCDKPITargetMap entity) { return((from e in entityContext.Set <SCDKPITargetMap>() where e.MapId == entity.MapId select e).FirstOrDefault()); }
protected override SCDKPITargetMap AddEntity(ScorecardContext entityContext, SCDKPITargetMap entity) { return(entityContext.Set <SCDKPITargetMap>().Add(entity)); }
protected override SCDKPI UpdateEntity(ScorecardContext entityContext, SCDKPI entity) { return((from e in entityContext.Set <SCDKPI>() where e.KPIId == entity.KPIId select e).FirstOrDefault()); }
protected override IEnumerable <SCDKPI> GetEntities(ScorecardContext entityContext) { return(from e in entityContext.Set <SCDKPI>() select e); }
protected override SCDTarget AddEntity(ScorecardContext entityContext, SCDTarget entity) { return(entityContext.Set <SCDTarget>().Add(entity)); }
protected override SCDTarget UpdateEntity(ScorecardContext entityContext, SCDTarget entity) { return((from e in entityContext.Set <SCDTarget>() where e.TargetId == entity.TargetId select e).FirstOrDefault()); }
protected override SCDActual AddEntity(ScorecardContext entityContext, SCDActual entity) { return(entityContext.Set <SCDActual>().Add(entity)); }