Beispiel #1
0
        private void Ratio_Bills_Over_Average(object sender, RoutedEventArgs e)
        {
            OracleCommand com = getNewCommand("PKG_MEMBER.ratioBillsOverAverage");

            addArgNumber("memberId", com);
            com.Parameters.Add("FunctionResult", OracleType.Int16);
            com.Parameters["FunctionResult"].Direction = System.Data.ParameterDirection.ReturnValue;
            var wind = new getParameters("Ratio Bills Over Average", new string[] { "memberId" }, com, true);

            wind.Closing += (sende, ev) => { if (((getParameters)sende).returnValue != null)
                                             {
                                                 MessageBox.Show((Convert.ToInt32(((getParameters)sende).returnValue) == 1) ? "The member is over the Bills average!" : "The member is under the Bills average!");
                                             }
            };
            wind.ShowDialog();
        }
Beispiel #2
0
        private void Member_Cost(object sender, RoutedEventArgs e)
        {
            OracleCommand com = getNewCommand("PKG_MEMBER.member_cost");

            addArgNumber("memberId", com);
            com.Parameters.Add("FunctionResult", OracleType.Int32);
            com.Parameters["FunctionResult"].Direction = System.Data.ParameterDirection.ReturnValue;
            var wind = new getParameters("Member Cost", new string[] { "memberId" }, com, true);

            wind.Closing += (sende, ev) => { if (((getParameters)sende).returnValue != null)
                                             {
                                                 MessageBox.Show("The member cost is: " + ((getParameters)sende).returnValue + "₪");
                                             }
            };
            wind.ShowDialog();
        }