public static IList <CoursePreview> GetList()
{
var repo = UowFactory.Get().Repository <CourseRepository>();
return(ModelHelper.FetchList <CoursePreview, Course>(repo.GetAll()));
//return ModelHelper.FetchList<CoursePreview, CourseDto>(await repo.GetAllAsync());
}
protected override void OnHandle(UpdatePortalCommand command)
{
var settings = ConvertTo(command.SettingsDto);
using (var uow = UowFactory.Create())
{
var portal = uow.Context
.Query <Entities.Sites.Portal>()
.SingleOrDefault();
if (portal == null)
{
throw new EntityNotFoundException("Portal entity not found");
}
portal.Name = command.Name;
portal.Title = command.Title;
portal.Description = command.Description;
uow.Context.Update(portal);
if (settings != null)
{
_settingsProvider.SaveSettings(uow, settings);
}
uow.Complete();
}
}
public void EditarTitulosConsignacionDetalle(IList <TituloConsignacionRendidasDetalleDto> titulosConsignacionRendidaDetalle)
{
if (!titulosConsignacionRendidaDetalle.Any())
{
return;
}
using (var uow = UowFactory.Create <ILaPazUow>())
{
var tituloConsignacionRendidaId = titulosConsignacionRendidaDetalle.First().TituloConsignacionRendidaId;
decimal nuevoImporte = 0;
foreach (var tituloConsignacionRendidaDetalle in titulosConsignacionRendidaDetalle)
{
var tituloConsignacionRendidaActual = uow.TitulosConsignacionesRendidasDetalle.Obtener(x => x.Id == tituloConsignacionRendidaDetalle.Id);
tituloConsignacionRendidaActual.PrecioCompra = tituloConsignacionRendidaDetalle.PrecioCompra;
tituloConsignacionRendidaActual.Importe = tituloConsignacionRendidaDetalle.Importe;
uow.TitulosConsignacionesRendidasDetalle.Modificar(tituloConsignacionRendidaActual);
nuevoImporte += tituloConsignacionRendidaDetalle.PrecioCompra * tituloConsignacionRendidaDetalle.Cantidad;
}
var tituloConsignacionRendida =
uow.TitulosConsignacionesRendidas.Obtener(x => x.Id == tituloConsignacionRendidaId);
tituloConsignacionRendida.Importe = nuevoImporte;
uow.TitulosConsignacionesRendidas.Modificar(tituloConsignacionRendida);
uow.Commit();
}
}
protected override void OnHandle(AddJobCommand command)
{
using (var uow = UowFactory.Create())
{
Validate(uow, command);
var jobType = (JobType)Enum.Parse(typeof(JobType), command.Type);
var ownerId = command.OwnerUserId;
var siteId = command.SiteId;
var owner = uow.Context.Query <Entities.Security.User>().SingleOrDefault(u => u.Id == ownerId);
var site = uow.Context.Query <Entities.Sites.Site>().SingleOrDefault(s => s.Id == siteId);
var newJob = new Entities.Jobs.Job
{
Name = command.Name,
Type = jobType,
IsSystemJob = command.IsSystemJob,
Description = command.Description,
Created = command.Created,
Owner = owner,
Site = site,
};
uow.Context.Add(newJob);
uow.Complete();
}
}
private void FrmReporteConsignaciones_Load(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.ProcessingMode = ProcessingMode.Local;
string appPath = Application.StartupPath.Replace("\\bin\\Debug", "");
string reportPath = @"\RDLS\RendicionConsignaciones.rdl";
reportViewer1.LocalReport.ReportPath = appPath + reportPath;
reportViewer1.ZoomPercent = 130;
using (var uow = UowFactory.Create <ILaPazUow>())
{
var proveedor = uow.Proveedores.Obtener(p => p.Id == ProveedorId);
reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("ReporteDataset", Listado));
var fecha = DateTime.Now.ToShortDateString();
var hora = DateTime.Now.ToShortTimeString();
var parametros = new List <ReportParameter>
{
new ReportParameter("Fecha", fecha),
new ReportParameter("Hora", hora),
new ReportParameter("Desde", Desde.ToShortDateString()),
new ReportParameter("Hasta", Hasta.ToShortDateString()),
new ReportParameter("ProveedorNombre", proveedor.Denominacion)
};
reportViewer1.LocalReport.SetParameters(parametros);
this.reportViewer1.RefreshReport();
this.Cursor = Cursors.Default;
}
}
public Movil ObtenerPorId(Guid movilId)
{
using (var uow = UowFactory.Create <IGestionAdministrativaUow>())
{
return(uow.Moviles.Obtener(c => c.Id == movilId));
}
}
public Cliente ObtenerPorId(Guid clienteId)
{
using (var uow = UowFactory.Create <ILaPazUow>())
{
return(uow.Clientes.Obtener(c => c.Id == clienteId, c => c.Localidad, c => c.Provincia, c => c.CondicionesVenta));
}
}
public LoteFactura UltimoNroLote(Guid opertadorId, int sucursalId)
{
using (var uow = UowFactory.Create <ILaPazUow>())
{
return(uow.LotesFacturas.Obtener(l => l.OperadorLote == opertadorId && l.NroActual < l.NroHasta && l.Estado == EstadoLoteEnum.Activo && l.SucursalAltaId == sucursalId));
}
}
/// <summary>
/// A collection with "AutoSave = true" was modified. Write current state to the database
/// </summary>
private void OnAutoSaveCollectionChanged(object sender, ReferenceCollectionChangedEventArgs args)
{
var instance = args.Parent;
var property = args.CollectionProperty;
lock (Graph.GetWrapper(instance.Id)) // Unlike Save AutoSave collections are ALWAYS part of the Graph
{
using (var uow = UowFactory.Create())
{
var newResources = ResourceLinker.SaveSingleCollection(uow, instance, property);
try
{
uow.SaveChanges();
}
catch (Exception ex)
{
Logger.LogException(LogLevel.Error, ex, "Error saving collection {2} on resource {0}-{1}!", instance.Id, instance.Name, property.Name);
throw;
}
foreach (var newResource in newResources)
{
AddResource(newResource, true);
}
}
}
}
public void TestConcurrency()
{
//client 1 tacking a instance and updating
UnitOfWork client1Uow = (UnitOfWork)UowFactory.Create("DefaultConnection");
var client1Repo = client1Uow.GetEntityRepository <Product>();
var client1Product = client1Repo.GetById(EntityId);
//lets detach before saving to simulate detached client behaviour
client1Uow.Context.ChangeObjectState(client1Product, EntityState.Detached);
client1Product.Name = "Client 1 new name";
//client 2 tacking the same instance and updating
UnitOfWork client2Uow = (UnitOfWork)UowFactory.Create("DefaultConnection");
var client2Repo = client2Uow.GetEntityRepository <Product>();
var client2Product = client2Repo.GetById(EntityId);
client2Uow.Context.ChangeObjectState(client2Product, EntityState.Detached);
client2Product.Name = "Client 2 new name";
//now save the client 1
client1Repo.InsertOrUpdate(client1Product);
client1Uow.Commit();
//now try to save the client 2, this should result in an concurrency exception
client2Repo.InsertOrUpdate(client2Product);
client2Uow.Commit();
}
public void Save(Resource resource)
{
lock (Graph.GetWrapper(resource.Id) ?? _fallbackLock)
{
using (var uow = UowFactory.Create())
{
var newResources = new HashSet <Resource>();
var entity = ResourceEntityAccessor.SaveToEntity(uow, resource);
if (entity.Id == 0)
{
newResources.Add(resource);
}
var newInstances = ResourceLinker.SaveReferences(uow, resource, entity);
newResources.AddRange(newInstances);
try
{
uow.SaveChanges();
}
catch (Exception ex)
{
Logger.LogException(LogLevel.Error, ex, "Error saving resource {0}-{1}!", resource.Id, resource.Name);
throw;
}
foreach (var instance in newResources)
{
AddResource(instance, true);
}
}
}
}
protected override void OnHandle(AddZoneCommand command)
{
using (var uow = UowFactory.Create())
{
ZoneTypeCodes zoneTypeCode;
if (!Enum.TryParse(command.ZoneType, out zoneTypeCode))
{
throw new ArgumentOutOfRangeException($"Zone type: {command.ZoneType} is not valid");
}
Validate(command, uow);
long siteId = command.SiteId;
var site = uow.Context.
FindById <Entities.Sites.Site>(siteId);
var zone = new Entities.Sites.Zone
{
Name = command.Name,
Title = command.Title,
ZoneType = zoneTypeCode,
IsActive = command.IsActive,
IsPrivate = !command.IsPublic,
Site = site,
Description = command.Description,
};
uow.Context.Add(zone);
uow.Complete();
}
}
public ActionResult Index()
{
Response.Write(UowFactory.Get() + "<br>");
Response.Write(UowFactory.Get() + "<br>");
Response.Write(UowFactory.Get() + "<br>");
return(View());
}
public static void Initialize(TestContext context)
{
//Configure the UowFactory to create a new database and seed sample data
UowFactory.Configure(true, true);
DeleteDbFile();
//create the unit of work to be tested
Uow = (UnitOfWork)UowFactory.CreateUnitOfWork("DefaultConnection");
}
public Caja UltimaCajaCarrada(Guid opertadorId, int sucursalId)
{
using (var uow = UowFactory.Create <ILaPazUow>())
{
return(uow.Cajas.Listado()
.Where(c => c.FCierre != null && c.OperadorId == opertadorId)
.OrderByDescending(c => c.FCierre).FirstOrDefault());
}
}
public static IList <StudentPreview> GetList(string sortBy, string sortOrder)
{
var repo = new StudentRepository(UowFactory.Get());
var list = repo.Query()
.OrderBy(string.Format("{0} {1}", sortBy ?? "Id", sortOrder))
.List();
return(ModelHelper.FetchList <StudentPreview, Student>(list));
}
public string FormaDePagoReimpresion(Guid comprobanteId)
{
StringBuilder formaPago = new StringBuilder();
using (var uow = UowFactory.Create <ILaPazUow>())
{
var cajaMovimiento = uow.CajaMovimientos.Obtener(cm => cm.ComprobanteId == comprobanteId);
if (cajaMovimiento != null)
{
if (cajaMovimiento.Efectivo.HasValue)
{
formaPago.AppendFormat("Efectivo {0:c2}. ", cajaMovimiento.Efectivo);
}
if (cajaMovimiento.Tarjeta.HasValue)
{
//var tarjetasMovimientos =
// uow.TarjetasMovimientos.Listado(tm => tm.Tarjeta).Where(tm => tm.CajaMovimientoId == cajaMovimiento.Id).ToList();
//foreach (var tarjetasMovimiento in tarjetasMovimientos)
//{
// formaPago.AppendFormat("Tarjeta {0} {1:c2}. ", tarjetasMovimiento.Tarjeta.Nombre, tarjetasMovimiento.Importe);
//}
formaPago.AppendFormat("Tarjeta {0} . ", cajaMovimiento.Tarjeta);
}
if (cajaMovimiento.Cheque.HasValue)
{
//var chequesTerceros =
// uow.ChequesTercero.Listado(ch => ch.Banco).Where(ch => ch.CajaMovimientoId == cajaMovimiento.Id);
//foreach (var chequeTercero in chequesTerceros)
//{
// formaPago.AppendFormat("Cheque {0} {1:c2}. ", chequeTercero.Banco.Nombre, chequeTercero.Importe);
//}
formaPago.AppendFormat("Cheque {0} . ", cajaMovimiento.Cheque);
}
if (cajaMovimiento.Deposito.HasValue)
{
//var cuentasMovimientos =
// uow.CuentasMovimientos.Listado(ch => ch.Cuenta).Where(ch => ch.ComprobanteId == comprobanteId);
//foreach (var cuentasMovimiento in cuentasMovimientos)
//{
// formaPago.AppendFormat("Deposito {0} {1:c2}. ", cuentasMovimiento.Cuenta.Nombre, cuentasMovimiento.Credito);
//}
formaPago.AppendFormat("Deposito {0} . ", cajaMovimiento.Deposito);
}
}
}
return(formaPago.ToString());
}
protected override void OnHandle(DeletePostSerieCommand command)
{
using (var uow = UowFactory.Create())
{
Validate(uow, command);
var postSerie = uow.Context.Query <PostSerie>().SingleOrDefault(j => j.Id == command.Id);
uow.Context.Remove(postSerie);
uow.Complete();
}
}
protected override void OnHandle(DeleteJobCommand command)
{
using (var uow = UowFactory.Create())
{
Validate(uow, command);
var job = uow.Context.Query <Entities.Jobs.Job>().SingleOrDefault(j => j.Id == command.JobId);
uow.Context.Remove(job);
uow.Complete();
}
}
protected override void OnHandle(DeletePostCommand command)
{
using (var uow = UowFactory.Create())
{
// TODO: validation
var post = uow.Context.FindById <Entities.Posts.Post>(command.PostId);
uow.Context.Remove(post);
uow.Complete();
}
}
protected override void OnHandle(SetUserEmailConfirmCommand command)
{
using (var uow = UowFactory.Create())
{
var user = uow.Context.FindById <Entities.Security.User>(command.UserId);
user.EmailConfirm = command.Confirmed;
uow.Context.Update(user);
uow.Complete();
}
}
protected override void OnHandle(DeleteCategoryCommand command)
{
using (var uow = UowFactory.Create())
{
var categoryToDelete = uow.Context.FindById <Entities.Posts.Category>(command.CategoryId);
Validate(categoryToDelete, uow);
uow.Context.Remove(categoryToDelete);
uow.Complete();
}
}
public static void Initialize(TestContext context)
{
//Configure the UowFactory to create a new database and seed sample data
UowFactory.Configure(true, true);
DeleteDbFile();
var configurator = new EndpointConfigurator();
var config = configurator.Configure(new HttpConfiguration());
Server = new HttpServer(config);
Client = new HttpClient(Server);
}
protected override void OnHandle(SetSecurityStampCommand command)
{
using (var uow = UowFactory.Create())
{
var user = uow.Context.FindById <Entities.Security.User>(command.UserId);
user.SecurityStamp = command.SecurityStamp;
uow.Context.Update(user);
uow.Complete();
}
}
public decimal SenaAFavorProveedor(Guid proveedorId, int sucursalId)
{
using (var uow = UowFactory.Create <ILaPazUow>())
{
var proveedorMontosFavor = uow.ProveedoresSenias.Listado().Where(ps => ps.ProveedorId == proveedorId &&
ps.SucursalAltaId == sucursalId &&
ps.ImporteUsado < ps.Importe)
.ToList();
return
(proveedorMontosFavor.Sum(cm => cm.Importe.GetValueOrDefault() - cm.ImporteUsado.GetValueOrDefault()));
}
}
protected override void OnHandle(DeleteRoleCommand command)
{
using (var uow = UowFactory.Create())
{
var roleToDelete = uow.Context
.FindById <Entities.Security.Role>(command.Id);
Validate(uow, roleToDelete);
uow.Context.Remove(roleToDelete);
uow.Complete();
}
}
protected override void OnHandle(DeleteSiteCommand command)
{
using (var uow = UowFactory.Create())
{
var siteToDelete = uow.Context
.FindById <Entities.Sites.Site>(command.Id);
Validate(uow, siteToDelete);
uow.Context.Remove(siteToDelete);
uow.Complete();
}
}
public bool Destroy(IResource resource, bool permanent)
{
var instance = (Resource)resource;
((IPlugin)resource).Stop();
// Load entity and relations to disconnect resource and remove from database
using (var uow = UowFactory.Create())
{
var resourceRepository = uow.GetRepository <IResourceEntityRepository>();
var relationRepository = uow.GetRepository <IResourceRelationRepository>();
// Fetch entity and relations
// Update properties on the references and get rid of relation entities
var entity = resourceRepository.GetByKey(instance.Id);
var relations = ResourceRelationAccessor.FromEntity(uow, entity);
foreach (var relation in relations)
{
var reference = Graph.Get(relation.ReferenceId);
ResourceLinker.RemoveLinking(resource, reference);
if (permanent)
{
relationRepository.Remove(relation.Entity);
}
}
resourceRepository.Remove(entity, permanent);
uow.SaveChanges();
}
// Unregister from all events to avoid memory leaks
UnregisterEvents(instance);
// Remove from internal collections
var removed = Graph.Remove(instance);
// Notify listeners about the removal of the resource
if (removed && instance is IPublicResource publicResource)
{
RaiseResourceRemoved(publicResource);
}
// Destroy the object
TypeController.Destroy(instance);
return(removed);
}
protected override void OnHandle(ChangePasswordCommand command)
{
using (var uow = UowFactory.Create())
{
var user = uow.Context.FindById <Entities.Security.User>(command.UserId);
var newPasswordAlgorithm = (HashAlgorithm)Enum.Parse(typeof(HashAlgorithm), user.PasswordHashAlgorithm);
user.PasswordHashAlgorithm = command.PasswordHashAlgorithm;
user.PasswordHash = command.NewPasswordHash;
uow.Context.Update(user);
uow.Complete();
}
}
public void ExecuteInitializer(IResourceInitializer initializer)
{
var roots = initializer.Execute(Graph);
if (roots.Count == 0)
{
throw new InvalidOperationException("ResourceInitializer must return at least one resource");
}
using (var uow = UowFactory.Create())
{
ResourceLinker.SaveRoots(uow, roots);
uow.SaveChanges();
}
}
