Esempio n. 1
0
        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));
        }