示例#1
0
        public string DeletePic(string conn, UpdateUserPics userPics)
        {
            string    msg       = string.Empty;
            SqlHelper sqlHelper = new SqlHelper(conn);
            var       para      = new DynamicParameters();
            var       outPut    = new DynamicParameters();

            try
            {
                para.Add("@PicID", userPics.PicId);
            }
            catch (Exception exp)
            {
                msg = "Error :" + exp.Message;
            }
            try
            {
                var result = sqlHelper.ExecuteSpReturnMessage("DeleteUserPic", para, null, true, null);
                msg = "Successfully Update Profile Pic.";
            }
            catch (Exception exp)
            {
                msg = "Error :" + exp.Message;
            }
            //int valueout = para.Get<int>("@outresult");
            return(msg);
        }
示例#2
0
        public string UpdateProfilePic(UpdateUserPics userPics)
        {
            var              data       = userPics;
            string           con        = ConfigurationManager.ConnectionStrings["SqlServerConnString"].ConnectionString;
            Crud_UserProfile repository = new Crud_UserProfile();

            return(repository.UpdateProfilePic(con, data));
            //InsertUserProfilePics
        }