C# (CSharp) Models.Comment_model Examples

Example #1

        public void MyWebsite(Models.Comment_model onNewComment)
        {
            SqlCommand com = new SqlCommand("Sp_AddComment", con);

            com.CommandType = CommandType.StoredProcedure;
            com.Parameters.AddWithValue("@Name", onNewComment.Name);
            com.Parameters.AddWithValue("@Email", onNewComment.Email);
            com.Parameters.AddWithValue("@Date", onNewComment.Date);
            com.Parameters.AddWithValue("@Message", onNewComment.Message);
            con.Open();
            com.ExecuteNonQuery();
            con.Close();
        }

Example #2

        public void Update_Comment(Models.Comment_model onNewComment)
        {
            SqlCommand com = new SqlCommand("Sp_UpdateComment", con);

            com.CommandType = CommandType.StoredProcedure;
            com.Parameters.AddWithValue("@CommentId", onNewComment.CommentId);
            com.Parameters.AddWithValue("@Name", onNewComment.Name);
            com.Parameters.AddWithValue("@Email", onNewComment.Email);

            com.Parameters.AddWithValue("@Comment", onNewComment.Message);
            con.Open();
            com.ExecuteNonQuery();
            con.Close();
        }