//public int DeleteNPPayoff(int payoffid,string username)
//{
// var cont = new SeniorLinqDataContext();
// var query = (from pof in cont.NPPayoffs where pof.PayoffId == payoffid && pof.Username ==username select pof).SingleOrDefault();
// cont.NPPayoffs.DeleteOnSubmit(query);
// cont.SubmitChanges();
// var q = (from pof in cont.NPPayoffs where pof.PayoffId == payoffid && pof.Username == username select pof).SingleOrDefault();
// if (q == null)
// return 1;
// else return -1;
//}
public NPPayoffModel RetreiveNPPayoff(int payoffid, string username)
{
var cont = new SeniorLinqDataContext();
var query = (from npof in cont.NPPayoffs where npof.Payoff == payoffid && npof.Username == username select npof).SingleOrDefault();
NPPayoffModel pm = new NPPayoffModel();
pm.NPID = query.NPID;
pm.Payoff = query.Payoff;
pm.PayoffId = query.PayoffId;
pm.Username = query.Username;
return(pm);
}
public int AddNPPayoff(NPPayoffModel payoff)
{
var cont = new SeniorLinqDataContext();
NPPayoff temp = new NPPayoff();
temp.NPID = payoff.NPID;
temp.PayoffId = payoff.PayoffId;
temp.Username = payoff.Username;
temp.Payoff = payoff.Payoff;
cont.NPPayoffs.InsertOnSubmit(temp);
cont.SubmitChanges();
var query = (from pof in cont.NPPayoffs where temp.NPID == pof.NPID && temp.PayoffId == pof.PayoffId && temp.Username == payoff.Username select pof.Payoff).SingleOrDefault();
if (query != null)
{
return(-1);
}
return(1);
}
