Entity query - calculate the difference between income and expenses a

Question

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.

Sachin Singh · Answer

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?

Sachin Singh · Answer

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.

Sachin Singh · Answer

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();

Mishkkk · Answer

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.

Mishkkk · Answer

public partial class Warehouse { public int WarehouseId { get ; set ; } public int OperationId { get ; set ; } public int NomenclatureId { get ; set ; } public decimal Quantity { get ; set ; } public DateTime? DateOperation { get ; set ; } public virtual Nomenclature Nomenclature { get ; set ; } public virtual Operation Operation { get ; set ; } } public partial class Nomenclature { public Nomenclature() => Warehouses = new HashSet(); public int NomenclatureId { get ; set ; } public string NomenclatureName { get ; set ; } public virtual ICollection Warehouses { get ; set ; } } public partial class Operation { public Operation() => Warehouses = new HashSet(); public int OperationId { get ; set ; } public string OperationName { get ; set ; } public virtual ICollection Warehouses { get ; set ; } }

Mishkkk · Answer

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