public void FirstCompanyShouldBeDifferentThanSecondCompanyTest()
{
using (SapRfcConnection conn = this.GetConnection())
{
var firstCompany = conn.Table <AirlineCompany>("SCARR").Take(1).ReadOne();
var secondCompany = conn.Table <AirlineCompany>("SCARR").Skip(1).Take(1).ReadOne();
Assert.NotEqual(firstCompany.Code, secondCompany.Code);
}
}
public void ReadAllEntriesTest()
{
using (SapRfcConnection conn = this.GetConnection())
{
var scarr = conn.Table <AirlineCompany>("SCARR").Read();
Assert.Equal(18, scarr.Count());
}
}
public void TakeFirstCompanyTest()
{
using (SapRfcConnection conn = this.GetConnection())
{
var scarr = conn.Table <AirlineCompany>("SCARR").Take(1).Read();
Assert.Equal(1, scarr.Count());
}
}
public void StrongTypeGreaterEqualAndLessEqualThanConditionTest()
{
using (SapRfcConnection conn = this.GetConnection())
{
var flights = conn.Table <Flight>("SPFLI")
.Where("DISTANCE", RfcReadTableOption.GreaterOrEqualThan, 6030)
.And("DISTANCE", RfcReadTableOption.LessOrEqualThan, 9100)
.Read();
Assert.Equal(12, flights.Count());
}
}
public void ReadWithTwoOrConditionsTest()
{
using (SapRfcConnection conn = this.GetConnection())
{
var scarr = conn.Table <AirlineCompany>("SCARR")
.Select("CARRID", "CURRCODE")
.Where("CARRID = 'DL'")
.Or("CARRID = 'AA'")
.Read();
Assert.Equal(2, scarr.Count());
}
}
public void ReadTwoFieldsTest()
{
using (SapRfcConnection conn = this.GetConnection())
{
var scarr = conn.Table <AirlineCompany>("SCARR").Select("CARRID", "CARRNAME").Read();
Assert.Equal(18, scarr.Count());
var aa = scarr.FirstOrDefault(x => x.Code == "AA");
Assert.Equal("AA", aa.Code);
Assert.Equal("American Airlines", aa.Name);
Assert.Equal(null, aa.Currency);
Assert.Equal(null, aa.Url);
}
}
public void StrongTypeNotEqualsConditionTest()
{
using (SapRfcConnection conn = this.GetConnection())
{
var scarr = conn.Table <AirlineCompany>("SCARR")
.Select("CARRID", "CURRCODE")
.Where("CARRID", RfcReadTableOption.NotEquals, "DL")
.Read();
foreach (var company in scarr)
{
Assert.NotEqual("DL", company.Code);
}
}
}
public void StrongTypeEqualsConditionTest()
{
using (SapRfcConnection conn = this.GetConnection())
{
var scarr = conn.Table <AirlineCompany>("SCARR")
.Select("CARRID", "CURRCODE")
.Where("CARRID", RfcReadTableOption.Equals, "DL")
.Read();
Assert.Equal(1, scarr.Count());
Assert.Equal("DL", scarr.ElementAt(0).Code);
Assert.Equal("USD", scarr.ElementAt(0).Currency);
Assert.Equal(null, scarr.ElementAt(0).Name);
Assert.Equal(null, scarr.ElementAt(0).Url);
Assert.Equal(0, scarr.ElementAt(0).Client);
}
}
public void ReadTwoFieldFromDeltaAirlineCompanyTest()
{
using (SapRfcConnection conn = this.GetConnection())
{
var scarr = conn.Table <AirlineCompany>("SCARR")
.Select("CARRID", "CURRCODE")
.Where("CARRID = 'DL'")
.Read();
Assert.Equal(1, scarr.Count());
Assert.Equal("DL", scarr.ElementAt(0).Code);
Assert.Equal("USD", scarr.ElementAt(0).Currency);
Assert.Equal(null, scarr.ElementAt(0).Name);
Assert.Equal(null, scarr.ElementAt(0).Url);
Assert.Equal(0, scarr.ElementAt(0).Client);
}
}