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);
}
}
}
