public clientEntities.Agreement GetAgreement(int agreementID)
{
//return clientEntities.Agreement.GetAgreement(agreementID);
using (var db = new EDEntities())
{
var result = from p in db.Agreements
where p.ID == agreementID
select p;
var first = result.FirstOrDefault();
if (first == default(Agreement))
{
throw new ApplicationException("Agreement not found {ID = " + agreementID.ToString() + "}");
}
var votes = (from p in db.AgreementVotes
where p.AgreementID == first.ID
select p);
clientEntities.Agreement agreement = new clientEntities.Agreement(first)
{
NumberOfVotes = votes.Count()
};
return(agreement);
}
}
public clientEntities.Agreement GetAgreement(int agreementID)
{
//return clientEntities.Agreement.GetAgreement(agreementID);
using (var db = new EDEntities())
{
var result = from p in db.Agreements
where p.ID == agreementID
select p;
var first = result.FirstOrDefault();
if (first == default(Agreement))
{
throw new ApplicationException("Agreement not found {ID = " + agreementID.ToString() + "}");
}
var votes = (from p in db.AgreementVotes
where p.AgreementID == first.ID
select p);
clientEntities.Agreement agreement = new clientEntities.Agreement(first) { NumberOfVotes = votes.Count() };
return agreement;
}
}
public static Agreement GetAgreement(long ID)
{
using (var db = new Model.EDEntities())
{
var result = from p in db.Agreements
where p.ID == ID
select p;
var first = result.FirstOrDefault();
if (first == default(Model.Agreement))
throw new ApplicationException("Agreement not found {ID = " + ID.ToString() + "}");
var amount = (from p in db.AgreementVotes
where p.AgreementID == first.ID
select p).Count();
Agreement agreement = new Agreement(first);
return agreement;
}
}
