public int CreateIndividualConsignee(IndividualConsigneeBindingModel individualConsigneeModel) { int?createdConsigneeId = null; var individualConsignee = new IndividualConsignee(); individualConsignee.FirstName = individualConsigneeModel.FirstName; individualConsignee.LastName = individualConsigneeModel.LastName; individualConsignee.TRN = individualConsigneeModel.TRN; individualConsignee.CustomerCode = individualConsigneeModel.CustomerCode; individualConsignee.Address = individualConsigneeModel.Address; using (var sqlConnection = new SqlConnection(_DBConnectionString)) { try { sqlConnection.Open(); createdConsigneeId = sqlConnection.ExecuteScalar <int>( @"INSERT INTO IndividualConsignee (FirstName,LastName,TRN,Address,CustomerCode) OUTPUT Inserted.Id Values (@indivdualConsignee)", individualConsignee, commandType: CommandType.Text, commandTimeout: 60); } catch (Exception ex) { ex.ToString(); //log exceptions here } } return(createdConsigneeId.Value); }
public int?CreateIndividualConsignee(IndividualConsigneeBindingModel individualConsigneeModel) { int?createdConsigneeId = null; using (var sqlConnection = new SqlConnection(_DBConnectionString)) { try { sqlConnection.Open(); createdConsigneeId = sqlConnection.ExecuteScalar <int>( @"INSERT INTO IndividualConsignee (FirstName,LastName,TRN,Address,CustomerCode) OUTPUT Inserted.Id Values (@FirstName,@LastName,@TRN,@Address,@CustomerCode)", new { @FirstName = individualConsigneeModel.FirstName, @LastName = individualConsigneeModel.LastName, @TRN = individualConsigneeModel.TRN, @Address = individualConsigneeModel.Address, @CustomerCode = individualConsigneeModel.CustomerCode }, commandType: CommandType.Text, commandTimeout: 60); } catch (Exception ex) { _logger.Error(ex, "Error creating individual consignee"); //TODO //NLOG && EXCEPTION HANDLING ex.ToString(); //log exceptions here } } return(createdConsigneeId); }
public int CreateIndividualConsignee(IndividualConsigneeBindingModel individualConsigneeModel) { int? createdConsigneeId = null; var individualConsignee = new IndividualConsignee(); individualConsignee.FirstName = individualConsigneeModel.FirstName; individualConsignee.LastName = individualConsigneeModel.LastName; individualConsignee.TRN = individualConsigneeModel.TRN; individualConsignee.CustomerCode = individualConsigneeModel.CustomerCode; individualConsignee.Address = individualConsigneeModel.Address; using (var sqlConnection = new SqlConnection(_DBConnectionString)) { try { sqlConnection.Open(); createdConsigneeId = sqlConnection.ExecuteScalar<int>( @"INSERT INTO IndividualConsignee (FirstName,LastName,TRN,Address,CustomerCode) OUTPUT Inserted.Id Values (@indivdualConsignee)", individualConsignee, commandType: CommandType.Text, commandTimeout: 60); } catch (Exception ex) { ex.ToString(); //log exceptions here } } return createdConsigneeId.Value; }
public IHttpActionResult IndividualSignUp(IndividualRegistration individualRegistrationModel) { var individualConsigneeModel = new IndividualConsigneeBindingModel() { Address = individualRegistrationModel.Address, TRN = individualRegistrationModel.TRN, FirstName = individualRegistrationModel.PrimaryUser.FirstName, LastName = individualRegistrationModel.PrimaryUser.LastName, }; var registerIndividualResult = _businessManager.RegisterIndividual(individualRegistrationModel.PrimaryUser, individualConsigneeModel); if (!registerIndividualResult.IsSuccess) { return(GetErrorResult(registerIndividualResult)); } var userId = registerIndividualResult.Result.UserModel.Id; Uri locationHeader = new Uri(Url.Link("GetUserById", new { id = userId })); return(Created(locationHeader, registerIndividualResult.Result.UserModel)); }
public GenericActionResult <RegistrationReturnModel <IndividualConsigneeBindingModel> > RegisterIndividual(CreateUserBindingModel principalUser, IndividualConsigneeBindingModel individualConsignee) { //validate individual doesn't exist first bool personAlreadyExists = _validationHelper.CheckForExistingIndividual(individualConsignee.TRN); if (personAlreadyExists) { return new GenericActionResult <RegistrationReturnModel <IndividualConsigneeBindingModel> >() { IsSuccess = false, Errors = new List <string> { "Individual already registered, duplicate TRN" } } } ; var userCreateResult = _userManagement.CreateUser(principalUser); string userId = null; if (userCreateResult.IsSuccess) { userId = userCreateResult.Result.Id; AssignUserToDefaultRoles(userId); } else { return(new GenericActionResult <RegistrationReturnModel <IndividualConsigneeBindingModel> >() { Errors = userCreateResult.Errors, IsSuccess = false, Result = null }); } int?indivdualConsigneeId = _dataAccess.CreateIndividualConsignee(individualConsignee); //if an id wasn't returned, it means an error occurred during the creation of the consignee record //therefore roll back all that came before it. if (!indivdualConsigneeId.HasValue) { //reverse the created user by deleting it _userManagement.DeleteUser(userCreateResult.Result.UserName); return(new GenericActionResult <RegistrationReturnModel <IndividualConsigneeBindingModel> >() { IsSuccess = false, Errors = new List <string> { "Error completing registration,please try again later." } }); } //create link between individual and consignee _dataAccess.CreateIndividualConsigneeRepresentative(userId, indivdualConsigneeId.Value); //return new information on user & company return(new GenericActionResult <RegistrationReturnModel <IndividualConsigneeBindingModel> >() { IsSuccess = true, Result = new RegistrationReturnModel <IndividualConsigneeBindingModel> { ConsigneeModel = individualConsignee, UserModel = userCreateResult.Result }, Errors = null }); }