public string InsertUserProfile(string conn, RegistrationModel registrationModel) { string msg = string.Empty; SqlHelper sqlHelper = new SqlHelper(conn); var para = new DynamicParameters(); var outPut = new DynamicParameters(); try { string dt = registrationModel.dob.formatted; para.Add("@PROFILE_CREATED_BY", registrationModel.profileCreateBy); para.Add("@F_NAME", registrationModel.firstName); para.Add("@L_NAME", registrationModel.lastName); para.Add("@COUNTRY_ID", registrationModel.country); para.Add("@CITY_ID", registrationModel.city); para.Add("@ADDRESS", registrationModel.address); para.Add("@E_MAIL", registrationModel.email); para.Add("@PASSWORD", registrationModel.password); para.Add("@DOB", dt);// registrationModel.dob.date ); para.Add("@TIME", registrationModel.time.hh + ":" + registrationModel.time.min + ":" + registrationModel.time.sec); para.Add("@Placeofbirth", registrationModel.birthplace); para.Add("@MY_RELIGION", registrationModel.religion); para.Add("@MY_MOTHER_TOUNG", registrationModel.mothertounge); para.Add("@MY_SUB_CASTE", registrationModel.mySubCaste); para.Add("@MY_RASHI", registrationModel.rashi); para.Add("@MY_GOTHRA", registrationModel.gotra); para.Add("@MY_NATIVE_PLACE", registrationModel.nativeplace); para.Add("@PHONE_NO1", registrationModel.landline); para.Add("@PHONE_NO2", registrationModel.landline); para.Add("@MOBILE_NO1", registrationModel.mobile); para.Add("@MARITIAL_STATUS", registrationModel.maritalstatus); para.Add("@ABOUT_ME", registrationModel.about); para.Add("@ABOUT_MY_EDUCATION", registrationModel.education); para.Add("@ABOUT_MY_PROFESSION", registrationModel.profession); para.Add("@MY_HIGHEST_DEGREE", registrationModel.education); para.Add("@MY_MIN_INCOME", registrationModel.incomerange); para.Add("@MY_MAX_INCOME", registrationModel.incomerange); para.Add("@MY_WORK_STATUS", registrationModel.workstatus); para.Add("@DIET_STATUS", registrationModel.dietstatus); para.Add("@SMOKE_STATUS", registrationModel.smokestatus); para.Add("@DRINK_STATUS", registrationModel.drinkstatus); para.Add("@HEIGHT", registrationModel.height); para.Add("@WEIGHT", registrationModel.weight); para.Add("@UPDATE_PROFILE_ID", ""); para.Add("@CREATED_BY", ""); para.Add("@MODIFIED_BY", ""); para.Add("@STATUS", 1); para.Add("@GENDER", registrationModel.gender); para.Add("@FACEBOOK_ID", registrationModel.myFacebookId); para.Add("@TWITTER_ID", registrationModel.myTwitterId); para.Add("@LINKEDIN_ID", registrationModel.mylinkedinId); var json = new JavaScriptSerializer().Serialize(registrationModel); para.Add("@JSONObject", ""); } catch (Exception exp) { msg = "Error :" + exp.Message; } try { sqlHelper.ExecuteSp("InsertProfile", para, null, true, null); msg = "Successfully Inserted Data."; } catch (Exception exp) { msg = "Error :" + exp.Message; } //int valueout = para.Get<int>("@outresult"); return(msg); }