public async Task <IHttpActionResult> PutAddressModels(int id, AddressModels addressModels)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != addressModels.AddressId)
{
return(BadRequest());
}
db.Entry(addressModels).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AddressModelsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public JsonResult EditById(int Id)
{
var User = (from s in oSaleforceConnector.Customers where s.Id == Id select s).FirstOrDefault();
var BillingAddressId = User.BillingAddressId;
var ShippingAddressId = User.ShippingAddressId;
//return RedirectToAction("Index", "Address");
var BillingsalesforceConnectionBilling = oSaleforceConnector.USP_Address_SelectByBillingAddressId(BillingAddressId).FirstOrDefault();
var Addressmodels = new AddressModels();
Addressmodels.Id = Convert.ToInt32(BillingsalesforceConnectionBilling.Id);
Addressmodels.BillingAddress1 = BillingsalesforceConnectionBilling.Address1;
Addressmodels.BillingAddress2 = BillingsalesforceConnectionBilling.Address2;
Addressmodels.BillingCity = BillingsalesforceConnectionBilling.City;
Addressmodels.BillingState = BillingsalesforceConnectionBilling.State;
Addressmodels.BillingCountry = BillingsalesforceConnectionBilling.Country;
Addressmodels.BillingPostalCode = BillingsalesforceConnectionBilling.PostalCode;
Addressmodels.BillingPhoneNumber = BillingsalesforceConnectionBilling.PhoneNumber;
Addressmodels.CustomerId = Convert.ToInt32(BillingsalesforceConnectionBilling.CustomerId);
//var ShippingsalesforceConnectionShipping = oSaleforceConnector.USP_Address_SelectByShippingAddressId(ShippingAddressId).FirstOrDefault();
//Addressmodels.Id = Convert.ToInt32(ShippingsalesforceConnectionShipping.Id);
//Addressmodels.ShippingAddress1 = ShippingsalesforceConnectionShipping.Address1;
//Addressmodels.ShippingAddress2 = ShippingsalesforceConnectionShipping.Address2;
//Addressmodels.ShippingCity = ShippingsalesforceConnectionShipping.City;
//Addressmodels.ShippingState = ShippingsalesforceConnectionShipping.State;
//Addressmodels.ShippingCountry = ShippingsalesforceConnectionShipping.Country;
//Addressmodels.ShippingPostalCode = ShippingsalesforceConnectionShipping.PostalCode;
//Addressmodels.ShippingPhoneNumber = ShippingsalesforceConnectionShipping.PhoneNumber;
return(Json(Addressmodels, JsonRequestBehavior.AllowGet));
}
public string AddressInsert(AddressModels oAddressmodels)
{
var BillingResult = 0;
var shippingResult = 0;
var customerid = oAddressmodels.CustomerId;
try
{
if (ModelState.IsValid)
{
BillingResult = oSaleforceConnector.USP_Address_Insert(oAddressmodels.CustomerId, oAddressmodels.BillingAddress1, oAddressmodels.BillingAddress2, oAddressmodels.BillingCountry, oAddressmodels.BillingState, oAddressmodels.BillingCity, oAddressmodels.BillingPostalCode, oAddressmodels.BillingPhoneNumber, "Billing");
//shippingResult = oSaleforceConnector.USP_Address_Insert(oAddressmodels.CustomerId, oAddressmodels.ShippingAddress1, oAddressmodels.ShippingAddress2, oAddressmodels.ShippingCountry, oAddressmodels.ShippingState, oAddressmodels.ShippingCity, oAddressmodels.ShippingPostalCode, oAddressmodels.ShippingPhoneNumber, "Shipping");
return("1");
}
return("3");
}
catch (Exception ex)
{
long CustomerID = Convert.ToInt32(customerid);
ex.Message.ToString();
Errorlog.ErrorDetail(CustomerID, orderId, "AddressInsert", ex.Message, 1);
return("0");
}
}
public async Task <IHttpActionResult> GetAddressModels(int id)
{
AddressModels addressModels = await db.AddressModels.FindAsync(id);
if (addressModels == null)
{
return(NotFound());
}
return(Ok(addressModels));
}
public string AddressUpdate(AddressModels oAddressmodels)
{
var BillingResult = 0;
// var shippingResult = 0;
// long CustomerId = Convert.ToInt64(Session["CustomerId"]);
var CustomerId = oAddressmodels.CustomerId;
var User = (from s in oSaleforceConnector.Customers where s.Id == CustomerId select s).FirstOrDefault();
var BillinAddressId = User.BillingAddressId;
//var ShippingAddressId = User.ShippingAddressId;
try
{
if (ModelState.IsValid)
{
BillingResult = oSaleforceConnector.USP_Address_Update
(
BillinAddressId,
oAddressmodels.BillingAddress1,
oAddressmodels.BillingAddress2,
oAddressmodels.BillingCountry,
oAddressmodels.BillingState,
oAddressmodels.BillingCity,
oAddressmodels.BillingPostalCode,
oAddressmodels.BillingPhoneNumber
);
// shippingResult = oSaleforceConnector.USP_Address_Update
// (
// ShippingAddressId,
// oAddressmodels.ShippingAddress1,
// oAddressmodels.ShippingAddress2,
// oAddressmodels.ShippingCountry,
// oAddressmodels.ShippingState,
// oAddressmodels.ShippingCity,
// oAddressmodels.ShippingPostalCode,
// oAddressmodels.ShippingPhoneNumber
//);
return("2");
}
else
{
return("3");
}
}
catch (Exception ex)
{
long CustomerID = Convert.ToInt32(CustomerId);
ex.Message.ToString();
Errorlog.ErrorDetail(CustomerID, orderId, "AddressUpdate", ex.Message, 1);
return("0");
}
}
private States GetState(AddressModels model)
{
var States = (from data in context.State where data.Name.ToLower() == model.City.State.Name.ToLower() select data).ToList();
if (States.Count > 0)
{
return((from data in context.State where data.Name.ToLower() == model.City.State.Name.ToLower() select data).First());
}
else
{
return(model.City.State);
}
}
public async Task <IHttpActionResult> DeleteAddressModels(int id)
{
AddressModels addressModels = await db.AddressModels.FindAsync(id);
if (addressModels == null)
{
return(NotFound());
}
db.AddressModels.Remove(addressModels);
await db.SaveChangesAsync();
return(Ok(addressModels));
}
public async Task <IHttpActionResult> PostAddressModels(AddressModels addressModels)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
String id = User.Identity.GetUserId();
addressModels.UserId = id;
db.AddressModels.Add(addressModels);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = addressModels.AddressId }, addressModels));
}
private ZipCode GetZip(AddressModels model)
{
var Zips = (from data in context.Zip where data.zip == model.Zip.zip select data).ToList();
if (Zips.Count > 0)
{
return((from data in context.Zip where data.zip == model.Zip.zip select data).First());
}
else
{
context.Zip.Add(model.Zip);
context.SaveChanges();
return((from data in context.Zip where data.zip == model.Zip.zip select data).First());
}
}
private Cities GetCity(AddressModels model)
{
model.City.State = GetState(model);
var cities = (from data in context.City where data.name == model.City.name && data.State.Name == model.City.State.Name select data).ToList();
if (cities.Count > 0)
{
return((from data in context.City where data.name == model.City.name && data.State.Name == model.City.State.Name select data).First());
}
else
{
context.City.Add(model.City);
context.SaveChanges();
return((from data in context.City where data.name == model.City.name && data.State.Name == model.City.State.Name select data).First());
}
}
private AddressModels GetAddress(AddressModels model)
{
model.City = GetCity(model);
model.Zip = GetZip(model);
var addresses = (from data in context.Address where data.addressLine == model.addressLine && data.City.name == model.City.name && data.Zip.zip == model.Zip.zip select data).ToList();
if (addresses.Count > 0)
{
return((from data in context.Address where data.addressLine == model.addressLine && data.City.name == model.City.name && data.Zip.zip == model.Zip.zip select data).First());
}
else
{
context.Address.Add(model);
context.SaveChanges();
return((from data in context.Address where data.addressLine == model.addressLine && data.City.name == model.City.name && data.Zip.zip == model.Zip.zip select data).First());
}
}
public ActionResult AddAddress(AddressModels model)
{
UserAddressJunction junction = new UserAddressJunction();
var username = User.Identity.GetUserName();
var user = (from data in context.Users where data.UserName == username select data).First();
junction.Address = GetAddress(model);
junction.User = user;
var existingJunction = (from data in context.UserAddresses where data.Address.ID == junction.Address.ID && data.User.Id == junction.User.Id select data).ToList();
if (existingJunction.Count > 0)
{
context.UserAddresses.Add(existingJunction[0]);
context.SaveChanges();
}
else
{
context.UserAddresses.Add(junction);
context.SaveChanges();
}
return(RedirectToAction("Account", "Customer"));
}
public ActionResult AddAddress()
{
AddressModels model = new AddressModels();
return(View(model));
}
