public async static Task <IDTO> AddUpdateMode(Acttribute busnies)
        {
            string SPName  = "";
            string message = "";
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();

            if (busnies.ID.HasValue)
            {
                oracleParams.Add(AttributesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)busnies.ID ?? DBNull.Value);
                SPName  = AttributesPName.SP_UPADTE_Attribute;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(AttributesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = AttributesPName.SP_INSERT_Attribute;
                message = "Inserted Successfully";
            }
            oracleParams.Add(AttributesSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)busnies.Name ?? DBNull.Value, 1000);
            oracleParams.Add(AttributesSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)busnies.Name2 ?? DBNull.Value, 1000);
            oracleParams.Add(AttributesSpParams.PARAMETER_TYPE, OracleDbType.Long, ParameterDirection.Input, (object)busnies.Type ?? DBNull.Value, 1000);
            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = message;
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
        public async static Task <IDTO> AddUpdateMode(ReportGroup bank)
        {
            string SPName  = "";
            string message = "";
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();

            if (bank.ID.HasValue)
            {
                oracleParams.Add(ReportGroupSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)bank.ID ?? DBNull.Value);
                SPName  = ReportGroupSPName.SP_UPADTE_ReportGroup;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(ReportGroupSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = ReportGroupSPName.SP_INSERT_ReportGroup;
                message = "Inserted Successfully";
            }

            oracleParams.Add(ReportGroupSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)bank.Name ?? DBNull.Value, 500);
            oracleParams.Add(ReportGroupSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)bank.Name2 ?? DBNull.Value, 500);
            oracleParams.Add(ReportGroupSpParams.PARAMETER_ORDER_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)bank.OrderBy ?? DBNull.Value, 50);

            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = message;
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
        public async static Task <IDTO> AutoAdd(Attachment attachment)
        {
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();



            oracleParams.Add(AttachmentsSpParams.PARAMETER_UW_DOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.DocumentID ?? DBNull.Value);
            oracleParams.Add(AttachmentsSpParams.PARAMETER_UW_RISK_ID, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.RiskID ?? DBNull.Value);
            oracleParams.Add(AttachmentsSpParams.PARAMETER_CLM_ID, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.ClaimID ?? DBNull.Value);
            oracleParams.Add(AttachmentsSpParams.PARAMETER_LOC_LEVEL, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.Level ?? DBNull.Value);
            oracleParams.Add(AttachmentsSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)attachment.CreatedBy ?? DBNull.Value);
            oracleParams.Add(AttachmentsSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)attachment.CreationDate ?? DBNull.Value);


            if (await NonQueryExecuter.ExecuteNonQueryAsync(AttachmentsSpName.SP_AUTO_INSERT_ATTACHMENT, oracleParams) == -1)
            {
                complate.message = "Operation Success";
            }
            else
            {
                complate.message = "Operation Failed";
            }
            return(complate);
        }
        public async static Task <IDTO> UpdateMode(Currency currency)
        {
            OracleDynamicParameters dyParam  = new OracleDynamicParameters();
            ComplateOperation <int> complate = new ComplateOperation <int>();

            dyParam.Add(CurrencySpParams.PARAMETER_CURRENCY_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)currency.Code ?? DBNull.Value, 30);
            dyParam.Add(CurrencySpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)currency.Name ?? DBNull.Value, 500);
            dyParam.Add(CurrencySpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)currency.Name2 ?? DBNull.Value, 500);
            dyParam.Add(CurrencySpParams.PARAMETER_DECIMAL_PLACES, OracleDbType.Int32, ParameterDirection.Input, (object)currency.DecimalPlaces ?? DBNull.Value, 5);
            dyParam.Add(CurrencySpParams.PARAMETER_SIGN, OracleDbType.Varchar2, ParameterDirection.Input, (object)currency.Sign ?? DBNull.Value, 200);
            dyParam.Add(CurrencySpParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)currency.Status ?? DBNull.Value);
            dyParam.Add(CurrencySpParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)currency.StatusDate ?? DBNull.Value);
            dyParam.Add(CurrencySpParams.PARAMETER_FRACT, OracleDbType.Varchar2, ParameterDirection.Input, (object)currency.FractName ?? DBNull.Value, 500);
            dyParam.Add(CurrencySpParams.PARAMETER_FRACT2, OracleDbType.Varchar2, ParameterDirection.Input, (object)currency.FractName2 ?? DBNull.Value, 500);

            if (await NonQueryExecuter.ExecuteNonQueryAsync(CurrencySPName.SP_UPDATE_CURRENCY, dyParam) == -1)
            {
                complate.message = "Operation Successed";
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
        public async static Task <IDTO> AddUpdate(Domain.Entities.ProductSetup.ProductColumns productColumns)
        {
            string SPName  = "";
            string message = "";
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();

            if (productColumns.ID.HasValue)
            {
                oracleParams.Add(ProductColumnSpParam.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ID ?? DBNull.Value);
                SPName  = ProductColumnsSpName.SP_UPADTE_COLUMN;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(ProductColumnSpParam.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = ProductColumnsSpName.SP_INSERT_COLUMN;
                message = "Inserted Successfully";
            }


            oracleParams.Add(ProductColumnSpParam.PARAMETER_LABLE, OracleDbType.Varchar2, ParameterDirection.Input, (object)productColumns.Lable ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_LABLE2, OracleDbType.Varchar2, ParameterDirection.Input, (object)productColumns.Lable2 ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_COL_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ColumnType ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.Status ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)productColumns.StatusDate ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_LINE_OF_BUSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.LineOfBusniess ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_SUB_LINE_OF_BUSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.SubLineOfBusniess ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_LOC_LEVEL, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.LocLevel ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_PRD_CLO_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.PrdColumnID ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_PRD_CAT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ProductCategoryID ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_CAT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.CategoryID ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ProductID ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ProductDetailID ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_COL_ORDER, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.Order ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ColumnID ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_DIC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.DictionaryID ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_DIC_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.DictionaryColumnID ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_REF_TABLE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.RefTable ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_WHERE_COND, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.WhereCondition ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)productColumns.CreateBy ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_CREATATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)productColumns.CreationDate ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)productColumns.ModifiedBy ?? DBNull.Value);
            oracleParams.Add(ProductColumnSpParam.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)productColumns.ModificationDate ?? DBNull.Value);



            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = message;
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
        public async static Task <IDTO> AddUpdate(Installment installment)
        {
            string SPName  = "";
            string message = "";
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();

            if (installment.ID.HasValue)
            {
                oracleParams.Add(InstallmetSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)installment.ID ?? DBNull.Value);

                SPName  = InstallmentSpName.SP_UPADTE_INSTALLMENT;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(InstallmetSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = InstallmentSpName.SP_INSERT_INSTALLMENT;
                message = "Inserted Successfully";
            }


            oracleParams.Add(InstallmetSpParams.PARAMETER_DUE_DATE, OracleDbType.Date, ParameterDirection.Input, (object)installment.DueDate ?? DBNull.Value);
            oracleParams.Add(InstallmetSpParams.PARAMETER_GROSS_AMOUNT, OracleDbType.Double, ParameterDirection.Input, (object)installment.GrossAmount ?? DBNull.Value);
            oracleParams.Add(InstallmetSpParams.PARAMETER_GROSS_AMOUNT_LC, OracleDbType.Double, ParameterDirection.Input, (object)installment.GrossAmountLc ?? DBNull.Value);

            oracleParams.Add(InstallmetSpParams.PARAMETER_NET_AMOUNT, OracleDbType.Double, ParameterDirection.Input, (object)installment.NetAmount ?? DBNull.Value);
            oracleParams.Add(InstallmetSpParams.PARAMETER_NET_AMOUNT_LC, OracleDbType.Double, ParameterDirection.Input, (object)installment.NetAmountLc ?? DBNull.Value);
            oracleParams.Add(InstallmetSpParams.PARAMETER_INST_FEES, OracleDbType.Double, ParameterDirection.Input, (object)installment.FeesAmount ?? DBNull.Value);
            oracleParams.Add(InstallmetSpParams.PARAMETER_INST_FEES_LC, OracleDbType.Double, ParameterDirection.Input, (object)installment.FeesAmountLC ?? DBNull.Value);
            oracleParams.Add(InstallmetSpParams.PARAMETER_EXRATE, OracleDbType.Double, ParameterDirection.Input, (object)installment.Exrate ?? DBNull.Value);

            oracleParams.Add(InstallmetSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)installment.CreatedBy ?? DBNull.Value, 1000);
            oracleParams.Add(InstallmetSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)installment.CreationDate ?? DBNull.Value);
            oracleParams.Add(InstallmetSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)installment.ModifiedBy ?? DBNull.Value, 1000);
            oracleParams.Add(InstallmetSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)installment.ModificationDate ?? DBNull.Value);

            oracleParams.Add(InstallmetSpParams.PARAMETER_UW_DOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)installment.DocumentID ?? DBNull.Value);

            oracleParams.Add(InstallmetSpParams.PARAMETER_INST_COMM, OracleDbType.Decimal, ParameterDirection.Input, (object)installment.CommissionAmount ?? DBNull.Value);
            oracleParams.Add(InstallmetSpParams.PARAMETER_INST_COMM_LC, OracleDbType.Decimal, ParameterDirection.Input, (object)installment.CommissionAmountLc ?? DBNull.Value);
            oracleParams.Add(InstallmetSpParams.PARAMETER_INS_PERCENT, OracleDbType.Decimal, ParameterDirection.Input, (object)installment.Percent ?? DBNull.Value);



            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = "Operation Success";
            }

            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
