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