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