예제 #1
0
        public async Task SaveLevyDeclaration(LevyDeclarationViewModel levyDeclaration)
        {
            await WithConnection(async c =>
            {
                var parameters = new DynamicParameters();
                parameters.Add("@DasAccountId", levyDeclaration.HashedAccountId, DbType.String);
                parameters.Add("@LevyDeclarationId", levyDeclaration.Id, DbType.Int64);
                parameters.Add("@PayeSchemeReference", levyDeclaration.PayeSchemeReference, DbType.String);
                parameters.Add("@LevyDueYearToDate", levyDeclaration.LevyDueYtd, DbType.Decimal);
                parameters.Add("@LevyAllowanceForYear", levyDeclaration.LevyAllowanceForYear, DbType.Decimal);
                parameters.Add("@SubmissionDate", levyDeclaration.SubmissionDate, DbType.DateTime);
                parameters.Add("@SubmissionId", levyDeclaration.SubmissionId, DbType.Int64);
                parameters.Add("@PayrollYear", levyDeclaration.PayrollYear, DbType.String);
                parameters.Add("@PayrollMonth", levyDeclaration.PayrollMonth, DbType.Int16);
                parameters.Add("@CreatedDate", levyDeclaration.CreatedDate, DbType.DateTime);
                parameters.Add("@EndOfYearAdjustment", levyDeclaration.EndOfYearAdjustment, DbType.Boolean);
                parameters.Add("@EndOfYearAdjustmentAmount", levyDeclaration.EndOfYearAdjustmentAmount, DbType.Decimal);
                parameters.Add("@DateCeased", levyDeclaration.DateCeased, DbType.DateTime);
                parameters.Add("@InactiveFrom", levyDeclaration.InactiveFrom, DbType.DateTime);
                parameters.Add("@InactiveTo", levyDeclaration.InactiveTo, DbType.DateTime);
                parameters.Add("@HmrcSubmissionId", levyDeclaration.HmrcSubmissionId, DbType.Int64);
                parameters.Add("@EnglishFraction", levyDeclaration.EnglishFraction, DbType.Decimal);
                parameters.Add("@TopupPercentage", levyDeclaration.TopUpPercentage, DbType.Decimal);
                parameters.Add("@TopupAmount", levyDeclaration.TopUp, DbType.Decimal);
                parameters.Add("@LevyDeclaredInMonth", levyDeclaration.LevyDeclaredInMonth, DbType.Decimal);
                parameters.Add("@LevyAvailableInMonth", levyDeclaration.TotalAmount, DbType.Decimal);

                return(await c.ExecuteAsync(
                           sql: "[Data_Load].[SaveLevyDeclaration]",
                           param: parameters,
                           commandType: CommandType.StoredProcedure));
            });
        }
예제 #2
0
        public void InsertIntoLevyDeclarations(dynamic value, ICollection <string> columns)
        {
            var levyDeclaration = new LevyDeclarationViewModel();

            levyDeclaration.HashedAccountId = columns.Contains("DasAccountId") ? value.DasAccountId : null;
            levyDeclaration.Id = columns.Contains("LevyDeclarationId") ? value.LevyDeclarationId : (long)43256;
            levyDeclaration.PayeSchemeReference       = columns.Contains("PayeSchemeReference") ? value.PayeSchemeReference : null;
            levyDeclaration.LevyDueYtd                = columns.Contains("LevyDueYearToDate") ? ConvertToType <decimal>(value.LevyDueYearToDate) : null;
            levyDeclaration.LevyAllowanceForYear      = columns.Contains("LevyAllowanceForYear") ? ConvertToType <decimal>(value.LevyAllowanceForYear) : null;
            levyDeclaration.SubmissionDate            = columns.Contains("SubmissionDate") ? value.SubmissionDate : DateTime.Now.AddDays(-100);
            levyDeclaration.SubmissionId              = columns.Contains("SubmissionId") ? value.SubmissionId : (long)66666;
            levyDeclaration.PayrollYear               = columns.Contains("PayrollYear") ? value.PayrollYear.ToString() : null;
            levyDeclaration.PayrollMonth              = columns.Contains("PayrollMonth") ? ConvertToType <short>(value.PayrollMonth) : null;
            levyDeclaration.CreatedDate               = columns.Contains("CreatedDate") ? value.CreatedDate : DateTime.Now.AddDays(-250);
            levyDeclaration.EndOfYearAdjustment       = columns.Contains("EndOfYearAdjustment") ? value.EndOfYearAdjustment : default(bool);
            levyDeclaration.EndOfYearAdjustmentAmount = columns.Contains("EndOfYearAdjustmentAmount") ? ConvertToType <decimal>(value.EndOfYearAdjustmentAmount) : null;
            levyDeclaration.DateCeased                = columns.Contains("DateCeased") ? value.DateCeased : null;
            levyDeclaration.InactiveFrom              = columns.Contains("InactiveFrom") ? value.InactiveFrom : null;
            levyDeclaration.InactiveTo                = columns.Contains("InactiveTo") ? value.InactiveTo : null;
            levyDeclaration.HmrcSubmissionId          = columns.Contains("HmrcSubmissionId") ? ConvertToType <long>(value.HmrcSubmissionId) : (long)777777;
            levyDeclaration.EnglishFraction           = columns.Contains("EnglishFraction") ? ConvertToType <decimal>(value.EnglishFraction) : (decimal)1.00000;
            levyDeclaration.TopUpPercentage           = columns.Contains("TopupPercentage") ? ConvertToType <decimal>(value.TopupPercentage) : (decimal)0.10000;
            levyDeclaration.TopUp = columns.Contains("TopupAmount") ? ConvertToType <decimal>(value.TopupAmount) : (decimal)100.0000;
            levyDeclaration.LevyDeclaredInMonth = columns.Contains("LevyDeclaredInMonth") ? ConvertToType <decimal>(value.LevyDeclaredInMonth) : (decimal)10000.00000;
            levyDeclaration.TotalAmount         = columns.Contains("LevyAvailableInMonth") ? ConvertToType <decimal>(value.LevyAvailableInMonth) : (decimal)11000.00000;

            var levyrepo = new LevyDeclarationRepository(_connectionString);

            levyrepo.SaveLevyDeclaration(levyDeclaration).Wait();
        }