public IActionResult GetAllAddresses([FromQuery] GetAllAddressesModel request)
{
Guard.NotNull(request, nameof(request));
// Checks the request is valid.
if (!this.ModelState.IsValid)
{
return(BuildErrorResponse(this.ModelState));
}
try
{
Wallet wallet = this.walletManager.GetWallet(request.WalletName);
HdAccount account = wallet.GetAccountByCoinType(request.AccountName, this.coinType);
AddressesModel model = new AddressesModel
{
Addresses = account.GetCombinedAddresses().Select(address => new AddressModel
{
Address = address.Address,
IsUsed = address.Transactions.Any(),
IsChange = address.IsChangeAddress()
})
};
return(this.Json(model));
}
catch (Exception e)
{
this.logger.LogError("Exception occurred: {0}", e.ToString());
return(ErrorHelpers.BuildErrorResponse(HttpStatusCode.BadRequest, e.Message, e.ToString()));
}
}
public virtual AvaCreateTransactionModel FromContext(TaxEvaluationContext context, string requiredCompanyCode)
{
code = context.Id;
// TODO: customerCode is required by AvaTax API, but using stub values when the customer is not specified doesn't seem right...
customerCode = context.Customer?.Id ?? Thread.CurrentPrincipal?.Identity?.Name ?? "undef";
companyCode = requiredCompanyCode;
date = DateTime.UtcNow;
type = DocumentType.SalesOrder;
currencyCode = context.Currency;
if (context.Lines != null)
{
lines = new List <LineItemModel>();
foreach (var taxLine in context.Lines.Where(x => !x.IsTransient()))
{
var avaLine = AbstractTypeFactory <AvaLineItem> .TryCreateInstance();
avaLine.FromTaxLine(taxLine);
lines.Add(avaLine);
}
}
if (context.Address != null)
{
var avaAddress = AbstractTypeFactory <AvaAddressLocationInfo> .TryCreateInstance();
avaAddress.FromAddress(context.Address);
addresses = new AddressesModel
{
// TODO: set actual origin address (fulfillment center/store owner)?
shipFrom = avaAddress,
shipTo = avaAddress
};
}
return(this);
}
public async Task GetUnusedAddressesInAccountWhenNoAddressesNeedToBeCreated()
{
using (NodeBuilder builder = NodeBuilder.Create(this))
{
// Arrange.
CoreNode node = builder.CreateStratisPosNode(this.network).Start();
this.AddAndLoadWalletFileToWalletFolder(node);
AddressesModel addressesModel = await $"http://localhost:{node.ApiPort}/api"
.AppendPathSegment("wallet/addresses")
.SetQueryParams(new { walletName = this.walletWithFundsName, accountName = "account 0" })
.GetJsonAsync <AddressesModel>();
int totalAddressesCount = addressesModel.Addresses.Count();
int unusedReceiveAddressesCount = addressesModel.Addresses.Count(a => !a.IsUsed && !a.IsChange);
// Act.
IEnumerable <string> unusedaddresses = await $"http://localhost:{node.ApiPort}/api"
.AppendPathSegment("wallet/unusedAddresses")
.SetQueryParams(new { walletName = this.walletWithFundsName, accountName = "account 0", count = unusedReceiveAddressesCount - 1 })
.GetJsonAsync <IEnumerable <string> >();
// Assert.
AddressesModel addressesModelAgain = await $"http://localhost:{node.ApiPort}/api"
.AppendPathSegment("wallet/addresses")
.SetQueryParams(new { walletName = this.walletWithFundsName, accountName = "account 0" })
.GetJsonAsync <AddressesModel>();
addressesModelAgain.Addresses.Count().Should().Be(totalAddressesCount);
}
}
//public EventsController()
//{
// var m_addressesDataSource = new EventsDataSource();
//}
public ActionResult Index()
{
var addresses = m_addressesDataSource.GetAllAddresses();
var addressesModel = new AddressesModel();
addressesModel.Addresses = addresses.ToArray();
return(View(addressesModel));
}
public async Task <PersonsModel> EditPersonAddressAsync(int personId, AddressesModel address, int addressId)
{
var oldmodel = await _context.Addresses
.FirstOrDefaultAsync(e => e.PersonId == personId && e.AddressId == addressId);
var result = Mapping.Mapper.Map(address, oldmodel);
await _context.SaveChangesAsync();
var personModel = await GetPersonModel(personId);
return(personModel);
}
public void Update(AddressesModel a)
{
AddressId = a.AddressId;
Address1 = a.Address1;
Address2 = a.Address2;
Address3 = a.Address3;
Address4 = a.Address4;
Address5 = a.Address5;
City = a.City;
Region = a.Region;
PostCode = a.PostCode;
International = a.International;
}
public IHttpActionResult PostAddress(AddressesModel address)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var add = new Address(address);
db.Addresses.Add(add);
db.SaveChanges();
address.AddressId = add.AddressId;
return(CreatedAtRoute("DefaultApi", new { id = address.AddressId }, address));
}
public virtual AvaCreateTransactionModel FromOrder(CustomerOrder order, string requiredCompanyCode, Address sourceAddress)
{
code = order.Number;
customerCode = order.CustomerId;
date = order.CreatedDate;
type = DocumentType.SalesInvoice;
currencyCode = order.Currency;
companyCode = requiredCompanyCode;
var shippingAddress = order.Addresses.FirstOrDefault(x => x.AddressType == AddressType.Shipping);
if (shippingAddress != null && sourceAddress != null)
{
var avaSourceAddress = AbstractTypeFactory <AvaAddressLocationInfo> .TryCreateInstance();
avaSourceAddress.FromAddress(sourceAddress);
var avaShippingAddress = AbstractTypeFactory <AvaAddressLocationInfo> .TryCreateInstance();
avaShippingAddress.FromAddress(shippingAddress);
addresses = new AddressesModel
{
shipFrom = avaSourceAddress,
shipTo = avaShippingAddress
};
}
lines = new List <LineItemModel>();
foreach (var orderLine in order.Items.Where(x => !x.IsTransient()))
{
var avaTaxLine = AbstractTypeFactory <AvaLineItem> .TryCreateInstance();
avaTaxLine.FromOrderLine(orderLine);
lines.Add(avaTaxLine);
}
foreach (var shipment in order.Shipments ?? Enumerable.Empty <Shipment>())
{
var avaTaxLine = AbstractTypeFactory <AvaLineItem> .TryCreateInstance();
avaTaxLine.FromOrderShipment(shipment);
lines.Add(avaTaxLine);
}
return(this);
}
public IHttpActionResult PutAddress(int id, AddressesModel address)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != address.AddressId)
{
return(BadRequest());
}
//grab entry from db
var dbAddress = db.Addresses.Find(id);
//save entry fetched
dbAddress.Update(address);
//mark entry as modified
db.Entry(dbAddress).State = EntityState.Modified;
//save changes
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!AddressExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public Address(AddressesModel model)
{
this.Update(model);
}
public async Task <ActionResult <PersonsModel> > EditPersonAddressAsync(int personId, AddressesModel address, int addressId)
{
var model = await _personService.EditPersonAddressAsync(personId, address, addressId);
var location = _linkGanarator.GetPathByAction("GetPersonByIdAsync", "Persons", new { personId = model.PersonId });
return(model);
}
public ActionResult Contact()
{
var model = new AddressesModel()
{
AddressDictionary = new Dictionary <int, List <Address> >()
{
{
2017, new List <Address>()
{
new Address()
{
Id = Guid.NewGuid(),
Date = 2017,
Latitude = 56.838219,
Longitude = 60.611162
},
new Address()
{
Id = Guid.NewGuid(),
Date = 2017,
Latitude = 56.838694,
Longitude = 60.610303
},
new Address()
{
Id = Guid.NewGuid(),
Date = 2017,
Latitude = 56.838503,
Longitude = 60.612221
},
new Address()
{
Id = Guid.NewGuid(),
Date = 2017,
Latitude = 56.837500,
Longitude = 60.613203
}
}
},
{
2018, new List <Address>()
{
new Address()
{
Id = Guid.NewGuid(),
Date = 2018,
Latitude = 56.839789,
Longitude = 60.612187
},
new Address()
{
Id = Guid.NewGuid(),
Date = 2018,
Latitude = 56.839657,
Longitude = 60.610701
},
new Address()
{
Id = Guid.NewGuid(),
Date = 2018,
Latitude = 56.840168,
Longitude = 60.610642
}
}
},
}
};
return(View(model));
}
/// <summary>
/// 增加一条数据mo
/// </summary>
public bool Add(AddressesModel model, string connectionStr, out string errorMsg)
{
errorMsg = string.Empty;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Tuhu_profiles.dbo.Addresses(");
strSql.Append("u_address_id,i_address_type,u_address_name,u_first_name,u_last_name,u_description,u_address_line1,u_address_line2,u_city,u_region_code,u_region_name,u_postal_code,u_country_code,u_country_name,u_tel_number,u_tel_extension,i_locale,u_user_id_changed_by,dt_date_last_changed,dt_csadapter_date_last_changed,dt_date_created)");
strSql.Append(" values (");
strSql.Append("@u_address_id,@i_address_type,@u_address_name,@u_first_name,@u_last_name,@u_description,@u_address_line1,@u_address_line2,@u_city,@u_region_code,@u_region_name,@u_postal_code,@u_country_code,@u_country_name,@u_tel_number,@u_tel_extension,@i_locale,@u_user_id_changed_by,@dt_date_last_changed,@dt_csadapter_date_last_changed,@dt_date_created)");
SqlParameter[] parameters =
{
new SqlParameter("@u_address_id", SqlDbType.NVarChar, 50),
new SqlParameter("@i_address_type", SqlDbType.Int, 4),
new SqlParameter("@u_address_name", SqlDbType.NVarChar, 50),
new SqlParameter("@u_first_name", SqlDbType.NVarChar, 64),
new SqlParameter("@u_last_name", SqlDbType.NVarChar, 64),
new SqlParameter("@u_description", SqlDbType.NVarChar, 50),
new SqlParameter("@u_address_line1", SqlDbType.NVarChar, 80),
new SqlParameter("@u_address_line2", SqlDbType.NVarChar, 80),
new SqlParameter("@u_city", SqlDbType.NVarChar, 64),
new SqlParameter("@u_region_code", SqlDbType.NVarChar, 50),
new SqlParameter("@u_region_name", SqlDbType.NVarChar, 64),
new SqlParameter("@u_postal_code", SqlDbType.NVarChar, 20),
new SqlParameter("@u_country_code", SqlDbType.NVarChar, 50),
new SqlParameter("@u_country_name", SqlDbType.NVarChar, 50),
new SqlParameter("@u_tel_number", SqlDbType.NVarChar, 32),
new SqlParameter("@u_tel_extension", SqlDbType.NVarChar, 50),
new SqlParameter("@i_locale", SqlDbType.Int, 4),
new SqlParameter("@u_user_id_changed_by", SqlDbType.NVarChar, 50),
new SqlParameter("@dt_date_last_changed", SqlDbType.DateTime),
new SqlParameter("@dt_csadapter_date_last_changed", SqlDbType.DateTime),
new SqlParameter("@dt_date_created", SqlDbType.DateTime)
};
parameters[0].Value = model.u_address_id;
parameters[1].Value = model.i_address_type;
parameters[2].Value = model.u_address_name;
parameters[3].Value = model.u_first_name;
parameters[4].Value = model.u_last_name;
parameters[5].Value = model.u_description;
parameters[6].Value = model.u_address_line1;
parameters[7].Value = model.u_address_line2;
parameters[8].Value = model.u_city;
parameters[9].Value = model.u_region_code;
parameters[10].Value = model.u_region_name;
parameters[11].Value = model.u_postal_code;
parameters[12].Value = model.u_country_code;
parameters[13].Value = model.u_country_name;
parameters[14].Value = model.u_tel_number;
parameters[15].Value = model.u_tel_extension;
parameters[16].Value = model.i_locale;
parameters[17].Value = model.u_user_id_changed_by;
parameters[18].Value = model.dt_date_last_changed;
parameters[19].Value = model.dt_csadapter_date_last_changed;
parameters[20].Value = model.dt_date_created;
int rows = SqlHelper.ExecuteNonQuery(connectionStr, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
errorMsg = string.Format("类:DalCrmAddress,方法：Add,错误信息:{0}", ex.ToString());
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(AddressesModel model, string connectionStr, string strWhere, out string errorMsg)
{
errorMsg = string.Empty;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Tuhu_profiles.dbo.Addresses WITH(rowlock) set ");
//strSql.Append("u_address_id=@u_address_id,");
strSql.Append("i_address_type=@i_address_type,");
strSql.Append("u_address_name=@u_address_name,");
strSql.Append("u_first_name=@u_first_name,");
strSql.Append("u_last_name=@u_last_name,");
strSql.Append("u_description=@u_description,");
strSql.Append("u_address_line1=@u_address_line1,");
strSql.Append("u_address_line2=@u_address_line2,");
strSql.Append("u_city=@u_city,");
strSql.Append("u_region_code=@u_region_code,");
strSql.Append("u_region_name=@u_region_name,");
strSql.Append("u_postal_code=@u_postal_code,");
strSql.Append("u_country_code=@u_country_code,");
strSql.Append("u_country_name=@u_country_name,");
strSql.Append("u_tel_number=@u_tel_number,");
strSql.Append("u_tel_extension=@u_tel_extension,");
strSql.Append("i_locale=@i_locale,");
//strSql.Append("u_user_id_changed_by=@u_user_id_changed_by,");
strSql.Append("dt_date_last_changed=@dt_date_last_changed,");
strSql.Append("dt_csadapter_date_last_changed=@dt_csadapter_date_last_changed,");
strSql.Append("dt_date_created=@dt_date_created");
strSql.Append(" where u_address_id=@u_address_id ");
if (!string.IsNullOrEmpty(strWhere))
{
strSql.Append(" and " + strWhere);
}
SqlParameter[] parameters =
{
new SqlParameter("@u_address_id", SqlDbType.NVarChar, 50),
new SqlParameter("@i_address_type", SqlDbType.Int, 4),
new SqlParameter("@u_address_name", SqlDbType.NVarChar, 50),
new SqlParameter("@u_first_name", SqlDbType.NVarChar, 64),
new SqlParameter("@u_last_name", SqlDbType.NVarChar, 64),
new SqlParameter("@u_description", SqlDbType.NVarChar, 50),
new SqlParameter("@u_address_line1", SqlDbType.NVarChar, 80),
new SqlParameter("@u_address_line2", SqlDbType.NVarChar, 80),
new SqlParameter("@u_city", SqlDbType.NVarChar, 64),
new SqlParameter("@u_region_code", SqlDbType.NVarChar, 50),
new SqlParameter("@u_region_name", SqlDbType.NVarChar, 64),
new SqlParameter("@u_postal_code", SqlDbType.NVarChar, 20),
new SqlParameter("@u_country_code", SqlDbType.NVarChar, 50),
new SqlParameter("@u_country_name", SqlDbType.NVarChar, 50),
new SqlParameter("@u_tel_number", SqlDbType.NVarChar, 32),
new SqlParameter("@u_tel_extension", SqlDbType.NVarChar, 50),
new SqlParameter("@i_locale", SqlDbType.Int, 4),
//new SqlParameter("@u_user_id_changed_by", SqlDbType.NVarChar,50),
new SqlParameter("@dt_date_last_changed", SqlDbType.DateTime),
new SqlParameter("@dt_csadapter_date_last_changed", SqlDbType.DateTime),
new SqlParameter("@dt_date_created", SqlDbType.DateTime)
};
parameters[0].Value = model.u_address_id;
parameters[1].Value = model.i_address_type;
parameters[2].Value = model.u_address_name;
parameters[3].Value = model.u_first_name;
parameters[4].Value = model.u_last_name;
parameters[5].Value = model.u_description;
parameters[6].Value = model.u_address_line1;
parameters[7].Value = model.u_address_line2;
parameters[8].Value = model.u_city;
parameters[9].Value = model.u_region_code;
parameters[10].Value = model.u_region_name;
parameters[11].Value = model.u_postal_code;
parameters[12].Value = model.u_country_code;
parameters[13].Value = model.u_country_name;
parameters[14].Value = model.u_tel_number;
parameters[15].Value = model.u_tel_extension;
parameters[16].Value = model.i_locale;
//parameters[17].Value = model.u_user_id_changed_by;
parameters[17].Value = model.dt_date_last_changed;
parameters[18].Value = model.dt_csadapter_date_last_changed;
parameters[19].Value = model.dt_date_created;
int rows = SqlHelper.ExecuteNonQuery(connectionStr, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
errorMsg = string.Format("类:DalCrmAddress,方法：Update,错误信息:{0}", ex.ToString());
return(false);
}
}
