public string InsertProfileVisitor(string conn, ProfileVisitor profileVisitor) { string msg = string.Empty; SqlHelper sqlHelper = new SqlHelper(conn); var para = new DynamicParameters(); var outPut = new DynamicParameters(); try { para.Add("@UserEmailId", profileVisitor.EmailId); para.Add("@VisitorEmailID", profileVisitor.VisitorEmailID); } catch (Exception exp) { msg = "Error :" + exp.Message; } try { sqlHelper.ExecuteSp("InsertVisitorDetails", para, null, true, null); msg = "Successfully Inserted Data."; } catch (Exception exp) { msg = "Error :" + exp.Message; } //int valueout = para.Get<int>("@outresult"); return(msg); }
// POST: api/VisitorDetails public string Post(ProfileVisitor value) { var data = value; string con = ConfigurationManager.ConnectionStrings["SqlServerConnString"].ConnectionString; CRUD repository = new CRUD(); return(repository.InsertProfileVisitor(con, data)); }