Need someone to go through the method and fix the datatypes. Nvarchar exAMPLE.

IN THE BELOW FUNCTION ===> THIS NEEDS TO BE CHECHED  the datatypes need to be corrected.
I have attached a file of the definitions of the fields. in snippet.  

 public void InsertPriceListHeader (PriceListHeader PLH)
    {
        //All .NET DB connectivity requires a connection, adapter, and dataset.
        System.Data.OracleClient.OracleConnection OracleConnection;
        System.Data.OracleClient.OracleDataAdapter OracleDataAdapter;
        OracleConnection conn = new OracleConnection("Data Source=SCWB2.WPG.CWB.CA;User ID=MXCUPRYK; Password=abcd;Integrated Security=no;");
        conn.Open();
        OracleCommand cmd = new OracleCommand("insert_price_list_hdr", conn);
        cmd.CommandType = CommandType.StoredProcedure;
       
        OracleParameter p_price_list_hdr_id             = new OracleParameter ();//By default parameters are input parameters.
       
        OracleParameter p_tough_disc_amt                = new OracleParameter ();
        OracleParameter p_damp_disc_amt                 = new OracleParameter ();
        OracleParameter p_stone_disc_amt                = new OracleParameter ();
        OracleParameter p_tough_stone_disc_amt          = new OracleParameter ();
        OracleParameter p_damp_stone_disc_amt           = new OracleParameter ();

        OracleParameter p_price_list_status_type_name   = new OracleParameter ();
        OracleParameter p_load_dtm                      = new OracleParameter ();
        OracleParameter p_user_name                     = new OracleParameter ();

        OracleParameter p_wht_indr_flag                 = new OracleParameter ();
        OracleParameter p_durum_indr_flag               = new OracleParameter ();
        OracleParameter p_bly_indr_flag                 = new OracleParameter ();
        OracleParameter p_desigtd_bly_indr_flag         = new OracleParameter ();

        OracleParameter p_load_type_name                = new OracleParameter ();

        OracleParameter p_wht_basis_num                 = new OracleParameter ();
        OracleParameter p_durum_basis_num               = new OracleParameter ();
        OracleParameter p_bly_basis_num                 = new OracleParameter ();
        OracleParameter p_desigtd_bly_basis_num         = new OracleParameter ();

        OracleParameter p_src_file_path_desc            = new OracleParameter ();
        OracleParameter p_pool_part_code                = new OracleParameter ();
        OracleParameter p_sct_price_list_name           = new OracleParameter ();
        OracleParameter p_sct_effctv_dtm                = new OracleParameter ();
       
        OracleParameter p_row_cnt_qty                   = new OracleParameter ();
        OracleParameter p_price_sum_amt                 = new OracleParameter ();



        p_price_list_hdr_id.ParameterName = "price_list_hdr_id "; //1
        p_price_list_hdr_id.OracleType = OracleType.NVarChar; ===> THIS NEEDS TO BE CHECKED
        p_price_list_hdr_id.Value = PLH.pricelistheaderid;

        p_tough_disc_amt.ParameterName = "tough_disc_amt"; //2
        p_tough_disc_amt.OracleType = OracleType.NVarChar; ===> THIS NEEDS TO BE CHECHED
        p_tough_disc_amt.Value= PLH.toughdiscountamount;

        p_damp_disc_amt.ParameterName = "damp_disc_amt"; // 3
        p_damp_disc_amt.OracleType = OracleType.NVarChar; ===> THIS NEEDS TO BE CHECHED
        p_damp_disc_amt.Value=PLH.dampdiscountamount;

        p_stone_disc_amt.ParameterName = "stone_disc_amt"; // 4
        p_stone_disc_amt.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_stone_disc_amt.Value = PLH.stonediscountamount;

        p_tough_stone_disc_amt.ParameterName = "tough_stone_disc_amt"; // 5
        p_tough_stone_disc_amt.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_tough_stone_disc_amt.Value = PLH.toughstonediscountamount;

        p_damp_stone_disc_amt.ParameterName = "damp_stone_disc_amt"; // 6
        p_damp_stone_disc_amt.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_damp_stone_disc_amt.Value = PLH.dampstonediscountamount;

        p_price_list_status_type_name.ParameterName = "price_list_status_type_name"; // 7
        p_price_list_status_type_name.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_price_list_status_type_name.Value = PLH.priceliststatustypename;

        p_load_dtm.ParameterName = "load_dtm"; // 8
        p_load_dtm.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_load_dtm.Value = PLH.loaddatetime;

        p_user_name.ParameterName = "user_name"; // 9
        p_user_name.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_user_name.Value = PLH.username;

        p_wht_indr_flag.ParameterName = "wht_indr_flag"; // 10
        p_wht_indr_flag.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_wht_indr_flag.Value = PLH.wheatindicatorflag;

        p_durum_indr_flag.ParameterName = "durum_indr_flag"; // 11
        p_durum_indr_flag.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_durum_indr_flag.Value = PLH.durumindicatorflag;

        p_bly_indr_flag.ParameterName = "bly_indr_flag"; // 12
        p_bly_indr_flag.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_bly_indr_flag.Value = PLH.barleyindicatorflag;

        p_desigtd_bly_indr_flag.ParameterName = "desigtd_bly_indr_flag"; // 13
        p_desigtd_bly_indr_flag.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_desigtd_bly_indr_flag.Value = PLH.designatedbarleyindicatorflag;

        p_load_type_name.ParameterName = "load_type_name"; // 14
        p_load_type_name.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_load_type_name.Value = PLH.loadtypename;

        p_wht_basis_num.ParameterName = "wht_basis_num"; // 15
        p_wht_basis_num.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_wht_basis_num.Value = PLH.wheatbasisnumber;

        p_durum_basis_num.ParameterName = "durum_basis_num"; // 16
        p_durum_basis_num.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_durum_basis_num.Value = PLH.durumbasisnumber;

        p_bly_basis_num.ParameterName = "bly_basis_num"; // 17
        p_bly_basis_num.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_bly_basis_num.Value = PLH.barleybasisnumber;

        p_desigtd_bly_basis_num.ParameterName = "desigtd_bly_basis_num"; // 18
        p_desigtd_bly_basis_num.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_desigtd_bly_indr_flag.Value = PLH.designatedbarleyindicatorflag;

        p_src_file_path_desc.ParameterName = "src_file_path_desc"; // 19
        p_src_file_path_desc.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_src_file_path_desc.Value = PLH.sourcefilepathdescription;

        p_pool_part_code.ParameterName = "pool_part_code"; // 20
        p_pool_part_code.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_pool_part_code.Value = PLH.poolpartcode;

        p_sct_price_list_name.ParameterName = "sct_price_list_name"; // 21
        p_sct_price_list_name.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_sct_price_list_name.Value = PLH.SCTpricelistname;


        p_sct_effctv_dtm.ParameterName = "sct_effctv_dtm"; // 22
        p_sct_effctv_dtm.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_sct_effctv_dtm.Value = PLH.SCTeffectivedatetime;

        p_row_cnt_qty.ParameterName = "row_cnt_qty"; // 23
        p_row_cnt_qty.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_row_cnt_qty.Value = PLH.rowcountquantity;

        p_price_sum_amt.ParameterName = "price_sum_amt"; // 24
        p_price_sum_amt.OracleType = OracleType.NVarChar;===> THIS NEEDS TO BE CHECHED
        p_price_sum_amt.Value = PLH.pricesumamount;

        cmd.Parameters.Add(p_price_list_hdr_id); //Add parameters.
        cmd.OracleParameter.Add(p_tough_disc_amt); //Add parameters.
        cmd.OracleParameter.Add(p_damp_disc_amt); //Add parameters.
        cmd.OracleParameter.Add(p_stone_disc_amt); //Add parameters.

        cmd.OracleParameter.Add(p_tough_stone_disc_amt); //Add parameters.
        cmd.OracleParameter.Add(p_damp_stone_disc_amt); //Add parameters.
        cmd.OracleParameter.Add(p_price_list_status_type_name); //Add parameters.
        cmd.OracleParameter.Add(p_load_dtm); //Add parameters.

        cmd.OracleParameter.Add(p_user_name); //Add parameters.
       
        cmd.OracleParameter.Add(p_wht_indr_flag); //Add parameters.
        cmd.OracleParameter.Add(p_durum_indr_flag); //Add parameters.
        cmd.OracleParameter.Add(p_bly_indr_flag); //Add parameters.
        cmd.OracleParameter.Add(p_desigtd_bly_indr_flag); //Add parameters.

        cmd.OracleParameter.Add(p_load_type_name); //Add parameters.
        cmd.OracleParameter.Add(p_wht_basis_num); //Add parameters.

        cmd.OracleParameter.Add(p_durum_basis_num); //Add parameters.
        cmd.OracleParameter.Add(p_bly_basis_num); //Add parameters.
        cmd.OracleParameter.Add(p_desigtd_bly_basis_num); //Add parameters.

        cmd.OracleParameter.Add(p_sct_price_list_name); //Add parameters.
        cmd.OracleParameter.Add(p_pool_part_code); //Add parameters.
        cmd.OracleParameter.Add(p_sct_price_list_name); //Add parameters.
        cmd.OracleParameter.Add(p_sct_effctv_dtm); //Add parameters.
        cmd.OracleParameter.Add(p_row_cnt_qty); //Add parameters.
        cmd.OracleParameter.Add(p_price_sum_amt); //Add parameters.

        cmd.ExecuteNonQuery(); //Execute Procedure here.

       
    }
Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:

