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();
}
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();
}