public ICffClient GetCffClientByClientId(int clientId)
{
ICffClient cffClient = null;
using (SqlConnection connection = CreateConnection())
{
using (
SqlDataReader dataReader = SqlHelper.ExecuteReader(connection, CommandType.StoredProcedure,
"Client_GetClientByCleintID",
CreateClientIdParameter(clientId)))
{
CleverReader cleverReader = new CleverReader(dataReader);
if (!cleverReader.IsNull && cleverReader.Read())
{
if (cleverReader.FromBigInteger("ClientID") == -1)
{
cffClient = AllClients.Create();
}
else
{
cffClient = new CffClient(cleverReader.ToString("ClientName"),
cleverReader.FromBigInteger("ClientID"),
cleverReader.FromBigInteger("ClientNum"),
cleverReader.ToSmallInteger("FacilityType"),
cleverReader.ToString("CollectionsBankAccount"),
cleverReader.ToSmallInteger("CFFDebtorAdmin"), //MSazra [20151006]
cleverReader.ToBoolean("ClientHasLetterTemplates") //MSazra [20151006]
);
}
}
}
}
return(cffClient);
}
public ICffClient LoadCffClientAssociatedWith(ICffUser user)
{
ArgumentChecker.ThrowIfNull(user, "user");
ICffClient client;
if (user.UserType == UserType.EmployeeAdministratorUser ||
user.UserType == UserType.EmployeeManagementUser ||
user.UserType == UserType.EmployeeStaffUser)
{
client = AllClients.Create();
}
else if (user.UserType == UserType.ClientStaffUser)
{
client = clientRepository.GetCffClientByClientId((int)((ClientStaffUser)user).ClientId);
}
else if (user.UserType == UserType.ClientManagementUser)
{
client = clientRepository.GetCffClientByClientId((int)((ClientManagementUser)user).ClientId);
}
else if (user.UserType == UserType.CustomerUser)
{
client = clientRepository.GetCffClientByCustomerId((int)((CustomerUser)user).CustomerId);
}
else
{
throw new CffUserNotFoundException("No cff user found");
}
return(client);
}
public IList <ICffClient> GetClientNameAndNum(string searchString, int numberOfCustomersToReturn)
{
IList <ICffClient> clientsList = new List <ICffClient>();
using (SqlConnection connection = CreateConnection())
{
using (
SqlDataReader dataReader = SqlHelper.ExecuteReader(connection, CommandType.StoredProcedure,
"GetMatchedClient",
CreateShowMatchedNamesParameters(searchString,
numberOfCustomersToReturn))
)
{
CleverReader cleverReader = new CleverReader(dataReader);
if (!cleverReader.IsNull)
{
while (cleverReader.Read())
{
if (cleverReader.FromBigInteger("ClientID") == -1)
{
clientsList.Add(AllClients.Create());
}
else
{
clientsList.Add(new CffClient(cleverReader.ToString("ClientName"),
cleverReader.FromBigInteger("ClientID"),
cleverReader.FromBigInteger("ClientNum"),
cleverReader.ToSmallInteger("FacilityType"),
cleverReader.ToString("CollectionsBankAccount"),
cleverReader.ToSmallInteger("CFFDebtorAdmin"), //MSazra [20151006]
cleverReader.ToBoolean("ClientHasLetterTemplates") //MSazra [20151006]
));
}
}
}
}
}
return(clientsList);
}
public bool CheckCustomerBelongsToClient(int clientId, int customerId)
{
if (clientId == AllClients.Create().Id)
{
return(true);
}
using (SqlConnection connection = CreateConnection())
{
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(connection,
CommandType.StoredProcedure,
"CheckCustomerBelongsToClient",
CreateClientAndCustomerIdParameters(clientId, customerId)))
{
CleverReader cleverReader = new CleverReader(dataReader);
if (!cleverReader.IsNull && cleverReader.Read())
{
return(cleverReader.ToBoolean("Result"));
}
}
}
return(false);
}