Example #1
0
        public dynamic Lay_DS_Thaydoi_I8(RangeDateRequestModel rdrm)
        {
            dynamic result = null;

            try
            {
                var dyParam = new OracleDynamicParameters();
                dyParam.Add("vtungay", OracleDbType.Varchar2, ParameterDirection.Input, rdrm.tu_ngay);
                dyParam.Add("vdenngay", OracleDbType.Varchar2, ParameterDirection.Input, rdrm.den_ngay);
                dyParam.Add("cur_data", OracleDbType.RefCursor, ParameterDirection.Output);

                var conn = connection.GetConnectionOracle();
                if (conn.State != ConnectionState.Open)
                {
                    conn.Open();
                }
                if (conn.State == ConnectionState.Open)
                {
                    var query = "API_01.Get_ds_thay_doi_i8";
                    result = SqlMapper.Query <DanhsachThaydoiI8Model>(conn, query, param: dyParam, commandType: CommandType.StoredProcedure).ToList();
                    conn.Close();
                }

                datarespond.success = true;
                datarespond.data    = result;
                datarespond.message = "get list I8 modified successfully";
            }
            catch (Exception ex)
            {
                //throw ex;
                datarespond.success = false;
                datarespond.message = ex.Message;
            }

            return(datarespond);
        }
Example #2
0
 public dynamic Lay_DS_Thaydoi_I8([FromBody] RangeDateRequestModel rdrm)
 {
     return(notification.Lay_DS_Thaydoi_I8(rdrm));
 }