Search results for query: *

  1. Gcobani54

    Joining three entities using linq

    Hi Team I have a method that calls three 3 tables, but now i am getting an error says ' variable does not exist in current context'. How do i fix this issue? public IList<ExtractionViewModel> GetExtractionViewModels(string year, int week) {...
  2. Gcobani54

    Joining three entities using linq

    This where i need help in with
  3. Gcobani54

    Joining three entities using linq

    Hi Team I need some help in joining three entities using linq, i have one join but the problem i have i am getting a repetion of years, weekNum and day colums with data being incorrect. public IList<ExtractionViewModel> GetExtractionViewModels(string year, int week) {...
  4. Gcobani54

    How make a query dynamic to filter records in the tables?

    SELECT TOP (1000) [ModelId] ,[Name] ,[Code] ,[CreatedDate] ,[CreatedBy] ,[ModifiedDate] ,[ModifiedBy] ,[InActive] FROM [ProductionManagement].[Schedule].[Model] where Name = 'VW270' order by InActive;
  5. Gcobani54

    How make a query dynamic to filter records in the tables?

    Hi Team I have a problem and need some help, problem my data on excel is duplicating year and week, e.g if there is a data on year 2020, it does, but still count on week as 2, 2, 3, 3. While on front end it count only 1,2 only. Yet if there is no data on any year my excel must do the same and...
  6. Gcobani54

    How make a query dynamic to filter records in the tables?

    I think if can have an example, will attempt something on my side and get back if i am stuck, thanks.
  7. Gcobani54

    How make a query dynamic to filter records in the tables?

    Hi Team I am struggling to make my query dynamic, what i mean here the record list must be formatted. Currently now i will attached the output of my excel and columns are not formatted for data be exposed. The first attachment is my current data. The out output must be second attachment, will...
Back
Top Bottom