public UpdateClientServicesResponse UpdateClientServices(UpdateClientServicesRequest request)
{
var response = new UpdateClientServicesResponse {
ResponseStatus = ResponseStatus.Success
};
var clientsProvider = new ClientsProvider();
try
{
if (request.ActionType == ActionType.Update)
{
response.isSuccessful = clientsProvider.ChangeClientServices(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 bool ChangeClientServices(UpdateClientServicesRequest request)
{
var conn = GetConnection(ConnectionNames.CSPSqlDatabase);
var commandWrapper = GetStoredProcCommand("dbo.Update_Client_Services", conn);
AddInParameter(commandWrapper, "@CustomerID", DbType.Int32, request.ClientId);
AddInParameter(commandWrapper, "@ServiceIds", DbType.String, string.Join(",", request.NewServices));
AddInParameter(commandWrapper, "@ERROR", DbType.String, 1000);
AddInParameter(commandWrapper, "@ERROR_CODE", DbType.String, 4);
try
{
conn.Open();
int results = commandWrapper.ExecuteNonQuery();
var isProcedureSucced = Convert.ToBoolean(results);
MakeDboLog(request.ToString(), isProcedureSucced.ToString(), "dbo.Update_Client_Services");
var errorObject = GetParameterValue(commandWrapper, "@ERROR");
var errorCodeObject = GetParameterValue(commandWrapper, "@ERROR_CODE");
return(Convert.ToBoolean(results));
}
finally
{
commandWrapper.Dispose();
conn.Close();
}
}
public UpdateClientServicesRequest UpdateClientServicesRequest(int clientId, List <int> services)
{
var request = new UpdateClientServicesRequest
{
ClientId = clientId,
NewServices = services,
ActionType = DataBaseCommunication.Mappers.Requests.ActionType.Update
};
return(request);
}
