public Message CreateClient(NewClientRequest newClient)
{
Message message = new Message();
int answer = 0;
try
{
Open();
command = new SqlCommand("dbo.spCreateNewUser", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@username", newClient.username);
command.Parameters.AddWithValue("@password", newClient.password);
command.Parameters.AddWithValue("@name", newClient.name);
reader = command.ExecuteReader();
while (reader.Read())
{
answer = reader.GetFieldValue <int>(0);
}
Close();
if (answer != 0)
{
message = new Message("0000", "Transaccion exitosa, cliente registrado", null);
}
else
{
message = new Message("0010", "Transaccion fallida.", null);
}
}
catch (Exception ex)
{
message = new Message("0011", "Transaccion fallida.", ex);
}
return(message);
}
public IActionResult Post(NewClientRequest newClient)
{
Repo.Add(newClient.Client);
if (Repo.SaveChanges())
{
int clientId = newClient.Client.Id;
foreach (var phoneNumber in newClient.PhoneList)
{
Phone tempPhone = new Phone()
{
ClientId = clientId,
Number = phoneNumber
};
Repo.Add(tempPhone);
}
if (Repo.SaveChanges())
{
var createdClient = Repo.GetClientById(clientId);
return(Ok(createdClient));
}
return(Ok("Fail on storage client phone list"));
}
return(Ok("Fail on create new client"));
}
public bool InsertClientData(NewClientRequest request)
{
var conn = GetConnection(ConnectionNames.CSPSqlDatabase);
var commandWrapper = GetStoredProcCommand("dbo.Insert_Client_Data", conn);
AddInParameter(commandWrapper, "@CustomerID", DbType.Int32, request.Client.CustomerID);
AddInParameter(commandWrapper, "@Name", DbType.String, request.Client.Name);
AddInParameter(commandWrapper, "@Address", DbType.String, request.Client.Address);
AddInParameter(commandWrapper, "@Place", DbType.String, request.Client.Place);
AddInParameter(commandWrapper, "@Municipality", DbType.String, request.Client.Municipality);
AddInParameter(commandWrapper, "@PIB", DbType.String, request.Client.PIB);
AddInParameter(commandWrapper, "@LegalID", DbType.String, request.Client.LegalID);
AddInParameter(commandWrapper, "@CreationDate", DbType.DateTime, request.Client.CreationDate == DateTime.MinValue ? System.Data.SqlTypes.SqlDateTime.MinValue.Value : request.Client.CreationDate);
AddInParameter(commandWrapper, "@Activity", DbType.String, request.Client.Activity);
AddInParameter(commandWrapper, "@ActivityCode", DbType.String, request.Client.ActivityCode);
AddInParameter(commandWrapper, "@Form", DbType.String, request.Client.Form);
AddInParameter(commandWrapper, "@FormSubType", DbType.String, request.Client.FormSubType);
AddInParameter(commandWrapper, "@ResponsiblePerson", DbType.String, request.Client.ResponsiblePerson);
AddInParameter(commandWrapper, "@ResponsiblePersonBirthDate", DbType.DateTime, request.Client.ResponsiblePersonBirthDate == DateTime.MinValue ? System.Data.SqlTypes.SqlDateTime.MinValue.Value : request.Client.ResponsiblePersonBirthDate);
AddInParameter(commandWrapper, "@ResponsiblePersonMail", DbType.String, request.Client.ResponsiblePersonMail);
AddInParameter(commandWrapper, "@ResponsiblePersonPhone", DbType.String, request.Client.ResponsiblePersonPhone);
AddInParameter(commandWrapper, "@PDV", DbType.String, request.Client.PDV);
AddInParameter(commandWrapper, "@BookKeepingType", DbType.String, request.Client.BookKeepingType);
AddInParameter(commandWrapper, "@Director", DbType.String, request.Client.Director);
AddInParameter(commandWrapper, "@Account", DbType.String, request.Client.Account);
AddInParameter(commandWrapper, "@EmployeesNumber", DbType.Int32, request.Client.EmployeesNumber);
AddInParameter(commandWrapper, "@StartDate", DbType.DateTime, request.Client.StartDate == DateTime.MinValue ? System.Data.SqlTypes.SqlDateTime.MinValue.Value : request.Client.StartDate);
AddInParameter(commandWrapper, "@MainUserId", DbType.Int32, request.Client.MainUserId);
AddInParameter(commandWrapper, "@SecondUserId", DbType.Int32, request.Client.SecondUserId);
AddInParameter(commandWrapper, "@Amount", DbType.Int32, request.Client.Amount);
AddInParameter(commandWrapper, "@AmountCode", DbType.String, request.Client.AmountCode);
AddInParameter(commandWrapper, "@Slava", DbType.String, request.Client.Slava);
AddInParameter(commandWrapper, "@BirthDate", DbType.DateTime, request.Client.BirthDate == DateTime.MinValue ? System.Data.SqlTypes.SqlDateTime.MinValue.Value : request.Client.BirthDate);
AddInParameter(commandWrapper, "@DeliveryMethod", DbType.String, request.Client.DeliveryMethod);
AddInParameter(commandWrapper, "@AdditionalMails", DbType.String, request.Client.AdditionalMails);
AddInParameter(commandWrapper, "@CourierDay", DbType.Int32, request.Client.CourierDay);
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.Insert_Client_Data");
var errorObject = GetParameterValue(commandWrapper, "@ERROR");
var errorCodeObject = GetParameterValue(commandWrapper, "@ERROR_CODE");
return(Convert.ToBoolean(results));
}
finally
{
commandWrapper.Dispose();
conn.Close();
}
}
public override Task <NewClientReply> NewClient(NewClientRequest req, ServerCallContext _)
{
var input = string.Concat(
PCSManager.ClientHeader(req.Uname, req.URL, req.Script),
PCSManager.Partitions(req.SParts),
PCSManager.Servers(req.Servs)
);
PCSManager.NewProcess(exeClient, input);
return(Task.FromResult(new NewClientReply()));
}
public void CreateNewClientRequest(String contactNumber)
{
endCall();
NewClientRequestController newClientRequestController = new NewClientRequestController();
NewClientRequest newClientRequest = new NewClientRequest(DateTime.Now, null, callLog);
newClientRequest.ContactNum = contactNumber;
newClientRequestController.Create(newClientRequest);
}
private NewClientResponse AddClientCore(NewClientRequest request)
{
var entity = new Client {
Name = request.Name, Address = request.Address
};
_dataModel.Client.Add(entity);
_dataModel.SaveChanges();
return(new NewClientResponse {
ClientId = entity.Id
});
}
public static Client ToEntity(this NewClientRequest request)
{
return(new Client
{
Address = request.Address,
DNI = request.DNI,
Email = request.Email,
LastNames = request.LastNames,
Names = request.Names,
Phone = request.Phone
});
}
public async Task NewClientAsync(string uname, string URL, string script) {
var req = new NewClientRequest {
Uname = uname,
URL = URL,
Script = script
};
SetPartitions(req.SParts);
SetServers(req.Servs);
try {
await stub.NewClientAsync(req);
} catch (RpcException e) {
PupExec.Clients[uname].NegAvailSync();
MessageBox.Show(string.Format("NewClientAsync: Not Created!{0}{1}", Environment.NewLine, e.Message));
}
}
public IActionResult AddNewClient(NewClientRequest request)
{
var errorList = ValidationHelper.ValidateNewClientRequest(request);
if (errorList.Count > 0)
{
return(BadRequest(errorList));
}
try
{
var response = _dbService.AddNewClient(request);
return(StatusCode(201, response));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
//Methods
private void CreateNewClient()
{
NewClientRequest.Raise(new CreateNewClientNotification {
Title = "Create a New Client Entry"
}, r =>
{
if (r.Confirmed)
{
int newClientID = _cs.AddNewClient(new Client()
{
ClientName = r.ClientName,
OfficeName = r.OfficeName,
});
NavigateToClientEntry(newClientID);
}
}
);
}
public void AddNewClient_SUCCESS()
{
//Arrange
var request = new NewClientRequest
{
FirstName = "Jan",
LastName = "Kotowski",
Email = "*****@*****.**",
Phone = "111-222-333",
Login = "******",
Password = "******"
};
var targetResponse = new NewClientResponse
{
AccessToken = "access",
RefreshToken = "refresh"
};
mockDbService.Setup(service => service.AddNewClient(request))
.Returns(targetResponse);
//Act
var actionResult = clientsController.AddNewClient(request);
//Assert
var createdObjectResult = actionResult as ObjectResult;
Assert.NotNull(createdObjectResult);
Assert.Equal(201, createdObjectResult.StatusCode);
var resultResponse = createdObjectResult.Value as NewClientResponse;
Assert.Equal(targetResponse, resultResponse);
mockDbService.Verify(service => service.AddNewClient(request), Times.Once);
}
public void AddNewClient_VALIDATION_ERROR_BAD_REQUEST()
{
//Arrange
var request = new NewClientRequest
{
FirstName = "123",
LastName = "*&%^$",
Email = "hello",
Phone = "abc",
Login = null,
Password = ""
};
var targetErrorList = new List <Error>();
targetErrorList.Add(
new Error
{
Field = "FirstName",
InvalidValue = request.FirstName,
Message = "Wrong format for First Name. Should be ^[A-Z][-a-zA-Z]+$"
}
);
targetErrorList.Add(
new Error
{
Field = "LastName",
InvalidValue = request.LastName,
Message = "Wrong format for Last Name. Should be ^[A-Z][-a-zA-Z]+$"
}
);
targetErrorList.Add(
new Error
{
Field = "Email",
InvalidValue = request.Email,
Message = "Wrong format for email"
}
);
targetErrorList.Add(
new Error
{
Field = "Phone",
InvalidValue = request.Phone,
Message = "Wrong format for phone number. Should be ^\\d{3}-\\d{3}-\\d{3}$"
}
);
targetErrorList.Add(
new Error
{
Field = "Login",
InvalidValue = request.Login,
Message = "Login field must be filled in"
}
);
targetErrorList.Add(
new Error
{
Field = "Password",
InvalidValue = request.Password,
Message = "Password field must be filled in"
}
);
//Act
var actionResult = clientsController.AddNewClient(request);
//Assert
var badRequestObjectResult = actionResult as BadRequestObjectResult;
Assert.NotNull(badRequestObjectResult);
var resultClientList = badRequestObjectResult.Value as List <Error>;
targetErrorList.Should().BeEquivalentTo(resultClientList);
mockDbService.Verify(service => service.AddNewClient(request), Times.Never);
}
public async Task <Guid> Post([FromBody] NewClientRequest request) => await _pipelineBehavior.Handle(request, _clientProcessor.Create);
public NewClientResponse AddClient(NewClientRequest request)
{
return(this.HandleAndReturn(request, AddClientCore));
}
public async Task <RegisteredClient> AddNewClient([FromBody] NewClientRequest request)
{
return(await _mediator.Send(request));
}
public NewClientResponse Create(NewClientRequest request)
{
return(_clientService.AddClient(request));
}
