public ClientAndCustomerContacts GetCustomerClientContact(int customerId)
{
if (customerId == int.MinValue || customerId == 0)
{
return(null);
}
ClientAndCustomerContacts clientAndCustomerContacts = null;
using (SqlConnection connection = CreateConnection())
{
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(connection,
CommandType.StoredProcedure,
"GetCustomerAndClientContact",
CreateCustomerIdParameter(customerId, true)))
{
CleverReader cleverReader = new CleverReader(dataReader);
if (!cleverReader.IsNull && cleverReader.Read())
{
ClientContact clientContact = new ClientContactBuilder(cleverReader).Build();
cleverReader.NextResult();
cleverReader.Read();
CustomerContact customerContact = new CustomerContactBuilder(cleverReader).Build();
clientAndCustomerContacts = new ClientAndCustomerContacts(clientContact, customerContact);
}
}
}
return(clientAndCustomerContacts);
}
private IList <CustomerContact> GetAllCustomersAndTheirContacts()
{
IList <CustomerContact> contacts;
using (SqlConnection connection = CreateConnection())
{
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(connection,
CommandType.StoredProcedure,
"dbo.CustomerContacts_GetAllContacts"))
{
CleverReader cleverReader = new CleverReader(dataReader);
contacts = new CustomerContactBuilder(cleverReader).BuildAll();
}
}
return(contacts);
}
public IList <CustomerContact> LoadMatchedAllClientsCustomerContact(string textToMatch)
{
IList <CustomerContact> contacts;
using (SqlConnection connection = CreateConnection())
{
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(connection,
CommandType.StoredProcedure,
"dbo.CustomerContactsView_GetMatchedCustomerContacts", GenerateTextToSearchParameters(textToMatch)))
{
CleverReader cleverReader = new CleverReader(dataReader);
contacts = new CustomerContactBuilder(cleverReader).BuildAll();
}
}
return(RecordLimiter.ReturnMaximumRecords(contacts));
}
private IList <CustomerContact> GetACustomersContacts(int customerId)
{
IList <CustomerContact> contacts;
using (SqlConnection connection = CreateConnection())
{
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(connection,
CommandType.StoredProcedure,
"dbo.CustomerContacts_GetContacts",
GenerateCustomerParameters(customerId)))
{
CleverReader cleverReader = new CleverReader(dataReader);
contacts = new CustomerContactBuilder(cleverReader).BuildAll();
}
}
return(contacts);
}
//MSarza [20150819]
public CustomerContact LoadTheDefaultCustomerContact(int customerId)
{
CustomerContact defaultContact = null;
using (SqlConnection connection = CreateConnection())
{
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(connection,
CommandType.StoredProcedure,
"dbo.CustomerContacts_GetContacts",
GenerateDefaultCustomerContactParams(customerId)))
{
CleverReader cleverReader = new CleverReader(dataReader);
if (!cleverReader.IsNull && cleverReader.Read())
{
defaultContact = new CustomerContactBuilder(cleverReader).Build();
}
}
}
return(defaultContact);
}
