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)); }