public int CreateBusiness(string name, string regNumber) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Business business = new Business(); business.Name = name; business.RegNumber = regNumber; business.Type = "B"; context.Parties.AddObject(business); context.SaveChanges(); return(business.Id); } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void UpdatePerson(int id, string firstName, string lastName, DateTime dateOfBirth) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Person person = (Person) (from p in context.Parties where p.Id == id select p).First(); if (person != null) { person.FirstName = firstName; person.LastName = lastName; person.DateOfBirth = dateOfBirth; context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void DeleteUser(string name) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { User user = (from u in context.Users where (u.Name == name) select u).First(); if (user != null) { context.DeleteObject(user); context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void UpdateBusiness(int id, string name, string regNumber) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { var business = (Business) (from b in context.Parties where b.Id == id select b).First(); if (business != null) { business.Name = name; business.RegNumber = regNumber; context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public int CreateTelephone(string type, string number) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Telephone telephone = new Telephone(); telephone.Number = number; telephone.SubType = type; telephone.Type = "T"; context.Contacts.AddObject(telephone); context.SaveChanges(); return(telephone.Id); } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void UpdateUser(string name, string fullName, string passwordHash) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { User user = (User) (from u in context.Users where u.Name == name select u).First(); if (user != null) { user.FullName = fullName; user.PasswordHash = passwordHash; context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public int CreateEmail(string type, string address) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Email email = new Email(); email.Address = address; email.SubType = type; email.Type = "E"; context.Contacts.AddObject(email); context.SaveChanges(); return(email.Id); } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void DeleteContact(int id) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Contact contact = (from ct in context.Contacts where (ct.Id == id) select ct).First(); if (contact != null) { context.DeleteObject(contact); context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void UpdateTelephone(int id, string type, string number) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Telephone telephone = (Telephone) (from t in context.Contacts where t.Id == id select t).First(); if (telephone != null) { telephone.Number = number; telephone.SubType = type; context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public int CreateAddress(string street, string town, string county, string postCode) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Address address = new Address(); address.Street = street; address.Town = town; address.County = county; address.PostCode = postCode; address.Type = "A"; context.Contacts.AddObject(address); context.SaveChanges(); return(address.Id); } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void UpdateAddress(int id, string street, string town, string county, string postCode) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Address address = (Address) (from a in context.Contacts where a.Id == id select a).First(); if (address != null) { address.Street = street; address.Town = town; address.County = county; address.PostCode = postCode; context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void CreatePartyContact(int partyId, int contactId, DateTime validFrom, DateTime validUntil) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { PartyContact partyContact = new PartyContact(); partyContact.PartyId = partyId; partyContact.ContactId = contactId; partyContact.ValidFrom = validFrom; partyContact.ValidUntil = validUntil; context.PartyContacts.AddObject(partyContact); context.SaveChanges(); } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void UpdatePartyContact(int partyId, int contactId, DateTime validFrom, DateTime validUntil) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { PartyContact partyContact = (PartyContact) (from pc in context.PartyContacts where (pc.PartyId == partyId && pc.ContactId == contactId) select pc).First(); if (partyContact != null) { partyContact.ValidFrom = validFrom; partyContact.ValidUntil = validUntil; context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void DeletePartyContact(int partyId, int contactId) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { PartyContact partyContact = (from pc in context.PartyContacts where (pc.PartyId == partyId && pc.ContactId == contactId) select pc).First(); if (partyContact != null) { context.DeleteObject(partyContact); context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void UpdateEmail(int id, string type, string address) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Email email = (Email) (from e in context.Contacts where e.Id == id select e).First(); if (email != null) { email.Address = address; email.SubType = type; context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public int CreatePerson(string firstName, string lastName, DateTime dateOfBirth) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Person person = new Person(); person.FirstName = firstName; person.LastName = lastName; person.DateOfBirth = dateOfBirth; person.Type = "P"; context.Parties.AddObject(person); context.SaveChanges(); return(person.Id); } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public SystemConfig GetSystemConfig(string name) { using (PartyEntities context = new PartyEntities(this.connectionString)) { var systemConfigs = from systemConfig in context.SystemConfigs where (systemConfig.Name == name) select systemConfig; if (systemConfigs.Count() == 0) { return(null); } return(systemConfigs.First()); } }
public User GetUser(string name) { using (PartyEntities context = new PartyEntities(this.connectionString)) { var users = from user in context.Users where (user.Name == name) select user; if (users.Count() == 0) { return(null); } return(users.First()); } }
public Party GetParty(int id) { using (PartyEntities context = new PartyEntities(this.connectionString)) { var parties = from party in context.Parties where (party.Id == id) select party; if (parties.Count() == 0) { return(null); } return(parties.First()); } }
public Contact GetContact(int id) { using (PartyEntities context = new PartyEntities(this.connectionString)) { var contacts = from contact in context.Contacts where (contact.Id == id) select contact; if (contacts.Count() == 0) { return(null); } return(contacts.First()); } }
public PartyContact GetPartyContact(int partyId, int contactId) { using (PartyEntities context = new PartyEntities(this.connectionString)) { var partyContacts = from partyContact in context.PartyContacts where (partyContact.PartyId == partyId && partyContact.ContactId == contactId) select partyContact; if (partyContacts.Count() == 0) { return(null); } return(partyContacts.First()); } }
public void DeleteParty(int id) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { using (TransactionScope txnScope = new TransactionScope(TransactionScopeOption.Required)) { Party party = (from p in context.Parties where (p.Id == id) select p).First(); if (party != null) { var partyContacts = from partyContact in context.PartyContacts where (partyContact.PartyId == id) select partyContact; foreach (PartyContact toRemove in partyContacts) { context.DeleteObject(toRemove); context.SaveChanges(); } context.DeleteObject(party); context.SaveChanges(); context.AcceptAllChanges(); txnScope.Complete(); } } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public ContactResults GetContactByPartyId(int partyId, string baseUrl) { using (PartyEntities context = new PartyEntities(this.connectionString)) { ContactResults contactResults = new ContactResults(); var contactQuery = context.ExecuteStoreQuery <ContactSummary>( "execute dbo.GetContactByPartyId {0}", partyId); foreach (ContactSummary contactSummary in contactQuery) { contactSummary.Link = string.Format("{0}contact/{1}", baseUrl, contactSummary.Id); contactResults.ContactList.Add(contactSummary); } return(contactResults); } }
public PartyResults GetPartyByName(string name, string baseUrl) { using (PartyEntities context = new PartyEntities(this.connectionString)) { PartyResults partyResults = new PartyResults(); var nameQuery = context.ExecuteStoreQuery <PartySummary>( "execute dbo.GetPartyByName {0}", name); foreach (PartySummary partySummary in nameQuery) { partySummary.Link = string.Format("{0}/party/{1}", baseUrl, partySummary.Id); partyResults.PartyList.Add(partySummary); } return(partyResults); } }
public int CreateEmail(string type, string address) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Email email = new Email(); email.Address = address; email.SubType = type; email.Type = "E"; context.Contacts.AddObject(email); context.SaveChanges(); return email.Id; } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public int CreateBusiness(string name, string regNumber) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Business business = new Business(); business.Name = name; business.RegNumber = regNumber; business.Type = "B"; context.Parties.AddObject(business); context.SaveChanges(); return business.Id; } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void CreateUser(string name, string fullName, string passwordHash) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { User user = new User(); user.Name = name; user.FullName = fullName; user.PasswordHash = passwordHash; context.Users.AddObject(user); context.SaveChanges(); } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public int CreateAddress(string street, string town, string county, string postCode) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Address address = new Address(); address.Street = street; address.Town = town; address.County = county; address.PostCode = postCode; address.Type = "A"; context.Contacts.AddObject(address); context.SaveChanges(); return address.Id; } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public ContactResults GetContactByPartyId(int partyId, string baseUrl) { using (PartyEntities context = new PartyEntities(this.connectionString)) { ContactResults contactResults = new ContactResults(); var contactQuery = context.ExecuteStoreQuery<ContactSummary>( "execute dbo.GetContactByPartyId {0}", partyId); foreach (ContactSummary contactSummary in contactQuery) { contactSummary.Link = string.Format("{0}contact/{1}", baseUrl, contactSummary.Id); contactResults.ContactList.Add(contactSummary); } return contactResults; } }
public Party GetParty(int id) { using (PartyEntities context = new PartyEntities(this.connectionString)) { var parties = from party in context.Parties where (party.Id == id) select party; if (parties.Count() == 0) { return null; } return parties.First(); } }
public PartyResults GetPartyByName(string name, string baseUrl) { using (PartyEntities context = new PartyEntities(this.connectionString)) { PartyResults partyResults = new PartyResults(); var nameQuery = context.ExecuteStoreQuery<PartySummary>( "execute dbo.GetPartyByName {0}", name); foreach (PartySummary partySummary in nameQuery) { partySummary.Link = string.Format("{0}/party/{1}", baseUrl, partySummary.Id); partyResults.PartyList.Add(partySummary); } return partyResults; } }
public PartyContact GetPartyContact(int partyId, int contactId) { using (PartyEntities context = new PartyEntities(this.connectionString)) { var partyContacts = from partyContact in context.PartyContacts where (partyContact.PartyId == partyId && partyContact.ContactId == contactId) select partyContact; if (partyContacts.Count() == 0) { return null; } return partyContacts.First(); } }
public SystemConfig GetSystemConfig(string name) { using (PartyEntities context = new PartyEntities(this.connectionString)) { var systemConfigs = from systemConfig in context.SystemConfigs where (systemConfig.Name == name) select systemConfig; if (systemConfigs.Count() == 0) { return null; } return systemConfigs.First(); } }
public void CreatePartyContact(int partyId, int contactId, DateTime validFrom, DateTime validUntil) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { PartyContact partyContact = new PartyContact(); partyContact.PartyId = partyId; partyContact.ContactId = contactId; partyContact.ValidFrom = validFrom; partyContact.ValidUntil = validUntil; context.PartyContacts.AddObject(partyContact); context.SaveChanges(); } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void DeletePartyContact(int partyId, int contactId) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { PartyContact partyContact = (from pc in context.PartyContacts where (pc.PartyId == partyId && pc.ContactId == contactId) select pc).First(); if (partyContact != null) { context.DeleteObject(partyContact); context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void UpdateBusiness(int id, string name, string regNumber) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { var business = (Business) (from b in context.Parties where b.Id == id select b).First(); if (business != null) { business.Name = name; business.RegNumber = regNumber; context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void UpdateEmail(int id, string type, string address) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Email email = (Email) (from e in context.Contacts where e.Id == id select e).First(); if (email != null) { email.Address = address; email.SubType = type; context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void UpdatePartyContact(int partyId, int contactId, DateTime validFrom, DateTime validUntil) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { PartyContact partyContact = (PartyContact) (from pc in context.PartyContacts where (pc.PartyId == partyId && pc.ContactId == contactId) select pc).First(); if (partyContact != null) { partyContact.ValidFrom = validFrom; partyContact.ValidUntil = validUntil; context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void UpdatePerson(int id, string firstName, string lastName, DateTime dateOfBirth) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Person person = (Person) (from p in context.Parties where p.Id == id select p).First(); if (person != null) { person.FirstName = firstName; person.LastName = lastName; person.DateOfBirth = dateOfBirth; context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void UpdateTelephone(int id, string type, string number) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Telephone telephone = (Telephone) (from t in context.Contacts where t.Id == id select t).First(); if (telephone != null) { telephone.Number = number; telephone.SubType = type; context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void UpdateUser(string name, string fullName, string passwordHash) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { User user = (User) (from u in context.Users where u.Name == name select u).First(); if (user != null) { user.FullName = fullName; user.PasswordHash = passwordHash; context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public Contact GetContact(int id) { using (PartyEntities context = new PartyEntities(this.connectionString)) { var contacts = from contact in context.Contacts where (contact.Id == id) select contact; if (contacts.Count() == 0) { return null; } return contacts.First(); } }
public void DeleteUser(string name) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { User user = (from u in context.Users where (u.Name == name) select u).First(); if (user != null) { context.DeleteObject(user); context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void UpdateAddress(int id, string street, string town, string county, string postCode) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Address address = (Address) (from a in context.Contacts where a.Id == id select a).First(); if (address != null) { address.Street = street; address.Town = town; address.County = county; address.PostCode = postCode; context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public User GetUser(string name) { using (PartyEntities context = new PartyEntities(this.connectionString)) { var users = from user in context.Users where (user.Name == name) select user; if (users.Count() == 0) { return null; } return users.First(); } }
public void DeleteParty(int id) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { using (TransactionScope txnScope = new TransactionScope(TransactionScopeOption.Required)) { Party party = (from p in context.Parties where (p.Id == id) select p).First(); if (party != null) { var partyContacts = from partyContact in context.PartyContacts where (partyContact.PartyId == id) select partyContact; foreach (PartyContact toRemove in partyContacts) { context.DeleteObject(toRemove); context.SaveChanges(); } context.DeleteObject(party); context.SaveChanges(); context.AcceptAllChanges(); txnScope.Complete(); } } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public int CreateTelephone(string type, string number) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Telephone telephone = new Telephone(); telephone.Number = number; telephone.SubType = type; telephone.Type = "T"; context.Contacts.AddObject(telephone); context.SaveChanges(); return telephone.Id; } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void DeleteContact(int id) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Contact contact = (from ct in context.Contacts where (ct.Id == id) select ct).First(); if (contact != null) { context.DeleteObject(contact); context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public int CreatePerson(string firstName, string lastName, DateTime dateOfBirth) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Person person = new Person(); person.FirstName = firstName; person.LastName = lastName; person.DateOfBirth = dateOfBirth; person.Type = "P"; context.Parties.AddObject(person); context.SaveChanges(); return person.Id; } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void CreateUser(string name, string fullName, string passwordHash) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { User user = new User(); user.Name = name; user.FullName = fullName; user.PasswordHash = passwordHash; context.Users.AddObject(user); context.SaveChanges(); } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }