コード例 #1
0
        private TaxFormulaCalculatedOnInfo GetTaxFormulaChargeCaculatedOnValues(DataRow dr)
        {
            TaxFormulaCalculatedOnInfo taxformulachargecalcultedon = new TaxFormulaCalculatedOnInfo();

            if (dr["TaxFormulaChargesId"] != DBNull.Value)
            {
                taxformulachargecalcultedon.TaxFormulaChargeId = Convert.ToInt32(dr["TaxFormulaChargesId"]);
            }

            if (dr["ChargesId"] != DBNull.Value)
            {
                taxformulachargecalcultedon.TaxChargesId = Convert.ToInt32(dr["ChargesId"]);
            }

            if (dr["ChargesName"] != DBNull.Value)
            {
                taxformulachargecalcultedon.TaxChargesName = Convert.ToString(dr["ChargesName"]);
            }

            if (dr["IsFixPrice"] != DBNull.Value)
            {
                taxformulachargecalcultedon.IsFixPrice = Convert.ToBoolean(dr["IsFixPrice"]);
            }

            if (dr["CalculatedOnId"] != DBNull.Value)
            {
                taxformulachargecalcultedon.CalculatedOnId = Convert.ToInt32(dr["CalculatedOnId"]);
            }

            List <KeyValueInfo> GetChargesRateTypes = LookupInfo.GetChargesRateTypes();

            if (taxformulachargecalcultedon.CalculatedOnId == 1)
            {
                taxformulachargecalcultedon.CalculatedOnName = GetChargesRateTypes[0].Value;
            }
            if (taxformulachargecalcultedon.CalculatedOnId == 2)
            {
                taxformulachargecalcultedon.CalculatedOnName = GetChargesRateTypes[1].Value;
            }
            if (taxformulachargecalcultedon.CalculatedOnId == 3)
            {
                taxformulachargecalcultedon.CalculatedOnName = GetChargesRateTypes[2].Value;
            }


            if (dr["Behaviour"] != DBNull.Value)
            {
                taxformulachargecalcultedon.Behaviour = Convert.ToString(dr["Behaviour"]);
            }

            return(taxformulachargecalcultedon);
        }
コード例 #2
0
        public TaxFormulaCalculatedOnInfo GetTaxFormulaChargeCaculatedOnFormula(TaxFormulaCalculatedOnInfo tfcoi)
        {
            //TaxFormulaCalculatedOnInfo taxformulacalonbehaviour = new TaxFormulaCalculatedOnInfo();

            tfcoi.TaxFormulaChargeId = tfcoi.TaxFormulaChargeId;

            tfcoi.TaxChargesId = tfcoi.TaxChargesId;

            tfcoi.TaxChargesName = tfcoi.TaxChargesName;

            tfcoi.CalOnBehaviour = tfcoi.CalOnBehaviour;

            return(tfcoi);
        }
コード例 #3
0
        public void InsertTaxFormulaCalculatedOn(TaxFormulaCalculatedOnInfo taxformulacalculatedon, int taxFormulaChargesId)
        {
            List <SqlParameter> sqlParams = new List <SqlParameter>();

            sqlParams.Add(new SqlParameter("@TaxFormulaChargesId", taxFormulaChargesId));

            Logger.Debug("TaxFormula Controller TaxFormulaChargesId:" + taxFormulaChargesId);

            sqlParams.Add(new SqlParameter("@IsFixPrice", taxformulacalculatedon.IsFixPrice));

            Logger.Debug("TaxFormula Controller IsFixPrice:" + taxformulacalculatedon.IsFixPrice);

            sqlParams.Add(new SqlParameter("@CalculatedOnId", taxformulacalculatedon.CalculatedOnId));

            Logger.Debug("TaxFormula Controller CalculatedOnId:" + taxformulacalculatedon.CalculatedOnId);

            sqlParams.Add(new SqlParameter("@Behaviour", taxformulacalculatedon.Behaviour));

            Logger.Debug("TaxFormula Controller Behaviour:" + taxformulacalculatedon.Behaviour);

            _sqlHelper.ExecuteNonQuery(sqlParams, Storeprocedures.spInsertTaxFormulaCalculatedOn.ToString(), CommandType.StoredProcedure);
        }