public void Save(Model.EDEntities db) { var result = (from p in db.Certificates where p.SerialNumber == this.SerialNumber select p).Count(); if (result > 0) { throw new ApplicationException("Person with this certificate has already been registered"); } var certificate = this.Map(); db.Certificates.Add(certificate); db.SaveChanges(); this.ID = certificate.ID; }
public void Save(Model.EDEntities db) { var result = (from p in db.People where p.Login.ToUpper() == this.Login.ToUpper() select p).Count(); if (result > 0) { throw new ApplicationException("Person with this login has already been registered"); } var person = this.Map(); db.People.Add(person); db.SaveChanges(); this.ID = person.ID; }
public void Vote() { using (var db = new Model.EDEntities()) { var result = (from p in db.PetitionVotes where p.PetitionID == this.Petition.ID && (p.PersonID == this.Person.ID || p.CertificateID == this.Certificate.ID) select p).Count(); if (result > 0) throw new ApplicationException("This vote was already counted"); var vote = this.Map(); db.PetitionVotes.Add(vote); db.SaveChanges(); this.ID = vote.ID; } }
public void Vote() { using (var db = new Model.EDEntities()) { var result = (from p in db.AgreementVotes where p.AgreementID == this.Agreement.ID && (p.PersonID == this.Person.ID || p.CertificateID == this.Certificate.ID) select p).Count(); if (result > 0) { throw new ApplicationException("This vote was already counted"); } var vote = this.Map(); db.AgreementVotes.Add(vote); db.SaveChanges(); this.ID = vote.ID; } }