public bool Check_ExchangeRatesAreCurrent()
{
using (new SharedConnection(dbConnection))
{
var result = dbConnection.Query <ExchangeRate>(SqlLoader.GetSql("Check_ExchangeRatesAreCurrent"));
return(result.Any() ? false : true);
}
}
public IEnumerable <InvoiceHeader_DataModel> Fetch_ConsignmentInvoiceHeaders(int consignment_Number)
{
using (new SharedConnection(dbConnection))
{
var result = dbConnection.Query <InvoiceHeader_DataModel>(SqlLoader.GetSql("Fetch_ConsignmentInvoiceHeader"),
consignment_Number
);
return(result.Any() ? result : null);
}
}
public IEnumerable <Consignment_DataModel> Fetch_AllActiveConsignments(string inlandDepotList)
{
using (new SharedConnection(dbConnection))
{
var result = dbConnection.Query <Consignment_DataModel>(SqlLoader.GetSql("Fetch_AllActiveConsignments"),
inlandDepotList,
DateParameter
);
return(result.Any() ? result : null);
}
}