public GetAddressResponse GetAddress(GetAddressRequest request)
{
GetAddressResponse response = new GetAddressResponse();
Consumer consumer = null;
try
{
using (UserDao dao = new UserDao())
{
consumer = GetAuthUser(dao, request.user_id, request.auth_token, true);
if (consumer == null)
{
MakeNouserResponse(response);
return(response);
}
ConsumerAddress consAddr = consumer.ConsumerAddresses.Where(a => a.AddrID == request.address_id).First();
UserAddressesDto addrDto = new UserAddressesDto();
UsersHelper.CopyFromEntity(addrDto, consAddr, consumer.Name);
response.user_address = addrDto;
response.has_resource = 1;
response.code = 0;
response.message = MessagesSource.GetMessage("addr.details");
return(response);
}
}
catch (Exception ex)
{
response.MakeExceptionResponse(ex);
}
return(response);
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Country,State,City,StreetAddress,PostCode")] ConsumerAddress consumerAddress)
{
if (id != consumerAddress.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
consumerAddress.IdentityUserId = _userService.GetUserId();
_context.Update(consumerAddress);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ConsumerAddressExists(consumerAddress.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(consumerAddress));
}
public ReturnType RemoveConsumerAddress(int consumeraddressID)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
List <ConsumerAddress> list = alading.ConsumerAddress.Where(p => p.ConsumerAddressID == consumeraddressID).ToList();
//List<ConsumerAddress> list = alading.ConsumerAddress.Where(p => p.ConsumerAddressCode == consumeraddressCode).ToList();
if (list.Count == 0)
{
return(ReturnType.NotExisted);
}
else
{
ConsumerAddress sy = list.First();
alading.DeleteObject(sy);
alading.SaveChanges();
return(ReturnType.Success);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType AddConsumerAddress(ConsumerAddress consumeraddress)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
alading.AddToConsumerAddress(consumeraddress);
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.PropertyExisted);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType UpdateConsumerAddress(ConsumerAddress consumeraddress)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
ConsumerAddress result = alading.ConsumerAddress.Where(p => p.ConsumerAddressID == consumeraddress.ConsumerAddressID).FirstOrDefault();
//ConsumerAddress result = alading.ConsumerAddress.Where(p => p.ConsumerAddressCode == consumeraddress.ConsumerAddressCode).FirstOrDefault();
if (result == null)
{
return(ReturnType.NotExisted);
}
#region Using Attach() Function Update,Default USE;
alading.Attach(result);
alading.ApplyPropertyChanges("ConsumerAddress", consumeraddress);
#endregion
#region Using All Items Replace To Update ,Default UnUse
/*
*
* result.buyer_nick = consumeraddress.buyer_nick;
*
* result.location_state = consumeraddress.location_state;
*
* result.location_city = consumeraddress.location_city;
*
* result.location_district = consumeraddress.location_district;
*
* result.location_address = consumeraddress.location_address;
*
* result.location_zip = consumeraddress.location_zip;
*
* result.location_country = consumeraddress.location_country;
*
*/
#endregion
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.OthersError);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public static void CopyToEntity(ConsumerAddress address, AddAddressRequest request)
{
address.ConsID = request.user_id;
address.Address = request.user_address;
address.RegionName = request.region_name;
address.PostalCode = request.postal_code;
address.AdditionalInfo = request.more_info;
address.IsDefault = Convert.ToBoolean(request.is_default);
address.Latitude = request.user_latitude;
address.Longitude = request.user_longitude;
}
public static void CopyFromEntity(UserAddressesDto usrAddr, ConsumerAddress consAddr, string userName)
{
usrAddr.address_id = consAddr.AddrID; // more_info, is_default
usrAddr.user_name = userName;
usrAddr.is_default = consAddr.IsDefault ? 1 : 0;
usrAddr.user_address = consAddr.Address;
usrAddr.region_name = consAddr.RegionName;
usrAddr.more_info = consAddr.AdditionalInfo;
usrAddr.postal_code = consAddr.PostalCode;
usrAddr.user_latitude = consAddr.Latitude;
usrAddr.user_longitude = consAddr.Longitude;
}
public async Task <IActionResult> Create([Bind("Id,Country,State,City,StreetAddress,PostCode")] ConsumerAddress consumerAddress)
{
if (ModelState.IsValid)
{
consumerAddress.IdentityUserId = _userService.GetUserId();
_context.Add(consumerAddress);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(consumerAddress));
}
public ResponseDto AddAddress(AddAddressRequest request)
{
ResponseDto response = new ResponseDto();
Consumer consumer = null;
response.has_resource = 0;
try
{
using (UserDao dao = new UserDao())
{
consumer = GetAuthUser(dao, request.user_id, request.auth_token, true);
if (consumer == null)
{
MakeNouserResponse(response);
return(response);
}
ConsumerAddress address = new ConsumerAddress();
address.ConsID = request.user_id;
UsersHelper.CopyToEntity(address, request);
address.CreatedDate = DateTime.Now;
address.UpdatedDate = address.CreatedDate;
address.StatusID = 1;
if (consumer.ConsumerAddresses.Count == 0)
{
address.IsDefault = true;
}
else
{
address.IsDefault = Convert.ToBoolean(request.is_default);
if (Convert.ToBoolean(request.is_default))
{
foreach (var item in consumer.ConsumerAddresses)
{
item.IsDefault = false;
}
dao.Update(consumer);
}
}
dao.AddAddress(address);
response.code = 0;
response.message = MessagesSource.GetMessage("addr.added");
return(response);
}
}
catch (Exception ex)
{
response.MakeExceptionResponse(ex);
}
return(response);
}
public bool DeleteAddress(int addressId, out bool isDefault)
{
ConsumerAddress addr = _context.ConsumerAddresses.Find(addressId);
if (addr != null)
{
isDefault = addr.IsDefault;
if (!isDefault)
{
addr.StatusID = 0;
_context.Entry(addr).State = System.Data.EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
isDefault = false;
return(false);
}
public ReturnType UpdateConsumerAddress(int consumeraddressID, ConsumerAddress consumeraddress)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
var result = alading.ConsumerAddress.Where(p => p.ConsumerAddressID == consumeraddressID).ToList();
//var result = alading.ConsumerAddress.Where(p => p.ConsumerAddressCode == consumeraddressCode).ToList();
if (result.Count == 0)
{
return(ReturnType.NotExisted);
}
ConsumerAddress ob = result.First();
ob.buyer_nick = consumeraddress.buyer_nick;
ob.location_state = consumeraddress.location_state;
ob.location_city = consumeraddress.location_city;
ob.location_district = consumeraddress.location_district;
ob.location_address = consumeraddress.location_address;
ob.location_zip = consumeraddress.location_zip;
ob.location_country = consumeraddress.location_country;
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.OthersError);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public ResponseDto UpdateAddress(UpdateAddressRequest request)
{
ResponseDto response = new ResponseDto();
Consumer consumer = null;
response.has_resource = 0;
try
{
using (UserDao dao = new UserDao())
{
consumer = GetAuthUser(dao, request.user_id, request.auth_token, true);
if (consumer == null)
{
MakeNouserResponse(response);
return(response);
}
ConsumerAddress address = dao.FindAddressById(request.address_id);
if (address == null)
{
response.code = 1;
response.message = MessagesSource.GetMessage("no.addr");
return(response);
}
if (Convert.ToBoolean(request.is_default))
{
foreach (var item in consumer.ConsumerAddresses.Where(x => x.IsDefault).ToList())
{
item.IsDefault = false;
}
UsersHelper.CopyToEntity(consumer.ConsumerAddresses.Where(x => x.AddrID == request.address_id).FirstOrDefault(), request);
dao.Update(consumer);
}
else
{
if (consumer.ConsumerAddresses.Where(x => x.IsDefault && x.AddrID != request.address_id).Count() == 0)
{
UsersHelper.CopyToEntity(consumer.ConsumerAddresses.Where(x => x.AddrID == request.address_id).FirstOrDefault(), request);
address.IsDefault = true;
dao.Update(consumer);
}
else
{
UsersHelper.CopyToEntity(consumer.ConsumerAddresses.Where(x => x.AddrID == request.address_id).FirstOrDefault(), request);
dao.Update(consumer);
}
}
//UsersHelper.CopyToEntity(address, request);
// dao.UpdateAddress(address);
response.code = 0;
response.message = MessagesSource.GetMessage("addr.updated");
return(response);
}
}
catch (Exception ex)
{
response.MakeExceptionResponse(ex);
}
return(response);
}
//public static ReturnType UpdateConsumerAddress(string consumeraddressCode, ConsumerAddress consumeraddress)
//{
// return DataProviderClass.Instance().UpdateConsumerAddress(consumeraddressCode, consumeraddress);
//}
public static ReturnType UpdateConsumerAddress(int consumeraddressID, ConsumerAddress consumeraddress)
{
return(DataProviderClass.Instance().UpdateConsumerAddress(consumeraddressID, consumeraddress));
}
public static ReturnType AddConsumerAddress(ConsumerAddress consumeraddress)
{
return(DataProviderClass.Instance().AddConsumerAddress(consumeraddress));
}
public void AddAddress(ConsumerAddress address)
{
_context.ConsumerAddresses.Add(address);
_context.SaveChanges();
}
public void UpdateAddress(ConsumerAddress address)
{
// _context.
_context.Entry(address).State = System.Data.EntityState.Modified;
_context.SaveChanges();
}