public PRICE_LIST_HDRRow AddPRICE_LIST_HDRRow(
                        decimal PRICE_LIST_HDR_ID, 
                        decimal TOUGH_DISC_AMT, 
                        decimal DAMP_DISC_AMT, 
                        decimal STONE_DISC_AMT, 
                        decimal TOUGH_STONE_DISC_AMT, 
                        decimal DAMP_STONE_DISC_AMT, 
                        string PRICE_LIST_STATUS_TYPE_NAME, 
                        System.DateTime LOAD_DTM, 
                        string USER_NAME, 
                        string WHT_INDR_FLAG, 
                        string DURUM_INDR_FLAG, 
                        string BLY_INDR_FLAG, 
                        string DESIGTD_BLY_INDR_FLAG, 
                        string LOAD_TYPE_NAME, 
                        decimal WHT_BASIS_NUM, 
                        decimal DURUM_BASIS_NUM, 
                        decimal BLY_BASIS_NUM, 
                        decimal DESIGTD_BLY_BASIS_NUM, 
                        string SRC_FILE_PATH_DESC, 
                        string POOL_PART_CODE, 
                        string SCT_PRICE_LIST_NAME, 
                        System.DateTime SCT_EFFCTV_DTM, 
                        decimal ROW_CNT_QTY, 
                        decimal PRICE_SUM_AMT)