/// <summary>
/// Obtem um parceiro de negócio a partir de seu código
/// </summary>
public BusinessPartnerDTO GetBusinessPartner(String cardCode)
{
String query = "SELECT CardCode, CardName, CardFName, CntctPrsn FROM OCRD WHERE CardCode = '" + cardCode + "'";
SqlCommand command = new SqlCommand(query, sqlServerConnection);
SqlDataReader dataReader = command.ExecuteReader();
if (!dataReader.Read()) return null;
BusinessPartnerDTO businessPartner = new BusinessPartnerDTO();
businessPartner.CardCode = GetStringValue(dataReader, "CardCode");
businessPartner.CardName = GetStringValue(dataReader, "CardName");
businessPartner.CardFName = GetStringValue(dataReader, "CardFName");
businessPartner.CntctPrsn = GetStringValue(dataReader, "CntctPrsn");
dataReader.Close();
return businessPartner;
}
/// <summary>
/// Obtem o parceiro de negócio responsável pelo transporte de mercadorias
/// </summary>
public BusinessPartnerDTO GetDefaultCarrier()
{
String subQuery = "SELECT GroupCode FROM OCRG WHERE GroupName = 'Transportadora'";
String query = "SELECT CardCode, CardName, CardFName, CntctPrsn FROM OCRD WHERE GroupCode = (" + subQuery + ") ORDER BY UpdateDate ASC";
SqlCommand command = new SqlCommand(query, sqlServerConnection);
SqlDataReader dataReader = command.ExecuteReader();
if (!dataReader.Read()) return null;
BusinessPartnerDTO businessPartner = new BusinessPartnerDTO();
businessPartner.CardCode = GetStringValue(dataReader, "CardCode");
businessPartner.CardName = GetStringValue(dataReader, "CardName");
businessPartner.CardFName = GetStringValue(dataReader, "CardFName");
businessPartner.CntctPrsn = GetStringValue(dataReader, "CntctPrsn");
dataReader.Close();
return businessPartner;
}
