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