Beispiel #7
0
        public async static Task <IDTO> AddUpdateMode(Company company)
        {
            string SPName  = "";
            string message = "";
            OracleDynamicParameters dyParam  = new OracleDynamicParameters();
            ComplateOperation <int> complate = new ComplateOperation <int>();

            if (company.ID.HasValue)
            {
                dyParam.Add(CompanySpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)company.ID ?? DBNull.Value);
                SPName  = CompanySPName.SP_UPADTE_COMPANY;
                message = "Updated Successfully";
            }
            else
            {
                dyParam.Add(CompanySpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = CompanySPName.SP_INSERT_COMPANY;
                message = "Inserted Successfully";
            }

            dyParam.Add(CompanySpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Name ?? DBNull.Value, 500);
            dyParam.Add(CompanySpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Name ?? DBNull.Value, 500);
            dyParam.Add(CompanySpParams.PARAMETER_PHONE, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Phone ?? DBNull.Value, 30);
            dyParam.Add(CompanySpParams.PARAMETER_COUNTRY_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.CountryCode ?? DBNull.Value, 30);
            dyParam.Add(CompanySpParams.PARAMETER_MOBILE, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Mobile ?? DBNull.Value, 30);
            dyParam.Add(CompanySpParams.PARAMETER_FAX, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Fax ?? DBNull.Value, 30);
            dyParam.Add(CompanySpParams.PARAMETER_EMAIL, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Email ?? DBNull.Value, 30);
            dyParam.Add(CompanySpParams.PARAMETER_WEBSITE, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Website ?? DBNull.Value, 30);
            dyParam.Add(CompanySpParams.PARAMETER_ADDRESS, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Address ?? DBNull.Value, 30);
            dyParam.Add(CompanySpParams.PARAMETER_ADDRESS2, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Address2 ?? DBNull.Value, 30);
            dyParam.Add(CompanySpParams.PARAMETER_CONTACT_PERSON, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.ContactPerson ?? DBNull.Value, 30);
            dyParam.Add(CompanySpParams.PARAMETER_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Code ?? DBNull.Value, 30);
            dyParam.Add(CompanySpParams.PARAMETER_COUNTRY_CURRENCY_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.CurrencyCode ?? DBNull.Value, 30);
            dyParam.Add(CompanySpParams.PARAMETER_COUNTRY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)company.CountryID ?? DBNull.Value);
            dyParam.Add(CompanySpParams.PARAMETER_LOGO, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Logo ?? DBNull.Value, 30);
            dyParam.Add(CompanySpParams.PARAMETER_PASS_MLENGHT, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordMinLength ?? DBNull.Value);
            dyParam.Add(CompanySpParams.PARAMETER_PASS_MUPPER, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordMinUpperCase ?? DBNull.Value);
            dyParam.Add(CompanySpParams.PARAMETER_PASS_MLOWER, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordMinLowerCase ?? DBNull.Value);
            dyParam.Add(CompanySpParams.PARAMETER_PASS_MDIGITS, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordMinNumbers ?? DBNull.Value);
            dyParam.Add(CompanySpParams.PARAMETER_PASS_MSPECIAL, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordMinSpecialCharacters ?? DBNull.Value);
            dyParam.Add(CompanySpParams.PARAMETER_PASS_EXPIRY_PERIOD, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordExpiryDays ?? DBNull.Value);
            dyParam.Add(CompanySpParams.PARAMETER_PASS_LOGATTEMPTS, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordFailedLoginAttempts ?? DBNull.Value);
            dyParam.Add(CompanySpParams.PARAMETER_PASS_REPEAT, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordRepeats ?? DBNull.Value);


            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, dyParam) == -1)
            {
                complate.message = message;
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
Beispiel #8
0
        public async static Task <IDTO> AddUpdate(Entities.Financial.CustomerCommission customerCommission)
        {
            string SPName  = "";
            string message = "";
            ComplateOperation <int> complate = new ComplateOperation <int>();


            OracleDynamicParameters oracleParams = new OracleDynamicParameters();

            if (customerCommission.ID.HasValue)
            {
                oracleParams.Add(CustomerCommissionSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.ID ?? DBNull.Value);

                SPName  = CustomerCommissionSpName.SP_UPADTE_CUSTOMER_COMM;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(CustomerCommissionSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = CustomerCommissionSpName.SP_INSERT_CUSTOMER_COMM;
                message = "Inserted Successfully";
            }
            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.CustomerID ?? DBNull.Value);
            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_LOC_CUST_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.LocCustomerType ?? DBNull.Value);
            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerCommission.CreatedBy ?? DBNull.Value);
            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerCommission.CreationDate ?? DBNull.Value);
            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerCommission.ModifiedBy ?? DBNull.Value);
            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerCommission.ModificationDate ?? DBNull.Value);
            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_COMM_PERC, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.ComissionPercentage ?? DBNull.Value);
            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_COMM_AMOUNT, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.CommissionAmount ?? DBNull.Value);
            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_COMM_AMOUNT_LC, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.CommissionAmount ?? DBNull.Value);
            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.ProductId ?? DBNull.Value);

            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.ProductDetailId ?? DBNull.Value);



            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_ST_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.LineOfBusiness ?? DBNull.Value);
            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_ST_SUB_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.SubLineOfBusiness ?? DBNull.Value);
            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_DRT_CR, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.DrtCr ?? DBNull.Value);
            oracleParams.Add(CustomerCommissionSpParams.PARAMETER_LOC_COMM_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.LocCommissionType ?? DBNull.Value);



            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = message;
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
Beispiel #9
0
        public async static Task <IDTO> AddUpdate(Pricing pricing)
        {
            string SPName  = "";
            string message = "";
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();

            if (pricing.ID.HasValue)
            {
                oracleParams.Add(PricingSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.ID ?? DBNull.Value);

                SPName  = PricingSpName.SP_UPADTE_PRICING;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(PricingSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = PricingSpName.SP_INSERT_PRICING;
                message = "Inserted Successfully";
            }


            oracleParams.Add(PricingSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricing.Name ?? DBNull.Value);
            oracleParams.Add(PricingSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricing.Name2 ?? DBNull.Value);
            oracleParams.Add(PricingSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricing.CreatedBy ?? DBNull.Value);
            oracleParams.Add(PricingSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.CreationDate ?? DBNull.Value);
            oracleParams.Add(PricingSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricing.ModifiedBy ?? DBNull.Value);
            oracleParams.Add(PricingSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.ModificationDate ?? DBNull.Value);
            oracleParams.Add(PricingSpParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.Status ?? DBNull.Value);

            oracleParams.Add(PricingSpParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.StatusDate ?? DBNull.Value, 1000);
            oracleParams.Add(PricingSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.ProductID ?? DBNull.Value);
            oracleParams.Add(PricingSpParams.PARAMETER_EFFECTIVE_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.EffectiveDate ?? DBNull.Value, 1000);
            oracleParams.Add(PricingSpParams.PARAMETER_EXPIRY_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.ExpiryDate ?? DBNull.Value);

            oracleParams.Add(PricingSpParams.PARAMETER_LOC_PRICE_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.PricingType ?? DBNull.Value);

            oracleParams.Add(PricingSpParams.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.CustomerID ?? DBNull.Value);



            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.ID      = oracleParams.Get(0);
                complate.message = message;
            }

            else
            {
                complate.message = message;
            }

            return(complate);
        }
        public async static Task<IDTO> DeleteCompaniesAsync(long[] IDs)
        {

            ComplateOperation<int> complate = new ComplateOperation<int>();

            if (await NonQueryExecuter.ExecuteNonQueryAsync(MultiDeleteFormater.Format(typeof(Company), IDs)) == -1)
                complate.message = "Operation Successed";
            else
                complate.message = "Operation Failed";

            return complate;
        }
        public async static Task <IDTO> AddUpdate(FactorDetail factor)
        {
            string SPName  = "";
            string message = "";
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();

            if (factor.ID.HasValue)
            {
                oracleParams.Add(FactorDetailSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ID ?? DBNull.Value);

                SPName  = FactorDetailSpName.SP_UPADTE_FACTOR_DETAIL;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(FactorDetailSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = FactorDetailSpName.SP_INSERT_FACTOR_DETAIL;
                message = "Inserted Successfully";
            }


            oracleParams.Add(FactorDetailSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)factor.Name ?? DBNull.Value);
            oracleParams.Add(FactorDetailSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)factor.Name2 ?? DBNull.Value);
            oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_DIC_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.DictionaryID ?? DBNull.Value);
            oracleParams.Add(FactorDetailSpParams.PARAMETER_ENTRY_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)factor.EntryType ?? DBNull.Value);
            oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_PRD_FACT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.FactorID ?? DBNull.Value);
            oracleParams.Add(FactorDetailSpParams.PARAMETER_FROM_VALUE, OracleDbType.Int64, ParameterDirection.Input, (object)factor.FromValue ?? DBNull.Value);
            oracleParams.Add(FactorDetailSpParams.PARAMETER_TO_VALUE, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ToValue ?? DBNull.Value);
            oracleParams.Add(FactorDetailSpParams.PARAMETER_F_FROM_DATE, OracleDbType.Date, ParameterDirection.Input, (object)factor.FromDate ?? DBNull.Value);
            oracleParams.Add(FactorDetailSpParams.PARAMETER_F_TO_DATE, OracleDbType.Date, ParameterDirection.Input, (object)factor.ToDate ?? DBNull.Value);
            oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_CHG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ChargeID ?? DBNull.Value);
            oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ProductID ?? DBNull.Value);
            oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ProductDetailID ?? DBNull.Value);
            oracleParams.Add(FactorDetailSpParams.PARAMETER_FRRMULA_EDOTORS, OracleDbType.Varchar2, ParameterDirection.Input, (object)factor.FrrmulaEdotors ?? DBNull.Value);
            oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_PRD_FACD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ProductFacdID ?? DBNull.Value);



            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = "Operation Success";
            }

            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
Beispiel #12
0
        public async static Task <IDTO> DeleteAttributesAsync(long[] IDs)
        {
            ComplateOperation <int> operation = new ComplateOperation <int>();

            if (await NonQueryExecuter.ExecuteNonQueryAsync(MultiDeleteFormater.Format(typeof(Acttribute), IDs)) == -1)
            {
                operation.message = "Operation Successed";
            }
            else
            {
                operation.message = "Operation Failed";
            }
            return(operation);
        }
        public async static Task <IDTO> AddUpdateMode(Share share)
        {
            string SPName  = "";
            string message = "";
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();

            if (share.ID.HasValue)
            {
                oracleParams.Add(SharesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)share.ID ?? DBNull.Value);

                SPName  = SharesSpName.SP_UPADTE_SHARE;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(SharesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = SharesSpName.SP_INSERT_SHARE;
                message = "Inserted Successfully";
            }

            oracleParams.Add(SharesSpParams.PARAMETER_LOC_SHARE_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)share.LocShareType ?? DBNull.Value);
            oracleParams.Add(SharesSpParams.PARAMETER_PRCNT, OracleDbType.Decimal, ParameterDirection.Input, (object)share.Percent ?? DBNull.Value);
            oracleParams.Add(SharesSpParams.PARAMETER_SHARE_PER, OracleDbType.Decimal, ParameterDirection.Input, (object)share.SharePercent ?? DBNull.Value);
            oracleParams.Add(SharesSpParams.PARAMETER_AMOUNT, OracleDbType.Decimal, ParameterDirection.Input, (object)share.Amount ?? DBNull.Value);
            oracleParams.Add(SharesSpParams.PARAMETER_AMOUNT_LC, OracleDbType.Decimal, ParameterDirection.Input, (object)share.AmountLC ?? DBNull.Value);
            oracleParams.Add(SharesSpParams.PARAMETER_NOTES, OracleDbType.Varchar2, ParameterDirection.Input, (object)share.Notes ?? DBNull.Value);
            oracleParams.Add(SharesSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)share.CreatedBy ?? DBNull.Value);
            oracleParams.Add(SharesSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)share.CreationDate ?? DBNull.Value);
            oracleParams.Add(SharesSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)share.ModifiedBy ?? DBNull.Value);
            oracleParams.Add(SharesSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)share.ModificationDate ?? DBNull.Value);
            oracleParams.Add(SharesSpParams.PARAMETER_UW_DOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)share.DocumentID ?? DBNull.Value);
            oracleParams.Add(SharesSpParams.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)share.CustomerId ?? DBNull.Value);
            oracleParams.Add(SharesSpParams.PARAMETER_ST_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)share.StLOB ?? DBNull.Value);
            oracleParams.Add(SharesSpParams.PARAMETER_ST_SUB_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)share.StSubLOB ?? DBNull.Value);
            oracleParams.Add(SharesSpParams.PARAMETER_DR_CR, OracleDbType.Int64, ParameterDirection.Input, (object)share.DrCr ?? DBNull.Value);


            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = message;
                complate.ID      = oracleParams.Get(0);
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
Beispiel #14
0
        public async static Task <IDTO> AddUpdate(Column column)
        {
            var SPName  = default(string);
            var message = default(string);
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();

            if (column.ID.HasValue)
            {
                oracleParams.Add(ColumnSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.ID ?? DBNull.Value);

                SPName  = ColumnSpName.SP_UPADTE_COLUMN;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(ColumnSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = ColumnSpName.SP_INSERT_COLUMN;
                message = "Inserted Successfully";
            }
            oracleParams.Add(ColumnSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.Name ?? DBNull.Value, 1000);
            oracleParams.Add(ColumnSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.Name2 ?? DBNull.Value, 1000);
            oracleParams.Add(ColumnSpParams.PARAMETER_LABLE, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.Lable ?? DBNull.Value, 1000);
            oracleParams.Add(ColumnSpParams.PARAMETER_LABLE2, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.Lable2 ?? DBNull.Value, 1000);
            oracleParams.Add(ColumnSpParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)column.Status ?? DBNull.Value);
            oracleParams.Add(ColumnSpParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)column.StatusDate ?? DBNull.Value);
            oracleParams.Add(ColumnSpParams.PARAMETER_COLUMN_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)column.ColumnType ?? DBNull.Value);
            oracleParams.Add(ColumnSpParams.PARAMETER_LINE_OF_BUSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)column.LineOfBusniess ?? DBNull.Value);
            oracleParams.Add(ColumnSpParams.PARAMETER_SUB_LINE_OF_BUSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)column.SubLineOfBusniess ?? DBNull.Value);
            oracleParams.Add(ColumnSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.CreateBy ?? DBNull.Value, 20);
            oracleParams.Add(ColumnSpParams.PARAMETER_CREATATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)column.CreationDate ?? DBNull.Value);
            oracleParams.Add(ColumnSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.ModifiedBy ?? DBNull.Value, 20);
            oracleParams.Add(ColumnSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)column.ModificationDate ?? DBNull.Value);
            oracleParams.Add(ColumnSpParams.PARAMETER_CATEGORY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.CategoryID ?? DBNull.Value);
            oracleParams.Add(ColumnSpParams.PARAMETER_REF_TABLE_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.RefTableName ?? DBNull.Value, 1000);
            oracleParams.Add(ColumnSpParams.PARAMETER_REF_MAJOR_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.RefMajorCode ?? DBNull.Value, 1000);
            oracleParams.Add(ColumnSpParams.PARAMETER_REF_COL_DETAILS, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.RefColDetailsID ?? DBNull.Value, 1000);

            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = message;
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
        public async static Task <IDTO> AddUpdate(PricingDetail pricingDetail)
        {
            string SPName  = "";
            string message = "";
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();

            if (pricingDetail.ID.HasValue)
            {
                oracleParams.Add(PricingDetailsSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.ID ?? DBNull.Value);

                SPName  = PricingDetailsSpName.SP_UPADTE_PRICING_DETAIL;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(PricingDetailsSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = PricingDetailsSpName.SP_INSERT_PRICING_DETAIL;
                message = "Inserted Successfully";
            }


            oracleParams.Add(PricingDetailsSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricingDetail.CreatedBy ?? DBNull.Value);
            oracleParams.Add(PricingDetailsSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.CreationDate ?? DBNull.Value);
            oracleParams.Add(PricingDetailsSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricingDetail.ModifiedBy ?? DBNull.Value);
            oracleParams.Add(PricingDetailsSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.ModificationDate ?? DBNull.Value);
            oracleParams.Add(PricingDetailsSpParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.Status ?? DBNull.Value);
            oracleParams.Add(PricingDetailsSpParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.StatusDate ?? DBNull.Value);
            oracleParams.Add(PricingDetailsSpParams.PARAMETER_EFFECTIVE_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.EffectiveDate ?? DBNull.Value);
            oracleParams.Add(PricingDetailsSpParams.PARAMETER_EXPIRY_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.ExpiryDate ?? DBNull.Value);
            oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.ProductID ?? DBNull.Value);
            oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.ProductDetailID ?? DBNull.Value);
            oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.LineOfBusiness ?? DBNull.Value);
            oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_SUB_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.SubLineOfBusiness ?? DBNull.Value);
            oracleParams.Add(PricingDetailsSpParams.PARAMETER_IS_FACTOR, OracleDbType.Int16, ParameterDirection.Input, (object)pricingDetail.IsFactor ?? DBNull.Value);
            oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_PRD_PRIC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.PricingID ?? DBNull.Value);

            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = "Operation Success";
            }

            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
