public async Task <int> RemainingCarsAsync()
{
var sql = "SELECT [dbo].[fnGetRemainingCars]()";
var result = await SCObjects.ReturnTextAsync(sql, Properties.Settings.Default.UserConnectionString);
return(int.Parse(result));
}
public async Task <decimal> TodaySalesAsync(DateTime date)
{
var sql = string.Format("SELECT [dbo].[fnGetTodaySales]('{0}')", date.ToString("MM/dd/yyyy"));
var result = await SCObjects.ReturnTextAsync(sql, Properties.Settings.Default.UserConnectionString);
return(decimal.Parse(result));
}
public async Task <decimal> WeeklyTotalSalesAsync()
{
var sql = "EXEC [dbo].[spWeeklySalesDecimal]";
var result = await SCObjects.ReturnTextAsync(sql, Properties.Settings.Default.UserConnectionString);
return(decimal.Parse(result));
}
public async Task <int> ProcessedTicketsAsync(DateTime date)
{
var sql = string.Format("SELECT [dbo].[fnGetProcessedTickets]('{0}')", date.ToString("MM/dd/yyyy"));
var result = await SCObjects.ReturnTextAsync(sql, Properties.Settings.Default.UserConnectionString);
return(int.Parse(result));
}