public void Update(RoleDto item) { using (var ctx = ObjectContextManager <PTrackerEntities> .GetManager("PTrackerEntities")) { var data = (from r in ctx.ObjectContext.Roles where r.Id == item.Id select r).FirstOrDefault(); if (data == null) { throw new DataNotFoundException("Role"); } if (!data.LastChanged.Matches(item.LastChanged)) { throw new ConcurrencyException("Role"); } data.Name = item.Name; var count = ctx.ObjectContext.SaveChanges(); if (count == 0) { throw new UpdateFailureException("Role"); } item.LastChanged = data.LastChanged; } }
public void WorksForObjectContext() { using (var manager = ObjectContextManager <TestObjectContextContainer> .GetManager()) { Assert.IsNotNull(manager); } }
public void MultipleLevelScoping() { ObjectContextManager <TestObjectContextContainer> manager = null; using (manager = ObjectContextManager <TestObjectContextContainer> .GetManager()) { Assert.AreEqual(1, manager.RefCount); using (ObjectContextManager <TestObjectContextContainer> .GetManager()) { Assert.AreEqual(2, manager.RefCount); using (ObjectContextManager <TestObjectContextContainer> .GetManager()) { Assert.AreEqual(3, manager.RefCount); } Assert.AreEqual(2, manager.RefCount); } Assert.AreEqual(1, manager.RefCount); } Assert.AreEqual(0, manager.RefCount); }
private void Child_Insert(Company company, Companies entityCompany) { using (var manager = ObjectContextManager <RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { LoadProperty(CompanyIdProperty, company.CompanyId); RolodexEF.Ranks newRank = GetRank(ReadProperty(RankIdProperty)); var newContact = new CompanyContacts(); newContact.BaseSalary = ReadProperty(BaseSalaryProperty); var birthday = ReadProperty(BirthdayProperty); if (!birthday.IsEmpty) { newContact.Birthday = birthday.Date; } newContact.Companies = entityCompany; newContact.FirstName = ReadProperty(FirstNameProperty); newContact.LastName = ReadProperty(LastNameProperty); newContact.Ranks = newRank; LoadProperty(InitialRankIdProperty, ReadProperty(RankIdProperty)); if (ReadProperty(CompanyContactIdProperty) == 0) { newContact.PropertyChanged += entityContact_PropertyChanged; } DataPortal.UpdateChild(ReadProperty(ContactsPhonesProperty), this, newContact); } }
private void Child_Update(Company company, Companies entityCompany) { using (var manager = ObjectContextManager <RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { RolodexEF.Ranks newRank = GetRank(ReadProperty(RankIdProperty)); RolodexEF.Ranks oldRank = GetRank(ReadProperty(InitialRankIdProperty)); var newContact = new CompanyContacts(); newContact.CompanyContactId = ReadProperty(CompanyContactIdProperty); newContact.EntityKey = new System.Data.EntityKey("RolodexEntities.CompanyContacts", "CompanyContactId", ReadProperty(CompanyContactIdProperty)); manager.ObjectContext.Attach(newContact); entityCompany.CompanyContacts.Attach(newContact); oldRank.CompanyContacts.Attach(newContact); newContact.Ranks = newRank; newContact.BaseSalary = ReadProperty(BaseSalaryProperty); var birthday = ReadProperty(BirthdayProperty); if (!birthday.IsEmpty) { newContact.Birthday = birthday.Date; } else { newContact.Birthday = null; } newContact.FirstName = ReadProperty(FirstNameProperty); newContact.LastName = ReadProperty(LastNameProperty); DataPortal.UpdateChild(ReadProperty(ContactsPhonesProperty), this, newContact); } }
private RolodexEF.Ranks GetRank(int rankID) { using (var manager = ObjectContextManager <RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { RolodexEF.Ranks rank; System.Data.EntityKey rankKey = new System.Data.EntityKey("RolodexEntities.Ranks", "RankId", rankID); System.Data.Objects.ObjectStateEntry entry; if (!manager.ObjectContext.ObjectStateManager.TryGetObjectStateEntry(rankKey, out entry)) { rank = new RolodexEF.Ranks(); rank.RankId = rankID; rank.EntityKey = rankKey; manager.ObjectContext.Attach(rank); } else { rank = entry.Entity as RolodexEF.Ranks; } return(rank); } }
public void Update(AssignmentDto item) { using (var ctx = ObjectContextManager <PTrackerEntities> .GetManager("PTrackerEntities")) { var data = (from r in ctx.ObjectContext.Assignments where r.ProjectId == item.ProjectId && r.ResourceId == item.ResourceId select r).FirstOrDefault(); if (data == null) { throw new DataNotFoundException("Assignment"); } if (!data.LastChanged.Matches(item.LastChanged)) { throw new ConcurrencyException("Assignment"); } data.Assigned = item.Assigned; data.RoleId = item.RoleId; var count = ctx.ObjectContext.SaveChanges(); if (count == 0) { throw new UpdateFailureException("Assignment"); } item.LastChanged = data.LastChanged; } }
protected override void DataPortal_Insert() { using (var manager = ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { var newCompany = new Companies(); newCompany.CompanyName = ReadProperty(CompanyNameProperty); SmartDate added = ReadProperty(DateAddedProperty); if (!added.IsEmpty) { newCompany.DateAdded = added.Date; } DataPortal.UpdateChild(ReadProperty(ContactsProperty), this, newCompany); manager.ObjectContext.AddToCompanies(newCompany); if (ReadProperty(CompanyIdProperty) == 0) { newCompany.PropertyChanged += newCompany_PropertyChanged; } DataPortal.UpdateChild(ReadProperty(ContactsProperty), this, newCompany); manager.ObjectContext.SaveChanges(); LoadProperty(CompanyIdProperty, newCompany.CompanyId); } }
public void ConnectionSetting_with_Invalid_DB_Throws_ConfigurationErrorsException_for_EntitiesContextDataContext() { using (var objectContextManager = ObjectContextManager <DataPortalTestDatabaseEntities> .GetManager(EntityConnectionWithMissingDB, true)) { Assert.IsNotNull(objectContextManager); //Throws EntityException var table = (from p in objectContextManager.ObjectContext.Table2 select p).ToList(); } }
public bool Exists(int id) { using (var ctx = ObjectContextManager <PTrackerEntities> .GetManager("PTrackerEntities")) { var result = (from r in ctx.ObjectContext.Projects where r.Id == id select r.Id).Count() > 0; return(result); } }
public List <RoleDto> Fetch() { using (var ctx = ObjectContextManager <PTrackerEntities> .GetManager("PTrackerEntities")) { var result = from r in ctx.ObjectContext.Roles select new RoleDto { Id = r.Id, Name = r.Name, LastChanged = r.LastChanged }; return(result.ToList()); } }
protected override void DataPortal_Insert() { using (ObjectContextManager <RolodexEntities> manager = ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { RolodexEF.Ranks newRank = new RolodexEF.Ranks(); newRank.Rank = ReadProperty(RankNameProperty); manager.ObjectContext.AddToRanks(newRank); manager.ObjectContext.SaveChanges(); LoadProperty(RankIdProperty, newRank.RankId); } }
protected void DataPortal_Fetch() { RaiseListChangedEvents = false; using (ObjectContextManager <RolodexEntities> manager = ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { foreach (var item in manager.ObjectContext.Ranks) { Add(Rank.GetRank(item)); } } RaiseListChangedEvents = true; }
public DashboardDto Fetch() { var result = new DashboardDto(); using (var ctx = ObjectContextManager <PTrackerEntities> .GetManager("PTrackerEntities")) { result.ProjectCount = ctx.ObjectContext.Projects.Count(); result.OpenProjectCount = ctx.ObjectContext.Projects.Where(r => r.Ended == null).Count(); result.ResourceCount = ctx.ObjectContext.Resources.Count(); } return(result); }
public void Table2_retreived_through_LingToEntitiesDataContext_has_records() { using (var objectContextManager = ObjectContextManager <DataPortalTestDatabaseEntities> .GetManager("DataPortalTestDatabaseEntities", true)) { Assert.IsNotNull(objectContextManager); var query = from p in objectContextManager.ObjectContext.Table2 select p; Assert.IsTrue(query.ToList().Count > 0, "Data in table is missing"); } }
protected override void DataPortal_Update() { using (ObjectContextManager <RolodexEntities> manager = ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { RolodexEF.Ranks newRank = new RolodexEF.Ranks(); newRank.RankId = ReadProperty(RankIdProperty); newRank.EntityKey = new System.Data.EntityKey("RolodexEntities.Ranks", "RankId", newRank.RankId); manager.ObjectContext.Attach(newRank); newRank.Rank = ReadProperty(RankNameProperty); manager.ObjectContext.SaveChanges(); } }
public void Insert(RoleDto item) { using (var ctx = ObjectContextManager <PTrackerEntities> .GetManager("PTrackerEntities")) { var newItem = new Role { Name = item.Name }; ctx.ObjectContext.AddToRoles(newItem); ctx.ObjectContext.SaveChanges(); item.Id = newItem.Id; item.LastChanged = newItem.LastChanged; } }
public void Delete(int projectId, int resourceId) { using (var ctx = ObjectContextManager <PTrackerEntities> .GetManager("PTrackerEntities")) { var data = (from r in ctx.ObjectContext.Assignments where r.ProjectId == projectId && r.ResourceId == resourceId select r).FirstOrDefault(); if (data != null) { ctx.ObjectContext.Assignments.DeleteObject(data); ctx.ObjectContext.SaveChanges(); } } }
private void Child_Update(CompanyContact companyContact, CompanyContacts entityContact) { using (ObjectContextManager <RolodexEntities> manager = ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { CompanyContactPhones newContactPhone = new CompanyContactPhones(); newContactPhone.CompanyContactPhoneId = ReadProperty(CompanyContactPhoneIdProperty); newContactPhone.EntityKey = new System.Data.EntityKey("RolodexEntities.CompanyContactPhones", "CompanyContactPhoneId", ReadProperty(CompanyContactPhoneIdProperty)); manager.ObjectContext.Attach(newContactPhone); entityContact.CompanyContactPhones.Attach(newContactPhone); newContactPhone.FaxNumber = ReadProperty(FaxNumberProperty); newContactPhone.PhoneNumber = ReadProperty(PhoneNumberProperty); } }
private void DataPortal_Fetch() { using (ObjectContextManager <RolodexEntities> manager = ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { RaiseListChangedEvents = false; IsReadOnly = false; foreach (var item in manager.ObjectContext.Ranks) { Add(new Ranks.NameValuePair(item.RankId, item.Rank)); } IsReadOnly = true; RaiseListChangedEvents = true; } }
public void Delete(int id) { using (var ctx = ObjectContextManager <PTrackerEntities> .GetManager("PTrackerEntities")) { var data = (from r in ctx.ObjectContext.Roles where r.Id == id select r).FirstOrDefault(); if (data != null) { ctx.ObjectContext.Roles.DeleteObject(data); ctx.ObjectContext.SaveChanges(); } } }
protected override void DataPortal_DeleteSelf() { if (!this.IsNew) { using (ObjectContextManager <RolodexEntities> manager = ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { RolodexEF.Ranks deleted = new RolodexEF.Ranks(); deleted.RankId = ReadProperty(RankIdProperty); deleted.EntityKey = new System.Data.EntityKey("RolodexEntities.Ranks", "RankId", deleted.RankId); manager.ObjectContext.Attach(deleted); manager.ObjectContext.DeleteObject(deleted); manager.ObjectContext.SaveChanges(); } } }
private void Child_DeleteSelf(CompanyContact companyContact, CompanyContacts entityContact) { if (!this.IsNew) { using (ObjectContextManager <RolodexEntities> manager = ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { CompanyContactPhones deleted = new CompanyContactPhones(); deleted.CompanyContactPhoneId = ReadProperty(CompanyContactPhoneIdProperty); deleted.EntityKey = new System.Data.EntityKey("RolodexEntities.CompanyContactPhones", "CompanyContactPhoneId", deleted.CompanyContactPhoneId); manager.ObjectContext.Attach(deleted); entityContact.CompanyContactPhones.Attach(deleted); manager.ObjectContext.DeleteObject(deleted); } } }
protected override void DataPortal_DeleteSelf() { if (!IsNew) { using (ObjectContextManager <RolodexEntities> manager = ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { Companies deleted = new Companies(); deleted.CompanyId = CompanyId; deleted.EntityKey = new System.Data.EntityKey("RolodexEntities.Companies", "CompanyId", CompanyId); manager.ObjectContext.Attach(deleted); manager.ObjectContext.DeleteObject(deleted); manager.ObjectContext.SaveChanges(); } } }
private void DataPortal_Fetch(LoginCriteria criteria) { if (criteria.IsGuest) { this.FetchGuest(); } else { using (var ctx = ObjectContextManager <ApplicationEntities> .GetManager(Database.SecurityConnection, false)) { IQueryable <Data.User> query = ctx.ObjectContext.Users; query = query.Where(row => row.Name == criteria.Name || row.Email == criteria.Name); var data = query.Select(row => row); if (data.Count() > 0) { var user = data.Single(); if (!string.IsNullOrEmpty(criteria.Password)) { if (PasswordHelper.ComparePasswords( user.Salt, criteria.Password, user.Password)) { this.Fetch(user); } else { throw new SecurityException("User name or password is invalid."); } } else { this.Fetch(user); } } else { throw new SecurityException("User name or password is invalid."); } } } }
private void DataPortal_Fetch() { RaiseListChangedEvents = false; //IsReadOnly = false; using (ObjectContextManager <RolodexEntities> manager = ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { foreach (var item in (from oneCompany in manager.ObjectContext.Companies orderby oneCompany.CompanyName select new { oneCompany.CompanyId, oneCompany.CompanyName })) { Add(ReadOnlyCompany.GetReadOnlyCompany(item.CompanyId, item.CompanyName)); } } //IsReadOnly = true; RaiseListChangedEvents = true; }
public void Insert(AssignmentDto item) { using (var ctx = ObjectContextManager <PTrackerEntities> .GetManager("PTrackerEntities")) { var newItem = new Assignment { ProjectId = item.ProjectId, ResourceId = item.ResourceId, Assigned = item.Assigned, RoleId = item.RoleId }; ctx.ObjectContext.AddToAssignments(newItem); ctx.ObjectContext.SaveChanges(); item.LastChanged = newItem.LastChanged; } }
public RoleDto Fetch(int id) { using (var ctx = ObjectContextManager <PTrackerEntities> .GetManager("PTrackerEntities")) { var result = (from r in ctx.ObjectContext.Roles where r.Id == id select new RoleDto { Id = r.Id, Name = r.Name, LastChanged = r.LastChanged }).FirstOrDefault(); if (result == null) { throw new DataNotFoundException("Role"); } return(result); } }
private void Child_Insert(CompanyContact companyContact, CompanyContacts entityContact) { using (ObjectContextManager <RolodexEntities> manager = ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { LoadProperty(CompanyContactIdProperty, companyContact.CompanyContactId); CompanyContactPhones newContactPhone = new CompanyContactPhones(); newContactPhone.FaxNumber = ReadProperty(FaxNumberProperty); newContactPhone.PhoneNumber = ReadProperty(PhoneNumberProperty); newContactPhone.CompanyContacts = entityContact; manager.ObjectContext.AddToCompanyContactPhones(newContactPhone); newContactPhone.PropertyChanged += newContactPhone_PropertyChanged; if (ReadProperty(CompanyContactIdProperty) == 0) { entityContact.PropertyChanged += entityContact_PropertyChanged; } } }
private void Child_DeleteSelf(Company company, Companies entityCompany) { if (!IsNew) { using (var manager = ObjectContextManager <RolodexEntities> .GetManager(DataConnection.EFConnectionName, true)) { var deleted = new CompanyContacts(); deleted.CompanyContactId = ReadProperty(CompanyContactIdProperty); deleted.EntityKey = new System.Data.EntityKey("RolodexEntities.CompanyContacts", "CompanyContactId", deleted.CompanyContactId); manager.ObjectContext.Attach(deleted); entityCompany.CompanyContacts.Attach(deleted); manager.ObjectContext.DeleteObject(deleted); } } }