static void InsertBusinessAddress(Business_Address business_address) { using (SqlConnection con = new SqlConnection(contact_connectionString)) { SqlCommand cmd = new SqlCommand("AddBusinessAddress", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@business_id", business_address.Business_ID); cmd.Parameters.AddWithValue("@main_address", business_address.Main_Address); cmd.Parameters.AddWithValue("@address_type", ReplaceEmpty(business_address.Address_Type)); cmd.Parameters.AddWithValue("@street_number", ReplaceEmpty(business_address.Street_Number)); cmd.Parameters.AddWithValue("@pre_direction", ReplaceEmpty(business_address.Pre_Direction)); cmd.Parameters.AddWithValue("@street_name", ReplaceEmpty(business_address.Street_Name)); cmd.Parameters.AddWithValue("@street_type", ReplaceEmpty(business_address.Street_Type)); cmd.Parameters.AddWithValue("@post_direction", ReplaceEmpty(business_address.Post_Direction)); cmd.Parameters.AddWithValue("@unit_suite_number", ReplaceEmpty(business_address.Unit_Suite_Number)); cmd.Parameters.AddWithValue("@address_line_3", ReplaceEmpty(business_address.Address_Line_3)); cmd.Parameters.AddWithValue("@po_box", ReplaceEmpty(business_address.PO_Box)); cmd.Parameters.AddWithValue("@city", ReplaceEmpty(business_address.City)); cmd.Parameters.AddWithValue("@state_code", ReplaceEmpty(business_address.State_Code)); cmd.Parameters.AddWithValue("@zip", ReplaceEmpty(business_address.Zip)); cmd.Parameters.AddWithValue("@county_code", ReplaceEmpty(business_address.County_Code)); cmd.Parameters.AddWithValue("@country_code", ReplaceEmpty(business_address.Country_Code)); cmd.Parameters.AddWithValue("@country_type", ReplaceEmpty(business_address.Country_Type)); cmd.Parameters.AddWithValue("@last_update_date", ReplaceEmpty(business_address.Last_Update_Date)); cmd.Parameters.AddWithValue("@last_update_user", ReplaceEmpty(business_address.Last_Update_User)); con.Open(); int j = cmd.ExecuteNonQuery(); con.Close(); if (j >= 1) { Console.WriteLine("Sucessfully wrote Business Address with ID: " + business_address.Business_ID); } else { Console.WriteLine("Error writing Business Address with ID: " + business_address.Business_ID); } } }
static void ProcessBusiness(EnerGovSource source) { string[] split = source.BTR_IDs.Split(";"); Console.WriteLine("Processing Business Object with Contact ID of " + source.Contact_ID + " and " + split[0]); using (SqlConnection bus_con = new SqlConnection(contact_connectionString)) { SqlCommand bus_command = new SqlCommand("GetBusinessInfo", bus_con); bus_command.CommandType = CommandType.StoredProcedure; bus_command.Parameters.AddWithValue("@refnum", split[0]); bus_con.Open(); SqlDataReader bus_rdr = bus_command.ExecuteReader(); while (bus_rdr.Read()) { Globals.counter = Globals.counter + 1; Business business = new Business() { Business_ID = ReturnFormattedID(Globals.counter), Contact_ID = source.Contact_ID, Ownership_Type = bus_rdr["Ownership"].ToString(), Location_Type = "Commercial", Business_Status = "Active", District = bus_rdr["district"].ToString(), Open_Date = bus_rdr["open_date"].ToString(), Business_Description = "", Closed_Date = "", Federal_ID_Number = bus_rdr["federal_id_number"].ToString(), State_ID_Number = "", DBA = "", Legacy_Data_Source_Name = "BTR" }; Console.WriteLine("New Business Object created with ID: " + ReturnFormattedID(Globals.counter)); Business_Address business_address = new Business_Address() { Business_ID = ReturnFormattedID(Globals.counter), Main_Address = true, Address_Type = "Location", Street_Number = bus_rdr["street_number"].ToString(), Pre_Direction = bus_rdr["pre_direction"].ToString(), Street_Name = bus_rdr["street_name"].ToString(), Street_Type = bus_rdr["street_type"].ToString(), Post_Direction = "", Unit_Suite_Number = bus_rdr["unit_suite_number"].ToString(), Address_Line_3 = "", PO_Box = "", City = bus_rdr["city"].ToString(), State_Code = "FL", Zip = bus_rdr["zip"].ToString(), County_Code = "", Country_Code = "", Country_Type = "US", Last_Update_Date = "", Last_Update_User = "" }; Business_Note business_note = new Business_Note() { Business_ID = ReturnFormattedID(Globals.counter), Note_Text = bus_rdr["note_text"].ToString(), Note_User = "", Note_Date = "" }; /* * Business_Parcel business_parcel = new Business_Parcel() * { * Business_ID = ReturnFormattedID(Globals.counter), * Parcel_Number = bus_rdr["note_text"].ToString(), * Main_Parcel = true * };*/ /* * //Business Additional Fields * Business_Additional_Fields business_additional_fields = new Business_Additional_Fields * { * Business_ID = ReturnFormattedID(Globals.counter), * Exemptions = bus_rdr["Exemption"].ToString(), * NewHomeBasedBusiness = bus_rdr["NewHomeBasedBusiness"].ToString(), * NotForProfitBusiness = bus_rdr["NotForProfitBusiness"].ToString(), * OfAdditionalClassifications = Convert.ToDecimal(bus_rdr["OfAdditionalClassifications"]) * };*/ InsertBusiness(business); InsertBusinessAddress(business_address); // InsertBusinessParcel(business_parcels); InsertBusinessNote(business_note); // InsertBusinessAdditionalFields(business_additional_fields); } } }