コード例 #1
0
ファイル: DBReadManager.cs プロジェクト: Skalie18/Myproject
        public static OutGoingCBCDeclarations OutGoingCBCDeclarationsDetails(string countryCode, string reportingPeriod)
        {
            var result = new OutGoingCBCDeclarations("[dbo].[uspREAD_OutGoingCBCDeclarationsDetails]", new Dictionary <string, object> {
                { "@CountryCode", countryCode }, { "@ReportingPeriod", reportingPeriod }
            });

            return(result.GetRecord <OutGoingCBCDeclarations>());
        }
コード例 #2
0
ファイル: DBReadManager.cs プロジェクト: Skalie18/Myproject
        public static OutGoingCBCDeclarations IncomingCBCDeclaration(int statusId, string countryCode, string ReportingPeriod)
        {
            var oParams = new Dictionary <string, object>
            {
                { "@CountryCode", countryCode },
                { "@ReportingPeriod", ReportingPeriod },
                { "@StatusId", statusId }
            };
            var result = new OutGoingCBCDeclarations("[dbo].[uspREAD_IncomingForeignDeclaration]", oParams);

            return(result.GetRecord <OutGoingCBCDeclarations>());
        }
コード例 #3
0
ファイル: DatabaseReader.cs プロジェクト: Skalie18/Myproject
        public static OutGoingCBCDeclarations OutGoingCBCDeclarationsDetails(string countryCode, int year)
        {
            var oParams = new DBParamCollection
            {
                { "@CountryCode", countryCode },
                { "@Year", year }
            };
            var result = new OutGoingCBCDeclarations("[dbo].[uspREAD_OutGoingCBCDeclarationsDetails]", new Dictionary <string, object> {
                { "@CountryCode", countryCode }, { "@Year", year }
            });

            return(result.GetRecord <OutGoingCBCDeclarations>());
        }
コード例 #4
0
    public static OutGoingCBCDeclarations OutGoingCBCDeclarationsDetails(string countryCode, string reportingPeriod)
    {
        var oParams = new DBParamCollection
        {
            { "@CountryCode", countryCode },
            { "@ReportingPeriod", reportingPeriod }
        };
        var result = new OutGoingCBCDeclarations("[dbo].[uspREAD_OutGoingCBCDeclarationsDetails]", new Dictionary <string, object> {
            { "@CountryCode", countryCode }, { "@ReportingPeriod", reportingPeriod }
        });

        if (result.Id > 0)
        {
            return(result.GetRecord <OutGoingCBCDeclarations>());
        }
        else
        {
            return(null);
        }
    }