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))); }