public IEnumerable <DomainEntity.VendorEntity> GetAllVendor(DomainEntity.VendorEntity entity)
{
try
{
var vendorList = new List <DomainEntity.VendorEntity>();
using (JDAContext)
{
if (DBOPEN(Function.getConnectionString(entity.login_entity), JDAContext))
{
string querystring = "SELECT " + entity.login_entity.dBname + ".APSUPP.ASALPH, "
+ entity.login_entity.dBname + ".APSUPP.ASNUM, "
+ entity.login_entity.dBname + ".APSUPP.ASNAME, "
+ entity.login_entity.dBname + ".APADDR.AAPHON "
+ "FROM " + entity.login_entity.dBname + ".APSUPP "
+ "INNER JOIN " + entity.login_entity.dBname + ".APADDR "
+ "ON " + entity.login_entity.dBname + ".APSUPP.ASNUM "
+ "= " + entity.login_entity.dBname + ".APADDR.AANUM ";
//+ "FETCH FIRST 50 ROWS ONLY";
var JDACommand = new OdbcCommand(querystring, JDAContext);
JDACommand.CommandTimeout = 0;
var JDAReader = JDACommand.ExecuteReader();
while (JDAReader.Read())
{
var vendorDetails = new DomainEntity.VendorEntity();
vendorDetails.mnemonic = JDAReader.GetString(JDAReader.GetOrdinal("ASALPH"));
vendorDetails.vendorNumber = JDAReader.GetInt32(JDAReader.GetOrdinal("ASNUM"));
vendorDetails.vendorName = JDAReader.GetString(JDAReader.GetOrdinal("ASNAME"));
vendorDetails.phoneNumber = JDAReader.GetString(JDAReader.GetOrdinal("AAPHON"));
vendorList.Add(vendorDetails);
}
JDAReader.Close();
JDACommand.Dispose();
}
}
return(vendorList);
}
catch (Exception ex)
{
throw ex;
}
finally
{
JDAContext.Close();
}
}
public void Update(DomainEntity.VendorEntity entity)
{
throw new NotImplementedException();
}
