public ComponentDto Fetch(string pdNumber)
{
using (var ctx = DbContextManager <Reco3Xml2DbContext> .GetManager(_dbName)) {
var result = (from r in ctx.DbContext.Components
where r.PDNumber == pdNumber
select new ComponentDto {
ComponentId = r.ComponentId,
PDNumber = r.PDNumber,
DownloadedTimestamp = r.DownloadedTimestamp,
Description = r.Description,
PDStatus = r.PD_Status,
ComponentType = r.Component_Type,
Xml = r.XML,
PDSource = r.PD_Source,
SourceComponentId = r.SourceComponentId
}).FirstOrDefault();
return(result);
}
}
public List <ComponentDto> FetchAllWSamePDNumber(string pdNumber)
{
using (var ctx = DbContextManager <Reco3Xml2DbContext> .GetManager(_dbName)) {
var result = from r in ctx.DbContext.Components
where r.PDNumber.Contains(pdNumber)
select new ComponentDto {
ComponentId = r.ComponentId,
PDNumber = r.PDNumber,
DownloadedTimestamp = r.DownloadedTimestamp,
Description = r.Description,
PDStatus = r.PD_Status,
ComponentType = r.Component_Type,
Xml = r.XML,
PDSource = r.PD_Source,
SourceComponentId = r.SourceComponentId
};
return(result.ToList());
}
}
protected void DataPortal_Fetch(int id)
{
using (BypassPropertyChecks)
{
using (var contexto = DbContextManager <Colegio> .GetManager())
{
var registro = contexto.DbContext.Alumnos.Find(id);
if (registro == null)
{
throw new InvalidOperationException("El registro no existe");
}
Id = registro.Id;
Nombres = registro.Nombres;
Apellidos = registro.Apellidos;
Edad = registro.Edad;
}
}
}
public List <RoadmapGroupDto> Fetch()
{
using (var ctx = DbContextManager <Reco4Context> .GetManager(_dbName)) {
var result = from r in ctx.DbContext.RoadmapGroups
select new RoadmapGroupDto {
RoadmapGroupId = r.RoadmapGroupId,
OwnerSss = r.OwnerSss,
RoadmapName = r.RoadmapName,
Protected = r.Protected,
CreationTime = r.CreationTime,
StartYear = r.StartYear,
EndYear = r.EndYear,
Xml = r.Xml,
ValidationStatusValue = r.Validation_Status,
ConvertToVehicleInputStatusValue = r.ConvertToVehicleInput_Status
};
return(result.ToList());
}
}
public void ConnectionSetting_with_Invalid_DB_Throws_ConfigurationErrorsException_for_DbContextDataContext()
{
var conn = ConfigurationManager.ConnectionStrings[EntityConnectionWithMissingDB].ConnectionString;
using (var context = new DataPortalTestDatabaseEntities(conn))
{
using (
var dbContextManager = DbContextManager <DataPortalDbContext> .GetManager(context))
{
Assert.IsNotNull(dbContextManager);
// Make sure the context is set in DbContext
Assert.AreSame(context, ((IObjectContextAdapter)dbContextManager.DbContext).ObjectContext);
//Throws EntityException
var table = (from p in context.Table2
select p).ToList();
}
}
}
public List <OrderDto> Fetch(int idCustomer)
{
using (var ctx = DbContextManager <ModelContainer> .GetManager())
{
var result = from o in ctx.DbContext.Orders
where o.Enable.Equals(true) && o.CustomerIdCustomer.Equals(idCustomer)
orderby o.OrderDate
select new OrderDto
{
IdCustomer = o.CustomerIdCustomer,
Id = o.OrderId,
OrderDate = o.OrderDate,
Status = o.Status,
ShippedDate = o.ShippedDate,
ReceivedDate = o.ReceivedDate
};
return(result.ToList());
}
}
/// <summary>
/// select an item from persistent store for given key
/// </summary>
/// <param name="aId"></param>
/// <returns></returns>
public D_ARK_ENTITY SelectItem(K_ARK_ENTITY aKey)
{
#if (NOTYET)
using (var ctx = DbContextManager <RepositoryModel.ApocFormsEntities> .GetManager())
{
var lQuery = (from item in ctx.DbContext.ARK_ENTITY
select new D_ARK_ENTITY
{
object_id = item.id,
event_dts = item.event_dts,
logger_nm = item.logger_nm,
thread_nm = item.thread_nm,
log_level_cd = item.log_level_cd,
apoc_user_nm = item.apoc_user_nm,
apoc_user_id = item.apoc_user_id,
apoc_form_nm = item.apoc_form_nm,
apoc_form_id = item.apoc_form_id,
location_txt = item.location_txt,
browser_nm = item.browser_nm,
request_url = item.request_url,
referrer_url = item.referrer_url,
message_txt = item.message_txt,
stack_trace = item.stack_trace,
active_yn = item.active_yn,
create_by_uid = item.create_by_uid,
create_on_dts = item.create_on_dts,
update_by_uid = item.update_by_uid,
update_on_dts = item.update_on_dts,
version_key = item.version_key
});
if (aKey.object_id.HasValue)
{
lQuery = lQuery.Where(x => x.object_id == aKey.object_id.Value);
}
return(lQuery.FirstOrDefault());
}
#else
return(new D_ARK_ENTITY());
#endif
}
public void Insert(ComponentDto data)
{
using (var ctx = DbContextManager <Reco3Xml2DbContext> .GetManager(_dbName)) {
var item = new Reco3Component {
ComponentId = data.ComponentId,
PDNumber = data.PDNumber,
DownloadedTimestamp = data.DownloadedTimestamp,
Description = data.Description,
PD_Status = data.PDStatus,
Component_Type = data.ComponentType,
XML = data.Xml,
PD_Source = data.PDSource,
SourceComponentId = data.SourceComponentId
};
ctx.DbContext.Components.Add(item);
ctx.DbContext.SaveChanges();
data.ComponentId = item.ComponentId;
}
}
protected override void DataPortal_Update()
{
using (var ctx = DbContextManager <Colegio> .GetManager())
{
var entidad = ctx.DbContext.Set <Alumno>().Find(Id);
if (entidad == null)
{
throw new InvalidOperationException("No se encuentra el registro");
}
entidad.Nombres = Nombres;
entidad.Apellidos = Apellidos;
entidad.Edad = Edad;
ctx.DbContext.Set <Alumno>().Attach(entidad);
ctx.DbContext.Entry(entidad).State = EntityState.Modified;
ctx.DbContext.SaveChanges();
}
}
private void DataPortal_Fetch(string criteria)
{
// TODO: load values
using (var ctx = DbContextManager <SeguridadEntities> .GetManager(BaseDatos.ConexionBD))
{
var q = ctx.DbContext.SelectEmpresa(criteria).FirstOrDefault();
if (q != null)
{
Id = q.IdEmpresa;
Codigo = q.CodigoEmpresa;
RazonSocial = q.RazonSocial;
NombreCorto = q.NombreCorto;
RUC = q.RUC;
}
else
{
throw new InvalidOperationException("No se encontró el registro");
}
}
}
private void DataPortal_Fetch(string criteria)
{
using (var ctx = DbContextManager <SeguridadEntities> .GetManager(BaseDatos.ConexionBD))
{
var app = ctx.DbContext.SelectAplicacion(criteria).FirstOrDefault();
if (app != null)
{
ID = app.IdAplicacion;
Nombre = app.NombreAplicacion;
Acronimo = app.Acronimo;
URI = app.Uri;
Tipo = app.Tipo;
ApplicationContext.LocalContext["AcronimoApp"] = Acronimo;
}
else
{
throw new InvalidOperationException("No se encontró el registro");
}
}
}
public async Task <bool> ResetPasswordAsync(string userName, string newPassword)
{
using (var dbContextManager = DbContextManager <LicenseManagerDbContext> .GetManager())
{
var userManager = new UserManager <User>(new UserStore <User>(dbContextManager.Context));
var user = await userManager.FindByNameAsync(userName);
if (user == null)
{
return(false);
}
await userManager.RemovePasswordAsync(user.Id);
await userManager.AddPasswordAsync(user.Id, newPassword);
return(true);
}
}
public List <OrderDetailDto> Fetch(Guid orderId)
{
using (var ctx = DbContextManager <ModelContainer> .GetManager())
{
var result = from o in ctx.DbContext.OrderDetails
where o.OrderOrderId.Equals(orderId)
orderby o.LineNo
select new OrderDetailDto
{
OrderId = o.OrderOrderId,
Id = o.OrderDetailId,
LineNo = o.LineNo,
Item = o.Item,
Price = o.Price,
Qty = o.Qty,
Discount = o.Discount
};
return(result.ToList());
}
}
public void Insert(RoadmapGroupDto data)
{
using (var ctx = DbContextManager <Reco4Context> .GetManager(_dbName)) {
var item = new RoadmapGroup {
OwnerSss = data.OwnerSss,
RoadmapName = data.RoadmapName,
Protected = data.Protected,
CreationTime = data.CreationTime,
StartYear = data.StartYear,
EndYear = data.EndYear,
Xml = data.Xml,
Validation_Status = data.ValidationStatusValue,
ConvertToVehicleInput_Status = data.ConvertToVehicleInputStatusValue
};
ctx.DbContext.RoadmapGroups.Add(item);
ctx.DbContext.SaveChanges();
data.RoadmapGroupId = item.RoadmapGroupId;
}
}
/// <summary>
/// insert an item into persistent store
/// </summary>
/// <param name="aDto"></param>
public D_ARK_ENTITY InsertItem(D_ARK_ENTITY aDto)
{
#if (NOTYET)
using (var ctx = DbContextManager <RepositoryModel.ApocFormsEntities> .GetManager())
{
// create new persistent object
var data = new ARK_ENTITY();
data.event_dts = aDto.event_dts;
data.logger_nm = aDto.logger_nm;
data.thread_nm = aDto.thread_nm;
data.log_level_cd = aDto.log_level_cd;
data.apoc_user_nm = aDto.apoc_user_nm;
data.apoc_user_id = aDto.apoc_user_id;
data.apoc_form_nm = aDto.apoc_form_nm;
data.apoc_form_id = aDto.apoc_form_id;
data.location_txt = aDto.location_txt;
data.browser_nm = aDto.browser_nm;
data.request_url = aDto.request_url;
data.referrer_url = aDto.referrer_url;
data.message_txt = aDto.message_txt;
data.stack_trace = aDto.stack_trace;
data.active_yn = aDto.active_yn;
data.create_by_uid = aDto.create_by_uid;
data.create_on_dts = aDto.create_on_dts;
data.update_by_uid = aDto.update_by_uid;
data.update_on_dts = aDto.update_on_dts;
// persist object and save changes
ctx.DbContext.ARK_ENTITY.Add(data);
ctx.DbContext.SaveChanges();
aDto.object_id = data.id;
aDto.create_by_uid = aDto.update_by_uid = data.create_by_uid;
aDto.create_on_dts = aDto.update_on_dts = data.create_on_dts;
aDto.version_key = data.version_key;
}
#endif
return(aDto);
}
private void DataPortal_Fetch(FiltroCriteria criteria)
{
RaiseListChangedEvents = false;
IsReadOnly = false;
using (var ctx = DbContextManager <SeguridadEntities>
.GetManager(BaseDatos.ConexionBD))
{
IEnumerable <Empresas> lista;
switch (criteria.NombreCampo)
{
case "RazonSocial":
lista = ctx.DbContext.SelectEmpresaByRazonSocial(criteria.ValorBusqueda).ToList();
break;
case "Codigo":
lista = ctx.DbContext.SelectEmpresaByCodigo(criteria.ValorBusqueda).ToList();
break;
case "NombreCorto":
lista = ctx.DbContext.SelectEmpresaByNombreCorto(criteria.ValorBusqueda).ToList();
break;
case "RUC":
lista = ctx.DbContext.SelectEmpresaByRUC(criteria.ValorBusqueda).ToList();
break;
default:
lista = ctx.DbContext.SelectAllEmpresas().ToList();
break;
}
foreach (var item in lista)
{
Add(EmpresaInfo.GetEmpresaInfo(item));
}
}
IsReadOnly = true;
RaiseListChangedEvents = true;
}
private void DataPortal_Fetch(FiltroCriteria criteria)
{
RaiseListChangedEvents = false;
IsReadOnly = false;
try
{
using (var ctx = DbContextManager <SeguridadEntities> .GetManager(BaseDatos.ConexionBD))
{
IEnumerable <Aplicaciones> lista;
switch (criteria.NombreCampo)
{
case "Nombre":
lista = ctx.DbContext.SelectAplicacionByName(criteria.ValorBusqueda).ToList();
break;
case "Acronimo":
lista = ctx.DbContext.SelectAplicacionByTag(criteria.ValorBusqueda).ToList();
break;
case "Ruta":
lista = ctx.DbContext.SelectAplicacionByUri(criteria.ValorBusqueda).ToList();
break;
default:
lista = ctx.DbContext.SelectAllAplicacion().ToList();
break;
}
foreach (var item in lista)
{
Add(AplicacionInfo.GetAplicacionInfo(item));
}
}
}
catch (Exception ex)
{
System.Diagnostics.Trace.Write(ex.ToString());
throw;
}
IsReadOnly = true;
RaiseListChangedEvents = true;
}
public void Insert(OrderDetailDto item)
{
using (var ctx = DbContextManager <ModelContainer> .GetManager())
{
var newItem = new OrderDetail
{
OrderOrderId = item.OrderId,
OrderDetailId = item.Id,
LineNo = item.LineNo,
Item = item.Item,
Price = item.Price,
Qty = item.Qty,
Discount = item.Discount
};
ctx.DbContext.OrderDetails.Add(newItem);
ctx.DbContext.SaveChanges();
item.Id = newItem.OrderDetailId;
}
}
public List <CustomerDto> Fetch()
{
using (var ctx = DbContextManager <ModelContainer> .GetManager())
{
var result = from c in ctx.DbContext.Customers
where c.Enable.Equals(true)
orderby c.Name
select new CustomerDto
{
Address = c.Address,
Name = c.Name,
Id = c.IdCustomer,
Num1 = c.Num1,
Num2 = c.Num2,
Sum = c.Sum,
StartDate = c.StartDate,
EndDate = c.EndDate
};
return(result.ToList());
}
}
public void Insert(OrderDto item)
{
using (var ctx = DbContextManager <ModelContainer> .GetManager())
{
var newItem = new Order
{
CustomerIdCustomer = item.IdCustomer,
OrderId = item.Id,
OrderDate = item.OrderDate,
Status = item.Status,
ShippedDate = item.ShippedDate,
ReceivedDate = item.ReceivedDate,
Enable = true
};
ctx.DbContext.Orders.Add(newItem);
ctx.DbContext.SaveChanges();
item.Id = newItem.OrderId;
}
}
public void Insert(CustomerDto item)
{
using (var ctx = DbContextManager <ModelContainer> .GetManager())
{
var newItem = new Customer
{
Address = item.Address,
Name = item.Name,
Num1 = item.Num1,
Num2 = item.Num2,
Sum = item.Sum,
StartDate = item.StartDate,
EndDate = item.EndDate,
Enable = true
};
ctx.DbContext.Customers.Add(newItem);
ctx.DbContext.SaveChanges();
item.Id = newItem.IdCustomer;
}
}
protected override void DataPortal_Update()
{
try
{
using (var ctx = DbContextManager <SeguridadEntities> .GetManager(BaseDatos.ConexionBD))
{
if (IsSelfDirty)
{
var app = ctx.DbContext.SelectAplicacion(ID).FirstOrDefault();
DoInsertUpdate(app);
}
ApplicationContext.LocalContext["IDPadre"] = ID;
FieldManager.UpdateChildren(this);
ctx.DbContext.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Trace.Write(ex.ToString());
throw ex;
}
}
private void DataPortal_Fetch(string criteria)
{
using (var ctx = DbContextManager <SeguridadEntities> .GetManager(BaseDatos.ConexionBD))
{
var recurso = ctx.DbContext.SelectRecurso(criteria).FirstOrDefault();
if (recurso != null)
{
using (BypassPropertyChecks)
{
ID = recurso.IdRecurso;
Descripcion = recurso.Descripcion;
RutaRecurso = recurso.RutaRecurso;
Nivel = recurso.Nivel;
ApplicationContext.LocalContext["IdPadre"] = ID;
}
}
else
{
throw new InvalidOperationException("No se encontró el registro!");
}
}
}
private void DataPortal_Fetch(FiltroCriteria criteria)
{
RaiseListChangedEvents = false;
IsReadOnly = false;
using (var ctx = DbContextManager <SeguridadEntities>
.GetManager(BaseDatos.ConexionBD))
{
IEnumerable <Recurso> query;
bool condicion = (string.IsNullOrEmpty(criteria.ValorBusqueda) && !string.IsNullOrEmpty(criteria.NombreCampo));
if (condicion)
{
query = ctx.DbContext.SelectAllRecurso();
}
else
{
//En caso de que no hay ningun campo devolvemos todos los Niveles
if (string.IsNullOrEmpty(criteria.NombreCampo))
{
query = ctx.DbContext.SelectRecursoForApp().ToList();
}
else
{
query = ctx.DbContext.SelectRecursoByDescripcion(criteria.ValorBusqueda).ToList();
}
}
foreach (var item in query)
{
Add(RecursosInfo.GetRecursosInfo(item));
}
}
IsReadOnly = true;
RaiseListChangedEvents = true;
}
private void DataPortal_Fetch(FiltroCriteria criteria)
{
RaiseListChangedEvents = false;
IsReadOnly = false;
using (var ctx = DbContextManager <SeguridadEntities>
.GetManager(BaseDatos.ConexionBD))
{
var lista = new List <PerfilUsuarioComplex>();
switch (criteria.NombreCampo)
{
case "Aplicacion":
lista = ctx.DbContext.SelectPerfilUsuarioByApp(criteria.ValorBusqueda).ToList();
break;
case "CodigoUsuario":
lista = ctx.DbContext.SelectPerfilUsuarioByUser(criteria.ValorBusqueda).ToList();
break;
case "IdPerfilUsuario":
lista = ctx.DbContext.SelectPerfilUsuarioById(criteria.ValorBusqueda).ToList();
break;
default:
lista = ctx.DbContext.SelectAllPerfilUsuario().ToList();
break;
}
foreach (var item in lista)
{
Add(PerfilUsuarioInfo.GetPerfilUsuarioInfo(item));
}
}
IsReadOnly = true;
RaiseListChangedEvents = true;
}
protected override void DataPortal_Update()
{
try
{
using (var ctx = DbContextManager <SeguridadEntities> .GetManager(BaseDatos.ConexionBD))
{
if (IsSelfDirty)
{
var entidad = ctx.DbContext.SelectPerfilUsuario(ID).FirstOrDefault();
DoInsertUpdate(entidad);
}
RolesPerfiles.Save();
if (Recursos != null)
{
Recursos.Save();
}
ctx.DbContext.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
public void CreateUserWithRoles(string userName, string password, List <string> userRoles)
{
if (!userRoles.Any())
{
throw new Exception("No roles were given to the user.", new Exception("To create a User you will have to give atleast 1 role to him."));
}
userRoles.ToList().ForEach(role =>
{
if (RoleExists(role) == false)
{
throw new Exception("Only created roles can be assigned to Users.", new Exception("The role \"" + role + "\" doesn't exist."));
}
});
using (var dbContextManager = DbContextManager <LicenseManagerDbContext> .GetManager())
{
var userManager = new UserManager <User>(new UserStore <User>(dbContextManager.Context));
var user = new User {
UserName = userName
};
userManager.Create(user, password);
userRoles.ToList().ForEach(x => userManager.AddToRole(user.Id, x));
}
}
public void Delete(Guid id)
{
using (var ctx = DbContextManager <EfDbContext> .GetManager())
ctx.DbContext.DeleteByPK(ctx.DbContext.AppUsers, id);
}
protected override void DataPortal_Execute()
{
using (var ctx = DbContextManager <SeguridadEntities> .GetManager(BaseDatos.ConexionBD))
Result = ctx.DbContext.SelectRecursoDetalleByIdRecurso(IdRecurso).ToList();
}
public DalManager()
{
ConnectionManager = DbContextManager <ModelContainer> .GetManager();
}
