public void populatingCustomerDb() { EstablishConnection(); OracleCommand command = new OracleCommand(); command.Connection = conn; List <int> idList = jsonQueryList(); foreach (var temp in idList) { ProfilePullHelper helper = new ProfilePullHelper(); ProfilePull customerPull = ProfilePullHelper.PullProfile(Convert.ToString(temp)); command.CommandText = "INSERT INTO fin_customer_data VALUES(:customerIDP, :firstNameP, :lastNameP, :customerStatusP, :streetNameP, :zipCodeP, :cityP, :stateP, :countryP, :emailP, :contactNumberP, :dateOfBirthP)"; command.Parameters.Add(":customerIDP", customerPull.customerdetails.customerid); command.Parameters.Add(":firstNameP", customerPull.customerdetails.fname); command.Parameters.Add(":lastNameP", customerPull.customerdetails.lname); command.Parameters.Add(":customerStatusP", customerPull.customerdetails.customerstatus); command.Parameters.Add(":streetNameP", customerPull.customerdetails.connectionaddress.streetname); command.Parameters.Add(":zipCodeP", customerPull.customerdetails.connectionaddress.zipcode); command.Parameters.Add(":cityP", customerPull.customerdetails.connectionaddress.city); command.Parameters.Add(":stateP", customerPull.customerdetails.connectionaddress.state); command.Parameters.Add(":countryP", customerPull.customerdetails.connectionaddress.country); command.Parameters.Add(":emailP", customerPull.customerdetails.email); command.Parameters.Add(":contactNumberP", customerPull.customerdetails.contactnumber); command.Parameters.Add(":dateOfBirthP", customerPull.customerdetails.dateofbirth); //command.Parameters.Add(":billAmountP", customerPull.) command.ExecuteNonQuery(); } conn.Close(); }
public static Profile PullProfile(string customerId) { Profile customProfile = null; string profileJson = GetJsonFromUrl(String.Format(@"{0}/{1}", PROFILE_PULL_URL, customerId)); if (!String.IsNullOrWhiteSpace(profileJson) && profileJson != "null") { ProfilePull fullProfile = GetObjectFromJson <ProfilePull>(profileJson); customProfile = fullProfile.GetCustomProfile(); } return(customProfile); }
public static Profile PullProfile(string customerId) { Profile customProfile = null; //string profileJson = GetJsonFromUrl(String.Format(@"{0}/{1}", PROFILE_PULL_URL, customerId)); string profileJson = File.ReadAllText("");//give json file path here if(!String.IsNullOrWhiteSpace(profileJson)) { ProfilePull fullProfile = GetObjectFromJson<ProfilePull>(profileJson); customProfile = fullProfile.GetCustomProfile(); } return customProfile; }
public static ProfilePull PullProfile(string customerId) { ProfilePull customerProfile = null; string url = profilePullUrl + "42";//customerid string customerProfileJson = GetJsonFromUrl(url); //string customerProfileJson = File.ReadAllText("D:\\profile.json");//give json file path here if (!String.IsNullOrWhiteSpace(customerProfileJson)) { customerProfile = GetObjectFromJson <ProfilePull>(customerProfileJson); } return(customerProfile); }
public void populatingCustomerDb() { List <int> idList = jsonQueryList(); foreach (var temp in idList) { ProfilePull customerPull = ProfilePullHelper.PullProfile(Convert.ToString(temp)); if (customerPull != null) { try { OracleCommand command = new OracleCommand(); command.Connection = conn; EstablishConnection(); command.CommandText = @"INSERT INTO fincustomerdata VALUES(:customerIDP, :firstNameP, :lastNameP, :customerStatusP, :streetNameP, :zipCodeP, :cityP, :stateP, :countryP, :emailP, :contactNumberP, TO_DATE(:dateOfBirthP,'YYYY-MM-DD'))"; command.Parameters.Add(":customerIDP", customerPull.customerdetails.customerid); command.Parameters.Add(":firstNameP", customerPull.customerdetails.fname); command.Parameters.Add(":lastNameP", customerPull.customerdetails.lname); command.Parameters.Add(":customerStatusP", customerPull.customerdetails.customerstatus); command.Parameters.Add(":streetNameP", customerPull.customerdetails.connectionaddress.streetname); command.Parameters.Add(":zipCodeP", customerPull.customerdetails.connectionaddress.zipcode); command.Parameters.Add(":cityP", customerPull.customerdetails.connectionaddress.city); command.Parameters.Add(":stateP", customerPull.customerdetails.connectionaddress.state); command.Parameters.Add(":countryP", customerPull.customerdetails.connectionaddress.country); command.Parameters.Add(":emailP", customerPull.customerdetails.email); command.Parameters.Add(":contactNumberP", customerPull.customerdetails.contactnumber); command.Parameters.Add(":dateOfBirthP", customerPull.customerdetails.dateofbirth); command.ExecuteNonQuery(); conn.Close(); } catch (Exception e) { Console.WriteLine(e.Message); } } } }