//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);
}
}
