public IList<Roles> FindAllRole()
{
string sql = UserStoredProceduresNames.GetAllRole;
return _sqlServerFindData.FindData<Roles>(sql);
}
public async Task <int> GetHighestAutoId()
{
string sql = AutoStoredProceduresNames.QueryForHighestAutoID;
return(await Task.Run(() => _sqlServerFindData.FindData(sql)));
}
public IList <UserSaleCommissionReport> LoadUserCommissionReport()
{
string sql = ReportStoredProceduresNames.GetUserSaleReport;
return(_sqlServerFindData.FindData <UserSaleCommissionReport>(sql));
}
public async Task <Auto> FindAutoAsync(int id)
{
string sql = AutoStoredProceduresNames.GetAutoByID;
return(await Task.Run(() => _sqlServerFindData?.FindData <Auto>(sql, id).FirstOrDefault()));
}
public async Task <int> GetHighestCustomerId()
{
string sql = SaleStoredProcedureNames.GetHighestCustomerID;
return(await Task.Run(() => _sqlServerFindData.FindData(sql)));
}