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