public async Task <DesignationDto> GetDesignationByIdAsync(int id)
{
return(await _dapperManager.QuerySingleAsync <DesignationDto>("SELECT * FROM Designation WHERE DesignationId=@id", new { id }));
}
public async Task <OrganizationInfoDto> GetOrganizationInfoAsync()
{
var obj = await _dapperManager.QuerySingleAsync <OrganizationInfoDto>("SELECT * FROM OrganizationInfo");
return(obj);
}
public async Task <ProductDto> GetProductByIdAsync(int id)
{
return(await _dapperManager.QuerySingleAsync <ProductDto>("SELECT * FROM ProductView " +
"WHERE ProductId=@id", new { id }));
}
public async Task <CustomerQueryDto> GetQueryByIdAsync(int id)
{
return(await _dapperManager.QuerySingleAsync <CustomerQueryDto>("SELECT * FROM CustomerQuery WHERE Id=@id", new { id }));
}
public async Task <FiscalYearDto> GetFiscalYearByIdAsync(int id)
{
return(await _dapperManager.QuerySingleAsync <FiscalYearDto>("SELECT * FROM FiscalYear WHERE FiscalYearId=@id", new { id }));
}
public async Task <UnitDto> GetUnitByIdAsync(int id)
{
return(await _dapperManager.QuerySingleAsync <UnitDto>("SELECT * FROM Unit WHERE UnitId=@id", new { id }));
}
public async Task <RoleDto> GetRoleByIdAsync(int id)
{
return(await _dapperManager.QuerySingleAsync <RoleDto>("SELECT * FROM Role WHERE RoleId=@id", new { id }));
}
public async Task <MenuAccessPermissionDto> GetMenuAccessByIdAsync(int id)
{
return(await _dapperManager.QuerySingleAsync <MenuAccessPermissionDto>("SELECT * FROM MenuAccessPermission WHERE MenuAccessPermissionId=@id", new { id }));
}
public async Task <AccountHeadDto> GetAllAccountHeadByIdAsync(int id)
{
return(await _dapperManager.QuerySingleAsync <AccountHeadDto>("SELECT * FROM AccountHead WHERE AccountHeadId=@id", new { id }));
}
public async Task <SupplierDto> GetSupplierByIdAsync(int id)
{
return(await _dapperManager.QuerySingleAsync <SupplierDto>("SELECT * FROM Supplier WHERE SupplierId=@id", new { id }));
}
public async Task <DepartmentDto> GetDepartmentByIdAsync(int id)
{
return(await _dapperManager.QuerySingleAsync <DepartmentDto>("SELECT * FROM Department WHERE DepartmentId=@id", new { id }));
}