public void Create(ShopAddress shopAddress)
{
try
{
if (shopAddress == null)
{
throw new ArgumentNullException();
}
if (String.IsNullOrEmpty(shopAddress.Name) || String.IsNullOrEmpty(shopAddress.Street) ||
String.IsNullOrEmpty(shopAddress.City) || String.IsNullOrEmpty(shopAddress.State))
{
throw new ArgumentException();
}
if (shopAddress.Number < 0)
{
throw new ArgumentOutOfRangeException();
}
_shopAddressRepository.Create(shopAddress);
_logger.CreateLog("Database", "Insert", "ShopAddress", new string[] { shopAddress.Name, shopAddress.Street, shopAddress.Number.ToString(), shopAddress.State });
}
catch (Exception ex)
{
_logger.CreateLog("Error", ex.ToString());
throw ex;
}
}
public ShopAddress Read(string name)
{
string query = "select * from shopAddress where name_shop = @P0";
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("P0", name));
SqlDataReader reader = cmd.ExecuteReader();
ShopAddress shopAddress = new ShopAddress();
if (reader.Read())
{
shopAddress.Id = Convert.ToInt32(reader["id_shop"]);
shopAddress.Name = Convert.ToString(reader["name_shop"]);
shopAddress.Street = Convert.ToString(reader["street_shop"]);
shopAddress.Number = Convert.ToInt32(reader["number_shop"]);
shopAddress.City = Convert.ToString(reader["city_shop"]);
shopAddress.State = Convert.ToString(reader["state_shop"]);
}
return(shopAddress);
}
}
}
public void ReadShopAddressTest()
{
string name = _name;
var shopAddress = new ShopAddress()
{
Id = _id,
Name = _name,
Street = _street,
Number = _number,
City = _city,
State = _state
};
_logger.Setup(x => x.CreateLog("Database", "Read", "ShopAddress", new string[] { shopAddress.Id.ToString(), shopAddress.Name, shopAddress.Street, shopAddress.Number.ToString(), shopAddress.State }));
_shopAddressRepository.Setup(x => x.Read(name)).Returns(shopAddress);
var instance = GetInstance();
var result = instance.Read(name);
Assert.NotNull(result);
_logger.Verify();
_shopAddressRepository.Verify();
}
public void CreateShopAddressNullTest()
{
ShopAddress shopAddress = null;
_logger.Setup(x => x.CreateLog("Error", "Exception Message"));
var instance = GetInstance();
Assert.Throws <ArgumentNullException>(() => instance.Create(shopAddress));
_logger.Verify();
}
public async Task <CreateShopCommandResponse> Handle(CreateShopCommand command)
{
var shopNumber = _seqRepository.GetNextSequenceValue(SqNames.ShopNumberSequence);
var marketer = await _marketerRepository.AsQuery().SingleOrDefaultAsync(p => p.BarcodeId == command.BarcodeId);
if (marketer == null)
{
throw new DomainException("بازاریاب یافت نشد");
}
_marketerDomainService.CheckMarketerActive(marketer);
_marketerDomainService.CheckMaxMarketerAllowedIsEnough(marketer);
_personDomainService.CheckShopIsExist(command.UserId);
var city = _cityRepository.Find(command.Address.CityId);
if (city == null)
{
throw new DomainException("شهر وارد شده یافت نشد");
}
var appSetting = await _applicationSettingRepository.AsQuery().SingleOrDefaultAsync();
if (appSetting == null)
{
throw new DomainException("تنظیمات برنامه یافت نشد");
}
if (command.DefaultDiscount < appSetting.MinimumDiscount || command.DefaultDiscount > appSetting.MaximumDiscount)
{
throw new DomainException("تخفیف پیش فرض در بازه تخفیفات معتبر نمی باشد");
}
var address = new ShopAddress(city.Id, city.Code, city.CityName, command.Address.AddressText,
command.Address.PhoneNumber, command.Address.Position.ToDbGeography(),
command.Address.ShopMobileNumber, command.Address.ZoneId,
city.Province.Id, city.Province.Code, city.Province.Name);
var accountBank = new BankAccount(command.BankAccount.Iban, command.BankAccount.AccountOwnerName, command.BankAccount.AccountNumber);
var imageDocument = new ImageDocuments(command.ImageDocuments.FaceImage, command.ImageDocuments.NationalCardImage);
var shop = new Shop(Guid.NewGuid(), command.Name, command.FirstName, command.LastName, command.EmailAddress,
command.UserId, command.Description, command.NationalCode, address, accountBank, imageDocument,
command.MobileNumber, command.AreaRadius, command.Metrage, command.DefaultDiscount, marketer.Id, shopNumber)
{
AppInfos = new List <AppInfo>(),
CustomerSubsets = new List <ShopCustomerSubset>()
};
_repository.Add(shop);
DomainEventDispatcher.Raise(new AssignmentShopMarketersHistoryEvent(shop, marketer,
new UserInfo(command.UserId, command.MobileNumber, "کاربر موبایل")));
DomainEventDispatcher.Raise(new AddPanelNotificationEvent(Guid.NewGuid(), command.Name, "فروشگاه ایجاد شد",
PanelNotificationType.ShopCreated, shop.Id.ToString()));
return(new CreateShopCommandResponse());
}
public void DeleteShopAddressIdLessThanZeroTest()
{
ShopAddress shopAddress = new ShopAddress()
{
Id = -1
};
_logger.Setup(x => x.CreateLog("Error", "Exception Message"));
var instance = GetInstance();
Assert.Throws <ArgumentOutOfRangeException>(() => instance.Delete(shopAddress));
_logger.Verify();
}
public void Delete(ShopAddress shopAddress)
{
string query = "delete from shopAddress where id_shop = @P0";
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("P0", shopAddress.Id));
cmd.ExecuteNonQuery();
}
}
}
public void UpdateShopAddressNumberLessThanZeroTest()
{
ShopAddress shopAddress = new ShopAddress()
{
Name = _name,
Street = _street,
City = _city,
State = _state,
Number = -1
};
_logger.Setup(x => x.CreateLog("Error", "Exception Message"));
var instance = GetInstance();
Assert.Throws <ArgumentOutOfRangeException>(() => instance.Update(shopAddress));
_logger.Verify();
}
private void FillBillingFields(Order order)
{
ShopAddress address = new ShopAddress();
txtEmail.Text = order.Email;
address.Address = order.BillingAddress;
address.Address2 = order.BillingAddress2;
address.City = order.BillingCity;
address.ForeName = order.BillingForename;
address.SurName = order.BillingSurname;
address.ZipCode = order.BillingZip;
address.State = order.BillingState;
address.Mobile = order.BillingMobile;
address.Company = order.BillingCompany;
//if (WAFContext.Session.IsAnonymous()) {
// txtEmail.Text = order.Email;
// address.Address = order.BillingAddress;
// address.Address2 = order.BillingAddress2;
// address.City = order.BillingCity;
// address.ForeName = order.BillingForename;
// address.SurName = order.BillingSurname;
// address.ZipCode = order.BillingZip;
// address.State = order.BillingState;
// address.Mobile = order.BillingMobile;
// address.Company = order.BillingCompany;
//} else {
// SystemUser user = WAFContext.Session.GetUser();
// txtEmail.Text = user.Email;
// address.Address = user.Street;
// address.Address2 = order.BillingAddress2;
// address.City = user.City;
// address.Mobile = user.Mobile;
// address.ForeName = user.Forename;
// address.SurName = user.Surname;
// address.ZipCode = user.PostZipCode;
// //address.State = ;
// address.Company = user.Company;
//}
if(order.BillingCountry.IsSet()) {
address.CountryCode = order.BillingCountry.Get().CountryCode;
}
BillingAddress1.ShopAddress = address;
}
public void CreateShopAddressNameEmptyTest()
{
ShopAddress shopAddress = new ShopAddress()
{
Name = "",
Street = _street,
City = _city,
State = _state,
Number = _number
};
_logger.Setup(x => x.CreateLog("Error", "Exception Message"));
var instance = GetInstance();
Assert.Throws <ArgumentException>(() => instance.Create(shopAddress));
_logger.Verify();
}
public Shop(Guid id, string name, string firstName, string lastName, string emailAddress,
Guid userId, string description, string nationalCode, ShopAddress address, BankAccount bankAccount,
ImageDocuments imageDocuments, string mobileNumber, int areaRadius, int metrage,
int defaultDiscount, long marketerId, long personNumber)
: base(id, firstName, lastName, emailAddress, userId, mobileNumber, personNumber)
{
Name = name;
ShopStatus = ShopStatus.Pending;
Description = description;
NationalCode = nationalCode;
ShopAddress = address;
BankAccount = bankAccount;
CreationTime = DateTime.Now;
ImageDocuments = imageDocuments;
AreaRadius = areaRadius;
Metrage = metrage;
DefaultDiscount = defaultDiscount;
MarketerId = marketerId;
RecommendCode = personNumber;
}
public void UpdateShopAddressTest()
{
ShopAddress shopAddress = new ShopAddress()
{
Name = _name,
Street = _street,
City = _city,
State = _state,
Number = _number
};
_logger.Setup(X => X.CreateLog("Database", "Insert", "ShopAddress", new string[] { shopAddress.Name, shopAddress.Street, shopAddress.Number.ToString(), shopAddress.State }));
_shopAddressRepository.Setup(x => x.Update(shopAddress));
var instance = GetInstance();
instance.Update(shopAddress);
_logger.Verify();
_shopAddressRepository.Verify();
}
public void Create(ShopAddress shopAddress)
{
string query = "insert into shopAddress values(@P0, @P1, @P2, @P3, @P4)";
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("P0", shopAddress.Name));
cmd.Parameters.Add(new SqlParameter("P1", shopAddress.Street));
cmd.Parameters.Add(new SqlParameter("P2", shopAddress.Number));
cmd.Parameters.Add(new SqlParameter("P3", shopAddress.City));
cmd.Parameters.Add(new SqlParameter("P4", shopAddress.State));
cmd.ExecuteNonQuery();
}
}
}
public void Delete(ShopAddress shopAddress)
{
try
{
if (shopAddress == null)
{
throw new ArgumentNullException();
}
if (shopAddress.Id < 0)
{
throw new ArgumentOutOfRangeException();
}
_shopAddressRepository.Delete(shopAddress);
_logger.CreateLog("Database", "Delete", "ShopAddress", new string[] { shopAddress.Id.ToString(), shopAddress.Name, shopAddress.Street, shopAddress.Number.ToString(), shopAddress.State });
}
catch (Exception ex)
{
_logger.CreateLog("Error", ex.ToString());
throw ex;
}
}
public void Update(ShopAddress shopAddress)
{
string query = "update shopAddress set name_shop = @P0, street_shop = @P1, number_shop = @P2, city_shop = @P3," +
"state_shop = @P4 where id_shop = @P5";
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("P0", shopAddress.Name));
cmd.Parameters.Add(new SqlParameter("P1", shopAddress.Street));
cmd.Parameters.Add(new SqlParameter("P2", shopAddress.Number));
cmd.Parameters.Add(new SqlParameter("P3", shopAddress.City));
cmd.Parameters.Add(new SqlParameter("P4", shopAddress.State));
cmd.Parameters.Add(new SqlParameter("P5", shopAddress.Id));
cmd.ExecuteNonQuery();
}
}
}
/// <summary>
/// 新增数据
/// </summary>
/// <param name="model">实体类</param>
/// <returns></returns>
public bool Insert(ShopAddress model)
{
return(CreateDao().Insert(model));
}
/// <summary>
/// 新增数据，并返回自增ID
/// </summary>
/// <param name="model">实体类</param>
/// <returns></returns>
public int InsertIdentity(ShopAddress model)
{
return(CreateDao().InsertIdentity(model));
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="model">实体类</param>
/// <param name="whereString">可选，更新条件</param>
/// <returns></returns>
public bool Update(ShopAddress model, string whereString = null)
{
return(CreateDao().Update(model, whereString));
}
public void Update(ShopAddress shopAddress)
{
_shopAddressService.Update(shopAddress);
}
public override string ToString()
{
return($"Order Location: {ShopAddress.ToString()} - Shop# {ShopID}");
}
private void FillShippingFields(Order order)
{
ShopAddress address = new ShopAddress();
address.Address = order.ShippingAddress;
address.Address2 = order.ShippingAddress2;
address.City = order.ShippingCity;
address.ForeName = order.ShippingForename;
address.SurName = order.ShippingSurname;
address.ZipCode = order.ShippingZip;
address.State = order.ShippingState;
address.Mobile = order.ShippingMobile;
if(order.ShippingCountry.IsSet()) {
address.CountryCode = order.ShippingCountry.Get().CountryCode;
}
address.Company = order.BillingCompany;
ShippingAddress1.ShopAddress = address;
}
private void SaveShippingFields(Order order, ShopAddress address)
{
order.ShippingForename = address.ForeName;
order.ShippingSurname = address.SurName;
if (address.CountryCode != null) {
Country c = WAFShopHelper.GetCountryFromCode(address.CountryCode);
if (c != null) {
order.ShippingCountry.Set(c);
}
}
order.ShippingAddress = address.Address;
order.ShippingAddress2 = address.Address2;
order.ShippingCity = address.City;
order.ShippingCompany = address.Company;
order.ShippingZip = address.ZipCode;
order.ShippingMobile = address.Mobile;
}
public void Create(ShopAddress shopAddress)
{
_shopAddressService.Create(shopAddress);
}
public static IShopAddressDto ToDto(this ShopAddress src)
{
return(Mapper.Map <IShopAddressDto>(src));
}
public void Delete(ShopAddress shopAddress)
{
_shopAddressService.Delete(shopAddress);
}
