public ActionResult InsertAddress()
{
try
{
AddressInfoModel addressInfoModel = new AddressInfoModel();
using (var context = new JustHallAtumationEntities())
{
var user = context.Users.Where(x => x.UserName == User.Identity.Name).FirstOrDefault();
var std = context.Students.Where(x => x.UserId == user.UserId).FirstOrDefault();
if (std == null) // If student information doesn't given
{
return(RedirectToAction("InsertStudentInfo", "InsertInformation"));
}
var dep = context.DepartmentInfoes.Where(x => x.StudentId == std.StudentId).FirstOrDefault();
if (dep == null) /// DepartMent Info doesn't given go insertDepartment info function.
{
RedirectToAction("InsertUserDepartmentInfo", "InsertInformation");
}
var add = context.Addresses.Where(x => x.StudentId == std.StudentId).FirstOrDefault();
if (add != null) /// Go to Profile bcs already given the Address information.
{
return(RedirectToAction("Contact", "Home"));
}
addressInfoModel.districts = context.Districts.ToList();
}
return(View(addressInfoModel));
}
catch (Exception ex)
{
return(View(ex));
}
}
public async Task <IActionResult> AddAddress([FromBody] AddressInfoModel model)
{
var address = this._mapper.Map <Address>(model);
var added = await this._addressService.CreateUserAddressAsync(address, User.Identity.Name);
return(Ok(new { message = $"Address with ID:{added.Id} was added to user: ${User.Identity.Name}", id = added.Id }));
}
public async Task <IHttpActionResult> SetAddressInfo([FromBody] AddressInfoModel addressInfo)
{
using (ApplicationDbContext usersDbContext = new ApplicationDbContext())
{
string userId = this.User.Identity.GetUserId();
Address userAddress = await usersDbContext.AddressInfos.FirstOrDefaultAsync(a => a.UserId == userId);
if (userAddress == null)
{
userAddress = new Address();
userAddress.UserId = userId;
usersDbContext.AddressInfos.Add(userAddress);
}
userAddress.FirstName = addressInfo.FirstName;
userAddress.MiddleName = addressInfo.MiddleName;
userAddress.LastName = addressInfo.LastName;
userAddress.Email = addressInfo.Email;
userAddress.Phone = addressInfo.Phone;
userAddress.Country = addressInfo.Country;
userAddress.District = addressInfo.District;
userAddress.Commune = addressInfo.Commune;
userAddress.City = addressInfo.City;
userAddress.PostCode = addressInfo.PostCode;
userAddress.AddresDetails = addressInfo.Address;
await usersDbContext.SaveChangesAsync();
}
return(this.Ok());
}
public ResponseMessageData <AddressInfoModel> SaveAddress(AddressInfoModel model)
{
using (_repository)
{
if (model.IsMap)
{
model.AddressId = _repository.SaveAddressMap(model, model.AddressId == null || model.AddressId == SharedConstants.NULL_ID_VALUE);
}
else
{
if (model.ZipCode == null || model.ZipCode.IdKey == null || model.ZipCode.IdKey <= 0)
{
var lastRegion = SettingsData.LastRegion;
model.ZipCode = FactoryAddress.GetQueryToGetByZipCodeId(_repository.InnerDbEntities, lastRegion, model);
}
model.AddressId = _repository.SaveAddress(model, model.AddressId == null || model.AddressId == SharedConstants.NULL_ID_VALUE);
}
return(new ResponseMessageData <AddressInfoModel>
{
Data = model,
IsSuccess = true,
Message = String.Empty
});
}
}
public async Task <IHttpActionResult> GetAddressInfo()
{
AddressInfoModel addressInfo = new AddressInfoModel();
string userId = this.User.Identity.GetUserId();
using (ApplicationDbContext usersDbContext = new ApplicationDbContext())
{
Address userAddress = await usersDbContext.AddressInfos.FirstOrDefaultAsync(a => a.UserId == userId);
if (userAddress != null)
{
addressInfo.FirstName = userAddress.FirstName;
addressInfo.MiddleName = userAddress.MiddleName;
addressInfo.LastName = userAddress.LastName;
addressInfo.Email = userAddress.Email;
addressInfo.Phone = userAddress.Phone;
addressInfo.Country = userAddress.Country;
addressInfo.District = userAddress.District;
addressInfo.Commune = userAddress.Commune;
addressInfo.City = userAddress.City;
addressInfo.PostCode = userAddress.PostCode;
addressInfo.Address = userAddress.AddresDetails;
}
else
{
ApplicationUser currentUser = usersDbContext.Users.First(u => u.Id == userId);
addressInfo.FirstName = currentUser.FirstName;
addressInfo.LastName = currentUser.LastName;
addressInfo.Email = currentUser.Email;
addressInfo.Country = "България"; //TODO: add countries nomenclature
}
}
return(this.Ok(addressInfo));
}
public ActionResult UpdateAddressInfo(int?id) // Student Id
{
try
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AddressInfoModel addressInfoModel = new AddressInfoModel();
addressInfoModel.StudentId = (int)id;
using (var context = new JustHallAtumationEntities())
{
var address = context.Addresses.Where(x => x.StudentId == (int)id).FirstOrDefault();
addressInfoModel.P_PostOffice = address.P_PostOffice;
addressInfoModel.P_VillageName = address.P_VillageName;
addressInfoModel.T_PostOffice = address.T_PostOffice;
addressInfoModel.T_VillageName = address.T_VillageName;
addressInfoModel.districts = context.Districts.ToList();
}
return(View(addressInfoModel));
}
catch (Exception ex)
{
return(View(ex));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(AddressInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CORE.dbo.AddressInfo (");
strSql.Append("SiteId,Attach,LastTime,TownId,Memo,OrderNo,Tel,ContactName,Invalid,MemberId,IsDefault");
strSql.Append(") values (");
strSql.Append("@SiteId,@Attach,@LastTime,@TownId,@Memo,@OrderNo,@Tel,@ContactName,@Invalid,@MemberId,@IsDefault");
strSql.Append(") ");
strSql.Append(";");
SqlParameter[] parameters =
{
new SqlParameter("@SiteId", SqlDbType.Decimal, 9),
new SqlParameter("@Attach", SqlDbType.VarChar, 200),
new SqlParameter("@LastTime", SqlDbType.DateTime),
new SqlParameter("@TownId", SqlDbType.Decimal, 9),
new SqlParameter("@Memo", SqlDbType.VarChar, 1000),
new SqlParameter("@OrderNo", SqlDbType.Int, 4),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@ContactName", SqlDbType.VarChar, 20),
new SqlParameter("@Invalid", SqlDbType.Bit, 1),
new SqlParameter("@MemberId", SqlDbType.Decimal, 9),
new SqlParameter("@IsDefault", SqlDbType.Bit, 1)
};
parameters[0].Value = model.SiteId;
parameters[1].Value = model.Attach;
parameters[2].Value = model.LastTime;
parameters[3].Value = model.TownId;
parameters[4].Value = model.Memo;
parameters[5].Value = model.OrderNo;
parameters[6].Value = model.Tel;
parameters[7].Value = model.ContactName;
parameters[8].Value = model.Invalid;
parameters[9].Value = model.MemberId;
parameters[10].Value = model.IsDefault;
bool result = false;
try
{
model.AddressId = decimal.Parse(helper.ExecuteNonQueryBackId(strSql.ToString(), "AddressId", parameters));
result = true;
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
finally
{
}
return(result);
}
public long SaveAddress(AddressInfoModel model, bool bIsNew)
{
var address = bIsNew ? new Entities.Address() : DbEntities.Address.Single(e => e.AddressId == model.AddressId);
var phoneToAdd = new ClientPhone {
ClientPhoneId = model.PrimaryPhone.PhoneId
};
DbEntities.ClientPhone.Attach(phoneToAdd);
for (var i = address.ClientPhone.Count - 1; i >= 0; i--)
{
var phone = address.ClientPhone.ElementAt(i);
address.ClientPhone.Remove(phone);
}
address.ClientPhone.Add(phoneToAdd);
if (model.Country != null && model.Country.IdKey != null)
{
address.CountryId = (int)model.Country.IdKey.Value;
}
if (model.RegionA != null && model.RegionA.IdKey != null)
{
address.RegionArId = (int)model.RegionA.IdKey.Value;
}
if (model.RegionB != null && model.RegionB.IdKey != null)
{
address.RegionBrId = (int)model.RegionB.IdKey.Value;
}
if (model.RegionC != null && model.RegionC.IdKey != null)
{
address.RegionCrId = (int)model.RegionC.IdKey.Value;
}
if (model.RegionD != null && model.RegionD.IdKey != null)
{
address.RegionDrId = (int)model.RegionD.IdKey.Value;
}
address.ExtIntNumber = model.ExtIntNumber;
address.MainAddress = model.MainAddress;
address.Reference = model.Reference;
if (model.ZipCode.IdKey != null)
{
address.ZipCodeId = (int)model.ZipCode.IdKey.Value;
}
address.IsMap = false;
if (bIsNew)
{
DbEntities.Address.Add(address);
}
DbEntities.SaveChanges();
return(address.AddressId);
}
public ResponseMessageData <AddressInfoModel> SaveClient(AddressInfoModel model)
{
try
{
return(AppInit.Container.Resolve <IAddressService>().SaveAddress(model));
}
catch (Exception ex)
{
SharedLogger.LogError(ex);
return(ResponseMessageData <AddressInfoModel> .CreateCriticalMessage("No fue posible guardar el cliente"));
}
}
/// <summary>
/// 添加或编辑常用地址
/// </summary>
/// <param name="addressinfo">地址信息</param>
/// <returns></returns>
internal static ReplayBase EditAddress(AddressInfoModel addressinfo)
{
using (SysTemDataBaseDataContext context = new SysTemDataBaseDataContext(SqlConnection))
{
string NewAddressId = Guid.NewGuid().ToString();
if (string.IsNullOrEmpty(addressinfo.id))
{
//新增
Us_RsAddress dbaddress = new Us_RsAddress()
{
modifiedOn = DateTime.Now,
Us_RsAddressId = NewAddressId,
address = addressinfo.address,
cityId = addressinfo.locationInfo.cityInfo.CityCode,
districtId = addressinfo.locationInfo.DistrictId,
linkMan = addressinfo.linkMan,
linkPhone = addressinfo.linkPhone,
postCode = addressinfo.postCode,
isDefault = addressinfo.isDefault,
fkId = addressinfo.fkId,
};
context.Us_RsAddress.InsertOnSubmit(dbaddress);
}
else
{
//编辑
NewAddressId = addressinfo.id;
Us_RsAddress dbaddress = context.Us_RsAddress.Single(p => p.Us_RsAddressId == addressinfo.id);
dbaddress.modifiedOn = DateTime.Now;
dbaddress.address = addressinfo.address;
dbaddress.cityId = addressinfo.locationInfo.cityInfo.CityCode;
dbaddress.districtId = addressinfo.locationInfo.DistrictId;
dbaddress.linkMan = addressinfo.linkMan;
dbaddress.linkPhone = addressinfo.linkPhone;
dbaddress.postCode = addressinfo.postCode;
dbaddress.isDefault = addressinfo.isDefault;
dbaddress.fkId = addressinfo.fkId;
}
context.SubmitChanges();
return(new ReplayBase()
{
ReturnMessage = NewAddressId
});
}
}
/// <summary>
/// 删除常用地址（物理删除）
/// 如果删除的时候默认地址，[则将当前用户最近编辑的一条这是为默认地址（如果有的话）]
/// </summary>
/// <param name="id">地址id</param>
/// <returns></returns>
internal static ReplayBase DelAddress(string id)
{
ReplayBase result = new ReplayBase();
try
{
//根据id获取地址信息，判断该地址是否是默认地址
List <AddressInfoModel> address = MembersExService.GetAddressListByFkId(new GetUserExInfoListRequest()
{
id = id, onlyDefalut = true
});
if (address.Count > 0)
{
//删除之后再将最新操作的一个地址设置为默认地址
//1,删除地址
MembersExDataBaseManager.DelAddress(id);
//2,找到用户id下剩余的地址
List <AddressInfoModel> list_address = MembersExService.GetAddressListByFkId(new GetUserExInfoListRequest()
{
fkId = address[0].fkId, onlyDefalut = false
});
//3,取到最新操作的一个地址，并且修改为默认地址(如果还有地址)
if (list_address.Count > 0)
{
AddressInfoModel tt = list_address[0];
tt.isDefault = true;
MembersExService.EditAddress(tt);
}
}
else
{
//直接删除
MembersExDataBaseManager.DelAddress(id);
}
}
catch (Exception e)
{
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = "服务器错误 500";
SysManagerService.SysSaveErrorLogMsg(e.ToString(), id);
}
return(result);
}
//Insert Address
public int InsertAddress(AddressInfoModel model, string UserName)
{
using (var context = new JustHallAtumationEntities())
{
Address address = new Address()
{
StudentId = GetStudentId(UserName),
P_DistrictId = model.P_DistrictId,
P_PostOffice = model.P_PostOffice,
P_VillageName = model.P_VillageName,
T_DistrictId = model.T_DistrictId,
T_PostOffice = model.T_PostOffice,
T_VillageName = model.T_VillageName
};
context.Addresses.Add(address);
context.SaveChanges();
return(address.StudentId);
}
}
public void Save(AddressMapInfoModel model)
{
var addressInfo = new AddressInfoModel
{
AddressId = Id,
Country = new ListItemModel {
Value = model.Address.Country
},
ExtIntNumber = model.Address.NumExt,
MainAddress = model.Address.MainAddress,
Reference = model.Address.Reference,
RegionA = new ListItemModel {
Value = model.Address.RegionA
},
RegionB = new ListItemModel {
Value = model.Address.RegionB
},
RegionC = new ListItemModel {
Value = model.Address.RegionC
},
RegionD = new ListItemModel {
Value = model.Address.RegionD
},
ZipCode = new ListItemModel {
Value = model.Address.ZipCode
},
PlaceId = model.PlaceId,
StoreCoverageIds = model.CoverageStoreIds,
IsMap = true
};
if (model.Position != null)
{
addressInfo.Lat = model.Position.Lat;
addressInfo.Lng = model.Position.Lng;
}
MessageBus.Current.SendMessage(new AddressInfoGrid
{
PreId = PreId,
AddressInfo = addressInfo
}, SharedMessageConstants.ORDER_ADDRESSINFO);
}
public IActionResult SaveAddress(AddressInfoModel addressModel)
{
var currentUser = ApplicationEngine.CurrentUser;
//get the address first
var address = addressModel.Id > 0 ? _addressService.Get(addressModel.Id) : new Address()
{
EntityId = currentUser.Id,
EntityName = nameof(User)
};
if (address == null || address.EntityId != currentUser.Id)
{
return(NotFound());
}
_modelMapper.Map(addressModel, address);
_addressService.InsertOrUpdate(address);
return(R.Success.Result);
}
public long SaveAddressMap(AddressInfoModel model, bool bIsNew)
{
var address = bIsNew ? new Entities.Address() : DbEntities.Address.Single(e => e.AddressId == model.AddressId);
var phoneToAdd = new ClientPhone {
ClientPhoneId = model.PrimaryPhone.PhoneId
};
DbEntities.ClientPhone.Attach(phoneToAdd);
for (var i = address.ClientPhone.Count - 1; i >= 0; i--)
{
var phone = address.ClientPhone.ElementAt(i);
address.ClientPhone.Remove(phone);
}
address.ClientPhone.Add(phoneToAdd);
address.CountryName = model.Country.Value;
address.RegionNameA = model.RegionA.Value;
address.RegionNameB = model.RegionB.Value;
address.RegionNameC = model.RegionC.Value;
address.RegionNameD = model.RegionD.Value;
address.ZipCodeValue = model.ZipCode.Value;
address.PlaceId = model.PlaceId;
address.Lat = model.Lat;
address.Lng = model.Lng;
address.ExtIntNumber = model.ExtIntNumber;
address.MainAddress = model.MainAddress;
address.Reference = model.Reference;
address.IsMap = true;
if (bIsNew)
{
DbEntities.Address.Add(address);
}
DbEntities.SaveChanges();
return(address.AddressId);
}
/// <summary>
/// 添加或编辑常用地址
/// </summary>
/// <param name="addressinfo">地址信息</param>
/// <returns></returns>
internal static ReplayBase EditAddress(AddressInfoModel addressinfo)
{
ReplayBase rep = new ReplayBase();
try
{
//先判断当前FKID有没有常用地址为默认地址
if (MembersExDataBaseManager.RsGetAddressHaveDefault(addressinfo.fkId.Trim())) //有历史
{
//有历史 设置为默认 addressinfo.isdefault - 历史全部设置为非默认-设置当前为默认 isdefalut =true
if (addressinfo.isDefault == true)
{
try
{
MembersExDataBaseManager.RsSetAddresstoUndefault(addressinfo.fkId.Trim());
}
catch (Exception e)
{
rep.ReturnCode = EnumErrorCode.ServiceError;
rep.ReturnMessage = "服务器错误 500";
SysManagerService.SysSaveErrorLogMsg(e.ToString(), addressinfo);
}
}
}
else//无历史
{
//无历史 设置为默认 - isDefalut=true
//无历史 设置为非默认 isDefalut=false
addressinfo.isDefault = true;
}
rep = MembersExDataBaseManager.EditAddress(addressinfo);
}
catch (Exception e)
{
rep.ReturnCode = EnumErrorCode.ServiceError;
rep.ReturnMessage = "服务器错误 500";
SysManagerService.SysSaveErrorLogMsg(e.ToString(), addressinfo);
}
return(rep);
}
public async Task <IHttpActionResult> Post(AddressInfoModel address)
{
try
{
if (ModelState.IsValid)
{
var addressInfo = _mapper.Map <AddressInfo>(address);
_repo.AddAddress(addressInfo);
if (await _repo.SaveChangesAsync())
{
return(Created("GetAddress", new { addressInfoId = addressInfo.AddressInfoId }));
}
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
return(BadRequest());
}
//For updating student address
public int AddressInformationUpdate(AddressInfoModel model)
{
using (var context = new JustHallAtumationEntities())
{
var address = context.Addresses.Where(x => x.StudentId == model.StudentId).FirstOrDefault();
if (address != null)
{
address.P_DistrictId = model.P_DistrictId;
address.P_PostOffice = model.P_PostOffice;
address.P_VillageName = model.P_VillageName;
address.T_DistrictId = model.T_DistrictId;
address.T_PostOffice = model.T_PostOffice;
address.T_VillageName = model.T_VillageName;
}
else
{
return(-1);
}
context.SaveChanges();
return(address.StudentId);
}
}
public static VerifyRepository.sAddressInfo ToEntity(this AddressInfoModel NatisPostal)
{
return
(new VerifyRepository.sAddressInfo
{
mAddressDate = NatisPostal.AddressDate,
AddressTypeID = NatisPostal.AddressTypeID,
mCode = NatisPostal.Code,
mCompanyName = NatisPostal.CompanyName,
mDate = NatisPostal.Date,
mIDNumber = NatisPostal.IDNumber,
mKey = NatisPostal.Key,
mPersonID = NatisPostal.PersonID,
mPOBox = NatisPostal.POBox,
mResidual = NatisPostal.Residual,
mResidualScore = NatisPostal.ResidualScore,
mSource = NatisPostal.Source,
mStreet = NatisPostal.Street,
mSuburb = NatisPostal.Suburb,
mTown = NatisPostal.Town,
mUserDetails = NatisPostal.UserDetails
});
}
/// <summary>
/// 设置某地址为默认地址
/// </summary>
/// <param name="id">地址id</param>
/// <returns></returns>
internal static ReplayBase SetAddressToDefault(string id)
{
ReplayBase result = new ReplayBase();
//通过id获取fkid
List <AddressInfoModel> address = MembersExService.GetAddressListByFkId(new GetUserExInfoListRequest()
{
id = id, onlyDefalut = false
});
if (address.Count > 0)
{
AddressInfoModel addressInfo = new AddressInfoModel()
{
id = id,
fkId = address[0].fkId,
address = address[0].address,
linkMan = address[0].linkMan,
linkPhone = address[0].linkPhone,
postCode = address[0].postCode,
locationInfo = new LocationInfoModel()
{
DistrictId = address[0].locationInfo.DistrictId, cityInfo = new GeoCityInfoModel()
{
CityCode = address[0].locationInfo.cityInfo.CityCode
}
},
isDefault = true
};
result = MembersExService.EditAddress(addressInfo);
}
else
{
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = "服务器错误 500";
}
return(result);
}
public ActionResult InsertAddress(AddressInfoModel model)
{
try
{
if (ModelState.IsValid)
{
int id = insertInfoOperation.InsertAddress(model, User.Identity.Name);
if (id > 0)
{
ModelState.Clear();
ViewBag.Success = "Information Inserted!";
}
else
{
ViewBag.Success = "failed!";
}
}
return(RedirectToAction("UploadImage")); /// Should go to profile
}
catch (Exception ex)
{
return(View(ex));
}
}
public ActionResult UpdateAddressInfo(AddressInfoModel model)
{
try
{
if (ModelState.IsValid)
{
int id = updateOperation.AddressInformationUpdate(model);
if (id > 0)
{
ModelState.Clear();
ViewBag.Success = "Inserted Successfully";
}
else
{
ViewBag.Success = "Failed!";
}
}
return(RedirectToAction("Studentslist", "ShowDetails"));
}
catch (Exception ex)
{
return(View(ex));
}
}
public static ListItemModel GetQueryToGetByZipCodeId(CallCenterEntities dbEntities, string lastRegion, AddressInfoModel model)
{
lastRegion = lastRegion.ToUpper();
switch (lastRegion)
{
case SettingsData.Constants.Control.CONTROL_REGION_A:
return(dbEntities.RegionA.Where(e => e.RegionId == model.RegionA.IdKey).Select(e => new ListItemModel {
IdKey = e.ZipCodeId, Value = e.ZipCode.Code
}).Single());
case SettingsData.Constants.Control.CONTROL_REGION_B:
return(dbEntities.RegionB.Where(e => e.RegionId == model.RegionB.IdKey).Select(e => new ListItemModel {
IdKey = e.ZipCodeId, Value = e.ZipCode.Code
}).Single());
case SettingsData.Constants.Control.CONTROL_REGION_C:
return(dbEntities.RegionC.Where(e => e.RegionId == model.RegionC.IdKey).Select(e => new ListItemModel {
IdKey = e.ZipCodeId, Value = e.ZipCode.Code
}).Single());
case SettingsData.Constants.Control.CONTROL_REGION_D:
return(dbEntities.RegionD.Where(e => e.RegionId == model.RegionD.IdKey).Select(e => new ListItemModel {
IdKey = e.ZipCodeId, Value = e.ZipCode.Code
}).Single());
}
throw new ArgumentNullException(String.Empty + "No está configurada la información de la jerarquía de direcciones para los códigos");
}
public static List <StoreModel> GetQueryToSearchStore(CallCenterEntities dbEntities, string franchiseCode, AddressInfoModel model, out int franchiseId)
{
franchiseId = dbEntities.Franchise.Where(e => e.IsObsolete == false && e.Code == franchiseCode).Select(e => e.FranchiseId).Single();
var id = franchiseId;
var query = dbEntities.StoreAddressDistribution.Where(e => e.FranchiseStore.FranchiseId == id);
if (SettingsData.Store.ByCountry)
{
query = query.Where(e => e.CountryId == model.Country.IdKey);
}
if (SettingsData.Store.ByRegionA)
{
query = query.Where(e => e.RegionArId == model.RegionA.IdKey);
}
if (SettingsData.Store.ByRegionB)
{
query = query.Where(e => e.RegionBrId == model.RegionB.IdKey);
}
if (SettingsData.Store.ByRegionC)
{
query = query.Where(e => e.RegionCrId == model.RegionC.IdKey);
}
if (SettingsData.Store.ByRegionD)
{
query = query.Where(e => e.RegionDrId == model.RegionD.IdKey);
}
if (SettingsData.Store.ByZipCode)
{
query = query.Where(e => e.ZipCodeId == model.ZipCode.IdKey);
}
return(query.OrderByDescending(e => e.Importance).Select(e =>
new StoreModel
{
Key = e.FranchiseStoreId.ToString(),
IdKey = e.FranchiseStoreId,
Value = e.FranchiseStore.Name,
MainAddress = e.FranchiseStore.Address.MainAddress,
LstPhones = e.FranchiseStore.FranchisePhone.Select(i => i.Phone).ToList(),
WsAddress = e.FranchiseStore.WsAddress
}).ToList());
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(AddressInfoModel model)
{
bool reValue = true;
int reCount = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("update CORE.dbo.AddressInfo set ");
strSql.Append(" SiteId = @SiteId , ");
strSql.Append(" Attach = @Attach , ");
strSql.Append(" LastTime = @LastTime , ");
strSql.Append(" TownId = @TownId , ");
strSql.Append(" Memo = @Memo , ");
strSql.Append(" OrderNo = @OrderNo , ");
strSql.Append(" Tel = @Tel , ");
strSql.Append(" ContactName = @ContactName , ");
strSql.Append(" Invalid = @Invalid , ");
strSql.Append(" MemberId = @MemberId , ");
strSql.Append(" IsDefault = @IsDefault ");
strSql.Append(" where AddressId=@AddressId ");
SqlParameter[] parameters =
{
new SqlParameter("@AddressId", SqlDbType.Decimal, 9),
new SqlParameter("@SiteId", SqlDbType.Decimal, 9),
new SqlParameter("@Attach", SqlDbType.VarChar, 200),
new SqlParameter("@LastTime", SqlDbType.DateTime),
new SqlParameter("@TownId", SqlDbType.Decimal, 9),
new SqlParameter("@Memo", SqlDbType.VarChar, 1000),
new SqlParameter("@OrderNo", SqlDbType.Int, 4),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@ContactName", SqlDbType.VarChar, 20),
new SqlParameter("@Invalid", SqlDbType.Bit, 1),
new SqlParameter("@MemberId", SqlDbType.Decimal, 9),
new SqlParameter("@IsDefault", SqlDbType.Bit, 1)
};
parameters[0].Value = model.AddressId;
parameters[1].Value = model.SiteId;
parameters[2].Value = model.Attach;
parameters[3].Value = model.LastTime;
parameters[4].Value = model.TownId;
parameters[5].Value = model.Memo;
parameters[6].Value = model.OrderNo;
parameters[7].Value = model.Tel;
parameters[8].Value = model.ContactName;
parameters[9].Value = model.Invalid;
parameters[10].Value = model.MemberId;
parameters[11].Value = model.IsDefault; try
{//异常处理
reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters);
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
if (reCount <= 0)
{
reValue = false;
}
return(reValue);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public AddressInfoModel GetModel(decimal AddressId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select AddressId, SiteId, Attach, LastTime, TownId, Memo, OrderNo, Tel, ContactName, Invalid, MemberId, IsDefault ");
strSql.Append(" from CORE.dbo.AddressInfo ");
strSql.Append(" where AddressId=@AddressId");
SqlParameter[] parameters =
{
new SqlParameter("@AddressId", SqlDbType.Decimal)
};
parameters[0].Value = AddressId;
AddressInfoModel model = new AddressInfoModel();
DataSet ds = helper.ExecSqlReDs(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["AddressId"].ToString() != "")
{
model.AddressId = decimal.Parse(ds.Tables[0].Rows[0]["AddressId"].ToString());
}
if (ds.Tables[0].Rows[0]["SiteId"].ToString() != "")
{
model.SiteId = decimal.Parse(ds.Tables[0].Rows[0]["SiteId"].ToString());
}
model.Attach = ds.Tables[0].Rows[0]["Attach"].ToString();
if (ds.Tables[0].Rows[0]["LastTime"].ToString() != "")
{
model.LastTime = DateTime.Parse(ds.Tables[0].Rows[0]["LastTime"].ToString());
}
if (ds.Tables[0].Rows[0]["TownId"].ToString() != "")
{
model.TownId = decimal.Parse(ds.Tables[0].Rows[0]["TownId"].ToString());
}
model.Memo = ds.Tables[0].Rows[0]["Memo"].ToString();
if (ds.Tables[0].Rows[0]["OrderNo"].ToString() != "")
{
model.OrderNo = int.Parse(ds.Tables[0].Rows[0]["OrderNo"].ToString());
}
model.Tel = ds.Tables[0].Rows[0]["Tel"].ToString();
model.ContactName = ds.Tables[0].Rows[0]["ContactName"].ToString();
if (ds.Tables[0].Rows[0]["Invalid"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Invalid"].ToString() == "1") || (ds.Tables[0].Rows[0]["Invalid"].ToString().ToLower() == "true"))
{
model.Invalid = true;
}
else
{
model.Invalid = false;
}
}
if (ds.Tables[0].Rows[0]["MemberId"].ToString() != "")
{
model.MemberId = decimal.Parse(ds.Tables[0].Rows[0]["MemberId"].ToString());
}
if (ds.Tables[0].Rows[0]["IsDefault"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsDefault"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsDefault"].ToString().ToLower() == "true"))
{
model.IsDefault = true;
}
else
{
model.IsDefault = false;
}
}
return(model);
}
else
{
return(model);
}
}
private List <int> CalculateStoresCoverages(List <CoverageStoreModel> storesCoverage, AddressInfoModel addressInfo)
{
var lstStoresIds = new List <int>();
DbGeography gPoint;
try
{
if (string.IsNullOrEmpty(addressInfo.Lat) || string.IsNullOrEmpty(addressInfo.Lng))
{
return(lstStoresIds);
}
gPoint = GeoHelper.PointFromText(addressInfo.Lat, addressInfo.Lng);
}
catch (Exception ex)
{
SharedLogger.LogError(ex, addressInfo.Lat, addressInfo.Lng);
return(lstStoresIds);
}
foreach (var coverage in storesCoverage)
{
if (gPoint.Intersects(coverage.Coverage))
{
if (lstStoresIds.Any(e => e == coverage.StoreId) == false)
{
lstStoresIds.Add(coverage.StoreId);
}
}
//if (coverage.Coverage.Intersects(gPoint))
//{
// if(lstStoresIds.Any(e => e == coverage.StoreId) == false)
// lstStoresIds.Add(coverage.StoreId);
//}
}
return(lstStoresIds);
}
public ReplayBase EditAddress(AddressInfoModel condtion)
{
ReplayBase result = MembersExService.EditAddress(condtion);
return(result);
}
