public NPStrategyModel RetreiveNPStrategy(int npstrategyid, string username)
{
var cont = new SeniorLinqDataContext();
var query = (from nps in cont.NPStrategies where nps.Username == username && nps.StrategyId == npstrategyid select nps).SingleOrDefault();
NPStrategyModel npsm = new NPStrategyModel();
npsm.StrategyId = query.StrategyId;
npsm.Username = query.Username;
npsm.NPID = query.NPID;
return(npsm);
}
public int AddNPStrategy(NPStrategyModel npstrategy)
{
var cont = new SeniorLinqDataContext();
NPStrategy temp = new NPStrategy();
temp.StrategyId = npstrategy.StrategyId;
temp.NPID = npstrategy.NPID;
temp.Username = npstrategy.Username;
cont.NPStrategies.InsertOnSubmit(temp);
cont.SubmitChanges();
var query = (from strat in cont.NPStrategies where temp.NPID == strat.NPID && temp.Username == strat.Username && temp.StrategyId == strat.StrategyId select strat.NPID).SingleOrDefault();
if (query != null)
{
return(-1);
}
return(1);
}
