public void Handle(IncomingInvoiceRegisteredEvent message)
{
var invoice = new IncomingInvoice();
invoice.Amount = message.Amount;
invoice.Date = message.InvoiceDate;
invoice.Description = message.Description;
invoice.Number = message.InvoiceNumber;
invoice.OriginalId = message.InvoiceId;
invoice.PurchaseOrderNumber = message.PurchaseOrderNumber;
invoice.Taxes = message.Taxes;
invoice.TotalPrice = message.TotalPrice;
invoice.Supplier = new Invoice.PartyInfo()
{
City = message.Supplier.City,
Country = message.Supplier.Country,
Name = message.Supplier.Name,
NationalIdentificationNumber = message.Supplier.NationalIdentificationNumber,
OriginalId = message.Supplier.Id,
PostalCode = message.Supplier.PostalCode,
StreetName = message.Supplier.StreetName,
VatIndex = message.Supplier.VatIndex
};
using (var ctx = new AccountancyContext())
{
ctx.IncomingInvoices.Add(invoice);
ctx.SaveChanges();
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Date,StorageId")] IncomingInvoice incomingInvoice)
{
if (id != incomingInvoice.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(incomingInvoice);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!IncomingInvoiceExists(incomingInvoice.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["StorageId"] = new SelectList(_context.Storages, "Id", "Id", incomingInvoice.StorageId);
return(View(incomingInvoice));
}
public async Task <IActionResult> Create([Bind("Id,Date,StorageId")] IncomingInvoice incomingInvoice)
{
int IdEnterprise = int.Parse(User.Claims.ToList()[1].Value);
if (ModelState.IsValid)
{
_context.Add(incomingInvoice);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["StorageId"] = new SelectList(_context.Storages.Where(s => s.EnterpriseId == IdEnterprise), "Id", "Name", incomingInvoice.StorageId);
return(View(incomingInvoice));
}
public async Task Handle(IncomingInvoiceRegisteredEvent message)
{
var invoice = new IncomingInvoice();
invoice.TaxableAmount = message.TaxableAmount;
invoice.Currency = message.Currency;
invoice.Date = message.InvoiceDate;
invoice.DueDate = message.DueDate;
invoice.Description = message.Description;
invoice.Number = message.InvoiceNumber;
invoice.OriginalId = message.InvoiceId;
invoice.PurchaseOrderNumber = message.PurchaseOrderNumber;
invoice.Taxes = message.Taxes;
invoice.TotalPrice = message.TotalPrice;
invoice.IsOverdue = false;
invoice.IsPaid = false;
invoice.Customer = new Invoice.PartyInfo()
{
City = message.Customer.City,
Country = message.Customer.Country,
Name = message.Customer.Name,
NationalIdentificationNumber = message.Customer.NationalIdentificationNumber,
OriginalId = message.Customer.Id,
PostalCode = message.Customer.PostalCode,
StreetName = message.Customer.StreetName,
VatIndex = message.Customer.VatIndex
};
invoice.Supplier = new Invoice.PartyInfo()
{
City = message.Supplier.City,
Country = message.Supplier.Country,
Name = message.Supplier.Name,
NationalIdentificationNumber = message.Supplier.NationalIdentificationNumber,
OriginalId = message.Supplier.Id,
PostalCode = message.Supplier.PostalCode,
StreetName = message.Supplier.StreetName,
VatIndex = message.Supplier.VatIndex
};
using (var ctx = new AccountancyDbContext(Options))
{
ctx.IncomingInvoices.Add(invoice);
await ctx.SaveChangesAsync();
}
}
public RedirectToActionResult CreateIncomingInvoice([Bind("Id,Date,StorageId")] IncomingInvoice incomingInvoice)
{
CartClassForInvoice cartClassForInvoice = new CartClassForInvoice("Product_in_InomingInvoice", _context, HttpContext);
incomingInvoice.Date = DateTime.Now;
incomingInvoice.UserId = _context.Users.FirstOrDefault(s => s.Login == User.Identity.Name).Id;
_context.IncomingInvoices.Add(incomingInvoice);
_context.SaveChanges();
var e = cartClassForInvoice.GetCart().Lines;
foreach (var el in e)
{
el.InvoiceId = incomingInvoice.Id;
Invoice_Product newInvo = new Invoice_Product {
InvoiceId = incomingInvoice.Id, ProductId = el.ProductId, Quantity = el.Quantity
};
_context.Invoice_Products.Add(newInvo);
}
_context.SaveChanges();
cartClassForInvoice.Clear();
return(RedirectToAction("Index"));
}
public override void UpdateNodes()
{
IncomingInvoice invoiceAlias = null;
IncomingWater waterAlias = null;
MovementDocument movementAlias = null;
WriteoffDocument writeoffAlias = null;
InventoryDocument inventoryAlias = null;
ShiftChangeWarehouseDocument shiftchangeAlias = null;
SelfDeliveryDocument selfDeliveryAlias = null;
RegradingOfGoodsDocument regradingOfGoodsAlias = null;
DocumentVMNode resultAlias = null;
Counterparty counterpartyAlias = null;
Counterparty secondCounterpartyAlias = null;
Warehouse warehouseAlias = null;
Warehouse secondWarehouseAlias = null;
MovementWagon wagonAlias = null;
Nomenclature productAlias = null;
CarLoadDocument loadCarAlias = null;
CarUnloadDocument unloadCarAlias = null;
RouteList routeListAlias = null;
Car carAlias = null;
Employee driverAlias = null;
Employee authorAlias = null;
Employee lastEditorAlias = null;
Domain.Orders.Order orderAlias = null;
List <DocumentVMNode> result = new List <DocumentVMNode> ();
if ((Filter.RestrictDocumentType == null || Filter.RestrictDocumentType == DocumentType.IncomingInvoice) && Filter.RestrictDriver == null)
{
var invoiceQuery = UoW.Session.QueryOver <IncomingInvoice>(() => invoiceAlias);
if (Filter.RestrictWarehouse != null)
{
invoiceQuery.Where(x => x.Warehouse.Id == Filter.RestrictWarehouse.Id);
}
if (Filter.RestrictStartDate.HasValue)
{
invoiceQuery.Where(o => o.TimeStamp >= Filter.RestrictStartDate.Value);
}
if (Filter.RestrictEndDate.HasValue)
{
invoiceQuery.Where(o => o.TimeStamp < Filter.RestrictEndDate.Value.AddDays(1));
}
var invoiceList = invoiceQuery.JoinQueryOver(() => invoiceAlias.Contractor, () => counterpartyAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinQueryOver(() => invoiceAlias.Warehouse, () => warehouseAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => invoiceAlias.Author, () => authorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => invoiceAlias.LastEditor, () => lastEditorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.SelectList(list => list
.Select(() => invoiceAlias.Id).WithAlias(() => resultAlias.Id)
.Select(() => invoiceAlias.TimeStamp).WithAlias(() => resultAlias.Date)
.Select(() => invoiceAlias.Comment).WithAlias(() => resultAlias.Comment)
.Select(() => DocumentType.IncomingInvoice).WithAlias(() => resultAlias.DocTypeEnum)
.Select(Projections.Conditional(
Restrictions.Where(() => counterpartyAlias.Name == null),
Projections.Constant("Не указан", NHibernateUtil.String),
Projections.Property(() => counterpartyAlias.Name)))
.WithAlias(() => resultAlias.Counterparty)
.Select(Projections.Conditional(
Restrictions.Where(() => warehouseAlias.Name == null),
Projections.Constant("Не указан", NHibernateUtil.String),
Projections.Property(() => warehouseAlias.Name)))
.WithAlias(() => resultAlias.Warehouse)
.Select(() => authorAlias.LastName).WithAlias(() => resultAlias.AuthorSurname)
.Select(() => authorAlias.Name).WithAlias(() => resultAlias.AuthorName)
.Select(() => authorAlias.Patronymic).WithAlias(() => resultAlias.AuthorPatronymic)
.Select(() => lastEditorAlias.LastName).WithAlias(() => resultAlias.LastEditorSurname)
.Select(() => lastEditorAlias.Name).WithAlias(() => resultAlias.LastEditorName)
.Select(() => lastEditorAlias.Patronymic).WithAlias(() => resultAlias.LastEditorPatronymic)
.Select(() => invoiceAlias.LastEditedTime).WithAlias(() => resultAlias.LastEditedTime)
)
.TransformUsing(Transformers.AliasToBean <DocumentVMNode> ())
.List <DocumentVMNode> ();
result.AddRange(invoiceList);
}
if ((Filter.RestrictDocumentType == null || Filter.RestrictDocumentType == DocumentType.IncomingWater) && Filter.RestrictDriver == null)
{
var waterQuery = UoW.Session.QueryOver <IncomingWater>(() => waterAlias);
if (Filter.RestrictWarehouse != null)
{
waterQuery.Where(x => x.IncomingWarehouse.Id == Filter.RestrictWarehouse.Id || x.WriteOffWarehouse.Id == Filter.RestrictWarehouse.Id);
}
if (Filter.RestrictStartDate.HasValue)
{
waterQuery.Where(o => o.TimeStamp >= Filter.RestrictStartDate.Value);
}
if (Filter.RestrictEndDate.HasValue)
{
waterQuery.Where(o => o.TimeStamp < Filter.RestrictEndDate.Value.AddDays(1));
}
var waterList = waterQuery
.JoinQueryOver(() => waterAlias.IncomingWarehouse, () => warehouseAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => waterAlias.Author, () => authorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => waterAlias.LastEditor, () => lastEditorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.Left.JoinAlias(() => waterAlias.Product, () => productAlias)
.SelectList(list => list
.Select(() => waterAlias.Id).WithAlias(() => resultAlias.Id)
.Select(() => waterAlias.TimeStamp).WithAlias(() => resultAlias.Date)
.Select(() => DocumentType.IncomingWater).WithAlias(() => resultAlias.DocTypeEnum)
.Select(Projections.Conditional(
Restrictions.Where(() => warehouseAlias.Name == null),
Projections.Constant("Не указан", NHibernateUtil.String),
Projections.Property(() => warehouseAlias.Name)))
.WithAlias(() => resultAlias.Warehouse)
.Select(() => productAlias.Name).WithAlias(() => resultAlias.ProductName)
.Select(() => waterAlias.Amount).WithAlias(() => resultAlias.Amount)
.Select(() => authorAlias.LastName).WithAlias(() => resultAlias.AuthorSurname)
.Select(() => authorAlias.Name).WithAlias(() => resultAlias.AuthorName)
.Select(() => authorAlias.Patronymic).WithAlias(() => resultAlias.AuthorPatronymic)
.Select(() => lastEditorAlias.LastName).WithAlias(() => resultAlias.LastEditorSurname)
.Select(() => lastEditorAlias.Name).WithAlias(() => resultAlias.LastEditorName)
.Select(() => lastEditorAlias.Patronymic).WithAlias(() => resultAlias.LastEditorPatronymic)
.Select(() => waterAlias.LastEditedTime).WithAlias(() => resultAlias.LastEditedTime))
.TransformUsing(Transformers.AliasToBean <DocumentVMNode> ())
.List <DocumentVMNode> ();
result.AddRange(waterList);
}
if ((Filter.RestrictDocumentType == null || Filter.RestrictDocumentType == DocumentType.MovementDocument) && Filter.RestrictDriver == null)
{
var movementQuery = UoW.Session.QueryOver <MovementDocument>(() => movementAlias);
if (Filter.RestrictWarehouse != null)
{
movementQuery.Where(x => x.FromWarehouse.Id == Filter.RestrictWarehouse.Id || x.ToWarehouse.Id == Filter.RestrictWarehouse.Id);
}
if (Filter.RestrictStartDate.HasValue)
{
movementQuery.Where(o => o.TimeStamp >= Filter.RestrictStartDate.Value);
}
if (Filter.RestrictEndDate.HasValue)
{
movementQuery.Where(o => o.TimeStamp < Filter.RestrictEndDate.Value.AddDays(1));
}
if (Filter.RestrictMovementStatus.HasValue && Filter.RestrictDocumentType == DocumentType.MovementDocument)
{
movementQuery.Where(o => o.Status == Filter.RestrictMovementStatus.Value);
}
var movementList = movementQuery
.JoinQueryOver(() => movementAlias.FromWarehouse, () => warehouseAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinQueryOver(() => movementAlias.ToWarehouse, () => secondWarehouseAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => movementAlias.MovementWagon, () => wagonAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => movementAlias.Author, () => authorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => movementAlias.LastEditor, () => lastEditorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.SelectList(list => list
.Select(() => movementAlias.Id).WithAlias(() => resultAlias.Id)
.Select(() => movementAlias.TimeStamp).WithAlias(() => resultAlias.Date)
.Select(() => DocumentType.MovementDocument).WithAlias(() => resultAlias.DocTypeEnum)
.Select(() => movementAlias.Status).WithAlias(() => resultAlias.MovementDocumentStatus)
.Select(() => movementAlias.HasDiscrepancy).WithAlias(() => resultAlias.MovementDocumentDiscrepancy)
.Select(() => wagonAlias.Name).WithAlias(() => resultAlias.CarNumber)
.Select(Projections.Conditional(
Restrictions.Where(() => warehouseAlias.Name == null),
Projections.Constant("Не указан", NHibernateUtil.String),
Projections.Property(() => warehouseAlias.Name)))
.WithAlias(() => resultAlias.Warehouse)
.Select(Projections.Conditional(
Restrictions.Where(() => secondWarehouseAlias.Name == null),
Projections.Constant("Не указан", NHibernateUtil.String),
Projections.Property(() => secondWarehouseAlias.Name)))
.WithAlias(() => resultAlias.SecondWarehouse)
.Select(() => authorAlias.LastName).WithAlias(() => resultAlias.AuthorSurname)
.Select(() => authorAlias.Name).WithAlias(() => resultAlias.AuthorName)
.Select(() => authorAlias.Patronymic).WithAlias(() => resultAlias.AuthorPatronymic)
.Select(() => lastEditorAlias.LastName).WithAlias(() => resultAlias.LastEditorSurname)
.Select(() => lastEditorAlias.Name).WithAlias(() => resultAlias.LastEditorName)
.Select(() => lastEditorAlias.Patronymic).WithAlias(() => resultAlias.LastEditorPatronymic)
.Select(() => movementAlias.LastEditedTime).WithAlias(() => resultAlias.LastEditedTime))
.TransformUsing(Transformers.AliasToBean <DocumentVMNode> ())
.List <DocumentVMNode> ();
result.AddRange(movementList);
}
if ((Filter.RestrictDocumentType == null || Filter.RestrictDocumentType == DocumentType.WriteoffDocument) && Filter.RestrictDriver == null)
{
var writeoffQuery = UoW.Session.QueryOver <WriteoffDocument>(() => writeoffAlias);
if (Filter.RestrictWarehouse != null)
{
writeoffQuery.Where(x => x.WriteoffWarehouse.Id == Filter.RestrictWarehouse.Id);
}
if (Filter.RestrictStartDate.HasValue)
{
writeoffQuery.Where(o => o.TimeStamp >= Filter.RestrictStartDate.Value);
}
if (Filter.RestrictEndDate.HasValue)
{
writeoffQuery.Where(o => o.TimeStamp < Filter.RestrictEndDate.Value.AddDays(1));
}
var writeoffList = writeoffQuery
.JoinQueryOver(() => writeoffAlias.Client, () => counterpartyAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinQueryOver(() => writeoffAlias.WriteoffWarehouse, () => warehouseAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => writeoffAlias.Author, () => authorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => writeoffAlias.LastEditor, () => lastEditorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.SelectList(list => list
.Select(() => writeoffAlias.Id).WithAlias(() => resultAlias.Id)
.Select(() => writeoffAlias.TimeStamp).WithAlias(() => resultAlias.Date)
.Select(() => DocumentType.WriteoffDocument).WithAlias(() => resultAlias.DocTypeEnum)
.Select(Projections.Conditional(
Restrictions.Where(() => counterpartyAlias.Name == null),
Projections.Constant(string.Empty, NHibernateUtil.String),
Projections.Property(() => counterpartyAlias.Name)))
.WithAlias(() => resultAlias.Counterparty)
.Select(Projections.Conditional(
Restrictions.Where(() => warehouseAlias.Name == null),
Projections.Constant(string.Empty, NHibernateUtil.String),
Projections.Property(() => warehouseAlias.Name)))
.WithAlias(() => resultAlias.Warehouse)
.Select(() => authorAlias.LastName).WithAlias(() => resultAlias.AuthorSurname)
.Select(() => authorAlias.Name).WithAlias(() => resultAlias.AuthorName)
.Select(() => authorAlias.Patronymic).WithAlias(() => resultAlias.AuthorPatronymic)
.Select(() => lastEditorAlias.LastName).WithAlias(() => resultAlias.LastEditorSurname)
.Select(() => lastEditorAlias.Name).WithAlias(() => resultAlias.LastEditorName)
.Select(() => lastEditorAlias.Patronymic).WithAlias(() => resultAlias.LastEditorPatronymic)
.Select(() => writeoffAlias.LastEditedTime).WithAlias(() => resultAlias.LastEditedTime))
.TransformUsing(Transformers.AliasToBean <DocumentVMNode> ())
.List <DocumentVMNode> ();
result.AddRange(writeoffList);
}
if ((Filter.RestrictDocumentType == null || Filter.RestrictDocumentType == DocumentType.InventoryDocument) && Filter.RestrictDriver == null)
{
var inventoryQuery = UoW.Session.QueryOver <InventoryDocument>(() => inventoryAlias);
if (Filter.RestrictWarehouse != null)
{
inventoryQuery.Where(x => x.Warehouse.Id == Filter.RestrictWarehouse.Id);
}
if (Filter.RestrictStartDate.HasValue)
{
inventoryQuery.Where(o => o.TimeStamp >= Filter.RestrictStartDate.Value);
}
if (Filter.RestrictEndDate.HasValue)
{
inventoryQuery.Where(o => o.TimeStamp < Filter.RestrictEndDate.Value.AddDays(1));
}
var inventoryList = inventoryQuery
.JoinQueryOver(() => inventoryAlias.Warehouse, () => warehouseAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => inventoryAlias.Author, () => authorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => inventoryAlias.LastEditor, () => lastEditorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.SelectList(list => list
.Select(() => inventoryAlias.Id).WithAlias(() => resultAlias.Id)
.Select(() => inventoryAlias.TimeStamp).WithAlias(() => resultAlias.Date)
.Select(() => DocumentType.InventoryDocument).WithAlias(() => resultAlias.DocTypeEnum)
.Select(() => warehouseAlias.Name).WithAlias(() => resultAlias.Warehouse)
.Select(() => authorAlias.LastName).WithAlias(() => resultAlias.AuthorSurname)
.Select(() => authorAlias.Name).WithAlias(() => resultAlias.AuthorName)
.Select(() => authorAlias.Patronymic).WithAlias(() => resultAlias.AuthorPatronymic)
.Select(() => lastEditorAlias.LastName).WithAlias(() => resultAlias.LastEditorSurname)
.Select(() => lastEditorAlias.Name).WithAlias(() => resultAlias.LastEditorName)
.Select(() => lastEditorAlias.Patronymic).WithAlias(() => resultAlias.LastEditorPatronymic)
.Select(() => inventoryAlias.LastEditedTime).WithAlias(() => resultAlias.LastEditedTime))
.TransformUsing(Transformers.AliasToBean <DocumentVMNode> ())
.List <DocumentVMNode> ();
result.AddRange(inventoryList);
}
if ((Filter.RestrictDocumentType == null || Filter.RestrictDocumentType == DocumentType.ShiftChangeDocument) && Filter.RestrictDriver == null)
{
var shiftchangeQuery = UoW.Session.QueryOver <ShiftChangeWarehouseDocument>(() => shiftchangeAlias);
if (Filter.RestrictWarehouse != null)
{
shiftchangeQuery.Where(x => x.Warehouse.Id == Filter.RestrictWarehouse.Id);
}
if (Filter.RestrictStartDate.HasValue)
{
shiftchangeQuery.Where(o => o.TimeStamp >= Filter.RestrictStartDate.Value);
}
if (Filter.RestrictEndDate.HasValue)
{
shiftchangeQuery.Where(o => o.TimeStamp < Filter.RestrictEndDate.Value.AddDays(1));
}
var shiftchangeList = shiftchangeQuery
.JoinQueryOver(() => shiftchangeAlias.Warehouse, () => warehouseAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => shiftchangeAlias.Author, () => authorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => shiftchangeAlias.LastEditor, () => lastEditorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.SelectList(list => list
.Select(() => shiftchangeAlias.Id).WithAlias(() => resultAlias.Id)
.Select(() => shiftchangeAlias.TimeStamp).WithAlias(() => resultAlias.Date)
.Select(() => DocumentType.ShiftChangeDocument).WithAlias(() => resultAlias.DocTypeEnum)
.Select(() => warehouseAlias.Name).WithAlias(() => resultAlias.Warehouse)
.Select(() => authorAlias.LastName).WithAlias(() => resultAlias.AuthorSurname)
.Select(() => authorAlias.Name).WithAlias(() => resultAlias.AuthorName)
.Select(() => authorAlias.Patronymic).WithAlias(() => resultAlias.AuthorPatronymic)
.Select(() => lastEditorAlias.LastName).WithAlias(() => resultAlias.LastEditorSurname)
.Select(() => lastEditorAlias.Name).WithAlias(() => resultAlias.LastEditorName)
.Select(() => lastEditorAlias.Patronymic).WithAlias(() => resultAlias.LastEditorPatronymic)
.Select(() => shiftchangeAlias.LastEditedTime).WithAlias(() => resultAlias.LastEditedTime))
.TransformUsing(Transformers.AliasToBean <DocumentVMNode>())
.List <DocumentVMNode>();
result.AddRange(shiftchangeList);
}
if ((Filter.RestrictDocumentType == null || Filter.RestrictDocumentType == DocumentType.RegradingOfGoodsDocument) && Filter.RestrictDriver == null)
{
var regrandingQuery = UoW.Session.QueryOver <RegradingOfGoodsDocument>(() => regradingOfGoodsAlias);
if (Filter.RestrictWarehouse != null)
{
regrandingQuery.Where(x => x.Warehouse.Id == Filter.RestrictWarehouse.Id);
}
if (Filter.RestrictStartDate.HasValue)
{
regrandingQuery.Where(o => o.TimeStamp >= Filter.RestrictStartDate.Value);
}
if (Filter.RestrictEndDate.HasValue)
{
regrandingQuery.Where(o => o.TimeStamp < Filter.RestrictEndDate.Value.AddDays(1));
}
var regrandingList = regrandingQuery
.JoinQueryOver(() => regradingOfGoodsAlias.Warehouse, () => warehouseAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => regradingOfGoodsAlias.Author, () => authorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => regradingOfGoodsAlias.LastEditor, () => lastEditorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.SelectList(list => list
.Select(() => regradingOfGoodsAlias.Id).WithAlias(() => resultAlias.Id)
.Select(() => regradingOfGoodsAlias.TimeStamp).WithAlias(() => resultAlias.Date)
.Select(() => DocumentType.RegradingOfGoodsDocument).WithAlias(() => resultAlias.DocTypeEnum)
.Select(() => warehouseAlias.Name).WithAlias(() => resultAlias.Warehouse)
.Select(() => authorAlias.LastName).WithAlias(() => resultAlias.AuthorSurname)
.Select(() => authorAlias.Name).WithAlias(() => resultAlias.AuthorName)
.Select(() => authorAlias.Patronymic).WithAlias(() => resultAlias.AuthorPatronymic)
.Select(() => lastEditorAlias.LastName).WithAlias(() => resultAlias.LastEditorSurname)
.Select(() => lastEditorAlias.Name).WithAlias(() => resultAlias.LastEditorName)
.Select(() => lastEditorAlias.Patronymic).WithAlias(() => resultAlias.LastEditorPatronymic)
.Select(() => regradingOfGoodsAlias.LastEditedTime).WithAlias(() => resultAlias.LastEditedTime))
.TransformUsing(Transformers.AliasToBean <DocumentVMNode> ())
.List <DocumentVMNode> ();
result.AddRange(regrandingList);
}
if ((Filter.RestrictDocumentType == null || Filter.RestrictDocumentType == DocumentType.SelfDeliveryDocument) && Filter.RestrictDriver == null)
{
var selfDeliveryQuery = UoW.Session.QueryOver <SelfDeliveryDocument>(() => selfDeliveryAlias)
.JoinQueryOver(() => selfDeliveryAlias.Warehouse, () => warehouseAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinQueryOver(() => selfDeliveryAlias.Order, () => orderAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinQueryOver(() => orderAlias.Client, () => counterpartyAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin);
if (Filter.RestrictWarehouse != null)
{
selfDeliveryQuery.Where(() => selfDeliveryAlias.Warehouse.Id == Filter.RestrictWarehouse.Id);
}
if (Filter.RestrictStartDate.HasValue)
{
selfDeliveryQuery.Where(() => selfDeliveryAlias.TimeStamp >= Filter.RestrictStartDate.Value);
}
if (Filter.RestrictEndDate.HasValue)
{
selfDeliveryQuery.Where(() => selfDeliveryAlias.TimeStamp < Filter.RestrictEndDate.Value.AddDays(1));
}
var selfDeliveryList = selfDeliveryQuery
.JoinAlias(() => selfDeliveryAlias.Author, () => authorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => selfDeliveryAlias.LastEditor, () => lastEditorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.SelectList(list => list
.Select(() => selfDeliveryAlias.Id).WithAlias(() => resultAlias.Id)
.Select(() => orderAlias.Id).WithAlias(() => resultAlias.OrderId)
.Select(() => selfDeliveryAlias.TimeStamp).WithAlias(() => resultAlias.Date)
.Select(() => DocumentType.SelfDeliveryDocument).WithAlias(() => resultAlias.DocTypeEnum)
.Select(() => counterpartyAlias.Name).WithAlias(() => resultAlias.Counterparty)
.Select(() => warehouseAlias.Name).WithAlias(() => resultAlias.Warehouse)
.Select(() => authorAlias.LastName).WithAlias(() => resultAlias.AuthorSurname)
.Select(() => authorAlias.Name).WithAlias(() => resultAlias.AuthorName)
.Select(() => authorAlias.Patronymic).WithAlias(() => resultAlias.AuthorPatronymic)
.Select(() => lastEditorAlias.LastName).WithAlias(() => resultAlias.LastEditorSurname)
.Select(() => lastEditorAlias.Name).WithAlias(() => resultAlias.LastEditorName)
.Select(() => lastEditorAlias.Patronymic).WithAlias(() => resultAlias.LastEditorPatronymic)
.Select(() => selfDeliveryAlias.LastEditedTime).WithAlias(() => resultAlias.LastEditedTime))
.TransformUsing(Transformers.AliasToBean <DocumentVMNode> ())
.List <DocumentVMNode> ();
result.AddRange(selfDeliveryList);
}
if (Filter.RestrictDocumentType == null || Filter.RestrictDocumentType == DocumentType.CarLoadDocument)
{
var carLoadQuery = UoW.Session.QueryOver <CarLoadDocument>(() => loadCarAlias)
.JoinQueryOver(() => loadCarAlias.Warehouse, () => warehouseAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinQueryOver(() => loadCarAlias.RouteList, () => routeListAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinQueryOver(() => routeListAlias.Car, () => carAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinQueryOver(() => routeListAlias.Driver, () => driverAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin);
if (Filter.RestrictWarehouse != null)
{
carLoadQuery.Where(() => loadCarAlias.Warehouse.Id == Filter.RestrictWarehouse.Id);
}
if (Filter.RestrictStartDate.HasValue)
{
carLoadQuery.Where(() => loadCarAlias.TimeStamp >= Filter.RestrictStartDate.Value);
}
if (Filter.RestrictEndDate.HasValue)
{
carLoadQuery.Where(() => loadCarAlias.TimeStamp < Filter.RestrictEndDate.Value.AddDays(1));
}
if (Filter.RestrictDriver != null)
{
carLoadQuery.Where(() => routeListAlias.Driver.Id == Filter.RestrictDriver.Id);
}
var carLoadList = carLoadQuery
.JoinAlias(() => loadCarAlias.Author, () => authorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => loadCarAlias.LastEditor, () => lastEditorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.SelectList(list => list
.Select(() => loadCarAlias.Id).WithAlias(() => resultAlias.Id)
.Select(() => loadCarAlias.TimeStamp).WithAlias(() => resultAlias.Date)
.Select(() => DocumentType.CarLoadDocument).WithAlias(() => resultAlias.DocTypeEnum)
.Select(() => carAlias.Model).WithAlias(() => resultAlias.CarModel)
.Select(() => carAlias.RegistrationNumber).WithAlias(() => resultAlias.CarNumber)
.Select(() => driverAlias.LastName).WithAlias(() => resultAlias.DirverSurname)
.Select(() => driverAlias.Name).WithAlias(() => resultAlias.DirverName)
.Select(() => driverAlias.Patronymic).WithAlias(() => resultAlias.DirverPatronymic)
.Select(() => warehouseAlias.Name).WithAlias(() => resultAlias.Warehouse)
.Select(() => routeListAlias.Id).WithAlias(() => resultAlias.RouteListId)
.Select(() => authorAlias.LastName).WithAlias(() => resultAlias.AuthorSurname)
.Select(() => authorAlias.Name).WithAlias(() => resultAlias.AuthorName)
.Select(() => authorAlias.Patronymic).WithAlias(() => resultAlias.AuthorPatronymic)
.Select(() => lastEditorAlias.LastName).WithAlias(() => resultAlias.LastEditorSurname)
.Select(() => lastEditorAlias.Name).WithAlias(() => resultAlias.LastEditorName)
.Select(() => lastEditorAlias.Patronymic).WithAlias(() => resultAlias.LastEditorPatronymic)
.Select(() => loadCarAlias.LastEditedTime).WithAlias(() => resultAlias.LastEditedTime))
.TransformUsing(Transformers.AliasToBean <DocumentVMNode> ())
.List <DocumentVMNode> ();
result.AddRange(carLoadList);
}
if (Filter.RestrictDocumentType == null || Filter.RestrictDocumentType == DocumentType.CarUnloadDocument)
{
var carUnloadQuery = UoW.Session.QueryOver <CarUnloadDocument>(() => unloadCarAlias)
.JoinQueryOver(() => unloadCarAlias.Warehouse, () => warehouseAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinQueryOver(() => unloadCarAlias.RouteList, () => routeListAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinQueryOver(() => routeListAlias.Car, () => carAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinQueryOver(() => routeListAlias.Driver, () => driverAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin);
if (Filter.RestrictWarehouse != null)
{
carUnloadQuery.Where(() => unloadCarAlias.Warehouse.Id == Filter.RestrictWarehouse.Id);
}
if (Filter.RestrictStartDate.HasValue)
{
carUnloadQuery.Where(() => unloadCarAlias.TimeStamp >= Filter.RestrictStartDate.Value);
}
if (Filter.RestrictEndDate.HasValue)
{
carUnloadQuery.Where(() => unloadCarAlias.TimeStamp < Filter.RestrictEndDate.Value.AddDays(1));
}
if (Filter.RestrictDriver != null)
{
carUnloadQuery.Where(() => routeListAlias.Driver.Id == Filter.RestrictDriver.Id);
}
var carUnloadList = carUnloadQuery
.JoinAlias(() => unloadCarAlias.Author, () => authorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.JoinAlias(() => unloadCarAlias.LastEditor, () => lastEditorAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin)
.SelectList(list => list
.Select(() => unloadCarAlias.Id).WithAlias(() => resultAlias.Id)
.Select(() => unloadCarAlias.TimeStamp).WithAlias(() => resultAlias.Date)
.Select(() => DocumentType.CarUnloadDocument).WithAlias(() => resultAlias.DocTypeEnum)
.Select(() => carAlias.Model).WithAlias(() => resultAlias.CarModel)
.Select(() => carAlias.RegistrationNumber).WithAlias(() => resultAlias.CarNumber)
.Select(() => driverAlias.LastName).WithAlias(() => resultAlias.DirverSurname)
.Select(() => driverAlias.Name).WithAlias(() => resultAlias.DirverName)
.Select(() => driverAlias.Patronymic).WithAlias(() => resultAlias.DirverPatronymic)
.Select(() => warehouseAlias.Name).WithAlias(() => resultAlias.Warehouse)
.Select(() => routeListAlias.Id).WithAlias(() => resultAlias.RouteListId)
.Select(() => authorAlias.LastName).WithAlias(() => resultAlias.AuthorSurname)
.Select(() => authorAlias.Name).WithAlias(() => resultAlias.AuthorName)
.Select(() => authorAlias.Patronymic).WithAlias(() => resultAlias.AuthorPatronymic)
.Select(() => lastEditorAlias.LastName).WithAlias(() => resultAlias.LastEditorSurname)
.Select(() => lastEditorAlias.Name).WithAlias(() => resultAlias.LastEditorName)
.Select(() => lastEditorAlias.Patronymic).WithAlias(() => resultAlias.LastEditorPatronymic)
.Select(() => unloadCarAlias.LastEditedTime).WithAlias(() => resultAlias.LastEditedTime))
.TransformUsing(Transformers.AliasToBean <DocumentVMNode> ())
.List <DocumentVMNode> ();
result.AddRange(carUnloadList);
}
result.Sort((x, y) => {
if (x.Date < y.Date)
{
return(1);
}
if (x.Date == y.Date)
{
return(0);
}
return(-1);
});
SetItemsSource(result);
}
public async Task Handle(IncomingInvoiceRegisteredEvent message)
{
var invoice = new IncomingInvoice();
invoice.TaxableAmount = message.TaxableAmount;
invoice.Currency = message.Currency;
invoice.Date = message.InvoiceDate;
invoice.DueDate = message.DueDate;
invoice.Description = message.Description;
invoice.Number = message.InvoiceNumber;
invoice.OriginalId = message.InvoiceId;
invoice.PurchaseOrderNumber = message.PurchaseOrderNumber;
invoice.Taxes = message.Taxes;
invoice.TotalPrice = message.TotalPrice;
invoice.IsOverdue = false;
invoice.IsPaid = false;
invoice.Customer = new Invoice.PartyInfo()
{
City = message.Customer.City,
Country = message.Customer.Country,
Name = message.Customer.Name,
NationalIdentificationNumber = message.Customer.NationalIdentificationNumber,
OriginalId = message.Customer.Id,
PostalCode = message.Customer.PostalCode,
StreetName = message.Customer.StreetName,
VatIndex = message.Customer.VatIndex
};
invoice.Supplier = new Invoice.PartyInfo()
{
City = message.Supplier.City,
Country = message.Supplier.Country,
Name = message.Supplier.Name,
NationalIdentificationNumber = message.Supplier.NationalIdentificationNumber,
OriginalId = message.Supplier.Id,
PostalCode = message.Supplier.PostalCode,
StreetName = message.Supplier.StreetName,
VatIndex = message.Supplier.VatIndex
};
if (message.LineItems != null && message.LineItems.Count() > 0)
{
invoice.InvoiceLineItems = message.LineItems.Select(i => new InvoiceLineItem
{
Code = i.Code,
Description = i.Description,
Quantity = i.Quantity,
TotalPrice = i.TotalPrice,
UnitPrice = i.UnitPrice,
Vat = i.Vat
}).ToList();
}
if (message.PricesByVat != null && message.PricesByVat.Count() > 0)
{
invoice.PricesByVat = message.PricesByVat.Select(p => new PriceByVat
{
TaxableAmount = p.TaxableAmount,
TotalPrice = p.TotalPrice,
VatAmount = p.VatAmount,
VatRate = p.VatRate
}).ToList();
}
if (message.NonTaxableItems != null && message.NonTaxableItems.Count() > 0)
{
invoice.NonTaxableItems = message.NonTaxableItems.Select(t => new NonTaxableItem
{
Description = t.Description,
Amount = t.Amount
}).ToList();
}
invoice.PricesAreVatIncluded = message.PricesAreVatIncluded;
using (var ctx = new AccountancyDbContext(Options))
{
ctx.IncomingInvoices.Add(invoice);
await ctx.SaveChangesAsync();
}
}
public IncomingInvoiceDocumentRDL(IncomingInvoice document, int?currentEmployeeId)
{
Document = document;
CurrentEmployeeId = currentEmployeeId;
}
