public ActionResult MiniProfiler()
{
using(var context = new EFContext())
{
var customer = context.Customers.First();
}
return View();
}
public ICollection<VentaPauta> ListarTodos()
{
using (EFContext db = new EFContext(ConexionUtil.ObtenerCadena()))
{
var resultado = from l in db.VentaPauta
select l;
return resultado.ToList();
}
}
private static void InitializeDB()
{
console.WriteOutputOnNewLine("\nInitializing the db....");
using (var ctx = new EFContext())
{
var dummyUser = ctx.Set<User>().FirstOrDefault();
}
console.WriteOutputOnNewLine("\nInitializing db has been completed....");
}
/// <summary>
/// Obtener empresa
/// </summary>
/// <param name="Codigo">Codigo del Empresa</param>
/// <returns></returns>
public Empresa Obtener(int Codigo)
{
using (EFContext db = new EFContext(ConexionUtil.ObtenerCadena()))
{
var empresa = from l in db.Empresa
where l.Codigo == Codigo
select l;
return empresa.SingleOrDefault();
}
}
/// <summary>
/// Obtener ventapauta
/// </summary>
/// <param name="Codigo">Codigo de ventapauta</param>
/// <returns></returns>
public VentaPauta Obtener(int Codigo)
{
using (EFContext db = new EFContext(ConexionUtil.ObtenerCadena()))
{
var ventapauta = from l in db.VentaPauta
where l.Codigo == Codigo
select l;
return ventapauta.SingleOrDefault();
}
}
public List<Models.Product> GetAll()
{
using (var context = new EFContext())
{
var query = from x in context.Products
select x;
var result = MappingProduct(query);
return result;
}
}
/// <summary>
/// Crear VentaPauta
/// </summary>
/// <param name="EmpresaACrear">Dominio VentaPauta</param>
/// <returns>Dominio VentaPauta</returns>
public VentaPauta Crear(VentaPauta VentaPautaACrear)
{
using (EFContext db = new EFContext(ConexionUtil.ObtenerCadena()))
{
int? codigo = db.VentaPauta.Select(l => (int?)l.Codigo).Max();
VentaPautaACrear.Codigo = (codigo ?? 0) + 1;
db.VentaPauta.Add(VentaPautaACrear);
db.SaveChanges();
}
return Obtener(VentaPautaACrear.Codigo);
}
public void Eliminar(Empresa itemEliminar)
{
using (EFContext db = new EFContext(ConexionUtil.ObtenerCadena()))
{
Empresa empresa = (from s in db.Empresa
where s.Codigo == itemEliminar.Codigo
select s).Single();
db.Empresa.Remove(empresa);
db.SaveChanges();
}
}
/// <summary>
/// Crear Empresa
/// </summary>
/// <param name="EmpresaACrear">Dominio Empresa</param>
/// <returns>Dominio Empresa</returns>
public Empresa Crear(Empresa EmpresaACrear)
{
using (EFContext db = new EFContext(ConexionUtil.ObtenerCadena()))
{
int? codigo = db.Empresa.Select(l => (int?)l.Codigo).Max();
EmpresaACrear.Codigo = (codigo ?? 0) + 1;
db.Empresa.Add(EmpresaACrear);
db.SaveChanges();
}
return Obtener(EmpresaACrear.Codigo);
}
public List<Models.Product> GetByCodeAutocomplete(string code)
{
using (var context = new EFContext())
{
var query = from x in context.Products
where x.Code.StartsWith(code)
select x;
var result = MappingProduct(query);
return result;
}
}
public Usuario ObtenerPorParametros(Usuario UsuarioAObtener)
{
using (EFContext db = new EFContext(ConexionUtil.ObtenerCadena()))
{
var usuario = from l in db.Usuario
where l.User == UsuarioAObtener.User &&
l.Password == UsuarioAObtener.Password &&
l.Estado == "A"
select l;
return usuario.SingleOrDefault();
}
}
public EFContactRepository()
{
try
{
_db = new EFContext();
DataSet = _db.Contacts;
}
catch (Exception ex)
{
Log.Error(ex.Message);
throw;
}
}
public Empresa Modificar(Empresa itemAModificar)
{
using (EFContext db = new EFContext(ConexionUtil.ObtenerCadena()))
{
Empresa empresa = db.Empresa.Single(l => l.Codigo == itemAModificar.Codigo);
empresa.RUC = itemAModificar.RUC;
empresa.nombrecomercial = itemAModificar.nombrecomercial;
empresa.direccion = itemAModificar.direccion;
empresa.telefono = itemAModificar.telefono;
empresa.Estado = itemAModificar.Estado;
db.SaveChanges();
return empresa;
}
}
public VentaPauta Modificar(VentaPauta itemAModificar)
{
using (EFContext db = new EFContext(ConexionUtil.ObtenerCadena()))
{
VentaPauta ventapauta = db.VentaPauta.Single(l => l.Codigo == itemAModificar.Codigo);
ventapauta.Codigo = itemAModificar.Codigo;
ventapauta.ventaEstado = itemAModificar.ventaEstado;
ventapauta.ventaUsuarioModif = itemAModificar.ventaUsuarioModif;
ventapauta.ventaFechaModif = itemAModificar.ventaFechaModif;
ventapauta.ventaEstado = itemAModificar.ventaEstado;
db.SaveChanges();
return ventapauta;
}
}
private void AssertCars()
{
var cars = new EFContext().Cars.Include(ReflectionHelper
.GetPropertyName<Car, Admin>(e => e.Admin)).ToArray();
Assert.AreEqual(2, cars.Length);
Assert.AreEqual(admin.Id, cars[0].Admin.Id);
Assert.AreEqual(car1.Id, cars[0].Id);
Assert.AreEqual("data", cars[0].Data);
Assert.AreEqual(admin.Id, cars[1].Admin.Id);
Assert.AreEqual(car2.Id, cars[1].Id);
Assert.AreEqual("data", cars[1].Data);
}
public void CustomerOrderTest()
{
System.Data.Entity.Database.SetInitializer<EFContext>(new CreateDatabaseIfNotExists<EFContext>());
using (var context = new EFContext())
{
context.Database.CreateIfNotExists();
Customer customer = new Customer
{
Name = "Raviendra",
Email = "*****@*****.**",
};
context.Entry(customer).State = (EntityState) System.Data.EntityState.Added;
context.SaveChanges();
}
}
static void Main(string[] args)
{
ObjectFactory.Initialize(x=>
{
x.For<IEFContext>().HybridHttpOrThreadLocalScoped().Use<EFContext>().Ctor<string>("connectionString").Is("Name=con"); ;
x.For<IUserRepository>().Use<UserRepository>();
x.For<IBookRepository>().Use<BookRepository>();
x.For<IAuthorRepository>().Use<AuthorRepository>();
});
//Database.SetInitializer(new DropCreateDatabaseAlways<EFContext>());
//var db = ObjectFactory.GetInstance<IEFContext>();
var db = new EFContext(System.Configuration.ConfigurationManager.ConnectionStrings["con"].ConnectionString);
var a = db.Borrowers.ToList();
foreach (var author in a)
{
Console.WriteLine(author.Comment);
}
}
private void AssertCars()
{
var cars = new EFContext().Cars.ToArray();
Assert.AreEqual(2, cars.Length);
Assert.AreEqual(admin.Id, cars[0].AdminId);
Assert.AreEqual(car1.Id, cars[0].Id);
Assert.AreEqual(initializingDate, cars[0].CreatedOn);
Assert.AreEqual(initializingDate, cars[0].LastUpdateOn);
Assert.AreEqual("data", cars[0].Data);
Assert.AreEqual(admin.Id, cars[1].AdminId);
Assert.AreEqual(car2.Id, cars[1].Id);
Assert.AreEqual(initializingDate, cars[1].CreatedOn);
Assert.AreEqual(initializingDate, cars[1].LastUpdateOn);
Assert.AreEqual("data", cars[1].Data);
}
public void TestInitialize()
{
initializingDate = DateTime.UtcNow;
EFContext.ClearDatabase();
var context = new EFContext();
admin = new Admin() { Data = "data", CreatedOn = initializingDate, LastUpdateOn = initializingDate };
context.Admins.Add(admin);
office1 = new Office() { Data = "data", Admin = admin, CreatedOn = initializingDate, LastUpdateOn = initializingDate };
office2 = new Office() { Data = "data", Admin = admin, CreatedOn = initializingDate, LastUpdateOn = initializingDate };
context.Offices.Add(office1);
context.Offices.Add(office2);
car1 = new Car() { Data = "data", Admin = admin, CreatedOn = initializingDate, LastUpdateOn = initializingDate };
car2 = new Car() { Data = "data", Admin = admin, CreatedOn = initializingDate, LastUpdateOn = initializingDate };
context.Cars.Add(car1);
context.Cars.Add(car2);
project1 = new Project() { Data = "data", Admin = admin, CreatedOn = initializingDate, LastUpdateOn = initializingDate };
project2 = new Project() { Data = "data", Admin = admin, CreatedOn = initializingDate, LastUpdateOn = initializingDate };
context.Projects.Add(project1);
context.Projects.Add(project2);
director = new Director() { Data = "data", CreatedOn = initializingDate, LastUpdateOn = initializingDate };
context.Directors.Add(director);
directorTracker = new DirectorTracker()
{
Data = "data",
Director = director,
CreatedOn = initializingDate,
LastUpdateOn = initializingDate
};
context.DirectorTrackers.Add(directorTracker);
context.SaveChanges();
}
public OrderSubtotalRepository(EFContext context)
: base(context)
{
}
public AnswerRepository(EFContext context)
: base(context)
{
}
/// <summary>
/// The EF code first.
/// </summary>
/// <returns>the entity framework code first view.</returns>
public ActionResult EFCodeFirst()
{
int count;
int? newCount = null;
EFContext context = null;
using (MiniProfiler.Current.Step("EF Stuff"))
{
try
{
using (MiniProfiler.Current.Step("Create Context"))
context = new EFContext();
// this is not correct, as the count from this assignment is never actually used
using (MiniProfiler.Current.Step("First count"))
count = context.People.Count();
using (MiniProfiler.Current.Step("Insertion"))
{
var p = new Person { Name = "sam" };
context.People.Add(p);
context.SaveChanges();
}
// this count is actually used.
using (MiniProfiler.Current.Step("Second count"))
count = context.People.Count();
const string sql = "Select count(*) from People";
using (MiniProfiler.Current.Step("Get Count from SqlQuery Method - no sql recorded"))
{
newCount = context.Database.SqlQuery<int>(sql).Single();
}
using (MiniProfiler.Current.Step("Get Count using ProfiledConnection - sql recorded"))
{
using (var conn = new ProfiledDbConnection(context.Database.Connection, MiniProfiler.Current))
{
conn.Open();
newCount = conn.Query<int>(sql).Single();
conn.Close();
}
}
}
finally
{
if (context != null)
{
context.Dispose();
}
}
}
return Content(string.Format("EF Code First complete - count: {0}, sqlQuery count {1}", count, newCount));
}
public EFUnitOfWorkManager(IEFContext context)
{
Database.SetInitializer<EFContext>(null);
_context = context as EFContext;
}
/// <summary>
/// The EF code first.
/// </summary>
/// <returns>the entity framework code first view.</returns>
public ActionResult EFCodeFirst()
{
int count;
EFContext context = null;
using (MiniProfiler.Current.Step("EF Stuff"))
{
try
{
using (MiniProfiler.Current.Step("Create Context"))
context = new EFContext();
// this is not correct, as the count from this assignment is never actually used
using (MiniProfiler.Current.Step("First count"))
count = context.People.Count();
using (MiniProfiler.Current.Step("Insertion"))
{
var p = new Person { Name = "sam" };
context.People.Add(p);
context.SaveChanges();
}
// this count is actually used.
using (MiniProfiler.Current.Step("Second count"))
count = context.People.Count();
}
finally
{
if (context != null)
{
context.Dispose();
}
}
}
return Content("EF Code First complete - count: " + count);
}
public UserRepository(EFContext context)
{
this.context = context;
}
//
// GET: /Home/
public ActionResult Index()
{
var hej = new EFContext().Restaurants;
return View();
}
public void Add_WithAllSubEntitiesAndRequiredUsedEntities_Succeeds()
{
//Arrange
var repository = new EFRepositoryTester();
repository.Initialize();
var addingDate = DateTime.UtcNow;
var manager = new Manager()
{
Director = director,
ManagerTrackers = new List<ManagerTracker>()
{
new ManagerTracker()
},
Office = office1,
Computer = new Computer() { Data = "data", Admin = admin },
Things = new List<Thing>()
{
new Thing()
{
Id = 1,
Admin = admin,
Data = "data"
},
new Thing()
{
Id = 2,
Admin = admin,
Data = "data"
}
},
Description = new Description()
{
Data = "data"
},
Data = "data"
};
//Act
repository.Add(new AddOperationParameters<Manager>()
{
Entity = manager,
OperationDateTime = addingDate
});
//Assert
var context = new EFContext();
var managers = context.Managers.ToArray();
var computers = context.Computers.ToArray();
var things = context.Things.ToArray();
var descriptions = context.Descriptions.ToArray();
AssertUsingEntities();
AssertSecondLevelUsedEntities();
//Sub entities
AssertComputers(addingDate, addingDate, "data", false);
AssertDescriptions(addingDate, addingDate, "data", false);
Assert.AreEqual(2, things.Length);
AssertThing(things[0], addingDate, addingDate, "data", managers[0].Id, false);
AssertThing(things[1], addingDate, addingDate, "data", managers[0].Id, false);
//Main entity
Assert.AreEqual(1, managers.Length);
Assert.AreEqual("data", managers[0].Data);
Assert.AreEqual(addingDate, managers[0].CreatedOn);
Assert.AreEqual(addingDate, managers[0].LastUpdateOn);
Assert.AreEqual(null, managers[0].CarId);
Assert.AreEqual(computers[0].Id, managers[0].ComputerId);
Assert.AreEqual(descriptions[0].Id, managers[0].DescriptionId);
Assert.AreEqual(null, managers[0].DirectorId);
Assert.AreEqual(false, managers[0].IsDeleted);
Assert.AreEqual(office1.Id, managers[0].OfficeId);
//First level used entities
AssertOffices();
}
public OrderSubtotalRepository(EFContext context, string safeCode)
: base(context, safeCode)
{
}
public void Get_WithAllRelatedEntities_ReturnsEntities()
{
//Arrange
var repository = new EFRepositoryTester();
repository.Initialize();
var manager = new Manager()
{
Director = director,
ManagerTrackers = new List<ManagerTracker>()
{
new ManagerTracker()
},
Office = office1,
Computer = new Computer() { Data = "data", Admin = admin },
Things = new List<Thing>()
{
new Thing()
{
Id = 1,
Admin = admin,
Data = "data"
},
new Thing()
{
Id = 2,
Admin = admin,
Data = "data"
}
},
Description = new Description()
{
Data = "data"
},
Data = "data",
Car = car1,
Projects = new List<Project>()
{
project1,
//project2
}
};
repository.Add(new AddOperationParameters<Manager>()
{
Entity = manager,
OperationDateTime = initializingDate
});
//Attach using entities
var context = new EFContext();
context.Directors.Attach(director);
context.Managers.Attach(manager);
director.Managers = new List<Manager>();
director.Managers.Add(manager);
context.ManagerTrackers.Add(new ManagerTracker()
{
Manager = manager,
Data = "data"
});
context.SaveChanges();
//Act
var entities = repository.Get(new GetOperationParameters()
{
LoadSubEntities = true,
LoadUsedEntities = true,
LoadUsingEntities = true,
});
//Assert
Assert.AreEqual(true, entities[0].IsUsed);
AssertUsingEntities();
AssertSecondLevelUsedEntities();
//Sub entities
Assert.AreEqual(1, entities.Length);
Assert.AreEqual("data", entities[0].Computer.Data);
Assert.AreEqual(admin.Id, entities[0].Computer.Admin.Id);
Assert.AreEqual("data", entities[0].Description.Data);
Assert.AreEqual("data", entities[0].Things[0].Data);
Assert.AreEqual(admin.Id, entities[0].Things[0].Admin.Id);
Assert.AreEqual(entities[0].Id, entities[0].Things[0].Manager.Id);
Assert.AreEqual("data", entities[0].Things[1].Data);
Assert.AreEqual(admin.Id, entities[0].Things[1].Admin.Id);
Assert.AreEqual(entities[0].Id, entities[0].Things[1].Manager.Id);
//Main entity
Assert.AreEqual("data", entities[0].Data);
Assert.AreEqual(car1.Id, entities[0].Car.Id);
Assert.AreEqual(director.Id, entities[0].Director.Id);
Assert.AreEqual(office1.Id, entities[0].Office.Id);
//First level used entities
Assert.AreEqual(office1.Id, entities[0].Office.Id);
Assert.AreEqual("data", entities[0].Office.Data);
Assert.AreEqual(admin.Id, entities[0].Car.Admin.Id);
Assert.AreEqual(car1.Id, entities[0].Car.Id);
Assert.AreEqual("data", entities[0].Car.Data);
Assert.AreEqual(admin.Id, entities[0].Projects[0].Admin.Id);
Assert.AreEqual(project1.Id, entities[0].Projects[0].Id);
Assert.AreEqual("data", entities[0].Projects[0].Data);
Assert.AreEqual(manager.Id, entities[0].Projects[0].Manager.Id);
//Assert.AreEqual(admin.Id, entities[0].Projects[1].AdminId);
//Assert.AreEqual(project2.Id, entities[0].Projects[1].Id);
//Assert.AreEqual(initializingDate, entities[0].Projects[1].CreatedOn);
//Assert.AreEqual(initializingDate, entities[0].Projects[1].LastUpdateOn);
//Assert.AreEqual("data", entities[0].Projects[1].Data);
//Assert.AreEqual(false, entities[0].Projects[1].IsDeleted);
//Assert.AreEqual(manager.Id, entities[0].Projects[1].ManagerId);
//Using entities
Assert.AreEqual("data", entities[0].ManagerTrackers[0].Data);
Assert.AreEqual(manager.Id, entities[0].ManagerTrackers[0].Manager.Id);
//Get result
}
public void Update_WithAllSubEntitiesAndAllUsedEntities_UpdateAllEntities_Succeeds()
{
//Arrange
var repository = new EFRepositoryTester();
repository.Initialize();
var addingDate = DateTime.UtcNow;
var manager = new Manager()
{
Director = director,
ManagerTrackers = new List<ManagerTracker>()
{
new ManagerTracker()
},
Office = office1,
Computer = new Computer() { Data = "data", Admin = admin },
Things = new List<Thing>()
{
new Thing()
{
Id = 1,
Admin = admin,
Data = "data"
},
new Thing()
{
Id = 2,
Admin = admin,
Data = "data"
}
},
Description = new Description()
{
Data = "data"
},
Data = "data",
Car = car1,
Projects = new List<Project>()
{
project1
}
};
repository.Add(new AddOperationParameters<Manager>()
{
Entity = manager,
OperationDateTime = addingDate
});
//Act
director.Data = "data100";
office1.Data = "data100";
office2.Data = "data100";
admin.Data = "data100";
car1.Data = "data100";
project1.Data = "data100";
project2.Data = "data100";
var updatingDate = DateTime.UtcNow;
manager.Data = "data1";
manager.Computer.Data = "data1";
manager.Description.Data = "data1";
manager.Office = office2;
manager.Things.RemoveAt(1);
manager.Things[0].Data = "data1";
manager.Things.Add(new Thing() { Admin = admin, Data = "data" });
manager.Car = car2;
manager.Projects.Clear();
manager.Projects.Add(project2);
repository.Update(new UpdateOperationParameters<Manager>()
{
Entity = manager,
OperationDateTime = updatingDate
});
//Assert
var context = new EFContext();
var managers = context.Managers.ToArray();
var computers = context.Computers.ToArray();
var things = context.Things.ToArray();
var descriptions = context.Descriptions.ToArray();
AssertUsingEntities();
AssertSecondLevelUsedEntities();
//Sub entities
AssertComputers(addingDate, updatingDate, "data1", false);
AssertDescriptions(addingDate, updatingDate, "data1", false);
Assert.AreEqual(3, things.Length);
AssertThing(things[0], addingDate, updatingDate, "data1", managers[0].Id, false);
AssertThing(things[1], addingDate, updatingDate, "data", managers[0].Id, true);
AssertThing(things[2], updatingDate, updatingDate, "data", managers[0].Id, false);
//Main entity
Assert.AreEqual(1, managers.Length);
Assert.AreEqual("data1", managers[0].Data);
Assert.AreEqual(addingDate, managers[0].CreatedOn);
Assert.AreEqual(updatingDate, managers[0].LastUpdateOn);
Assert.AreEqual(car2.Id, managers[0].CarId);
Assert.AreEqual(computers[0].Id, managers[0].ComputerId);
Assert.AreEqual(descriptions[0].Id, managers[0].DescriptionId);
Assert.AreEqual(null, managers[0].DirectorId);
Assert.AreEqual(false, managers[0].IsDeleted);
Assert.AreEqual(office2.Id, managers[0].OfficeId);
//First level used entities
AssertOffices();
AssertCars();
AssertProjects(null, manager.Id);
}
public void Update_WithRequiredSubEntitiesAndRequiredUsedEntities_UpdateAllEntities_Succeeds()
{
//Arrange
var repository = new EFRepositoryTester();
repository.Initialize();
var addingDate = DateTime.UtcNow;
var manager = new Manager()
{
Director = director,
ManagerTrackers = new List<ManagerTracker>()
{
new ManagerTracker()
},
Office = office1,
Computer = new Computer() { Data = "data", Admin = admin },
Data = "data"
};
repository.Add(new AddOperationParameters<Manager>()
{
Entity = manager,
OperationDateTime = addingDate
});
//Act
director.Data = "data100";
office1.Data = "data100";
office2.Data = "data100";
admin.Data = "data100";
var updatingDate = DateTime.UtcNow;
manager.Data = "data1";
manager.Computer.Data = "data1";
manager.Office = office2;
repository.Update(new UpdateOperationParameters<Manager>()
{
Entity = manager,
OperationDateTime = updatingDate
});
//Assert
var context = new EFContext();
var managers = context.Managers.ToArray();
var computers = context.Computers.ToArray();
AssertUsingEntities();
AssertSecondLevelUsedEntities();
//Sub entities
AssertComputers(addingDate, updatingDate, "data1", false);
//Main entity
Assert.AreEqual(1, managers.Length);
Assert.AreEqual("data1", managers[0].Data);
Assert.AreEqual(addingDate, managers[0].CreatedOn);
Assert.AreEqual(updatingDate, managers[0].LastUpdateOn);
Assert.AreEqual(null, managers[0].CarId);
Assert.AreEqual(computers[0].Id, managers[0].ComputerId);
Assert.AreEqual(null, managers[0].DescriptionId);
Assert.AreEqual(null, managers[0].DirectorId);
Assert.AreEqual(false, managers[0].IsDeleted);
Assert.AreEqual(office2.Id, managers[0].OfficeId);
//First level used entities
AssertOffices();
}
public UserDal(EFContext context)
{
_context = context;
}
public void Get_WithUsingEntities_IsUsedIsTrue()
{
//Arrange
var repository = new EFRepositoryTester();
repository.Initialize();
var manager = new Manager()
{
Director = director,
ManagerTrackers = new List<ManagerTracker>()
{
new ManagerTracker()
},
Office = office1,
Computer = new Computer() { Data = "data", Admin = admin },
Things = new List<Thing>()
{
new Thing()
{
Id = 1,
Admin = admin,
Data = "data"
},
new Thing()
{
Id = 2,
Admin = admin,
Data = "data"
}
},
Description = new Description()
{
Data = "data"
},
Data = "data",
Car = car1,
Projects = new List<Project>()
{
project1,
//project2
}
};
repository.Add(new AddOperationParameters<Manager>()
{
Entity = manager,
OperationDateTime = initializingDate
});
//Attach using entities
var context = new EFContext();
context.Directors.Attach(director);
context.Managers.Attach(manager);
director.Managers = new List<Manager>();
director.Managers.Add(manager);
context.ManagerTrackers.Add(new ManagerTracker()
{
Manager = manager,
Data = "data"
});
context.SaveChanges();
//Act
var entities = repository.Get(new GetOperationParameters()
{
LoadSubEntities = true,
LoadUsedEntities = true,
LoadUsingEntities = true,
});
//Assert
Assert.AreEqual(true, entities[0].IsUsed);
}
public UserController(EFContext eFContext)
{
contex = eFContext;
}
