public void AddClientHouseRequestService() { using (SqlConnection conn = ConnectionManager.GetDataBaseConnection()) { SqlCommand cmd = new SqlCommand("AddClientHouseRequestService", conn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parm = new SqlParameter("@userId", SqlDbType.Int); parm.Direction = ParameterDirection.Output; cmd.Parameters.Add(parm); parm = new SqlParameter("@Email", SqlDbType.NChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = Email; cmd.Parameters.Add(parm); parm = new SqlParameter("@userName", SqlDbType.NChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = WeChat; cmd.Parameters.Add(parm); parm = new SqlParameter("@userType", SqlDbType.VarChar, 30); parm.Direction = ParameterDirection.Input; parm.Value = "client"; cmd.Parameters.Add(parm); parm = new SqlParameter("@active", SqlDbType.Bit); parm.Direction = ParameterDirection.Input; parm.Value = true; cmd.Parameters.Add(parm); parm = new SqlParameter("@approve", SqlDbType.Bit); parm.Direction = ParameterDirection.Input; parm.Value = true; cmd.Parameters.Add(parm); parm = new SqlParameter("@phone", SqlDbType.NChar, 30); parm.Direction = ParameterDirection.Input; parm.Value = Phone; cmd.Parameters.Add(parm); parm = new SqlParameter("@cellPhone", SqlDbType.NChar, 30); parm.Direction = ParameterDirection.Input; parm.Value = ""; cmd.Parameters.Add(parm); parm = new SqlParameter("@webChat", SqlDbType.NChar, 15); parm.Direction = ParameterDirection.Input; parm.Value = WeChat; cmd.Parameters.Add(parm); parm = new SqlParameter("@counselor", SqlDbType.NChar, 30); parm.Direction = ParameterDirection.Input; parm.Value = CounselorName; cmd.Parameters.Add(parm); parm = new SqlParameter("@createClientat", SqlDbType.NChar, 10); parm.Direction = ParameterDirection.Input; parm.Value = ImportCity; cmd.Parameters.Add(parm); parm = new SqlParameter("@chineseName1", SqlDbType.NChar, 30); parm.Direction = ParameterDirection.Input; parm.Value = ClientName; cmd.Parameters.Add(parm); parm = new SqlParameter("@title1", SqlDbType.NChar, 5); parm.Direction = ParameterDirection.Input; parm.Value = Gender; cmd.Parameters.Add(parm); parm = new SqlParameter("@fullname", SqlDbType.NChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = ClientName; cmd.Parameters.Add(parm); parm = new SqlParameter("@chineseAddress", SqlDbType.NChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = Address; cmd.Parameters.Add(parm); parm = new SqlParameter("@city", SqlDbType.NChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = City; cmd.Parameters.Add(parm); parm = new SqlParameter("@state", SqlDbType.NChar, 2); parm.Direction = ParameterDirection.Input; parm.Value = State; cmd.Parameters.Add(parm); parm = new SqlParameter("@zipcode", SqlDbType.NChar, 15); parm.Direction = ParameterDirection.Input; parm.Value = ZipCode; cmd.Parameters.Add(parm); parm = new SqlParameter("@interestedHouse", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = InterestedHouse; cmd.Parameters.Add(parm); parm = new SqlParameter("@interestedCondo", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = InterestedCondo; cmd.Parameters.Add(parm); parm = new SqlParameter("@interestedTownHouse ", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = InterestedTownHouse; cmd.Parameters.Add(parm); parm = new SqlParameter("@interestedApartment", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = InterestedApartment; cmd.Parameters.Add(parm); parm = new SqlParameter("@excellentDistrict", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = ExcellentDistrict; cmd.Parameters.Add(parm); parm = new SqlParameter("@goodDistrict", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = GoodDistrict; cmd.Parameters.Add(parm); parm = new SqlParameter("@generalDistrict", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = GeneralDistrict; cmd.Parameters.Add(parm); parm = new SqlParameter("@newHouse", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = NewHouse; cmd.Parameters.Add(parm); parm = new SqlParameter("@east", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = East; cmd.Parameters.Add(parm); parm = new SqlParameter("@west", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = West; cmd.Parameters.Add(parm); parm = new SqlParameter("@south", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = South; cmd.Parameters.Add(parm); parm = new SqlParameter("@north", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = North; cmd.Parameters.Add(parm); parm = new SqlParameter("@northEast", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = NorthEast; cmd.Parameters.Add(parm); parm = new SqlParameter("@southEast", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = SouthEast; cmd.Parameters.Add(parm); parm = new SqlParameter("@southWest", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = SouthWest; cmd.Parameters.Add(parm); parm = new SqlParameter("@northWest", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = NorthWest; cmd.Parameters.Add(parm); parm = new SqlParameter("@moveInImmediately", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = MoveInImmediately; cmd.Parameters.Add(parm); parm = new SqlParameter("@threeYears", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = ThreeYears; cmd.Parameters.Add(parm); parm = new SqlParameter("@fiveYears", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = FiveYears; cmd.Parameters.Add(parm); parm = new SqlParameter("@tenYears", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = TenYears; cmd.Parameters.Add(parm); parm = new SqlParameter("@overTenYears", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = OverTenYears; cmd.Parameters.Add(parm); parm = new SqlParameter("@hawaii", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = Hawaii; cmd.Parameters.Add(parm); parm = new SqlParameter("@chicago", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = Chicago; cmd.Parameters.Add(parm); parm = new SqlParameter("@miami", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = Miami; cmd.Parameters.Add(parm); parm = new SqlParameter("@sanDiego", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = SanDiego; cmd.Parameters.Add(parm); parm = new SqlParameter("@newJersey", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = NewJersey; cmd.Parameters.Add(parm); parm = new SqlParameter("@connecticut", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = Connecticut; cmd.Parameters.Add(parm); parm = new SqlParameter("@atlanta", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = Atlanta; cmd.Parameters.Add(parm); parm = new SqlParameter("@newYorkState", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = NewYorkState; cmd.Parameters.Add(parm); parm = new SqlParameter("@california", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = California; cmd.Parameters.Add(parm); parm = new SqlParameter("@washington", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = Washington; cmd.Parameters.Add(parm); parm = new SqlParameter("@floridia", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = Floridia; cmd.Parameters.Add(parm); parm = new SqlParameter("@massachusetts", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = Massachusetts; cmd.Parameters.Add(parm); parm = new SqlParameter("@pennsylvania", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = Pennsylvania; cmd.Parameters.Add(parm); parm = new SqlParameter("@bothInvstmtment", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = BothInvstmtment; cmd.Parameters.Add(parm); int numberofVisitingCities = 1; if (SecondVistiHouseTime.Trim() != "") { numberofVisitingCities++; } if (ThirdVisitHouseTime.Trim() != "") { numberofVisitingCities++; } parm = new SqlParameter("@numberofVisitingCities", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = numberofVisitingCities; cmd.Parameters.Add(parm); parm = new SqlParameter("@preferredState", SqlDbType.NChar, 2); parm.Direction = ParameterDirection.Input; parm.Value = PreferredState; cmd.Parameters.Add(parm); parm = new SqlParameter("@purchaseHouseforInvestment", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = PurchaseHouseforInvestment; cmd.Parameters.Add(parm); parm = new SqlParameter("@PurchaseHouseForSelf", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = PurchaseHouseForSelf; cmd.Parameters.Add(parm); parm = new SqlParameter("@preferredBedrooms", SqlDbType.NChar, 15); parm.Direction = ParameterDirection.Input; parm.Value = PreferredBedrooms; cmd.Parameters.Add(parm); parm = new SqlParameter("@preferredBathrooms", SqlDbType.NChar, 15); parm.Direction = ParameterDirection.Input; parm.Value = PreferredBathrooms; cmd.Parameters.Add(parm); parm = new SqlParameter("@preferredGarages", SqlDbType.NChar, 15); parm.Direction = ParameterDirection.Input; parm.Value = PreferredGarages; cmd.Parameters.Add(parm); parm = new SqlParameter("@minPreferedFootage", SqlDbType.NChar, 15); parm.Direction = ParameterDirection.Input; parm.Value = MinPreferedFootage; cmd.Parameters.Add(parm); parm = new SqlParameter("@maxPreferredFootage", SqlDbType.NChar, 15); parm.Direction = ParameterDirection.Input; parm.Value = MaxPreferredFootage; cmd.Parameters.Add(parm); parm = new SqlParameter("@minPreferedPrice", SqlDbType.NChar, 15); parm.Direction = ParameterDirection.Input; parm.Value = MinPreferedPrice; cmd.Parameters.Add(parm); parm = new SqlParameter("@maxPreferredPrice", SqlDbType.NChar, 15); parm.Direction = ParameterDirection.Input; parm.Value = MaxPreferredPrice; cmd.Parameters.Add(parm); parm = new SqlParameter("@needFinancing", SqlDbType.NChar, 5); parm.Direction = ParameterDirection.Input; parm.Value = NeedFinancing; cmd.Parameters.Add(parm); parm = new SqlParameter("@haveLiquidAsset", SqlDbType.NChar, 5); parm.Direction = ParameterDirection.Input; parm.Value = HaveLiquidAsset; cmd.Parameters.Add(parm); parm = new SqlParameter("@TimeToMoveIn", SqlDbType.NChar, 20); parm.Direction = ParameterDirection.Input; parm.Value = TimeToMoveIn; cmd.Parameters.Add(parm); parm = new SqlParameter("@arrivalDate", SqlDbType.NChar, 14); parm.Direction = ParameterDirection.Input; parm.Value = ArrivalDate; cmd.Parameters.Add(parm); parm = new SqlParameter("@deoartureDate", SqlDbType.NChar, 14); parm.Direction = ParameterDirection.Input; parm.Value = DepartureDate; cmd.Parameters.Add(parm); parm = new SqlParameter("@destination", SqlDbType.NChar, 14); parm.Direction = ParameterDirection.Input; parm.Value = Destination; cmd.Parameters.Add(parm); parm = new SqlParameter("@child1age", SqlDbType.NChar, 10); parm.Direction = ParameterDirection.Input; parm.Value = ChildAge; cmd.Parameters.Add(parm); parm = new SqlParameter("@child1Grade", SqlDbType.NChar, 10); parm.Direction = ParameterDirection.Input; parm.Value = ChildGrade; cmd.Parameters.Add(parm); parm = new SqlParameter("@groupVisiting", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = GroupVisiting; cmd.Parameters.Add(parm); parm = new SqlParameter("@summerCamp", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = SummerCamp; cmd.Parameters.Add(parm); parm = new SqlParameter("@educationalPlan", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = CollegeCounseling; cmd.Parameters.Add(parm); parm = new SqlParameter("@accountingCounsel", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = AccountingRecommending; cmd.Parameters.Add(parm); parm = new SqlParameter("@financialCounsel", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = PropertyManagement; cmd.Parameters.Add(parm); parm = new SqlParameter("@airportService", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = AirportService; cmd.Parameters.Add(parm); parm = new SqlParameter("@eb5Visa", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = Eb5Visa; cmd.Parameters.Add(parm); parm = new SqlParameter("@usOfficeCounsel", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = UsOfficeCounsel; cmd.Parameters.Add(parm); parm = new SqlParameter("@emergencyHelp", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = EmergencyHelp; cmd.Parameters.Add(parm); parm = new SqlParameter("@otherService", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = OtherService; cmd.Parameters.Add(parm); parm = new SqlParameter("@greenCardStatus", SqlDbType.NChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = GreenCardStatus; cmd.Parameters.Add(parm); parm = new SqlParameter("@firstVisitHouseTime", SqlDbType.NChar, 15); parm.Direction = ParameterDirection.Input; parm.Value = FirstVisitHouseTime; cmd.Parameters.Add(parm); parm = new SqlParameter("@detailed_information", SqlDbType.NChar, 400); parm.Direction = ParameterDirection.Input; parm.Value = ReasonsToPurchase; cmd.Parameters.Add(parm); parm = new SqlParameter("@ArrivalState", SqlDbType.NChar, 2); parm.Direction = ParameterDirection.Input; parm.Value = ArrivalState; cmd.Parameters.Add(parm); parm = new SqlParameter("@longIsland", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = LongIsland; cmd.Parameters.Add(parm); parm = new SqlParameter("@portland", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = Portland; cmd.Parameters.Add(parm); parm = new SqlParameter("@orlando", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = Orlando; cmd.Parameters.Add(parm); parm = new SqlParameter("@schoolReports", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = SchoolReports; cmd.Parameters.Add(parm); parm = new SqlParameter("@recommendedHousing", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = RecommendedHousing; cmd.Parameters.Add(parm); parm = new SqlParameter("@housingPurchaseGuide", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = HousingPurchaseGuide; cmd.Parameters.Add(parm); parm = new SqlParameter("@skillsTraining", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = SkillsTraining; cmd.Parameters.Add(parm); parm = new SqlParameter("@jobPlanning", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = JobPlanning; cmd.Parameters.Add(parm); parm = new SqlParameter("@memberActivity", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = MemberActivity; cmd.Parameters.Add(parm); parm = new SqlParameter("@accountingRecommending", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = AccountingRecommending; cmd.Parameters.Add(parm); parm = new SqlParameter("@openAcccount", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = OpenAcccount; cmd.Parameters.Add(parm); parm = new SqlParameter("@insuranceChoice", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = InsuranceChoice; cmd.Parameters.Add(parm); parm = new SqlParameter("@propertyManagement", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = PropertyManagement; cmd.Parameters.Add(parm); parm = new SqlParameter("@legalCounseling", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = LegalCounseling; cmd.Parameters.Add(parm); parm = new SqlParameter("@counselWeChat", SqlDbType.NChar, 15); parm.Direction = ParameterDirection.Input; parm.Value = CounselorWeChat; cmd.Parameters.Add(parm); parm = new SqlParameter("@counselPhone", SqlDbType.NChar, 15); parm.Direction = ParameterDirection.Input; parm.Value = CounselorPhone; cmd.Parameters.Add(parm); parm = new SqlParameter("@counselEmail", SqlDbType.NChar, 20); parm.Direction = ParameterDirection.Input; parm.Value = CounselorEmail; cmd.Parameters.Add(parm); parm = new SqlParameter("@otherCity", SqlDbType.NChar, 20); parm.Direction = ParameterDirection.Input; parm.Value = otherCity; cmd.Parameters.Add(parm); parm = new SqlParameter("@secondVisitHouseTime", SqlDbType.NChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = SecondVistiHouseTime; cmd.Parameters.Add(parm); parm = new SqlParameter("@thirdVisitHouseTime", SqlDbType.NChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = ThirdVisitHouseTime; cmd.Parameters.Add(parm); /* parm = new SqlParameter("@secondChildAge", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = SecondChildAge; cmd.Parameters.Add(parm); parm = new SqlParameter("@secondChildGrade", SqlDbType.NChar, 50); parm.Direction = ParameterDirection.Input; parm.Value = SecondChildGrade; cmd.Parameters.Add(parm); parm = new SqlParameter(" @thirdChildAge", SqlDbType.Int); parm.Direction = ParameterDirection.Input; parm.Value = ThirdChildAge; cmd.Parameters.Add(parm); parm = new SqlParameter("@thirdChildGrade", SqlDbType.NChar, 10); parm.Direction = ParameterDirection.Input; parm.Value =ThirdChildGrade; cmd.Parameters.Add(parm); */ cmd.ExecuteNonQuery(); UserId = int.Parse(cmd.Parameters["@userId"].Value.ToString()); Description d = new Description(); d.Detail = Detailed_information; d.SourceId = UserId; d.DescriptionType = 1; d.AddADescription(); } }