コード例 #1
0
 public async Task <DesignationDto> GetDesignationByIdAsync(int id)
 {
     return(await _dapperManager.QuerySingleAsync <DesignationDto>("SELECT * FROM Designation WHERE DesignationId=@id", new { id }));
 }
コード例 #2
0
        public async Task <OrganizationInfoDto> GetOrganizationInfoAsync()
        {
            var obj = await _dapperManager.QuerySingleAsync <OrganizationInfoDto>("SELECT * FROM OrganizationInfo");

            return(obj);
        }
コード例 #3
0
 public async Task <ProductDto> GetProductByIdAsync(int id)
 {
     return(await _dapperManager.QuerySingleAsync <ProductDto>("SELECT * FROM ProductView " +
                                                               "WHERE ProductId=@id", new { id }));
 }
コード例 #4
0
 public async Task <CustomerQueryDto> GetQueryByIdAsync(int id)
 {
     return(await _dapperManager.QuerySingleAsync <CustomerQueryDto>("SELECT * FROM CustomerQuery WHERE Id=@id", new { id }));
 }
コード例 #5
0
 public async Task <FiscalYearDto> GetFiscalYearByIdAsync(int id)
 {
     return(await _dapperManager.QuerySingleAsync <FiscalYearDto>("SELECT * FROM FiscalYear WHERE FiscalYearId=@id", new { id }));
 }
コード例 #6
0
ファイル: UnitRepository.cs プロジェクト: sanjuktasunar/WEB
 public async Task <UnitDto> GetUnitByIdAsync(int id)
 {
     return(await _dapperManager.QuerySingleAsync <UnitDto>("SELECT * FROM Unit WHERE UnitId=@id", new { id }));
 }
コード例 #7
0
ファイル: RoleRepository.cs プロジェクト: sanjuktasunar/WEB
 public async Task <RoleDto> GetRoleByIdAsync(int id)
 {
     return(await _dapperManager.QuerySingleAsync <RoleDto>("SELECT * FROM Role WHERE RoleId=@id", new { id }));
 }
コード例 #8
0
 public async Task <MenuAccessPermissionDto> GetMenuAccessByIdAsync(int id)
 {
     return(await _dapperManager.QuerySingleAsync <MenuAccessPermissionDto>("SELECT * FROM MenuAccessPermission WHERE MenuAccessPermissionId=@id", new { id }));
 }
コード例 #9
0
 public async Task <AccountHeadDto> GetAllAccountHeadByIdAsync(int id)
 {
     return(await _dapperManager.QuerySingleAsync <AccountHeadDto>("SELECT * FROM AccountHead WHERE AccountHeadId=@id", new { id }));
 }
コード例 #10
0
 public async Task <SupplierDto> GetSupplierByIdAsync(int id)
 {
     return(await _dapperManager.QuerySingleAsync <SupplierDto>("SELECT * FROM Supplier WHERE SupplierId=@id", new { id }));
 }
コード例 #11
0
 public async Task <DepartmentDto> GetDepartmentByIdAsync(int id)
 {
     return(await _dapperManager.QuerySingleAsync <DepartmentDto>("SELECT * FROM Department WHERE DepartmentId=@id", new { id }));
 }