Beispiel #16
0
        public async static Task <IDTO> AddUpdateMode(Domain.Entities.ProductSetup.ProductWordingDetails wording)
        {
            string SPName  = "";
            string message = "";
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();

            if (wording.ID.HasValue)
            {
                oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)wording.ID ?? DBNull.Value);
                SPName  = ProductWordDetailSpName.SP_UPADTE_PRODUCT_WORDING_DETAIL;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = ProductWordDetailSpName.SP_INSERT_PRODUCT_WORDING_DETAIL;
                message = "Inserted Successfully";
            }

            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_SERIAL, OracleDbType.Int64, ParameterDirection.Input, (object)wording.Serial ?? DBNull.Value, 500);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_DESCRIPTION, OracleDbType.Varchar2, ParameterDirection.Input, (object)wording.Description ?? DBNull.Value, 4000);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_DESCRIPTION2, OracleDbType.Varchar2, ParameterDirection.Input, (object)wording.Description2 ?? DBNull.Value, 4000);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_WORD_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)wording.WordType ?? DBNull.Value);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)wording.Status ?? DBNull.Value);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)wording.StatusDate ?? DBNull.Value);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ST_WORD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)wording.WordId ?? DBNull.Value);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_IS_AUTO_ADD, OracleDbType.Int64, ParameterDirection.Input, (object)wording.IsAutoAdd ?? DBNull.Value);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)wording.ProductId ?? DBNull.Value);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)wording.ProductDetailId ?? DBNull.Value);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ST_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)wording.LineOfBusiness ?? DBNull.Value);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ST_SUB_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)wording.SubLineOfBusiness ?? DBNull.Value);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ST_SRVCS_ID, OracleDbType.Int64, ParameterDirection.Input, (object)wording.ServiceID ?? DBNull.Value);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)wording.CreateBy ?? DBNull.Value, 50);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)wording.CreationDate ?? DBNull.Value);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)wording.ModifiedBy ?? DBNull.Value, 50);
            oracleParams.Add(ProductWordDetailSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)wording.ModificationDate ?? DBNull.Value);

            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = message;
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
        public async static Task <IDTO> AddUpdate(Entities.Financial.CustomerLicense customerLicense)
        {
            string SPName  = "";
            string message = "";
            ComplateOperation <int> complate = new ComplateOperation <int>();


            OracleDynamicParameters oracleParams = new OracleDynamicParameters();

            if (customerLicense.ID.HasValue)
            {
                oracleParams.Add(CustomerLicenseSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerLicense.ID ?? DBNull.Value);

                SPName  = CustomerLicenseSpName.SP_UPADTE_CUSTOMER_LICENSE;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(CustomerLicenseSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = CustomerLicenseSpName.SP_INSERT_CUSTOMER_LICENSE;
                message = "Inserted Successfully";
            }
            oracleParams.Add(CustomerLicenseSpParams.PARAMETER_LICNESNO, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerLicense.LicenseNo ?? DBNull.Value);
            oracleParams.Add(CustomerLicenseSpParams.PARAMETER_EFF_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerLicense.EffectiveDate ?? DBNull.Value);
            oracleParams.Add(CustomerLicenseSpParams.PARAMETER_EXP_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerLicense.ExpireDate ?? DBNull.Value);
            oracleParams.Add(CustomerLicenseSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerLicense.CreatedBy ?? DBNull.Value);
            oracleParams.Add(CustomerLicenseSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerLicense.CreationDate ?? DBNull.Value);
            oracleParams.Add(CustomerLicenseSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerLicense.ModifiedBy ?? DBNull.Value);
            oracleParams.Add(CustomerLicenseSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerLicense.ModificationDate ?? DBNull.Value);
            oracleParams.Add(CustomerLicenseSpParams.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerLicense.CustomerID ?? DBNull.Value);
            oracleParams.Add(CustomerLicenseSpParams.PARAMETER_LOC_SPT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerLicense.LocSptID ?? DBNull.Value);
            oracleParams.Add(CustomerLicenseSpParams.PARAMETER_LOC_COD, OracleDbType.Int64, ParameterDirection.Input, (object)customerLicense.LocCode ?? DBNull.Value);
            oracleParams.Add(CustomerLicenseSpParams.PARAMETER_LOC_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)customerLicense.Status ?? DBNull.Value);
            oracleParams.Add(CustomerLicenseSpParams.PARAMETER_STATUS_DATE, OracleDbType.Int64, ParameterDirection.Input, (object)customerLicense.StatuseDate ?? DBNull.Value);
            oracleParams.Add(CustomerLicenseSpParams.PARAMETER_LOC_PROVIDER_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)customerLicense.LocProviderTyoe ?? DBNull.Value);



            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = message;
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
        public async static Task <IDTO> DeleteProductReportsAsync(long[] IDs)
        {
            ComplateOperation <int> complate = new ComplateOperation <int>();

            if (await NonQueryExecuter.ExecuteNonQueryAsync(MultiDeleteFormater.Format(typeof(Domain.Entities.ProductSetup.ProductReport), IDs)) == -1)
            {
                complate.message = "Operation Successed";
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
Beispiel #19
0
        public async static Task <IDTO> DeleteQuestionsAsync(long[] IDs)
        {
            ComplateOperation <int> complate = new ComplateOperation <int>();

            if (await NonQueryExecuter.ExecuteNonQueryAsync(MultiDeleteFormater.Format(typeof(Question), IDs)) == -1)
            {
                complate.message = "Operation Successed";
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
        public async static Task<IDTO> DeleteCompanyAsync(Company company)
        {
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation<int> complate = new ComplateOperation<int>();
            var dyParam = new OracleDynamicParameters();
            dyParam.Add(CompanySpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)company.ID ?? DBNull.Value);

            if (await NonQueryExecuter.ExecuteNonQueryAsync(CompanySPName.SP_DELETE_COMPANY, dyParam) == -1)
                complate.message = "Operation Successed";
            else
                complate.message = "Operation Failed";

            return complate;

        }
Beispiel #21
0
        public async static Task <IDTO> DeleteCurrenciesAsync(string[] Codes)
        {
            ComplateOperation <int> complate = new ComplateOperation <int>();

            if (await NonQueryExecuter.ExecuteNonQueryAsync(MultiDeleteFormater.Format(typeof(Currency), Codes)) == -1)
            {
                complate.message = "Operation Successed";
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
Beispiel #22
0
        public async static Task <IDTO> DeleteCommissions(long[] IDs)
        {
            ComplateOperation <int> complate = new ComplateOperation <int>();

            if (await NonQueryExecuter.ExecuteNonQueryAsync(MultiDeleteFormater.Format(typeof(Entities.Financial.CustomerCommission), IDs)) == -1)
            {
                complate.message = "Operation Successed";
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
Beispiel #23
0
        public async static Task <IDTO> AddUpdate(Entities.Financial.CustomerGroupRelation customerGroupRelation)
        {
            string SPName  = "";
            string message = "";
            ComplateOperation <int> complate = new ComplateOperation <int>();


            OracleDynamicParameters oracleParams = new OracleDynamicParameters();

            if (customerGroupRelation.ID.HasValue)
            {
                oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerGroupRelation.ID ?? DBNull.Value);

                SPName  = CustomerGrRelationSpName.SP_UPADTE_CUSTOMER_GROUP_RELATIONS;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = CustomerGrRelationSpName.SP_INSERT_CUSTOMER_GROUP_RELATIONS;
                message = "Inserted Successfully";
            }
            oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerGroupRelation.Name ?? DBNull.Value);
            oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerGroupRelation.Name2 ?? DBNull.Value);
            oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerGroupRelation.CreatedBy ?? DBNull.Value);
            oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerGroupRelation.CreationDate ?? DBNull.Value);
            oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerGroupRelation.ModifiedBy ?? DBNull.Value);
            oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerGroupRelation.ModificationDate ?? DBNull.Value);
            oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_ST_PARTD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerGroupRelation.ProductDetailId ?? DBNull.Value);

            oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_LOC_UNITT, OracleDbType.Int64, ParameterDirection.Input, (object)customerGroupRelation.LocUnit ?? DBNull.Value);
            oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_PRICE_AMOUNT, OracleDbType.Int64, ParameterDirection.Input, (object)customerGroupRelation.PriceAmount ?? DBNull.Value);
            oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_FREQ, OracleDbType.Int64, ParameterDirection.Input, (object)customerGroupRelation.Freq ?? DBNull.Value);
            oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_REF_NO, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerGroupRelation.ReferenceNo ?? DBNull.Value);
            oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerGroupRelation.CustomerID ?? DBNull.Value);


            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = message;
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
Beispiel #24
0
        public async static Task <IDTO> AddUpdateMode(CustomerContact customerContact)
        {
            string SPName  = "";
            string message = "";
            ComplateOperation <int> complate = new ComplateOperation <int>();


            OracleDynamicParameters oracleParams = new OracleDynamicParameters();

            if (customerContact.ID.HasValue)
            {
                oracleParams.Add(CustomerContactsSpParam.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerContact.ID ?? DBNull.Value);

                SPName  = CustomerContactsSpName.CUSTOMER_CONTACT_UPDATE;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(CustomerContactsSpParam.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = CustomerContactsSpName.CUSTOMER_CONTACT_INSERT;
                message = "Inserted Successfully";
            }
            oracleParams.Add(CustomerContactsSpParam.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerContact.CustomerID ?? DBNull.Value);

            oracleParams.Add(CustomerContactsSpParam.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.Name ?? DBNull.Value);
            oracleParams.Add(CustomerContactsSpParam.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.Name2 ?? DBNull.Value);
            oracleParams.Add(CustomerContactsSpParam.PARAMETER_POHNE_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.PhoneCode ?? DBNull.Value);
            oracleParams.Add(CustomerContactsSpParam.PARAMETER_PHONE, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.Phone ?? DBNull.Value);
            oracleParams.Add(CustomerContactsSpParam.PARAMETER_MOBILE, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.Mobile ?? DBNull.Value);
            oracleParams.Add(CustomerContactsSpParam.PARAMETER_EMAIL, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.Email ?? DBNull.Value);
            oracleParams.Add(CustomerContactsSpParam.PARAMETER_ST_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)customerContact.LineOfBusiness ?? DBNull.Value);
            oracleParams.Add(CustomerContactsSpParam.PARAMETER_LOC_INS_DEPT, OracleDbType.Int64, ParameterDirection.Input, (object)customerContact.LocCustomerDept ?? DBNull.Value);
            oracleParams.Add(CustomerContactsSpParam.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.CreatedBy ?? DBNull.Value);
            oracleParams.Add(CustomerContactsSpParam.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerContact.CreationDate ?? DBNull.Value);
            oracleParams.Add(CustomerContactsSpParam.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.ModifiedBy ?? DBNull.Value);
            oracleParams.Add(CustomerContactsSpParam.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerContact.ModificationDate ?? DBNull.Value);

            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = message;
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
Beispiel #25
0
        public async static Task <IDTO> AddUpdateMode(ProductDynamicColumn column)
        {
            string SPName  = "";
            string message = "";
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();

            if (column.UwColID.HasValue)
            {
                oracleParams.Add(ColumnsSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.UwColID ?? DBNull.Value);
                SPName  = ColumsSpName.SP_UPADTE_COLUMNS;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(ColumnsSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = ColumsSpName.SP_INSERT_COLUMNS;
                message = "Inserted Successfully";
            }


            oracleParams.Add(ColumnsSpParams.PARAMETER_LABLE, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.Lable ?? DBNull.Value, 100);
            oracleParams.Add(ColumnsSpParams.PARAMETER_LABLE2, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.Lable2 ?? DBNull.Value, 100);
            oracleParams.Add(ColumnsSpParams.PARAMETER_UW_COL_CAT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.UnderWritingColCatID ?? DBNull.Value);
            oracleParams.Add(ColumnsSpParams.PARAMETER_ST_PRD_CAT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.ProductCategoryID ?? DBNull.Value);
            oracleParams.Add(ColumnsSpParams.PARAMETER_ST_PRD_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.ProductColumnID ?? DBNull.Value, 50);
            oracleParams.Add(ColumnsSpParams.PARAMETER_VALUE_DATE, OracleDbType.Date, ParameterDirection.Input, (object)column.ValueDate ?? DBNull.Value);
            oracleParams.Add(ColumnsSpParams.PARAMETER_VALUE_AMOUNT, OracleDbType.Int64, ParameterDirection.Input, (object)column.ValueAmount ?? DBNull.Value);
            oracleParams.Add(ColumnsSpParams.PARAMETER_VALUE_DESC, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.ValueDesc ?? DBNull.Value);
            oracleParams.Add(ColumnsSpParams.PARAMETER_VAL_LOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.ValueLockUpID ?? DBNull.Value);
            oracleParams.Add(ColumnsSpParams.PARAMETER_UW_RISK_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.UnderWritingRiskID ?? DBNull.Value);
            oracleParams.Add(ColumnsSpParams.PARAMETER_UW_DOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.UnderWritingDocID ?? DBNull.Value);
            oracleParams.Add(ColumnsSpParams.PARAMETER_COL_ORDER, OracleDbType.Int64, ParameterDirection.Input, (object)column.ColumnOrder ?? DBNull.Value);
            oracleParams.Add(ColumnsSpParams.PARAMETER_ST_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.ColumnID ?? DBNull.Value);
            oracleParams.Add(ColumnsSpParams.PARAMETER_ST_DIC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.Dictionary ?? DBNull.Value);
            oracleParams.Add(ColumnsSpParams.PARAMETER_ST_DIC_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.DictionaryColumnID ?? DBNull.Value);

            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = message;
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
        public async static Task <IDTO> AddUpdate(Domain.Entities.ProductSetup.ProductColumnValidation productColumns)
        {
            string SPName  = "";
            string message = "";
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();

            if (productColumns.ID.HasValue)
            {
                oracleParams.Add(ProductValidationSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ID ?? DBNull.Value);
                SPName  = ProductValidationSpName.SP_UPADTE_VALIDATION;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(ProductValidationSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = ProductValidationSpName.SP_INSERT_VALIDATION;
                message = "Inserted Successfully";
            }


            oracleParams.Add(ProductValidationSpParams.PARAMETER_LABLE, OracleDbType.Varchar2, ParameterDirection.Input, (object)productColumns.Lable ?? DBNull.Value);
            oracleParams.Add(ProductValidationSpParams.PARAMETER_LABLE2, OracleDbType.Varchar2, ParameterDirection.Input, (object)productColumns.Lable2 ?? DBNull.Value);
            oracleParams.Add(ProductValidationSpParams.PARAMETER_DATA_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.DataType ?? DBNull.Value);
            oracleParams.Add(ProductValidationSpParams.PARAMETER_LOC_VALD_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.LocValidType ?? DBNull.Value);
            oracleParams.Add(ProductValidationSpParams.PARAMETER_IS_MANDETORY, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.IsMandetory ?? DBNull.Value);
            oracleParams.Add(ProductValidationSpParams.PARAMETER_MAX_VALUE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.MaxValue ?? DBNull.Value);
            oracleParams.Add(ProductValidationSpParams.PARAMETER_MIN_VALUE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.MinValue ?? DBNull.Value);
            oracleParams.Add(ProductValidationSpParams.PARAMETER_CHECK_DUPLICATION, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.CheckDuplication ?? DBNull.Value);
            oracleParams.Add(ProductValidationSpParams.PARAMETER_ST_CAT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.CategoryID ?? DBNull.Value);
            oracleParams.Add(ProductValidationSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ProductID ?? DBNull.Value);
            oracleParams.Add(ProductValidationSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ProductDetailID ?? DBNull.Value);
            oracleParams.Add(ProductValidationSpParams.PARAMETER_ST_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ColumnID ?? DBNull.Value);



            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.ID      = oracleParams.Get(0);
                complate.message = message;
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
Beispiel #27
0
        public async static Task <IDTO> AddUpdate(Product Product)
        {
            var SPName  = default(string);
            var message = default(string);
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();

            if (Product.ID.HasValue)
            {
                oracleParams.Add(ProductSPParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.ID ?? DBNull.Value);
                SPName  = ProductSPName.SP_UPADTE_PRODUCT;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(ProductSPParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = ProductSPName.SP_INSERT_PRODUCT;
                message = "Inserted Successfully";
            }
            oracleParams.Add(ProductSPParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.Name ?? DBNull.Value, 1000);
            oracleParams.Add(ProductSPParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.Name2 ?? DBNull.Value, 1000);
            oracleParams.Add(ProductSPParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)Product.Status ?? DBNull.Value);
            oracleParams.Add(ProductSPParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.StatusDate ?? DBNull.Value);
            oracleParams.Add(ProductSPParams.PARAMETER_LOGO, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.Logo ?? DBNull.Value, 1000);
            oracleParams.Add(ProductSPParams.PARAMETER_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.Code ?? DBNull.Value, 30);
            oracleParams.Add(ProductSPParams.PARAMETER_EFFECTIVE_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.EffectiveDate ?? DBNull.Value);
            oracleParams.Add(ProductSPParams.PARAMETER_EXPIRY_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.ExpiryDate ?? DBNull.Value);
            oracleParams.Add(ProductSPParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.CreateBy ?? DBNull.Value, 50);
            oracleParams.Add(ProductSPParams.PARAMETER_CREATATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.CreationDate ?? DBNull.Value);
            oracleParams.Add(ProductSPParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.ModifiedBy ?? DBNull.Value, 50);
            oracleParams.Add(ProductSPParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.ModificationDate ?? DBNull.Value);
            oracleParams.Add(ProductSPParams.PARAMETER_LOCK_INDV_GROUPE, OracleDbType.Int16, ParameterDirection.Input, (object)Product.LockIndvGroup ?? DBNull.Value);
            oracleParams.Add(ProductSPParams.PARAMETER_COMPANY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.CompanyID ?? DBNull.Value);
            oracleParams.Add(ProductSPParams.PARAMETER_FIN_CUSTOMER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.FCustomerID ?? DBNull.Value);


            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.ID      = oracleParams.Get(0);
                complate.message = message;
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }
        public async static Task <IDTO> DeleteProducReportAsync(Domain.Entities.ProductSetup.ProductReport report)
        {
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();
            var dyParam = new OracleDynamicParameters();

            dyParam.Add(ProductReportSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)report.ID ?? DBNull.Value);
            if (await NonQueryExecuter.ExecuteNonQueryAsync(ProductReportSpName.SP_DELETE_PRODUCT_REPORT, dyParam) == -1)
            {
                complate.message = "Operation Successed";
            }
            else
            {
                complate.message = "Operation Failed";
            }
            return(complate);
        }
Beispiel #29
0
        public async static Task <IDTO> DeleteQuestionAsync(Question question)
        {
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();
            var dyParam = new OracleDynamicParameters();

            dyParam.Add(QuestionSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)question.ID ?? DBNull.Value);
            if (await NonQueryExecuter.ExecuteNonQueryAsync(QuestionSpName.SP_DELETE_QUESTION, dyParam) == -1)
            {
                complate.message = "Operation Successed";
            }
            else
            {
                complate.message = "Operation Failed";
            }
            return(complate);
        }
        public async static Task <IDTO> AddUpdate(ProductSubjectType Product)
        {
            var SPName  = default(string);
            var message = default(string);
            OracleDynamicParameters oracleParams = new OracleDynamicParameters();
            ComplateOperation <int> complate     = new ComplateOperation <int>();

            if (Product.ID.HasValue)
            {
                oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.ID ?? DBNull.Value);
                SPName  = ProductSubjectsTypiesSPName.SP_UPADTE_PRODUCT_SUBJECT_TYPE;
                message = "Updated Successfully";
            }
            else
            {
                oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
                SPName  = ProductSubjectsTypiesSPName.SP_INSERT_PRODUCT_SUBJECT_TYPE;
                message = "Inserted Successfully";
            }
            oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_EXCESS_PERC, OracleDbType.Int64, ParameterDirection.Input, (object)Product.ExcessPerc ?? DBNull.Value);
            oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_EXCESS_MIN, OracleDbType.Int64, ParameterDirection.Input, (object)Product.MinExcess ?? DBNull.Value);
            oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_EXCESS_MAX, OracleDbType.Int64, ParameterDirection.Input, (object)Product.MaxExcess ?? DBNull.Value);
            oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_EXCESS_FROM, OracleDbType.Int64, ParameterDirection.Input, (object)Product.ExcessFrom ?? DBNull.Value);
            oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_SUBJECT_TYPE_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.SubjectTypeID ?? DBNull.Value);
            oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_SUBJECT_TYPE_PARENT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.SubjectTypeParentID ?? DBNull.Value);
            oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_LINE_OF_BUSSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)Product.LineOfBusniess ?? DBNull.Value);
            oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_SUB_LINE_OF_BUSSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)Product.SubLineOfBusniess ?? DBNull.Value);
            oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.CreateBy ?? DBNull.Value, 20);
            oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_CREATATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.CreationDate ?? DBNull.Value);
            oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.ModifiedBy ?? DBNull.Value, 20);
            oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.ModificationDate ?? DBNull.Value);
            oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_PRODUCT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.ProductID ?? DBNull.Value);
            oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_PRODUCT_DETAILS_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.ProductDetailsID ?? DBNull.Value);


            if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
            {
                complate.message = message;
            }
            else
            {
                complate.message = "Operation Failed";
            }

            return(complate);
        }