public IEnumerable <TrailerViewModel> GetTrailerForSuggestion(string value) { var trailer = _trailerRepository.Query(tra => (tra.TrailerC.Contains(value) || tra.TrailerNo.Contains(value)) && tra.IsActive == Constants.ACTIVE); var destination = Mapper.Map <IEnumerable <Trailer_M>, IEnumerable <TrailerViewModel> >(trailer); return(destination); }
public TruckExpenseViewModel GetTruckExpensesByKey(int id) { var searchTruckExpense = _truckExpenseRepository.Query(t => t.Id == id).FirstOrDefault(); var truckExpense = Mapper.Map <TruckExpense_D, TruckExpenseViewModel>(searchTruckExpense); if (truckExpense != null) { // get entryClerk var employee = _employeeRepository.Query(e => e.EmployeeC == truckExpense.EntryClerkC).FirstOrDefault(); if (employee != null) { truckExpense.EntryClerkN = employee.EmployeeLastN + " " + employee.EmployeeFirstN; truckExpense.EntryClerkRetiredD = employee.RetiredD; } // get Ob if (truckExpense.ObjectI == "0") { var truck = _truckRepository.Query(tr => tr.TruckC == truckExpense.Code).FirstOrDefault(); truckExpense.ObjectNo = truck.RegisteredNo; truckExpense.AcquisitionD = truck.AcquisitionD; truckExpense.DisusedD = truck.DisusedD; } else if (truckExpense.ObjectI == "1") { var trailer = _trailerRepository.Query(tr => tr.TrailerC == truckExpense.Code).FirstOrDefault(); truckExpense.ObjectNo = trailer.TrailerNo; } // get expenseN var expense = _expenseRepository.Query(ex => ex.ExpenseC == truckExpense.ExpenseC).FirstOrDefault(); if (expense != null) { truckExpense.ExpenseN = expense.ExpenseN; truckExpense.TaxRate = expense.TaxRate; truckExpense.TaxRoundingI = expense.TaxRoundingI; } // get driverN if (truckExpense.DriverC != null) { var driver = _driverRepository.Query(dr => dr.DriverC == truckExpense.DriverC).FirstOrDefault(); if (driver != null) { truckExpense.DriverN = driver.LastN + " " + driver.FirstN; truckExpense.RetiredD = driver.RetiredD; } } // get supplierN if (truckExpense.SupplierMainC != null && truckExpense.SupplierSubC != null) { var supplier = _supplierRepository.Query(su => su.SupplierMainC == truckExpense.SupplierMainC && su.SupplierSubC == truckExpense.SupplierSubC ).FirstOrDefault(); if (supplier != null) { truckExpense.SupplierN = supplier.SupplierN; } } truckExpense.ExpenseI = "T"; truckExpense.TruckExpenseIndex = FindIndex(id); } return(truckExpense); }