public AllClientsResponse GetAllClients(AllClientsRequest request)
{
var response = new AllClientsResponse {
ResponseStatus = ResponseStatus.Success
};
var clientsProvider = new ClientsProvider();
try
{
if (request.ActionType == ActionType.Select)
{
response.Clients = clientsProvider.GetAllClients(request);
}
else
{
response.ResponseStatus = ResponseStatus.Failure;
response.ResponseDescription = "Not update action";
}
}
catch (Exception ex)
{
response.ResponseStatus = ResponseStatus.Failure;
response.ResponseDescription = ex.Message;
}
return(response);
}
public List <ClientProfile> GetAllClients(AllClientsRequest request)
{
var conn = GetConnection(ConnectionNames.CSPSqlDatabase);
var commandWrapper = GetStoredProcCommand("dbo.Get_All_Clients", conn);
AddInParameter(commandWrapper, "@Role", DbType.Int32, request.Role);
AddInParameter(commandWrapper, "@TeamId", DbType.Int32, request.TeamId);
IDataReader reader = null;
List <ClientProfile> tmp = new List <ClientProfile>();
try
{
conn.Open();
reader = commandWrapper.ExecuteReader();
FillClients(reader, tmp, 0, int.MaxValue);
MakeDboLog(request.ToString(), reader.ToString(), "dbo.GetAllClients");
return(tmp);
}
finally
{
if (reader != null)
{
reader.Close();
}
commandWrapper.Dispose();
conn.Close();
}
}
public AllClientsRequest GetAllClientsRequest(Role role, int teamId)
{
var request = new AllClientsRequest
{
Role = role,
TeamId = teamId,
ActionType = DataBaseCommunication.Mappers.Requests.ActionType.Select
};
return(request);
}
public UpdateClientResponse UpdateClientData(UpdateClientRequest request)
{
var response = new UpdateClientResponse {
ResponseStatus = ResponseStatus.Success
};
var clientsProvider = new ClientsProvider();
try
{
if (request.ActionType == ActionType.Update)
{
response.isSuccessful = clientsProvider.ChangeClientData(request);
if (response.isSuccessful)
{
var refreshClientsRequest = new AllClientsRequest
{
ActionType = ActionType.Select,
Role = request.Role,
TeamId = request.TeamId
};
var clientsResponse = GetAllClients(refreshClientsRequest);
response.NewClientsList = clientsResponse.Clients;
//Log all changes
List <Change> changes = ClientsHelper.GetAllChanges(request.Client, request.OldClientProfile);
response.isSuccessful = clientsProvider.LogClientChanges(changes, request.Client.CustomerID, request.UserId);
}
}
else
{
response.ResponseStatus = ResponseStatus.Failure;
response.ResponseDescription = "Not update action";
}
}
catch (Exception ex)
{
response.ResponseStatus = ResponseStatus.Failure;
response.ResponseDescription = ex.Message;
}
return(response);
}
public NewClientResponse AddNewClient(NewClientRequest request)
{
var response = new NewClientResponse {
ResponseStatus = ResponseStatus.Success
};
var clientsProvider = new ClientsProvider();
try
{
if (request.ActionType == ActionType.Insert)
{
response.isSuccessful = clientsProvider.InsertClientData(request);
if (response.isSuccessful)
{
var refreshClientsRequest = new AllClientsRequest
{
ActionType = ActionType.Select,
Role = request.Role,
TeamId = request.TeamId
};
var clientsResponse = GetAllClients(refreshClientsRequest);
response.NewClientsList = clientsResponse.Clients;
}
}
else
{
response.ResponseStatus = ResponseStatus.Failure;
response.ResponseDescription = "Not update action";
}
}
catch (Exception ex)
{
response.ResponseStatus = ResponseStatus.Failure;
response.ResponseDescription = ex.Message;
}
return(response);
}
