//public int DeleteNashPointProfile(int NPID)
//{
// var cont = new SeniorLinqDataContext();
// var query = (from npp in cont.NashPointProfiles where npp.NPID == NPID select npp).SingleOrDefault();
// cont.NashPointProfiles.DeleteOnSubmit(query);
// cont.SubmitChanges();
// var q = (from npp in cont.NashPointProfiles where npp.NPID == NPID select npp).SingleOrDefault();
// if (q == null)
// return 1;
// else return -1;
//}
public NashPointProfileModel RetreiveNashPointProfile(int NPID)
{
var cont = new SeniorLinqDataContext();
var query = (from npp in cont.NashPointProfiles where npp.NPID == NPID select npp).SingleOrDefault();
NashPointProfileModel nppm = new NashPointProfileModel();
nppm.NPID = query.NPID;
nppm.GID = query.GID;
return(nppm);
}
public int AddNashPointProfile(NashPointProfileModel NP)
{
var cont = new SeniorLinqDataContext();
NashPointProfile temp = new NashPointProfile();
temp.NPID = NP.NPID;
temp.GID = NP.GID;
cont.NashPointProfiles.InsertOnSubmit(temp);
cont.SubmitChanges();
var query = (from np in cont.NashPointProfiles where np.NPID == temp.NPID && np.NPID == temp.NPID select np.NPID).SingleOrDefault();
if (query != null)
{
return(query);
}
return(-1);
}