public int CreateCompanyConsignee(CompanyConsigneeBindingModel companyConsigneeModel) { int?createdConsigneeId = null; var companyCosignee = new CompanyConsignee(); companyCosignee.CompanyName = companyConsigneeModel.CompanyName; companyCosignee.CompanyTRN = companyConsigneeModel.CompanyTRN; companyCosignee.CompanyAddress = companyConsigneeModel.CompanyAddress; companyCosignee.CompanyEmail = companyConsigneeModel.CompanyEmail; companyCosignee.CompanyPhone = companyCosignee.CompanyPhone; companyCosignee.CustomerCode = companyCosignee.CustomerCode; using (var sqlConnection = new SqlConnection(_DBConnectionString)) { try { sqlConnection.Open(); createdConsigneeId = sqlConnection.ExecuteScalar <int>( @"INSERT INTO CompanyConsignee (CompanyName,CompanyTRN,CompanyAddress,CompanyEmail,CompanyPhoneNumber,CustomerCode) OUTPUT Inserted.Id Values (@companyConsignee)", companyCosignee, commandType: CommandType.Text, commandTimeout: 60); } catch (Exception ex) { ex.ToString(); //log exceptions here } } return(createdConsigneeId.Value); }
public int?CreateCompanyConsignee(CompanyConsigneeBindingModel companyConsigneeModel) { int?createdConsigneeId = null; var CompanyCosignee = new CompanyConsignee(); using (var sqlConnection = new SqlConnection(_DBConnectionString)) { try { //TODO replace with stored procedures sqlConnection.Open(); createdConsigneeId = sqlConnection.ExecuteScalar <int>( @"INSERT INTO CompanyConsignee (CompanyName,CompanyTRN,CompanyAddress,CompanyEmail,CompanyPhoneNumber) OUTPUT Inserted.Id Values (@CompanyName,@CompanyTRN,@CompanyAddress,@CompanyEmail,@CompanyPhone)", new { CompanyName = companyConsigneeModel.CompanyName, CompanyTRN = companyConsigneeModel.CompanyTRN, CompanyAddress = companyConsigneeModel.CompanyAddress, CompanyEmail = companyConsigneeModel.CompanyEmail, CompanyPhone = CompanyCosignee.CompanyPhone, }, commandType: CommandType.Text, commandTimeout: 60); } catch (Exception ex) { _logger.Error(ex, "Error creating company consignee."); //TODO - Rethrow exception here //ex.ToString(); //log exceptions here } } return(createdConsigneeId); }
public int CreateCompanyConsignee(CompanyConsigneeBindingModel companyConsigneeModel) { int? createdConsigneeId = null; var companyCosignee = new CompanyConsignee(); companyCosignee.CompanyName = companyConsigneeModel.CompanyName; companyCosignee.CompanyTRN = companyConsigneeModel.CompanyTRN; companyCosignee.CompanyAddress = companyConsigneeModel.CompanyAddress; companyCosignee.CompanyEmail = companyConsigneeModel.CompanyEmail; companyCosignee.CompanyPhone = companyCosignee.CompanyPhone; companyCosignee.CustomerCode = companyCosignee.CustomerCode; using (var sqlConnection = new SqlConnection(_DBConnectionString)) { try { sqlConnection.Open(); createdConsigneeId = sqlConnection.ExecuteScalar<int>( @"INSERT INTO CompanyConsignee (CompanyName,CompanyTRN,CompanyAddress,CompanyEmail,CompanyPhoneNumber,CustomerCode) OUTPUT Inserted.Id Values (@companyConsignee)",companyCosignee, commandType: CommandType.Text, commandTimeout: 60); } catch (Exception ex) { ex.ToString(); //log exceptions here } } return createdConsigneeId.Value; }
public GenericActionResult <RegistrationReturnModel <CompanyConsigneeBindingModel> > RegisterCompanyWithPrincipal(CreateUserBindingModel principalUser, CompanyConsigneeBindingModel companyConsignee) { bool companyAlreadyExists = _validationHelper.CheckForExistingCompany(companyConsignee.CompanyTRN); if (companyAlreadyExists) { return(new GenericActionResult <RegistrationReturnModel <CompanyConsigneeBindingModel> >() { IsSuccess = false, Errors = new List <string> { "Company already registered, duplicate TRN" } }); } var createUserResult = _userManagement.CreateUser(principalUser); string userId = null; if (createUserResult.IsSuccess) { userId = createUserResult.Result.Id; AssignUserToDefaultRoles(userId); } else { return new GenericActionResult <RegistrationReturnModel <CompanyConsigneeBindingModel> >() { IsSuccess = false, Errors = createUserResult.Errors } }; //create and get company id to create a link between created user int?companyId = _dataAccess.CreateCompanyConsignee(companyConsignee); //if no company Id was returned, it means an error occured during creation of the user //in that case roll back the created user transactions if (!companyId.HasValue) { //TODO could use transactions here //reverse the created user by deleting it _userManagement.DeleteUser(createUserResult.Result.UserName); return(new GenericActionResult <RegistrationReturnModel <CompanyConsigneeBindingModel> >() { IsSuccess = false, Errors = new List <string> { "Error completing registration,please try again later." } }); } //create a link record between the company and the user _dataAccess.CreateCompanyConsigneeRepresentative(userId, companyId.Value); //return new information on user & company return(new GenericActionResult <RegistrationReturnModel <CompanyConsigneeBindingModel> >() { IsSuccess = true, Errors = null, Result = new RegistrationReturnModel <CompanyConsigneeBindingModel>() { UserModel = createUserResult.Result, ConsigneeModel = companyConsignee } }); }
public int CreateConsignee(CompanyConsigneeBindingModel companyConsigneeModel) { throw new NotImplementedException(); }