public ICollection <TallySearchDto> GetTallySearch(SocDto soc)
{
var quary = string.Format(@"select DealerInformation.DealerName,ProductOrder.OrderId,ProductOrder.Orderdate,ProductOrder.Quantity,PaymentOrder.ChequeNo,PaymentOrder.PaymentMethod,PaymentOrder.PaymentDate,OrderState.StateName as Status from ProductOrder
inner join DealerInformation on ProductOrder.DealerId = DealerInformation.DealerId
inner join PaymentOrder on ProductOrder.OrderId = PaymentOrder.OrderId
inner join OrderState on ProductOrder.StateId = OrderState.OrderStateId
where Soc = '{0}'", soc.SearchSoc);
return(new Data <TallySearchDto>(_connection).DataSource(quary));
}
public ICollection <TallySearchDto> GetTallySearch(SocDto soc)
{
return(_unitOfWork.TallyPoint.GetTallySearch(soc));
}
public IActionResult SearchSoc(SocDto Soc)
{
return(Ok(_tallySearchServices.GetTallySearch(Soc)));
}
