//For Search Grid public List <INVStoreTrans> GetTransactionInfoForSearch(string _TransactionType) { using (_context) { var AllData = (from t in _context.INV_StoreTrans where t.TransactionCategory == "ISU" & t.TransactionType == _TransactionType join r in _context.INV_StoreTransRequest on t.TransactionID equals r.TransactionID into ReqInfo from r in ReqInfo.DefaultIfEmpty() from tf in _context.SYS_Store.Where(x => (x.StoreID).ToString() == t.TransactionFrom).DefaultIfEmpty() from tt in _context.SYS_Store.Where(x => (x.StoreID).ToString() == t.TransactionTo).DefaultIfEmpty() orderby t.TransactionID descending select new INVStoreTrans { TransactionID = t.TransactionID, TransactionNo = t.TransactionNo, TransactionDateTemp = (t.TransactionDate), TransactionFrom = (tf == null ? null : tf.StoreName), TransactionTo = (tt == null ? null : tt.StoreName), RecordStatus = (t.RecordStatus), ReqFromDateTemp = (r.ReqFromDate), ReqToDateTemp = (r.ReqToDate), RequisitionNo = r.RequestNo }).ToList(); return(AllData); } }