M_BillingAddress ICustomer.AddNewAddress(M_BillingAddress address) { try { return(icustomer.AddNewAddress(address)); } catch (Exception ex) { return(null); } }
M_BillingAddress ICustomerDA.AddNewAddress(M_BillingAddress address) { //M_BillingAddress result = new M_BillingAddress(); try { DataTable dt = new DataTable(); if (connString.State == ConnectionState.Closed) { connString.Open(); } cmd = new SqlCommand("uspInsertUpdateAddress", connString); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CustomerId", address.CustomerId); cmd.Parameters.AddWithValue("@BillingAddressId", address.BillingAddressId); cmd.Parameters.AddWithValue("@Name", address.Name); cmd.Parameters.AddWithValue("@Address1", address.Address1); cmd.Parameters.AddWithValue("@Address2", address.Address2); cmd.Parameters.AddWithValue("@LandMark", address.LandMark); cmd.Parameters.AddWithValue("@ContactNo", address.ContactNo); cmd.Parameters.AddWithValue("@Pincode", address.Pincode); cmd.Parameters.AddWithValue("@StateId", address.StateId); cmd.Parameters.AddWithValue("@CountryId", address.CountryId); cmd.Parameters.AddWithValue("@Latitude", address.Latitude); cmd.Parameters.AddWithValue("@Longitude", address.Longitude); cmd.Parameters.AddWithValue("@AddressType", address.AddressType); cmd.Parameters.AddWithValue("@IsDefault", address.IsDefault); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); sda.Dispose(); return(ExtensionMethods.ConvertToListOf <M_BillingAddress>(dt).FirstOrDefault()); } catch (Exception ex) { return(null); } finally { connString.Close(); } }
public async Task <HttpResponseMessage> AddCustomerAddress([FromBody] M_BillingAddress address) { try { M_BillingAddress customer = new OnlineShop.Model.M_BillingAddress(); await Task.Run(() => { customer = icustomer.AddNewAddress(address); }); if (customer != null) { return(Request.CreateResponse(HttpStatusCode.OK, customer)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, new { StatusCode = HttpStatusCode.NotFound, Status = "Failed" })); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } }