public void AddParameters()
{
Library lib = Library.Create(this.AllorsSession, "TestLib");
Program pgm = Program.Create(this.AllorsSession, "TestPgm", lib);
Parameter parm1 = StringParameter.Create(this.AllorsSession, "@parm1", 10, "test1");
pgm.FirstParameter = parm1;
Parameter parm2 = StringParameter.Create(this.AllorsSession, "@parm2", 20, "test2");
parm1.NextParameter = parm2;
Parameter parm3 = IntParameter.Create(this.AllorsSession, "@parm3", 30);
parm2.NextParameter = parm3;
Parameter parm4 = DecimalParameter.Create(this.AllorsSession, "@parm4", 5, 2, 0M);
parm3.NextParameter = parm4;
Parameter parm5 = DateTimeParameter.Create(this.AllorsSession, "@parm5", DateTime.Now);
parm4.NextParameter = parm5;
Assert.IsTrue(pgm.Parameters.Count == 5);
}
public void CallTest006()
{
Library lib = Library.Create(this.AllorsSession, "TestLib");
IntParameter parm5;
StringParameter parm6;
DecimalParameter parm7;
DateTimeParameter parm8;
DateTime tijd = DateTime.Now;
using (Program pgm = Program.Create(this.AllorsSession, "Test006", lib))
{
IntParameter parm1 = IntParameter.Create(this.AllorsSession, "@parm1", 25);
pgm.FirstParameter = parm1;
StringParameter parm2 = StringParameter.Create(this.AllorsSession, "@parm2", 20, "testing");
parm1.NextParameter = parm2;
DecimalParameter parm3 = DecimalParameter.Create(this.AllorsSession, "@parm3", 18, 2, 118.36M);
parm2.NextParameter = parm3;
DateTimeParameter parm4 = DateTimeParameter.Create(this.AllorsSession, "@parm4", tijd);
parm3.NextParameter = parm4;
parm5 = IntParameter.Create(this.AllorsSession, "@parm5", 0);
parm4.NextParameter = parm5;
parm6 = StringParameter.Create(this.AllorsSession, "@parm6", 20, "");
parm5.NextParameter = parm6;
parm7 = DecimalParameter.Create(this.AllorsSession, "@parm7", 18, 2, 0.00M);
parm6.NextParameter = parm7;
parm8 = DateTimeParameter.Create(this.AllorsSession, "@parm8", DateTime.MinValue);
parm7.NextParameter = parm8;
string connectionstring = ConfigurationManager.ConnectionStrings["iseries"].ConnectionString;
using (Session session = new Session(connectionstring))
{
pgm.Call(session);
session.Commit();
}
}
Assert.IsTrue(parm5.Value == 25);
Assert.IsTrue(parm6.Value == "testing");
Assert.IsTrue(parm7.Value == 118.36M);
Assert.IsTrue(parm8.Value.Date == tijd.Date);
}
public void CreateDecimal()
{
DecimalParameter param = DecimalParameter.Create(this.AllorsSession, "strParam", 4, 2, 10.23M);
Assert.IsTrue(param != null);
Assert.IsTrue(param.Value == 10.23M);
Assert.IsTrue(param.Name == "strParam");
iDB2Parameter newValue = new iDB2Parameter("strParam", iDB2DbType.iDB2Decimal);
newValue.Value = 19.86M;
param.UpdateValue(newValue);
Assert.IsTrue(param.Value == 19.86M);
}
public void CallTest003()
{
Library lib = Library.Create(this.AllorsSession, "TestLib");
DecimalParameter parm2;
using (Program pgm = Program.Create(this.AllorsSession, "Test003", lib))
{
DecimalParameter parm1 = DecimalParameter.Create(this.AllorsSession, "@parm1", 18, 2, 1235.23M);
pgm.FirstParameter = parm1;
parm2 = DecimalParameter.Create(this.AllorsSession, "@parm2", 18, 2, 0.00M);
parm1.NextParameter = parm2;
string connectionstring = ConfigurationManager.ConnectionStrings["iseries"].ConnectionString;
using (Session session = new Session(connectionstring))
{
pgm.Call(session);
session.Commit();
}
}
Assert.IsTrue(parm2.Value == 1235.23M);
}
