//Need to FindByCriteria Temp Table AdjustmentVoucherTransaction
public List<AdjustmentVoucher> FindAdjustmentVoucherByCriteria(AdjustmentVoucherSearchDTO adjustmentVoucherSearchDTO)
{
var tempQuery = (from r in context.AdjustmentVouchers
where 1 == 1
select r);
if (adjustmentVoucherSearchDTO != null)
{
if (adjustmentVoucherSearchDTO.AdjustmentVoucherID != -1)
{
tempQuery = tempQuery.Where(r => r.AdjustmentVoucherID == adjustmentVoucherSearchDTO.AdjustmentVoucherID);
}
if (adjustmentVoucherSearchDTO.StartDate != null && adjustmentVoucherSearchDTO.EndDate != null)
{
tempQuery = tempQuery.Where(r => r.DateIssued >= adjustmentVoucherSearchDTO.StartDate && r.DateIssued <= adjustmentVoucherSearchDTO.EndDate);
}
if (adjustmentVoucherSearchDTO.StartDate != null)
{
tempQuery = tempQuery.Where(r => r.DateIssued == adjustmentVoucherSearchDTO.StartDate);
}
if (adjustmentVoucherSearchDTO.EndDate != null)
{
tempQuery = tempQuery.Where(r => r.DateIssued == adjustmentVoucherSearchDTO.EndDate);
}
}
return (from q in tempQuery select q).ToList<AdjustmentVoucher>();
}
public List<StockLog> GetAllStockLogByCriteria(AdjustmentVoucherSearchDTO adjustmentVoucherSearchDTO)
{
try
{
var Query =
from u in context.StockLogs
where u.StockLogID == (adjustmentVoucherSearchDTO.StockLogID == 0 ? u.StockLogID : adjustmentVoucherSearchDTO.StockLogID)
&& u.AdjustmentVoucherID == (adjustmentVoucherSearchDTO.AdjustmentVoucherID == 0 ? u.AdjustmentVoucherID : adjustmentVoucherSearchDTO.AdjustmentVoucherID)
&& u.StationeryID == (adjustmentVoucherSearchDTO.StationeryID == 0 ? u.Type : adjustmentVoucherSearchDTO.StationeryID)
&& u.Type == (adjustmentVoucherSearchDTO.Type == 0 ? u.Type : adjustmentVoucherSearchDTO.Type)
&& u.Reason == (adjustmentVoucherSearchDTO.Reason == null ? u.Reason : adjustmentVoucherSearchDTO.Reason)
&& u.Quantity == (adjustmentVoucherSearchDTO.Quantity == 0 ? u.Quantity : adjustmentVoucherSearchDTO.Quantity)
&& u.Balance == (adjustmentVoucherSearchDTO.Balance == 0 ? u.Balance : adjustmentVoucherSearchDTO.Balance)
select u;
List<StockLog> stockLog = Query.ToList<StockLog>();
return stockLog;
}
catch (Exception ex)
{
throw new Exception("Stock Log Transaction Get All Records By Criteria Return Error" + ex.Message);
}
}
public List<StockLog> GetAllStockLogByCriteria(AdjustmentVoucherSearchDTO criteria)
{
try
{
return adjustmentVoucherDAO.GetAllStockLogByCriteria(criteria);
}
catch (Exception ex)
{
throw new Exception("Stock Log Get All Records By Criteria Return Error" + ex.Message);
}
}
