Entity query - calculate the difference between income and expenses a

Mishkkk

Help me please!!!

I have:

public class Warehouse
{
public int WarehouseId { get; set; }
public DateTime? DateOperation { get; set; }// date record
public int Nomenclature { get; set; }// name
public int Operation { get; set; }// operation: only income and expense
public decimal Quantity { get; set; }
}
using (Cxt db = new Cxt())
{
gridQuery.DataSource = ???
}

i need to calculate the difference between income and expense and show everything in the table. I think the approach should be:

select all fields income, summarize, select all fields expenditure, summarize, subtract from the amounts of income the amount of expenditure and write in the table, and so on all fields of the nomenclature.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mishkkk5y ago
here only quantity, no prices. Only the amount of nomenclature that enters the warehouse and that leaves the warehouse.
I need leftovers, quantity. without price.
Sachin Singh5y ago
as per your schema , the code i gave you is correct , but in your classes there is no property such as income and expense , i do understand that expenses may be calculated as quantity*Price but you have no price property as well , so how do you suppose to calculate income and expense?
please explain what do you mean by income and expense and in which context?
Mishkkk5y ago
1. public partial class Warehouse
2. {
3. public int WarehouseId { get; set; }
4. public int OperationId { get; set; }
5. public int NomenclatureId { get; set; }
6. public decimal Quantity { get; set; }
7. public DateTime? DateOperation { get; set; }
8. public virtual Nomenclature Nomenclature { get; set; }
9. public virtual Operation Operation { get; set; }
10. }
11. public partial class Nomenclature
12. {
13. public Nomenclature() => Warehouses = new HashSet();
14. public int NomenclatureId { get; set; }
15. public string NomenclatureName { get; set; }
16. public virtual ICollection Warehouses { get; set; }
17. }
18. public partial class Operation
19. {
20. public Operation() => Warehouses = new HashSet();
21. public int OperationId { get; set; }
22. public string OperationName { get; set; }
23. public virtual ICollection Warehouses { get; set; }
24. }

Sachin Singh5y ago

i believe that Nomenclature and Operation are foreign keys , then with Entity Framework you get navigation property which enables you to access related properties.

Please share your all entities, if you find it strange.

Mishkkk5y ago

How x.Operation.Income-x.Operation.Expense?

Sachin Singh5y ago

var result =( cxt.WareHouse.Select(x=>new {
Name= x.Nomenclature.Name // it must be a navigation property.
Saving= x.Operation.Income-x.Operation.Expense;
}).ToList();