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();
}
}
